Error "ODI-26016 : The requested operation cannot succeed, The object no longer exists" Encountered When Generating/Regenerating Scenarios in ODI

(Doc ID 2311541.1)

Last updated on OCTOBER 04, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

After migrating objects to a new Oracle Data Integrator (ODI) repository and attempting to generate or regenerate a package scenario in Studio, the following error is displayed:

ODI-26016 : The requested operation cannot succeed, The object no longer exists.
Detailed Error:
com.sunopsis.core.SnpsInexistantObjectException: SnpPschemaCont.getObjectByIdent : SnpPschema does not exist
 at com.sunopsis.dwg.dbobj.SnpPschema.getObjectByLSchemaNameAndContext(SnpPschema.java:117)
 at com.sunopsis.dwg.dbobj.SnpPschema.getSnpPSchemaCont(SnpPschema.java:140)
 at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.treatJobPopCollectionBuild(SnpGeneratorSQLCIT.java:7764)
 at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.preComputePop(SnpGeneratorSQLCIT.java:7742)
 at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.treatJobPop(SnpGeneratorSQLCIT.java:7642)
 at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.mainGenPopInternal(SnpGeneratorSQLCIT.java:3314)
 at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.treatPopSourceSet(SnpGeneratorSQLCIT.java:10777)
 at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.treatJobPop(SnpGeneratorSQLCIT.java:7651)
 at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.treatPackageStep(SnpGeneratorSQLCIT.java:10563)
 at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.mainGenPackageScenario(SnpGeneratorSQLCIT.java:2914)
 at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.mainGenScenSourceScenario(SnpGeneratorSQLCIT.java:11585)
 ...

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms