Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
maximum queries allowed by the system has been exceeded
Mqueue
Trying to understand, what has gone wrong:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
****0000025131*soapOpsJob.cpp*05733*08000*2012MAR12*22:08:20
RunSyncJob() failed: Report generation failed. The report generation took longer than the time allowed.
****0000043895*reJobMgr.cpp*01351*08000*2012MAR12*22:08:42
Job execution failed because it was cancelled: Report generation failed. The report generation took longer than the time all
owed.
Job Type = Sync Transient
WriteLockHandle = 513
****0000021583*soapOpsJob.cpp*05733*08000*2012MAR12*22:08:42
RunSyncJob() failed: Report generation failed. The report generation took longer than the time allowed.
encycsrvr10.10879420.t03.2012MAR12_16_49_53_EST.1.log: END
</pre>
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
[Thread-12, RequestID-t03--2012-03-12 21:52:31--398] Mar 12, 2012 9:53:25 PM org.eclipse.birt.data.engine.odaconsumer.Connection prepareOdaQuery
SEVERE: Cannot prepare statement.
com.actuate.oda.adapter.dtp.OdaAdapterException: The maximum queries allowed by the system has been exceeded. Please try again later or see your systems administrator.
at com.actuate.oda.adapter.dtp.Query.prepare(DashoA1*..)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doPrepare(OdaQuery.java:210)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.prepare(OdaQuery.java:167)
at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareOdaQuery(Connection.java:222)
at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareStatement(Connection.java:159)
at org.eclipse.birt.data.engine.executor.DataSource.prepareStatement(DataSource.java:309)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:256)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:345)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:331)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:498)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:189)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:177)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:482)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:115)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:79)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1755)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:104)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:153)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:68)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27)
at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:76)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:68)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:211)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:116)
at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(Unknown Source)
at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(Unknown Source)
at com.actuate.reportapi.engine.Task.execute(Unknown Source)
at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
at java.lang.Thread.run(Thread.java:735)
</pre>
Find more posts tagged with
Comments
Mqueue
I was advised to tune the following config file to see if that helps...such things usually happens in load test...<br />
<br />
$AC_SERVER_HOME/encyc - acserverconfig.xml<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'><IntegrationService
LogDirectory="/local/sys/actuate10/AcServer/log"
EnableIntegrationService="true"/></pre>
<br />
To that add the following entry MaxConcurrentQueries="100" to make it look like below (Default is 50):<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'><IntegrationService
LogDirectory="/local/sys/actuate10/AcServer/log"
MaxConcurrentQueries="150"
EnableIntegrationService="true"/></pre>
RSiegler
Mqueue,
The default setting for MaxConcurrentQueries is set to 50, however it is not a setting that can be altered through the UI of Configuration Console by default.
I would suggest opening a case with Actuate support with regards to this issue.
Mqueue
yes that's not a setting you can set thru the UI interface. such setting is configured on the encyc/acserverconfig.xml file. Apparently the default setting is not even stated in the configuration file so it can be set. yes opening a case with Actuate would help.