Error for Table Update method with 2 Service Objects (tables) that uses GUID as primary key

 

Symptoms

Trying to execute an UPDATE for a SmartObject that uses the SQL Server Broker to update two tables in the database throws the following error exception:

?10702 An error occurred in SQL service instance. Incorrect syntax near the keyword 'WHERE'.?

Both tables use GUIDs as the primary key, and have the same name (culumnID). So the SmartObject combines 2 table updates in a single SmartObject method.
 

Diagnoses

A composite SmartObject method for CRUD. All works except UPDATE. If you use the SmartObject Update method to update only one of the tables, it works fine. The Create and Read methods also works fine, even if both tables are being used.
 

Resolution

This is a known issue.
A workaround is to execute the UPDATE method on the respective SmartObjects in lieu of the UPDATE method for the composite SmartObject.