web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / eConnect 2010 using an...
Microsoft Dynamics GP (Archived)

eConnect 2010 using an MSMQ Public Queue

(0) ShareShare
ReportReport
Posted on by Jay Johnston 115

I have installed eConnect 2010 on a server that is remote from the GP Dynamics 2010 database server.  The environment is Win2008R2 servers with a Win2003R2 domain Controller.  The Requester Setup on the client uses integrated security for a user that is a domain admin and all connections fun.  The Outgoing config is setup correctly because the Outgoing Service starts witn no errors (the Outgoing Service runs under the domain admin user mentioned above).  The above mentioned domain admin user is a member of DYNGRP on the company DB and Dynamics.  I then do an update transaction in GP2010, the transaction appears momentarily in the table eConnect_Out and then disappears into nowhere.  The Public Queue on the client remains empty. 

The Message Queue Services installation has the Message Queueing Services, Directory Service Integration, and Routing Service installed.   No error messages in the eConnect Application Log.

thanks,

Jay

*This post is locked for comments

I have the same question (0)
  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Jay,

    Do eConnect incoming service is also running or not? If not then there is problem you won't able to update/integrate with GP.

    Thanks

    Sandip

  • Jay Johnston Profile Picture
    Jay Johnston 115 on at

    Hi Sandip,

    This system I am working with is a Win2008R2 test system with a GP2010 Test database the is an upgrade of the production GP v.10 system..  The test GP 2010 DBserver and eConnect client server are VM's inside a Win2008R2 host.

    My production system is a Win2003 system that runs eConnect v10 on a client that is remote from the DBServer.  The production system works fine with GP v.10 update, add, etc transactions loading up in the eConnect public queue as they are supposed to.  The client is ONLY running the Outgoing service.  I tried firing up the Incoming Service also on the Test system with no success.  

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Jay,

    Did Com+ Application setting has done rightly? Is all dependecy services are available on eCOnnect Incoming Service?

    support.microsoft.com/.../862412 this article may help you to resolve issue.

    Let me know you able to resolve issue or not.

    Thanks

    Sandip Jadhav

  • Jay Johnston Profile Picture
    Jay Johnston 115 on at

    Hi Sandip,

    I don't know where I missed explaining this correctly, but the issue is OUTGOING not incoming.  Furthermore, I am on Windows Server 2008 R2 so that the link above does not apply.  However, I did not install the Message Queuing DCOM Proxy feature.  I will try that to see if it makes a difference.

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Hi Jay,

    Are you trying to update Dynamics GP as you mentioned ' I then do an update transaction in GP2010' ? For updating Dynamics GP using eConnect; eConnect incoming service need to be run on 'client' machine.  Without incoming service 'Update/insert' will not work.

    Thanks

    Sandip

  • Community Member Profile Picture
    Community Member on at

    HI Sandip,

    I'm using Message Queue to send the data to GP.i'm getting XML data in Message Queue.but that customer data(when i try to insert the customer) is not syncing in GP.Please suggest me for this problem .

    My code is below :

    eConnectType eConnect = new eConnectType(); // Instantiate an eConnectType schema object
    XmlSerializer serializer = new XmlSerializer(eConnect.GetType());// Create an XML serializer object
    RMCustomerMasterType[] mySmCustomerMaster = { mySMCustomerMaster };
    eConnect.RMCustomerMasterType = mySmCustomerMaster;// Populate the eConnectType object with the RMCustomerMasterType schema object
    MemoryStream memoryStream = new MemoryStream();// Serialize the object to produce an XML document
    serializer.Serialize(memoryStream, eConnect);
    memoryStream.Position = 0;
    XmlDocument createCustomerDocument = new XmlDocument();
    createCustomerDocument.Load(memoryStream);

    //Creating the customer entity
    // customerResult = eConnectMethod.CreateEntity(sConnectionString, createCustomerDocument.OuterXml);

    // HairDirect Customizations //

    MessageQueue queue = new MessageQueue(@".\private$\econnect_incoming");
    if (!MessageQueue.Exists(@".\private$\econnect_incoming"))
    {
    MessageQueue.Create(@".\private$\econnect_incoming");
    }

    Message message = new Message();
    ActiveXMessageFormatter formatter = new ActiveXMessageFormatter();
    MessageQueueTransaction transaction = new MessageQueueTransaction();
    message.Label = "Customer Creation";
    message.Body = createCustomerDocument.OuterXml;
    message.Formatter = formatter;
    queue.Send(message, "Customer XML Data", transaction);
    formatter.Write(message, createCustomerDocument.OuterXml);
    transaction.Begin();
    transaction.Commit();
    queue.Close();

     

    Please tell me if i miss anything in this code.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans