Greetings.
At me a problem (I use version SD + 8015).
If I want to use as database MS SQL - at restoration SD + from archive, there is such error.
========================================================= 23:14
Error occured while deletion of all table
data please see the error log
Please wait ! Restoring in Progress...................
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
==================QUERY = INSERT INTO configurationrecord (CRID,CRTYPE,SCOPE,SEG
MENTATIONTYPE,AVAILABLE) VALUES(1537, N'ClientComponentsCI', N'GLOBAL', NULL, 0)
;
java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'Configuratio
nRecord_PK'. Cannot insert duplicate key in object 'dbo.configurationrecord'.
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:402)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:142)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:90)
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 'ConfigurationR
ecord_PK'. Cannot insert duplicate key in object 'dbo.configurationrecord'.
I select * from configurationrecord and table configurationrecord not have more CRID<=9.
Why there is such error and what it is necessary to do that it to correct?
If to use MySQL - such error isn't present.
I ask to help.