Back

Error message when running the map “Conversion failed when converting the varchar value ‘The’ to data type Int.

Published: Jun 05, 2018
Post Author Written by David Youngquist

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.

Did this answer your question?

FEEDBACK FORM HERE

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.