on 01-06-2009 10:13 AM
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
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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).
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 ?
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.