My Oracle Support Banner

Groovy Variable in Global Scope No Longer Works in ODI (Doc ID 2522651.1)

Last updated on JUNE 16, 2022

Applies to:

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


The following error related to a missing Groovy variable is received after upgrading to Oracle Data Integrator (ODI) or later:

ODI-1217: Session <SESSION_NAME> fails with return code ODI-1298.
ODI-1226: Step <STEP_NAME> fails after 1 attempt(s).
ODI-1227: Task <TASK_NAME> fails on the source connection .
ODI-1298: Serial task <TASK_NAME> failed because child task <TASK_NAME> is in error.
ODI-1298: Serial task <TASK_NAME> failed because child task <TASK_NAME> is in error.
ODI-1590: The execution of the script failed.
Caused By: org.apache.bsf.BSFException: exception from Groovy: groovy.lang.MissingPropertyException: No such property: hive for class: _
  at org.codehaus.groovy.bsf.GroovyEngine.exec(
  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(

In this example, the variable "hive" is declared in the previous step, "Prepare Hive Session" as:

hive = new flexUtilHive( odiRef.getJDBCConnection("SRC") )


Upgrade from another ODI version to ODI


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.