Null Values from SQL SmartObjects are being converted to zero
kbt149855
PRODUCTK2 Five
BASED ONK2 Five (all)
TAGSSQL
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.
Issue
K2 makes the value a valid null, and not the number that is seen. This is the .net DataTable object that does this.Symptoms
When the value goes into the .net DataTable object, it sees the column as an Autonumber, and it automatically honors the identity and adds a number. This causes the "NULL" value to be converted to a "0".Resolution
To resolve this, change the “StoredProc Dataset Execution” setting on the SQL Service instance and set this to “true”. By default, this is set to “false”.
