Load Data warehouse full load job failed after enabled Include in the Data Warehouse option for multi valued lookups

Article Id: 102813

Status: Published

Updated On: 20-06-2018 08:47

Products:

CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , Clarity PPM SaaS - Application , Clarity PPM On Premise

Issue/Introduction:

If the lookup_id contains a space the Load Data Warehouse fails with the following error:

CREATE_LKP_TAB - org.pentaho.di.core.exception.KettleStepException:
Error while running this step!

And referencing your table:

Couldn't execute SQL: CREATE TABLE DWH_LKP_YOUR TABLE_00
(
CLARITY_UPDATED_DATE DATE,
DW_UPDATED_DATE DATE

Cause:

This is caused by a space in the Lookup_id.

In general PPM does not allow for spaces or special characters in the ID, but there have been occasions where this did happen.

Environment:

Release: CODFSS99000-15.3-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution:

Either do not include the attribute in the data warehouse or if you do need it in DWH then you will need to create a new lookup and attribute and then move values from the old attribute to the new one.