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

Document ID : KB000008038
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.

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.