Good Day

I am failing to generate an asset audit report, I have tried renaming

the report folder to report_old but the issue still persists.

Message

Dear user,

Unable to generate the report you have scheduled, So please contact

your Administrator [OR]

servicedesk support for further assistance to resolve the issue and

forward this mail and support file(s) to

Report Title : Audit history by Changes

Your Message :

Error Trace

org.postgresql.util.PSQLException: ERROR: syntax error at or near

"GROUP" Position: 7447 at

org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)

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:374)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)

at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:250)

at com.adventnet.servicedesk.reports.utils.ReportUtil.getSQLColumns(ReportUtil.java:2873)

at com.adventnet.servicedesk.reports.utils.AuditReportUtil.getQueryColumnDetails(AuditReportUtil.java:708)

at com.adventnet.servicedesk.reports.utils.AuditReportUtil.generateReport(AuditReportUtil.java:370)

at com.adventnet.servicedesk.reports.utils.AuditReportUtil.generateCompiledReport(AuditReportUtil.java:146)

at com.adventnet.servicedesk.report.task.ScheduledReportTask.generateReport(ScheduledReportTask.java:355)

at com.adventnet.servicedesk.report.task.ScheduledReportTask.executeTask(ScheduledReportTask.java:159)

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:933)

at com.adventnet.workengine.service.ThreadPoolService$WorkerThread.run(ThreadPoolService.java:256)

at java.lang.Thread.run(Unknown Source