Skip to content


Payables Transaction Insert

Davel asked 9 years ago
I am new to Smartconnect and have managed to create a map to insert a transaction in to GP from an SQL table. However, when I run the map I have come accross the below error. II am unsure as to which field that this problem is referring to!!!! Can anyone help?

"Failed to convert parameter value from a String to a Int16."

Sherry replied 9 years ago

Take a look at your source data and identify all values that are strings. Then look at each of those fields in the GP tables and determine where you have a mismatch – where the destination GP field is not a string field.  The you will have to transform your source data to match the GP data type. Hope this helps. 

Best Answer
Chris answered 9 years ago
Sherry is correct in that you are passing a string value to a field it wants a number in. Another way to do it is to dsend the map to GP – File as the destination and run it. Then you can open one of the xml files and compare the results in those parameters you have mapped to the eConnect schema reference for the node you have mapped and see which fields have the datatype mismatch.

rglide replied 9 years ago

My issue is all the mappings say they are strings, so why does SmartConnect tell me they are strings but when it tries to save them it needs an int?

If you would like to submit an answer or comment, please sign in to the eOne portal.