Job failed with Javalang exception

[DEV4]

Hello all,

My job failed with the below error message. Looks like non-numeric value occured in the source which caused the failure while inserting in to numeric column. Please help me how to handle this issue.

Thanks

[Anonymous]

The source has problematic data, ~[?:?], below are 4 situations that depends on your need.
1. Check the data source, correct or remove these problematic data from the source, and then re-run the job.
2. In the job, use tschemaCheckComplianceCheck to check and filter these problematic data before inserting into DB.
3. Capture the error message and stop the job.
4. Just reject these problematic data and continue to execute the job.

Regards
Shong