Error while loading data to Table (TeraData)

[anil411]

DataStage/TeraData Gurus,

1. The parallel job is loading data from DataSet to TeraData Table. We are using ODBC Stage to load data.

This job is being called many times during the entire schedule. Say if the job was called 10 times , It rans sucessfully for 6 times but another 4 times we get a Fatal Error Message as below but the job doesn't fail.

tera_PROCESS_LOG,1: [DataDirect][ODBC Teradata Client driver][Teradata]Right truncation of string data.

The job doesn't fail and the Successor Job runs normally.

Please suggest us how to fix the error.

2. Sometimes the job fails with the following error message.

ODBC_PRCS_CNTL,0: The runLocally() of the operator failed.

After re-running the Failed job without any changes, The job runs normally and finishes succesfully.

Please give your thoughts to fix the above issues.

[JoshGeorge]

1. A "Right truncation of string data" error means that a value in a field is too long for the field. These error messages are thrown for specific records which are coming in the above fashion by teradata CLI whilst it rejects those records. This should have been recorded as a warning message and not a Fatal, something you should take to the official support to clarify. 4 times you got this Error Message and the job didn't fail because of the same reason. If you investigate the records you passed to teradata table in these 4 runs you should be able to figure this out.