Clarity

  • 1.  14.2 Patch 11 Load DWH failing

    Posted Dec 14, 2016 06:05 AM

    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.



  • 2.  Re: 14.2 Patch 11 Load DWH failing

    Broadcom Employee
    Posted Dec 15, 2016 12:56 AM

    Hi Shanti,

     

    Will it be possible to provide the BG DWH log? We need to see the full trace in order to recommend the next steps.

     

    Regards

    Suman Pramanik