Change Internal ID of ODI Repository

Change Internal ID of ODI Repository:

Hi Guys!!
I have a quick post on renumbering the internal id of ODI repositories. Please take backup of your repositories before attempting below steps. Otherwise you might lose your valuable projects.

Change Internal ID of ODI Repository

Right click on the work repository and click renumber

repository_renum2

 

Click Yes.

repository_renum3

repository_renum4

 

Provide the new ID.

repository_renum5

repository_renum6

 

Click Yes.

repository_renum7

repository_renum8

repository_renum9

 

You are done!!.

Thank you for reading.

0

About the author

Bhabani(http://dwteam.in) - Currently Bhabani is working as Sr Development Engineer at Harman International. He has good expertise on Oracle, Oracle Data Integrator, Pervasive Data Integrator, MSBI, Talend and Java. He is also contributing in ODI-OTN forum for last 5 years. He is from India. If you want to reach him then please visit contact us page. If you have any doubts or concerns on the above article, please put your question here. Dw Team will try to respond it as soon as possible. Also dont forget to provide your comments / suggestions / feedback for further improvement. Thanks for your time.

Similar Posts

3 comments

Hello Bhabani,

I tried changing internal id of my repository, but all the times, appears the message: “ODI-23044: The new ID you have chosen is already in use as a table “SNP_VAR_DATA” primary key. The renumbering has been aborted. No changes have been made.”
I deleted the register at the table SNP_VAR_DATA that was using the number and the problem goes on. Do you have any idea?

Thanks!

Renato, I encountered the “The new ID you have chosen is already in use” error. I simply changed the new ID to a high number (900) and I got past that error. Unfortunately, now I’m getting a new error: “ORA-02292: integrity constraint (ODI_MASTER_REP_V7B.FK_VERSION_SNP_DAT) violated – child record found”.

I’m currently upgrading ODI. I think I will leave my repository ID alone in Dev and just try to change the IDs in the upper environments.

Hi Renato,

I have the same problem, with some id´s i´ve got to start the renumbering process but failed with no specific error, could you resolve your problem?

Thank you.

Leave a replay to Oracle ODI Cancel reply

required*

Are you a human? *