DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 1

changes.mady.by.user admin

Saved on

compared with

New Version 2

changes.mady.by.user admin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Wiki Markup
h3. Installation & Troubleshooting


h4. Setting up SQL Server Database Permissions

When the Connector runs in two server mode, the eConnect COM\+ application uses SQL Server integrated security to connect to the eConnect business objects. During the installation of eConnect, you need to supply a domain user account for the COM\+ application. This domain user account need be put in the DYNGRP in SQL Server. To set up the user account, complete the following procedure:
# Launch "SQL Server Enterprise Manager" and go to the *DYNAMICS* database.
# Right click *User* under the database *DYNAMICS* and choose *New Database User.*
# Add the domain user account to the *DYNGRP* database role.

h3. FAQ

*1. What are the pre-requisite software requirement for DBSync integration with Microsoft Dynamics GP?*

The eConnect libraries must be installed ([eConnect Documentation|http://msdn2.microsoft.com/en-us/dynamics/gp/bb457189.aspx]) however the full eConnect Runtime module *does not* need to be installed.

*2. Does Dbsync need to be installed on the same machine as that of Microsoft Dynamcs GP?*

DBSync Microsoft Dynamics GP (GreatPlains) adapter can be either configured on the same instance GP is installed or on a remote machine which can access GreatPlains database.\\

*3. What are the limitations of DBSync integration with Microsoft Dynamics GP?*

The eConnect interfaces do not support every object and interaction available within Microsoft Dynamics GP (Great Plains). If your integration scenario requires working with objects from other modules or more sophisticated queries, you will need to use our Database Adapter for Microsoft SQL Server to connect to backend database tables directly. While this is an option, it is recommended to avoid accessing Microsoft Dynamics GP (GreatPlains) database directly to maintain data integrity and business rule executions.[Skip navigation|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#page-content]| | [|http://help.boomi.com/display/BOD]
| [|http://help.boomi.com/display/BASDASH/Boomi+AtomSphere+Dashboard]  [Dashboard|http://help.boomi.com/dashboard.action] > [Boomi AtomSphere|http://help.boomi.com/display/BOD] > [...|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#][Boomi AtomSphere Help|http://help.boomi.com/display/BOD/Boomi+AtomSphere+Help] > [3 - Build|http://help.boomi.com/display/BOD/3+-+Build] > [3.2 - Building Connectors|http://help.boomi.com/display/BOD/3.2+-+Building+Connectors] > [Available Connectors|http://help.boomi.com/display/BOD/Available+Connectors] > [Great Plains Connector|http://help.boomi.com/display/BOD/Great+Plains+Connector] > [Great Plains Connector Install and Troubleshooting Guide|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide] | | View |
* View
** This page
*** [Normal view|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide?decorator=normal]
*** [Printable view|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide?decorator=printable]
** Other pages
*** [Home page|http://help.boomi.com/display/BOD]
*** [Dashboard|http://help.boomi.com/dashboard.action]
***  
*** [News|http://help.boomi.com/pages/viewrecentblogposts.action?key=BOD]
*** [Recent updates|http://help.boomi.com/pages/recentlyupdated.action?key=BOD]
*** [RSS feed builder|http://help.boomi.com/dashboard/configurerssfeed.action]
***  
*** [Index|http://help.boomi.com/pages/listpages-alphaview.action?key=BOD]
*** [Site map|http://help.boomi.com/pages/listpages-dirview.action?key=BOD&openId=6520852]
*** [Labels|http://help.boomi.com/labels/listlabels-heatmap.action?key=BOD]
***  
*** [Attachments index (13)|http://help.boomi.com/spaces/listattachmentsforspace.action?key=BOD]
*** [People directory|http://help.boomi.com/browsepeople.action]
*** [Space activity|http://help.boomi.com/spaces/usage/report.action?key=BOD]
**  
** Account
*** [Log in|http://help.boomi.com/login.action?os_destination=%2Fdisplay%2FBOD%2FGreat%2BPlains%2BConnector%2BInstall%2Band%2BTroubleshooting%2BGuide]
***  
*** [History|javascript:var%20wnd=window.open('/users/viewuserhistory.action','user_history',%20'width=620,%20height=200,%20resizable');] | | |
| <!-- .li{   padding-left:15; } -->*  [1 - Introduction|http://help.boomi.com/display/BOD/1+-+Introduction]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][2 - Getting Started|http://help.boomi.com/display/BOD/2+-+Getting+Started]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][3 - Build|http://help.boomi.com/display/BOD/3+-+Build]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][3.1 - Building Processes|http://help.boomi.com/display/BOD/3.1+-+Building+Processes]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][3.2 - Building Connectors|http://help.boomi.com/display/BOD/3.2+-+Building+Connectors]
*  [Atom Specific Connection Settings|http://help.boomi.com/display/BOD/Atom+Specific+Connection+Settings]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][Available Connectors|http://help.boomi.com/display/BOD/Available+Connectors]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][AS2 Client Connector|http://help.boomi.com/display/BOD/AS2+Client+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][AS2 Server Connector - Legacy|http://help.boomi.com/display/BOD/AS2+Server+Connector+-+Legacy]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][Autotask Connector|http://help.boomi.com/display/BOD/Autotask+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][Coupa Connector|http://help.boomi.com/display/BOD/Coupa+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][Database Connector|http://help.boomi.com/display/BOD/Database+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][Disk Connector|http://help.boomi.com/display/BOD/Disk+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][FTP Connector|http://help.boomi.com/display/BOD/FTP+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][Great Plains Connector|http://help.boomi.com/display/BOD/Great+Plains+Connector]
*  [Creating a Great Plains Connection|http://help.boomi.com/display/BOD/Creating+a+Great+Plains+Connection]
*  [Creating a Great Plains Operation|http://help.boomi.com/display/BOD/Creating+a+Great+Plains+Operation]
*  [Great Plains Connector Install and Troubleshooting Guide|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][HTTP Client Connector|http://help.boomi.com/display/BOD/HTTP+Client+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][HTTP Server Connector - Legacy|http://help.boomi.com/display/BOD/HTTP+Server+Connector+-+Legacy]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][Innotas Connector|http://help.boomi.com/display/BOD/Innotas+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][Intacct Connector|http://help.boomi.com/display/BOD/Intacct+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][Mail Connector|http://help.boomi.com/display/BOD/Mail+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][NetSuite Connector|http://help.boomi.com/display/BOD/NetSuite+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][OpSource Services Bus Connector|http://help.boomi.com/display/BOD/OpSource+Services+Bus+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][Parature Connector|http://help.boomi.com/display/BOD/Parature+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][Peachtree Connector|http://help.boomi.com/display/BOD/Peachtree+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][QuickBooks Connector|http://help.boomi.com/display/BOD/QuickBooks+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][RightNow Connector|http://help.boomi.com/display/BOD/RightNow+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][Salesforce Connector|http://help.boomi.com/display/BOD/Salesforce+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][SAP Connector|http://help.boomi.com/display/BOD/SAP+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][SFTP Connector|http://help.boomi.com/display/BOD/SFTP+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][SmartTurn Connector|http://help.boomi.com/display/BOD/SmartTurn+Connector]
*  [Web Services Server Connector|http://help.boomi.com/display/BOD/Web+Services+Server+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][Web Services SOAP Client Connector|http://help.boomi.com/display/BOD/Web+Services+SOAP+Client+Connector]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][Connector Best Practices|http://help.boomi.com/display/BOD/Connector+Best+Practices]
*  [Understanding Connector Operations|http://help.boomi.com/display/BOD/Understanding+Connector+Operations]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][3.3 - Building Data Profiles|http://help.boomi.com/display/BOD/3.3+-+Building+Data+Profiles]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][3.4 - Building Data Maps|http://help.boomi.com/display/BOD/3.4+-+Building+Data+Maps]
*  [3.5 - Scheduling Processes|http://help.boomi.com/display/BOD/3.5+-+Scheduling+Processes]
*  [3.6 - Data Type Formatting|http://help.boomi.com/display/BOD/3.6+-+Data+Type+Formatting]
*  [3.7 - Understanding Parameter Values|http://help.boomi.com/display/BOD/3.7+-+Understanding+Parameter+Values]
*  [3.8 - Cross Reference Tables|http://help.boomi.com/display/BOD/3.8+-+Cross+Reference+Tables]
*  [3.9 - Testing a Process|http://help.boomi.com/display/BOD/3.9+-+Testing+a+Process]
*  [3.10 - Process Properties|http://help.boomi.com/display/BOD/3.10+-+Process+Properties]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][3.11 - Process Extensions|http://help.boomi.com/display/BOD/3.11+-+Process+Extensions]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][4 - Deploy|http://help.boomi.com/display/BOD/4+-+Deploy]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][5 - Manage|http://help.boomi.com/display/BOD/5+-+Manage]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][6 - Process Library|http://help.boomi.com/display/BOD/6+-+Process+Library]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][7 - Connector SDK|http://help.boomi.com/display/BOD/7+-+Connector+SDK]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][8 - The Boomi Atom|http://help.boomi.com/display/BOD/8+-+The+Boomi+Atom]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][9 - EDI and B2B Solutions|http://help.boomi.com/display/BOD/9+-+EDI+and+B2B+Solutions]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][10 - Widgets|http://help.boomi.com/display/BOD/10+-+Widgets]
*  [|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide][11 - Web Service Publishing|http://help.boomi.com/display/BOD/11+-+Web+Service+Publishing]
*  [Boomi Best Practices|http://help.boomi.com/display/BOD/Boomi+Best+Practices] | | h1. Great Plains Connector Install and Troubleshooting Guide |
| | | In this article:
[|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-Installation]* [Installation|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-Installation]
[|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-Prerequisitessetup]** [Prerequisites setup|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-Prerequisitessetup]
[|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-SetupCOMaccountDBpermission]*** [Setup COM+ account DB permission|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-SetupCOMaccountDBpermission][|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-MakesureDTCisrunning]*** [Make sure DTC is running|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-MakesureDTCisrunning][|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-SetupFunctionalCurrencyinMSDynamicsGP]*** [Setup Functional Currency in MS-Dynamics GP|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-SetupFunctionalCurrencyinMSDynamicsGP][|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-CommonConnectionIssuesandTroubleshooting]* [Common Connection Issues and Troubleshooting|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-CommonConnectionIssuesandTroubleshooting]
[|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-Error%3AThepartnertransactionmanagerhasdisableditssupportforremote%2Fnetworktransactions]*** [Error: The partner transaction manager has disabled its support for remote/network transactions|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-Error%3AThepartnertransactionmanagerhasdisableditssupportforremote%2Fnetworktransactions][|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-Error%3AThetransactionhasalreadybeenimplicitlyorexplicitlycommittedoraborted.]*** [Error: The transaction has already been implicitly or explicitly committed or aborted.|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-Error%3AThetransactionhasalreadybeenimplicitlyorexplicitlycommittedoraborted.][|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-Troubleshooting]** [Troubleshooting|http://help.boomi.com/display/BOD/Great+Plains+Connector+Install+and+Troubleshooting+Guide#GreatPlainsConnectorInstallandTroubleshootingGuide-Troubleshooting]
h1. Installation
h2. Prerequisites setup
h3. Setup COM\+ account DB permission
When the Connector runs in two server mode, the eConnect COM\+ application uses SQL Server integrated security to connect to the eConnect business objects. During the installation of eConnect, you need to supply a domain user account for the COM\+ application. This domain user account need be put in the DYNGRP in SQL Server. To set up the user account, complete the following procedure:
# Launch "SQL Server Enterprise Manager" and go to the *DYNAMICS* database.
# Right click *User* under the database *DYNAMICS* and choose *New Database User...*.
# Add the domain user account to the *DYNGRP* database role.
h3. Make sure DTC is running
# Launch the Services console by going to *Start >> Run* and type *services.msc*. Verify the *Distributed Transaction Coordinator* service is running.
h3. Setup Functional Currency in MS-Dynamics GP
eConnect requires a functional currency to be set up for Microsoft Dynamics GP, even if multicurrency is not being used. To set up a functional currency, do the following:
# Open the Multicurrency Setup window in Microsoft Dynamics GP.\\
 From the menu bar, choose *Tools >> Setup >> Financial >> Multicurrency*. This example designates US dollars as the functional currency.
# Complete check links when needed.\\
 If a message prompts you to run check links for the multicurrency table, you should do so. To run checklinks, go to *File >> Maintenance >> Check Links*. Select the series and tables to check. Click *OK*.
h1. Common Connection Issues and Troubleshooting
h3. Error: The partner transaction manager has disabled its support for remote/network transactions
When making a request to eConnect, you may get exception as below:cli.System.Transactions.TransactionException: The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)
        at cli.System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(Unknown Source)
        at cli.System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(Unknown Source)
        at cli.Microsoft.Dynamics.GP.eConnect.eConnectMethods.eConnect_Requester(Unknown Source)
        at server.eConnect.request(eConnect.java:38)
        at java.lang.reflect.Method.invoke(Method.java:434)
        at gnu.java.rmi.server.UnicastServerRef.incomingMessageCall(UnicastServerRef.java:394)
        at gnu.java.rmi.server.UnicastServer.incomingMessageCall(UnicastServer.java:279)
        at gnu.java.rmi.server.UnicastServer.dispatch(UnicastServer.java:235)
        at gnu.java.rmi.server.UnicastConnection.run(UnicastConnection.java:219)
        at java.lang.Thread.run(Thread.java:744)
        at java.lang.VMThread.run(VMThread.java:76)
        at java.lang.VMThread$1.Invoke(VMThread.java:334)
        at cli.System.Threading.ThreadHelper.ThreadStart_Context(Unknown Source)
        at cli.System.Threading.ExecutionContext.Run(Unknown Source)
        at cli.System.Threading.ThreadHelper.ThreadStart(Unknown Source)
Caused by: cli.System.Runtime.InteropServices.COMException: The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)
        ... 12 more
*Solution:*\\
 First verify the "Distribute Transaction Coordinator" Service is running on both database server computer and client computers.
# Go to *Start >> Administrative Tools >> Services*.
# Turn on the "Distribute Transaction Coordinator" Service if it is not runningIf it is running and Atom is not on the same computer as the database server, on the computer running database server
# Go to *Start >> Administrative Tools > Component Services*.
# On the left navigation tree, go to *Component Services >> Computers >> My Computer* (you may need to double click and wait as some nodes need time to expand).
# Right click *My Computer* select *Properties*.
# Go to the *MSDTC* tab
# Click *Security Configuration*
# Make sure you check "Network DTC Access", "Allow Remote Client", "Allow Inbound/Outbound", "Enable TIP" (Some option may not be necessary, have a try to get your configuration)
# The service will restart.
# Try to connect from Boomi AtomSphere.
# YOU MAY NEED TO ALSO REBOOT YOUR SERVER IF IT STILL DOES NOT WORKOn your client computer use the same above procedure to open the "Security Configuration" setting, make sure you check "Network DTC Access", "Allow Inbound/Outbound" option, restart service and computer if necessary.\\
On you SQL server service manager, click "Service" dropdown, select "Distribute Transaction Coordinator", it should be also running on your server computer.
h3. Error: The transaction has already been implicitly or explicitly committed or aborted.
When change IP in the local client machine you may get exception as below:Starting call eConnect....cli.System.Transactions.TransactionException: The transaction has already been implicitly or explicitly committed or aborted.
        at cli.System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(Unknown Source)
        at cli.System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(Unknown Source)
        at cli.Microsoft.Dynamics.GP.eConnect.eConnectMethods.eConnect_Requester(Unknown Source)
        at server.eConnect.request(eConnect.java:78)
        at java.lang.reflect.Method.invoke(Method.java:434)
        at gnu.java.rmi.server.UnicastServerRef.incomingMessageCall(UnicastServerRef.java:394)
        at gnu.java.rmi.server.UnicastServer.incomingMessageCall(UnicastServer.java:279)
        at gnu.java.rmi.server.UnicastServer.dispatch(UnicastServer.java:235)
        at gnu.java.rmi.server.UnicastConnection.run(UnicastConnection.java:219)
        at java.lang.Thread.run(Thread.java:744)
        at java.lang.VMThread.run(VMThread.java:76)
        at java.lang.VMThread$1.Invoke(VMThread.java:334)
        at cli.System.Threading.ThreadHelper.ThreadStart_Context(Unknown Source)
        at cli.System.Threading.ExecutionContext.Run(Unknown Source)
        at cli.System.Threading.ThreadHelper.ThreadStart(Unknown Source)
Caused by: cli.System.Runtime.InteropServices.COMException: The transaction has already been implicitly or explicitly committed or aborted (Exception from HRESULT: 0x8004D00E)
        ... 12 more
*Solution:*\\
 This is because the MSDTC cannot correctly use the DNS server to resolve a new IP address for the local host name after the IP address changing. Restore your old IP or check the DNS settings to make sure the GP DB server can correctly resolve the client host name via DNS server.
h2. Troubleshooting
Because the Great Plains application consists of many different modules including eConnect, .NET, Microsoft SQL server, DCOM, MSDTC, etc. initial configuration and troubleshooting can be more involved than with other applications and connectors. \\
Most Great Plains connection issues are related to permissions: user permissions and database permissions.\\
High-level diagnostic steps:
# Verify Boomi Connection configuration
# Verify database port
# Check the user has the right password and permission
# Check the database has the right permissionsUser Permission: eConnect need configure a user (domain user) to have right permission to connect to Great Plains. Below are the details steps to check and make sure the user permission is correct.
# Login to the Windows machine installed Boomi Atom.
# Go to *Start >> Run* and type *services.msc* and click *OK* to launch the Services console.
# Verify the "Distributed Transaction Coordinator" service is started.
# Go to *Start >> Run* and type *dcomcnfg* and click *OK* to launch the Component Services console.
# Go to *Console Root >> Component Services >> Computers >> My Computer*.
# Right click *My Computer* and choose *Properties...*
# Go to the *Default Properties* tab and verify *Enable Distributed COM on this computer* is checked.
# Go to the *MSDTC* tab and click *Security Configuration*. Verify "Network DTC Access", "Allow Remote Clients", "Allow Inbound", "Allow Outbound" and "Enable Transaction Internet Protocol (TIP) Transaction" are checked.
# Under *My Computer* folder, right click *COM\+ Applications* and choose *Properties...*
# Click *Identify{*}and verify the user and password are correct and have not been expired or locked from Windows user management tools. The user configured here should be the same user configured in the Boomi Great Plains Connection. To make sure the password and the user account is right, you can retype the password and click *Apply*. If it is incorrect, it will display an error.
# After resetting the Identity, you may need "Shut Down" and "Start" the eConnect COM\+ application by clicking the mouse right button as below:Database permission: eConnect need connect to the MS SQL server with the user configured in the above "Identity" tab. The correct permissions are also needed on the database side.
# Log into the MS SQL server (this guide illustrates SQL Server 2005).
# Start the "SQL Server Configuration Manager" and go to *SQL Server 2005 Network Configuration* >> Protocols for <server name> >> TCP/IP*. Right click TCP/IP and choose *Properties*.
# On the *Protocol* tab, verify *Enabled* is set to "Yes". On the *IP Addresses* tab, in the *IPAll* section, verify the port is specified in either the *TCP Dynamic Ports* or *TCP port*.
# Start "Microsoft SQL Server Management Studio Express", right click your database instance, and choose *Properties*.
# Go to *Security* and verify "SQL Server and Windows Authentication mode" is checked.
# Setup the necessary database permissions for the user. Please refer to the above section "Setup COM\+ account DB permission" for details. | | |
| |
| [Do you have suggestions to improve our documentation?  We'd love to hear about them in our Feedback Forums|http://feedback.boomi.com/] | |
| [Adaptavist Theme Builder|http://www.adaptavist.com/] {color:#909090}Powered by{color} [Atlassian Confluence|http://www.atlassian.com/software/confluence/default.jsp?clicked=footer] |

| | This page | |
| | Other pages | |
| |
| | Account | |
| | Normal view | |
| | Printable view | |
| | Home page | |
| | Dashboard | |
| |
| | News | |
| | Recent updates | |
| | RSS feed builder | |
| |
| | Index | |
| | Site map | |
| | Labels | |
| |
| | Attachments index (13) | |
| | People directory | |
| | Space activity | |
| | Log in | |
| |
| | History | |