Hello:

 

I am trying to restore or production MSSQL database (build 9035) to our test MSSQL database (build 9035) - to prepare for an upgrade.  It appears I am getting a SQL statement error, like it is terminating the statement because of length. 

I get among other errors:  Invalid SQL statement or JDBC escape, terminating ''' not  found.

 

 

D:\ManageEngine\ServiceDesk\bin>restoredata.bat/sh
********************************************************************************
*
                         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]

********************************************************************************
*
Mar 17, 2016 11:32:16 AM com.adventnet.servicedesk.server.utils.SDDataManager se
tStandAlone
INFO: Going to set the standAlone param as : true
Mar 17, 2016 11:32:16 AM com.adventnet.servicedesk.server.utils.SDDataManager se
tStandAlone
INFO: Going to reset rootDir using server.dir
Mar 17, 2016 11:32:26 AM com.adventnet.servicedesk.server.utils.SDDataManager <i
nit>
INFO: rootDir :: .
Mar 17, 2016 11:32:26 AM com.adventnet.servicedesk.server.utils.SDDataManager <i
nit>
INFO: netutilsData :: {RELEASE={version=9.0}, BUILD={number=9035}}
Mar 17, 2016 11:32:26 AM com.adventnet.servicedesk.server.utils.SDDataManager <i
nit>
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: D:\ManageEngine\ServiceDesk\backup\backup_mssql_903
5_database_02_18_2016_18_01\backup_mssql_9035_database_02_18_2016_18_01_part_1.d
ata
File name is :  D:\ManageEngine\ServiceDesk\backup\backup_mssql_9035_database_02
_18_2016_18_01\backup_mssql_9035_database_02_18_2016_18_01_part_1.data
Mar 17, 2016 11:33:33 AM com.adventnet.servicedesk.server.utils.SDDataManager se
tStandAlone
INFO: Going to set the standAlone param as : true
Mar 17, 2016 11:33:33 AM com.adventnet.servicedesk.server.utils.SDDataManager se
tStandAlone
INFO: Going to reset rootDir using server.dir
Mar 17, 2016 11:33:33 AM com.adventnet.servicedesk.server.utils.SDDataManager <i
nit>
INFO: rootDir :: .
Mar 17, 2016 11:33:33 AM com.adventnet.servicedesk.server.utils.SDDataManager <i
nit>
INFO: netutilsData :: {RELEASE={version=9.0}, BUILD={number=9035}}
Mar 17, 2016 11:33:33 AM com.adventnet.servicedesk.server.utils.SDDataManager <i
nit>
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

*************************************************************.\backup_info.xml
         Backpup data    : Thu Feb 18 18:01:56 EST 2016
         Database name   : servicedesk
         Total Tables    : 1315
         Database Server : mssql
         Build Number    : 9035
*************************************************************

Mar 17, 2016 11:36:14 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Entering changeDocType
Mar 17, 2016 11:36:14 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: publicChanged :: false
Mar 17, 2016 11:36:14 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: written the file :: [server\default\conf\datasource-configuration.xml_tmp]

Mar 17, 2016 11:36:14 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Finally publicChanged :: false
Mar 17, 2016 11:36:14 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: public ID not there in datasource-configuration.xml
Mar 17, 2016 11:36:14 AM com.adventnet.updatemgr.util.ConfUtils changeDocType
INFO: Exiting changeDocType
Mar 17, 2016 11:36:14 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInsta
ntiateDB
INFO: extractLocation : file:/D:/ManageEngine/ServiceDesk/applications/extracted
/
Mar 17, 2016 11:36:14 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInsta
ntiateDB
INFO: startDBServer :: [true]
Mar 17, 2016 11:36:14 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInsta
ntiateDB
INFO: jndiName :: [MSSQLDS]
Mar 17, 2016 11:36:14 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInsta
ntiateDB
INFO: setdbhomearg set in mappings.xml :: [null]
Mar 17, 2016 11:36:14 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInsta
ntiateDB
INFO: Final setdbhomearg :: [false]
Mar 17, 2016 11:36:14 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInsta
ntiateDB
INFO: properties sent to adapter initialization :: {jndiname=MSSQLDS, name=mssql
, setdbhomearg=false, sqlgenerator=com.adventnet.db.adapter.mssql.MssqlSQLGenera
tor}
Mar 17, 2016 11:36:14 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInsta
ntiateDB
INFO: db.home :: [D:\ManageEngine\ServiceDesk\bin\\..\pgsql] finally
Mar 17, 2016 11:36:15 AM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: connectionProperties :: [null]
Mar 17, 2016 11:36:15 AM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: url :: [jdbc:jtds:sqlserver://VCOBSQLDEV:1433;DatabaseName=servicedesk;Tds
=8.0;PrepareSql=3;XaEmulation=false;]
Mar 17, 2016 11:36:15 AM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: AUTO_QUOTE_IDENTIFIER value : false
Mar 17, 2016 11:36:15 AM com.adventnet.db.adapter.Jdbc20DBAdapter getListFromIde
ntifierFile
WARNING: 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
Mar 17, 2016 11:36:15 AM 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.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(%)
================Error ignored = Violation of PRIMARY KEY constraint 'WM_PK'. Can
not insert duplicate key in object 'dbo.WordMap'.
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
Error ignored = Violation of PRIMARY KEY constraint 'WM_PK'. Cannot insert dupli
cate key in object 'dbo.WordMap'.
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
==QUERY = INSERT INTO ErrorLog (ERRORLOGID,OCCURREDTIME,MESSAGE,ERRORMODULE,SUBE
RRORMODULE,PROBABLECAUSE,OWNERID,TYPE,ACTION) VALUES(2390452, 1454345323562, N'R
Report Query : SELECT workstation.WORKSTATIONNAME "Machine Name",workstation.MAN
UFACTURER "Manufacturer",workstation.MODEL "Model" FROM SystemInfo workstation L
EFT JOIN Resources resource ON workstation.WORKSTATIONID=resource.RESOURCEID LEF
T JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID L
EFT JOIN ResourceState state ON resource.RESOURCESTATEID=state.RESOURCESTATEID W
HERE  (((((((((((((((((((((((((((((((((((product.COMPONENTNAME = N''Evo D510 CMT
'' COLLATE SQL_Latin1_General_CP1_CI_AS) OR (product.COMPONENTNAME = N''HP 6300P
 i3'' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (product.COMPONENTNAME = N''HP C
ompaq 8100 Elite SFF PC'' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (product.COM
PONENTNAME = N''HP Compaq 8200 Elite SFF PC'' COLLATE SQL_Latin1_General_CP1_CI_
AS)) OR (product.COMPONENTNAME = N''HP Compaq dc7800 Small Form Factor'' COLLATE
 SQL_Latin1_General_CP1_CI_AS)) OR (product.COMPONENTNAME = N''HP Compaq Pro 630
0 MT'' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (product.COMPONENTNAME = N''HP
Compaq Pro 6300 SFF'' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (product.COMPONE
NTNAME = N''HP d530 CMT(DG769A)'' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (pro
duct.COMPONENTNAME = N''HP EliteDesk 800 G1 DM'' COLLATE SQL_Latin1_General_CP1_
CI_AS)) OR (product.COMPONENTNAME = N''HP EliteDesk 800 G1 SFF'' COLLATE SQL_Lat
in1_General_CP1_CI_AS)) OR (product.COMPONENTNAME = N''HP EliteDesk 800 G1 TWR''
 COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (product.COMPONENTNAME = N''HP MP6 Di
gital Signage Player'' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (product.COMPON
ENTNAME = N''HP MP9 Model 9000'' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (prod
uct.COMPONENTNAME = N''HP ProDesk 600 G1 SFF'' COLLATE SQL_Latin1_General_CP1_CI
_AS)) OR (product.COMPONENTNAME = N''HP Vectra'' COLLATE SQL_Latin1_General_CP1_
CI_AS)) OR (product.COMPONENTNAME = N''HP xw4400 Workstation'' COLLATE SQL_Latin
1_General_CP1_CI_AS)) OR (product.COMPONENTNAME = N''HP Z210 Workstation'' COLLA
TE SQL_Latin1_General_CP1_CI_AS)) OR (product.COMPONENTNAME = N''Mac Pro'' COLLA
TE SQL_Latin1_General_CP1_CI_AS)) OR (product.COMPONENTNAME = N''Optiplex 745''
COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (product.COMPONENTNAME = N''OptiPlex 7
55'' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (product.COMPONENTNAME = N''OptiP
lex 760'' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (product.COMPONENTNAME = N''
OptiPlex 780'' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (product.COMPONENTNAME
= N''OptiPlex GX260'' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (product.COMPONE
NTNAME = N''OptiPlex GX270'' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (product.
COMPONENTNAME = N''OptiPlex GX280'' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (p
roduct.COMPONENTNAME = N''OptiPlex GX520'' COLLATE SQL_Latin1_General_CP1_CI_AS)
) OR (product.COMPONENTNAME = N''Precision T1500'' COLLATE SQL_Latin1_General_CP
1_CI_AS)) OR (product.COMPONENTNAME = N''Precision T1600'' COLLATE SQL_Latin1_Ge
neral_CP1_CI_AS)) OR (product.COMPONENTNAME = N''Precision T1650'' COLLATE SQL_L
atin1_General_CP1_CI_AS)) OR (product.COMPONENTNAME = N''Precision T1700'' COLLA
TE SQL_Latin1_General_CP1_CI_AS)) OR (product.COMPONENTNAME = N'', N'Reports', N
'', N'', 6018, N'Info', N'');

java.sql.SQLException: Invalid SQL statement or JDBC escape, terminating ''' not
 found.
        at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:1155)
        at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:156)
        at net.sourceforge.jtds.jdbc.JtdsStatement.addBatch(JtdsStatement.java:1
088)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:727)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:326)
        at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:133)
        at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:188)
        at java.lang.Thread.run(Unknown Source)
Unable to restore database : Invalid SQL statement or JDBC escape, terminating '
'' not found.
Invalid SQL statement or JDBC escape, terminating ''' not found.

Mar 17, 2016 11:47:31 AM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: dbadapter :: [com.adventnet.db.adapter.mssql.MssqlDBAdapter@5f3c6654], sta
rtDBServer :: [true], dbProp :: {ManagedConnectionFactoryProperties=
, TrackConnectionByTx=true, Password=, MaxSize=20, SecurityDomainJndi
Name=DBPwdEncrypt, UserName=, ConnectionURL=jdbc:jtds:sqlserver:// ;Tds=8.0;PrepareSql=3;XaEmulation=false;, Blockin
gTimeoutMillis=30000, Criteria=ByContainer, DriverClass=net.sourceforge.jtds.jdb
c.Driver, JndiName=MSSQLDS, LocalTransactions=true, IdleTimeoutMinutes=15, MinSi
ze=0}
Mar 17, 2016 11:47:31 AM com.adventnet.db.adapter.Jdbc20DBAdapter shutDownDBForc
eFully
SEVERE: Stop DBServer operation is not supported in Jdbc20DBAdapter
Mar 17, 2016 11:47:31 AM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: waitAfterDBStop :: val :: [5]
Mar 17, 2016 11:47:31 AM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Thread is going to sleep for [5] seconds
Mar 17, 2016 11:47:36 AM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Coming out of stopDB

D:\ManageEngine\ServiceDesk\bin>

 

Thanks

Kristen