I received a message from my Service Desk that the scheduled backup cannot be completed successfully.
Dear Admin,
Unable to take the backup of ServiceDesk Plus, So please contact your database Administrator [OR]
java.io.FileNotFoundException: ..\fileAttachments\Request\Aug2012\1600 (The process cannot access the file because it is being used by another process) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.(Unknown Source) at com.adventnet.servicedesk.tools.SDBackUp.zipDirectory(SDBackUp.java:1656) at com.adventnet.servicedesk.tools.SDBackUp.zipDirectory(SDBackUp.java:1652) at com.adventnet.servicedesk.tools.SDBackUp.zipDirectory(SDBackUp.java:1652) at com.adventnet.servicedesk.tools.SDBackUp.endBackup(SDBackUp.java:497) at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:97) 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)
• 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
I dont want to stop the backup scheduling since I still need and hence need to see how I can sort this out.
I just removed the attachment from request Id 1600 and tried the backup but this did not sort out the issue.
Any ideas on how to sort this out will be appreciated.