It's all about the answers!

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

×42,884

question asked: Mar 03 '08, 11:26 a.m.
question was seen: 4,545 times
last updated: Mar 03 '08, 11:26 a.m.

Related questions

Beta2a to M5 import errors

0
Daan van der Munnik (291●1●31●27) | asked Mar 03 '08, 11:26 a.m.
Hi,

When importing our Beta2a database into our new M5 installation, we get the following import errors:

Importing deferred items...
Rebuilding indices...
com.ibm.team.repository.service.internal.db.util.JdbcDB$1: Error preparing or executing statement => CREATE UNIQUE INDEX MODEL.UNIQUE_PATH ON MODEL.CATEGORY(PROJECT_AREA_ITEM_ID, INTERNAL_CATEGORY_ID)
com.ibm.team.repository.service.internal.db.util.JdbcDB$1: Error preparing or executing statement => CREATE UNIQUE INDEX MODEL.UNIQUE_PATH ON MODEL.CATEGORY(PROJECT_AREA_ITEM_ID, INTERNAL_CATEGORY_ID)
Error rebuilding index.Exception occurred creating indices for schema MODEL. See log for details

Is this ok, or should we be worried..

thanks

Daan.

5 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Ritchie Schacher - IBM (476●1●1) | answered Mar 03 '08, 9:28 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
This looks a lot like the problem reported in Category constraint violation
migrating from M3 to Beta2 (43180) (web).

I would be worried about the error, as it means a constraint was violated in
the database. I'd suggest you comment in the bug and either reopen it or
file a new related bug.

--
Ritchie

**********************************************
Ritchie Schacher
Jazz Repository/Server Team
"dvdmunni" <daan.van.der.munnik@philips-dot-com.no-spam.invalid> wrote in
message news:fqh8uf$5bj$1@localhost.localdomain...
Hi,

When importing our Beta2a database into our new M5 installation, we
get the following import errors:

Importing deferred items...
Rebuilding indices...
com.ibm.team.repository.service.internal.db.util.JdbcDB$1: Error
preparing or executing statement => CREATE UNIQUE INDEX
MODEL.UNIQUE_PATH ON MODEL.CATEGORY(PROJECT_AREA_ITEM_ID,
INTERNAL_CATEGORY_ID)
com.ibm.team.repository.service.internal.db.util.JdbcDB$1: Error
preparing or executing statement => CREATE UNIQUE INDEX
MODEL.UNIQUE_PATH ON MODEL.CATEGORY(PROJECT_AREA_ITEM_ID,
INTERNAL_CATEGORY_ID)
Error rebuilding index.Exception occurred creating indices for schema
MODEL. See log for details

Is this ok, or should we be worried..

thanks

Daan.
0
permanent link
Aaron Cohen (820●78●51) | answered Mar 03 '08, 9:28 p.m.
JAZZ DEVELOPER
Hello Daan,

It looks like you may have hit a bug. Lets create a defect to notify
the Development team. First lets gather some information. What database
are you using? DB2, Oracle, or Derby? Also was the Beta2a data an
upgrade from a previous version? For instance did you go from M3 to Beta2a?

Thanks!


dvdmunni wrote:
Hi,

When importing our Beta2a database into our new M5 installation, we
get the following import errors:

Importing deferred items...
Rebuilding indices...
com.ibm.team.repository.service.internal.db.util.JdbcDB$1: Error
preparing or executing statement => CREATE UNIQUE INDEX
MODEL.UNIQUE_PATH ON MODEL.CATEGORY(PROJECT_AREA_ITEM_ID,
INTERNAL_CATEGORY_ID)
com.ibm.team.repository.service.internal.db.util.JdbcDB$1: Error
preparing or executing statement => CREATE UNIQUE INDEX
MODEL.UNIQUE_PATH ON MODEL.CATEGORY(PROJECT_AREA_ITEM_ID,
INTERNAL_CATEGORY_ID)
Error rebuilding index.Exception occurred creating indices for schema
MODEL. See log for details

Is this ok, or should we be worried..

thanks

Daan.
0
permanent link
Daan van der Munnik (291●1●31●27) | answered Mar 04 '08, 3:28 a.m.
We are using Derby.

The data has been migrated between Milestones from the start, so yes it has been migrated from M3 to Beta2a.

regards

Daan.
0
permanent link
Patrick Streule (4.9k●2●1) | answered Mar 04 '08, 5:38 a.m.
JAZZ DEVELOPER
Importing deferred items...
Rebuilding indices...
com.ibm.team.repository.service.internal.db.util.JdbcDB$1: Error
preparing or executing statement => CREATE UNIQUE INDEX
MODEL.UNIQUE_PATH ON MODEL.CATEGORY(PROJECT_AREA_ITEM_ID,
INTERNAL_CATEGORY_ID)
com.ibm.team.repository.service.internal.db.util.JdbcDB$1: Error
preparing or executing statement => CREATE UNIQUE INDEX
MODEL.UNIQUE_PATH ON MODEL.CATEGORY(PROJECT_AREA_ITEM_ID,
INTERNAL_CATEGORY_ID)
Error rebuilding index.Exception occurred creating indices for schema
MODEL. See log for details

Please see
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/43180

Regards,
Patrick
Jazz Work Item Team
0
permanent link
Daan van der Munnik (291●1●31●27) | answered Mar 04 '08, 8:13 a.m.
ok, I have added a comment and re-opened work-item 43180

thanks

Daan.

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.