Troubleshooting
Problem
Attempt to install IBM Collaborative Lifecycle Management (CLM) products fails with "ORA-01000: Maximum open cursors exceeded" error during repotools -createTables stage when Oracle 12 is used.
Symptom
You see the following error message in repotools-app_createTables.log file:
CRJAZ0811E The package-to-schema map could not be detected because of an SQL error.
com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0811E The package-to-schema map could not be detected because of an SQL error.
at com.ibm.team.repository.service.TeamRepositoryExceptionHelper.wrapException(TeamRepositoryExceptionHelper.java:58)
at com.ibm.team.repository.service.db.provider.AbstractDbProvider.doesTableOrViewExist(AbstractDbProvider.java:467)
at com.ibm.team.repository.service.db.provider.AbstractDbProvider.doesTableExist(AbstractDbProvider.java:430)
at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
...
Caused by: java.sql.SQLException: ORA-01000: Maximum open cursors exceeded
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
Cause
Defect in Oracle jdbc driver: Bug 19632480 - ORACLEDATABASEMETADATA.GETTABLES CURSOR CONNECTION LEAK.
Environment
Oracle jdbc driver in version 12.1.0.2.0.
Diagnosing The Problem
Check your Oracle jdbc driver if your version is affected by the defect above
Resolving The Problem
Contact Oracle support to get the driver which is not affected by Bug 19632480. The example Oracle driver version not affected by this bug is 12.1.0.1.0.
Related Information
Product Synonym
Rational DOORS Next Generation;Rational Team Concert;Rational Quality Manager
Was this topic helpful?
Document Information
Modified date:
29 September 2018
UID
swg21990430