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

Beta2a to M5 import errors

Questions
Tags
Users
Badges
Daan van der Munnik
(291●1●31●27) 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.

0 votes

5 answers
4,760 views
0 votes

5 answers

Permanent link
Ritchie Schacher - IBM
FORUM MODERATOR / JAZZ DEVELOPER (476●1●1) Mar 03 '08, 9:28 p.m.
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 votes

Permanent link
Aaron Cohen
JAZZ DEVELOPER (820●78●51) Mar 03 '08, 9:28 p.m.
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 votes

Permanent link
Daan van der Munnik
(291●1●31●27) 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 votes

Permanent link
Patrick Streule
JAZZ DEVELOPER (4.9k●2●1) Mar 04 '08, 5:38 a.m.
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 votes

Permanent link
Daan van der Munnik
(291●1●31●27) Mar 04 '08, 8:13 a.m.
ok, I have added a comment and re-opened work-item 43180

thanks

Daan.

0 votes

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: Mar 03 '08, 11:26 a.m.

Question was seen: 4,760 times

Last updated: Mar 03 '08, 11:26 a.m.

Confirmation Cancel Confirm