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

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

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

It's all about the answers!

Related questions

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

One answer

Your answer