Critical error on manual and scheduled backups SQL 2012 SDP 8027

Critical error on manual and scheduled backups SQL 2012 SDP 8027

Hi Service Desk
I discovered that I have the a problem with the backups, please see error message below when performing backups. I am using SDP 8027 and SQL Server 2012.

This happens either with the scheduled backup and the manual backups

Also, I cannot upgrade to 8.1 because of this error, is there any way to skip the automatic backup when upgrading?
It was possible before in v 8013

What could be the problem?

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 [trace_xe_action_map] table at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingLimit(SDBackUp.java:1080) at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingLimit(SDBackUp.java:1099) at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingLimit(SDBackUp.java:1099) at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingLimit(SDBackUp.java:1099) at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:763) at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:343) at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:94) at com.adventnet.servicedesk.setup.task.ScheduledBackupTask.executeTask(ScheduledBackupTask.java:88) 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

  • Server crashed after received this E-Mail


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















                  New to ADSelfService Plus?