gs.swaroop2004

14.2 Patch 11 Load DWH failing

Discussion created by gs.swaroop2004 on Dec 14, 2016
Latest reply on Dec 15, 2016 by Suman Pramanik

Hi,

 

Our Load DWH is failing with this error.

 

ClarityDB - isOracle? - An error occurred executing this job entry :
Couldn't execute SQL: BEGIN
DWH_CFG_PRE_CONFIG_SP(
    P_DBLINK => 'PPMDBLINK.TE2.GBL.UBS.NET',
P_FULL_RELOAD => 'Y'
);
END;

 

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-02070: database  does not support  in this context
ORA-06512: at line 25
ORA-06512: at "PPM_DWH.DWH_CFG_PRE_CONFIG_SP", line 11
ORA-06512: at line 2

 

It was working fine before but I think something has been changed in the Database which is resulting in the above error.

Outcomes