Violation of PRIMARY KEY constraint in ITAM

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).