Error message when running the map “Conversion failed when converting the varchar value ‘The’ to data type Int.
By David Youngquist, Senior Support EngineerTuesday, June 5, 2018
Running a SmartConnect map using KEY2ACT eConnect nodes and receiving an error that says. “Conversion failed when converting the varchar value ‘The’ to data type Int.” The word “The” might be replaced by the word “Job” or another random word.
This is caused by a setting in the Wennsoft eConnect nodes. At the bottom of each node mapping, there is a field called “ReturnErrorText”. Set this field to a local constant of 0 (zero). This tells their node to return the error number and not the error message.