Getting "Failed to create OdiRef object for target" And ClassCastException When Trying To Run Mapping in ODI 12.1.3

(Doc ID 2074859.1)

Last updated on DECEMBER 13, 2016

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 to 12.1.3.0.1 [Release 12c]
Information in this document applies to any platform.

Symptoms

 After migrating from Oracle Warehouse Builder (OWB) 11.2.0.4 to Oracle Data Integrator (ODI) 12.1.3 successfully, Mappings that used to run fine in OWB fail in ODI with the following error, and the Session never starts:

Failed to create OdiRef object for target: xxxxx.
Please check the Validation Results window for more information.

 ... while the "Messages - Log" window shows:

WARNING oracle.odi.mapping.generation.GenerationException: Failed to create OdiRef object for target: xxxxx.
  at oracle.odi.domain.odireference.OdiRef.initialize(OdiRef.java:419)
  at oracle.odi.domain.odireference.OdiRef.<init>(OdiRef.java:276)
  at oracle.odi.domain.mapping.generator.MappingGenerator.createOdiRef(MappingGenerator.java:3078)
  at ...
Caused by: oracle.odi.mapping.generation.GenerationException: Failed to initialize OdiDataSetRef object
  at oracle.odi.domain.odireference.OdiDataSetRef.<init>(OdiDataSetRef.java:154)
  at oracle.odi.domain.odireference.OdiRef.initialize(OdiRef.java:361)
  ... 111 more
Caused by: java.lang.ClassCastException: oracle.odi.mapping.generation.CorrelatedQuery cannot be cast to oracle.odi.mapping.generation.Expression
  at oracle.odi.domain.odireference.OdiDataSetRef.getNewExpressionForMerge(OdiDataSetRef.java:506)
  at oracle.odi.domain.odireference.OdiDataSetRef.getNewExpressionForMerge(OdiDataSetRef.java:496)
  at oracle.odi.domain.odireference.OdiDataSetRef.getNewExpressionForMerge2(OdiDataSetRef.java:536)
  at oracle.odi.domain.odireference.OdiDataSetRef.extractExpressionText(OdiDataSetRef.java:382)
  at oracle.odi.domain.odireference.OdiDataSetRef.initialize(OdiDataSetRef.java:211)
  at oracle.odi.domain.odireference.OdiDataSetRef.<init>(OdiDataSetRef.java:152)
  ... 112 more

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms