If you are using FieldOne Sky or Field Service Mobile, then there is a possibility that you might get this error:

 

License: Valid

Customization NOT MODIFIED

Exception while syncing: productpricelevel

2017-04-24T20:19:48.3360650+01:00: Exception

Thread: Exception while fetching entity productpricelevel

Inner: RescoSoapException: Server Error: Code.Value=s:Sender| Reason.Text=SQL timeout expired.| Detail.OrganizationServiceFault.ErrorCode=-2147204783| Detail.OrganizationServiceFault.Timestamp=2017-04-24T19:19:48.1907336Z| Detail.OrganizationServiceFault.ExceptionRetriable=false| Detail.OrganizationServiceFault.InnerFault.InnerFault.ErrorCode=-2147220970| Detail.OrganizationServiceFault.InnerFault.InnerFault.Message=System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #584C6C78| Detail.OrganizationServiceFault.InnerFault.InnerFault.InnerFault.Message=System.ComponentModel.Win32Exception: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #4E96B386

at ...WebServiceBase.ThrowSoapException (HttpException ex) <0x1004da0b0 + 0x000a8>

at XmlResponse..ctor (System.context, async, soap, System.XmlReaderSettings xmlSettings) <0x1004dab20 + 0x001a7>

at XmlResponse..ctor (System.context, async) <0x1004daaa0 + 0x0002b>

at Crm2011.CrmService2011+<ExecuteFetch>c__Iterator1.MoveNext () <0x10053faf0 + 0x002df>

at Synchronization.SyncEngine+EntityDownloader.Downloader () <0x1004eae50 + 0x00c1b>

-----------------------------

<Summary Foreground Server:5 Crm2011.13/OnlineFederation2016 Threads:3 Sent=1 Recv=682 Result=Normal/>

<Times Total=143496 Connect=1850 Prepare=1338 UploadTotal=379/>

<Error>Exception while fetching entity productpricelevel

Server Error: Code.Value=s:Sender| Reason.Text=SQL timeout expired.| Detail.OrganizationServiceFault.ErrorCode=-2147204783| Detail.OrganizationServiceFault.Timestamp=2017-04-24T19:19:48.1907336Z| Detail.OrganizationServiceFault.ExceptionRetriable=false| Detail.OrganizationServiceFault.InnerFault.InnerFault.ErrorCode=-2147220970| Detail.OrganizationServiceFault.InnerFault.InnerFault.Message=System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #584C6C78| Detail.OrganizationServiceFault.InnerFault.InnerFault.InnerFault.Message=System.ComponentModel.Win32Exception: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #4E96B386</Error>

<Details>

<UploadSync> Entitys=422ms Sleep=1000ms Sent=1 SvrCalls=1 TotalTim=1430 NoChangesLeft</UploadSync>

<GetCustomization Tim=1336/>

<IncSync>

<SyncDeletes <Analyze Tim=232 UnchangedTbls=55/> Fetches=4 Deletes=5 Tim=1121/>

<SyncAnalyzer SkipEntitys=50 Tim=2358ms/>

</Details>

 

When you sync the application it will try and retrieve the data from that entity but will eventually timeout after 2 minutes and the above error message will appear. To fix it, just adjust or remove the Sync Filter in Woodford to the Entity which the error message is pointing to. This is because the joining on the query is too complex for it to complete.

Leave a Reply

Your email address will not be published. Required fields are marked *