Hi,
we have problem with our backup, server is debian 4 and database - mysql 5.0:
Error Trace
java.io.FileNotFoundException: /usr/local/bin/ServiceDesk/fileAttachments/Request/Jun2008/1379/b����d.jpg (No such file or directory) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.(Unknown Source) at com.adventnet.servicedesk.tools.SDBackUp.zipDirectory(SDBackUp.java:947) at com.adventnet.servicedesk.tools.SDBackUp.zipDirectory(SDBackUp.java:943) at com.adventnet.servicedesk.tools.SDBackUp.zipDirectory(SDBackUp.java:943) at com.adventnet.servicedesk.tools.SDBackUp.zipDirectory(SDBackUp.java:943) at com.adventnet.servicedesk.tools.SDBackUp.endBackup(SDBackUp.java:293) at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:79) at com.adventnet.servicedesk.setup.task.ScheduledBackupTask.executeTask(Schedul edBackupTask.java:60) at com.adventnet.workengine.task.internal.TaskManagerImpl.executeTask(TaskManag erImpl.java:706) at com.adventnet.workengine.executor.internal.WorkFlowExecutor.executeStartingT ask(WorkFlowExecutor.java:160) at com.adventnet.workengine.executor.internal.WorkFlowExecutor.executeWorkFlowT emplate(WorkFlowExecutor.java:115) at com.adventnet.workengine.executor.internal.WorkFlowExecutor.executeWorkFlow( WorkFlowExecutor.java:105) at com.adventnet.workengine.workflow.ejb.internal.WorkFlowExecutorBean.executeW orkFlow(WorkFlowExecutorBean.java:105) at sun.reflect.GeneratedMethodAccessor96.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(Stateles sSessionContainer.java:683) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(Cach edConnectionInterceptor.java:186) at org.jboss.ejb.plugins.AbstractInterceptor.invoke(AbstractInterceptor.java:94 ) at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSe ssionInstanceInterceptor.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(AuthorizationInt erceptor.java:88) at com.adventnet.authentication.interceptor.SecurityInterceptor.invoke(Security Interceptor.java:108) at com.adventnet.audit.interceptor.AuditInterceptor.invoke(AuditInterceptor.jav a:128) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191) at com.adventnet.logging.tracing.TracingInterceptor.invoke(TracingInterceptor.j ava:136) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinde rInterceptor.java:122) at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionConta iner.java:331) at org.jboss.ejb.Container.invoke(Container.java:709) at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFacto ry.java:419) at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionPro xy.java:83) at $Proxy98.executeWorkFlow(Unknown Source) at com.adventnet.workengine.executor.internal.RemoteWorkFlowExecutionHandler.ex ecute(RemoteWorkFlowExecutionHandler.java:77) at com.adventnet.workengine.internal.WorkEngineImpl$WorkFlowExecutorThread.run( WorkEngineImpl.java:923) at com.adventnet.workengine.service.ThreadPoolService$WorkerThread.run(ThreadPo olService.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 " ______________________________________________________________