Birt report errors. Oracle. gwt-console 3.3.1

[jjrs]

Hi,

After having some issues with the datasource configuration of the birt reports, now I am facing a problem with the content of the reports. I am getting errors with the Most active processes, and the Execution time quartiles reports (I think I only have access to those two from the website)


The errors I get in the web page are...

Most active processes Process workload
 Report information
Created: 6 Mar 2009 10:28




--------------------------------------------------------------------------------

The following items have errors:


ReportDesign (id = 1):
+ Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: ORA-00933: SQL command not properly ended


+ Column binding "count(ID_)" has referred to a data set column "count(ID_)" which does not exist.
+ Column binding "total" has referred to a data set column "total" which does not exist.

Report for process: General Batch
Execution time quartiles Upper quartile
 ID Exec time (seconds)





--------------------------------------------------------------------------------

The following items have errors:


ReportDesign (id = 1):
+ Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: ORA-00904: "INSTANCEID": invalid identifier

I used the provided installer. Are this reports prepared for the 3.3.1 version of the Database, or are they for version 4? Has anyone been able to have the reports working in the 3.3.1 version ?


Regards.
Jose.

[jjrs]

Hello,

Is there anyone that could provide some help with the reports ?

They are a really cool functionality (if I was able to make them work).

Are the reports not supported in the forum due to be based/implemented using a different technology (BIRT)?

Regards.
Jose

[kukeltje]

Reports are new, as is the GWT console so not many people used it yet (including me :-() so that is probably why there is not much support yet from peers

[jjrs]

Hi Ronald,

Thanks a lot for your answer. I will try with the latest version of the reports in the repository and if still have the same issue I will write Heiko as I believe he is in charge of that part.

Regards.
Jose.