Management Reporter Database Upgrade – SQL Timeout Error

While upgrading a client to Management Reporter (MR) 2012, the database upgrade failed due to a SQL timeout exception. The timeout setting was originally set to a time that could not do all conversions, causing the configuration to fail.

The solution:

1. Find the SQL timeout value setting in the MRConfigurationConsole file. This is in the Management Reporter folder (C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Console).

2. Change the value to a higher time for the conversion to complete. For us it was changing the 300 to 300000. MR

3. Restart the Configuration Console for changes to take effect. Configuration was successful.



Related News