Code Fix: An error occurs when executing a SQL Service SmartObject when a non-required field contains a null value
KB001825
PRODUCTK2 blackpearl 4.7
BASED ONK2 blackpearl 4.7
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.
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
- 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.