ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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