Restore SDP backup failed
Hi,
I'm using SDP v11.1.22 on MS SQL 2019. When I want to restore SDP backup in pre-producation server, show me this error:
- Error Tables : wordmap,wordoccurrences,errorlog
0-----------------------50------------------------100(%)
===================Reason For failure: The INSERT statement conflicted with the FOREIGN KEY constraint "WmiSWUsageInfo_FK1". The conflict occurred in database "servicedeskplus11", table "dbo.SoftwareInfo", column 'SOFTWAREINFOID'.
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:226)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1051)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:3331)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:3000)
at com.adventnet.servicedesk.tools.RestoreSDBackup.close_symmetrickey(RestoreSDBackup.java:1862)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:1014)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:516)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:143)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:188)
at java.lang.Thread.run(Thread.java:748)
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:226)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1051)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:3331)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:3000)
at com.adventnet.servicedesk.tools.RestoreSDBackup.close_symmetrickey(RestoreSDBackup.java:1862)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:1014)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:516)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:143)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:188)
at java.lang.Thread.run(Thread.java:748)
java.sql.BatchUpdateException: The INSERT statement conflicted with the FOREIGN KEY constraint "WmiSWUsageInfo_FK1". The conflict occurred in database "servicedeskplus11", table "dbo.SoftwareInfo", column 'SOFTWAREINFOID'.
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeBatch(SQLServerStatement.java:1816)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:971)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:516)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:143)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:188)
at java.lang.Thread.run(Thread.java:748)
Unable to restore database : The INSERT statement conflicted with the FOREIGN KEY constraint "WmiSWUsageInfo_FK1". The conflict occurred in database "servicedeskplus11", table "dbo.SoftwareInfo", column 'SOFTWAREINFOID'.
The INSERT statement conflicted with the FOREIGN KEY constraint "WmiSWUsageInfo_FK1". The conflict occurred in database "servicedeskplus11", table "dbo.SoftwareInfo", column 'SOFTWAREINFOID'.
Time Taken: 2 min 46 seconds
stopping DB Server >>>>> true
java.lang.String cannot be cast to java.lang.Integer
In my per-production server, MS SQL 2014 installed. What should I do? Why this problem occurs?
Thanks for helping
New to ADSelfService Plus?