A Generic SQL error may appear in the Riva On-Premise CRM Monitor application for some users. (For Riva Cloud users, this is extremely unlikely to occur, but if it does, contact the Riva Success Team.)
The crmex-log files contain an error stack similar to this:
2013-04-08 16:33:33,942 ERROR [CTP-tyy #188] [23CDU14O7U2O] [CA] Error occurred polling for changes
Omni.OmniSoapException: [0x80044150:appointment] Generic SQL error. ---> 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)
Because this type of error is occurring in the Microsoft SQL server hosting the CRM datastore, Riva logs cannot determine what the specific error is without additional diagnostic investigation.
To gather additional information:
Applying a U12 patch to the Dynamics CRM 2011 server breaks a feature used by Riva called “AllColumns”. With this feature, Riva can simply ask for all columns available in the CRM, and the system returns them. However, as of U12, it appears that SQL Server has an SQL bug that causes this query to fail with these Generic SQL errors.
Solution for Riva On-Premise
To prevent the error:
Article ID: 916
Last updated: 13 Dec, 2016
Also listed in
Riva On-Premise - CRM Sync -> Manage Riva On-Premise (Admin Guides) -> Troubleshooting (Includes Monitoring) -> Resolving Data Sync Issues
Riva On-Premise - CRM Sync -> Manage Riva On-Premise (Admin Guides) -> CRM Systems -> Microsoft Dynamics CRM -> Errors & Troubleshooting