ODI 12c Validates Mapping with SET Component but Fails at Scenario Generation with Fatal Error "Caused by: JNPE"

(Doc ID 2316024.1)

Last updated on OCTOBER 19, 2017

Applies to:

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

Symptoms

In Oracle Data Integrator (ODI) 12c, generating a Scenario of a specific Mapping using the SET component fails even though the Mapping can be validated without errors.  The error message received is as follows:

Fatal Error when calling generation delegate for component KM XKM
SQL Set: null Caused by: JNPE
 at oracle.odi.domain.mapping.component.km.SQLSetCompKM.getSelectList(SQLSetCompKM.java:127)

To reproduce the behavior:

  1. Open ODI Studio > Designer and navigate to the Mapping.
  2. Edit the Mapping, and on the "Logical" tab, observe the (SET component).
         
  3. Click on the green check mark to validate the Mapping. Observe this works without errors.
          
  4. Attempt to generate a Scenario from the Mapping, and observe this fails.

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