IBM Support

RTC Attempts to run repotools may result in java.sql.SQLException: Limit on number of statements exceeded 

Troubleshooting


Problem

When you run IBM Rational Team Concert (RTC) repotools -reindex all using DB2 for IBM i you may experience a java.sql.SQLException: Limit on number of statements exceeded

Symptom

You may see the following error message:

java.sql.SQLException: Limit on number of statements exceeded.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:408)
    at com.ibm.as400.access.AS400JDBCConnection.getUnusedId(AS400JDBCConnection.java:1404)
    at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:2165)
    at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1965)

Cause

If the "hold statements" setting in the Java JDBC properties file for connecting to a DB2 for IBM i is set to true then the repotools may fail.

Resolving The Problem

To resolve this issue follow the steps below:

1. Modify the hold statements to false in the teamserver.properties files located in
/QIBM/UserData/JazzTeamServerXXX/server/conf/ccm
/QIBM/UserData/JazzTeamServerXXX/server/conf/jts
/QIBM/UserData/JazzTeamServerXXX/server/conf/rm
/QIBM/UserData/JazzTeamServerXXX/server/conf/qm


(ex. "//hostname;hold statements\=false;user\=DB2IADM_R;password\={password};metadata source\=1;" in the teamserver.properties file
2. Rerun the repotools-xxx.sh -reindex command.
3. Change the modified value back in step #1 to true.

[{"Product":{"code":"SSUC3U","label":"IBM Engineering Workflow Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Enterprise Extensions","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"4.0.4;4.0.5;4.0.6;4.0.7;5.0.2","Edition":"Enterprise","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Product Synonym

Rational Team Concert

Document Information

Modified date:
17 June 2018

UID

swg21698131