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.)

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

Tue, 18 December 2012 07:37

Eclipse User

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

Eclipse User

Can you attach the design?

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

Eclipse User

<?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>

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

Eclipse User

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?

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

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

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 22 21:16:00 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter