Clarity

  • 1.  Question on Incremental Load Data Warehouse Failures

    Posted Mar 21, 2018 08:28 AM

    Regarding the "Load Data Warehouse" job when run in incremental mode -- we are a SaaS environment and are having recurring issues with the job failing on the key violation shown below.  (Yes, I have a ticket open with CA Support.)  My question is, when this error occurs, does the job stop dead in its tracks, or does it continue on to its normal conclusion, reloading additional tables AFTER the error occurs?

     

    I'm trying to figure out if this failure only impacts 1 table (i.e., the one in the failure statement), or many tables (i.e., that one plus every other table that would follow in the ETL sequence).

     

    Does anyone know?  Any info would be much appreciated!

     

    Reload Facts 1? - An error occurred executing this job entry :  Couldn't execute SQL: BEGIN   DWH_INV_TASK_PERIOD_FACTS_LOAD (P_ARRAY_SIZE => 50000); END;  [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_INV_TASK_PERIOD_FACTS_LOAD. SQLERRM : ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_INTERNAL_MD. SQLERRM : ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found ORA-06512: at "SC51432PDWH.DWH_INV_TASK_PERIOD_FACTS_LOAD", line 56 ORA-06512: at line 2


  • 2.  Re: Question on Incremental Load Data Warehouse Failures

    Broadcom Employee
    Posted Mar 21, 2018 11:04 AM

    This is a known bug DE37008. This is fixed in 15.3 patch 2 



  • 3.  Re: Question on Incremental Load Data Warehouse Failures

    Posted Mar 21, 2018 01:24 PM

    Thanks for that feedback.  If 15.3 Patch 2 available yet, and if not, what is the anticipated release date?



  • 4.  Re: Question on Incremental Load Data Warehouse Failures
    Best Answer

    Broadcom Employee
    Posted Mar 21, 2018 01:28 PM

    15.3 patch 2 was made GA CA PPM 15.3 Cumulative Patch 2 (15.3.0.2) General Availability Announcement 

     

    So you can raise a ticket and request to apply the patch. 

     

    Regards

    Suman Pramanik