Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

CRJAZ0577E error and SQL0206 received on repotools-jazz -rebuildIndices command

Questions
Tags
Users
Badges
Alphonso Smith
(11●1●2) edited
Oct 16 '13, 1:32 p.m.

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.

0 votes

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?

1 answer
7,550 views
0 votes

One answer

Permanent link
Eric Jodet
JAZZ DEVELOPER (6.3k●5●111●120) Oct 17 '13, 5:41 a.m.
 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

0 votes

Comments
Alphonso Smith
Oct 17 '13, 10:20 a.m.
 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.

Eric Jodet
JAZZ DEVELOPER Oct 17 '13, 10:31 a.m.
 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

Your answer

Register or log in to post 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Oct 16 '13, 11:22 a.m.

Question was seen: 7,550 times

Last updated: Oct 17 '13, 10:31 a.m.

Confirmation Cancel Confirm