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
Article ID: 221770
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).
Feedback
Yes
No
Powered by
