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.

Objective

This occurs when attempting to execute the Read method, retrieving Null value of type INT on SQL SmartObject (mapped to Workflow data field number through a form). The activity is configured with an input parameter that is taken from a data field in the workflow. The output is mapped to a different variable/data field in the workflow of type 'Number'.

When that activity is executed in the workflow, the process goes into an error state with the message:

 Input string was not in a correct format.

Before You Begin

There's no error on the form or view, and this happens when you read null value from SQL SmartObject into workflow variable of type number.

How-to Steps

K2 does not support SQL SmartObject retrieval of NULL declared values of type INT to workflow variables Number type. However, the value can be returned as an empty string by changing the variable type to "Text" instead of "Number" in the workflow designer variable.