Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » JS Error after upgrading from 2.2.2 to 3.7.2(Invalid javascript expression: dataSetRow["CODE"] recieved.)
JS Error after upgrading from 2.2.2 to 3.7.2 [message #991303] Tue, 18 December 2012 07:37 Go to next message
Yuval Meiri is currently offline Yuval Meiri
Messages: 2
Registered: December 2012
Junior Member

Hi,
I've recently upgraded BIRT from 2.2.2 to 3.7.2
My server code is running on JBoss 4.3.0.GA_CP10 (build: SVNTag=JBPAPP_4_3_0_GA_C)

1. When I run my reports in eclipse environment it works fine.
2. My tested report is simple and does not include any JS.
3. I do not have additional js.jar in my classpath (as far as I know and checked).
4. I've deprecated the call to setBIRTHome(...) as mentioned in the upgrade docs.
4.1. I'm using the BIRT API as I've used in 2.2.2 except the change mentioned above.
5. I've added all jars contained in ReportEngine\lib

I've tried almost everything and will appreciate any help

Thanks,
Yuval

Here is my error & StackTrace:
Table (id = 45):
- A BIRT exception occurred. See next exception for more information.
Invalid javascript expression: dataSetRow["CODE"] (Element ID:45)

data.engine.BirtException ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: A BIRT exception occurred. See next exception for more information.
Invalid javascript expression: dataSetRow["CODE"] (Element ID:45)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1216)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.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.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)

Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred. See next exception for more information.
Invalid javascript expression: dataSetRow["CODE"]
at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123)
at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.populateColumnList(ExpressionCompilerUtil.java:504)
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:370)
at org.eclipse.birt.data.engine.impl.ResultIterator.<init>(ResultIterator.java:148)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:212)
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
... 58 more
Caused by: org.eclipse.birt.core.exception.CoreException: Invalid javascript expression: dataSetRow["CODE"]
at org.eclipse.birt.core.data.ExpressionParserUtility.compileColumnExpression(ExpressionParserUtility.java:85)
at org.eclipse.birt.core.data.ExpressionUtil.extractColumnExpressions(ExpressionUtil.java:282)
at org.eclipse.birt.data.engine.expression.ExpressionCompilerUtil.populateColumnList(ExpressionCompilerUtil.java:499)
... 68 more
Caused by: org.eclipse.birt.core.exception.CoreException: org.eclipse.birt.core
at org.eclipse.birt.core.data.ExpressionParserUtility.CompiledExprFromTree(ExpressionParserUtility.java:160)
at org.eclipse.birt.core.data.ExpressionParserUtility.compileColumnExpression(ExpressionParserUtility.java:78)
... 70 more
Re: JS Error after upgrading from 2.2.2 to 3.7.2 [message #991361 is a reply to message #991303] Tue, 18 December 2012 12:31 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1546
Registered: July 2009
Senior Member

Can you attach the design?

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: JS Error after upgrading from 2.2.2 to 3.7.2 [message #991445 is a reply to message #991361] Wed, 19 December 2012 03:20 Go to previous messageGo to next message
Yuval Meiri is currently offline Yuval Meiri
Messages: 2
Registered: December 2012
Junior Member
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
<property name="comments">Copyright (c) 2007 &lt;&lt;Your Company Name here>></property>
<property name="createdBy">Eclipse BIRT Designer Version 3.7.2.v20120213 Build &lt;3.7.2.v20120214-1408></property>
<html-property name="description">Creates a blank report with no predefined content.</html-property>
<list-property name="propertyBindings">
<structure>
<property name="name">odaJndiName</property>
<property name="id">43</property>
<expression name="value">params["jdbc_jndi_url"]</expression>
</structure>
<structure>
<property name="name">queryText</property>
<property name="id">2213</property>
</structure>
<structure>
<property name="name">queryTimeOut</property>
<property name="id">2213</property>
</structure>
<structure>
<property name="name">rowFetchSize</property>
<property name="id">2213</property>
</structure>
</list-property>
<property name="units">in</property>
<text-property name="displayName">Security Report - Active users</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="layoutPreference">auto layout</property>
<parameters>
<scalar-parameter name="jdbc_jndi_url" id="2212">
<text-property name="promptText">jdbc_jndi_url</text-property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant"></value>
</simple-property-list>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="ora10loc" id="43">
<list-property name="privateDriverProperties">
<ex-property>
<name>metadataBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>disabledMetadataBidiFormatStr</name>
</ex-property>
<ex-property>
<name>contentBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>disabledContentBidiFormatStr</name>
</ex-property>
</list-property>
<property name="odaDriverClass">oracle.jdbc.OracleDriver</property>
<property name="odaURL">jdbc:oracle:thin:@localhost:1521:orcl11</property>
<property name="odaUser">test</property>
<encrypted-property name="odaPassword" encryptionID="base64">ZXNidGs=</encrypted-property>
<property name="odaJndiName">com.test.hibernate.DataSource</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="User" id="2213">
<property name="nullsOrdering">nulls lowest</property>
<list-property name="columnHints">
<structure>
<property name="columnName">CODE</property>
<property name="analysis">dimension</property>
<text-property name="displayName">CODE</text-property>
</structure>
<structure>
<property name="columnName">NAME</property>
<property name="analysis">dimension</property>
<text-property name="displayName">NAME</text-property>
</structure>
<structure>
<property name="columnName">EMAIL</property>
<property name="analysis">dimension</property>
<text-property name="displayName">EMAIL</text-property>
</structure>
<structure>
<property name="columnName">IP_ADDR</property>
<property name="analysis">dimension</property>
<text-property name="displayName">IP_ADDR</text-property>
</structure>
<structure>
<property name="columnName">LOGGED_ON_SINCE</property>
<property name="analysis">dimension</property>
<text-property name="displayName">LOGGED_ON_SINCE</text-property>
</structure>
<structure>
<property name="columnName">SESSION_ID</property>
<property name="analysis">dimension</property>
<text-property name="displayName">SESSION_ID</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">EMAIL</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">IP_ADDR</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">LOGGED_ON_SINCE</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">SESSION_ID</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">ora10loc</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CODE</property>
<property name="nativeName">CODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">NAME</property>
<property name="nativeName">NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">EMAIL</property>
<property name="nativeName">EMAIL</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">IP_ADDR</property>
<property name="nativeName">IP_ADDR</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">LOGGED_ON_SINCE</property>
<property name="nativeName">LOGGED_ON_SINCE</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">93</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">SESSION_ID</property>
<property name="nativeName">SESSION_ID</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT
u.code,
u.name,
u.email,
cu.ip_addr,
cu.logged_on_since,
cu.session_id

FROM
SEC_CURRENT_USER_LIST cu,
SEC_USER u

WHERE
cu.user_id <> 1
AND cu.user_id = u.id

ORDER BY 1]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="crosstab" id="4">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="topMargin">1in</property>
<property name="leftMargin">1.25in</property>
<property name="bottomMargin">1in</property>
<property name="rightMargin">1.25in</property>
<page-footer>
<grid id="388">
<property name="width">100%</property>
<column id="389"/>
<row id="390">
<cell id="391">
<text id="349">
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
<property name="fontStyle">normal</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<B>Date of Execution : </B> <value-of>new Date()</value-of>]]></text-property>
</text>
</cell>
</row>
<row id="392">
<cell id="393">
<text id="350">
<property name="fontFamily">"Arial"</property>
<property name="fontSize">10pt</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<B>Page No.:</B> <value-of>pageNumber</value-of> ]]></text-property>
</text>
</cell>
</row>
<row id="394">
<cell id="348"/>
</row>
</grid>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<table id="2214">
<property name="fontFamily">"Arial"</property>
<property name="textAlign">left</property>
<property name="width">100%</property>
<property name="dataSet">User</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">CODE</property>
<text-property name="displayName">CODE</text-property>
<expression name="expression" type="javascript">dataSetRow["CODE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">NAME</property>
<text-property name="displayName">NAME</text-property>
<expression name="expression" type="javascript">dataSetRow["NAME"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">EMAIL</property>
<text-property name="displayName">EMAIL</text-property>
<expression name="expression" type="javascript">dataSetRow["EMAIL"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">IP_ADDR</property>
<text-property name="displayName">IP_ADDR</text-property>
<expression name="expression" type="javascript">dataSetRow["IP_ADDR"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">LOGGED_ON_SINCE</property>
<text-property name="displayName">LOGGED_ON_SINCE</text-property>
<expression name="expression" type="javascript">dataSetRow["LOGGED_ON_SINCE"]</expression>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="name">SESSION_ID</property>
<text-property name="displayName">SESSION_ID</text-property>
<expression name="expression" type="javascript">dataSetRow["SESSION_ID"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<property name="pageBreakInterval">50</property>
<column id="2233"/>
<column id="2234"/>
<column id="2235"/>
<column id="2236"/>
<column id="2237"/>
<header>
<row id="2215">
<property name="backgroundColor">#C0C0C0</property>
<property name="fontWeight">bold</property>
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<cell id="2216">
<label id="2238">
<text-property name="text">User Code</text-property>
</label>
</cell>
<cell id="2217">
<label id="2239">
<text-property name="text">User Name</text-property>
</label>
</cell>
<cell id="2218">
<label id="2242">
<text-property name="text">Session ID</text-property>
</label>
</cell>
<cell id="2219">
<label id="2241">
<text-property name="text">Session Start</text-property>
</label>
</cell>
<cell id="2220">
<label id="2240">
<text-property name="text">IP-Address</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="2221">
<cell id="2222">
<data id="2243">
<property name="resultSetColumn">CODE</property>
</data>
</cell>
<cell id="2223">
<data id="2244">
<property name="resultSetColumn">NAME</property>
</data>
</cell>
<cell id="2224">
<data id="2263">
<property name="resultSetColumn">SESSION_ID</property>
</data>
</cell>
<cell id="2225">
<data id="2262">
<property name="resultSetColumn">LOGGED_ON_SINCE</property>
</data>
</cell>
<cell id="2226">
<data id="2261">
<property name="resultSetColumn">IP_ADDR</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="2227">
<cell id="2228"/>
<cell id="2229"/>
<cell id="2230"/>
<cell id="2231"/>
<cell id="2232"/>
</row>
</footer>
</table>
</body>
</report>
Re: JS Error after upgrading from 2.2.2 to 3.7.2 [message #991705 is a reply to message #991445] Wed, 19 December 2012 21:41 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1546
Registered: July 2009
Senior Member

Does this happen with all reports, now? What version of Java are you using? If you rebuild the report from scratch, in 3.7.2, does it work?

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.

[Updated on: Wed, 19 December 2012 21:42]

Report message to a moderator

Previous Topic:BIRT Report Chart not showing on IE8
Next Topic:emitter nativexls in BIRT Runtime 3.7.2
Goto Forum:
  


Current Time: Thu Jul 24 09:17:14 EDT 2014

Powered by FUDForum. Page generated in 0.01918 seconds