IBM Support

repotools -createTables command fails with ORA-01000 on Oracle 12

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)

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.

[{"Product":{"code":"SSUVV6","label":"IBM Engineering Test Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSUC3U","label":"IBM Engineering Workflow Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Installation","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"6.0;6.0.1;6.0.2","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSUVLZ","label":"IBM Engineering Requirements Management DOORS Next"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

Rational DOORS Next Generation;Rational Team Concert;Rational Quality Manager

Document Information

Modified date:
29 September 2018

UID

swg21990430