Eclipse Community Forums: BIRT » NPE in birt 4.2.2

Help

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)

Show: Today's Messages :: Show Polls :: Message Navigator

NPE in birt 4.2.2 [message #1038958]

Thu, 11 April 2013 14:49

Juan Holder

Messages: 14
Registered: August 2010

Junior Member

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)

Attachment: udrF2.rptdesign
(Size: 1.35MB, Downloaded 398 times)

Report message to a moderator

Re: NPE in birt 4.2.2 [message #1039994 is a reply to message #1038958]

Fri, 12 April 2013 22:50

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

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?

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: NPE in birt 4.2.2 [message #1043351 is a reply to message #1039994]

Wed, 17 April 2013 15:39

Juan Holder

Messages: 14
Registered: August 2010

Junior Member

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

Report message to a moderator

Re: NPE in birt 4.2.2 [message #1043678 is a reply to message #1043351]

Thu, 18 April 2013 01:56

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

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.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: NPE in birt 4.2.2 [message #1044360 is a reply to message #1043678]

Thu, 18 April 2013 20:32

Juan Holder

Messages: 14
Registered: August 2010

Junior Member

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

Report message to a moderator

Re: NPE in birt 4.2.2 [message #1045062 is a reply to message #1044360]

Fri, 19 April 2013 18:10

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

If you remove the crosstab associated with this cube, does the report run fine?

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: NPE in birt 4.2.2 [message #1045128 is a reply to message #1045062]

Fri, 19 April 2013 20:34

Juan Holder

Messages: 14
Registered: August 2010

Junior Member

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.

Report message to a moderator

Re: NPE in birt 4.2.2 [message #1048511 is a reply to message #1045128]

Wed, 24 April 2013 15:16

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

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.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: NPE in birt 4.2.2 [message #1048556 is a reply to message #1038958]

Wed, 24 April 2013 16:36

Juan Holder

Messages: 14
Registered: August 2010

Junior Member

ok, we'll try those test and will write you again.

regards!

JH

Report message to a moderator

Re: NPE in birt 4.2.2 [message #1048648 is a reply to message #1048556]

Wed, 24 April 2013 19:32

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Sounds good.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: NPE in birt 4.2.2 [message #1049946 is a reply to message #1048648]

Fri, 26 April 2013 13:41

Juan Holder

Messages: 14
Registered: August 2010

Junior Member

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

Report message to a moderator

Previous Topic:	EMF Cross Reference : Resolve eProxy ?
Next Topic:	Supporting Multiple SQL Servers

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 06 21:08:40 GMT 2023

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter