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

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. 

 

Environment

CA Asset Portfolio Management 17.0

Cause

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

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.