My Oracle Support Banner

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:

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

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

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
Changes
Cause
Solution
 Set the "Execute Options" to false.
 Add the missing parameters to the procedure
References


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