Violation of UNIQUE KEY constraint 'SoftwareList_ UK1'. Cannot insert duplicate key in object 'dbo.SoftwareList'
Help,
when restoring a backup I get the following error, and change with the next line registration restoreData.bat:
Dsdp.restore.error.ignoretables=softwarelist com.adventnet.servicedesk.tools.RestoreDialog
C:\ManageEngine\ServiceDesk\bin>restoreData.bat
********************************************************************************
*
Restore DB Setup Wizard
********************************************************************************
*
Execute Restore DB Utility from command prompt
For Windows users :
bin>restoreData -c [backup file]
For Linux users :
bin]#sh restoreData.sh -c [backup file]
********************************************************************************
*
01-07-2016 06:43:09 PM com.adventnet.servicedesk.server.utils.SDDataManager setS
tandAlone
INFO: Going to set the standAlone param as : true
01-07-2016 06:43:09 PM com.adventnet.servicedesk.server.utils.SDDataManager setS
tandAlone
INFO: Going to reset rootDir using server.dir
01-07-2016 06:43:11 PM com.adventnet.servicedesk.server.utils.SDDataManager <ini
t>
INFO: rootDir :: .
01-07-2016 06:43:11 PM com.adventnet.servicedesk.server.utils.SDDataManager <ini
t>
INFO: netutilsData :: {RELEASE={version=9.1}, BUILD={number=9100}}
01-07-2016 06:43:11 PM com.adventnet.servicedesk.server.utils.SDDataManager <ini
t>
INFO: rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=O
pManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManag
er Plus}}
You chose to open this file: C:\ManageEngine\ServiceDesk\backup\backup_mssql_910
0_fullbackup_06_25_2016_10_45\backup_mssql_9100_fullbackup_06_25_2016_10_45_part
_1.data
File name is : C:\ManageEngine\ServiceDesk\backup\backup_mssql_9100_fullbackup_
06_25_2016_10_45\backup_mssql_9100_fullbackup_06_25_2016_10_45_part_1.data
01-07-2016 06:43:22 PM com.adventnet.servicedesk.server.utils.SDDataManager setS
tandAlone
INFO: Going to set the standAlone param as : true
01-07-2016 06:43:22 PM com.adventnet.servicedesk.server.utils.SDDataManager setS
tandAlone
INFO: Going to reset rootDir using server.dir
01-07-2016 06:43:22 PM com.adventnet.servicedesk.server.utils.SDDataManager <ini
t>
INFO: rootDir :: .
01-07-2016 06:43:22 PM com.adventnet.servicedesk.server.utils.SDDataManager <ini
t>
INFO: netutilsData :: {RELEASE={version=9.1}, BUILD={number=9100}}
01-07-2016 06:43:22 PM com.adventnet.servicedesk.server.utils.SDDataManager <ini
t>
INFO: rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=O
pManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManag
er Plus}}
Extracting backup file....
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
*************************************************************.\backup_info.xml
Backpup data : Sat Jun 25 10:45:01 GMT-04:00 2016
Database name : servicedesk
Total Tables : 1397
Database Server : mssql
Build Number : 9100
*************************************************************
01-07-2016 06:48:45 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Entering changeDocType
01-07-2016 06:48:45 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: publicChanged :: false
01-07-2016 06:48:45 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: written the file :: [server\default\conf\datasource-configuration.xml_tmp]
01-07-2016 06:48:45 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Finally publicChanged :: false
01-07-2016 06:48:45 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: public ID not there in datasource-configuration.xml
01-07-2016 06:48:45 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Exiting changeDocType
01-07-2016 06:48:46 PM com.adventnet.updatemgr.util.ConfUtils parseXML
INFO: extractLocation : file:/C:/ManageEngine/ServiceDesk/applications/extracted
/
01-07-2016 06:48:46 PM com.adventnet.updatemgr.util.ConfUtils parseXML
INFO: startDBServer :: [true]
01-07-2016 06:48:46 PM com.adventnet.updatemgr.util.ConfUtils parseXML
INFO: jndiName :: [MSSQLDS]
01-07-2016 06:48:46 PM com.adventnet.updatemgr.util.ConfUtils parseXML
INFO: setdbhomearg set in mappings.xml :: [null]
01-07-2016 06:48:46 PM com.adventnet.updatemgr.util.ConfUtils parseXML
INFO: Final setdbhomearg :: [false]
01-07-2016 06:48:46 PM com.adventnet.updatemgr.util.ConfUtils parseXML
INFO: properties sent to adapter initialization :: {jndiname=MSSQLDS, name=mssql
, setdbhomearg=false, sqlgenerator=com.adventnet.db.adapter.mssql.MssqlSQLGenera
tor}
01-07-2016 06:48:46 PM com.adventnet.updatemgr.util.ConfUtils parseXML
INFO: db.home :: [C:\ManageEngine\ServiceDesk\bin\\..\pgsql] finally
01-07-2016 06:48:48 PM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: connectionProperties :: [null]
01-07-2016 06:48:48 PM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: url :: [jdbc:jtds:sqlserver://localhost:1433;DatabaseName=servicedesk;Tds=
8.0;PrepareSql=3;XaEmulation=false;]
01-07-2016 06:48:48 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: AUTO_QUOTE_IDENTIFIER value : false
01-07-2016 06:48:48 PM com.adventnet.db.adapter.Jdbc20DBAdapter getListFromIdent
ifierFile
ADVERTENCIA: AUTO_QUOTE_IDENTIFIERS not supported for this DB...
Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.mssql.Ms
sqlSQLGenerator javax.naming.NoInitialContextException: Need to specify class na
me in environment or system property, or as an applet parameter, or in an applic
ation resource file: java.naming.factory.initial
01-07-2016 06:48:48 PM com.adventnet.db.adapter.Jdbc20DBAdapter setUpDB
GRAVE: Start DBServer operation is not supported
01-07-2016 06:48:48 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleCo
llation
INFO: Incoming collation string is Modern_Spanish_CI_AS
01-07-2016 06:48:48 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleCo
llation
INFO: Collation String constructed is Modern_Spanish_CS_A%
01-07-2016 06:48:48 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleCo
llation
INFO: The Toggle collation string is Modern_Spanish_CS_AI
Active DB Server = mssql
Database connectionProp : null
Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.SQLGener
ator java.lang.InstantiationException: com.adventnet.db.adapter.SQLGenerator
Database started
Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
====================================================
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
Please wait ! Restoring in Progress...................
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
=======================QUERY = INSERT INTO SoftwareList (SOFTWAREID,SOFTWARENAME
,SWMANUFACTURERID,FILEVERSION,PRODUCTNAME,PRODUCTVERSION,COMPANYNAME,SOFTWARETYP
EID,SOFTWARECATEGORYID,CURRENTLYMETERED,DESCRIPTION,CITYPEID) VALUES(12006, N'Sk
ypeÔäó 5.8', 421, N'-', N'-', N'-', N'-', 2, 9, '0', NULL, 14);
java.sql.BatchUpdateException: Violation of UNIQUE KEY constraint 'SoftwareList_
UK1'. Cannot insert duplicate key in object 'dbo.SoftwareList'. The duplicate ke
y value is (cellSens Standard - C:\Archivos de programa\cellSens Standard).
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.ja
va:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:755)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:343)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:135)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:188)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : Violation of UNIQUE KEY constraint 'SoftwareList_UK
1'. Cannot insert duplicate key in object 'dbo.SoftwareList'. The duplicate key
value is (cellSens Standard - C:\Archivos de programa\cellSens Standard).
Violation of UNIQUE KEY constraint 'SoftwareList_UK1'. Cannot insert duplicate k
ey in object 'dbo.SoftwareList'. The duplicate key value is (cellSens Standard -
C:\Archivos de programa\cellSens Standard).
01-07-2016 06:57:40 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: dbadapter :: [com.adventnet.db.adapter.mssql.MssqlDBAdapter@7ad2f417], sta
rtDBServer :: [true]
01-07-2016 06:57:40 PM com.adventnet.db.adapter.Jdbc20DBAdapter shutDownDBForceF
ully
GRAVE: Stop DBServer operation is not supported in Jdbc20DBAdapter
01-07-2016 06:57:40 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: waitAfterDBStop :: val :: [5]
01-07-2016 06:57:40 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Thread is going to sleep for [5] seconds
01-07-2016 06:57:45 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Coming out of stopDB