Trouble with "database move" from MySQL to SQL Ser

Posted by Rollbase User on 02-Jul-2013 12:29

In a rollbase 4.05 private cloud installation, we are trying to use the "database move" option to move a customer zone/tenant from a mySQL database to a SQL Server database. The error we are getting in backup.log is: java.lang.Exception: Error copying table RB_FIELD_DEF: String or binary data would be truncated. INSERT INTO RB_FIELD_DEF (CUST_ID, FIELD_ID, ORIGINAL_ID, OBJ_DEF_ID, COLUMN_NAME, FIELD_NAME, GROUP_NAME, DATA_CLASS_NAME, IS_REQUIRED, IS_READ_ONLY, IS_TEXT_INDEXABLE, IS_SYSTEM, IS_AUDITABLE, HAS_PERMISSIONS, DISPLAY_LABEL, MAX_LENGTH, DESCRIPTION, UI_CLASS_NAME, PROPERTIES, SCRIPT_VALIDATION, CREATED_BY, CREATED_AT, UPDATED_BY, UPDATED_AT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) at p25.a351.copyTable(a351.java:236) at p25.a351.doJob(a351.java:79) at com.rb.util.system.a475.run(a475.java:58) Does anyone have any experience with this or have seen this before?

All Replies

Posted by Admin on 15-Jul-2013 13:20

Hi Ben,



Tracking this issue with support case # 72441220



Thank You,

Srikanth

Progress|Rollbase Product Support Team

This thread is closed