How To Fix 5K173 - No. of exported employees does not match no. of records in import file

SAP Error Message - Details

• Message type: E = Error

• Message class: 5K - HR: Messages for Canada

• Message number: 173

• Message text: No. of exported employees does not match no. of records in import file

What causes this issue?

The ROE Workbench compared the number of employee ROE records in the
file being imported with the list of employees whose current ROE status
for this Run ID is <ZH>Exported</>, and encountered a discrepancy in
the process. This can occur if one or more of the employee ROE records
were voided or deleted in the ROE Workbench <ZH>before</> the import
run was executed.

System Response

The ROE Importer continues to import the selected form(s).

How to fix this error?

From the ROE Workbench, execute the <ZH>ROE History Viewer</> to review
and verify the current status for all employees in this Run ID.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message 5K173 - No. of exported employees does not match no. of records in import file ?

  The SAP error message 5K173, which states "No. of exported employees does not match no. of records in import file," typically occurs during the data import process, particularly when dealing with employee data in SAP systems. This error indicates a mismatch between the number of employee records that were exported from the SAP system and the number of records present in the import file being processed.
  Causes:
  
  Mismatch in Record Count: The number of records in the import file does not match the number of records that were exported. This could be due to missing records, additional records, or a corrupted file.
  File Format Issues: The import file may not be in the expected format, leading to incorrect parsing of records.
  Data Corruption: The import file may have been corrupted during transfer or saving, leading to discrepancies in the record count.
  Incorrect Mapping: If the fields in the import file do not match the expected fields in SAP, it may lead to issues during the import process.
  Filtering or Selection Criteria: If the export process included filters or selection criteria that were not applied during the import, it could lead to a mismatch.
  
  Solutions:
  
  Verify Record Count: Check the number of records in both the exported file and the import file. Ensure they match.
  Check File Integrity: Ensure that the import file is not corrupted. You can do this by opening the file in a text editor or spreadsheet application to verify its contents.
  Review Export/Import Process: Ensure that the same criteria used during the export process are applied during the import process. If any filters were used, make sure they are consistent.
  Validate File Format: Ensure that the import file is in the correct format (e.g., CSV, TXT) and that it adheres to the expected structure defined by SAP.
  Check for Missing Records: If records are missing from the import file, you may need to re-export the data or manually add the missing records.
  Consult Documentation: Refer to SAP documentation or help resources for specific guidelines on the import/export process for employee data.
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message.
  Transaction Codes: Familiarize yourself with relevant transaction codes such as PA40 (Personnel Actions) or PA30 (Maintain HR Master Data) that may be involved in the import/export process.
  Data Migration Tools: If you are using tools like LSMW (Legacy System Migration Workbench) or BAPIs for data import, ensure that the configurations are correct.
  Testing: Before performing a large import, consider testing with a smaller dataset to ensure that the process works as expected.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to resolve it.