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.