string to decimal error conversion

kjaouhari · Post by **kjaouhari** » Wed Jul 15, 2009 9:42 am

Hello all,

My job is aborting because of this error generated by aggregator stage:
Value treated as NULL
Attempt to convert String value "26.50" to Decimal type unsuccessful
The think is the data looks like a decimal and the data type is also decimal.
Does anything need to be change on NLS ?

ArndW · Post by **ArndW** » Wed Jul 15, 2009 10:00 am

No, this has nothing to do with NLS. Perhaps there are "hidden" characters in the string and I seem to recall that spaces cause issues as well. Do the explicit conversion in a modify or transform stage and you can also implement the IsValid() function to check on validity.

kjaouhari · Post by **kjaouhari** » Wed Jul 15, 2009 10:28 am

I was thinking that it has to do with NLS cause when the decimal value is with coma then it works.
Again the issue is within the aggregator, I need to set the decimal value in aggregator with dot and not coma.
I did change the NLS many times but still ask for coma as decimal.

kjaouhari · Post by **kjaouhari** » Thu Jul 16, 2009 2:21 am

Does anybody know how to set decimal value with dot instead of coma in aggregator ?

ArndW · Post by **ArndW** » Thu Jul 16, 2009 2:31 am

The "," comma is the decimal separator in several NLS locales so you are correct and I was wrong - it is likely to do with NLS after all. What Locale do you have set - in German, for example, the default decimal separator is the "," character. Also, in the "edit row" attributes for the column in question, do you have "decimal separator" set - if not, try putting in a decimal point.

kjaouhari · Post by **kjaouhari** » Thu Jul 16, 2009 3:09 am

Thanks ArndW,
Any idea on wich NLS will be suitable for this ? I'm testing lot of them unsuccessfuly so far.

I've checked some previous posts and this issue seems to be related to anyone that need to migrate from 7.1 to 8 with NLS enabled.

kjaouhari · Post by **kjaouhari** » Thu Jul 16, 2009 3:10 am

Thanks ArndW,
Any idea on wich NLS will be suitable for this ? I'm testing lot of them unsuccessfuly so far.

I've checked some previous posts and this issue seems to be related to anyone that need to migrate from 7.1 to 8 with NLS enabled.

ArndW · Post by **ArndW** » Thu Jul 16, 2009 4:28 am

The actual character set is not important - it is the NLS Locale which affects such things as date & time format, decimal separators, currency and collating order.

kjaouhari · Post by **kjaouhari** » Thu Jul 16, 2009 5:10 am

Unfortunately, when I change those NLS settigns in US -ENGLISH , still the decimal is not recognized. And There is no NLS tab within the aggregator stage. I'm going to check if there is anything to do on administrator ...

ArndW · Post by **ArndW** » Thu Jul 16, 2009 5:58 am

Did you try explicitly setting the delimiter in the column definition?

kjaouhari · Post by **kjaouhari** » Thu Jul 16, 2009 6:04 am

I don't see any location in aggregator where I can set the delimiter .

ArndW · Post by **ArndW** » Thu Jul 16, 2009 6:17 am

right-mouse click on the column and choose "edit row"

kjaouhari · Post by **kjaouhari** » Thu Jul 16, 2009 6:40 am

ok , but still don't really see where and how to set the delimiter

ArndW · Post by **ArndW** » Thu Jul 16, 2009 6:55 am

There is a category called "decimal separator" which lets you specify which character you wish to use.

kjaouhari · Post by **kjaouhari** » Thu Jul 16, 2009 7:24 am

Don't have such thing in aggregator stage.