Management Reporter Error: An Error Occurred While Configuring ‘Management Reporter Application Service’ Part 2 – SQL Timeout

As mentioned in the last post, I’ve been having some fun with Management Reporter recently. Unfortunately, Integration Manager the errors it produces are often less than useful. After resolving the issue with the schema owner, the attempt to upgrade Management Reporter produced another generic error message:

Management Reporter 2012
An error occurred while configuring 'Management Reporter Application Service'. Check the deployment log for details.

I opened up the deployment log and quickly found the error (I’ll only post the significant parts of the log as it is quite long). I was pleased to see that the error message was a different one, which meant that I had at least successfully fixed the first error:

02/11/2015 09:45:14 - .Net SqlClient Data Provider: Msg -2, Level 11, State 0, Line 0 Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

The configuration of the Management Reporter Configuration Console is stored in a file called MRConfigurationConsole.exe.config. The file is stored in C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Console.

The screenshot below shows that the SqlTimeout value is set to 300 seconds which equates to 5 minutes:

I upped this to 3600 seconds (1 hour) and restarted the configuration. This particular error didn’t occur again, but check back tomorrow for the next error.