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:
- Create DDL using <SCHEMA> > <NAME> > Right Click > Generate DDL
- Change Procedure Name from 'DDL <NAME> 001' to 'DDL <NAME> PROD' Generation Folder: <NAME>_SVN.First Folder
- Generate the DDL
- Create new DDL using <SCHEMA> > <NAME> > Right Click > Generate DDL
- DDL UI does not appear and the error message pops up
The issue does not occur with the following names:
- 'DDL <NAME>'
- '<NAME> DDL'
- 'DDL <NAME> 234'
- 'DDL <NAME> PROD 009'
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 |