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:
I see also following stack trace in jrs.log file:
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:
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.
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.