Dear all,
We are facing an issue where the user receives an error while hitting the button "Synchronize with CRM" inside the Outlook client.
the error states " A SQL Server error occurred. Try this action again. If the problem continues, check the Microsoft Dynamics CRM Community".
We have a CRM 2013 server on-premises with SP1 installed on both the server & the client pc. The user can access the web interface of CRM without problems & it appears that the appointments and email are correctly tracked inside the CRM server. But the error still appears..
Any idea on how to solve this issue ?
Here are the logs I've gathered :
[2014-09-18 12:02:33.948] Process:OUTLOOK |Organization:0b0dc0cb-e2f7-42d8-a18e-286879fc7f95 |Thread: 28 |Category: Application.Outlook |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: | CrmServiceForOutlook.Execute ilOffset = 0xD
at CrmServiceForOutlook.Execute(OrganizationRequest request, Boolean wrapException) ilOffset = 0xD
at OutlookSubscription.PrepareOnlineSync(String clientId, Int32 callPriority) ilOffset = 0x24
at OnlineSyncStrategy.PrepareSync(String id, Int32 callPriority) ilOffset = 0xD
>FaultExceptionDetails: Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Generic SQL error.Detail:
<OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
<ErrorCode>-2147204784</ErrorCode>
<ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
<Message>Generic SQL error.</Message>
<Timestamp>2014-09-18T10:02:10.305324Z</Timestamp>
<InnerFault>
<ErrorCode>-2147204784</ErrorCode>
<ErrorDetails xmlns:d3p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
<Message>Generic SQL error.</Message>
<Timestamp>2014-09-18T10:02:10.305324Z</Timestamp>
<InnerFault>
<ErrorCode>-2147220970</ErrorCode>
<ErrorDetails xmlns:d4p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
<Message>System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #BB7ABAFB</Message>
<Timestamp>2014-09-18T10:02:10.305324Z</Timestamp>
<InnerFault i:nil="true" />
<TraceText i:nil="true" />
</InnerFault>
<TraceText i:nil="true" />
</InnerFault>
<TraceText i:nil="true" />
</OrganizationServiceFault>
Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.Xrm.Sdk.IOrganizationService.Execute(OrganizationRequest request)
at Microsoft.Xrm.Sdk.Client.OrganizationServiceProxy.ExecuteCore(OrganizationRequest request)
at Microsoft.Crm.Application.SMWrappers.ClientOrganizationServiceProxy.ExecuteCore(OrganizationRequest request)
at Microsoft.Crm.Application.SMWrappers.CrmServiceForOutlook.Execute(OrganizationRequest request, Boolean wrapException)
[2014-09-18 12:02:33.948] Process:OUTLOOK |Organization:0b0dc0cb-e2f7-42d8-a18e-286879fc7f95 |Thread: 28 |Category: Application.Outlook |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: | OnlineSyncStrategy.PrepareSync ilOffset = 0xD
at OnlineSyncStrategy.PrepareSync(String id, Int32 callPriority) ilOffset = 0xD
> TraceException: Unhandled Exception: System.Runtime.InteropServices.COMException: Generic SQL error.
at Microsoft.Crm.Application.SMWrappers.CrmServiceForOutlook.Execute(OrganizationRequest request, Boolean wrapException)
at Microsoft.Crm.Application.SMWrappers.OutlookSubscription.PrepareOnlineSync(String clientId, Int32 callPriority)
at Microsoft.Crm.Application.SMWrappers.OnlineSyncStrategy.PrepareSync(String id, Int32 callPriority)
