We have identified a case that necessitates an update to the Admin Tool for resolution. Currently, the fix for this issue has not been scheduled for a future Mosaic release.
In the interim, you can utilize the following SQL as a local report. This will allow you to comment on your database type and adjust the ‘to and from’ dates as needed:
SELECT id "ID",
batch_ref "BATCH REF",
time_stamp "TIME STAMP",
routine "ROUTINE",
severity "SEVERITY",
order_by "ORDER BY",
error_id "ERROR ID",
error_table_name "ERROR TABLE NAME",
step "STEP",
description "DESCRIPTION"
FROM error_log
--Amend to and from dates as required
WHERE time_stamp between convert(varchar,'2020-05-05', 23) AND convert(varchar,'2022-05-05', 23) --SQL SERVER DB
ORDER BY id desc
Upon running this SQL, you may encounter errors similar to the following:
ERROR: 547 The INSERT statement conflicted with the CHECK constraint ERROR: 547 The INSERT statement conflicted with the CHECK constraint "charge_pr_prv_pec_id_or_pe_id". The conflict occurred in database "Mostest", table "dbo.CHARGE_PERIOD_PROVISIONS". at line 815 in update_auto_contribs
The root cause of this issue is related to the uplift process. Uplift requests are initially given a status of “Error” at the start of the uplift process. They are only updated to “Successful” at the end of the process.
If the process is interrupted in any way, the successful flag isn’t set, and the individual error reasons aren’t created. It is the existence of these individual uplift element error reasons that make the button become available.
In the future, the Report to see errors will be available in the Mosaic Reports Repository 23.2, along with other manual uplift reports currently in the Report Repository.