Eclipse Community Forums: BIRT » JS Error after upgrading from 2.2.2 to 3.7.2

Home » Archived » BIRT » JS Error after upgrading from 2.2.2 to 3.7.2(Invalid javascript expression: dataSetRow["CODE"] recieved.)

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

JS Error after upgrading from 2.2.2 to 3.7.2 [message #991303]

Tue, 18 December 2012 12:37

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

Report message to a moderator

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 17:31

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Can you attach the design?

Michael

Developer Evangelist, Silanis

Report message to a moderator

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 08:20

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 <<Your Company Name here>></property>
<property name="createdBy">Eclipse BIRT Designer Version 3.7.2.v20120213 Build <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>

Report message to a moderator