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.
Related Information
Product Synonym
Rational Team Concert
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21698131