Bug 355295 - Birt report showing error message when i add running count.
Summary: Birt report showing error message when i add running count.
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: unspecified   Edit
Hardware: PC Linux
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Birt-Report-inbox@eclipse.org CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on: 352397
Blocks:
  Show dependency tree
 
Reported: 2011-08-20 09:15 EDT by prashant CLA
Modified: 2012-01-08 10:05 EST (History)
5 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description prashant CLA 2011-08-20 09:15:14 EDT
Build Identifier: Eclipse indigo

org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report.
This is erron message displayed after adding running count in Birt report.
and if i removed running count then its working properly.


Reproducible: Always

Steps to Reproduce:
1.Report showing proper reult of dataset.
2.Add running count aggregation function giving follwing error
3.org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report.
Comment 1 Bob Tiernay CLA 2011-09-22 22:44:32 EDT
This looks related to 352397
Comment 2 Xiaoying Gu CLA 2011-10-24 04:13:18 EDT
I can't reproduce this issue with latest birt.
If you can still reproduce it,could you provide more detail information about how to reproduce it or a sample report I can test with.
Comment 3 Bob Tiernay CLA 2011-10-24 08:24:12 EDT
Please try using the report attached to 352397
Comment 4 Xiaoying Gu CLA 2011-10-27 02:49:37 EDT
(In reply to comment #3)
> Please try using the report attached to 352397

Yes, I tried the report in 352397.
No any exception or any error log when run this report.
Comment 5 Bob Tiernay CLA 2011-10-27 10:57:41 EDT
I have confirmed this is still failing with BIRT 3.7.1.v20110905. 

The exact error in the attached 352397 report is:

The following items have errors:

Chart (id = 9):
- null (Element ID:9)
null ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: null (Element ID:9)
	at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1214)
	at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.processExtendedContent(LocalizedContentVisitor.java:1045)
	at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localizeForeign(LocalizedContentVisitor.java:578)
	at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localize(LocalizedContentVisitor.java:163)
	at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:37)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
	at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
	at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
	at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:929)
	at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)
	at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:131)
	at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
	at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
	at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
	at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
	at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
	at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
	at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
	at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
	at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
	at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
	at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
	at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
	at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
	at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
	at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
	at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
	at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
	at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:317)
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390)
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.Server.handle(Server.java:322)
	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
	at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:939)
	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
	at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: org.eclipse.birt.chart.exception.ChartException
	at org.eclipse.birt.chart.internal.datafeed.DataProcessor.mapToChartResultSet(DataProcessor.java:372)
	at org.eclipse.birt.chart.internal.datafeed.DataProcessor.generateRuntimeSeries(DataProcessor.java:507)
	at org.eclipse.birt.chart.factory.Generator.bindData(Generator.java:652)
	at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.bindData(ChartReportItemPresentationBase.java:729)
	at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.onRowSets(ChartReportItemPresentationBase.java:860)
	at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationProxy.onRowSets(ChartReportItemPresentationProxy.java:108)
	at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.processExtendedContent(LocalizedContentVisitor.java:1022)
	... 58 more
Caused by: java.lang.NullPointerException
	at org.eclipse.birt.core.util.IOUtil.writeInt(IOUtil.java:226)
	at org.eclipse.birt.core.util.IOUtil.writeObject(IOUtil.java:674)
	at org.eclipse.birt.data.engine.executor.transform.SimpleGroupCalculator.next(SimpleGroupCalculator.java:233)
	at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.next(SimpleResultSet.java:562)
	at org.eclipse.birt.data.engine.executor.transform.ResultSetWrapper.next(ResultSetWrapper.java:81)
	at org.eclipse.birt.data.engine.impl.ResultIterator.hasNextRow(ResultIterator.java:584)
	at org.eclipse.birt.data.engine.impl.ResultIterator.nextRow(ResultIterator.java:525)
	at org.eclipse.birt.data.engine.impl.ResultIterator.next(ResultIterator.java:475)
	at org.eclipse.birt.chart.reportitem.BaseGroupedQueryResultSetEvaluator.next(BaseGroupedQueryResultSetEvaluator.java:412)
	at org.eclipse.birt.chart.internal.datafeed.DataProcessor.evaluateRowSet(DataProcessor.java:1466)
	at org.eclipse.birt.chart.internal.datafeed.DataProcessor.mapToChartResultSet(DataProcessor.java:368)
	... 64 more



What version are you using to test?
Comment 6 Xiaoying Gu CLA 2011-11-09 22:19:29 EST
I tried again using 3.7.1.v20110905.
No any exception or any error log when run this report.
Comment 7 Phil Freeman CLA 2011-12-13 18:27:47 EST
I'm still seeing this in:

Version: 3.7.1.v20110905-809u7NFT0z0-TWCm5MjN7w
Build id: v20110905-1820
Comment 8 Bob Tiernay CLA 2011-12-13 19:41:24 EST
(In reply to comment #7)
> I'm still seeing this in:
> 
> Version: 3.7.1.v20110905-809u7NFT0z0-TWCm5MjN7w
> Build id: v20110905-1820

Could you please verify with the report attached to #352397? Thanks
Comment 9 Phil Freeman CLA 2011-12-13 19:50:23 EST
I try running the report attached to #352397, and I get a:

The following items have errors: 


Chart (id = 9): 
+ null (Element ID:9) 



and it doesn't complete.  I'm not familiar enough with charts to see what's happening.

Thanks,

Phil
Comment 10 Bob Tiernay CLA 2011-12-13 19:59:20 EST
(In reply to comment #9)
> I try running the report attached to #352397, and I get a:
> 
> The following items have errors: 
> 
> 
> Chart (id = 9): 
> + null (Element ID:9) 
> 
> 
> 
> and it doesn't complete.  I'm not familiar enough with charts to see what's
> happening.
> 
> Thanks,
> 
> Phil

Hi Phil,

Click on the + sign in the editor, and copy and paste the stacktrace into the bug report.

Thanks
Comment 11 Phil Freeman CLA 2011-12-13 20:06:51 EST
Here you go.  Sorry about that:


The following items have errors: 


Chart (id = 9): 
- null (Element ID:9) 
null ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: null (Element ID:9)
	at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1214)
	at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.processExtendedContent(LocalizedContentVisitor.java:1045)
	at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localizeForeign(LocalizedContentVisitor.java:578)
	at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.localize(LocalizedContentVisitor.java:163)
	at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:37)
	at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
	at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
	at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
	at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:929)
	at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)
	at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:131)
	at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
	at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
	at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
	at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
	at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
	at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
	at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
	at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
	at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
	at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
	at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
	at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
	at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
	at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
	at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
	at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
	at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
	at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:317)
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390)
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.Server.handle(Server.java:326)
	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
	at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:939)
	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
	at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: org.eclipse.birt.chart.exception.ChartException
	at org.eclipse.birt.chart.internal.datafeed.DataProcessor.mapToChartResultSet(DataProcessor.java:372)
	at org.eclipse.birt.chart.internal.datafeed.DataProcessor.generateRuntimeSeries(DataProcessor.java:507)
	at org.eclipse.birt.chart.factory.Generator.bindData(Generator.java:652)
	at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.bindData(ChartReportItemPresentationBase.java:729)
	at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationBase.onRowSets(ChartReportItemPresentationBase.java:860)
	at org.eclipse.birt.chart.reportitem.ChartReportItemPresentationProxy.onRowSets(ChartReportItemPresentationProxy.java:108)
	at org.eclipse.birt.report.engine.presentation.LocalizedContentVisitor.processExtendedContent(LocalizedContentVisitor.java:1022)
	... 58 more
Caused by: java.lang.NullPointerException
	at org.eclipse.birt.core.util.IOUtil.writeInt(IOUtil.java:226)
	at org.eclipse.birt.core.util.IOUtil.writeObject(IOUtil.java:674)
	at org.eclipse.birt.data.engine.executor.transform.SimpleGroupCalculator.next(SimpleGroupCalculator.java:233)
	at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.next(SimpleResultSet.java:562)
	at org.eclipse.birt.data.engine.executor.transform.ResultSetWrapper.next(ResultSetWrapper.java:81)
	at org.eclipse.birt.data.engine.impl.ResultIterator.hasNextRow(ResultIterator.java:584)
	at org.eclipse.birt.data.engine.impl.ResultIterator.nextRow(ResultIterator.java:525)
	at org.eclipse.birt.data.engine.impl.ResultIterator.next(ResultIterator.java:475)
	at org.eclipse.birt.chart.reportitem.BaseGroupedQueryResultSetEvaluator.next(BaseGroupedQueryResultSetEvaluator.java:412)
	at org.eclipse.birt.chart.internal.datafeed.DataProcessor.evaluateRowSet(DataProcessor.java:1466)
	at org.eclipse.birt.chart.internal.datafeed.DataProcessor.mapToChartResultSet(DataProcessor.java:368)
	... 64 more


Also, for whatever reason, the RunningCount is now working.  I have no idea what changed.  I spent some time trying to get a workaround, and went back and tried it, and it's not erroring out anymore.  If it errors out again, I will try to reproduce it.

Thanks.
Comment 12 Bob Tiernay CLA 2011-12-13 20:19:54 EST
So, this is fairly easy to reproduce:

1. Download birt build from eclipse
2. Run attached report in 352397

I don't know if the birt devs are using production releases, but I have tried this a few times with the most basic eclipse release with birt preinstalled and it shows up every time.
Comment 13 Xiaoying Gu CLA 2011-12-15 02:18:27 EST
(In reply to comment #12)
> So, this is fairly easy to reproduce:
> 
> 1. Download birt build from eclipse
> 2. Run attached report in 352397
> 
> I don't know if the birt devs are using production releases, but I have tried
> this a few times with the most basic eclipse release with birt preinstalled and
> it shows up every time.


Can you give me the link you download?
So I can use the same release to reproduce.

Thanks.
Comment 14 Bob Tiernay CLA 2011-12-15 10:13:45 EST
Just tested this again with the following binary and 352397 attached report and it is still failing:

http://www.eclipse.org/downloads/download.php?file=/technology/epp/downloads/release/indigo/SR1/eclipse-reporting-indigo-SR1-linux-gtk.tar.gz
Comment 15 Xiaoying Gu CLA 2011-12-15 21:24:11 EST
Thank you.
I can reproduce in this release.
But I can't reproduce in latest 3.7.2.I think it has been fixed.
Please contact here if you still can reproduce in 3.7.2
Comment 16 Bob Tiernay CLA 2012-01-08 10:05:14 EST
(In reply to comment #15)
> Thank you.
> I can reproduce in this release.
> But I can't reproduce in latest 3.7.2.I think it has been fixed.
> Please contact here if you still can reproduce in 3.7.2

As far as I know, there is no release, milestone, or publically available nightly of 3.7.2. Do you have a link? Is there an estimate of when this will be released?

Thanks.