Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter SQ...
Microsoft Dynamics GP (Archived)

Management Reporter SQL Timeout Error

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

WHen trying to run a report, in MR, the below error is logged in the event viewer. Is there a timeout setting that can be changed?

Event Type: Error
Event Source: Management Reporter Services
Event Category: None
Event ID: 0
Date:  5/4/2011
Time:  3:55:12 PM
User:  N/A
Description:

 Timestamp: 5/4/2011 3:55:12 PM
 Message: System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.AccountBalanceReader.Open()
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLBalanceResult.GetNextReader()
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLDataProcessor.ProcessOneBalanceResult(GLBalanceResult balanceResult, Int32 rowNumber)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLLinkAdapter.RetrieveGLDataBatch(Int32 rowNumber)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.GLLinkAdapter.GetData()
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportUnitProcessor.RetrieveLinkData()
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportUnitProcessor.RetrieveData()
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportProcessor.RunAllUnitProcessors()
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.ReportGenerator.ProcessReport(Definition definition, Action`1 resultHandler)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.EngineController.GenerateReport(Action`1 resultHandler)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.EngineController.Run(NativeReport repositoryReport, Definition definition)
   at Microsoft.Dynamics.Performance.Reporting.Engine.Server.QueueWatcher.WatchQueue()


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Thanks,

 

Sandeep.

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter SQL Timeout Error

    Guys,

    This post has really helped me but certain things are not clear/information is distributed, so here's what I have done.

    We are on AX 2012 R3 and MR 2016 version

    Two things:

    1. On MRConfigurationConsole.exe.config file - can be found at C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Console

    Made sure SqlTimeout value=0 - you can find this under <configuration>

    2. On MRServiceHost.settings.config file - can be found at C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Services

    Updated AXReaderTimeout value to 160 and SqlBulkCopyTimeout value to 6000 and SqlQueryTimeout value to 6000.

    Remember these values vary by user, so increment these in numbers of 20, run the report, if it does not work, increment again.

    Hope this helps.

    Thanks,

    Vishal

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter SQL Timeout Error

    Management Reporter  

    Vers. 2012

    UC015.

    Error: Management Reporter SQL Timeout Error

    the source system provider was unable to complete the request.

    An internal error ocurred in the provider. Additional information is available in the event viewer on the Management Reporter Server. Pleas contact your administrator.

    Requesting data

    Retrieving data

    Setting up

    Writing report structure.

    Solution:  

    a) Set timeout on the server console , add the SQLTIMEOUT entry in the configuration file that is in .. \ Management Reporter\2.1 \ Server \ Console \ with the name MRConfigurationConsole.exe.config

     

    b ) Set timeout in the service, in the fields AxReaderTimeout, 

    GPReaderTimeout and IntegrationReaderQueryAttempts found in the file in
    Management Reporter\2.1\Server\Services\
    with the name MRServicesHost.setting.config

  • Ryan Sandness Profile Picture
    Ryan Sandness on at
    Re: Management Reporter SQL Timeout Error

    Hi Brent,

    This file is read-only so it doesn't get updated during Management Reporter updates. You can add the settings to the file manually, or if you uninstall the services and reinstall with Rollup 2 these settings will be in the new file.

    Support can also assist with troubleshooting timeouts if you want to open a ticket with them.

    Thanks

    Ryan

  • Brent Kiley Profile Picture
    Brent Kiley 30 on at
    Re: Management Reporter SQL Timeout Error

    Hello,

    We are having a similar issue with GP2010 and MR2012. We didn't have any of those lines in our MRServiceHost.settings.config. I added them and it didn't seem to help. For MRServiceHost.exe.config I don't have a line or section like that. Does anyone know how I can add it to see if that will help?

    Thank you,

    Brent

  • Joseph Noufaily Profile Picture
    Joseph Noufaily 130 on at
    Re: Management Reporter SQL Timeout Error

    Hi Sandeep,

    Thank you for the help.

    At last it worked and this is what i did:

    In MRServiceHost.exe.config i changed the value of this line

     <setting name="ReaderTimeout" serializeAs="String">

     <value>480</value>

    In MRServiceHost.settings.config  i changed the following lines 

      <add key="GPReaderTimeout" value="480" />
      <add key="SqlBulkCopyTimeout" value="6000" />
      <add key="SqlBulkCopyBatchSize" value="15000" />
      <add key="IntegrationReaderTimeout" value="1000" />

    The report is taking some time to be generated (about 10min) but at least i'm getting the data i need.

    Best Regards,

    Joseph

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Management Reporter SQL Timeout Error

    Hi Joseph,

    I kept increasing the value until "120" worked for me. In MR 2012, the MRServiceHost.settings file seems to be the one that has the timeout value...

    <?xml version="1.0" encoding="utf-8" ?>

    <appSettings>

    <add key="DefaultBaseAddress" value="http://localhost:8080" />

    <!-- Valid values for "MaximumConcurrentReportTasks" are 1 to 2147483647. The default value is 5.-->

    <add key="MaximumConcurrentReportingTasks" value="5" />

    <add key="AXReaderTimeout" value="90" />

    <add key="GPReaderTimeout" value="90" />

    <add key="SqlBulkCopyTimeout" value="3000" />

    <add key="SqlBulkCopyBatchSize" value="10000" />

    <add key="IntegrationReaderTimeout" value="600" />

    </appSettings>

     

    Try changing this to a higher number, restart the service and see if that helps.

     

    Sandeep.

  • Joseph Noufaily Profile Picture
    Joseph Noufaily 130 on at
    Re: Management Reporter SQL Timeout Error

    Hi Sandeep,

    I'm facing the same issue while trying to generate complex reports.

    I'm on GP 2010 SP3 using management reporter 2012.

    I tried to use the above resolution but it didn't work, is there anu specific value for the timout or should I change any other values?

    Thanh you

    Joseph

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Management Reporter SQL Timeout Error

    I would like to add that we use GP2010. Not sure if the above will change for your version of Dynamics.

    Sandeep.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Management Reporter SQL Timeout Error

    Hi Karen,

    I had opened a support case with MS and here is the resolution. This worked for me.

    "Resolution: Made changes to:
    C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Services\MRServiceHost.exe.config

    ***Please note: I would like you to create a copy of the MRServiceHost.exe.config file and place it on the desktop of the server just in case we need to restore the file after making changes to it.

    Open the file in Notepad and find the <configuration> tag, and then insert the following section of code immediately under the <configuration> tag.

    <configSections>
    <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
    <section name="Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
    </sectionGroup>
    </configSections>
    <applicationSettings>
    <Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Properties.Settings>
    <setting name="ReaderTimeout" serializeAs="String">
    <value>120</value>
    </setting>
    </Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Properties.Settings>
    </applicationSettings> "

     The highlighted setting is what you can change. Increase the "120" to a higher value (i had to do that) and see what works best for you.

     Thanks,

    Sandeep.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Management Reporter SQL Timeout Error

    Did you find a solution? Dynamics 2009 with MR version 2.0.1700.31. Complex reports don't complete. These same reports worked last month but now trying to print fiscal year end reports for June and many of them are failing with the Timeout message shown above.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans