Problem Statement:

When attempting to run a batch query, receives error:

 "The batch job failed due to a SQL error. Data conversion or data mapping error."


It appears that some invalid data was causing the error.

Things to check:

  1. Make sure there are no invalid dates like a 13th month, or 32nd day.
  2. Make sure there are no result columns that may be trying to divide by zero. If so use Case logic to modify.
  3. Make sure that a result column is not being brought back as a NULL.

If dividing 2 fields and returning a NULL you may have to use the FLOAT wrapper around each field in the result column to bring back the correct value.


Ref#: 1475861





Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: April 21, 2017