If the Mini-Sync fails during Employees, it is more than likely due to an Employee Master (EMPMAS) record being deleted without deleting the corresponding Employee Extension (EMPMSX) record. To find and delete any orphaned EMPMSX records:

1. Log on to the iSeries and get to a command line.
   
   
2. Start SQL with STRSQL.
   
   
3. Find all orphaned Employee Extension records with:
   SELECT EMPNJF FROM AMFLIBy/EMPMSX WHERE EMPNJF NOT IN (SELECT EMPNO FROM AMFLIBy/EMPMAS)
   
   
4. Issue delete statements for each number found:
   DELETE FROM AMFLIBy/EMPMSX WHERE EMPNJF = [Number found in previous statement]
   
   
5. Exit SQL with the F3 key.  Issue a 2 to not save.
   
   
6. Log off the iSeries.