[SOLVED]Error with sending scheduled report to email [SD-80239]

[SOLVED]Error with sending scheduled report to email [SD-80239]

Greetings,

We have an issue with 10.5 Build 10506 + PostgreSQL. When I create a schedule report like this one:

  1. SELECT ti.FIRST_NAME "Technician",std.STATUSNAME "Request Status",count(wo.WORKORDERID) "Request Count" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (wo.ISPARENT='1') AND wo.CREATEDTIME >= <from_thismonth> AND wo.CREATEDTIME <= <to_thismonth> GROUP BY  ti.FIRST_NAME ,std.STATUSNAME order by 1
It works fine, but when I create a schedule report and try to send it to my email I have an error:

  1. org.postgresql.util.PSQLException: Cannot change transaction read-only property in the middle of a transaction. at org.postgresql.jdbc.PgConnection.setReadOnly(PgConnection.java:693) at com.zoho.cp.LogicalConnection.setReadOnly(LogicalConnection.java:708) at com.adventnet.servicedesk.reports.utils.CoreReportDesigner.generateSQLReport(CoreReportDesigner.java:8160) at com.adventnet.servicedesk.reports.utils.CoreReportDesigner.generateSQLReport(CoreReportDesigner.java:7965) at com.adventnet.servicedesk.report.task.ScheduledReportTask.generateReport(ScheduledReportTask.java:486) at com.adventnet.servicedesk.report.task.ScheduledReportTask.executeTask(ScheduledReportTask.java:181) at com.adventnet.taskengine.internal.SchedulerBean.executeTask(SchedulerBean.java:631) at sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.adventnet.mfw.bean.BeanProxy.invoke(BeanProxy.java:53) at com.sun.proxy.$Proxy4.executeTask(Unknown Source) at com.adventnet.taskengine.internal.ScheduleExecutor.executeNextTask(ScheduleExecutor.java:148) at com.adventnet.taskengine.internal.ScheduleExecutor.run(ScheduleExecutor.java:76) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)


Our previous employee has quit and put it without a resolve, could please somebody helps to resolve the issue?

                  New to ADSelfService Plus?