Symptoms

This is a very visible project for K2.

I have a SmartObject with an Update method, that uses the SQL Server Broker to update 2 tables in an app database. Both tables (Task.Master and Task.Accounting) use GUIDs as the primary key, and have the same name (TaskID). So the SmartObject combines 2 table updates in a single SmO method. The SmartObject method has been mapped correctly - I'm 100% sure of that.

I get the following error:

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

We ARE NOT using Stored Procedures. This is the simple table CRUD methods that is created by the SQL Server Broker.

If we update the SmartObject Update method to update only 1 of the tables, it works fine. The Create and Read methods also works fine, even if both tables are being used.
 

Diagnoses

This is a known issue.

 

Resolution

Our labs team has linked the ticket to an existing TFS item - SQL Server Service: Execute Update Method only specifying the Required input (Example ID) throws error.