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 to [Release 12c]
Information in this document applies to any platform.


 After migrating from Oracle Warehouse Builder (OWB) 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(
  at oracle.odi.domain.odireference.OdiRef.<init>(
  at oracle.odi.domain.mapping.generator.MappingGenerator.createOdiRef(
  at ...
Caused by: oracle.odi.mapping.generation.GenerationException: Failed to initialize OdiDataSetRef object
  at oracle.odi.domain.odireference.OdiDataSetRef.<init>(
  at oracle.odi.domain.odireference.OdiRef.initialize(
  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(
  at ...


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.