You’re offline. This is a read only version of the page.
75
Hi,
Using Management Reporter 2.0 RU4, we are trying to add a Dynamics GP Data Mart connecting to a GP 2013 environment. We are able to successfully add the ERP Integration however the Initial Integration continues to fail with the error message below.
Any ideas to get around this integration issue?
[GL Transaction to Fact] has encountered an error. Processing will be aborted. Error text: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
*This post is locked for comments
Valen -
You will note that this post was originally from 2013, and the version of Management Reporter was CU4. Current release is CU15, so I pulled the same settings referenced in the Verififed Answer above from the MRServiceHost.settings.config file. They are as follows:
<add key="SqlBulkCopyTimeout" value="3000" />
<add key="SqlBulkCopyBatchSize" value="10000" />
<add key="IntegrationReaderTimeout" value="86400" />
This file is located in the following location if the default folders are accepted during installation:
C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Services\
The IntegrationReaderTimeout value is now set significantly higher than the value DMR used above.
I know this problem has been a while.. i've been curious what is the cause of this problem?
On digging I found a solution to this problem. Of the companies in my test environment the larger contains a decade of transaction history. I suspect this company was causing the timeout issue.
In the MRServiceHost.settings.config file I extended the time values for keys "SqlBulkCopyTimeout" and "IntegrationReaderTimeout" to 7200 (2 hours) and all imported fine. I'm unsure which of these settings actually fixed the problem if not both.
Hi,
For Management Reporter 2012 RU4, I have seen this error which was a result of the ISO codes for the currencies setup with numerical 3 digits. Instead of USD for United States Dollars, it was set to 840.
Replacing 840 with USD for the ISO code within Dynamics GP and the various other incorrect ISO codes enable the integration to run.
Hope it helps you!
Randal Mayer
Summit Group Software
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (