Hi,

We are using 2012 (Sage 300 Premium ERP) (Build 5) (Product Update 5) and CRM 7.2b updated to h. Both synchronization and importation of contacts was successful, the issue comes about when trying to update any field in company or persons. CRM returns an sql error while ERP returns the error below.

tried some fix like updating the EmailLink_InstUpd but to no vein

Attached is the screen shot kindly assist

Description: Failed to update Sage CRM with customer number 'AU-ADA-3032', named 'ADAMS MATHEW KARAURI'. Specific error: System.Web.Services.Protocols.SoapHeaderException: Failed to update address 1 successfully. SQL Error     at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)     at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)     at AccpacCRMWS.CRMWebService.WebService.updaterecord(String entityname, ewarebase[] records)     at AccpacCRMWS.Link.UpdateRecords(ewarebase[] CRMBase)     at AccpacCRMWS.Link.UpdateAllRecords()     at AccpacCRMWS.Link.UpdateCompanyEntity()

Source:  15:35:14