Error when loading Teradata Table

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
siva4joy
Premium Member
Premium Member
Posts: 34
Joined: Fri Apr 14, 2006 6:10 am
Location: London

Error when loading Teradata Table

Post by siva4joy »

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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

... 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
siva4joy
Premium Member
Premium Member
Posts: 34
Joined: Fri Apr 14, 2006 6:10 am
Location: London

Post by siva4joy »

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
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

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
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Post Reply