Compliance Manager load job is now failing with a -545 sqlcode

Products

• Compliance Manager for z/OS

Issue/Introduction

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 : 2.0

Component : CA COMPLIANCE MANAGER FOR Z/OS

Resolution

CA7 scheduler id associated with the Scheduled Compliance Manager load job is not authorized to the DB2 objects. Authorizing the acid associated with the job resolves the problem.