Load DW Fails Invalid Identifier

Article Id: 107525

Status: Published

Updated On: 20-07-2018 13:20

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:

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.

Additional Information:

Please reference https://docs.oracle.com/cd/B19306_01/em.102/b40103/app_oracle_reserved_words.htm

for a complete list of Oracle Reserved Words

Load DW Fails Invalid Identifier - Reserved word