My Oracle Support Banner

"ODI-1529" Error at Root Step of Load Plan when Evaluating Variable Calling odiRef.getSchemaName() if Context is not Provided (Doc ID 1620938.1)

Last updated on SEPTEMBER 30, 2020

Applies to:

Oracle Data Integrator - Version 11.1.1.6.3 to 11.1.1.7.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

Oracle Data Integrator (ODI) Load Plan root step will not evaluate a Variable calling odiRef.getSchemaName() when no Context is provided.

That is, the step will not get the Execution Context.

The Variable refreshes by calling:

odiRef.getSchemaName("pLogicalShema", "D")

which is a valid call of the method getSchemaName(), that is, no "contextName" is provided to the method.

If so, the step fails and with it the whole Load Plan, as the variable refresh fails by not finding the SchemaName, yet it works fine if the method is called
like:

odiRef.getSchemaName("pLogicalShema","contextName","D")


 The actual call is:

select TASK_VALUE
from <%=odiRef.getSchemaName( "<VALUE>","D" )%>.SBS_ODI_TASKS
where TASK_TYPE = 'ODI'
and TASK_NAME = 'MYTASK'
and TASK_VAR = 'MYVAR'

Error Message:

ODI-1529: Refresh of variable "<NAME>"
failed :
 SELECT TASK_VALUE
 FROM Exception getSchemaName("<VALUE>", "D") : SnpContext.getContextByCode : SnpContext does not exist.SBS_ODI_TASKS

 

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.