KB Article #178642

CEIL function does not return a correct value

Problem

-- DML ceil function does not behave as expected

Ex : ceil(.109e+1) = 0 ; it should have returned 2

Resolution

* set the the locale environment variables LC_NUMERIC to "en_US", restart Integrator server and test again

LC_NUMERIC="en_US"

* this solution might apply to errors on other mathematics DML function (floor, round, remainder, IntegerPortion, decimalPortion...)