My Oracle Support Banner

"ODI-17546: Specified variable not found in the Repository" when Using ODI Project Code String Containing Extended ASCII Characters (Doc ID 2616029.1)

Last updated on MAY 15, 2020

Applies to:

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

Symptoms

On Oracle Data Integrator (ODI) 12.2.1.3.0, a project uses a code string (set on the project Definition page) that contains a non-Basic ASCII character (for example, a character from the Latin-1 set). A procedure is created within this project that defines a variable. The procedure is generated into a scenario, which is then executed. The session fails with the following error:

ODI-1217: Session <PROCEDURE_NAME> () fails with return code 7000.
Caused By: java.lang.Exception: ODI-17546: Specified variable not found in the Repository : <PROJECT_CODE_CONTAINING_NATIONAL_CHARACTER><VARIABLE>

However, the string displaying the project code displays the character as an encoded value. For example, the character '£' displays as "&#xA3;" and character 'Ã' displays as "&#xC3;".

The same scenario may work when executed on Studio using the Local (No Agent).

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.