Error creating Software Asset Record

Products

• CA Service Management - Asset Portfolio Management
• ASSET PORTFOLIO MGMT- SERVER
• CA IT Asset Manager
• CA IT Asset Manager Asset Portfolio Management

Issue/Introduction

When attempting to create an Software Asset Record, we are encountering the following errors:

(System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_al_license_flags'. Cannot insert duplicate key in object 'dbo.al_license_flags'. The duplicate key value is (1000005). The statement has been terminated. at CA.Common.Web.Services.DataBroker.SaveCachedValuesToDatabase(List`1 uniqueCacheGroupIdList, Boolean forceFilterSaveSelected) at CA.Common.Web.UI.BasePage.SaveButton_Click(Object sender, EventArgs e) ClientConnectionId:378643b4-ab51-4888-9eeb-b3c50e869c86 Error Number:2627,State:1,Class:14)

Environment

CA IT Asset Manager 17.x

All Supported Operating Systems

Resolution

There are insert, update and delete triggers (screenshot below) on the al_license MDB table which were installed with CA SwCM (CA Software Compliance Manager) which  has been end-of-life (EOL) a decade ago.

These triggers are attempting multiple inserts on the al_license_flags table, leading to the PrimaryKey Violation error.

These triggers are not installed nor used by ITAM.

Please perform the following:

1. Connect to the MDB via SQL Server Management studio as an administrator.

2.  Expand Tables- > al_license table -> expand Triggers 

3.  Right click on each of them and select 'Disable'.

4.  Perform IISRESET on both App and Web servers and test Software asset creation.