java.math.BigDecimal.<init>(Unknown Source) - error in tmap

One Star

java.math.BigDecimal.<init>(Unknown Source) - error in tmap

Hi,
I'm encountering the below error in tmap and below is the screenshot of the tmap.
Can anyone please let me know if anything is wrong.
Exception in component tMap_12
disconnected
java.lang.NumberFormatException
    at java.math.BigDecimal.<init>(Unknown Source)
    at java.math.BigDecimal.<init>(Unknown Source)
    at routines.Numeric.convertImpliedDecimalFormat(Numeric.java:130)
    at drug.job01_12_t_msp_dly_0_1.JOB01_12_T_MSP_DLY.tFileInputMSPositional_2Process(JOB01_12_T_MSP_DLY.java:18615)
Moderator

Re: java.math.BigDecimal.<init>(Unknown Source) - error in tmap

Hi,
There is something wrong with your conversion.
Could you please elaborate your case with an example with input and expected output values?
Do you want to convert your input string into BigDecimal value in tMap?
String-->BigDecimal
new java.math.BigDecimal(row1.columnName).
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: java.math.BigDecimal.<init>(Unknown Source) - error in tmap

Hi Sabrina,
We have the below input data coming from the source as the implied decimal format and we need to load the data using the Talend mappings into the oracle database.
I need to convert string into BigDecimal value in tmap.
Input row data : 498840035012T1   000000000000020090717000000000779020081128000000000420020041028               15344
Sample column data : 000000000000020090
I need to populate the database table in the decimal format as - 2.90
Thanks!