AL2DCC40 job ABEND with DB13001E error when preparing for CA7 upgrade

Products

• Datacom
• Datacom/AD

Issue/Introduction

CA11 11.0 and CA7 12.1 use the same MUF.

ABEND=S000 U0004

DB13001E - UNEXPECTED RETURN CODE 94 (31) SEE SQL ERROR IN DIAG
                    DB10045E - ABNORMAL TERMINATION DUE TO ERROR(S)
Date:  8/24/2021    ********************************************************************************         Page:   107
                    *                                CA Datacom/DB                                 *
Time: 11.47.15      *                                General Utility                               *      Version: 15.0
                    *               COPYRIGHT (C) 1990-2013 CA.   ALL RIGHTS RESERVED.             *
                    ******************************************************************************** Directory: CAL7

                    CONTROL CARD(S)
                    .........1.........2.........3.........4.........5.........6.........7.........8
                    CONFIRM DBID=770,TABLE=VRQ

                    FUNCTION=CONFIRM
                       DBID=00770
                       TABLE=VRQ

DB10015E - NO EXECUTION DUE TO INDICATED ERROR(S)

Environment

Component: Datacom/AD

Cause

Datacom/AD DBID 770 was not initialized or updated.

RETURN CODE 94 (31)

Reason - You attempted to delete or update a referenced primary key value, or you attempted to add an invalid foreign key value.

 

 

 

Resolution

First run all AL2DCA* and AL2DBI03 jobs to initialize or update Datacom/AD DBID 770 then run all AL2DCC* jobs.

 

Additional Information

SQL Return Codes