cancel
Showing results for 
Search instead for 
Did you mean: 

Decimal conversion error (Data Integrator 11.7.000)

Former Member
0 Kudos

Did someone encoutered this error? Any solution?

1004 3488 RUN-050802 06/01/2009 10:43:23 Cannot convert data <-.91> into type <DECIMAL>. Context: Column <Project Column AIColumn7>.

It happens when I try to perform a multiplication of a number with -0.91

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

what is the mapping expression ?

what is the datatype of the source column and data type of target column ?

you get this error for all rows or you get this error even before loading started ?

Former Member
0 Kudos

Mapping expression : VNO_GLB_QTE_FRN_DOM_PRV*PRX_HT_VNO

VNO_GLB_QTE_FRN_DOM_PRV : integer

PRX_HT_VNO : decimal(6,2) (which get the value -0.91)

Target column: decimal(9,2)

I get this error for each row where value of PRX_HT_VNO is like '-0.xx'

Former Member
0 Kudos

is this expression getting pushed down to the database ?

I tried reproducing this issue using 2 table source, but couldn't reproduce also tried with 2 file source just to make sure it get evaluated in DI, but that seems to wrok as well

what is the exact version of DI, 11.7.0.0, 11.7.2.x, or 11.7.3.x

are there amy lookup_ext functions in the Query mapping ?

are you using DOP for this DF?

Former Member
0 Kudos

the expression is not pushed down to the database

we have DI version 11.7.3.0 with Oracle 9.2 databases (repository and datastores)

there is not lookup_ext in the Query mapping, I use 2 source tables which are join by 1 column

I use DOP = 0 for this DF. I also tried with DOP=2 (our server is bi-proc).

Former Member
0 Kudos

this seems to be happening for a specific optimization plan

tried with 11.7.3.0 and oracle 9i, since the query is not getting pushed down so most likely not a issue with database

I am trying to reproduce this using 2 source table and multiplying 2 columns in mapping by selecting a int column from one table and decimal (6,2) column from other table and output is also decimal (6,2)

is there anything else in the mapping expression for the other column, which might be creating multiple nodes for optimizer

can you give some more information about the DF, like outer join, where condition

since you mentioned both the source are oracle, why is the expression not getting pushed down ?

Former Member
0 Kudos

I tried with a basic query with just the primary key column and the calculated column.

the error happens when I use an external lookup in the DF.

I'll try to use no external lookup when this kind of error happens.

Thanks for your help