[Luis Pedro]

Hi there,
I’m developing aMyEclipse WebReport project and everything works grate localy. When I export my project to a .war file and then I deploy it in a remote server, the project is unable to use the Data Sources defined in order to fetch data. I get anexception.

My Data Source is defined as follows:

<data-sources>
        <oda-data-source extensionID="com.genuitec.eclipse.reporting.oda" name="Data Source" id="234">
            <property name="meDriver">MySQL</property>
            <property name="odaDriverClass">com.mysql.jdbc.Driver</property>
            <property name="odaURL">jdbc:mysql://servern:3306/damf3administration</property>
            <property name="odaUser">report</property>
            <encrypted-property name="odaPassword" encryptionID="base64">Ym9sMnJegd==</encrypted-property>
        </oda-data-source>
    </data-sources>

and I’ve the mysql driver Jar in the lib/ folder of the project.

Any idea why is this hapening?

The exception I get is the following:

org.eclipse.birt.report.engine.api.EngineException: A BIRT exception occurred: Invalid javascript expression: dataSetRow["name"]. See next exception for more information. Invalid javascript expression: dataSetRow["name"] at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:70) at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:61) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45) at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45) at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63) at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27) at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133) at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:104) at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:153) at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27) at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:68) at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27) at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:76) at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:68) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101) at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:231) at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237) at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:90) at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1164) at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:155) at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81) at org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(BirtGetPageActionHandler.java:58) at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:121) at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:106) 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.handleGetPage(BirtDocumentProcessor.java:87) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) 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:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) 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:225) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 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:128) 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:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:636) Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: Invalid javascript expression: dataSetRow["name"]. See next exception for more information. Invalid javascript expression: dataSetRow["name"] at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:118) at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.populateColumnList(ExpressionCompilerUtil.java:502) at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.extractDataSetColumnExpression(ExpressionCompilerUtil.java:276) at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.extractDataSetColumnExpression(ExpressionCompilerUtil.java:193) at org.eclipse.birt.data.engine.impl.ResultIterator.validateManualBindingExpressions(ResultIterator.java:291) at org.eclipse.birt.data.engine.impl.ResultIterator.<init>(ResultIterator.java:146) at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:177) at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:92) at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:128) at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:79) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:248) at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.executeQueries(ExtendedGenerateExecutor.java:204) at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:65) ... 67 more Caused by: org.eclipse.birt.core.exception.CoreException: Invalid javascript expression: dataSetRow["name"] at org.eclipse.birt.core.data.ExpressionParserUtility.compileColumnExpression(ExpressionParserUtility.java:85) at org.eclipse.birt.core.data.ExpressionUtil.extractColumnExpressions(ExpressionUtil.java:284) at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.populateColumnList(ExpressionCompilerUtil.java:497) ... 78 more Caused by: org.eclipse.birt.core.exception.CoreException: org.eclipse.birt.core at org.eclipse.birt.core.data.ExpressionParserUtility.CompiledExprFromTree(ExpressionParserUtility.java:159) at org.eclipse.birt.core.data.ExpressionParserUtility.compileColumnExpression(ExpressionParserUtility.java:78) ... 80 more 

Thank you very much in advance for your time and answer.

Luis Pedro

[support-shalini]

Luis,
I have escalated this issue the dev team. They will get back to you

[pkrgbsi]

When we migrated birt2.3.2 we are facing same problem.

If you have any solution please upated us also.

Thanks in advance.

[Luis Pedro]

@support-shalini wrote:

Luis,
I have escalated this issue the dev team. They will get back to you

Hi again,
Any news from the development team?

Thanks in advance

Luis Pedro

[Brian Fernandes]

Luis,

Sorry for the delayed response. This does not seem to be a problem with your data source or data set. Did you run into this issue after upgrading your project from a previous version of BIRT to 2.3.2 or is this a brand new report project that you created in MyEclipse 7.5?

These kinds of problems are possible if you have attempted to upgrade your project but not followed the correct procedure, see below:

pkrgbsi,

Did you follow the upgrade process exactly as outlined in the upgrade doc?

For reference, you can find this doc in MyEclipse in our help system. Go to Help > Help Contents > MyEclipse Learning Center > Technical Notices > Upgrading MyEclipse Reports Projects.

Please follow this process and you should not have any issues. Let us know if you do need further assistance. Sorry for the inconvenience caused.

[Luis Pedro]

@Support-Brian wrote:

Luis,

Sorry for the delayed response. This does not seem to be a problem with your data source or data set. Did you run into this issue after upgrading your project from a previous version of BIRT to 2.3.2 or is this a brand new report project that you created in MyEclipse 7.5?

These kinds of problems are possible if you have attempted to upgrade your project but not followed the correct procedure, see below:

This is a brand new MyEclipse Report Web Project started from scratch. No import has been done from BIRT.

I’m using MyEclipse
Version: 7.5
Build id: 7.5-20090609

Please let me know if you need me to port the Configuration Details.

Thanks again for your help.

Best regards,

Luis

[Brian Fernandes]

Luis,

You mentioned earlier that everything works just fine locally. Can you please clarify what you meant by that? Did you deploy it from within MyEclipse to a local server and it works fine? Or were you referring to the Preview tab within the report designer?

Did a local packaged deployment work (as opposed to an exploded deployment)?

Could you please mention the local server on which you deployed the application and the remote server on which deployment fails?

You mentioned that the project was created from scratch. I assume it was created in version 7.5 of MyEclipse and not an earlier version, correct?

[Luis Pedro]

Hi Brian,

@Support-Brian wrote:

Luis,

You mentioned earlier that everything works just fine locally. Can you please clarify what you meant by that? Did you deploy it from within MyEclipse to a local server and it works fine? Or were you referring to the Preview tab within the report designer?

It works fine if I deploy it from MyEclipse to my local Tomcat server both by using packaged and exploded deployement methods.

@Support-Brian wrote:

Could you please mention the local server on which you deployed the application and the remote server on which deployment fails?

The local server in which everything works fine is:
Apache Tomcat/6.0.18 1.6.0_13-b03 Sun Microsystems Inc. Windows Vista 6.0 x86

The server that it fails:
Apache Tomcat/6.0.18 1.6.0_0-b12 Sun Microsystems Inc. Linux 2.6.27-7-server i386

@Support-Brian wrote:

You mentioned that the project was created from scratch. I assume it was created in version 7.5 of MyEclipse and not an earlier version, correct?

Yes, that’s correct. Everything has been developed and created using 7.5.

Another detail (not sure if it is relevant): if I take the .war file generated by the MyEclipse deployment process (packaged) and I deploy it in the remote server, I get all the same errors.

Thank you in advance,

Luis

[Brian Fernandes]

Luis,

Thanks for the detailed response, it helps a great deal.

1) How are you generating the WAR for the remote website? Do you use the WAR export wizard or are you taking the WAR file from the local packaged deploy location?

If you are not using the wizard, could you try it? (File > Export > Java EE > WAR File (MyEclipse))

2) I’m wondering if in some way there are some system specific paths that are being used in your reporting app which is causing it to fail, or if we have a Windows / Linux problem.

a) Can you try deploying the WAR on another Windows machine and see if that works?

b) Could you try searching your project’s source files (.js, .html, .jsp) for absolute file system paths (starting with C:, D:, etc. – depending on which drive your project is on)? I doubt this is the cause but at this point it’s worth checking.

[Luis Pedro]

Hi again Brian,

@Support-Brian wrote:

1) How are you generating the WAR for the remote website? Do you use the WAR export wizard or are you taking the WAR file from the local packaged deploy location?

I’m using the (File > Export > Java EE > WAR File) in order to generate the war file.

@Support-Brian wrote:

2) I’m wondering if in some way there are some system specific paths that are being used in your reporting app which is causing it to fail, or if we have a Windows / Linux problem.

a) Can you try deploying the WAR on another Windows machine and see if that works?

I’ll check if I’ll be able to get another windows machine to deploy it. Anyway, it works great when I deploy it to the Tomcat Server that I’ve installed myself or if it is deployed to MyEclipse Tomcat Server.
@Support-Brian wrote:

b) Could you try searching your project’s source files (.js, .html, .jsp) for absolute file system paths (starting with C:, D:, etc. – depending on which drive your project is on)? I doubt this is the cause but at this point it’s worth checking.

No… there is no reference to C:, D: or any windows specific paths. It is a very simple project with two reports. Each one of them with a chart. Nothing else in this project. Actually we are introducing report capabilities in one of our projects and we decided to keep them as separate web projects. So, this is a very simple and straight forward project. I can even send it to you but you’ll not be able to access to the data sources…

So… I’m also thinking about a Windows/Linux problem, but I’ve no idea where it comes from…

[Luis Pedro]

Hi again Brian,
Any ideas if in the development team someone ever got into the same problem. i.e., developing a project on Windows causes the deployment on a Linux Tomcat server not to work properly?

Thanks in advance,

Luis Pedro

[Luis Pedro]

Brian,
Any news about the Windows –> Linux deployment compatibility for the Reporting Projects?

Best,

Luis

[ifer]

Hi,
I ‘m facing exactly the same problem. I have depelopped an application on Windows XP using ME 7.5 with BIRT libraries “MyEclipse 7.0 / BIRT 2.3.1”.

I ‘m getting the same error when I deploy my application on an Unix (AIX) server, or even on another Tomcat Server on the same development machine (WinXP) !

Please do something !!

[ifer]

I finally located the problem: MyEclipse uses another “js.jar” for the deployment to its embedded Tomcat server and another when it creates a WAR package for deployment !!!
The size of the “correct” file is 801485, while the other has 756883 bytes. If you replace the js.jar on the target server with the correct one, the report works fine!
I’m not sure that I understand how this happens, but I hope that this is going to be fixed in future versions..

[Author]

Posts