BIRT Report fails if result set over 1000 work items

Megan Katysovas

(76●6●5) May 10 '12, 11:40 a.m.

I have a fairly simple report showing a table of work items. When deployed to the server, the report gives the below error when the result set is over 1000 work items. If less than 1000 work items, the report runs as expected.

I cannot replicate this issue in my local eclipse client due to the 1000 result set limitation that RTC / BIRT has set: https://jazz.net/forums/viewtopic.php?p=46631&sid=a20c7615953ad505a56698190d643a18

Any ideas on how to resolve this?

The following items have errors&#58;



TextData &#40;id = 5047&#41;&#58;

- Cannot execute the statement.



Cannot execute the statement. &#40; 1 time&#40;s&#41; &#41;

detail &#58; org.eclipse.birt.report.engine.api.EngineException&#58; Cannot execute the statement.

 at org.eclipse.birt.report.engine.executor.ExecutionContext.addException&#40;ExecutionContext.java&#58;1121&#41;

 at org.eclipse.birt.report.engine.executor.ExecutionContext.addException&#40;ExecutionContext.java&#58;1085&#41;

 at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery&#40;QueryItemExecutor.java&#58;88&#41;

 at org.eclipse.birt.report.engine.executor.DynamicTextItemExecutor.execute&#40;DynamicTextItemExecutor.java&#58;73&#41;

 at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute&#40;SuppressDuplicateItemExecutor.java&#58;42&#41;

 at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute&#40;WrappedReportItemExecutor.java&#58;45&#41;

 at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute&#40;LocalizedReportItemExecutor.java&#58;33&#41;

 at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes&#40;HTMLBlockStackingLM.java&#58;63&#41;

 at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout&#40;HTMLPageLM.java&#58;90&#41;

 at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout&#40;HTMLReportLayoutEngine.java&#58;101&#41;

 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun&#40;RunAndRenderTask.java&#58;151&#41;

 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run&#40;RunAndRenderTask.java&#58;72&#41;

 at com.ibm.team.reports.service.birt.internal.BirtReportEngineService.internalGetRenderedReport&#40;BirtReportEngineService.java&#58;672&#41;

 at com.ibm.team.reports.service.birt.internal.BirtReportEngineService.getRenderedReport&#40;BirtReportEngineService.java&#58;299&#41;

 at sun.reflect.GeneratedMethodAccessor307.invoke&#40;Unknown Source&#41;

 at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;43&#41;

 at java.lang.reflect.Method.invoke&#40;Method.java&#58;618&#41;

 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke&#40;ExportProxyServiceRecord.java&#58;370&#41;

 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0&#40;ExportProxyServiceRecord.java&#58;356&#41;

 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke&#40;ExportProxyServiceRecord.java&#58;56&#41;

 at $Proxy443.getRenderedReport&#40;Unknown Source&#41;

 at com.ibm.team.reports.service.internal.InternalReportService.getRenderedReport&#40;InternalReportService.java&#58;1098&#41;

 at sun.reflect.GeneratedMethodAccessor306.invoke&#40;Unknown Source&#41;

 at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;43&#41;

 at java.lang.reflect.Method.invoke&#40;Method.java&#58;618&#41;

 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke&#40;ExportProxyServiceRecord.java&#58;370&#41;

 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0&#40;ExportProxyServiceRecord.java&#58;356&#41;

 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke&#40;ExportProxyServiceRecord.java&#58;56&#41;

 at $Proxy213.getRenderedReport&#40;Unknown Source&#41;

 at com.ibm.team.reports.service.internal.ReportRestService$1.run&#40;ReportRestService.java&#58;421&#41;

 at com.ibm.team.reports.service.internal.ReportRestService.getRenderedReport&#40;ReportRestService.java&#58;428&#41;

 at com.ibm.team.reports.service.internal.ReportRestService.postRenderReport&#40;ReportRestService.java&#58;512&#41;

 at sun.reflect.GeneratedMethodAccessor312.invoke&#40;Unknown Source&#41;

 at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;43&#41;

 at java.lang.reflect.Method.invoke&#40;Method.java&#58;618&#41;

 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke&#40;ExportProxyServiceRecord.java&#58;370&#41;

 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0&#40;ExportProxyServiceRecord.java&#58;356&#41;

 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke&#40;ExportProxyServiceRecord.java&#58;56&#41;

 at $Proxy217.postRenderReport&#40;Unknown Source&#41;

 at sun.reflect.GeneratedMethodAccessor311.invoke&#40;Unknown Source&#41;

 at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;43&#41;

 at java.lang.reflect.Method.invoke&#40;Method.java&#58;618&#41;

 at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doModelledRestService&#40;AbstractTeamServerServlet.java&#58;571&#41;

 at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2&#40;AbstractTeamServerServlet.java&#58;1771&#41;

 at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest&#40;AbstractTeamServerServlet.java&#58;1642&#41;

 at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service&#40;AbstractTeamServerServlet.java&#58;1555&#41;

 at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;729&#41;

 at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service&#40;ServletManager.java&#58;180&#41;

 at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest&#40;ServletRegistration.java&#58;90&#41;

 at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias&#40;ProxyServlet.java&#58;111&#41;

 at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service&#40;ProxyServlet.java&#58;75&#41;

 at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;729&#41;

 at org.eclipse.equinox.servletbridge.BridgeServlet.service&#40;BridgeServlet.java&#58;121&#41;

 at com.ibm.team.repository.server.servletbridge.JazzServlet.service&#40;JazzServlet.java&#58;54&#41;

 at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;729&#41;

 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;269&#41;

 at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;188&#41;

 at org.apache.catalina.core.StandardWrapperValve.invoke&#40;StandardWrapperValve.java&#58;213&#41;

 at org.apache.catalina.core.StandardContextValve.invoke&#40;StandardContextValve.java&#58;172&#41;

 at org.apache.catalina.authenticator.AuthenticatorBase.invoke&#40;AuthenticatorBase.java&#58;525&#41;

 at org.apache.catalina.core.StandardHostValve.invoke&#40;StandardHostValve.java&#58;127&#41;

 at org.apache.catalina.valves.ErrorReportValve.invoke&#40;ErrorReportValve.java&#58;117&#41;

 at org.apache.catalina.core.StandardEngineValve.invoke&#40;StandardEngineValve.java&#58;108&#41;

 at org.apache.catalina.connector.CoyoteAdapter.service&#40;CoyoteAdapter.java&#58;174&#41;

 at org.apache.coyote.http11.Http11Processor.process&#40;Http11Processor.java&#58;873&#41;

 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection&#40;Http11BaseProtocol.java&#58;665&#41;

 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket&#40;PoolTcpEndpoint.java&#58;528&#41;

 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt&#40;LeaderFollowerWorkerThread.java&#58;81&#41;

 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run&#40;ThreadPool.java&#58;689&#41;

 at java.lang.Thread.run&#40;Thread.java&#58;811&#41;

Caused by&#58; org.eclipse.birt.data.engine.core.DataException&#58; Cannot execute the statement.

 at org.eclipse.birt.data.engine.executor.DataSourceQuery$OdaQueryExecutor.run&#40;DataSourceQuery.java&#58;935&#41;

 ... 1 more

1 vote

1 answer

5,234 views

1 vote

One answer

Permanent link

Rafik Jaouani

JAZZ DEVELOPER (5.0k●1●6) May 28 '12, 4:24 p.m.

This is as designed to prevent performance issues on the server when fetching live data. Have you tried finding the data in the data warehouse?

1 vote

Your answer

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers

Answers and Comments

Question details

rational-team-concert

× 42,912

Question asked: May 10 '12, 11:40 a.m.

Question was seen: 5,234 times

Last updated: May 10 '12, 11:40 a.m.

BIRT Report fails if result set over 1000 work items

Megan Katysovas

1 answer

5,234 views

1 vote

One answer

Rafik Jaouani

Your answer

Follow this question

Question details

Related questions