D365 F&O on-premises | deployment failed for application financial reporting alias management reporter

During our installations and code deployments into Dynamics 365 for Finance and Operations on-premises we struggled a lot with one of the last steps of the installation: The financial reporting application. We have seen different issues till now. And there are several things to check when this step fails.

• Check EventLog of primary orchestrator node for error messages in the local-agent folder.
• Install ETW-Manisfest on the orchestrator node if not already there to check the MR logs:
  https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/deployment/troubleshoot-on-prem#mr
• Check the userinfo table of AX DB. There must be a user called FRServiceUser 
• Check if there are reports still checked out:
  
  select * from reporting.ControlReport where CheckedOutTo is not null

•  If yes just update the following tables (on your own risk):
  
  update Reporting.ControlReport

  set CheckedOutTo = null

  
  
  
  
  update Reporting.ControlRowMaster

  set CheckedOutTo = null

  
  
  
  
  update Reporting.ControlColumnMaster

  set CheckedOutTo = null

  
  
  
  
  update Reporting.ControlTreeMaster

  set CheckedOutTo = null

  
  

If all the above is not solving the issue you could also try to replace the financialReporting DB with an empty financialReporting database.