...
Record failures of status 500 typically mean there was an issue with the EH server, with 400 meaning there was an issue with the request/data. For 500 errors you can just re-send, however 400 errors should be investigated as they may require updating the a view to handle bad data.
You can re-send failed emp_id’s by running the following two queries.
...