My Oracle Support Banner

ODI 11g Generate DDL Requires a Completely New Name or a Numeric Value at the End (Doc ID 2493761.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 11.1.1.9.0 to 12.2.1.3.2 [Release 11gR1 to 12c]
Information in this document applies to any platform.

Symptoms

In Oracle Data Integrator (ODI) 11g, the following error occurs when attempting to generate a new DDL Procedure if the name is not completely changed, or a numeric value is not used at the end of the name.

java.lang.NumberFormatException: For input string: ""
  at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
  at java.lang.Integer.parseInt(Integer.java:592)
  at java.lang.Integer.parseInt(Integer.java:615)
  at com.sunopsis.graphical.dialog.SnpsDialogADHGenerateDDL.getTentativeTrtName(SnpsDialogADHGenerateDDL.java:618)
  at com.sunopsis.graphical.dialog.SnpsDialogADHGenerateDDL.resetName(SnpsDialogADHGenerateDDL.java:474)
  at com.sunopsis.graphical.dialog.SnpsDialogADHGenerateDDL.initialize(SnpsDialogADHGenerateDDL.java:288)
  at com.sunopsis.graphical.dialog.SnpsDialogADHGenerateDDL.(SnpsDialogADHGenerateDDL.java:140)
  at oracle.odi.ui.action.SnpsPopUpActionADHGenerateDDL.actionPerformed(SnpsPopUpActionADHGenerateDDL.java:64)
  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)
  ...

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

  1. Create DDL using <SCHEMA> > <NAME> > Right Click > Generate DDL
  2. Change Procedure Name from 'DDL <NAME> 001' to 'DDL <NAME> PROD' Generation Folder: <NAME>_SVN.First Folder
  3. Generate the DDL
  4. Create new DDL using <SCHEMA> > <NAME> > Right Click > Generate DDL
  5. DDL UI does not appear and the error message pops up

The issue does not occur with the following names:

Each of the above names will increment the trailing numeric value by 1, except '<NAME> DDL' which will not have a Numeric value at the end.

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.