A recent case has highlighted some subtle differences in behaviour with eConnect for Microsoft Dynamics GP 2010 and the way it handles SQL transaction commit and rollback.
Prior to Microsoft Dynamics GP 2010, if a XML Document file contained any transactions which generated errors from eConnect, the entire Document and all the transactions that have already been processed in it would be rolled back.
With eConnect for Microsoft Dynamics GP, this behaviour has changed under certain circumstances. eConnect now works in one of two ways:
So what does this mean in a practical sense?
If you are using a "Mode 1" XML document then there is no difference in behaviour.
However, if you are using a "Mode 2" XML document including the <eConnectProcessInfo> node for each transaction and an error occurs, I can't just attempt to re-import the document as all the transaction prior to the one with the error are already imported and will generate duplicate errors.
Note: If you want to restore the previous behaviour to Mode 2, where the entire XML Document will be rolled back if there is an error on any transaction within the document, you can add the ReuseBaseTransaction configuration setting to your application's config file or the Microsoft.Dynamics.GP.eConnect.Service.exe application's config file (Microsoft.Dynamics.GP.eConnect.Service.exe.config). If you change the settings on the service executable, you will will need to restart the service for the change to take effect. The default location for the service files is C:\Program Files\Microsoft Dynamics\eConnect 11.0\Service.
See the example .config below:
<?xml version="1.0"?> <configuration> <appSettings> <add key="ReuseBaseTransaction" value="true"/> </appSettings> </configuration>
For more information on the changes to eConnect for Microsoft Dynamics GP 2010, please review Chris' post:
Hope this information is useful.
I was wondering if there was a typo in the BLOG at the text "Note: If you want to restore the previous behaviour to Mode 2, ". Did you possibly mean Mode 1 instead?
Thanks for the feedback.
The note is correct. You can restore the previous rollback behavior even when including connection data in the XML document (mode 2).
Posting from Mark Polino at DynamicAccounting.net
PLEASE READ BEFORE POSTING
Please only post comments relating to the topic of this page.
If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.