"java.lang.NumberFormatException: For input string" Error while Clicking the "GENERATE DDL" Option on Model (Doc ID 2197183.1)

Last updated on SEPTEMBER 11, 2018

Applies to:

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

Generating DDL on ODI Model fails with the following error even before the "generate ddl " Wizard opens:

The error has been found to occur in two cases so far:

CASE 1:

If a procedure already exists with the same name for the specific Model.

The following error may be seen:

'java.lang.NumberFormatException: For input string: <Number>'

Ex.
'java.lang.NumberFormatException: For input string: "12121212004'

CASE 2:

When a procedure exists for the specific model AND the name was changed from the default name.

EXAMPLE:
Original name: DDL Oracle BI Applications 001
Changed name: DDL Oracle BI Applications Contract Header Start Date

Once the name was changed and the number removed, the error presented.

The error may present as:

java.lang.NumberFormatException: For input string: ""

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

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