My Oracle Support Banner

"Failed to create OdiRef object for target" And ClassCastException When Trying To Run Mapping in ODI 12.2.1 After Migration from OWB (Doc ID 2213139.1)

Last updated on FEBRUARY 01, 2019

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 to 12.2.1.2.0 [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.2.1 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:425)
  at oracle.odi.domain.odireference.OdiRef.<init>(OdiRef.java:286)
  at oracle.odi.domain.mapping.generator.MappingGenerator.createOdiRef(MappingGenerator.java:3149)
  at ...
Caused by: oracle.odi.mapping.generation.GenerationException: Failed to initialize OdiDataSetRef object
  at oracle.odi.domain.odireference.OdiDataSetRef.<init>(OdiDataSetRef.java:158)
  at oracle.odi.domain.odireference.OdiRef.initialize(OdiRef.java:370)
  at ...
Caused by: java.lang.ClassCastException: oracle.odi.mapping.generation.WrappedCorrelatedQuery cannot be cast to oracle.odi.mapping.generation.Expression
  at oracle.odi.domain.odireference.OdiDataSetRef.getNewExpressionForMerge(OdiDataSetRef.java:508)
  at ...

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.