RESTORE FAILS build 9200
Please Help trying to restore BACKUP,
Had posgresql,I made a backup , then changed DB to my SQL express 2012, now i cannot restore,
i found similiar post and the guy somehow fixed this issue with an upload of some kind of JAR file
SEE LINK:
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]
*********************************************************************************
Jan 27, 2016 8:02:02 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to set the standAlone param as : true
Jan 27, 2016 8:02:02 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to reset rootDir using server.dir
Jan 27, 2016 8:02:04 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: .
Jan 27, 2016 8:02:04 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=9.2}, BUILD={number=9200}}
Jan 27, 2016 8:02:04 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManager Plus}}
You chose to open this file: C:\Users\Akaki Shelia\Desktop\backup_mssql_9200_fullbackup_01_27_2016_19_13\backup_mssql_9200_fullbackup_01_27_2016_19_13_part_1.data
File name is : C:\Users\Akaki Shelia\Desktop\backup_mssql_9200_fullbackup_01_27_2016_19_13\backup_mssql_9200_fullbackup_01_27_2016_19_13_part_1.data
Jan 27, 2016 8:02:22 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to set the standAlone param as : true
Jan 27, 2016 8:02:22 PM com.adventnet.servicedesk.server.utils.SDDataManager setStandAlone
INFO: Going to reset rootDir using server.dir
Jan 27, 2016 8:02:22 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rootDir :: .
Jan 27, 2016 8:02:22 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: netutilsData :: {RELEASE={version=9.2}, BUILD={number=9200}}
Jan 27, 2016 8:02:22 PM com.adventnet.servicedesk.server.utils.SDDataManager <init>
INFO: rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManager Plus}}
Extracting backup file....
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Jan 27, 2016 8:02:28 PM com.zoho.framework.utils.FileUtils copyFile
INFO: Entered into copyFile :: sourceFile :: [.\server\default\conf\SnmpConfigurations.xml], destinationFile :: [.\server\default\conf\SnmpConfigurations_1453910548995.xml]
Jan 27, 2016 8:02:29 PM com.zoho.framework.utils.FileUtils copyFile
INFO: Entered into copyFile :: sourceFile :: [.\SnmpConfigurations.xml], destinationFile :: [.\server\default\conf\SnmpConfigurations.xml]
*************************************************************.\backup_info.xml
Backpup data : Wed Jan 27 19:13:17 GET 2016
Database name : sd
Total Tables : 1368
Database Server : mssql
Build Number : 9200
*************************************************************
Jan 27, 2016 8:02:29 PM com.adventnet.persistence.service.DatabaseFactory loadConfigurationAndPopulateAsPersistenceConfigurations
INFO: DataSourceConfiguration file URL is file:/c:/ManageEngine/ServiceDesk/./server/default/conf/datasource-configuration.xml
Jan 27, 2016 8:02:29 PM com.adventnet.persistence.service.DatabaseFactory loadConfigurationAndPopulateAsPersistenceConfigurations
INFO: Service file URL is file:/c:/ManageEngine/ServiceDesk/./server/default/conf/jboss-service.xml
Jan 27, 2016 8:02:29 PM com.adventnet.persistence.service.DatabaseFactory getDSProperties
INFO: Coming Out of getDSProperties
Jan 27, 2016 8:02:29 PM com.adventnet.persistence.PersistenceInitializer getDBParamsFilePath
INFO: Reading null\conf\database_params.conf
Jan 27, 2016 8:02:29 PM com.adventnet.ds.DefaultDataSourcePlugIn initialize
INFO: ConnectionPoolParams :: minSize :: [20], maxSize :: [1], idleTimeout :: [1,800 seconds], blockingTimeout :: [30 seconds]
Jan 27, 2016 8:02:29 PM com.adventnet.ds.DefaultDataSourcePlugIn getDataSource
INFO: DataSourceorg.jboss.resource.adapter.jdbc.WrapperDataSource@104272b2
Jan 27, 2016 8:02:29 PM com.adventnet.persistence.PersistenceInitializer createArchiveAdapter
INFO: Archive Adapter class ::: com.adventnet.db.archive.DefaultArchiveAdapter
Jan 27, 2016 8:02:29 PM com.adventnet.persistence.PersistenceInitializer createArchiveAdapter
INFO: Storage Adapter class ::: null
Jan 27, 2016 8:02:29 PM com.adventnet.db.api.RelationalAPI <clinit>
SEVERE: haltjvm.on.dbcrash is set to [false]
Jan 27, 2016 8:02:29 PM com.adventnet.db.adapter.Jdbc20DBAdapter getShutDownStrings
INFO: shutDownStrings :: []
Jan 27, 2016 8:02:29 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTemplates
INFO: Loading the function patterns from the file :: [null\conf\Persistence\mssql_functionpatterns.txt]
Jan 27, 2016 8:02:29 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTemplates
SEVERE: Exception occurred while parsing the file :: [null\conf\Persistence\mssql_functionpatterns.txt]
java.io.FileNotFoundException: null\conf\Persistence\mssql_functionpatterns.txt (The system cannot find the path specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at com.adventnet.db.adapter.Jdbc20DBAdapter.loadFunctionTemplates(Jdbc20DBAdapter.java:2057)
at com.adventnet.db.adapter.Jdbc20DBAdapter.initialize(Jdbc20DBAdapter.java:213)
at com.adventnet.db.adapter.mssql.MssqlDBAdapter.initialize(MssqlDBAdapter.java:92)
at com.adventnet.persistence.PersistenceInitializer.initializeRelationalAPI(PersistenceInitializer.java:446)
at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:457)
at com.adventnet.persistence.PersistenceInitializer.initializeDBAndDBProps(PersistenceInitializer.java:338)
at com.adventnet.persistence.service.DatabaseFactory.startDB(DatabaseFactory.java:535)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:287)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:136)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:188)
at java.lang.Thread.run(Unknown Source)
Jan 27, 2016 8:02:30 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
SEVERE: Error while trying to instantiate SQLGenerator :: {0}
java.io.FileNotFoundException: null\conf\Persistence\mssql_functionpatterns.txt (The system cannot find the path specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at com.adventnet.db.adapter.Jdbc20DBAdapter.loadFunctionTemplates(Jdbc20DBAdapter.java:2057)
at com.adventnet.db.adapter.Jdbc20DBAdapter.initialize(Jdbc20DBAdapter.java:213)
at com.adventnet.db.adapter.mssql.MssqlDBAdapter.initialize(MssqlDBAdapter.java:92)
at com.adventnet.persistence.PersistenceInitializer.initializeRelationalAPI(PersistenceInitializer.java:446)
at com.adventnet.persistence.PersistenceInitializer.initializeDB(PersistenceInitializer.java:457)
at com.adventnet.persistence.PersistenceInitializer.initializeDBAndDBProps(PersistenceInitializer.java:338)
at com.adventnet.persistence.service.DatabaseFactory.startDB(DatabaseFactory.java:535)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:287)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:136)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:188)
at java.lang.Thread.run(Unknown Source)
Jan 27, 2016 8:02:30 PM com.zoho.framework.utils.crypto.EnDecryptImpl decrypt
SEVERE: Encryption failed
Jan 27, 2016 8:02:30 PM com.adventnet.db.adapter.AbstractRestoreHandler doRestoreSanityTesting
INFO: Restore process fully completed.
Jan 27, 2016 8:02:30 PM com.adventnet.persistence.PersistenceInitializer getTemplatesReplacedUrl
INFO: Template replaced url :: jdbc:jtds:sqlserver://localhost:54733;DatabaseName=servicedesk;Tds=8.0;PrepareSql=3;XaEmulation=false;
Jan 27, 2016 8:02:30 PM com.adventnet.persistence.PersistenceInitializer getTemplatesReplacedUrl
INFO: Template replaced url :: jdbc:jtds:sqlserver://localhost:54733;DatabaseName=servicedesk;Tds=8.0;PrepareSql=3;XaEmulation=false;
Jan 27, 2016 8:02:30 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleCollation
INFO: Incoming collation string is SQL_Latin1_General_CP1_CI_AS
Jan 27, 2016 8:02:30 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleCollation
INFO: Collation String constructed is SQL_Latin1_General_CP1_CS_A%
Jan 27, 2016 8:02:30 PM com.adventnet.db.adapter.mssql.MssqlDBAdapter getToggleCollation
INFO: The Toggle collation string is SQL_Latin1_General_CP1_CS_AS
Jan 27, 2016 8:02:30 PM com.adventnet.db.adapter.Jdbc20DBAdapter getDBProps
INFO: splitConnectionURL :: {DatabaseName=servicedesk, PrepareSql=3, Port=54733, url_props_delimiter=;, urlWithoutProps=jdbc:jtds:sqlserver://localhost:54733, jdbcurl_props_separator=;, Tds=8.0, properties={Tds=8.0, XaEmulation=false, Server=localhost, PrepareSql=3, DatabaseName=servicedesk, DBName=localhost:54733, Port=54733}, DBName=localhost:54733, XaEmulation=false, Server=localhost, urlProps={Tds=8.0, XaEmulation=false, PrepareSql=3, DatabaseName=servicedesk}}
Jan 27, 2016 8:02:30 PM com.adventnet.persistence.PersistenceInitializer getTemplatesReplacedUrl
INFO: Template replaced url :: jdbc:jtds:sqlserver://localhost:54733;DatabaseName=servicedesk;Tds=8.0;PrepareSql=3;XaEmulation=false;
Active DB Server = mssql
Database connectionProp : null
Jan 27, 2016 8:02:35 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTemplates
INFO: Loading the function patterns from the file :: [null\conf\Persistence\mssql_functionpatterns.txt]
Jan 27, 2016 8:02:35 PM com.adventnet.db.adapter.Jdbc20DBAdapter loadFunctionTemplates
SEVERE: Exception occurred while parsing the file :: [null\conf\Persistence\mssql_functionpatterns.txt]
java.io.FileNotFoundException: null\conf\Persistence\mssql_functionpatterns.txt (The system cannot find the path specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at com.adventnet.db.adapter.Jdbc20DBAdapter.loadFunctionTemplates(Jdbc20DBAdapter.java:2057)
at com.adventnet.db.adapter.Jdbc20DBAdapter.initialize(Jdbc20DBAdapter.java:213)
at com.adventnet.db.adapter.mssql.MssqlDBAdapter.initialize(MssqlDBAdapter.java:92)
at com.adventnet.servicedesk.tools.ConnectionUtil.getDBAdapter(ConnectionUtil.java:195)
at com.adventnet.servicedesk.tools.ConnectionUtil.getConnection(ConnectionUtil.java:60)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:289)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:136)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:188)
at java.lang.Thread.run(Unknown Source)
Jan 27, 2016 8:02:35 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
SEVERE: Error while trying to instantiate SQLGenerator :: {0}
java.io.FileNotFoundException: null\conf\Persistence\mssql_functionpatterns.txt (The system cannot find the path specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at com.adventnet.db.adapter.Jdbc20DBAdapter.loadFunctionTemplates(Jdbc20DBAdapter.java:2057)
at com.adventnet.db.adapter.Jdbc20DBAdapter.initialize(Jdbc20DBAdapter.java:213)
at com.adventnet.db.adapter.mssql.MssqlDBAdapter.initialize(MssqlDBAdapter.java:92)
at com.adventnet.servicedesk.tools.ConnectionUtil.getDBAdapter(ConnectionUtil.java:195)
at com.adventnet.servicedesk.tools.ConnectionUtil.getConnection(ConnectionUtil.java:60)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:289)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:136)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:188)
at java.lang.Thread.run(Unknown Source)
Jan 27, 2016 8:02:35 PM com.adventnet.db.adapter.Jdbc20DBAdapter initialize
SEVERE: Exception occured while initializing datasource.
Jan 27, 2016 8:02:35 PM com.zoho.framework.utils.crypto.EnDecryptImpl decrypt
SEVERE: Encryption failed
Database started
Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
========================================================
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
QUERY = INSERT INTO DynamicTables (DYNAMIC_TABLE_ID,TABLENAME,MODULE,CHAR_COLS,NUM_COLS,DATE_COLS,DEC_COLS) VALUESnull
java.sql.BatchUpdateException: Invalid object name 'DynamicTables'.
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:883)
at com.adventnet.servicedesk.tools.RestoreSDBackup.dynamicTablesList(RestoreSDBackup.java:1467)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:313)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:136)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:188)
at java.lang.Thread.run(Unknown Source)
java.sql.BatchUpdateException: Invalid object name 'DynamicTables'.
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:883)
at com.adventnet.servicedesk.tools.RestoreSDBackup.dynamicTablesList(RestoreSDBackup.java:1467)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:313)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:136)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:188)
at java.lang.Thread.run(Unknown Source)
Unable to restore database : Invalid object name 'DynamicTables'.
Invalid object name 'DynamicTables'.
Jan 27, 2016 8:02:44 PM com.adventnet.persistence.PersistenceInitializer stopDB
INFO: Going to stop the DBServer
Jan 27, 2016 8:02:44 PM com.adventnet.persistence.PersistenceInitializer getTemplatesReplacedUrl
INFO: Template replaced url :: jdbc:jtds:sqlserver://localhost:54733;DatabaseName=servicedesk;Tds=8.0;PrepareSql=3;XaEmulation=false;
TRIED THIS STEPS I FOUND ON FORUM:
Remove Restorestatus.txt file from SDP-home/server folder
Invoke ChangeDBserver.bat from SDP_home/bin folder
Give a new database name say Servicedesknew. Test and Save the settings.
Start and Stop the application.
Now start the restore using restoreData.bat file from SDP-home/bin directory
cmd> SDP-home/bin>restoredata.bat >2.txt
Watch 2.txt file under SDP-home/bin folder for restore Progress. In case of any issue
Invoke ChangeDBserver.bat from SDP_home/bin folder
Give a new database name say Servicedesknew. Test and Save the settings.
Start and Stop the application.
Now start the restore using restoreData.bat file from SDP-home/bin directory
cmd> SDP-home/bin>restoredata.bat >2.txt
Watch 2.txt file under SDP-home/bin folder for restore Progress. In case of any issue
SEE my 2.txt attached