warning while running a job

haivineetha · Post by **haivineetha** » Thu May 07, 2009 9:14 pm

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

datastage_learner · Post by **datastage_learner** » Thu May 07, 2009 10:15 pm

Try to set the metadata for decimal column properly...

chulett · Post by **chulett** » Thu May 07, 2009 10:26 pm

First step actually is posting the question in the proper forum.

haivineetha · Post by **haivineetha** » Thu May 07, 2009 10:51 pm

The metadata is set properly.The job is currently running perfectly in the production.The prob is with dev only...!

datastage_learner · Post by **datastage_learner** » Thu May 07, 2009 11:06 pm

haivineetha wrote:The metadata is set properly.The job is currently running perfectly in the production.The prob is with dev only...!

sometimes slight changes in dev / prod environments creat such minor issues

mate...if u are not performing any calculation on decimal col. I would change it as string and try to process it

haivineetha · Post by **haivineetha** » Thu May 07, 2009 11:10 pm

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!

datastage_learner · Post by **datastage_learner** » Thu May 07, 2009 11:14 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.

ray.wurlod · Post by **ray.wurlod** » Thu May 07, 2009 11:29 pm

Try posting the question in the correct forum, so we get some idea of what version, what platform and what job type you are using.

haivineetha · Post by **haivineetha** » Thu May 07, 2009 11:30 pm

can u suggest some forums?

ray.wurlod · Post by **ray.wurlod** » Thu May 07, 2009 11:33 pm

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.

haivineetha · Post by **haivineetha** » Thu May 07, 2009 11:35 pm

Sorry for that..!Will keep that in mind next time I log in.

*Note: Topic Relocated - Content Editor*