Database error 0307 running CA Dispatch DSEXLOD(L) utility

Products

• Dispatch Output Mgmt

Issue/Introduction

We are attempting to run the database load utility DSEXLOD(L) to upload new records to our CA Dispatch database. The job is failing with a RC=16 and issues the following error messages:

*** CADSUPDT - Abnormally Terminated 
*** Data Base Error - 0307 

PROGRAM NAME ------ RDBTUPLO 
ERROR STATUS ------ 0307 
ERROR RECORD ------ RD-RCPRPT 
ERROR SET ------ RD-BASE-RCPRPT 
ERROR AREA ------ RD-AREA 
LAST GOOD RECORD--- RD-RCPRPT 
LAST GOOD AREA----- RD-AREA 
DML SEQUENCE ------ 00000165 

Environment

z/OS

Cause

This error is typically caused by trying to load DUPLICATE records into the CA Dispatch database. 

The term DUPLICATE records can mean either: 

A . That you have multiple records in your INPUT FILE that are exactly the same. 
B. Or, that you are trying to load a database record into the database that ALREADY EXIST. 

Resolution

To resolve the problem you are going to have to analyze and evaluate the records in your INPUT file (specified on the //CONVERT DD statement), identify the duplicate record(s), and delete them from the input file. 

To help you identify the duplicate records, review the output from the failed job, and look for messages similar to the following: 

- INPUT REJECTED, REC # - 0000010. ERROR: + CAGL002E *REPORT BASE RECORD TO BE ADDED ALREADY EXISTS 
- INPUT REJECTED, REC # - 0001977. ERROR: + CAGL017E *REPORT RECIP RECORD ALREADY EXISTS AND DUP FLAG NOT Y 


If you happen to be loading TYPE 3 Report Recipient records, and have the SAME RECIPIENT NAME defined on more than 1 record for the SAME REPORT/JOBNAME, then you are going to have to make sure that you have the DUPLICATE RECIPIENT flag located at offset/column 37 of those particular TYPE 3 records set to a 'Y'. AND, that you have the appropriate "Duplicate Recipient Sequence Number" value defined for those same recipients in offset/column 254 of your input file.