ODI OdiWaitForData parameter fails with errors: ODI-1217, ODI-1226, ODI-1241, java.lang.NullPointerException (Doc ID 2399991.1)

Last updated on OCTOBER 04, 2022

Applies to:

Symptoms

An Oracle Data Integrator (ODI) 11g package using the OdiWaitForData tool parameter in an interface returns the following error:

ODI-1217: Session <PACKAGE_NAME> (<ID>) fails with return code 7000.
ODI-1226: Step OdiWaitForData 1 fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
Caused By: java.lang.NullPointerException
....

<Field name="field_name" type="java.lang.String"><![CDATA[OdiWaitForData "-CONTEXT=GLOBAL" "-GLOBAL_ROWCOUNT=1" "-LSCHEMA=<ODI_SCHEMA>" "-POLLINT=1000" "-TIMEOUT=0" "-TIMEOUT_WITH_ROWS_OK=YES" "-UNIT_ROWCOUNT=1" "-INCREMENT_DETECTION=YES" "-INCREMENT_MODE=MEMORY" "-TABLE_NAME=Table_Name" "-OBJECT_TYPE=T" ]]></Field>
<Field name="ErrorMessage" type="java.lang.String"><![CDATA[java.lang.NullPointerException
  at oracle.odi.core.datasource.DataSourceDefinition.equals(DataSourceDefinition.java:79)
  at java.util.HashMap.getEntry(HashMap.java:468)
  at java.util.HashMap.get(HashMap.java:418)
  at java.util.Collections$SynchronizedMap.get(Collections.java:2037)
  at org.springframework.util.CachingMapDecorator.get(CachingMapDecorator.java:248)
  at java.util.Collections$SynchronizedMap.get(Collections.java:2037)
  at oracle.odi.core.DataSourceManager.getDataSource(DataSourceManager.java:152)
  at oracle.odi.core.OdiInstance.lookupDataSource(OdiInstance.java:985)
  at oracle.odi.core.datasource.dwgobject.support.DwgConnectConnectionCreatorImpl.createDwgConnectConnection(DwgConnectConnectionCreatorImpl.java:60)
  at com.sunopsis.dwg.tools.WaitForData.actionExecute(WaitForData.java:356)
  ...

The issue can be reproduced at will with the following steps:

1. Create a package.
2. Add and configure OdiWaitForData.
3. Run the Package.

Changes

Cause

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