Cannot "Mark as Complete" an ODI 12c Failed Load Plan

(Doc ID 2384756.1)

Last updated on APRIL 23, 2018

Applies to:

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

Symptoms

The following error is observed in the Oracle Data Integrator (ODI) 12c Agent log file when attempting to "Mark as Complete" a failed Load Plan:

[2017-11-21T16:07:57.180+01:00] [odi] [ERROR] [] [oracle.odi.core.persistence.jpa.JpaOdiTransactionManager] [tid: 17] [ecid: ####xxx##xxxx##xxxx#xx###xxx######,0] javax.persistence.RollbackException: Exception [EclipseLink-26] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DescriptorException[[
Exception Description: Trying to get value for instance variable [loadplan] of type [org.eclipse.persistence.indirection.ValueHolderInterface] from the object [oracle.odi.domain.runtime.lpi.OdiLoadPlanInstanceException]. The specified object is not an instance of the class or interface declaring the underlying field.
Internal Exception: java.lang.IllegalArgumentException: Can not set org.eclipse.persistence.indirection.ValueHolderInterface field oracle.odi.domain.runtime.lpi.OdiLoadPlanInstance.loadplan to oracle.odi.domain.runtime.lpi.OdiLoadPlanInstanceException
Mapping: org.eclipse.persistence.mappings.OneToOneMapping[loadplan]
Descriptor: RelationalDescriptor(oracle.odi.domain.runtime.lpi.OdiLoadPlanInstance --> [DatabaseTable(SNP_LP_INST)])
  at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:159)
  at oracle.odi.core.persistence.jpa.JpaOdiTransactionManager.doCommit(JpaOdiTransactionManager.java:387)
  at ...

Changes

 

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