SQL error #1: Row/column index out of range

Rojo

Hi everybody, I hope someone to help me, this is my problem:

I have a report designed in Eclipse BIRT Designer Version 2.5.2.v20100208 (galileo), then I put a query to get info from a informix datasource, I put my query without parameters, I put constants, and in design I put a table, and the query and report runs ok, i see the info in the table, in the report.

Well, when I change the query to get parameters (?), and I run the report, it gets the next error:

Table (id = 9):
- Cannot execute the statement.
SQL statement does not return a ResultSet object.
SQL error #1: Row/column index out of range

odaconsumer.CannotExecuteStatement ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Cannot execute the statement.
SQL statement does not return a ResultSet object.
SQL error #1: Row/column index out of range

The Query is ok, because I run this in datastudio, or in the same report but without parameters, the problem is when I modify the query to get parameters like :

and tostring(s16_clvorg) = ?
and tostring(s16_clvdir) = ?
and tostring(s16_clvdep) = ?

instead of

and tostring(s16_clvorg) = 18
and tostring(s16_clvdir) = 13
and tostring(s16_clvdep) = 3

This report runs ok in Eclipse BIRT Designer Version 2.1.2.v20070205-1728 and is in production...


Thanks.

bhanley

Have you bound the parameter in the query to a report parameter? On the "Edit Data Set" window there is a "parameters" group along the left-hand side. There you will need to bind the parameter in the query to an actual value (usually a report parameter).

You should also make sure the data type on your report parameter matches the type expected by the query. That can also cause failures like you are seeing.