If you try to migrate the back-end storage for a Tenant and its background tasks fail with a truncation error, you can try to implement the suggestions from this article to get the tasks to go through.
The solution presented in this article will only work if the destination is a cloud provider or file system (that accepts more than 255 character paths), and applies specifically to the following the migration task error:
"Task Failed:Unhandled exception:String or binary data would be truncated. The statement has been terminated."
This problem is caused by long paths that exceed the database's maximum allowed length. At the time of this writing, the maximum length for migration task paths is 300 characters, so if you get the truncation error described above, the solution is to increase the length of the database columns.
If you have the default installation of CentreStack, the database is a MySQL instance installed on the C:\CSDBRoot folder. Use Oracle's free MySQL Workbench to modify the csmain database -> xaf_SubTasks table. For authentication, look at the initfile in the conf sub-directory with a text editor, such as notepad. The default column length is 300 nvarchar, so you could simply increase the TaskPara1, TaskPara2, and TaskPara3 column lengths to 1000, save the tables, and then retry the tasks from the web portal.
If you have an MSSQL database (either Express or Standard), the database can be easily modified with the free MSSQL Management Studio from Microsoft. Simply connect to the database using windows authentication and modify the "user" database.
Increase the lengths of the same TaskPara1, TaskPara2, and TaskPara3 columns described above to any arbitrary larger number, such as 1000. Save the tables and retry the tasks. If you get an error that says the table needs to be dropped and re-created, go to MSSQL -> Tools -> Options -> Designers. Uncheck the property that says "prevent saving changes that require table re-creation"
After you save the changes, you should be able to save the column modifications as well.
If you continue to experience issues, please create a support ticket by sending an email to support@gladinet.com.
Comments
0 comments
Article is closed for comments.