MDM Repository unarchive problem

[Former Member]

Hello,

As a refresher procedure we are following the process of archiving MDM repository on production first and then unarchive on required target systems.

some time unarchiving not working so best to delete existing archive repository.

I have executed following things to delete repository archive at oracle level (As it is not able to mount on MDM Console) after many try I got success

So it may be helpful for others who want to delete repository directly from oracle

1) Delete the repository from Database

Step 1 u2013 Connect to the Database using the Database Management tool (SQL for oracle)

Step 2 u2013 Delete the databases - RepositoryName_z000 and RepositoryName_m000

(drop user RepositoryName_z000 cascade;

drop user RepositoryName_m000 cascade;)

Step 3 u2013 Delete repository specific entry from the table A2i_Catalogs in A2i_xCat_DBs database

(delete from A2i_xCat_DBs.A2i_Catalogs where CATALOG_TAG='SRM_MDM_MASTER_BRIDGE';)

2) Unarchive the repository from old archive

3) Load the repository

Regards,

Nitin Salunkhe

[Former Member]

Many thanks Nitin,

I was just doing the same thing because the delete repository in MDM console does not seems to work properly.

It helps a lot !!!! ( especially the table name A2i_Catalogs )

thanks again for sharing this info !!!!

Regards

Jean-Louis

[Former Member]

this is just information for others