Enterprise Insights: ETL job failing intermittently with PK Constraint error

XMLWordPrintable

    • 1
    • Severity 2 - Major
    • No
    • None

      Issue Summary

      ETL Jobs are failing intermittently because of a PRIMARY KEY constraint violation. Although retrying the ETL job might temporarily solve the issue, it's not an efficient solution and it's causing significant delays.

      Steps to Reproduce

      1. Wait for the ETL Job to run
      2. Check the ETL Job that failed

      Expected Results

      ETL Job should run successfully

      Actual Results

      Intermittently, ETL Jobs fail with the following error:

      Get Agile Object Key Records:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.

Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005
Description: "The statement has been terminated.".

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005
Description: "Voilation of PRIMARY KEY constraint

'PK_upd_Agile_Object_Key'. Cannot insert duplicate key in object 'dbo.upd_Agile_Object_Key'. The duplicate key value is

      Workaround

      Configure the SSIS Agent Job to force retries.
      Retry attempts: 3
      Retry interval (minutes): 2

            Assignee:
            David Guimbellot
            Reporter:
            Leo.Soronio
            Votes:
            7 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated:
              Resolved: