Compliance Manager load job fails with -545 sqlcode

Products

• Compliance Manager for z/OS

Issue/Introduction

The Compliance Manager load job fails with:

SEC##02E  SQLD     - SQL Failure Detected (Diagnostic Location IRQO    ,    387)

SEC##03I  SQLD     - DSN00545E   THE REQUESTED OPERATION IS NOT ALLOWED BECAUSE A ROW DOES NOT SATISFY THE CHECK CONSTRAINT RESC_ACCESSOR_TYPE

SEC##04E  SQLD     - SQLCODE  =  -545

Environment

Release : ALL

Component : COMPLIANCE MANAGER FOR Z/OS

Resolution

The CA7 scheduler ACID associated with the scheduled Compliance Manager load job was not authorized to the DB2 objects. Authorizing the ACID associated with the job resolves the problem.