Symptoms
You may experience one or more of the following symptoms in Microsoft Dynamics CRM 4.0.
Symptom 1
When you try to save an appointment for an account, you receive the following error message:
A SQL Server Error has occurred
Violation of UNIQUE KEY constraint 'UQ_PrincipalObjectAccess'. Cannot insert duplicate key in object 'dbo.PrincipalObjectAccess'.If you use Microsoft SQL Server tracing, you also receive an error message that resembles the following:
Exception: Error: 2627,Severity: 14,State:1
User Error Message: Violation of UNIQUE KEY constraint 'UQ_PrincipalObjectAccess'. Cannot insert duplicate key in object 'dbo.PrincipalObjectAccess'. User Error Message: The statement has been terminated.This problem occurs if the account owner shares the account with you.
Symptom 2
When you try to promote an e-mail message from Microsoft Outlook to Microsoft Dynamics CRM 4.0, you receive the following error message:
Email cannot be promoted.
Symptom 3
When you run Microsoft Dynamics CRM 4.0 E-mail Router on a computer, you receive an error message in the application event log that resembles the following:
Event Type: Error
Event Source: MSCRMEmail Event Category: None Event ID: 0 Date: Date Time: Time User: N/A Computer: Computer Name Description: #9628 - An error occurred while delivering the e-mail message with subject "Subject" in mailbox E-mail Address for delivery to http://crm/CRM. System.Web.Services.Protocols.SoapException: Server was unable to process request. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.Crm.Sdk.Proxy.CrmService.Execute(Request Request) at Microsoft.Crm.Tools.Email.Providers.CrmPollingMailboxProvider.DeliverMessageInternal(EmailMessage emailMessage) at Microsoft.Crm.Tools.Email.Providers.ExchangePollingMailboxProvider.DeliverMessageInternal(EmailMessage emailMessage) at Microsoft.Crm.Tools.Email.Providers.CrmPollingMailboxProvider.DeliverMessage(EmailMessage emailMessage) at Microsoft.Crm.Tools.Email.Providers.CrmPollingMailboxProvider.Run()\r\n 0x80044150 Generic SQL error. Platform For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Note These problems occur after you apply hotfix 951502. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
951502 You cannot open an e-mail message that is sent from a Microsoft Dynamics CRM 4.0 user
Resolution
This problem is fixed in the latest cumulative update rollup for Microsoft Dynamics CRM 4.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
949256 Microsoft Dynamics CRM 4.0 updates and hotfixes
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
More Information
For more information about the terminology that is used to describe Microsoft software updates, click the following article numbers to view the articles in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards