ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Load Data warehouse full load job failed after enabled Include in the Data Warehouse option for multi valued lookups
Article ID: 102813
Updated On:
Products
Clarity PPM SaaS
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
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.
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:
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.
Feedback
Yes
No
Powered by
