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

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

Back to top