SUMMARY Data being integrated with eConnect is leaving records in Microsoft Dynamics GP tables when there is an error being returned. eConnect should be rolling back the data out of Microsoft Dynamics GP tables.
INTRODUCTION eConnect uses Microsoft Distributed Transaction Coordinator (DTC) to send the data being imported from the workstation to the SQL Server. When using Distribution Transaction Coordinator if there is an error received during the integration process then DTC will rollback the data from the Microsoft Dynamics GP tables. Now if the eConnect 10 for Microsoft Dynamics GP is set to a value other than Required under the Transaction Support tab then it will not roll back the data.
MORE INFORMATIONTo check the Transaction Support setting perform the following steps:
If the Transaction Support is not set to Required perform the following steps:
David CDeveloper Support
Thanks for the post David. That's a pretty obscure setting!
When troubleshooting a DTC error recently, I found a recommendation to use the "Enlist=False" parameter for the eConnect conn string to get rid of the error.
But I subsequently read that setting Enlist = False may disable some MS DTC transaction handling mechanisms.
Can you or the GP developers help shed some light on the impact / usage of the Enlist conn string parameter?
Here are my two posts on the topic:
When eConnects return an error?
It always show the long error list. We need to do a lot of try an error to figure what causing the error.
The error message also bit technical for user.
Is there any proper way display more proper error message to the user?
when we import data uging eConnect to GP,they will be in a 'SAVE'status.
Is it possible to import data directly into GP in 'POST' status??
Because,normally user can change the data imported by eConnect and then post it,-what i need is to block the user access to the imported data.
let me know if u have any idea.
After transactions are imported via eConnect, there is no option in eConnect to import them as posted, or post them automatically using eConnect.
However, you can use a third party product to automatically post the batches after they are imported. Check out Post Master for Dynamics GP:
Full disclosure: I now resell Post Master in North America.
Here is a blog post that I wrote about it before I started to resell it:
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
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.