AnsweredAssumed Answered

Load Datawarehouse Job Fails - Full Load

Question asked by Augustin2537 on Jun 28, 2017
Latest reply on Jul 3, 2017 by Augustin2537

We are in 14.2. When we try to run the Load Datawarehouse Job as a full load, it fails within few seconds with the following error. It looks like there is no table name passed as a first parameter.

 

An error occurred executing this job entry :
Couldn't execute SQL: BEGIN
CMN_DISABLE_CONSTRAINTS_SP(NULL,'PK');
END;

 

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-01735: invalid ALTER TABLE option
ORA-06512: at "PPM_DWH.CMN_DISABLE_CONSTRAINTS_SP", line 25
ORA-06512: at line 2

 

Can somebody please help?

@NIKA HADZHIKIDI

 

Regards

Augustin#

Outcomes