warning while running a job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Thu May 07, 2009 9:06 pm
warning while running a job
Hi,
I am getting the Warning:-
" Unable to set output decimal field value from argument string '1078.72256' in function setOutputFieldAsDecimal() for field '6' in output dataset "
while I run the job.The run is always a success,but cant solve the warning.This warning is from a teradata source stage,which acts as a before dataset to a change capture stage.
Can someone help????? :
I am getting the Warning:-
" Unable to set output decimal field value from argument string '1078.72256' in function setOutputFieldAsDecimal() for field '6' in output dataset "
while I run the job.The run is always a success,but cant solve the warning.This warning is from a teradata source stage,which acts as a before dataset to a change capture stage.
Can someone help????? :
-
- Participant
- Posts: 15
- Joined: Thu May 07, 2009 9:50 pm
-
- Participant
- Posts: 9
- Joined: Thu May 07, 2009 9:06 pm
-
- Participant
- Posts: 15
- Joined: Thu May 07, 2009 9:50 pm
sometimes slight changes in dev / prod environments creat such minor issueshaivineetha wrote:The metadata is set properly.The job is currently running perfectly in the production.The prob is with dev only...!
mate...if u are not performing any calculation on decimal col. I would change it as string and try to process it
Thanks,
DS_Learner
DS_Learner
-
- Participant
- Posts: 9
- Joined: Thu May 07, 2009 9:06 pm
-
- Participant
- Posts: 15
- Joined: Thu May 07, 2009 9:50 pm
haivineetha wrote:I should be resolving this issue without changing the metadata of the columns since the job is fine in production .This runs daily in production!
well something u gotta change to get it working right? try trimming it..
from the error it seems there is issue with function and decimal o/p value it self.
Thanks,
DS_Learner
DS_Learner
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I doubt it. U has not logged in for some weeks.
The second person personal pronoun in English is spelled "you", not "u". We strive for a professional standard of written English on DSXchange, primarily to make life a little easier for those whose first language is not English, but also because, as professionals, we are aware that DSXchange is not a device that requires SMS-style abbreviations.
Meanwhile, go back to the index and choose one of the Server or Enterprise Edition forums, depending on whether your job type is server or parallel respectively.
The second person personal pronoun in English is spelled "you", not "u". We strive for a professional standard of written English on DSXchange, primarily to make life a little easier for those whose first language is not English, but also because, as professionals, we are aware that DSXchange is not a device that requires SMS-style abbreviations.
Meanwhile, go back to the index and choose one of the Server or Enterprise Edition forums, depending on whether your job type is server or parallel respectively.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 9
- Joined: Thu May 07, 2009 9:06 pm