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

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

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.