Troubleshooting
Problem
Attempts to run "repotools -rebuildIndices" command after restoring database result in ORA-02429 error in IBM Rational Team Concert (RTC) 3.0.x.
Symptom
When you run the command repotools-, it fails.
Then you will see the "CRJAZ1942E" error with the following information in repotools-<app>_rebuildIndices.log.
Caused by:
java.sql.SQLException: ORA-02429: cannot drop index used for enforcement of unique/primary key
Cause
The problem can happen after restoring Oracle database in RTC.
The database index is a multi-part index whose columns happen to be the primary key of the table in reverse order. After a backup and restore operation, Oracle appears to create the index first and then the primary key constraint rather than the other way around. This makes it impossible to drop the index without first dropping the PK constraint.
Jazz workitem 180771 has been submitted to address the issue.
Resolving The Problem
This issue has been fixed in IBM Rational Collaborative Lifecycle Management (CLM) 2013 (Jazz 4.0) and later.
WORKAROUND:
Run the attached script once the database is restored in CLM 2012 (Jazz 3.0.x).
All source code and/or binaries attached to this document are referred to here as "the Program". IBM is not providing program services of any kind for the Program. IBM is providing the Program on an "AS IS" basis without warranty of any kind. IBM WILL NOT BE LIABLE FOR ANY ACTUAL, DIRECT, SPECIAL, INCIDENTAL, OR INDIRECT DAMAGES OR FOR ANY ECONOMIC CONSEQUENTIAL DAMAGES (INCLUDING LOST PROFITS OR SAVINGS), EVEN IF IBM, OR ITS RESELLER, HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. |
|---|
fixOraclePk.zipProduct Synonym
Rational Team Concert
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21618082