LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: lae_errors

This post has been created for discussion of error code ls.brain.node.changeMetadata.conversionError.

Please reply to this thread with any description of error conditions, diagnostic information, and recommended resolutions.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

This error can occur when there is no explicit conversion defined between the input value in a record and the required output data type.

The error can be generated when converting string data to a numeric data type and the input data contains an empty string. In this case there is usually more descriptive information included in the error message, e.g.

ERROR: Field 'id', Record#5 - Could not convert id to double; java.lang.NumberFormatException: empty String
Error Code: ls.brain.node.changeMetadata.conversionError

In the above example the first error message indicates that the conversion of the 5th record in the 'id' field could not be converted to a double data type as it contained an empty string.
Similar errors would also be generated when attempting to convert to other numeric values (int, long).

You can force the conversion of an empty string value to a NULL value by setting the 'EmptyStringAsNull' property on the Optional tab to 'true'.