Hello,

We have a workflow that pulls in a ck number from quick fields, then goes off to find the vendor that matches it.

The field in the template is a long int.

The column in the SQL view is int.

The process used to work then one day just stopped. Error is occurring during the query data source step.

the error is Conversion failed when converting the narvrchar vaule %(retreveFieldValuesCheckNumber_CheckNumber) to data type int.

I have attempted to resolve this issue by adding a token after return data type, and setting that token to  non string values (tested with number & long int) with the same error. Why is the field getting pulled in as a string?

Thank you for your time,

Tabby