Hi i am trying to run a backup before updating the software however i keep getting error. please let me know how to fix this?

 

C:\ManageEngine\ServiceDesk\bin>backUpData.bat --trimmed

Starting....

24/07/2014 18:52:15 com.adventnet.servicedesk.server.utils.SDDataManager setStan

dAlone

INFO: Going to set the standAlone param as : true

24/07/2014 18:52:16 com.adventnet.servicedesk.server.utils.SDDataManager setStan

dAlone

INFO: Going to reset rootDir using server.dir

24/07/2014 18:52:16 com.adventnet.servicedesk.server.utils.SDDataManager <init>

INFO: rootDir :: ..

24/07/2014 18:52:16 com.adventnet.servicedesk.server.utils.SDDataManager <init>

INFO: netutilsData :: {RELEASE={version=8.1.0}, BUILD={number=8114}}

24/07/2014 18:52:16 com.adventnet.servicedesk.server.utils.SDDataManager <init>

INFO: rebrandData :: {OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine Ser

viceDesk Plus}, ADMANAGER={name=ADManager}}

Active DB Server = mssql

Database connectionProp : null

Database started

*************************************************************

Number of tables found : 1222

-------------------------------------------------------------

Build number           : 8114

-------------------------------------------------------------

backup_info.xml        : true

-------------------------------------------------------------

Ignored Table List

-------------------------------------------------------------

AaaAccSessionAudit

AaaAccHttpSession

AaaAccSessionProp

AaaAccSession

AuditRecord

OperationAuditRecord

AuditResultProperty

AuditResourceProp

AuditOperProperty

RecentItems

-------------------------------------------------------------

Going to take minimal backup without file attachments

-------------------------------------------------------------

deleting duplicate entries in WordMap table : 0

*************************************************************

 

 

 

Please wait ! backup in Progress...................

0-----------------------50------------------------100(%)

======================java.sql.SQLException: Invalid state, the Connection objec

t is closed.

        at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:448)

        at net.sourceforge.jtds.jdbc.TdsCore.getNextRow(TdsCore.java:760)

        at net.sourceforge.jtds.jdbc.JtdsResultSet.next(JtdsResultSet.java:593)

        at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac

kUp.java:889)

        at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:781)

 

        at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:35

3)

        at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:95)

        at com.adventnet.servicedesk.tools.SDBackUp.main(SDBackUp.java:1813)

Backup table in progress is hwaudithistory.sql

 

It looks like database connection get lost while taking the backup, and now appl

ication will try to establish the db connection and continue with the backup in

two attempts with 10 sec intervals. Attempt 1.

 

Active DB Server = mssql

Database connectionProp : null

Database started

Reestablishing the connection again. Attempt :2.

 

java.sql.SQLException: Invalid state, the Connection object is closed.

        at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:448)

        at net.sourceforge.jtds.jdbc.TdsCore.getNextRow(TdsCore.java:760)

        at net.sourceforge.jtds.jdbc.JtdsResultSet.next(JtdsResultSet.java:593)

        at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac

kUp.java:889)

        at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac

kUp.java:1070)

        at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:781)

 

        at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:35

3)

        at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:95)

        at com.adventnet.servicedesk.tools.SDBackUp.main(SDBackUp.java:1813)

Backup table in progress is hwaudithistory.sql

 

It looks like database connection get lost while taking the backup, and now appl

ication will try to establish the db connection and continue with the backup in

two attempts with 10 sec intervals. Attempt 2.

 

Active DB Server = mssql

Database connectionProp : null

Database started

Reestablishing the connection again. Attempt :3.

 

java.lang.Exception: Unable to get the data from [HwAuditHistory] table

        at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac

kUp.java:789)

        at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac

kUp.java:1070)

        at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac

kUp.java:1070)

        at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:781)

 

        at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:35

3)

        at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:95)

        at com.adventnet.servicedesk.tools.SDBackUp.main(SDBackUp.java:1813)

 

 

stopping DB Server >>>>> false

java.lang.Exception: Unable to get the data from [HwAuditHistory] table

        at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac

kUp.java:789)

        at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac

kUp.java:1070)

        at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBac

kUp.java:1070)

        at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:781)

 

        at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:35

3)

        at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:95)

        at com.adventnet.servicedesk.tools.SDBackUp.main(SDBackUp.java:1813)