Failed migration to MS SQL Server
We have ServiceDesk Plus installed using the distributed MySQL server on build 7018.
I have the valid back up from this server. I have tested restoring with a new installation from MySQL to SQL Server with no issues, but when trying to restore with the live backup data I get the following error at around 80-85% complete
Any ideas what could be causing this as we need to get this switched over.
I have the valid back up from this server. I have tested restoring with a new installation from MySQL to SQL Server with no issues, but when trying to restore with the live backup data I get the following error at around 80-85% complete
Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
=============================================QUERY = INSERT INTO task_input (INS
TANCE_ID,SCHEDULE_ID,WORKFLOW_TEMPLATE_ID,SCHEDULE_TIME,EXECUTION_START_TIME,EXE
CUTION_FINISH_TIME,WORKENGINE_ID,ADMIN_STATUS,OPERATIONAL_STATUS,SERVER_ID,CRID)
VALUESnull
java.sql.BatchUpdateException: Data truncation
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:384)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:124)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:84)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:184)
at java.lang.Thread.run(Unknown Source)
java.sql.BatchUpdateException: Data truncation
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:384)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:124)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:84)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:184)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : Data truncation
Any ideas what could be causing this as we need to get this switched over.