Violation of PRIMARY KEY constraint in ITAM

book

Article ID: 221770

calendar_today

Updated On:

Products

CA Service Management - Asset Portfolio Management

Issue/Introduction

When adding asset to "Asset Configuration" the following error is received:

Violation of PRIMARY KEY constraint 'pkrel_asset_cfg_spec'.

Cannot insert duplicate key in object 'dbo.arg_rel_asset_cfg_spec'

Environment

Release : 17.1

Component : ITAM - Other

Resolution

Updated next_id field on table al_next_id to reflect the max+1 id of (table, field) (arg_rel_asset_cfg_spec, relationship_id).