When editing an asset, an error appears "Another user updated this record after it was loaded".

book

Article ID: 8038

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

When editing an asset or updating an asset using the ITAM Data Importer an error appears:

"Another user updated this record after it was loaded".

Cause

This is caused by a problem with the trigger "ca_tr_upd_usp_owned_resource" trigger on the "usp_owned_resource" table in the MDB?

Examining the trigger definition, the LEFT OUTER JOIN statement was:

LEFT OUTER JOIN dbo.aud_usp_owned_resource auditid WITH (NOLOCK) ON auditid.audit_trail_id = trlid.audit_trail_id WHERE trlid.audit_trail_id IS NOT NULL

This is missing an AND condition on the end.

Environment

Release: UAPMAC990JPP-12.9-Asset Portfolio Management-Asset Configuration
Component:

Resolution

Modify the trigger "ca_tr_upd_usp_owned_resource" trigger on the "usp_owned_resource" so that the LEFT OUTER JOIN statement has an additional condition:

LEFT OUTER JOIN dbo.aud_usp_owned_resource auditid WITH (NOLOCK) ON auditid.audit_trail_id = trlid.audit_trail_id WHERE trlid.audit_trail_id IS NOT NULL AND auditid.audit_trail_id IS NULL

Once this change has been made, it will take immediate effect.