<p>[color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]I have design one report with Actuate 2.3.2 and deploy on iServer SP 11 . Report is running fine with small db but when it was run against huge DB, it is not giving results and throwing error in a popup after 5 min.[/color]<br />
</p><p>ORA-01013 : user requested cancel of current operation</p><p> </p><p>[color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]I need to find out if there is a configuration setting I can change to set the wait time for query results. [/color]<br />
<br />
[color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;font-size:14px;]Below are the logs :- [/color]</p><p><span style="font-size:14px;">AcOndemandServerManager:</span></p><div> New on-demand server activated:</div><div> Server process ID: 94900Resource group name: Default BIRT 360Max threads: 8</div><div> </div><div>****0106244976*applevellock.cpp*00172*PRGRM*2014MAY15*12:43:15</div><div> Trying to acquire application lock: /opt/actuate/AcServer/data/config/11SP3/acconfig.lock</div><div>****0106244976*applevellock.cpp*00330*PRGRM*2014MAY15*12:43:15</div><div> Trying to release application lock: /opt/actuate/AcServer/data/config/11SP3/acconfig.lock</div><div>****0106244976*applevellock.cpp*00330*PRGRM*2014MAY15*12:43:15</div><div> Released application lock: /opt/actuate/AcServer/data/config/11SP3/acconfig.lock</div><div>****0157617008*reJobMgr.cpp*01370*08000*2014MAY15*12:49:01</div><div> Job execution failed because it was cancelled: Cannot execute the statement.</div><div> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.</div><div> SQL error #1:[ActuateDD][Oracle JDBC Driver][Oracle]ORA-01013: user requested cancel of current operation</div><div> </div><div> ;</div><div> java.sql.SQLException: [ActuateDD][Oracle JDBC Driver][Oracle]ORA-01013: user requested cancel of current operation</div><div> (Element ID:365)</div><div> Job Type = Sync Transient</div><div> WriteLockHandle = 1</div><div>****0115719024*soapOpsJob.cpp*00464*08000*2014MAY15*12:49:01</div><div> RunSyncJob() failed: Cannot execute the statement.</div><div> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.</div><div> SQL error #1:[ActuateDD][Oracle JDBC Driver][Oracle]ORA-01013: user requested cancel of current operation</div><div> </div><div> ;</div><div> java.sql.SQLException: [ActuateDD][Oracle JDBC Driver][Oracle]ORA-01013: user requested cancel of current operation</div><div> (Element ID:365)</div><div>****0115719024*applevellock.cpp*00172*PRGRM*2014MAY15*12:50:31</div><div> Trying to acquire application lock: /opt/actuate/AcServer/data/config/11SP3/acconfig.lock</div><div>****0115719024*applevellock.cpp*00330*PRGRM*2014MAY15*12:50:31</div><div> Trying to release application lock: /opt/actuate/AcServer/data/config/11SP3/acconfig.lock</div><div>****0115719024*applevellock.cpp*00330*PRGRM*2014MAY15*12:50:31</div><div> Released application lock: /opt/actuate/AcServer/data/config/11SP3/acconfig.lock</div><div>****0106244976*applevellock.cpp*00172*PRGRM*2014MAY15*12:50:35</div><div> Trying to acquire application lock: /opt/actuate/AcServer/data/config/11SP3/acconfig.lock</div><div>****0106244976*applevellock.cpp*00330*PRGRM*2014MAY15*12:50:35</div>
