After you upgrade from IBM Rational Team Concert (RTC) v4.0.1 to v4.0.5, the "CRJAZ2055W" error occurs on the IBM Change and Configuration Manager (CCM) diagnostics page.
Steps to reproduce:
- Upgrade your RTC server from version 4.0.1 to 4.0.5
- Go to the CCM diagnostics page at the following site:
- Use the Run All Diagnostics button
Result: You will get the following error message:
CRJAZ2055W Some indices were missing from the database, and missing indices can negatively impact application performance. To add the missing indices, you should stop your server and execute the -rebuildIndices command in repotools.
as in the following screenshot:
Even if you execute the
-rebuildIndicescommand using the
repotools, as the error message suggests, this issue will not be fixed.
The name of the index table is different in RTC 4.0.5.
If you create a new RTC 4.0.5 database, the index name will be
However, if you upgrade from RTC v4.0.1 to v4.0.5, the index name becomes
Resolving The Problem
Use the following steps to confirm and solve the problem:
- Export the Diagnostics results using the Export Results button on the top-right corner of the Diagnostics page
- Extract all files from the
diagnostics.zipfile and open the
com.ibm.team.repository.service.diagnostics.basic.internal.DBIndexDiagnostic.txtfile. If this file contains the
CRJAZ2055W Some indices were missing from the database ... The SQL commands that can be used to add the missing indices are: CREATE INDEX SCM.PORT_ORDER_IDX ON SCM.ACCEPT_QUEUE(WORKSPACE_ID, COMPONENT_ID, ORDER_INDEX)message, perform Step 3.
- Run the
CREATE INDEXcommand from Step 2 on the CCM database. If as a result you get the
The index was not created becase an index "SCM.PORT_ORDER_IDX0" with a matching definition already exists. SQLSTATE=01550error message, perform Step 4.
- Run the following SQL command on the CCM database:
select * from SYSIBM.SYSINDEXES where TBNAME='ACCEPT_QUEUE'. If you will get the index table name
PORT_ORDER_IDX0", perform Step 5.
- Rename the table using the SQL command:
rename index SCM.PORT_ORDER_IDX0 to PORT_ORDER_IDX
- Run the
repotools-ccm.sh -rebuildIndicescommand after the database changes and rerun all the diagnostics test on the CCM Diagnostic page.
Rational Team Concert
Was this topic helpful?
16 June 2018