Issue Description
When the user executes a SQL Service SmartObject, and a non-required field has a null value, a Duplicate Parameter error is thrown.

Error Message
Parameter '[Name of Parameter]' was supplied multiple times.

Cause
SmartObject List method execution NULL values were passed through as SCNULL values.

Repro Steps
Execute a SQL stored procedure SmartObject, using null values on a non-required parameter.

Resolution

  1. Ensure you have K2 4.7 installed.
  2. Install the K2 4.7 February 2017 Cumulative Update.
  3. Get the K2 4.7 February 2017 Cumulative Update FP2 from Regional Support.
  4. Install the K2 4.7 February 2017 Cumulative Update FP2 to apply the fix.