Applies ToDynamics CRM 4.0 Dynamics CRM 4.0

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:1User 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: MSCRMEmailEvent Category: None Event ID: 0 Date:DateTime:TimeUser: N/A Computer:Computer NameDescription: #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\n0x80044150 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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.