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.
Error when loading Teradata Table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
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>
<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>