SD+ crashes after every schedule backup job failure
Hi,
After my scheduled backup job fails, my SD+ 7.0 server crashes. I get the following error log in an email:
Dear Admin,
ServiceDesk Plus database seems to be corrupted, So please contact your database Administrator [OR]
servicedesk support for further assistance to recover your data forward this mail and support file(s) to support@servicedeskplus.com
java.sql.SQLException: TDS Protocol error: Invalid packet type 0xd1 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2284) at net.sourceforge.jtds.jdbc.TdsCore.getNextRow(TdsCore.java:761) at net.sourceforge.jtds.jdbc.JtdsResultSet.next(JtdsResultSet.java:593) at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:573) at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:240) at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:78) at com.adventnet.servicedesk.setup.task.ScheduledBackupTask.executeTask(ScheduledBackupTask.java:60) 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.workflow.ejb.internal.WorkFlowExecutorBean.executeWorkFlow(WorkFlowExecutorBean.java:105) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186) at org.jboss.ejb.plugins.AbstractInterceptor.invoke(AbstractInterceptor.java:94) at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148) at com.adventnet.authorization.AuthorizationInterceptor.invoke(AuthorizationInterceptor.java:88) at com.adventnet.authentication.interceptor.SecurityInterceptor.invoke(SecurityInterceptor.java:108) at com.adventnet.audit.interceptor.AuditInterceptor.invoke(AuditInterceptor.java:128) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191) at com.adventnet.logging.tracing.TracingInterceptor.invoke(TracingInterceptor.java:136) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122) at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331) at org.jboss.ejb.Container.invoke(Container.java:709) at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:419) at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:83) at $Proxy98.executeWorkFlow(Unknown Source) at com.adventnet.workengine.executor.internal.RemoteWorkFlowExecutionHandler.execute(RemoteWorkFlowExecutionHandler.java:77) at com.adventnet.workengine.internal.WorkEngineImpl$WorkFlowExecutorThread.run(WorkEngineImpl.java:923) at com.adventnet.workengine.service.ThreadPoolService$WorkerThread.run(ThreadPoolService.java:256) at java.lang.Thread.run(Unknown Source) Caused by: net.sourceforge.jtds.jdbc.ProtocolException: Invalid packet type 0xd1 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2271) ... 37 more
� 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
Any help on this would appreciated. THe issue gets resolved once i restart the SD+ services. I am using free version of SD+ 7.0 build 7002
Regards
Samad
New to ADSelfService Plus?