Bursting Report To File System Behaving Strangely
Hi Everyone,
There is no issue when the main query has a where condition as rownum < 100.
When the WHERE clause is removed or main query is run without the condition, the below error is observed in the xdo.log file =>
[030415_090940388][][STATEMENT] ToplinkDataHandler.getOutput() : called
[030415_090940388][][STATEMENT] Default read connection pool max:20, min:10, total:10, available:10
[030415_090940389][oracle.apps.xdo.servlet.scheduler.XDOJob][EXCEPTION] [ID:29651] Unexpected exception occurred while running the job.
oracle.apps.xdo.servlet.scheduler.ProcessingException: java.lang.NullPointerException
at oracle.apps.xdo.servlet.scheduler.XDOJob.runBurstingReport(XDOJob.java:2184)
at oracle.apps.xdo.servlet.scheduler.XDOJob.execute(XDOJob.java:372)
at org.quartz.core.JobRunShell.run(JobRunShell.java:195)