You may receive an error message when you try to save an appointment, promote an e-mail message, or run the E-mail Router in Microsoft Dynamics CRM 4.0

Hotfix Download Available
View and request hotfix downloads

View products that this article applies to.

SYMPTOMS

You may experience one or more of the following symptoms in Microsoft Dynamics CRM 4.0.

Back to the top

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.

Back to the top

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.

Back to the top

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 (http://support.microsoft.com/kb/951502/ ) You cannot open an e-mail message that is sent from a Microsoft Dynamics CRM 4.0 user

Back to the top

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 (http://support.microsoft.com/kb/949256/ ) Microsoft Dynamics CRM 4.0 updates and hotfixes

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Back to the top

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 (http://support.microsoft.com/kb/824684/ ) Description of the standard terminology that is used to describe Microsoft software updates

887283 (http://support.microsoft.com/kb/887283/ ) Microsoft Business Solutions CRM software hotfix and update package naming standards

Back to the top