CRJAZ0577E error and SQL0206 received on repotools-jazz -rebuildIndices command
Received errors while running the following command...
"repotools-jazz -rebuildIndices teamserver.properties=conf/jazz/teamserver.properties"
How do I get past the CRJAZ0577E and SQL0206 errors?
Here's what that repotools-jazz_rebuildIndices.log show...
CREATE INDEX JAZZREPO01.CMMNSNPSHTTRTNDX0 ON JAZZREPO01.CMMNSNPSH3(ITERATION_ID)
java.sql.SQLException: [SQL0206] Column or global variable ITERATION_ID not found.
One answer
Hello Alphonso,
I did extensive searches on jazz for SQL0206 mixed with CRJAZ0577E in the context of a rebuildIndices command,
nothing found.
From the above:
- repotools-jazz
--> assuming you are using an upgraded server - right?
- java.sql.SQLException: [SQL0206] Column or global variable ITERATION_ID not found
--> so a column is not found
I would assume that the addTables command was missed from last upgrade.
1 - could you confirm "history" of your server?
2 - what is current version?
3 - try and run repotools-jazz -addTables?
- verify resulting log has no error and possibly paste it here
- try and run the rebuildIndices after and let us know the outcome
Thanks,
Eric
Comments
The history of our server is 1st...We upgraded from RTC 2.0.0.1 to JTS 3.0.1.
...then we upgraded from 3.0.1 to 4.0.3.
Our current version is 4.0.3
When I look at the current repotools-jazz_addTables.log, the very last line says...
2013-09-18 15:27:10,972 CRJAZ1791E ERROR Migration completed with errors. The imported database is in an inconsistent state and should not be used without further analysis.
I'm not sure what this means.
I could re-run repotools-jazz -addTables (again), check the log for errors, and then run the rebuildIndices if you think this will resolve the issue that I am having.
Hello Alphonso,
yes - you may run the 4.0.3 addTables
if you still have errors, please open a PMR - https://jazz.net/help/support/
Thanks,
Eric
Comments
Kot T.
JAZZ DEVELOPER Oct 16 '13, 12:43 p.m.In repotools-jazz_rebuildIndices.log, does it show the SQL statements that cause SQL0206 errors? Could you add the error stack here?