Report # 6 : Error Messages

nuraniuscc

Hi Mike,

This is what I get when I do a PREVIEW on one of my reports.

Cycle :- [Ljava.lang.Object;@1ac3fc7
Market :- [Ljava.lang.Object;@1e94f23

Status :- [Ljava.lang.Object;@1ac3fc7

Table (id = 249):
- An exception occurred during processing. Please see the following message for details:
Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: ORA-00936: missing expression

---

Here, I have another SQL which gets the count(*) which I need to show on the report (I created a seperate grid and bound to that Dataset)

Maybe, It doesn't like the count(*) and Hence the Bind variable error?

Grid (id = 1016):
- An exception occurred during processing. Please see the following message for details:
Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: ORA-01006: bind variable does not exist

Thanks
Nurani Sivakumar

Davolio

When writing querys the BIRT datasets I've found that I have to declare all my SQL aggregate functions like this

count(*) as theCount

Birt doesn't like columns that do not have 'aliases' - I think that is the term.



I'm just throwing ideas out there though one of the experts will probably have a better answer.

I also use BIRT 2.2.1 and SQLServer2005 to develop with, not Oracle.