search cancel

Getting CAL2D309E SQL error at startup of CA 7

book

Article ID: 225672

calendar_today

Updated On:

Products

CA 7 Workload Automation

Issue/Introduction

When starting CA 7 after applying maintenance and you get the following SQL error:

CA7MUF:DB00135I - CONNECT TO CA7MUF          ADGCUL   JOB12345 GCU2     M
CA7MUF:DB00101I - STARTED JOB-CA7      NUMBER-12345 CXX=ADGCUL   MUFNAME=AD
CAL2D024I CA Datacom OPEN successful for SASSIQDC                            
CAL2D308E SQL error, Table(CA7_ACT_CPM_FLOW  ) Func(PREPARE) RC(-0124)       
CAL2D309E SQL error, PLAN MFWA.SASSIQDC_CA7040371MFWA DOES NOT EXIST         
V370030W CA7,CA7ONL,SYS00002,SYS21280.T141701.RA000.CA7.T1641554.H01.        

 

Note: The plan name can vary. There are multiple plans defined to the CA 7 database.

 

 

 

Cause

Some CA 7 maintenance require a new or updated plan for some of the CA 7 programs. If CA 7 maintenance require you import new plans, this specific PTF will document the actions in the HOLD DATA. 

Environment

Release : 12.0, 12.1

Component : CA-7

Resolution

You will need to run the AL2DCA70 job from the CAL2JCL library to install the new plans. Ensure you have copied the new plans from your CAL2EXP SMP install library to your actual runtime library before running the AL2DCA70 job.