Deployment failed due to FinancialReporting Issue

Message: Module FinancialReporting failed

Detail:

System.InvalidOperationException: An error was encountered. Details may be found in the deployment logs at 'C:\ProgramData\Microsoft Dynamics ERP\Management Reporter\Logs' System.ServiceModel.FaultException 1 [Microsoft.Dynamics.Performance.Common.Contract.Reporting.ServiceFault]: (Faul Detail is equal to Microsoft.Dynamics.Performance.Common.Contract.Reporting.ServiceFault). at Microsoft.Dynamics.Performance.Deployment.FinancialReportingDeployer.Program.Main(String[]args) at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args) at System.AppDomain.ExecuteAssembly(String assemblyFile, String[] args) at System.AppDomain.ExecuteAssembly(String  assemblyFile, String[] args) at SetupCore.SetupManager.LaunchProcessInAppDomain(String startupExe, String workingDir, StringcurrentFolder, String[] moduleArgs) at SetupCore.Setupmanager.<>c_DisplayClass12_1.<InvokeModules>b__6()

ErrorCode: 0

MemberName: ErrorPrettify

SourceFile E:\Work\131\s\Source\LocalAgentEvents\LocalAgentEventSource.cs 

SourceLineNumber: 79

Solution

Check the FinancialReporting database if there are reports not checked out: 

  

select * from reporting.ControlReport where CheckedOutTo is not null 

If the query returns something then we can run those scripts for FinancialReporting: 

update Reporting.ControlReport 

set CheckedOutTo = null 

update Reporting.ControlRowMaster 

set CheckedOutTo = null 

update Reporting.ControlColumnMaster 

set CheckedOutTo = null 

update Reporting.ControlTreeMaster 
set CheckedOutTo = null