Critical Errors while performing Scheduled Backups (8 different critical errors and their solutions)

When Backup Scheduling is enabled in ServiceDeskPlus-MSP under Admin tab-> Backup Scheduling -> Edit Scheduling, 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 notification under Admin tab–> Notification Rules–> Technician Notification.

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 and support file(s) to servicedeskplus-support@manageengine.com

Error Message java.io.IOException: There is not enough space on the disk at java.io.FileOutputStream.writeBytes(Native Method) at java.io.FileOutputStream.write(Unknown Source) at java.util.zip.DeflaterOutputStream.deflate(Unknown Source) at java.util.zip.DeflaterOutputStream.write(Unknown Source) at java.util.zip.ZipOutputStream.write(Unknown Source) at com.adventnet.servicedesk.tools.SDBackUp.zipDirectory(SDBackUp.java:1671) at com.adventnet.servicedesk.tools.SDBackUp.zipDirectory(SDBackUp.java:1645) at com.adventnet.servicedesk.tools.SDBackUp.zipDirectory(SDBackUp.java:1645) at com.adventnet.servicedesk.tools.SDBackUp.endBackup(SDBackUp.java:492) at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:97) at com.adventnet.servicedesk.setup.task.ScheduledBackupTask.executeTask(ScheduledBackupTask.java:87) 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

Note: Mostly,the first 2 lines of the Error Trace on the email, will provide a hint which can help in troubleshooting the error.

Below are some of the most common Error traces listed along with the solutions.

a. Error trace in logs:

java.io.IOException: The system cannot find the path specified at java.io.WinNTFileSystem.createFileExclusively(Native Method) at java.io.File.createNewFile(Unknown Source) at com.adventnet.servicedesk.tools.SDBackUp.createBuildInfoXml(SDBackUp.java:838) at com.adventnet.servicedesk.tools.SDBackUp.initBackup(SDBackUp.java:174) at……..


 Cause:

Under Admin -> Backup Scheduling -> Edit Scheduling, the location mentioned for the backup maybe invalid.

Solution:

Make sure you have mentioned the correct location for the backup.

b. Error trace in logs:

java.io.IOException: Access is denied at java.io.WinNTFileSystem.createFileExclusively(Native Method) at java.io.File.createNewFile(Unknown Source) at com.adventnet.servicedesk.tools.SDBackUp.createBuildInfoXml(SDBackUp.java:838) at com.adventnet.servicedesk.tools.SDBackUp.initBackup(SDBackUp.java:174) at……..

  java.io.FileNotFoundException: C:ManageEngineServiceDeskPlus-MSPackupackup_info.xml (The system cannot find the file specified) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.(Unknown Source) at com.adventnet.servicedesk.tools.SDBackUp.addToZip(SDBackUp.java:421) at com.adventnet.servicedesk.tools.SDBackUp.endBackup(SDBackUp.java:298) at……….

 Solution:

Check if the folder name mentioned in location field under Admin -> Backup Scheduling -> Edit Scheduling is like ‘folder name’ i.e. name with space .Please use the folder name without any space. 

Also, if this folder is shared, make sure the folder have all the read and write permissions.

c. Error trace in logs:

java.io.IOException: There is not enough space on the disk at java.io.FileOutputStream.writeBytes(Native Method) at java.io.FileOutputStream.write(Unknown Source) at sun.nio.cs.StreamEncoder$CharsetSE.writeBytes(Unknown Source) at………


 Cause:

The location mentioned under Admin -> Backup Scheduling -> Edit Scheduling may not have enough disk space.

Solution:

Make sure the disk have enough disk space. As of now ServiceDeskPlus-MSP does not provide an automated way of deleting the older backup so you can retain the last 5 to 10 backups and delete the rest manually.

d. Error trace in logs:

 java.sql.SQLException: Login failed for user ‘administrator’. Reason: The password of the account has expired. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at ……..

Cause:

The error occurs only in installation using MSSQL database. The password for the account ‘administrator’ in the SQL server would have got expired.

Solution:

Configure a new password for the MSSQL account used under C:\ManageEngine\ServiceDeskPlus-MSP\bin\ChangeDBServer.bat file for ServiceDeskPlus-MSP database and then run the script Changedbserver.bat to change the password.

NOTE: You will find the application connected to the database because of an existing open connection to the SQL Server. But due to SQL account password expiry, you will be unable to restart the application.

e. Error trace in logs:

java.lang.Exception: Unable to get the data from [aaaaccadminprofile] table at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:492) at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:511) at………

java.lang.Exception: Unable to get the data from [acboxconfig] table at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:492) at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:240) at……

 Cause:

This error occurs when ServiceDeskPlus-MSP is configured using MSSQL database and the database is set with case sensitive mode in the SQL server.

Solution:

Change the ‘COLLATION’ in the MSSQL server for the database of ServiceDeskPlus-MSP as CASE-INSENSITIVE. You can use the following query to update the same in MSSQL on the query editor:

ALTER DATABASE MyDatabase COLLATE SQL_Latin1_General_CP1_CI_AS;

NOTE: ‘MyDatabase’ in the query you have to replace with the database name. In most cases it is be ‘servicedesk’.

f. Error Trace in logs:

 

java.io.IOException: The device is not ready at java.io.WinNTFileSystem.createFileExclusively(Native Method at java.io.File.createNewFile (Unknown Source) at com.adventnet.servicedesk.tools.SDBackUp.createBuildInfoXml(SDBackUp.java:838) at …..

 

Cause:

The error occurs when the location mentioned under Admin -> Backup Scheduling -> Edit Scheduling is being used by another application for some purpose.This will lock the folder which might not allow our application to write the backup at the time scheduled.

Solution:

Please make sure you configure the location which is not used by any other application.

g. Error trace in logs:

java.sql.SQLException: No operations allowed after connection closed. Connection was closed due to the following exception: ** BEGIN NESTED EXCEPTION ** java.sql.SQLException MESSAGE: Communication link failure: java.net.SocketException, underlying cause: Software caused

connection abort: recv failed ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: Software caused connection abort: recv failed STACKTRACE: java.net.SocketException: Software caused…..

Cause:

This error occurs with installations configured on MSSQL database. While the scheduled backup is being performed, due to some network issue ,the connection between the ServiceDeskPlus-MSP and MSSQL server is closed.Thus,the backup process stops and ServiceDeskPlus-MSP triggers an error email.

Solution:

Try running a manual backup by executing backupdata.bat script under C:\ManageEngine\ServiceDeskPlus-MSP\bin and if you are able to take a complete backup, you can ignore the error you received. Next time the scheduled backup should run without any issues.

NOTE: When the application looses connection with MSSQL database, it will retry automatically to connect back to MSSQL. But the scheduled backup process will not retry and hence once a connection is closed the backup process will be stopped and you will receive an error mail.

h. Error trace in logs:

java.io.IOException: The specified network name is no longer available at java.io.FileOutputStream.writeBytes(Native Method) at java.io.FileOutputStream.write(Unknown Source) at sun.nio.cs.StreamEncoder$CharsetSE.writeBytes(Unknown Source) at sun.nio.cs.StreamEncoder$CharsetSE.implWrite(Unknown Source) at……

 

Cause:

This error usually occurs when the location field mentioned under Admin -> Backup Scheduling -> Edit Scheduling is on a network drive which is unreachable from the ServiceDeskPlus-MSP server at the scheduled time when backup process is suppose to run.

Solution:

Make sure the path mentioned in the location field is correct and reachable from the ServiceDeskPlus-MSP server. Also, make sure that the network folder has full read and write permission and path specified is in the below format 

\\machine_name\drive$\folder_name

 

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