Restore SDP backup failed

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:

  1. 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?