Jazz Register Log in
Jazz Forum Welcome to the Jazz Community Forum

Welcome to the Jazz Community Forum

Connect and collaborate with IBM Engineering experts and users

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)




1 vote



One answer

Permanent link
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.

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 361
× 42

Question asked: Nov 10 '15, 3:05 a.m.

Question was seen: 4,172 times

Last updated: Nov 10 '15, 3:09 a.m.

Confirmation Cancel Confirm