Dynamics 365 Finance and Operations (FinOps) datamart issue when refreshing SAT database

On one of our customer environment running D365-FO, we recently encountered an LCS issue while refreshing the SAT database from PROD. Even though the database was copied successfully from PROD to SAT, the environment status within LCS got stuck and it could neither be resumed or rolled-back. This of course blocked further actions from being executed on SAT such as deploying further packages or triggering another DB refresh. In our case, the process was failing on the last step (step 23)

DVT script for service model: MRProcessService on machine: <our-customer-server-name>

After some hours of investigations the final solution boiled down to manually resetting the SAT datamart on the SAT VM before trying to re-resume the process on LCS. After running the script below on SAT, the LCS job finishes successfully and you can sign it off.

Import-module .\MRDeploy.psd1
Reset-DatamartIntegration -Reason OTHER -ReasonDetail "DB Refresh"