Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Duplicate appointment in outlook - crm 2013 UR3 On Premise RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi there,

    We have duplicate appointments in Outlook randomly happening to some users. The duplicate appointment has the same GUID stored in crmId field, see screenshot attached. 

    Has anyone experienced the same issue?

    Wednesday, October 8, 2014 4:20 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    We found the cause of the issue that the users use multiple computers, and no roaming profile/folder redirection was set up on AppData\Roaming folder. In other words, a separate local SQLCE database is created in each computer (with outlook client installed) that the user has logged on to. As the user moves from one computer to another, user must set the current computer as the synchronising client. When the Outlook client performs synch in one computer, all other copies of SQLCE database residing in other machines become out dated.

    Is it surprising that the company (with over 5000 staffs) does not have roaming profile/folder redirection configuration? I am not qualified to comment on that.

    Microsoft's suggestion for resolution is either allow user use only one PC or set up folder redirection so user accesses only one SQLCE database regardless of which computer is logged on to.

    However, the internal IT suggests the Outlook client has a flaw that it should be able to resume the synch and consolidates any differences regardless of which computer is logged on to because CRM tracking information is actually stored in each appointment object in Exchange Server.

    Henri

    • Marked as answer by Henri_L Sunday, November 16, 2014 10:32 PM
    Friday, November 14, 2014 6:27 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Henri,

     No idea what crmid field refers to, is this a custom filed. Please try to run the following query in CRM database and let us know if there are duplicates. ActivityId is the primary key field. Primary key being unique will not allow duplicates.

    select * from FilteredAppointment where subject like '%Booked for L H O by C M%'

    Regards,

    Jithesh.K

    Wednesday, October 8, 2014 5:33 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks for reply Jithesh. The screenshot you are looking at is certainly not CRM UI but Outlook Calendar. crmid is a custom field which you can add to CRM Calendar List View.

    There is no duplicate in CRM database.

    Wednesday, October 29, 2014 4:54 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Are the users with this issue syncing contacts to a smart phone?  If they stop syncing, does this stop happening for the users?

    Also, are they using shared calendars? 

    Or are your users also Contacts in CRM and have the same e-mail address in both record types?

    Jason Peterson

    Wednesday, October 29, 2014 9:00 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    We found the cause of the issue that the users use multiple computers, and no roaming profile/folder redirection was set up on AppData\Roaming folder. In other words, a separate local SQLCE database is created in each computer (with outlook client installed) that the user has logged on to. As the user moves from one computer to another, user must set the current computer as the synchronising client. When the Outlook client performs synch in one computer, all other copies of SQLCE database residing in other machines become out dated.

    Is it surprising that the company (with over 5000 staffs) does not have roaming profile/folder redirection configuration? I am not qualified to comment on that.

    Microsoft's suggestion for resolution is either allow user use only one PC or set up folder redirection so user accesses only one SQLCE database regardless of which computer is logged on to.

    However, the internal IT suggests the Outlook client has a flaw that it should be able to resume the synch and consolidates any differences regardless of which computer is logged on to because CRM tracking information is actually stored in each appointment object in Exchange Server.

    Henri

    • Marked as answer by Henri_L Sunday, November 16, 2014 10:32 PM
    Friday, November 14, 2014 6:27 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    thank you Henri for updating the post. Please mark your reply so that it comes on top of the search.

    regards

    Jithesh

    Friday, November 14, 2014 7:22 AM