Generating an ODI 12c Scenario Results in Error "ODI-15405: Scenario generation exception: Failed to generate scenario" (Doc ID 2411888.1)

Last updated on AUGUST 16, 2018

Applies to:

Symptoms

On Oracle Data Integrator (ODI) Studio 12.2.1, when attempting to generate a scenario, the following error occurs.

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:77)
  ...
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:104)
   at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
   at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:64)
   at com.sunopsis.graphical.scenario.DwgScenGeneratingWizard$1.doInBackground(DwgScenGeneratingWizard.java:84)
   at com.sunopsis.graphical.scenario.DwgScenGeneratingWizard$1.doInBackground(DwgScenGeneratingWizard.java:78)
   at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
   at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)
   at java.lang.Thread.run(Thread.java:745)
Caused by: oracle.odi.generation.OdiScenarioGeneratorException: ODI-15405: Scenario generation exception: Failed to generate scenario.
   at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.treatPackageStep(SnpGeneratorSQLCIT.java:12118)
   at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.mainGenPackageScenario(SnpGeneratorSQLCIT.java:3319)
   at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.mainGenScenSourceScenario(SnpGeneratorSQLCIT.java:13308)
   at oracle.odi.generation.support.ScenarioUtils.generateNewScen(ScenarioUtils.java:358)
   at com.sunopsis.graphical.dialog.SnpsDialogScen.generateScen(SnpsDialogScen.java:218)
   at com.sunopsis.graphical.scenario.DwgScenGeneratingWizard.internalGenerate(DwgScenGeneratingWizard.java:161)
   at com.sunopsis.graphical.scenario.DwgScenGeneratingWizard.access$000(DwgScenGeneratingWizard.java:52)
   at com.sunopsis.graphical.scenario.DwgScenGeneratingWizard$1$1.doAction(DwgScenGeneratingWizard.java:100)
   ... 7 more

The issue can be reproduced by attempting to generate/regenerate a specific scenario.

Cause

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