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 DWH full error: "ORA-01735: invalid ALTER TABLE option"

book

Article ID: 190977

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

The Load Data Warehouse (DWH) full is failing with error: ORA-01735: invalid ALTER TABLE option
Full error below:
ClarityDB - isOracle? - An error occurred executing this job entry : 
Couldn't execute SQL: BEGIN
  FOR I IN (SELECT TABLE_NAME, CONSTRAINT_NAME 
 FROM USER_CONSTRAINTS
 WHERE  CONSTRAINT_TYPE = 'P' 
    AND    STATUS = 'DISABLED')
 LOOP
 EXECUTE IMMEDIATE 'ALTER TABLE ' ||I.TABLE_NAME|| ' ENABLE CONSTRAINT ' ||I.CONSTRAINT_NAME || ' EXCEPTIONS INTO DWH_FK_PK_EXCEPTIONS';
  END LOOP I; 
END;

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-01735: invalid ALTER TABLE option
ORA-06512: at line 7

Environment

Release : All

Resolution

Rebuild the DWH. See steps at When to rebuild the Data Warehouse (DWH) database