Bug 332462

Description c-dowood@state.pa.us Mising name 2010-12-13 13:34:46 EST

Build Identifier: birt-runtime-2_3_2_2.zip

I have a report which uses both a JDBC Dataset and a Scripted Dataset. When I preview the report within the Report Design perspective, the report works fine. However, when I run my application and attempt to view the report using the Report Viewer, I'm receiving the error below.

[11/24/10 11:07:33:827 EST] 00000035 QueryResultSe E Cannot fetch the next data row.
Cannot move down to next row in the result set.
SQL error #1: [jcc][t4][10120][10898][3.52.95] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null

org.eclipse.birt.data.engine.core.DataException: Cannot fetch the next data row.

I've narrowed the problem down to the Scripted Dataset. If I remove it and its corresponding table, the report runs without an error. (Of course in this case, I'm also missing necessary data.) If I leave the Scripted DataSet in the report but don't bind any of its data to a table, I get errors on the console; however, the report still runs. With the Scripted Dataset and a table on the report using data from the Scripted Dataset, the report doesn't run...all I get is the error on the console shown above.

For details related to this follow the link below.  This was an entry I submitted to the BIRT forum and went back and for over ten days with Jason Weathersby applying his suggestions, none of which fixed the issue.  His final suggestion was to add a bug.  This is related some how to having a DB2 datasource.  This worked when I used the SAMPLE database that comes with BIRT.


http://www.eclipse.org/forums/index.php?t=tree&goto=641969&S=adb25ce9c88a41aa34190c3b441d0825

Reproducible: Always

Steps to Reproduce:
1.Use DB2 datasource/dataset - bind to hidden table.
2.Create a Scripted datasource/dataset - bind to visible table.
3.Preview in BIRT viewer.