Duplicate Record Joblogs

The Migration Database Analyzer report should have been used to identify and clean up duplicate records. If duplicate records are found during the CPYF process, the CPYF Conversion report will have an error message CPF2972 indicating that has occurred. Joblogs are produced for each file with a duplicate record issue. Use the WRKSBMJOB command to look for joblogs by file to see if any copies failed because of duplicate records. You will need to analyze the data to identify each duplicate record. You might decide to combine the data into one record or in some cases it might be possible to change a key field to make the record unique. This option must be done with care as it could compromise the integrity of the data. When merging the data or changing the key is not an option, you must delete one of the records.

Once the duplicate records are cleaned up in the JD Edwards World file, you can use the CPYF command with MBROPT (*REPLACE) and FMTOPT (*MAP *DROP) to copy the data from the JD Edwards World file to the JD Edwards EnterpriseOne 9.2 table. If you are unable to clean up all the duplicate records in the JD Edwards World file, set the Errors allowed parameter on the CPYF command to *NOMAX, so you bring over as much data from the JD Edwards World file as possible. You can also create a new version of P98881 and change the data selection to run the CPYF program for specific files.