Oracle Business Intelligence Applications

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

ODI Migration Issue

Received Response
11
Views
2
Comments

Hi,

so I have inherited part of this issue from someone else's set up.

Physical Oracle Architecture is not identical in Test and Production instances, so on using Smart Export I also have to manually change the physical name for the test environment to the Production equivalent and update the database physical connection and password post migration.

This works, but gives me two issues.

  1. If I then change anything trivial in the Production set up I get a Java error on trying to run the Package or regenerate its Scenario; -

ODI-26016 The requested operation cannot succeed. The object no longer exists.

java.lang.RuntimeException: java.lang.RuntimeException: com.sunopsis.core.SnpsInexistantObjectException: SnpProject.getObjectByIdent : SnpProject does not exist

2. If I try to migrate artifacts (mappings / models etc) incrementally to add to the package - it calls these dynamically at runtime - I get errors whichever type of import I try and typically they become global artifacts which is not the desired result

Any suggestions on either issue would be gladly received, though the first is most pressing.

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @Robert of STAU

    You issue seems like an below - Can you refer below MOS doc -

    "ODI-26016: The object no longer exists" Error Observed when Attempting to Open Oracle Technology from ODI Studio Topology (Doc ID 2319307.1)

    Regards,

    Arjun

  • sjbhe
    sjbhe Rank 1 - Community Starter

    I am getting the following error while performing SmartExport/Import -

    what is ODI-10017: This import is forbidden: the text 25,048 has a different origin in the repository and in the import file.

    Any suggestions?