List RQM reports fails with the statement "handle not executed"
When attempting to display list of RQM reports in IBM Jazz Reporting Service (JRS), it fails with the following error message:
CRRGW5628E An java.sql.SQLException error occurred when validating the input SQL string, caused by statement handle not executed: getMetaData. java.sql.SQLException: statement handle not executed: getMetaData I see also following stack trace in jrs.log file: ERROR ibm.team.integration.reporting.model.utils.DbUtils - CRRGW5628E An java.sql.SQLException error occurred when validating the input SQL string, caused by statement handle not executed: getMetaData. java.sql.SQLException: statement handle not executed: getMetaData at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199) |
One answer
|
The possible root cause is the wrong version of Oracle jdbc driver provided. The driver version is provided in jrs.log file at the moment when the tool is starting. For example the following information:
Db Product Name: Oracle Db Product Version: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Jdbc Driver Version: 11.1.0.7.0-Production indicates that your JDBC driver is in the version 11.1.0.7.0-Production. You have to use the version According to system requirements we require using Oracle Java Database Connectivity (JDBC) ojdbc6.jar.11.2.0.3 or higher. Change driver version to check whether the issue is fixed. |