It's all about the answers!

Ask a question

jts_upgrade.sh failing [step 1]


Rafael Pirolla (1617) | asked Jun 01 '15, 5:29 p.m.
edited Jun 01 '15, 5:35 p.m.
 Hello,

I'm upgrading JTS and CCM from 4.0.4 to 5.0.2 and the upgrade script is failing with this message:
CRJZS5650I Indices directory is /app/rtc/IBM/JazzTeamServer502/server/conf/jts/indices
CRJZS6122I The indexes in /app/rtc/IBM/JazzTeamServer502/server/conf/jts/indices must be updated to correct a version mismatch. The update will occur automatically.
CRJZS6120I The server is collecting data to update the indexes in /app/rtc/IBM/JazzTeamServer502/server/conf/jts/indices.
CRJZS6121I The indexes in /app/rtc/IBM/JazzTeamServer502/server/conf/jts/indices are being updated.
CRJZS6043E The indexes in /app/rtc/IBM/JazzTeamServer502/server/conf/jts/indices could not be merged. Stop the server and either restore a backup of the indexes and rerun the "repotools-jts -addTables" command, or recover the correct index by running the "repotools-jts -reindex all" command.
               /app/rtc/IBM/JazzTeamServer502/server/conf/jts/indices/_ce2ZIZQJEeOFaqgcFa_Oow/jfs-textindex/_2.fnm (No such file or directory) . See the log file "/app/rtc/IBM/JazzTeamServer502/server/repotools-jts_addTables.log" for details.
Running post addTables for "Full Text Migration Handler"...
Running post addTables for "com.ibm.team.jfs.indexes"...
Running post addTables for "Full Text Migration Handler"...
CRJAZ0577E The following SQL query did not execute properly on the server:
CREATE UNIQUE INDEX JTS_OWNER.DSCVRDSCVRSRVCCNTRBTNRSRCPPNMD ON JTS_OWNER.DISCOVERY_SERVICE_CNTRBTN_RSRC(APP_NAME)
The user "ADMIN" has logged out of the database "xxxxxx".
CRJAZ1425E The database could not create indexes for the DISCOVERY_SERVICE_CNTRBTN_RSRC table.
CRJAZ1791E The migration completed with errors. The imported database is unstable and should not be used without further analysis.
On the log file (/app/rtc/IBM/JazzTeamServer502/server/repotools-jts_addTables.log), there's this:

2015-06-01 17:55:51,887 Running post addTables for "com.ibm.team.jfs.indexes"...

2015-06-01 17:55:51,888 CRJZS5650I Indices directory is /app/rtc/IBM/JazzTeamServer502/server/conf/jts/indices

2015-06-01 17:55:51,891 CRJZS6122I The indexes in /app/rtc/IBM/JazzTeamServer502/server/conf/jts/indices must be updated to correct a version mismatch. The update will occur automatically.

2015-06-01 17:55:51,891 CRJZS6120I The server is collecting data to update the indexes in /app/rtc/IBM/JazzTeamServer502/server/conf/jts/indices.

2015-06-01 17:55:51,955 CRJZS6121I The indexes in /app/rtc/IBM/JazzTeamServer502/server/conf/jts/indices are being updated.

2015-06-01 17:55:52,999 CRJZS6043E The indexes in /app/rtc/IBM/JazzTeamServer502/server/conf/jts/indices could not be merged. Stop the server and either restore a backup of the indexes and rerun the "repotools-jts -addTables" command, or recover the correct index by running the "repotools-jts -reindex all" command.

com.ibm.team.repository.common.TeamRepositoryException: /app/rtc/IBM/JazzTeamServer502/server/conf/jts/indices/_ce2ZIZQJEeOFaqgcFa_Oow/jfs-textindex/_2.fnm (No such file or directory)

        at

com.ibm.team.jfs.indexing.service.internal.MergeIndexService.updateVersion(MergeIndexService.java:971)

        at

com.ibm.team.jfs.indexing.service.internal.MergeIndexService.updateVersion(MergeIndexService.java:937)

        at

com.ibm.team.jfs.indexing.service.internal.MergeIndexService.mergeIfNeeded(MergeIndexService.java:663)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

(...)

Caused by: java.io.FileNotFoundException: /app/rtc/IBM/JazzTeamServer502/server/conf/jts/indices/_ce2ZIZQJEeOFaqgcFa_Oow/jfs-textindex/_2.fnm (No such file or directory)

(...)

2015-06-01 17:55:53,004         /app/rtc/IBM/JazzTeamServer502/server/conf/jts/indices/_ce2ZIZQJEeOFaqgcFa_Oow/jfs-textindex/_2.fnm (No such file or directory)

2015-06-01 17:55:53,004 Post addTables for com.ibm.team.jfs.indexes took 1117 ms.

2015-06-01 17:55:53,004 Running post addTables for "Full Text Migration Handler"...

2015-06-01 17:55:53,005 Post addTables for Full Text Migration Handler took 1 ms.

2015-06-01 17:55:53,005 Running post addTables for "com.ibm.team.jfs.indexes"...

2015-06-01 17:55:53,006 Post addTables for com.ibm.team.jfs.indexes took 1 ms.

2015-06-01 17:55:53,006 Running post addTables for "Full Text Migration Handler"...

2015-06-01 17:55:53,007 Post addTables for Full Text Migration Handler took 1 ms.

2015-06-01 17:55:53,232 CRJAZ0577E The following SQL query did not execute properly on the server:

CREATE UNIQUE INDEX JTS_OWNER.DSCVRDSCVRSRVCCNTRBTNRSRCPPNMD ON JTS_OWNER.DISCOVERY_SERVICE_CNTRBTN_RSRC(APP_NAME)

java.sql.SQLException: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

2015-06-01 17:55:53,235 The user "ADMIN" has logged out of the database "xxxxx".

2015-06-01 17:55:53,235 CRJAZ1425E The database could not create indexes for the DISCOVERY_SERVICE_CNTRBTN_RSRC table.

2015-06-01 17:55:53,235 CRJAZ1425E The database could not create indexes for the DISCOVERY_SERVICE_CNTRBTN_RSRC table.

com.ibm.team.repository.common.TeamRepositoryException: CRJAZ1425E The database could not create indexes for the DISCOVERY_SERVICE_CNTRBTN_RSRC table.

Caused by: com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577E The following SQL query did not execute properly on the server:

CREATE UNIQUE INDEX JTS_OWNER.DSCVRDSCVRSRVCCNTRBTNRSRCPPNMD ON JTS_OWNER.DISCOVERY_SERVICE_CNTRBTN_RSRC(APP_NAME)

        at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQuery(JdbcDB.java:239)

        at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQuery(JdbcDB.java:114)

        at com.ibm.team.repository.service.internal.db.util.JdbcDB.executeQueryOn(JdbcDB.java:103)

        at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.executeStatement(JdbcDBBuilder.java:151)

        at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.executeStatements(JdbcDBBuilder.java:275)

        at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.executeStatements(JdbcDBBuilder.java:256)

        at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.createIndicesUsingStatements(JdbcDBBuilder.java:240)

        at com.ibm.team.repository.service.internal.db.util.JdbcDBBuilder.createIndicesForTable(JdbcDBBuilder.java:210)

        at com.ibm.team.repository.service.internal.rdb.DatabaseMaintenanceService.addIndexForSingleTable(DatabaseMaintenanceService.java:2005)

        ... 54 more

Caused by: java.sql.SQLException: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

        ... 62 more

2015-06-01 17:55:53,237 CRJAZ1791E The migration completed with errors. The imported database is unstable and should not be used without further analysis.


Even thought I set the fulltext.indexLocation property over step 0 to:
/app/rtc/IBM/WebSphere/AppServer/profiles/AppSrv01/conf/jts/indices/workitemindex

It continues to use /app/rtc/IBM/JazzTeamServer502/server/conf/jts/indices

Not sure what's the best way to proceed in this one...

Thanks for any help,
Raf.

4 answers



permanent link
Lily Wang (4.9k714) | answered Jun 01 '15, 9:55 p.m.
It seems some problem in the index. Could you please try to run 'repotools-jts -reindex' in both RTC 4.0.4 and RTC 5.0.2?
If the same error reported, you can try if the solution in https://jazz.net/forum/questions/91541/rtc-database-reindexing-fails-and-the-database-is-unusable works for you.


permanent link
Donald Nong (14.4k314) | answered Jun 01 '15, 10:29 p.m.
It looks very strange and you may need to contact Support to get it investigated further.

The error message says that duplicate values were found in column "APP_NAME" of table DISCOVERY.SERVICE_CONTRIBUTION_RESOURCE (SERVICE_CNTRBTN_RSRC) when the script tried to create a unique index on it. This column should have values such as "/ccm", "/qm" and/or "/rm", and etc. I can't imagine what duplicate values they will be.

permanent link
Rafael Pirolla (1617) | answered Jun 02 '15, 8:30 a.m.
Hello,

I have tried to reindex through both versions. 404 updates the index all right and 502 doesn't let me execute as there are repository differences. Even removing the index directory and recreating it as Spencer Murata reply does not solve the issue.

So yes, it seems very odd indeed:
Select count(*),APP_NAME
From JTS_OWNER.DISCOVERY_SERVICE_CNTRBTN_RSRC
Havind count(*) > 1
Group by APP_NAME

Gives:
COUNT(*)          APP_NAME
3             svuxdrtc1.gvt.net.br:9443/jts

I have opened PMR 80855,235,631 and will let this post updated with any resolution.

Regards,
Raf.

permanent link
Rafael Pirolla (1617) | answered Jun 23 '15, 9:39 a.m.
Nothing so far from IBM. The PMR is escalated to the DEV team. As this was our development environment we have wiped the DB and started the upgrade from scratch - all went well. I suppose this got into DEV environment by some wrong installation procedure or something alike.

Thanks,
Raf.

Your answer


Register or to post your answer.