[jboss-user] [JBoss jBPM] - 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.




View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4215654#4215654

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4215654