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 and later
Information in this document applies to any platform.


On Oracle Data Integrator (ODI), 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).


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

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