Error "GEN0383W Invalid numeric data in field "xxxxxx"" in EngageOne and DOC1 Generate

Product Feature: Installation / Upgrade

Issue

XML using full stop as decimal separator giving the following error:

GEN0383W Invalid numeric data in field "xxxxxx"  record number 70

Which eventually leads to an abort error (GEN0575A)

When this XML uses a comma as the decimal separator, DOC1GEN succeeds.

Cause

With V5.5, we permitted customers to define the decimal separator in XML data, so if this has been done, this is what Generate will expect to find in the data used at run time.

In later versions (5.6 and later), we tightened up the rules so we complied with XML standards, which state that the decimal separator must be a full stop.

It can also be caused when the data format is created and the locale used has the comma as the decimal separator, and a full stop (period) as the thousands separator.

Resolution

UPDATED: November 7, 2019
XML "rules" state that a numeric value must contain a full stop as the decimal separator.  This will mean that the numeric field in the data format will need to have it's locale changed to one that has the full stop (period) as the decimal separator, and the comma as the thousands separator (for example English United States of America).

If the output needs to show mainland European number formatting (comma as the decimal separator and full stop (period) as the thousands separator), then the publication\document\section properties will need to have an appropriate locale assigned.