Options

NAV/CRM Connector, CRM->NAV Contacts synchronization issues

toLLtotoLLto Member Posts: 34
edited 2012-02-16 in NAV Three Tier
I'm newbie in CRM 2011. I'm trying to setup synchronization between NAV 2009 R2 and CRM 2011.

NAV->CRM works fine. Now I'm trying to sync Contacts from CRM to NAV and I've huge problems.

1. Existing NAV-Contacts are transferred correctly in both directions. According to the Dynamics Connector manual, every new CRM Contact should be first submitted to be integrated to NAV. I found this Submit button on "ISV" Tab (called "Custom").

Image18.jpg

Is there any way to move this button to the Contact Maintab? and change his name to "Submit"?

When I hit this button my new CRM-Contact becomes "Ready to Integration" and a new "Integration Key"

Image19.jpg

Integration Key is created automaticaly (some characters from Lastname + some numbers), can I change this? In NAV we are using for Contacts another No. Series: 'K100000'-'K199999'. Or will this be replaced after succesfull synchronisation?

My big problem is, that my new CRM-Contacts are not transferred to NAV. I see following Error in CRM Connector (sorry but I see only German-Localized exceptions):
[Contact to NAV Contact Card] has encountered an error while processing key [620ec2b5-6156-e111-ba06-00155d014105]. Der Clientrückruf (z. B. Seitenanzeige) wird nicht unterstützt, wenn benutzerdefinierte Web Services ausgeführt werden. Soll ein neuer Datensatz angelegt werden?


2. In Connector's log I see strange entries, something like infinite loop, some Contacts are transferred in both directions, even if no contacts were changed in NAV or CRM. First 42 Contacts are transferred from CRM to NAV and some seconds later 42 Contacts are transferred from NAV to CRM. This happens again and again.

Image13-1.jpg

Image14-2.jpg


Image12-1.jpg

How to solve this issues?


3. Sometimes I get following Exceptions for my CRM Contact to NAV Contact map:
[Contact to NAV Contact Card] has encountered an error. Processing will be aborted. Das Kommunikationsobjekt "System.ServiceModel.Channels.HttpChannelFactory+HttpRequestChannel" kann nicht für die Kommunikation verwendet werden, da es abgebrochen wurde.
[Contact to NAV Contact Card] has encountered an error. Processing will be aborted. Die HTTP-Anforderung an "http://xxx/COMPANY/XRMServices/2011/Organization.svc" wurde abgebrochen. Möglicherweise wurde der lokale Kanal geschlossen, während die Anforderung noch durchgeführt wurde. Wenn dieses Verhalten nicht erwünscht ist, aktualisieren Sie den Code dahingehend, dass der Kanal nicht geschlossen wird, solange noch Anforderungsvorgänge durchgeführt werden.

My settings are ok. "Test settings" in Connector, and CRM-Configuration works great.

Image4.jpg
Image3.jpg

Answers

  • Options
    StarkStark Member Posts: 39
    Hi Couple of questions,
    1. How you import Connector Solution? Is there same issue with "submit" button on Account and Order forms(are they on main form ribbon or not too)?
    2. What CRM 2011 Configuration you using? On-promise with IFD?
    http://nav-connector.com/ - blog about Dynamics Connector
  • Options
    toLLtotoLLto Member Posts: 34
    @Stark:

    1. I'm using "Configure MS Dynamics CRM" option in Dynamics Connector. I didn't import anything manually.

    In Accounts I see same issue, "Custom" button on ISV Tab
    Image23.jpg

    In Order I can see "Submit Order" Button on Order-Tab
    Image22.jpg

    2. We're working with CRM in local intranet, without IFD.

    Image21-1.jpg

    It was upgraded from CRM 4.0
  • Options
    StarkStark Member Posts: 39
    I see,
    Here is some missing/wrong steps:
    - After Connector installation you have to manually import Connector Solution into your CRM and this should be before first settings update.(Solution located in ..Program Files\Connector folder - "ConnectorForMicrosoftDynamicsNav.zip")
    - Connector CRM Settings:
    FP7 has two different configurations:
    CRM - for on-promise and online
    CRM 2011 - for IFD
    you need to use first configuration (CRM) not the second one.
    Small Tip: your Discovery server - just CRM server name

    Cheers,
    Konstantin
    http://nav-connector.com/ - blog about Dynamics Connector
  • Options
    toLLtotoLLto Member Posts: 34
    thanks,
    as you suggested, I imported Connector Solution in CRM, and I changed "CRM 2011" adapter to "CRM".

    Problem with Submit Button - resolved!
    Problem 3) (strange Exceptions) - resolved!


    But I still can't sync new CRM-Contacts to NAV. I keep getting the same exception:
    [Contact to NAV Contact Card] has encountered an error while processing key [b0be7147-3d56-e111-a6b3-00155d014108]. Der Clientrückruf (z. B. Seitenanzeige) wird nicht unterstützt, wenn benutzerdefinierte Web Services ausgeführt werden. Soll ein neuer Datensatz angelegt werden?

    Error Code: Microsoft.Dynamics.Integration.Adapters.Nav2009::0x80131501
    Map: Contact to NAV Contact Card

    Image31.jpg

    any ideas?
  • Options
    StarkStark Member Posts: 39
    My bad ...
    CRM adapters Setting and CRM 2011 Adapter Settings can be used both for CRM 2011 On-promise.
    And MSFT suggest to use CRM 2011 Adapter Settings for new integrations. So, you choose correct adapter.

    Cheers,
    Konstantin
    http://nav-connector.com/ - blog about Dynamics Connector
  • Options
    StarkStark Member Posts: 39
    Hi toLLto,
    Is your Client NAV Page customized?
    http://nav-connector.com/ - blog about Dynamics Connector
  • Options
    toLLtotoLLto Member Posts: 34
    Stark wrote:
    CRM adapters Setting and CRM 2011 Adapter Settings can be used both for CRM 2011 On-promise.
    And MSFT suggest to use CRM 2011 Adapter Settings for new integrations. So, you choose correct adapter.
    Installing Connector solution solved some my problems. Issue with new CRM-Contacts happens in both adapters ("CRM" and "CRM 2011").
    Stark wrote:
    Is your Client NAV Page customized?

    Hard to say. NAV was installed by another developer. I started a month ago. I don't now if he made any customizations in "5050 Contact Card" Page. I have no other clean NAV Installation, so I can't compare now how looks this page on clean deployment.

    Here is my Contact Card:
    http://toll.pl/temp/page%205050.fob
  • Options
    StarkStark Member Posts: 39
    Reviewing page not will be really helpful,
    My suggestion - create new clean and simple Contact page, include it in Integration and create Map for CRM Contact to NAV Custom Contact. This will allow to see if issue with NAV Page or something else.
    http://nav-connector.com/ - blog about Dynamics Connector
  • Options
    toLLtotoLLto Member Posts: 34
    Stark wrote:
    create new clean and simple Contact page, include it in Integration and create Map for CRM Contact to NAV Custom Contact. This will allow to see if issue with NAV Page or something else.

    I created new Contact Page, as simple as possible:

    Image41.jpg

    Added new Map in Connector:

    Image42.jpg

    But I'm still getting the same Error:
    [Contact to NAV Custom Contact Card] has encountered an error while processing key [b0be7147-3d56-e111-a6b3-00155d014108]. Der Clientrückruf (z. B. Seitenanzeige) wird nicht unterstützt, wenn benutzerdefinierte Web Services ausgeführt werden. Soll ein neuer Datensatz angelegt werden?
  • Options
    toLLtotoLLto Member Posts: 34
    edited 2012-02-29
    Problem resolved. This site was helpful: http://msdn.microsoft.com/en-us/library/gg502485.aspx
    Client callback (such as showing Pages) is not supported when executing custom Web services. <Additional information about the error from the dialog box>

    The first error generally occurs because the web service has accessed application code that contains either a Confirm or StrMenu dialog box or a Page type. These types of dialog boxes require user input, which cannot be handled when using the web service. The web service call then includes a detailed message with information from the dialog box, which you can then use to analyze the reason for the callback.

    My problem was that in the Contact Table in OnInsert Trigger someone have used a DIALOG.CONFIRM prompt. Because of this connector was unable to insert new records in Contact-Table.
    OnInsert()
    IF NOT DIALOG.CONFIRM(LT_Question, TRUE) THEN BEGIN
      ERROR('');
    END;
    

    Thanks for help everyone.

    EDIT: you can use GUIALLOWED http://msdn.microsoft.com/en-us/library/dd339064.aspx to show the CONFIRM only if it runs under Classic Client, not under WebServices:
    IF GUIALLOWED THEN
      IF NOT DIALOG.CONFIRM(LT_Question, TRUE) THEN BEGIN
        ERROR('');
      END;
    
  • Options
    ajhvdbajhvdb Member Posts: 672
Sign In or Register to comment.