It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,884
×6,034
×4,321

question asked: Oct 16 '13, 11:22 a.m.
question was seen: 4,933 times
last updated: Oct 17 '13, 10:31 a.m.

Related questions

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

0
Alphonso Smith (11●1●2) | asked Oct 16 '13, 11:22 a.m.
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.

Comments
Kot T. commented Oct 16 '13, 12:43 p.m.
JAZZ DEVELOPER

In repotools-jazz_rebuildIndices.log, does it show the SQL statements that cause SQL0206 errors? Could you add the error stack here?

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Eric Jodet (6.3k●5●111●120) | answered Oct 17 '13, 5:41 a.m.
JAZZ DEVELOPER
 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
Alphonso Smith commented 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 commented Oct 17 '13, 10:31 a.m.
JAZZ DEVELOPER

 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 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.