Version 9.1.181 (1 September 2025)

Imports

Errors (#136080)

Problem

• The user import cannot transfer people due to the error Global appointment error, Failed to process transfers, details: Cannot insert duplicate key row in object 'JobProfiler.Appointments' with unique index 'IX_Appointments_UserId_RulesetId_EndDate'. The duplicate key value is (831760, 168, 2026-03-31 00:00:00.0000000). The statement has been terminated. 

Solution

• Change the order of the bulk insert in the appointment command to first update existing records and then add new records to avoid this conflict on the end date.

Missing Employee (#135967)

Problem

• Import fails to stage more than 2100 users 

Solution

• Implement batching for Dapper queries when removing duplicate users for the staging queue.

Audit

Development Environment and Infrastructure for 2025 (#125158)

Problem

• Sign-in history on the people profile did not receive the correct user ID, and the query which retrieved the history had a bug where it returned history for ALL users instead of filtering on the user it received. 

Solution

• Ensure that the correct user ID is retrieved and fix the query to always filter on the user ID. 

Data Warehouse

Send job completion mail (#135969)

Problem

• The package email step does not email all the execution results 

Solution

• Adjusted the script and added a step that will be used to retrieve the latest SQL Job results for the ExecuteSequence SSIS package

Daily Server Monitoring Checks 2025 (#125159)

Problem

• The lmEmployeeTrainingRequirementsMatrix is executing very long due to the current script logic, and it refreshes all the data every day 

Solution

• Added a date filter to only refresh recent data and implemented a performance improvement within the SQL Script

Performance Management

[Copy from Previous] Search filters not reset, but results are (#133833)

Problem

• When a user opens a modal to create a contract from another person, searches, then proceeds to cancel and reopens the modal, the results are reset, but not the search text. 

Solution

• Implement a change to reset the search text as soon as the results are reset and populated when the modal opens