SDP 8214: postgre 2 MSSQL restore failed
Dear colleagues,
Due to postgre's real misbehaving i'm trying to convert our working evaluation DB to MSSQL.... and i failed in strange way... Can anybody suggest something? I expect this is due to localized naming chars in the DB... still it's only a guess..
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]
*********************************************************************************
Dec 27, 2013 9:56:31 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to set the standAlone param as : true
Dec 27, 2013 9:56:31 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to reset rootDir using server.dir
Dec 27, 2013 9:56:33 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: .
Dec 27, 2013 9:56:33 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=8.2.0}, BUILD={number=8214}}
Dec 27, 2013 9:56:33 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManager}}
You chose to open this file: C:\ManageEngine\ServiceDesk\backup\backup_postgres_8214_fullbackup_12_27_2013_15_06.data
File name is : C:\ManageEngine\ServiceDesk\backup\backup_postgres_8214_fullbackup_12_27_2013_15_06.data
Dec 27, 2013 9:56:39 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to set the standAlone param as : true
Dec 27, 2013 9:56:39 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to reset rootDir using server.dir
Dec 27, 2013 9:56:39 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: .
Dec 27, 2013 9:56:39 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=8.2.0}, BUILD={number=8214}}
Dec 27, 2013 9:56:39 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManager}}
Extracting backup file....
Please wait extracting backup file
*************************************************************.\backup_info.xml
Backpup data : Fri Dec 27 15:06:38 YEKT 2013
Database name : servicedesk
Total Tables : 1225
Database Server : postgres
Build Number : 8214
*************************************************************
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Entering changeDocType
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: publicChanged :: false
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: written the file :: [server\default\conf\datasource-configuration.xml_tmp]
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Finally publicChanged :: false
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: public ID not there in datasource-configuration.xml
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Exiting changeDocType
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: extractLocation : file:/C:/ManageEngine/ServiceDesk/applications/extracted/
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: startDBServer :: [true]
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: jndiName :: [MSSQLDS]
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: setdbhomearg set in mappings.xml :: [null]
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: Final setdbhomearg :: [false]
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: properties sent to adapter initialization :: {jndiname=MSSQLDS, name=mssql, setdbhomearg=false, sqlgenerator=com.adventnet.d
b.adapter.mssql.MssqlSQLGenerator}
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: db.home :: [C:\ManageEngine\ServiceDesk\bin\\..\pgsql] finally
Dec 27, 2013 9:57:08 PM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: connectionProperties :: [null]
Dec 27, 2013 9:57:08 PM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: url :: [jdbc:jtds:sqlserver://localhost:1433;DatabaseName=servicedesk;Tds=8.0;PrepareSql=3;XaEmulation=false;]
Dec 27, 2013 9:57:08 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: AUTO_QUOTE_IDENTIFIER value : false
Dec 27, 2013 9:57:08 PM com.adventnet.db.adapter.Jdbc20DBAdapter getListFromIdentifierFile
WARNING: AUTO_QUOTE_IDENTIFIERS not supported for this DB...
Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.mssql.MssqlSQLGenerator javax.naming.NoInitialContextExcep
tion: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:
java.naming.factory.initial
Dec 27, 2013 9:57:08 PM com.adventnet.db.adapter.Jdbc20DBAdapter setUpDB
SEVERE: Start DBServer operation is not supported
Active DB Server = mssql
Database connectionProp : null
Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.SQLGenerator java.lang.InstantiationException: com.adventn
et.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 DepartmentDefinition (deptid,deptname,deptheadid,phoneno,fax,siteid,deptdesc,isdeleted,ciid
) VALUESnull
java.sql.BatchUpdateException: Violation of UNIQUE KEY constraint 'DepartmentDefinition_UK'. Cannot insert duplicate key in object
'dbo.DepartmentDefinition'. The duplicate key value is (ПТО, <NULL>).
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:694)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:296)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:141)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:186)
at java.lang.Thread.run(Unknown Source)
java.sql.BatchUpdateException: Violation of UNIQUE KEY constraint 'DepartmentDefinition_UK'. Cannot insert duplicate key in object
'dbo.DepartmentDefinition'. The duplicate key value is (ПТО, <NULL>).
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:694)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:296)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:141)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:186)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : Violation of UNIQUE KEY constraint 'DepartmentDefinition_UK'. Cannot insert duplicate key in object '
dbo.DepartmentDefinition'. The duplicate key value is (ПТО, <NULL>).
Violation of UNIQUE KEY constraint 'DepartmentDefinition_UK'. Cannot insert duplicate key in object 'dbo.DepartmentDefinition'. Th
e duplicate key value is (ПТО, <NULL>).
Dec 27, 2013 9:57:43 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: dbadapter :: [com.adventnet.db.adapter.mssql.MssqlDBAdapter@27af8502], startDBServer :: [true], dbProp :: {BlockingTimeoutMi
llis=30000, ManagedConnectionFactoryProperties=
, Criteria=ByContainer, LocalTransactions=true, MinSize=0, Password=*****, JndiName=MSSQLDS, MaxSize=20, SecurityDomainJndiNam
e=DBPwdEncrypt, DriverClass=net.sourceforge.jtds.jdbc.Driver, TrackConnectionByTx=true, IdleTimeoutMinutes=15, UserName=sa, Connec
tionURL=jdbc:jtds:sqlserver://localhost:1433;DatabaseName=servicedesk;Tds=8.0;PrepareSql=3;XaEmulation=false;}
Dec 27, 2013 9:57:43 PM com.adventnet.db.adapter.Jdbc20DBAdapter shutDownDBForceFully
SEVERE: Stop DBServer operation is not supported in Jdbc20DBAdapter
Dec 27, 2013 9:57:43 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: waitAfterDBStop :: val :: [5]
Dec 27, 2013 9:57:43 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Thread is going to sleep for [5] seconds
Dec 27, 2013 9:57:48 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Coming out of stopDB
C:\ManageEngine\ServiceDesk\bin>
Due to postgre's real misbehaving i'm trying to convert our working evaluation DB to MSSQL.... and i failed in strange way... Can anybody suggest something? I expect this is due to localized naming chars in the DB... still it's only a guess..
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]
*********************************************************************************
Dec 27, 2013 9:56:31 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to set the standAlone param as : true
Dec 27, 2013 9:56:31 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to reset rootDir using server.dir
Dec 27, 2013 9:56:33 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: .
Dec 27, 2013 9:56:33 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=8.2.0}, BUILD={number=8214}}
Dec 27, 2013 9:56:33 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManager}}
You chose to open this file: C:\ManageEngine\ServiceDesk\backup\backup_postgres_8214_fullbackup_12_27_2013_15_06.data
File name is : C:\ManageEngine\ServiceDesk\backup\backup_postgres_8214_fullbackup_12_27_2013_15_06.data
Dec 27, 2013 9:56:39 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to set the standAlone param as : true
Dec 27, 2013 9:56:39 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to reset rootDir using server.dir
Dec 27, 2013 9:56:39 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: .
Dec 27, 2013 9:56:39 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=8.2.0}, BUILD={number=8214}}
Dec 27, 2013 9:56:39 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManager}}
Extracting backup file....
Please wait extracting backup file
*************************************************************.\backup_info.xml
Backpup data : Fri Dec 27 15:06:38 YEKT 2013
Database name : servicedesk
Total Tables : 1225
Database Server : postgres
Build Number : 8214
*************************************************************
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Entering changeDocType
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: publicChanged :: false
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: written the file :: [server\default\conf\datasource-configuration.xml_tmp]
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Finally publicChanged :: false
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: public ID not there in datasource-configuration.xml
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Exiting changeDocType
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: extractLocation : file:/C:/ManageEngine/ServiceDesk/applications/extracted/
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: startDBServer :: [true]
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: jndiName :: [MSSQLDS]
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: setdbhomearg set in mappings.xml :: [null]
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: Final setdbhomearg :: [false]
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: properties sent to adapter initialization :: {jndiname=MSSQLDS, name=mssql, setdbhomearg=false, sqlgenerator=com.adventnet.d
b.adapter.mssql.MssqlSQLGenerator}
Dec 27, 2013 9:57:07 PM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInstantiateDB
INFO: db.home :: [C:\ManageEngine\ServiceDesk\bin\\..\pgsql] finally
Dec 27, 2013 9:57:08 PM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: connectionProperties :: [null]
Dec 27, 2013 9:57:08 PM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: url :: [jdbc:jtds:sqlserver://localhost:1433;DatabaseName=servicedesk;Tds=8.0;PrepareSql=3;XaEmulation=false;]
Dec 27, 2013 9:57:08 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: AUTO_QUOTE_IDENTIFIER value : false
Dec 27, 2013 9:57:08 PM com.adventnet.db.adapter.Jdbc20DBAdapter getListFromIdentifierFile
WARNING: AUTO_QUOTE_IDENTIFIERS not supported for this DB...
Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.mssql.MssqlSQLGenerator javax.naming.NoInitialContextExcep
tion: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:
java.naming.factory.initial
Dec 27, 2013 9:57:08 PM com.adventnet.db.adapter.Jdbc20DBAdapter setUpDB
SEVERE: Start DBServer operation is not supported
Active DB Server = mssql
Database connectionProp : null
Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.SQLGenerator java.lang.InstantiationException: com.adventn
et.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 DepartmentDefinition (deptid,deptname,deptheadid,phoneno,fax,siteid,deptdesc,isdeleted,ciid
) VALUESnull
java.sql.BatchUpdateException: Violation of UNIQUE KEY constraint 'DepartmentDefinition_UK'. Cannot insert duplicate key in object
'dbo.DepartmentDefinition'. The duplicate key value is (ПТО, <NULL>).
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:694)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:296)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:141)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:186)
at java.lang.Thread.run(Unknown Source)
java.sql.BatchUpdateException: Violation of UNIQUE KEY constraint 'DepartmentDefinition_UK'. Cannot insert duplicate key in object
'dbo.DepartmentDefinition'. The duplicate key value is (ПТО, <NULL>).
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:694)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:296)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:141)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:186)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : Violation of UNIQUE KEY constraint 'DepartmentDefinition_UK'. Cannot insert duplicate key in object '
dbo.DepartmentDefinition'. The duplicate key value is (ПТО, <NULL>).
Violation of UNIQUE KEY constraint 'DepartmentDefinition_UK'. Cannot insert duplicate key in object 'dbo.DepartmentDefinition'. Th
e duplicate key value is (ПТО, <NULL>).
Dec 27, 2013 9:57:43 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: dbadapter :: [com.adventnet.db.adapter.mssql.MssqlDBAdapter@27af8502], startDBServer :: [true], dbProp :: {BlockingTimeoutMi
llis=30000, ManagedConnectionFactoryProperties=
, Criteria=ByContainer, LocalTransactions=true, MinSize=0, Password=*****, JndiName=MSSQLDS, MaxSize=20, SecurityDomainJndiNam
e=DBPwdEncrypt, DriverClass=net.sourceforge.jtds.jdbc.Driver, TrackConnectionByTx=true, IdleTimeoutMinutes=15, UserName=sa, Connec
tionURL=jdbc:jtds:sqlserver://localhost:1433;DatabaseName=servicedesk;Tds=8.0;PrepareSql=3;XaEmulation=false;}
Dec 27, 2013 9:57:43 PM com.adventnet.db.adapter.Jdbc20DBAdapter shutDownDBForceFully
SEVERE: Stop DBServer operation is not supported in Jdbc20DBAdapter
Dec 27, 2013 9:57:43 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: waitAfterDBStop :: val :: [5]
Dec 27, 2013 9:57:43 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Thread is going to sleep for [5] seconds
Dec 27, 2013 9:57:48 PM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Coming out of stopDB
C:\ManageEngine\ServiceDesk\bin>