Error While invoking Scheduled backup (DB:MSSQL)

When Backup Scheduling is enabled in ServiceDeskPlus-MSP and at the specified time if the application is unable to perform the backup for some reasons, an exception is thrown and this exception will be sent as an email to email addresses configured under “application error occurs” under Admin > Notification Rules > Technician Notifications.
The mail sent will look like this:

Message Dear Admin,

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

Error Message java.lang.Exception: Unable to get the data from [SeqGenState] table at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingLimit(SDBackUp.java:1594) at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:1197) at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:396) at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:110) at com.adventnet.servicedesk.setup.task.ScheduledBackupTask.executeTask(ScheduledBackupTask.java:101) 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 queryupdate 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

Solution :
Before performing the below steps, please take a Snapshot (of both Application and SQL Server) or have a SQL backup (.bak). Please check and confirm the exception as shown above “Exception: Unable to get the data from [SeqGenState]” and connect to the database to execute the below query :

CREATE TABLE [dbo].[DynamicDummy]([COLNAME] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,[COLALIAS] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
CONSTRAINT [DynamicDummy_PK] PRIMARY KEY CLUSTERED ([COLNAME] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY])

Restart the application services once.

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500