Page 1 of 1

Floating point Error in Prod

Posted: Mon Sep 08, 2008 11:14 pm
by iwin
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.

Posted: Tue Sep 09, 2008 2:18 am
by ray.wurlod
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.

Posted: Mon Sep 22, 2008 12:23 pm
by iwin
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

Posted: Mon Sep 22, 2008 4:17 pm
by ray.wurlod
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.)