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 Migration from DEV to UAT

728361Jul 3 2015 — edited Jul 6 2015

Hi,

I am using ODI 11.1.1.7 version and trying to migrate my project (interfaces, procedures, variables, KM, packages) from DEV (internal id -> 1) to UAT.

Earlier we didn't had different internal ID in UAT and faced issues. Then we changed the internal ID of work rep in UAT (internal id -> ) and re performed migration. Steps are:

1. Topology setup in UAT.

2. Migration of Models: Export models from DEV and import in UAT. Changed the context to "UAT" (In DEV my context was "DEV").

3. Migration of interfaces: We exported the XML of interfaces from DEV and imported in UAT. Migration report shows correct internal ID (as per UAT) but all the interfaces turned Yellow (originally in DEV they were Blue). Also the mapping is lost and I cannot see source table columns in mapping tab.

Error Message: The file being imported contains objects from a repository with id 2, but this repository is not decalared in the target repository,
would u like to declare and proceed with import.

If I give ok for the above am getting error like:

com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10032: You cannot import this object (DwgObject(com.sunopsis.dwg.dbobj.SnpModel): Interest).
A referenced object (DwgObject(com.sunopsis.dwg.dbobj.SnpModFolder): null = 1002) does not exist in the repository

Please let me know if this the right approach?

Appreciate your help...

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details