Error "Exception GetOption("JMSDELIVERYMODE") : Option Does Not Exist ("JMSDELIVERYMODE")" when Generating Scenario of Procedure or Package in ODI 12c (Doc ID 2486481.1)

Last updated on DECEMBER 08, 2021

Applies to:

Symptoms

After a successful smart import of an Oracle Data Integrator (ODI) 11g package into ODI 12c, scenario generation of the imported package fails with the following error:

java.lang.RuntimeException: java.lang.RuntimeException: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Exception getOption("JMSDELIVERYMODE") : Exception getOption("JMSDELIVERYMODE") : Option does not exist ("JMSDELIVERYMODE")
  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)
  at oracle.odi.ui.action.SnpsPopupActionGenerateScenHandler.actionPerformed(SnpsPopupActionGenerateScenHandler.java:94)
  at oracle.odi.ui.SnpsActionControler.handleEvent(SnpsActionControler.java:94)
  at oracle.ide.controller.IdeAction$ControllerDelegatingController.handleEvent(IdeAction.java:1488)
  at oracle.ide.controller.IdeAction.performAction(IdeAction.java:663)
  at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:1159)
  at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:618)
  at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
  ...
Caused by: java.lang.RuntimeException: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Exception getOption("JMSDELIVERYMODE") : Exception getOption("JMSDELIVERYMODE") : Option does not exist ("JMSDELIVERYMODE")
  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:748)
Caused by: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Exception getOption("JMSDELIVERYMODE") : Exception getOption("JMSDELIVERYMODE") : Option does not exist ("JMSDELIVERYMODE")
  at com.sunopsis.dwg.snpreference.SnpReference.getUserExit(SnpReference.java:14216)
  at com.sunopsis.dwg.snpreference.SnpReference.getOption(SnpReference.java:8863)
  at com.sunopsis.dwg.codeinterpretor.SnpGenerator.getJMSParamForSnpsJDBCDrivers(SnpGenerator.java:1769)
  at com.sunopsis.dwg.codeinterpretor.SnpGenerator.treatSQLTxt(SnpGenerator.java:2402)
  at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.treatGenProcedureJob(SnpGeneratorSQLCIT.java:8061)
  at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.treatJobProcedure(SnpGeneratorSQLCIT.java:11630)
  at com.sunopsis.dwg.codeinterpretor.SnpGeneratorSQLCIT.treatPackageStep(SnpGeneratorSQLCIT.java:12142)
  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 package that fails to generate has procedures that are set to "JMS Queue XML" as Target technology. Attempting to generate a scenario of the procedure results in the same error. The error does not occur in 11g.

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.