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.
- 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.