CA Datacom/AD 15.1 and CA 7 - RC 15(139)

Products

• DATACOM - AD
• CA 7 Workload Automation

Issue/Introduction

Running CA Datacom/AD 15.1 Multi-User . 

CA 7 fails due to security error : 

ICH408I USER(CA7STC  ) GROUP(STC     ) NAME(CA7*STC*ID          )

   PRODALT.DB00002.ATZ CL(DC@ABLE )                               

   INSUFFICIENT ACCESS AUTHORITY                                  

   FROM PRODALT.DB00002.* (G)                                      

   ACCESS INTENT(READ   )  ACCESS ALLOWED(NONE   )                

 

SQL INITIALIZATION:  MUF IS SECURED                                            

DBSRPPR: Initializing Source Cache                                              

-- DATA BASE SQL ERROR SUMMARY  1/23/2021 20:44:32  --                         

SQLSTATE R158B OCCURRED WITH SQL ERROR CODE -118 IN PROG    GETEN AT LINE 972 (D DSERV)

ERROR MESSAGE TEXT:    DSF 'D000' DB RETURN COMMAND = REDKG  FILENAME = ATZ  KEYNAME = ATZKS PGM = RTV

RETURN CODE FROM DB:   <15(139)>, FROM DSF: <D000>                             

AUTH-ID.PLAN NAME:     SYSADM.SQLSCPLAN                                        

COMMAND(STATEMENT ID): QEXEC(STATEMENT 16)                                      

JOB NAME:              CA7, RUN UNIT: 12376                                    

 

 

Environment

Release : 15.1 and 15.0 

Component : CA Datacom/AD

Cause

CA 7 user-id  has no read access to tables in system DBID 2 , DATA-DICT.

Resolution

Install CA Datacom SQL 15.1 PTF LU00602  .

Download here

Additional Information

SQL Source Cache