Hi experts!
EPM 11.2
We have a large report which could run using FR Batch Scheduler. It worked fine on EPM 11.1. But now it fails with error each time after 120 minutes running:
ADM Error processing results from query: An unexpected communication error has occurred
[SRC_CLASS: com.hyperion.reporting.results.ExecGrid] [SRC_METHOD: executeGridObject] 5203; nested exception is: [[ com.hyperion.ap.APException: [0] An unexpected communication error has occurred. com.hyperion.reporting.util.HyperionReportException: ADM Error processing results from query: An unexpected communication error has occurred. at com.hyperion.reporting.haradm.HFMDataQuery.processAdmQueries(HFMDataQuery.java:2347) at com.hyperion.reporting.haradm.HFMDataQuery.execute(HFMDataQuery.java:3184) at com.hyperion.reporting.results.ExecGrid.executeGridObject(ExecGrid.java:1357) at com.hyperion.reporting.results.ExecGrid.executeGridObject(ExecGrid.java:169) at com.hyperion.reporting.results.ExecReport.executeReport(ExecReport.java:612) at com.hyperion.reporting.reportserver.FetchInstanceThread.runDesign(FetchInstanceThread.java:199) at com.hyperion.reporting.reportserver.FetchInstanceThread.run(FetchInstanceThread.java:126) Caused by: com.hyperion.ap.APException: [0] An unexpected communication error has occurred. at oracle.adm.results.DataQueryResults.getDataForPage(DataQueryResults.java:252) at oracle.adm.results.DataQueryResults.cachePageIfRequired(DataQueryResults.java:279) at oracle.adm.results.DataQueryResults.getQueryDataSize(DataQueryResults.java:438) at oracle.adm.session.ADMDriverSession.HssQryGetDataSize(ADMDriverSession.java:2345) at com.oracle.hfm.HsvADMDriver.HssQryGetDataSize(HsvADMDriver.java:1007) at com.hyperion.ap.adm.HssConnSessionWrapper.HssQryGetDataSize(HssConnSessionWrapper.java:2228) at com.hyperion.ap.adm.HssQryCubeViewEdge.getRowCount(HssQryCubeViewEdge.java:1707) at com.hyperion.ap.adm.HssQryCubeViewEdge.getResultCount(HssQryCubeViewEdge.java:693) at com.hyperion.reporting.haradm.HFMDataQuery.processAdmQueries(HFMDataQuery.java:1740) ... 6 more ]]
Is the issue in some timeout setting? Couldn't find it yet.