Error converting data type nvarchar to numeric Error 42000 when exporting using Database Export Connector

Issue

I receive the following error message in the Database Export Connector:

Error: Script #1 (Database Export Connector) [5 ERROR [42000] [Microsoft][ODBC SQL
Server Driver][SQL Server] Error converting data type nvarchar to numeric.]

How can I resolve this issue?

Cause

The issue is that one of the Field Types being exported to the database is decimal type, and by default, the Support Locale Format option is checked (enabled).

The locale format for the Windows PC is set to enter an exponential expression after the decimal point: For example, during Validation, the value is entered as .04.

The Field Type is saved as 4.e-002 because of the Windows locale setting.

The Database Export connector will send the value as 4.e-002 instead of .04, causing the error.

Solution

The solution is to uncheck the Support Locale Format option for the Numeric Field Type that’s being exported.

Level of Complexity 

Easy

Applies to  

References

18698

​