Hi Mohammed,
Thank you for using Dynamics Finance Communities.
The timeout error is usually due to a large query taking too long to complete. With MR 2012 RU2 and above, there is a setting in the following file on the Management Reporter server, we can adjust:
C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Services\MRServiceHost.settings.config.
You will see the following lines in that file. If you don't see the following you can add the missing items:
<?xml version="1.0" encoding="utf-8"?>
<appSettings>
<add key="DefaultBaseAddress" value="">http://csevers5:4712/" />
<!-- 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>
NOTE:
I suggest creating a backup of this file prior to making any changes.
The values above are the default values, listed in seconds.
You can update the "IntegrationReaderTimeout" value to a larger number.
Note that you can either set it larger, such as "7200" (2 hours) or you could set it to "0", which would mean that it would never timeout.
Please restart the Management Reporter services once done.
If the issue does not get resolved even after adjusting the time out settings, please log a support ticket so that we can continue to investigate the issue.
Regards,
Marian Wrice
SR Support Engineer
Dynamics 365 Finance
