It's all about the answers!

Ask a question

List RQM reports fails with the statement "handle not executed"


Krzysztof Ka┼║mierczyk (7.4k374103) | asked Nov 10 '15, 3:05 a.m.
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



permanent link
Krzysztof Ka┼║mierczyk (7.4k374103) | answered Nov 10 '15, 3:09 a.m.
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.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.