Ansicht
Dokumentation

CPD32C4 - Secondary referential constraint cannot be added. ( OS/400 )

CPD32C4 - Secondary referential constraint cannot be added. ( OS/400 )

Vendor Master (General Section)   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.
SAP E-Book


Message : CPD32C4
Secondary referential constraint cannot be added.

Message Long Text :

Cause . . . . . : Referential constraint &12 for dependent file &1 in library &2 is in error. Parent file &5 in library &6 has a delete rule of &10 and update rule of &11.
When a unique constraint or a primary key constraint is added to a file that is a parent file in a defined referential constraint with a dependent file, then the referential constraint of the dependent file is known as a secondary referential constraint. The referential constraint is regarded as secondary processing because the primary request is for the processing of the unique constraint or the primary key constraint.
The constraint was not added because of errors. The reason code is &7. The reason codes and their meanings are as follows:

00 - See previous messages.
01 - The dependent file or library does not exist but the system
cross reference file has a constraint entry for the file.
02 - The secondary referential constraint cannot be processed. The
system cross reference files indicate a referential constraint
exists for the added unique or primary key constraint but the
dependent file does not contain the referential constraint.
03 - Mismatch between the keys of the parent file and the dependent
file when processing a secondary referential constraint for
a unique or primary key constraint.
Recovery . . . :
01 - Perform a reclaim storage (RCLSTG).
02 - Perform a reclaim storage (RCLSTG).
03 - Remove the constraint (RMVPFCST) and add the constraint back
(ADDPFCST) with a KEY that matches the secondary referential
constraint.

Message File : QCPFMSG
Library Message File : QSYS2924


General Material Data   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.

Length: 3267 Date: 20240329 Time: 104518     sap01-206 ( 3 ms )