Format Error Numeric Value Not Consistent with Culture Separators

Affected Software/Reports/DLL(s): EDP

Symptoms: This is a data/configuration error that occurs prior to the problematic data arriving at the database (shown below).

“Numeric value is not consistent with the current culture separators (decimal separator = '.'; group separator = ',')”

Cause/Details: Fields of numeric type where the numeric value starts with a zero or the thousand/group separator will result in this error. Additionally, an error will appear if the number of digits before the first group separator is greater than three or if the number of digits between two group separators (or one group separator and the decimal separator or last group separator and end of value if the decimal separator does not exist) does not equal three.

Resolution/Workaround: This error can be solved by swapping the separators in the numeric value or by loading the data into EDP using the same culture settings that the data was created in.