Problem with SQL Database Restore
Hellow,
I try to restore my SDP database, its finished with error. After first restoring, SDP service not starting
Restore data log:
INFO: setdbhomearg set in mappings.xml :: [null]
Mar 18, 2014 10:52:50 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInsta
ntiateDB
INFO: Final setdbhomearg :: [false]
Mar 18, 2014 10:52:50 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInsta
ntiateDB
INFO: properties sent to adapter initialization :: {jndiname=MySqlDS, name=mysql
, setdbhomearg=false, sqlgenerator=com.adventnet.db.adapter.mysql.MysqlSQLGenera
tor}
Mar 18, 2014 10:52:50 AM com.adventnet.updatemgr.util.ConfUtils parseXMLAndInsta
ntiateDB
INFO: db.home :: [.\mysql] finally
Mar 18, 2014 10:52:51 AM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: connectionProperties :: [useUnicode=true
characterEncoding=UTF-8
]
Mar 18, 2014 10:52:51 AM com.adventnet.updatemgr.util.ConfUtils initDataAccess
INFO: url :: [jdbc:mysql://localhost:33366/servicedesk?&useUnicode=true&characte
rEncoding=UTF-8]
Mar 18, 2014 10:52:51 AM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
INFO: AUTO_QUOTE_IDENTIFIER value : false
Mar 18, 2014 10:52:51 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.mysql.My
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 18, 2014 10:52:53 AM com.adventnet.db.adapter.DBInitializer startDBServer
INFO: Command to start DB server [cmd, /c, ".\bin\startDB.bat", 33366]
Active DB Server = mysql
Database connectionProp : useUnicode=true
characterEncoding=UTF-8
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(%)
====Base table or view not found, message from server: "Table 'servicedesk.rel_
301' doesn't exist" : delete from Rel_301
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_2103' doesn't exist" : delete from ARC_ServiceReq_2103
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_2103' doesn't exist" : delete from ServiceReq_2103
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_2102' doesn't exist" : delete from ARC_ServiceReq_2102
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_2102' doesn't exist" : delete from ServiceReq_2102
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_2101' doesn't exist" : delete from ARC_ServiceReq_2101
=Base table or view not found, message from server: "Table 'servicedesk.service
req_2101' doesn't exist" : delete from ServiceReq_2101
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_1802' doesn't exist" : delete from ARC_ServiceReq_1802
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_1802' doesn't exist" : delete from ServiceReq_1802
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_1201' doesn't exist" : delete from ARC_ServiceReq_1201
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_1201' doesn't exist" : delete from ServiceReq_1201
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_903' doesn't exist" : delete from ARC_ServiceReq_903
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_903' doesn't exist" : delete from ServiceReq_903
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_902' doesn't exist" : delete from ARC_ServiceReq_902
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_902' doesn't exist" : delete from ServiceReq_902
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_901' doesn't exist" : delete from ARC_ServiceReq_901
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_901' doesn't exist" : delete from ServiceReq_901
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_601' doesn't exist" : delete from ARC_ServiceReq_601
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_601' doesn't exist" : delete from ServiceReq_601
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_334' doesn't exist" : delete from ARC_ServiceReq_334
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_334' doesn't exist" : delete from ServiceReq_334
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_330' doesn't exist" : delete from ARC_ServiceReq_330
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_330' doesn't exist" : delete from ServiceReq_330
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_322' doesn't exist" : delete from ARC_ServiceReq_322
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_322' doesn't exist" : delete from ServiceReq_322
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_321' doesn't exist" : delete from ARC_ServiceReq_321
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_321' doesn't exist" : delete from ServiceReq_321
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_320' doesn't exist" : delete from ARC_ServiceReq_320
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_320' doesn't exist" : delete from ServiceReq_320
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_318' doesn't exist" : delete from ARC_ServiceReq_318
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_318' doesn't exist" : delete from ServiceReq_318
=Base table or view not found, message from server: "Table 'servicedesk.arc_ser
vicereq_317' doesn't exist" : delete from ARC_ServiceReq_317
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_317' doesn't exist" : delete from ServiceReq_317
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_316' doesn't exist" : delete from ARC_ServiceReq_316
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_316' doesn't exist" : delete from ServiceReq_316
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_315' doesn't exist" : delete from ARC_ServiceReq_315
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_315' doesn't exist" : delete from ServiceReq_315
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_313' doesn't exist" : delete from ARC_ServiceReq_313
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_313' doesn't exist" : delete from ServiceReq_313
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_311' doesn't exist" : delete from ARC_ServiceReq_311
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_311' doesn't exist" : delete from ServiceReq_311
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_310' doesn't exist" : delete from ARC_ServiceReq_310
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_310' doesn't exist" : delete from ServiceReq_310
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_308' doesn't exist" : delete from ARC_ServiceReq_308
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_308' doesn't exist" : delete from ServiceReq_308
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_306' doesn't exist" : delete from ARC_ServiceReq_306
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_306' doesn't exist" : delete from ServiceReq_306
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_305' doesn't exist" : delete from ARC_ServiceReq_305
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_305' doesn't exist" : delete from ServiceReq_305
Base table or view not found, message from server: "Table 'servicedesk.arc_serv
icereq_303' doesn't exist" : delete from ARC_ServiceReq_303
Base table or view not found, message from server: "Table 'servicedesk.servicer
eq_303' doesn't exist" : delete from ServiceReq_303
=============================================
Error occured while deletion of all table
data please see the error log
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
Please wait ! Restoring in Progress...................
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
====================QUERY = INSERT INTO ErrorLog (ERRORLOGID,OCCURREDTIME,MESSAG
E,ERRORMODULE,SUBERRORMODULE,PROBABLECAUSE,OWNERID,TYPE,ACTION) VALUES(318315, 1
387198207393, N'--Continued--\n \n\nCACHE KEY: 1250_DEFSITE\nCACHE TYPE: java.la
ng.Long\nCACHE DATA: VALUE 1502 \n\nCACHE KEY: 6401_DEFSITE\nCACHE TYPE: java.la
ng.Long\nCACHE DATA: VALUE 1502 \n\nCACHE KEY: 5111_DEFSITE\nCACHE TYPE: java.la
ng.Long\nCACHE DATA: VALUE 1803 \n\nCACHE KEY: 1462_DEFSITE\nCACHE TYPE: java.la
ng.Long\nCACHE DATA: VALUE 1803 \n\nCACHE KEY: TECH_SITE_MAPPING_9002\nCACHE TYP
E: java.util.Vector\nCACHE DATA: SIZE 0 \n\nCACHE KEY: ALL_TEMPLATES_DO_FOR_PARE
NT_SERVICE\nCACHE TYPE: com.adventnet.persistence.WritableDataObject\nCACHE DATA
: Table:RequestTemplate_List 278Rows \n\nCACHE KEY: ROLES_FOR_USER_5148\nCACHE T
YPE: java.util.ArrayList\nCACHE DATA: SIZE 41 \n\nCACHE KEY: 5123_DEFSITE\nCACHE
TYPE: java.lang.Long\nCACHE DATA: VALUE 1801 \n\nCACHE KEY: TECH_SITE_MAPPING_9
301\nCACHE TYPE: java.util.Vector\nCACHE DATA: SIZE 0 \n\nCACHE KEY: SYSTEM_LANG
UAGE\nCACHE TYPE: java.lang.String\nCACHE DATA: VALUE default \n\nCACHE KEY: 480
4_USERSITES\nCACHE TYPE: com.adventnet.persistence.WritableDataObject\nCACHE DAT
A: Table:SDOrganization 6Rows \n\nCACHE KEY: 1294_USERSITES\nCACHE TYPE: com.adv
entnet.persistence.WritableDataObject\nCACHE DATA: \n\nCACHE KEY: 603_DEFSITE\nC
ACHE TYPE: java.lang.Long\nCACHE DATA: VALUE 1501 \n\nCACHE KEY: 1254_DEFSITE\nC
ACHE TYPE: java.lang.Long\nCACHE DATA: VALUE 1502 \n\nCACHE KEY: 7860_DEFSITE\nC
ACHE TYPE: java.lang.Long\nCACHE DATA: VALUE -1 \n\nCACHE KEY: TECH_SITE_MAPPING
_9302\nCACHE TYPE: java.util.Vector\nCACHE DATA: SIZE 0 \n\nCACHE KEY: 1188_DEFS
ITE\nCACHE TYPE: java.lang.Long\nCACHE DATA: VALUE 1802 \n\nCACHE KEY: 6437_DEFS
ITE\nCACHE TYPE: java.lang.Long\nCACHE DATA: VALUE 1502 \n\nCACHE KEY: 1286_DEFS
ITE\nCACHE TYPE: java.lang.Long\nCACHE DATA: VALUE 1502 \n\nCACHE KEY: 941_DEFSI
TE\nCACHE TYPE: java.lang.Long\nCACHE DATA: VALUE 1802 \n\nCACHE KEY: 1482_DEFSI
TE\nCACHE TYPE: java.lang.Long\nCACHE DATA: VALUE 1803 \n\nCACHE KEY: QUEUETECHM
APPINGDO\nCACHE TYPE: com.adventnet.persistence.WritableDataObject\nCACHE DATA:
Table:Queue_Technician 60Rows \n\nCACHE KEY: COPYCUSTOMSITECOUNT_FOR_QUEUES\nCAC
HE TYPE: java.lang.Integer\nCACHE DATA: VALUE 6 \n\nCACHE KEY: ROLES_FOR_USER_63
98\nCACHE TYPE: java.util.ArrayList\nCACHE DATA: SIZE 41 \n\nCACHE KEY: 945_DEFS
ITE\nCACHE TYPE: java.lang.Long\nCACHE DATA: VALUE 1802 \n\nCACHE KEY: 7205_DEFS
ITE\nCACHE TYPE: java.lang.Long\nCACHE DATA: VALUE -1 \n\nCACHE KEY: GLOBAL_REQU
EST_ONHOLD_OPTION\nCACHE TYPE: java.lang.String\nCACHE DATA: VALUE false \n\nCAC
HE KEY: 1274_DEFSITE\nCACHE TYPE: java.lang.Long\nCACHE DATA: VALUE 1502 \n\nCAC
HE KEY: 611_DEFSITE\nCACHE TYPE: java.lang.Long\nCACHE DATA: VALUE 1501 \n\nCACH
E KEY: 1513_DEFSITE\nCACHE TYPE: java.lang.Long\nCACHE DATA: VALUE 1502 \n\nCACH
E KEY: 1388_DEFSITE\nCACHE TYPE: java.lang.Long\nCACHE DATA: VALUE 1502 \n\nCACH
E KEY: 1360_DEFSITE\nCACHE TYPE: java.lang.Long\nCACHE DATA: VALUE 1502 \n\nCACH
E KEY: 1243_USERSITES\nCACHE TYPE: com.adventnet.persistence.WritableDataObject\
nCACHE DATA: \n\nCACHE KEY: 7837_DEFSITE\nCACHE TYPE: java.lang.Long\nCACHE DATA
: VALUE -1 \n\nCACHE KEY: 6339_DEFSITE\nCACHE TYPE: java.lang.Long\nCACHE DATA:
VALUE 1802 \n\nCACHE KEY: 1219_DEFSITE\nCACHE TYPE: java.lang.Long\nCACHE DATA:
VALUE 1802 \n\nCACHE KEY: 1384_DEFSITE\nCACHE TYPE: java.lang.Long\nCACHE DATA:
VALUE 1502 \n\nCACHE KEY: 639_DEFSITE\nCACHE TYPE: java.lang.Long\nCACHE DATA: V
ALUE 1501 \n\nCACHE KEY: DYNAMIC_SERVICE_TABLES_DO\nCACHE TYPE: com.adventnet.pe
rsistence.WritableDataObject\nCACHE DATA: Table:ServiceMetaTable 44Rows Tab', N'
CACHE', N'DATA COUNT', N'', NULL, N'Info', N'Add');
java.sql.BatchUpdateException: Syntax error or access violation, message from s
erver: "You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'CACHE', 'DATA COU
NT', '', NULL, 'Info', 'Add')' at line 1"
at com.mysql.jdbc.Statement.executeBatch(Statement.java:1057)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(Rest
oreSDBackup.java:623)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(Resto
reSDBackup.java:296)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.
java:141)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.jav
a:186)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : Syntax error or access violation, message from ser
ver: "You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'CACHE', 'DATA COUNT
', '', NULL, 'Info', 'Add')' at line 1"
Syntax error or access violation, message from server: "You have an error in yo
ur SQL syntax; check the manual that corresponds to your MySQL server version fo
r the right syntax to use near 'CACHE', 'DATA COUNT', '', NULL, 'Info', 'Add')'
at line 1"
Mar 18, 2014 11:05:27 AM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: dbadapter :: [com.adventnet.db.adapter.mysql.MysqlDBAdapter@940f82], start
DBServer :: [true], dbProp :: {BlockingTimeoutMillis=30000, ManagedConnectionFac
toryProperties=
, Criteria=ByContainer, LocalTransactions=true, MinSize=0, Password=, JndiName=M
ySqlDS, MaxSize=20, SecurityDomainJndiName=DBPwdEncrypt, DriverClass=org.gjt.mm.
mysql.Driver, TransactionIsolation=TRANSACTION_READ_COMMITTED, ConnectionPropert
ies=useUnicode=true
characterEncoding=UTF-8
, TrackConnectionByTx=true, UserName=root, IdleTimeoutMinutes=15, ConnectionURL=
jdbc:mysql://localhost:33366/servicedesk}
Mar 18, 2014 11:05:27 AM com.adventnet.db.adapter.mysql.MysqlDBAdapter shutDownD
B
INFO: connectionURL :: [jdbc:mysql://localhost:33366/servicedesk], userName :: [
root], password :: []
Mar 18, 2014 11:05:27 AM com.adventnet.db.adapter.mysql.MysqlDBAdapter shutDownD
B
INFO: Stopping MySQL Server ...
Mar 18, 2014 11:05:27 AM com.adventnet.db.adapter.DBInitializer stopDBServer
INFO: Command to stop DB server [cmd, /c, .\bin\stopDB.bat, 33366, root, ]
Mar 18, 2014 11:05:27 AM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: waitAfterDBStop :: val :: [5]
Mar 18, 2014 11:05:27 AM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Thread is going to sleep for [5] seconds