RQM6.0: Re-Building DB Indices error: CRJAZ0577E The following SQL query did not execute properly on the server: DROP INDEX EXECUTION.
The following error when running re-index on QM v6 after upgrading it from v502 (no errors were shown whenrunning upgrade script)
COMMAND: ./repotools-qm.sh -rebuildIndices ERROR: [wasadmin@ratsuite193 server]$ ./repotools-qm.sh -rebuildIndices Repo Tools Provisioning using "./conf/qm/provision_profiles". Quality Management - Core Libraries, Version 6.0 (I20150519_1442) JazzFoundation - Core Libraries, Version 6.0 (RJF-I20150519-1056) To submit questions about issues, go to the Jazz.net forum at https://jazz.net/forum. To find more information about a message, see the online product documentation. CRJAZ1363I Loading the configuration from "file:conf/qm/teamserver.properties". CRJAZ1778I This server is configured asan application. CRJAZ1365I The server is attempting to connect to the following database: "//ratsuite197.sby.ibm.com:60000/QM:user=xxxxxxxx password=xxxxxxxx;" CRJAZ1364I The connection to the following database was successful: Db Product Name: DB2/AIX64 Db Product Version: SQL10056 Db URL: jdbc:db2://ratsuite197.sby.ibm.com:60000/QM:user=xxxxxxxx;password=xxxxxxxx; Jdbc Driver Name: IBM Data Server Driver for JDBC and SQLJ Jdbc Driver Version: 4.17.28 CRJAZ2558I Setting the local server rename state to false and the openServerDescriptionServiceTemporarily state to false. CRJAZ1970I The application is configured with: Public URI: " https://ratsuite193.sby.ibm.com:9443/qm" (https://ratsuite193.sby.ibm.com:9443/qm%22) Jazz Team Server location: " https://ratsuite191.sby.ibm.com:9443/jts/" (https://ratsuite191.sby.ibm.com:9443/jts/%22) CRJAZ2523I Setting the global server rename state to false and the validation state to false.Rebuilding the indices for the database "//ratsuite197.sby.ibm.com: 60000/QM:user=xxxxxxxx;password=xxxxxxxx;". CRJAZ0577E The following SQL query did not execute properly on the server: DROP INDEX EXECUTION. XCTNTSKRSLTCSTMTT0 [187cc587] CRJAZ0577E The following SQL query did not execute properly on the server: DROP INDEX EXECUTION. XCTNTSKRSLTCSTMTT0 CRJAZ1217E The indices could not be rebuilt for the following database: "//ratsuite197.sby.ibm.com:60000/QM:user=xxxxxxxx; password=xxxxxxxx;" |
3 answers
This was fixed in 6.0.1 (see Database Indices error after upgrade from 5.0.2 to 6.0.1 (139274) and Database Indices error after upgrade from 5.0.2 to 6.0.1 (362446)).
Comments
Rajesh Avanthi
commented Sep 11 '15, 7:06 a.m.
Thanks Paul
You have two options:
|
I have the same issue:
2015-09-18 23:38:55,896 CRJAZ0577E The following SQL query did not execute properly on the server: DROP INDEX EXECUTION.XCTNTSKRSLTCSTMTT0 com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-669, SQLSTATE=42917, SQLERRMC=null, DRIVER=4.17.28 |
Now, I won't update this CLM to v601, do you know if you will release an iFix to fix this issue for v6.0 ??
Thanks. Comments This fix (Database Indices error after upgrade from 5.0.2 to 6.0.1 (362446)) is not included in an iFix since there isn't an APAR issued for the Foundation defect. Please open a new PMR (http://www-01.ibm.com/support/docview.wss?uid=swg21507639).
Roberto Gomez
commented Sep 28 '15, 4:17 p.m.
Actually, we have a PMR S1, but the Rational Developers Team commented us the new iFix will be delivered next Oct 15, 2015.... the concern here is that our customer requires this issue will be fixed ASAP... they won't be waiting until October, maybe you can help me to follow up this issue.
Roberto, please work with IBM Support.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
Have you checked the repotools log file, or the DB2 diagnostic log files for more detailed error messages? Also, any reason for you to run the "repotools-qm.sh -rebuildIndices" command?