Error when trying to Update Salesforce in SSMS as linked server

[kacorace]

OLE DB provider "MSDASQL" for linked server "SALESFORCE_64" returned message "[Devart][ODBC][Salesforce]SQLite error
parser stack overflow".
Msg 7343, Level 16, State 4, Line 13
The OLE DB provider "MSDASQL" for linked server "SALESFORCE_64" could not UPDATE table "[SALESFORCE_64]...[Opportunity]".

[MaximG]

Hi there!
Thank you for contacting Devart and for your inquiry!
We received the text of the implemented request which you have sent earlier and we are already investigating it.
We will inform you as soon as we have the results!

[ryanc30]

I also have the same issue. Any advice?

The select works correctly. The update gives the error.

Select * From [DYNAMICS365]...[account]
where name = 'Margaret Bruce (RGC Import)'

update [DYNAMICS365]...[account]
set websiteurl = '[email protected]'
where name = 'Margaret Bruce (RGC Import)'

OLE DB provider "MSDASQL" for linked server "DYNAMICS365" returned message "[Devart][ODBC][Dynamics 365]SQLite error
parser stack overflow".

[MaximG]

Its appearance is associated with the peculiarities of the SQL Server Management Studio and we will try to find the necessary solution. Currently for changing the value of the websiteurl field you can use the following request:
UPDATE OPENQUERY ([DYNAMICS365], 'SELECT accountid, name, websiteurl FROM account WHERE name = ''Margaret Bruce (RGC Import)''') SET websiteurl = '[email protected]'