Failed to convert parameter value from a string to Int16
Trenton asked 9 years ago
i am getting the following error message when trying to run a map. "Failed to convert parameter value from a string to Int16" the field that is erroring out is the key field. the numbers i have tried for that field range anywhere from the date, to a single digit to a name. nothing works. when i pull up the log file, it shows the key as F6 = '1' so it appear there is an "int16" in that field. why would it be erroring out still with that message?
thanks,
thanks,
Answers
Best Answer
lorren answered 9 years ago
Dan replied 7 years ago
lorren answered 9 years ago
Trenton,
That usually means you are trying to send a string value to a SQL Procedure that requires an Integer.
If you are updating Dynamics GP data, you can change your data source to Microsoft Dynamics GP – File and have it generate an XML file. Then you can look at what data is being sent from your SmartConnect Mapping. Compare the XML data based on the expected eConnect data from this site. http://msdn.microsoft.com/en-us/library/ff623651.aspx.
If you are updating a SQL Stored Procedure then you will need to use SQL Server Profiler to see the SQL that is being executed.
Lorren
That usually means you are trying to send a string value to a SQL Procedure that requires an Integer.
If you are updating Dynamics GP data, you can change your data source to Microsoft Dynamics GP – File and have it generate an XML file. Then you can look at what data is being sent from your SmartConnect Mapping. Compare the XML data based on the expected eConnect data from this site. http://msdn.microsoft.com/en-us/library/ff623651.aspx.
If you are updating a SQL Stored Procedure then you will need to use SQL Server Profiler to see the SQL that is being executed.
Lorren
Dan replied 7 years ago Very useful advice. One minor change, it’s the data destination you want to change to Microsoft Dynamics GP – File and have it generate an XML file. From there, it’s fairly straight-forward.