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
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.
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.