ERROR dwh.event audit table name - & DWH_CFG_AUDIT in Load dataware house full load

book

Article ID: 185594

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

ERROR 2020-02-20 13:03:38,958 [dwh_jb_pre_execution UUID: 42ffa408-7f6c-4520-a78f-dfd69e4089c6] dwh.event audit table name -  & DWH_CFG_AUDIT

While running the Load dataware house full load multiple errors with the DWH_CFG_AUDIT table without any statement in the bg_dwh.logs and also in bg_ca.logs .

Cause

Multiple error with DWH_CFG_AUDIT without any statement of duplicate or unique index . Eventually DWH_CFG_AUDIT table did get update when the load dataware house jobs in-spite of error in the logs. This errors are info as there is no duplicate or constraint error in the indexes.  

Environment

Release : 15.X

Component : CA PPM APPLICATION

Resolution

Navigate to security.logs via editing the URL after action:security.logs and open log configuration. Kettle Log level should be set to Minimal until you are not facing any issue in Load dataware house full load and Load dataware house increment jobs. 

Attachments