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

Microsoft Dynamics GPAs 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.

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:

MRConfigurationConsole.exe.config

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.

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.