ODI 12c Dimensions Mapping Fails Validation with a Null Pointer Exception (Doc ID 2280505.1)

Last updated on JULY 20, 2017

Applies to:

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

Symptoms

An Oracle Data Integrator (ODI) 12.2.1.2.6 Mapping built upon Dimensions fails validation with a Java Null Pointer Exception (JNPE), as noted by this error excerpt:

JNPE at oracle.odi.domain.mapping.component.dimension.DimensionPattern.validateSCDAttributesOnDimensionComponent (DimensionPattern.java.136)

Additionally, the click on the Mapping "Physical" tab shows the following error in the ODI Studio "Messages - Log" window:

Jul 20, 2017 8:10:59 PM oracle.odi.mapping
WARNING: Validation error found for component: DIM_CUSTOMER_V1

Jul 20, 2017 8:10:59 PM oracle.odi.mapping
WARNING: Logical mapping issues found when building physical design:
Java Exception thrown:
java.lang.NullPointerException
  at oracle.odi.domain.mapping.component.dimension.DimensionPattern.validateSCDAttributesOnDimensionComponent(DimensionPattern.java:136)
  at oracle.odi.domain.mapping.component.dimension.DimensionPattern.validate(DimensionPattern.java:77)
  at oracle.odi.domain.mapping.component.ExpandableComponentDelegate.customValidation(ExpandableComponentDelegate.java:900)
  at oracle.odi.domain.mapping.MapComponent.validate(MapComponent.java:3152)
  at oracle.odi.domain.mapping.MapComponentDelegator.validate(MapComponentDelegator.java:493)
  at oracle.odi.domain.mapping.MapComponentOwner.internalValidate(MapComponentOwner.java:1736)
  at oracle.odi.domain.mapping.MapComponentOwner.validate(MapComponentOwner.java:1686)
  at oracle.odi.domain.mapping.Mapping.validate(Mapping.java:933)
  at oracle.odi.domain.mapping.physical.MapPhysicalDesign.calculateSpec(MapPhysicalDesign.java:1601)
  at oracle.odi.domain.mapping.physical.MapPhysicalDesign.calc
...

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