Message

Dear Admin,

Unable to take the backup of ServiceDesk Plus, So please contact your database Administrator [OR]
product support for further assistance to fix the below error and forward this E-Mail and support file(s) to servicedeskplus-support@manageengine.com

Error Message

java.lang.Exception: Unable to get the data from [ServiceReq_SW] table at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingLimit(SDBackUp.java:1495) at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingLimit(SDBackUp.java:1516) at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBackUp.java:1135) at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:1106) at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:366) at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:101) at com.adventnet.servicedesk.setup.task.ScheduledBackupTask.executeTask(ScheduledBackupTask.java:93) at com.adventnet.workengine.task.internal.TaskManagerImpl.executeTask(TaskManagerImpl.java:706) at com.adventnet.workengine.executor.internal.WorkFlowExecutor.executeStartingTask(WorkFlowExecutor.java:160) at com.adventnet.workengine.executor.internal.WorkFlowExecutor.executeWorkFlowTemplate(WorkFlowExecutor.java:115) at com.adventnet.workengine.executor.internal.WorkFlowExecutor.executeWorkFlow(WorkFlowExecutor.java:105) at com.adventnet.workengine.executor.internal.LocalWorkFlowExecutionHandler.execute(LocalWorkFlowExecutionHandler.java:67) at com.adventnet.workengine.internal.WorkEngineImpl$WorkFlowExecutorThread.run(WorkEngineImpl.java:931) at com.adventnet.workengine.service.ThreadPoolService$WorkerThread.run(ThreadPoolService.java:256) at java.lang.Thread.run(Unknown Source)

Trouble shooting tips

Please contact your DBA to update the following sql query

update Task_Input SET OPERATIONAL_STATUS = 4 where SCHEDULE_ID = (select SCHEDULE_ID from schedule where SCHEDULE_NAME = 'BackupSchedule')

This sql query will stop your backup scheduling