Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » Birt Report Message... The following items have errors...
Birt Report Message... The following items have errors... [message #246286] Wed, 04 July 2007 09:34 Go to next message
Eclipse UserFriend
My BIRT reports shows errors after deployment in Tomcat (using IE to
execute and view). The error message below is displayed at the bottom of
the report indicating that some of the fields are invalid. Removing these
fields from the report design and adding them again usually fixes the
problem (until today). Some versions of IE do not display the errors but
leave the corresponding cells in the report blank. Firefox also leaves
the “problem” cells blank.

The report is very big in terms of the number of fields and I was
wondering whether the size of the report is not the main cause of the
problem. The problem occurs intermittently (once every few months)
without changes to the report or database. The fields affected are of
different types showing data of different data types and I could not
establish a pattern in the behaviour.

Can you please assist?

Regards
Karen

Error Message:
The following items have errors:

Data (id = 1458):
+ Invalid expression to retrieve value in presentation.
data.engine.InValidExpr ( 1 time(s) )
detail : org.eclipse.birt.data.engine.core.DataException:
Invalid expression to retrieve value in presentation.
at
org.eclipse.birt.data.engine.impl.document.util.ExprResultSe t.getValue(ExprResultSet.java:130)
at
org.eclipse.birt.data.engine.impl.document.ResultIterator.ge tValue(ResultIterator.java:150)
at
org.eclipse.birt.report.engine.data.dte.DteResultSet.getValu e(DteResultSet.java:261)
at
org.eclipse.birt.report.engine.internal.executor.doc.Abstrac tReportReader$1.visitData(AbstractReportReader.java:321)
at
org.eclipse.birt.report.engine.content.impl.DataContent.acce pt(DataContent.java:111)
at
org.eclipse.birt.report.engine.content.ContentVisitorAdapter .visit(ContentVisitorAdapter.java:9)
at
org.eclipse.birt.report.engine.internal.executor.doc.ReportI temReader.initializeContent(ReportItemReader.java:252)
at
org.eclipse.birt.report.engine.internal.executor.doc.ReportI temReader.execute(ReportItemReader.java:61)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportExecutor.execute(LocalizedReportExecutor.java:90)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportExecutor.execute(LocalizedReportExecutor.java:98)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportExecutor.execute(LocalizedReportExecutor.java:98)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportExecutor.execute(LocalizedReportExecutor.java:98)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportExecutor.execute(LocalizedReportExecutor.java:98)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportExecutor.execute(LocalizedReportExecutor.java:77)
at
org.eclipse.birt.report.engine.internal.document.v3.ReportCo ntentLoaderV3.loadPage(ReportContentLoaderV3.java:51)
at
org.eclipse.birt.report.engine.internal.document.ReportConte ntLoader.loadPage(ReportContentLoader.java:55)
at
org.eclipse.birt.report.engine.api.impl.RenderTask.doRender( RenderTask.java:248)
at
org.eclipse.birt.report.engine.api.impl.RenderTask$PageRende r.render(RenderTask.java:702)
at
org.eclipse.birt.report.engine.api.impl.RenderTask.render(Re nderTask.java:613)
at
org.eclipse.birt.report.service.ReportEngineService.renderRe port(Unknown
Source)
at
org.eclipse.birt.report.service.ReportEngineService.renderRe port(Unknown
Source)
at org.eclipse.birt.report.service.BirtViewerReportService.getP age(Unknown
Source)
at
org.eclipse.birt.report.service.actionhandler.BirtChangePara meterActionHandler.doRenderPage(Unknown
Source)
at
org.eclipse.birt.report.service.actionhandler.AbstractChange ParameterActionHandler.__execute(Unknown
Source)
at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source)
at
org.eclipse.birt.report.soapengine.processor.AbstractBaseDoc umentProcessor.__executeAction(Unknown
Source)
at
org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.executeAction(Unknown
Source)
at
org.eclipse.birt.report.soapengine.processor.BirtDocumentPro cessor.handleChangeParameter(Unknown
Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.process(Unknown
Source)
at
org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingI mpl.getUpdatedObjects(Unknown
Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCP rovider.java:397)
at
org.apache.axis.providers.java.RPCProvider.processMessage(RP vider.java:186)
at
org.apache.axis.providers.java.JavaProvider.invoke(JavaProvi der.java:323)
at
org.apache.axis.strategies.InvocationStrategy.visit(Invocati onStrategy.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:453)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281 )
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServle t.java:699)
at
org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.doPost(Unknown
Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11Connection Handler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt( LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Re: Birt Report Message... The following items have errors... [message #246353 is a reply to message #246286] Wed, 04 July 2007 20:35 Go to previous messageGo to next message
Eclipse UserFriend
Karen wrote:
> My BIRT reports shows errors after deployment in Tomcat (using IE to
> execute and view). The error message below is displayed at the bottom
> of the report indicating that some of the fields are invalid. Removing
> these fields from the report design and adding them again usually fixes
> the problem (until today). Some versions of IE do not display the
> errors but leave the corresponding cells in the report blank. Firefox
> also leaves the �problem� cells blank.
>
> The report is very big in terms of the number of fields and I was
> wondering whether the size of the report is not the main cause of the
> problem. The problem occurs intermittently (once every few months)
> without changes to the report or database. The fields affected are of
> different types showing data of different data types and I could not
> establish a pattern in the behaviour.
>
> Can you please assist?
>
> Regards
> Karen
>
> Error Message:
> The following items have errors:
>
> Data (id = 1458):
> + Invalid expression to retrieve value in presentation.
> data.engine.InValidExpr ( 1 time(s) )
> detail : org.eclipse.birt.data.engine.core.DataException:
> Invalid expression to retrieve value in presentation.
> at
> org.eclipse.birt.data.engine.impl.document.util.ExprResultSe t.getValue(ExprResultSet.java:130)
>
> at
> org.eclipse.birt.data.engine.impl.document.ResultIterator.ge tValue(ResultIterator.java:150)
>
> at
> org.eclipse.birt.report.engine.data.dte.DteResultSet.getValu e(DteResultSet.java:261)
>
> at
> org.eclipse.birt.report.engine.internal.executor.doc.Abstrac tReportReader$1.visitData(AbstractReportReader.java:321)
>
> at
> org.eclipse.birt.report.engine.content.impl.DataContent.acce pt(DataContent.java:111)
>
> at
> org.eclipse.birt.report.engine.content.ContentVisitorAdapter .visit(ContentVisitorAdapter.java:9)
>
> at
> org.eclipse.birt.report.engine.internal.executor.doc.ReportI temReader.initializeContent(ReportItemReader.java:252)
>
> at
> org.eclipse.birt.report.engine.internal.executor.doc.ReportI temReader.execute(ReportItemReader.java:61)
>
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
>
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportExecutor.execute(LocalizedReportExecutor.java:90)
>
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportExecutor.execute(LocalizedReportExecutor.java:98)
>
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportExecutor.execute(LocalizedReportExecutor.java:98)
>
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportExecutor.execute(LocalizedReportExecutor.java:98)
>
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportExecutor.execute(LocalizedReportExecutor.java:98)
>
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportExecutor.execute(LocalizedReportExecutor.java:77)
>
> at
> org.eclipse.birt.report.engine.internal.document.v3.ReportCo ntentLoaderV3.loadPage(ReportContentLoaderV3.java:51)
>
> at
> org.eclipse.birt.report.engine.internal.document.ReportConte ntLoader.loadPage(ReportContentLoader.java:55)
>
> at
> org.eclipse.birt.report.engine.api.impl.RenderTask.doRender( RenderTask.java:248)
>
> at
> org.eclipse.birt.report.engine.api.impl.RenderTask$PageRende r.render(RenderTask.java:702)
>
> at
> org.eclipse.birt.report.engine.api.impl.RenderTask.render(Re nderTask.java:613)
>
> at
> org.eclipse.birt.report.service.ReportEngineService.renderRe port(Unknown
> Source)
> at
> org.eclipse.birt.report.service.ReportEngineService.renderRe port(Unknown
> Source)
> at
> org.eclipse.birt.report.service.BirtViewerReportService.getP age(Unknown
> Source)
> at
> org.eclipse.birt.report.service.actionhandler.BirtChangePara meterActionHandler.doRenderPage(Unknown
> Source)
> at
> org.eclipse.birt.report.service.actionhandler.AbstractChange ParameterActionHandler.__execute(Unknown
> Source)
> at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source)
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseDoc umentProcessor.__executeAction(Unknown
> Source)
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.executeAction(Unknown
> Source)
> at
> org.eclipse.birt.report.soapengine.processor.BirtDocumentPro cessor.handleChangeParameter(Unknown
> Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.process(Unknown
> Source)
> at
> org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingI mpl.getUpdatedObjects(Unknown
> Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at
> org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCP rovider.java:397)
>
> at
> org.apache.axis.providers.java.RPCProvider.processMessage(RP vider.java:186)
> at
> org.apache.axis.providers.java.JavaProvider.invoke(JavaProvi der.java:323)
> at
> org.apache.axis.strategies.InvocationStrategy.visit(Invocati onStrategy.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:453)
> at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281 )
> at org.apache.axis.transport.http.AxisServlet.doPost(AxisServle t.java:699)
> at
> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.doPost(Unknown
> Source)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
>
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:869)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11Connection Handler.processConnection(Http11BaseProtocol.java:664)
>
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
>
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt( LeaderFollowerWorkerThread.java:80)
>
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:684)
>
> at java.lang.Thread.run(Thread.java:595)
>

Could you attach a invalid design file on?
Or you can file a bugzilla item with the invalid design files.

Thanks
Qs
Re: Birt Report Message... The following items have errors... [message #246431 is a reply to message #246353] Thu, 05 July 2007 04:33 Go to previous messageGo to next message
Eclipse UserFriend
How do I attach my problem .rptdesign file as requested? Should I copy
the contents of the file to this message box.

Bugzilla also does not have the facility to attach a file.

Regards
Karen
Re: Birt Report Message... The following items have errors... [message #246450 is a reply to message #246431] Thu, 05 July 2007 06:00 Go to previous messageGo to next message
Eclipse UserFriend
In order to clarify my initial post:

The Eclipse viewer shows the report and data correctly. The problem only
occurs after deployment to Tomcat and execution and viewing in IE 7 or
Firefox 2.

Regards
Karen
Re: Birt Report Message... The following items have errors... [message #246581 is a reply to message #246431] Thu, 05 July 2007 21:06 Go to previous messageGo to next message
Eclipse UserFriend
Karen wrote:
> How do I attach my problem .rptdesign file as requested? Should I copy
> the contents of the file to this message box.
>
> Bugzilla also does not have the facility to attach a file.
>
> Regards
> Karen
>
you can create attachments in bugzilla system.
Re: Birt Report Message... The following items have errors... [message #246586 is a reply to message #246450] Thu, 05 July 2007 21:07 Go to previous messageGo to next message
Eclipse UserFriend
Karen wrote:
> In order to clarify my initial post:
>
> The Eclipse viewer shows the report and data correctly. The problem
> only occurs after deployment to Tomcat and execution and viewing in IE 7
> or Firefox 2.
>
> Regards
> Karen
>
Do you mean the error is binding to IE7 and Firefox 2 only?
The eclipse viewer uses tomcat too. So I think there should no relation
ship with tomcat.

Thanks
Qs
Re: Birt Report Message... The following items have errors... [message #249304 is a reply to message #246581] Sat, 21 July 2007 08:52 Go to previous messageGo to next message
Eclipse UserFriend
Field values are still disappearing from my report. I examined the code
(in .rptdesign) for two of the fields. One field’s value is displays
correctly while the other field’s value is blank. The code for both
fields is identical. Executing the SQL on the database returns both
values.

I still feel that this problem may be related to the number of fields I
have in my report. My report shows one row/record from the database and
each row consist of approximately 130 values (= database columns). There
are also approximately 160 headings/labels in my report. The report is
presented as a form with hard coded headings and subheadings and the data
from the database is used to “populate” this form.

How does BIRT handle this type of report behind the scenes? Is there a
limit to the number of fields per report? I am thinking in terms of
buffer size limitations and possible configuration changes I can do on my
side.

Can you please assist? I am at the point where I need to start looking at
alternative reporting solutions in order to deliver a stable product to
the client.

Regards
Karen
Re: Birt Report Message... The following items have errors... [message #249309 is a reply to message #246586] Sat, 21 July 2007 08:55 Go to previous messageGo to next message
Eclipse UserFriend
The problem occurs in IE 6 and 7 as well as in Firefox 2.0.0.3. But as I
mentioned before, I don't get the problem when viewing the report in
Eclipse (using the BIRT plugin).

Regards
Karen
Re: Birt Report Message... The following items have errors... [message #249361 is a reply to message #249304] Mon, 23 July 2007 06:22 Go to previous messageGo to next message
Eclipse UserFriend
Karen Kotze wrote:
> Field values are still disappearing from my report. I examined the code
> (in .rptdesign) for two of the fields. One field�s value is displays
> correctly while the other field�s value is blank. The code for both
> fields is identical. Executing the SQL on the database returns both
> values.
>
> I still feel that this problem may be related to the number of fields I
> have in my report. My report shows one row/record from the database and
> each row consist of approximately 130 values (= database columns). There
> are also approximately 160 headings/labels in my report. The report is
> presented as a form with hard coded headings and subheadings and the
> data from the database is used to �populate� this form.
>
> How does BIRT handle this type of report behind the scenes? Is there a
> limit to the number of fields per report? I am thinking in terms of
> buffer size limitations and possible configuration changes I can do on
> my side.
>
> Can you please assist? I am at the point where I need to start looking
> at alternative reporting solutions in order to deliver a stable product
> to the client.
>
> Regards
> Karen
>
>
>
I don't think BIRT does kind of limitation.
Could you attach you file when you replay to the new group? What's your
news client? It should provide a attach file option.
qs
Re: Birt Report Message... The following items have errors... [message #249499 is a reply to message #249361] Tue, 24 July 2007 04:33 Go to previous messageGo to next message
Eclipse UserFriend
I think I found my problem... (or I hope so)

I used aliases in my SQL.
E.g.
SELECT
a.name AS a_name,
b.name AS b_name
FROM
A a,
B b
WHERE
a.id = b.id;

My problem was solved after removing the aliases. This does not make
sense since the report was deployed to UAT (with aliases in the SQL) about
4 month ago and we started to experience the problems only about a month
ago.

Do you have any explanation for this situation?

Regards
Karen
Re: Birt Report Message... The following items have errors... [message #249877 is a reply to message #249499] Wed, 25 July 2007 21:01 Go to previous message
Eclipse UserFriend
Well sounds like a bug :(
Could yo file a bug with the design file attached?
Thanks
Qiangsheng

Karen Kotze wrote:
> I think I found my problem... (or I hope so)
>
> I used aliases in my SQL.
> E.g.
> SELECT
> a.name AS a_name,
> b.name AS b_name
> FROM
> A a,
> B b
> WHERE
> a.id = b.id;
>
> My problem was solved after removing the aliases. This does not make
> sense since the report was deployed to UAT (with aliases in the SQL)
> about 4 month ago and we started to experience the problems only about a
> month ago.
>
> Do you have any explanation for this situation?
>
> Regards
> Karen
>
>
>
>
>
Previous Topic:How to debug a report
Next Topic:Problems with 2.2 WebViewer example and MacOSX ...
Goto Forum:
  


Current Time: Wed May 28 17:35:29 EDT 2025

Powered by FUDForum. Page generated in 0.05530 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