Backups failing

Hello,

we have been receiving this error message on one of our SD+ Standard servers running build 9201

It has happened every day for the last 5 days, first failure occurred on the 17th of March. Backups are scheduled to run daily. All other servers running build 9201 have no issue, server has 4GB memory and is only running SD+ on it, and backups have been running fine for the last two years without this issue.

Dear Admin,

Unable to take the backup of ServiceDesk Plus, 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

org.postgresql.util.PSQLException: Ran out of memory retrieving query results. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1817) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) at com.adventnet.servicedesk.tools.SDBackUp.dumpTableUsingCriteria(SDBackUp.java:1416) at com.adventnet.servicedesk.tools.SDBackUp.dumpTable(SDBackUp.java:1093) at com.adventnet.servicedesk.tools.SDBackUp.startBackup(SDBackUp.java:366) at com.adventnet.servicedesk.tools.SDBackUp.process(SDBackUp.java:101) at com.adventnet.servicedesk.setup.task.ScheduledBackupTask.executeTask(ScheduledBackupTask.java:93) 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) Caused by: java.lang.OutOfMemoryError: Java heap space

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 assistance would be much appreciated thanks.

Cheers

Siobhan