You may see errors in the event log when PeoplePlanner attempts to send absences to SelectHR, such as:
Error occurred in 'AccessSelect.HR.Logic.DataHub.AbsenceCreatedHandler': The absence cannot overlap an existing sickness. (xxxxx). Cannot insert the value NULL into column 'Absence Number', table 'SelectHR.Absence.DaysOverride'; column does not allow nulls. INSERT fails. The statement has been terminated.
These errors occur when PeoplePlanner tries to create an absence in SelectHR that overlaps with existing sickness records, or when a conflict arises during absence creation. This prevents the new record from being successfully imported.
Check the employee record causing the issue
In SelectHR, click Admin, then Admin again.
Click Integration.
Click Received From Datahub.
Review the list and identify which employee has an error with their absence import.
Delete the conflicting absence in SelectHR
Navigate to the affected employee's record.
Go to Absence History.
Locate and delete the existing absence that is causing the conflict.
Once deleted, the updated absence can be reimported from PeoplePlanner.
Prevent future issues with overlapping absences
In PeoplePlanner, open the Absence Type settings.
Tick the box for Disable Concurrent Unavailability.
Save your changes.
This will help prevent duplicate or overlapping absences from being sent to SelectHR.