Cannot start ServiceDesk Plus

Cannot start ServiceDesk Plus

Dear Sirs,

Please help to check and solve our problem as below:

SDP run well after the installation is completed. However when we try to restore the database from a backup file it can not start anymore but stopping at "Application Layer Started...."

Please see the below for reference of command line screen when we restore the database:


********************************************************************************
*
                         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]

********************************************************************************
*
You chose to open this file: C:\Documents and Settings\dinhle\Desktop\backup_ser
vicedesk_8010_fullbackup_06_16_2011_15_19.data
File name is :  C:\Documents and Settings\dinhle\Desktop\backup_servicedesk_8010
_fullbackup_06_16_2011_15_19.data
 requestScheme is http
Please wait extracting backup file
Active DB Server = mysql
Database connectionProp : useUnicode=true
characterEncoding=UTF-8

Database not started. Starting .........
Jun 17, 2011 10:53:13 AM com.adventnet.db.adapter.DBInitializer startDBServer
INFO: Command to start DB server [cmd, /c, "..\bin\startDB.bat", 33366]

*************************************************************
         Backpup data    : Thu Jun 16 15:19:59 ICT 2011
         Database name   : servicedesk
         Total Tables    : 1021
         Database Server : mysql
         Build Number    : 8010
*************************************************************

Jun 17, 2011 10:53:15 AM com.adventnet.servicedesk.server.utils.SDDataManager <i
nit>
INFO: rootDir :: ..
Jun 17, 2011 10:53:15 AM com.adventnet.servicedesk.server.utils.SDDataManager <i
nit>
INFO: netutilsData :: {RELEASE={version=8.0.0}, BUILD={number=8010}}
Jun 17, 2011 10:53:15 AM com.adventnet.servicedesk.server.utils.SDDataManager <i
nit>
INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine Ser
viceDesk Plus}, ADMANAGER={name=ADManager}}


Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
====================================================


Please wait ! Restoring in Progress...................
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
===================================================
 deleting temp files.....
stopping DB Server >>>>> true
Jun 17, 2011 11:02:12 AM com.adventnet.db.adapter.mysql.MysqlDBAdapter shutDownD
B
INFO: connectionURL :: [jdbc:mysql://localhost:33366/servicedesk?useUnicode=true
&characterEncoding=UTF-8], userName :: [root], password :: [null]
Jun 17, 2011 11:02:12 AM com.adventnet.db.adapter.mysql.MysqlDBAdapter shutDownD
B
INFO: Stopping MySQL Server ...
Jun 17, 2011 11:02:12 AM com.adventnet.db.adapter.DBInitializer stopDBServer
INFO: Command to stop DB server [cmd, /c, ..\bin\stopDB.bat, 33366, root]

Thank you for your support,
Dinh Le

















































































                  New to ADSelfService Plus?