It's all about the answers!

Ask a question

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

Alphonso Smith (1112) | 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"

How do I get past the CRJAZ0577E and SQL0206 errors?

Here's what that repotools-jazz_rebuildIndices.log show...


java.sql.SQLException: [SQL0206] Column or global variable ITERATION_ID not found.

Kot T. commented 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?

One answer

permanent link
Eric Jodet (6.3k5111120) | answered 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


Alphonso Smith commented Oct 17 '13, 10:20 a.m.

 The history of our server is 1st...We upgraded from RTC 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.

 Hello Alphonso,

yes - you may run the 4.0.3 addTables
if you still have errors, please open a PMR -


Your answer

Register or to post your answer.