"ODI-15405: Scenario generation exception: Failed to generate scenario." Error Received when Running ODI 12c Package or Generating Scenario from Package (Doc ID 2493412.1)

Last updated on SEPTEMBER 22, 2022

Applies to:

Symptoms

A Package has been configured in Oracle Data Integrator (ODI) 12.2.1.2.6.

After upgrading successfully from ODI 12.2.1.2.6 to 12.2.1.3.0, running the same Package (or attempting to generate a Scenario from the Package) results in the following error:

java.lang.RuntimeException: java.lang.RuntimeException: oracle.odi.generation.OdiScenarioGeneratorException: ODI-15405: Scenario generation exception: Failed to generate scenario.
at oracle.odi.ui.framework.adapter.DefaultAdapter.executeBackgroundTask(DefaultAdapter.java:636)
at oracle.odi.ui.framework.UIFramework.executeBackgroundTask(UIFramework.java:452)
at com.sunopsis.graphical.scenario.DwgScenGeneratingWizard.generate(DwgScenGeneratingWizard.java:71)
...
Caused by: java.lang.RuntimeException: oracle.odi.generation.OdiScenarioGeneratorException: ODI-15405: Scenario generation exception: Failed to generate scenario.
at com.sunopsis.graphical.scenario.DwgScenGeneratingWizard$1$1.doAction(DwgScenGeneratingWizard.java:98)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:64)
...
Caused by: oracle.odi.generation.OdiScenarioGeneratorException: ODI-15405: Scenario generation exception: Failed to generate scenario.
at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.treatPackageStep(SnpGeneratorSQLCIT.java:12115)
at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.mainGenPackageScenario(SnpGeneratorSQLCIT.java:3313)
at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.mainGenScenSourceScenario(SnpGeneratorSQLCIT.java:13305)
...
... 7 more

The issue can be reproduced at will with the following steps:

1. Open ODI Studio and connect to the master/work repositories.
    
2. Attempt to generate a Scenario for the Package which was working correctly in ODI 12.2.1.2.6. 
   Alternatively, run the Package using an Agent, or in Simulation mode.
    
3. Observe the error stack indicated above.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.