Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI Unique Constraint Error when creating Procedure

User13393553-OracleAug 9 2010 — edited Aug 11 2010
Hi,

I have a created a local work repository and imported the models and projects to this repository from the Development repository.

For Project reasons, our plan is to work on local repository and then export the changes to development work repository.

I have created local work repository with same internal id 402 as that of development work repository as they are different servers.

The import is successful to the local environment but when i try to create a procedure it gives me unique constraint errors.

I think the reason for this is that ODI is trying to create a procedure with same internal id which already exists in the project tables.

Is there a way, that i can find the max internal ids of objects from the development work repository and then set up my local work repository settings to create internal ids greater than that???

Thank you in Advance.

Regards,
Swapna.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2010
Added on Aug 9 2010
4 comments
1,247 views