DSXchange

hi
i am using the teradata Enterprise stage to load the data in the teradata tables using the option as replace.the problem i am facing is while running individual job it is running fine but when it is running through the sequence the job gets aborting getting the following errors.my source values are char and i am converting in to deciamal and loading in to the target fileds as intiger.
main_program: Invalid character conversion found converting to ISO-8859-1, substituting.
tdtPdwDA_PDW_CC1K: Error occurred during initializeFromArgs()
main_program: Creation of step finished with status = FAILED
can anybody tell me what is the error.
appreciate your help in this.

The only difference when running under control of a Sequence job should be parameter values. Have you double-checked what was actually passed to the job?

... which you can do in the Director, by inspecting either the log of the job sequence or the log of the job, or the status detail of the job.

yes i have given the same parameters in the sequence also ,
even though it is nor running ,but in some other jobs when i am extracting the records from the same table it is extracting when i am running in the sequence or the job

So that confirms this is a conversion related issue only. If you are extracting from the same table and some jobs are running fine, what differently are you using in the failing jobs? A different target table with different datatype? You are converting Char to decimal and then to integer, trim the source field and do an IsValid() to filter erroneous records.

siva4joy wrote:in some other jobs when i am extracting the records from the same table it is extracting when i am running in the sequence or the job