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:
Example:
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.