An internal Microsoft Dynamics CRM error occurred while synchronizing appointments, contacts, and tasks for the mailbox UserA. The mailbox has been disabled for synchronizing appointments, contacts and tasks and the owner of the associated email se

All replies

• 

  

  0

  Sign in to vote

  Hi Zaheerahmed,

  what is the result when you run this query on your organization DB? Change EMAIL..
  

  
  declare @TableName char(256)
  declare @ColumnName char(256)
  declare @FindString char(256)
  declare @sql char(8000)
  
  /*Replace X with character(s) you which to find and Y with its replacement*/
  set @FindString = 'EMAIL'
  
  /*select o.name, c.name from syscolumns c inner join sysobjects o
   on o.id = c.id
   where o.xtype = 'U'*/
  
  declare T_cursor cursor for
   select o.name, c.name from sysobjects o inner join syscolumns c
    on o.id = c.id
    where o.xtype = 'U' and c.xtype in (175,239,99,231,35,167)
  
  open T_cursor
  fetch next from T_cursor into @TableName, @ColumnName
  while (@@fetch_status <> -1)
   begin
   
   set @sql = 'if exists (select * from ' + rtrim(@TableName) + ' where ' + rtrim(@ColumnName) + ' like ''%' + rtrim(@FindString) + '%'')
    begin
    print ''Table = ' + rtrim(@TableName) + '      Column = ' + rtrim(@ColumnName) + '''
    end'
  
   exec(@sql)
  
   fetch next from T_cursor into @TableName, @ColumnName
  
   end
  
  close T_cursor
  deallocate T_cursor
  

  ---

  gruss Daniel Ovadia MBSS - Microsoft Dynamics CRM MCNPS

  Tuesday, September 22, 2015 2:39 PM
• 

  

  0

  Sign in to vote

  Hi Daniel,

  I have following result set.

  Table = ActivityPartyBase      Column = AddressUsed

  Table = AnnotationBase      Column = NoteText

  Table = ActivityPointerBase      Column = Description

  Table = ActivityPointerBase      Column = Sender

  Table = ActivityPointerBase Column = ToRecipients

  Table = ActivityPointerBase      Column = SubmittedBy

  Table = ImportDataBase      Column = Data

  Table = cdi_emaileventBase      Column = cdi_email

  Table = cdi_emaileventBase      Column = cdi_message

  Table = EmailSearchBase      Column = EmailAddress

  Table = cdi_emailsendBase      Column = cdi_fromemail

  Table = ContactBase      Column = EMailAddress1

  Table = cdi_eventparticipationBase      Column = cdi_emailaddress

  Table = QueueBase      Column = EMailAddress

  Table = MailboxBase      Column = EmailAddress

  Table = SystemUserBase      Column = InternalEMailAddress

  Table = AuditBase      Column = ChangeData

  Table = cdi_sentemailBase      Column = cdi_fromemail

  Table = cdi_sentemailBase      Column = cdi_toemail

  Thanks

  Tuesday, September 22, 2015 5:30 PM
• 

  

  0

  Sign in to vote

  sorry, compare the output of user which works

  ---

  gruss Daniel Ovadia MBSS - Microsoft Dynamics CRM MCNPS

  Tuesday, September 22, 2015 5:44 PM
• 

  

  0

  Sign in to vote

  Hi Daniel,

  I got following result set for working user2.

  Table = AuditBase      Column = ChangeData
  Table = MailboxBase      Column = EmailAddress
  Table = SystemUserBase      Column = InternalEMailAddress
  Table = ActivityPointerBase      Column = Description
  Table = ActivityPointerBase      Column = ToRecipients
  Table = ActivityPartyBase      Column = AddressUsed
  Table = EmailSearchBase      Column = EmailAddress

  Please can you explain how this comparison will help? I have compared two results set and found 12 different tables which are used by User1.

  Table = AnnotationBase      Column = NoteText
  Table = ActivityPointerBase      Column = Sender
  Table = ActivityPointerBase      Column = SubmittedBy
  Table = ImportDataBase      Column = Data
  Table = ContactBase      Column = EMailAddress1
  Table = QueueBase      Column = EMailAddress

  Table = cdi_emaileventBase      Column = cdi_email
  Table = cdi_emaileventBase      Column = cdi_message
  Table = cdi_emailsendBase      Column = cdi_fromemail
  Table = cdi_eventparticipationBase      Column = cdi_emailaddress
  Table = cdi_sentemailBase      Column = cdi_fromemail
  Table = cdi_sentemailBase      Column = cdi_toemail

  Many Thanks

  Wednesday, September 23, 2015 9:13 AM
• 

  

  0

  Sign in to vote

  Hi Zaheerahmed,I think its imported organiaztion and you must chnage/delete them, but it is acutlaly not supported and could cause many things. I would try it anyway with a copy backup.

  ---

  gruss Daniel Ovadia MBSS - Microsoft Dynamics CRM MCNPS

  Wednesday, September 23, 2015 9:17 AM
• 

  

  0

  Sign in to vote

  Hi Daniel,

  It is not imported orgniazation. Please can you confirm what I need to change/delete?

  Thanks

  Wednesday, September 23, 2015 10:44 AM
• 

  

  0

  Sign in to vote

  I would delte the cdi_x vlaues... but i thought its imported.. i don´t know if this helpds also

  ---

  gruss Daniel Ovadia MBSS - Microsoft Dynamics CRM MCNPS

  Wednesday, September 23, 2015 1:09 PM
• 

  

  0

  Sign in to vote

  Hi Daniel,

  We are using third party solution and all cdi_x tables belongs to that solution and deleting them will break that solution functionality. 

  Thanks

  Wednesday, September 23, 2015 1:42 PM
• 

  

  0

  Sign in to vote

  Hi Daniel,

  I have resolved this issue after resetting ExchangeSyncStateXml column to NULL in MailboxBase table for corresponding user.

  I have perform following steps:

  1-Run Below update

  SELECT ExchangeSyncStateXml,MailboxId,* FROM MailboxBase
  WHERE 
  EmailAddress='yourmail@company.co.uk'
  
  UPDATE MailboxBase
  SET ExchangeSyncStateXml=NULL
  WHERE MailboxId='YourMailboxId' 

  2- Open specific user mailbox and run "Test and Enabled Mailbox" option which created new clientid and associated data

  Thanks for your help.

   

  • Proposed as answer by Daniel Ovadia Thursday, September 24, 2015 8:32 AM

  Wednesday, September 23, 2015 2:30 PM