Dear all ,
I was setup services desk plus Version : 7.5.0 Build 7509 , i first time i was setup to database MYSQL , and now i backup full data and setup new services desk with MYSQL server 2005 but i can't restore , with error :
Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
===============================================QUERY = INSERT INTO wordmap (APPL
ICATIONID,WORD) VALUES(1, N'/> </imagedata');
java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'WM_PK'. Cann
ot insert duplicate key in object 'dbo.wordmap'.
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:311)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:141)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:91)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:184)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : Violation of PRIMARY KEY constraint 'WM_PK'. Cannot
insert duplicate key in object 'dbo.wordmap'.
How do i fix it ? Thanks alot of !