Running CORACLEANUP errors with: ErrorCode: -2147217873,WordErrorCode:3119, IDispatch error 3119, Violation of PRIMARY KEY constraint aud_ca_owned_resource_PK. Cannot insert duplicate key in object dbo.aud_ca_owned_resource

book

Article ID: 49217

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

The following trigger on the ca_owned_resource table needs to be disabled.
Run the following sql command against the mdb to disable the trigger:
DISABLE TRIGGER dbo.ca_tr_upd_ca_owned_resource ON dbo.ca_owned_resource
After disabling the trigger, run CORACLEANUP again, then ENABLE the trigger again before running APM.

Environment

Release: UAPMAC990JPP-12.6-Asset Portfolio Management-Asset Configuration
Component: