Floating point Error in Prod

iwin · Post by **iwin** » Mon Sep 08, 2008 11:14 pm

Hi All,
I am running a job in Production which sources the data from Oracle and i get the warnings: Floating point decimal is not fully supported: Adjusting the scale.
I ran the same job in Dev Server many times before moving it to prod but didnt get any of this warnings. I'm not sure if this is bcos of Prod and Dev servers not being consistent ??
Any Ideas please suggest!!!

Thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 09, 2008 2:18 am

Search?

Floating point is not fully supported, because it can't be. Study the IEEE standards on storage of floating point numbers in computers to find out why.

iwin · Post by **iwin** » Mon Sep 22, 2008 12:23 pm

ray.wurlod wrote:Search?

Floating point is not fully supported, because it can't be. Study the IEEE standards on storage of floating point numbers in computers to find out why.

Hi Ray,
Thanks for the info. But the job that i ran in Datastage dev server gave no warnings but when i run the same job in Datastage Prod box i get these warnings. I'm not sure why there is inconsistancy between Dev and Prod Servers??

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon Sep 22, 2008 4:17 pm

Did someone create a local message handler in development? (There will be an entry in the log showing near the beginning that a message handler was attached, and another near the end if one was used.)