3 Replies Latest reply on Mar 12, 2009 11:46 AM by Jose Rodriguez

    Birt report errors. Oracle. gwt-console 3.3.1

    Jose Rodriguez Newbie

      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.