Clarity PPM: Load DWH Job Fails With Error Duplicate in DWH_FIN_TRANSACTION

Products

• Clarity PPM SaaS

Issue/Introduction

The full and incremental runs of the job fails with error in BG DWH log:

      INSERT INTO DWH_CMN_ERROR_MESSAGE VALUES ('DWH_FIN_TRANSACTION',V_EXCEPTION,V_SQLSTATE,V_SQL_TEXT);
        END;
        COMMIT;
        RAISE EXCEPTION '%', V_EXCEPTION; 
    END;
    COMMIT;
        CALL DWH_SAVEDROP_CREATE_INDEXES_SP('DWH_FIN_TRANSACTION','CREATE');
        CALL DWH_GATHER_TABLE_STATS_SP('DWH_FIN_TRANSACTION');
END $$
LANGUAGE PLPGSQL;

ERROR: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_FIN_TRANSACTION. duplicate key value violates unique constraint "dwh_fin_transaction_u3"
  Where: PL/pgSQL function inline_code_block line 23 at RAISE

Cause

There is a duplicate record in the view that feeds the DWH table.

There is a duplicated vendor code.

 

Resolution

This is reported as defect DE55384 and is currently under investigation.