My Oracle Support Banner

"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 JUNE 18, 2019

Applies to:

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

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.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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