In CA Asset Portfolio Management 17.0, we are seeing event service errors related to the audit_trail_id

book

Article ID: 8671

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

We have recently upgraded to CA Asset Portfolio Management 17.0.  The event service errors with: 

ERROR CA.Applications.EventService.EventService - Error Occured in Sync ITAM Audit: Error Code :515 Message Cannot insert the value NULL into column 'audit_trail_id', table '@arg_audpointer'; column does not allow nulls. INSERT fails. 

 

Cause

This is a known issue in the CA APM 17.0 GA release. 

Environment

CA Asset Portfolio Management 17.0

Resolution

Please contact support for an updated stored procedure named: AL_CMDB_AUDIT_SHARE .sql

The correction will also be included in the APM 17.0 #1 Rollup patch.