ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 227648

calendar_today

Updated On:

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.