You are here: Home / FAQ / Database / eWay-CRM synchronization malfunction - Could not find stored procedure 'eWaySP_SendMail_Clr'

eWay-CRM synchronization malfunction - Could not find stored procedure 'eWaySP_SendMail_Clr'

Description

The server log will show:

2014-11-10 14:29:15,281 [8] ERROR w3wp [(null)] - Request processed with error response 'rcGeneralError'
System.InvalidOperationException: Problem executing trigger 'eWaySP_Leads_OwnerChangedNotifier'
---> System.Data.SqlClient.SqlException: Could not find stored procedure 'eWaySP_SendMail_Clr'.

Version

All versions of eWay-CRM

Difficulty

High

Resolution

It is necessary to run the function for creating the CLR procedure on the server.

  1. Launch Microsoft SQL Server Management Studio - you can download it here.
  2. Run this SQL script whereas the path in the parameter is the path to the eWay-CRM web service folder (you have to run procedure as system administrator):
    EXEC [dbo].[eWaySP_CreateClrProcedures] @WebServicePath = N'C:\inetpub\wwwroot\eWay\'
  3. Now, eWay-CRM synchronization should be proceeded successfully.