Load DW Fails Invalid Identifier - Reserved word
book
Article ID: 107525
calendar_today
Updated On:
Products
CLARITY PPM FOR ITG
CLARITY PPM FEDERAL
Clarity PPM SaaS
Clarity PPM On Premise
Issue/Introduction
Load DWH job failing with error:
Invalid Identifier at:
ALTER TABLE DWH_LKP_INDEX ADD INDEX VARCHAR2(255)
Note the lookup ID is INDEX.
Cause
The lookup was using the reserved word INDEX.
Environment
Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:
Resolution
Create a calculated attribute as a string to pull in the existing data from the original attribute and use that attribute in the data warehouse.
Feedback
thumb_up
Yes
thumb_down
No