Error while loading data to Table (TeraData)
Posted: Fri Oct 19, 2007 9:07 am
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.
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.