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:
- Make sure there are no invalid dates like a 13th month, or 32nd day.
- Make sure there are no result columns that may be trying to divide by zero. If so use Case logic to modify.
- 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.
Last Modified On:
No, open a new Support Case
You don't have the appropriate permissions.