Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ODI - Smart Export import in same environment giving error.

Received Response
2
Views
2
Comments

Hi,

We are using BIApps 11.1.1.8 with ODI Version 11.1.1.7 .

As per BIApps migration strategy when we move objects from lower environment (Dev) to Higher environment(UAT) process is as below.

1. Smart Export objects to exported from Dev.

2. Copy files from Dev machine to UAT machine.

3. Smart Export Context/Topology from UAT environment.

4. Smart Import files copied on machine in step 2.

5. Smart Import Context/Topology that was done in step 3.

But when we are doing step-5 we are getting below Error.

oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10093: You are importing an object from another repository with the same identifier. It is forbidden.

  at com.sunopsis.dwg.smartie.SmartImportManager.runSmartImport(SmartImportManager.java:2397)

  at oracle.odi.impexp.smartie.impl.ISmartImportInstanceImpl.runSmartImport(ISmartImportInstanceImpl.java:346)

  at oracle.odi.ui.smartie.imp.ImportSmartWizard$1.doInBackground(ImportSmartWizard.java:251)

  at oracle.odi.ui.smartie.imp.ImportSmartWizard$1.doInBackground(ImportSmartWizard.java:1)

  at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)

  at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)

  at java.lang.Thread.run(Thread.java:662)

Caused by: oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10093: You are importing an object from another repository with the same identifier. It is forbidden.

  at com.sunopsis.dwg.smartie.RunSmartImport.run(RunSmartImport.java:2436)

  at com.sunopsis.dwg.smartie.SmartImportManager.runSmartImport(SmartImportManager.java:2385)

  ... 6 more

Caused by: oracle.odi.impexp.smartie.OdiSmartImportException: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10093: You are importing an object from another repository with the same identifier. It is forbidden.

  at com.sunopsis.dwg.smartie.RunSmartImport.internalRunImportForTempObjList(RunSmartImport.java:1194)

  at com.sunopsis.dwg.smartie.RunSmartImport.internalRun(RunSmartImport.java:2164)

  at com.sunopsis.dwg.smartie.RunSmartImport.access$5(RunSmartImport.java:2139)

  at com.sunopsis.dwg.smartie.RunSmartImport$2.doAction(RunSmartImport.java:2300)

  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

  at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:64)

  at com.sunopsis.dwg.smartie.RunSmartImport.internalRunWorkAndMaster(RunSmartImport.java:2279)

  at com.sunopsis.dwg.smartie.RunSmartImport.run(RunSmartImport.java:2428)

  ... 7 more

Caused by: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10093: You are importing an object from another repository with the same identifier. It is forbidden.

  at com.sunopsis.dwg.CheckImportRepCoherenceCallBackForNonGui.importFromAnotherRepositoryWithSameIdIsForbidden(CheckImportRepCoherenceCallBackForNonGui.java:38)

  at com.sunopsis.dwg.DwgDuplicationTools.checkTheImportRepCoherence(DwgDuplicationTools.java:2815)

Repository Details are as Below

Dev Master and Work Repository Number:- 501

Dev Master and Work Repository Number:- 551

As per document it should work, but it is not working.

Can you please help us with this.

Regards,

Mahesh

Answers

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Hi -

    Has this worked before?

    Also, kindly clarify this (you have Dev twice):

    Dev Master and Work Repository Number:- 501Dev Master and Work Repository Number:- 551

    Regards,

    Charles

  • Mahesh25
    Mahesh25 Rank 2 - Community Beginner

    Yes, it used to work previously.