Fatal Error On Decimal representaion for stage variable

kumar3846 · Post by **kumar3846** » Wed Oct 25, 2006 3:19 pm

Hi ,

My job is getting failed in my preproduction run with full volume which job has succesfully ran with out any warnings

in my job i am using a stage varible AKT decimal (10,4)
the source column A for this variable is also having decimal(10,4)

in stage varibale iam uisng NullToValue(A,0.0)

It is not giving any error or warning in my Development , but it is failed
in production environ ment please help me out this

here is the fatal error

APT_CombinedOperatorController,3: Fatal Error: APT_Decimal::compare: the left-hand-side decimal has an invalid
representation.
node_re2cdw02_1: Player 7 terminated unexpectedly

Thank You

talk2shaanc · Post by **talk2shaanc** » Wed Oct 25, 2006 6:05 pm

a question before suggesting anything; are you using the same file in pre-production run ?

Kirtikumar · Post by **Kirtikumar** » Thu Oct 26, 2006 12:29 am

Kumar,

From the warning one can not say that it is aborting due to stage var or something else.

Do you have any other decimal operation or column in your mappings?

kumar_s · Post by **kumar_s** » Thu Oct 26, 2006 12:38 am

Try passing the exact length of the decimal field like "000000.0000" to NullToValue expression. Additionally, try disable the CombinableOperator in your transformer property to get more diagnostic message.

kumar3846 · Post by **kumar3846** » Thu Oct 26, 2006 9:41 am

Thank you for your response

kumar_s the thing is when i am running my developement it is running fine and if i dont use stage varible its is giving lot of following errors

Xfm_rate,1: APT_DecimalNumber::analyzeAndPrepare:divisor is 0.
Xfm_rate,1: APT_DecimalNumber::APT_DecimalNumber: invalid decimal argument.
Xfm_rate,1: APT_DecimalNumber::analyzeAndPrepare:parameter(s) are invalid or not normalized.

i am here dividing two decimals and cheking for nulls and zeros for denominator as 0000000000.0000 even i increased the target filed precision and scale it is giving me the same warnign,

may the way handling the null and cheking zeros for decimal value makin
some thing wron denominator is decimal(10,4)
numerator is decimal(10,4)
please help me out this thank you

ray.wurlod · Post by **ray.wurlod** » Thu Oct 26, 2006 9:42 am

You'd better show us HOW you are "checking for denominator", since DataStage is still claiming an attempt to divide by zero.

kumar3846 · Post by **kumar3846** » Mon Oct 30, 2006 12:20 pm

Here is my cheking for denominator

If IsNull(a) Or IsNull(b) Or IsNull(c)
Then SetNull() Else If IsNotNull(a) And IsNotNull(b) And IsNotNull(c) And b<>0.0 Then
(a/b)*(c) Else SetNull()

Please help me out

thank you

Nageshsunkoji · Post by **Nageshsunkoji** » Tue Oct 31, 2006 5:28 am

Hi Kumar,

Check the Datatype of Divisor, ( I think b in case of your derivation rule). If your output is a decimal and your perfroming division opertaion on a Decimal field, then your divisor datatype should be in decimal.
For Ex : If you are performing 100.00/10 and storing in a decimal filed,it will not give you the result, try to perform 100.00/10.00, then you will get the result.

kumar3846 · Post by **kumar3846** » Wed Nov 01, 2006 10:15 am

B is also decimal the three fields iam using are decimals