Code Fix: An error occurs when executing a SQL Service SmartObject when a non-required field contains a null value
KB001825
PRODUCTIssue 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
- Ensure you have K2 4.7 installed.
- Install the K2 4.7 February 2017 Cumulative Update.
- Get the K2 4.7 February 2017 Cumulative Update FP2 from Regional Support.
- Install the K2 4.7 February 2017 Cumulative Update FP2 to apply the fix.