Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » NPE in birt 4.2.2(I get a npe running a report migrated from 2.5.x to 4.2.2)
NPE in birt 4.2.2 [message #1038958] Thu, 11 April 2013 10:49 Go to next message
Eclipse UserFriend
Dear all,

First of all regards for your time and interest on reading this post.

The current problem is that when I run a report in a webapp with the birt engine 4.2.2 (got from maven repository), I get a a NPE in the middle of the execution. For example, if I run it in HTML output, it cuts the report and unexpectedly finish, in PDF output it is bad formed.

i am attaching the rpt design and the complete stack trace.

Thank you so much!

J

10-abr-2013 17:36:57 org.eclipse.birt.report.engine.api.impl.EngineTask handleFatalExceptions
GRAVE: An error happened while running the report. Cause:
java.lang.NullPointerException
at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.getCurrentResultIndex(CachedResultSet.java:499)
at org.eclipse.birt.data.engine.script.JSResultSetRow.get(JSResultSetRow.java:135)
at org.mozilla.javascript.ScriptableObject.getProperty(ScriptableObject.java:1617)
at org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRuntime.java:1390)
at org.mozilla.javascript.ScriptRuntime.getObjectElem(ScriptRuntime.java:1372)
at org.mozilla.javascript.gen.c38._c0(<inline>:0)
at org.mozilla.javascript.gen.c38.call(<inline>)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:398)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3065)
at org.mozilla.javascript.gen.c38.call(<inline>)
at org.mozilla.javascript.gen.c38.exec(<inline>)
at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:99)
at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(JavascriptEvalUtil.java:138)
at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:992)
at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evalExpr(ScriptEvalUtil.java:928)
at org.eclipse.birt.data.engine.olap.impl.query.CubeQueryExecutor.createSimpleLevelFilter(CubeQueryExecutor.java:198)
at org.eclipse.birt.data.engine.olap.impl.query.CubeQueryExecutor.populateFilterHelpers(CubeQueryExecutor.java:343)
at org.eclipse.birt.data.engine.olap.impl.query.CubeQueryExecutor.<init>(CubeQueryExecutor.java:119)
at org.eclipse.birt.data.engine.olap.impl.query.CubeQueryResults.createCursor(CubeQueryResults.java:279)
at org.eclipse.birt.data.engine.olap.impl.query.CubeQueryResults.getCubeCursor(CubeQueryResults.java:161)
at org.eclipse.birt.report.engine.data.dte.CubeResultSet.<init>(CubeResultSet.java:98)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteCube(DteDataEngine.java:253)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:272)
at org.eclipse.birt.report.engine.executor.ExecutorManager$ExecutorContext.executeQuery(ExecutorManager.java:447)
at org.eclipse.birt.report.item.crosstab.core.re.executor.BaseCrosstabExecutor.executeQuery(BaseCrosstabExecutor.java:122)
at org.eclipse.birt.report.item.crosstab.core.re.executor.CrosstabReportItemExecutor.execute(CrosstabReportItemExecutor.java:102)
at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.traverse(HTMLAbstractLM.java:441)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.traverse(HTMLAbstractLM.java:442)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.traverse(HTMLAbstractLM.java:442)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.traverse(HTMLAbstractLM.java:442)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.traverse(HTMLAbstractLM.java:442)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.traverse(HTMLAbstractLM.java:442)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.handleVisibility(HTMLAbstractLM.java:374)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:123)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLGroupLM.layoutChildren(HTMLGroupLM.java:117)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLGroupLM.layoutChildren(HTMLGroupLM.java:117)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLListLM.layoutChildren(HTMLListLM.java:72)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
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:181)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at org.unctad.framework.reporting.RunAndRenderReportTask.run(RunAndRenderReportTask.java:202)
at org.unctad.framework.reporting.UserDefinedReportF2ServiceImpl.runReport(UserDefinedReportF2ServiceImpl.java:70)
at org.unctad.framework.reporting.ReportCommonData.executeReport(ReportCommonData.java:135)
at org.unctad.framework.reporting.ReportingServiceImpl.selectAndRunReport(ReportingServiceImpl.java:30)
at org.unctad.framework.reporting.ReportingServiceImpl$$FastClassByCGLIB$$c8eadc8e.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at org.unctad.framework.reporting.ReportingServiceImpl$$EnhancerByCGLIB$$649ef113.selectAndRunReport(<generated>)
at org.unctad.framework.reporting.ReportServlet.doGet(ReportServlet.java:218)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)
at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)
at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)
at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at org.unctad.framework.security.filter.SecurityTraceFilter.doFilter(SecurityTraceFilter.java:37)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
Re: NPE in birt 4.2.2 [message #1039994 is a reply to message #1038958] Fri, 12 April 2013 18:50 Go to previous messageGo to next message
Eclipse UserFriend
Well, it appears to be an issue with a result set. In HTML does it cut at the same point each time? Is some of the report visible? If so, where does it cut off? That might help you figure out which dataSet it's having issue with. If there is no output, can you try writing out to a text file from each dataSet to see where the report fails?
Re: NPE in birt 4.2.2 [message #1043351 is a reply to message #1039994] Wed, 17 April 2013 11:39 Go to previous messageGo to next message
Eclipse UserFriend
Michael Williams wrote on Fri, 12 April 2013 18:50
Well, it appears to be an issue with a result set. In HTML does it cut at the same point each time? Is some of the report visible? If so, where does it cut off? That might help you figure out which dataSet it's having issue with. If there is no output, can you try writing out to a text file from each dataSet to see where the report fails?



Dear Michael,

These reports where ok till we migrated from the 2.5 engine to the 4.2.2 engine.

The HTML output always cuts in the same part or section each time, and it is visible untill it finishes . It is the details section that contains a list of groups, it is the report on itself, I mean de iterable part. In PDF we just get a malformed document.

We see which dataset fails, but we can't see why.

thanks in advance

JH
Re: NPE in birt 4.2.2 [message #1043678 is a reply to message #1043351] Wed, 17 April 2013 21:56 Go to previous messageGo to next message
Eclipse UserFriend
Could you tell me which dataSet fails so that when I look in the above report I know better on where to look for where the problem might be? Thanks.
Re: NPE in birt 4.2.2 [message #1044360 is a reply to message #1043678] Thu, 18 April 2013 16:32 Go to previous messageGo to next message
Eclipse UserFriend
Michael Williams wrote on Wed, 17 April 2013 21:56
Could you tell me which dataSet fails so that when I look in the above report I know better on where to look for where the problem might be? Thanks.


Dear Michael,

Doing a debug of the BIRT sources while generating the report we found that the Cube/Data Set that is failing is the one involving the following information:

Name:
Data Cube - SubTotal_Break2

Dimensions:
Group - Subtotal_Break2_Cols

Data Set:
Data Set - SubTotal_Break2

BindingList:
BREAK1_VAL_1
BREAK1_VAL_2
CU_BASE
UDR_COL_SEQ
aggrFunc: SUM AMT2_Group - Subtotal_Break2_Cols/UDR_COL_SEQ
aggrFunc: SUM AMT2_Group - Subtotal_Break2_Rows/CU_BASE
aggrFunc: SUM AMT2_Group - Subtotal_Break2_Rows/CU_BASE_Group - Subtotal_Break2_Cols/UDR_COL_SEQ
aggrFunc: FIRST PERCENTAGE8_Group - Subtotal_Break2_Rows/CU_BASE_Group - Subtotal_Break2_Cols/UDR_COL_SEQ

does it help?

thanks in advance!

JH
Re: NPE in birt 4.2.2 [message #1045062 is a reply to message #1044360] Fri, 19 April 2013 14:10 Go to previous messageGo to next message
Eclipse UserFriend
If you remove the crosstab associated with this cube, does the report run fine?
Re: NPE in birt 4.2.2 [message #1045128 is a reply to message #1045062] Fri, 19 April 2013 16:34 Go to previous messageGo to next message
Eclipse UserFriend
Michael Williams wrote on Fri, 19 April 2013 14:10
If you remove the crosstab associated with this cube, does the report run fine?


We have just done that test, with no success, it remains the same error. After that, we also deleted other crosstabs, but again with no success.
Re: NPE in birt 4.2.2 [message #1048511 is a reply to message #1045128] Wed, 24 April 2013 11:16 Go to previous messageGo to next message
Eclipse UserFriend
I think I might see an issue. In all of your filters, your outer values are defined by data._outer. The outer element is a list which uses "row". Try changing all of the data._outer values to row._outer. This could explain why it makes it part way down the page before breaking. Let me know.
Re: NPE in birt 4.2.2 [message #1048556 is a reply to message #1038958] Wed, 24 April 2013 12:36 Go to previous messageGo to next message
Eclipse UserFriend
ok, we'll try those test and will write you again.

regards!

JH
Re: NPE in birt 4.2.2 [message #1048648 is a reply to message #1048556] Wed, 24 April 2013 15:32 Go to previous messageGo to next message
Eclipse UserFriend
Sounds good.
Re: NPE in birt 4.2.2 [message #1049946 is a reply to message #1048648] Fri, 26 April 2013 09:41 Go to previous message
Eclipse UserFriend
Good Call Michael!! It completely solved the problem in the reports with this issue!! We performed a massive row._outer replacement into the reports and it worked fine! As I said in the subject of this thread, we are migrating from 2.5 to 4.2.2, and this solution unlocks us to continue with this migration. Hope this helps for future generations lol Very Happy.

Thanks you and regards for your time and cooperation! remarkable!

Juan Holder
Previous Topic:EMF Cross Reference : Resolve eProxy ?
Next Topic:Supporting Multiple SQL Servers
Goto Forum:
  


Current Time: Thu May 15 21:48:38 EDT 2025

Powered by FUDForum. Page generated in 0.04549 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly