Forum Stats

  • 3,815,486 Users
  • 2,259,038 Discussions
  • 7,893,134 Comments

Discussions

ODI 11G - Problem to Export Import Interface between DEV and TEST Env

BenFreez
BenFreez Member Posts: 60 Red Ribbon
edited Jul 16, 2018 1:54PM in Data Integrator

Hi all,

I am trying to Export an Folder who is containing a Interface. This interface is using a Models.

To do my export, i followed the steps below :

- Export and Import the Model (Duplication) : Everything is working fine and i am able to visualize the data.

- Export and Import the Folder with the Interface (Duplication) : Import done without error but when i am opening the folder, my interface is in yellow. I have the error message saying Object referenced in this interface are missing.

The missing objetc is my source table but i already tested and the source is in the models already.

Please is one of you faced to that problem  ?

Thanks in advance for your help.

Best regards,

Ben

Tagged:

Answers

  • Adrian_Popescu-Oracle
    Adrian_Popescu-Oracle RomaniaPosts: 1,976 Employee
    edited Jul 5, 2018 5:00PM

    Hi Ben,

    If you have ODI 11.1.1.6 or later, always use Smart Export/Import to transfer ODI objects between environments.

    Smart Export/Import of an object automatically takes care of the references.

    Then drag and drop from Designer your objects.

    Adrian

    Smart export.png

    Smart export2.png

    BenFreez
  • Pavan8u
    Pavan8u Member Posts: 278 Silver Badge
    edited Jul 6, 2018 6:36AM

    Hi,

    If you use Duplicate mode ODI will create new object id, which will cause the issue.

    Consider in dev environment you have a table with ID -1, and you tried to import model with duplciation mode in other environment. In this case there is no guarantee that EMP table will have same ID-1 in prod which results in error you are facing.

    Delete the objects and try using INSERT_UPDATE mode.

    Hope this helps.

    Regards,

    Pavan

    BenFreez
  • BenFreez
    BenFreez Member Posts: 60 Red Ribbon
    edited Jul 16, 2018 1:53PM

    Hi Adrian,

    Thanks a lot for your help. I will check this feature

    Best regards,

    Ben

  • BenFreez
    BenFreez Member Posts: 60 Red Ribbon
    edited Jul 16, 2018 1:54PM

    Hi Pavan8u,

    Big thanks for this informations. I will test the import by using the method you provided to me.

    Best regards,

    Ben

This discussion has been closed.