[FROMDBLOVER] RWDecimal: overflow converting from double (0)

[system]

Hi Experts,
We have a Batch job which runs everyday successfully. we moved this job to a new environment where it sometimes fails with the below error message. Nothing has been changed, it is the same exact job and parameters which runs at the same time as in the old environment too, where it runs successfully all the time and in new environment it fails sometimes with the below message.

Error: <[FROMDBLOVER] RWDecimal: overflow converting from double (0)>

Both the environment are in the same version too (BODS 4.2).Any suggestions?

Thanks,
Deepak N.

---

deepak_n01 (BOB member since 2008-07-22)

[system]

HI Deepak,

Did you find a solution to this problem?

We’re facing an identical situation with DS 4.1 SP2 running on SQL 2012.

Many thanks!

Bogdan

---

Foreman3 (BOB member since 2014-03-25)

[system]

No, I haven’t found any solution for this. The issue hasn’t occurred for these past days and I have no clue why it hadn’t.

Thanks,
Deepak N.

---

deepak_n01 (BOB member since 2008-07-22)

[system]

I have seen this intermittent issue in different environments. No idea what the cause might be.

Run the same dataflow again, with exactly the same data, and everything works as expected.

Could you please create a Support Message for this issue? The more people report it to SAP, the higher the chance of getting it fixed.

---

Alterego (BOB member since 2003-09-23)

[system]

I posted a duplicate issue on this here. Same exact error and same scenario.

Not sure if you’re on SP1 of 4.2, but we are.

I’ll be opening an SAP support issue on this today.

Thanks.

---

nhohman (BOB member since 2008-11-19)

[system]

Any luck with SAP Support? Just raised an incident myself today as it started happening again. We’re running 4.1 SP2 BTW.

Thanks!

---

Foreman3 (BOB member since 2014-03-25)

[system]

I have a similar issue on BODS 4.1 SP1 across several marts. converting from int to decimal. I recast explicitly as decimal. It hasn’t returned yet.

cast(QrySourcePK.ADDRESSNUMBER, ‘decimal(28,0)’)

---

jbankston (BOB member since 2013-11-04)

[system]

Same problem here.

2 jobs, scheduled every night, and suddenly both jobs crashed in the same night with the same error mentioned in this topic.

When I ran the jobs manually in the morning, no error occured.

The input data is totally different I so don’t expect a data issue.

We are on BODS 4.2 SP1 Patch 4.

I just filed an incident at SAP support. These are my two mappings:

nvl(CAST(dt_3.WDAA_DE_BDR_WINK,'decimal(20,4)') + CAST(dt_3.WDAA_DE_BDR_WINK_RL,'decimal(20,4)'), CAST(0,'decimal(20,4)'))

(target column is a decimal(20,4)

ifthenelse(dt_2.VALUEHOME< 0.0000,dt_2.VALUEHOME,0.0000)

(VALUEHOME is a decimal(19,4), and so is the target column)

---

H. Westerhof (BOB member since 2010-03-26)

[system]

Hello there

Any update or ADAPT nr ? We’re facing the same, so just wanted to know does it make any sense to create new incident with SAP?

---

Antremons (BOB member since 2006-03-21)

[system]

Please file another incident @ SAP Support. The more issues they get, the sooner they will fix this.

Update from my side. I have done two things. Update to BODS 4.2 SP2, and alter the mapping. The problem hasn’t returned since (but it still can, it’s very random)

Old mapping:

ifthenelse(dt_2.VALUEHOME< 0.0000,dt_2.VALUEHOME,0.0000)

New mapping:

CAST( ifthenelse(dt_2.VALUEHOME< 0.0000,dt_2.VALUEHOME,0.0000) , 'decimal(19,4)')

---

H. Westerhof (BOB member since 2010-03-26)

[system]

I also encounter the same problem in our production server.

I found that there’s no such problem when the application database is of oracle version 11.2.0.2

The problem happens intermittently for same set of DI ETL jobs when connecting to oracle version 11.2.0.4

During production loading of one of our Business Units we got the Error:
<[FROMDBLOVER] RWDecimal: overflow converting from double
(2.01301e+007)>.
(14.0) 07-24-14 08:37:33 (E) (6876:3272) RUN-053008: |Data flow
DF_B_TXN_DELTA_POINT|Transform Query_2-Mapping2
INFO: The above error occurs in the context <|Data flow
DF_B_TXN_DELTA_POINT|Transform Query_2-Mapping2|Project Column
TRANSACTION_DT_KEY|>.
appeared. This column mapped along with “cast” function.

---

mtvloong (BOB member since 2014-07-30)

[system]

I have also raised a support ticket to SAP.

---

mtvloong (BOB member since 2014-07-30)

[system]

This is the response from SAP

Dear Customer
Let me report the latest progress. This problem has been investigated
and it is judged as a bug. The adapt ADAPT01730269(DS 4.1 FROMDBLOVER
error) has been created for it and it is scheduled to be fixed at
DS_4.2_SP03 which will be released about in September.
As you current version is Data Services 4.0 SP2 Patch 1 which is too
old and has not been supported now, it is recommended for you to
upgrade to the DS_4.2_SP03 to fix the issue.
Note:As it is possible that the fix schedule maybe changed too, it is
recommended for you to read the release noteof DS_4.2_SP03 to check
whether ADAPT01730269 has been fixed in it before upgrading.

---

mtvloong (BOB member since 2014-07-30)

[system]

That’s good news. Hopefully they won’t delay the fix in another fixpack.

The problem now occurs on other places in my ETL as well, while it didn’t before.

---

H. Westerhof (BOB member since 2010-03-26)

[system]

Does anyone has this error after upgrading to DS 4.2 SP3?

The ADAPT no. mentioned above (ADAPT01730269) is not mentioned in the release notes.

---

H. Westerhof (BOB member since 2010-03-26)

[system]

[quote:b89671ee6f=“H. Westerhof”]Does anyone has this error after upgrading to DS 4.2 SP3?

The ADAPT no. mentioned above (ADAPT01730269) is not mentioned in the release notes.
[/quote]

I’m on 4.2 SP3 and I’m getting this error.

Take a look at KB 1987908 for a intrim fix.

---

LymedoBI (BOB member since 2013-08-08)

[system]

Thanks for the SAP note.

However my jobs cannot get started when patching the work around files.

Bottomline, I have production ETL which crashes randomly in the night, and according to the same SAP note, the scheduled fix is planned for SP3 Patch 3, or later because they can change the schedule without prior notification.

I’m going to file another incident about this, that it’s taking too long and that it’s affecting our customer satisfaction.

---

H. Westerhof (BOB member since 2010-03-26)

[system]

I saw it was mentioned in the SP3 PL2 release notes.

ADAPT01730269
A Data Services job may fail with the error message “Error: <[FROMDBLOVER] RWDecimal: overflow converting from double ()” if conversion takes place between integer/double to decimal. To resolve this issue, set Use_Decimal_Mutex=1 in the [AL_Engine] section of the DSConfig.txt file.

Apparently changing/adding a parameter to the dsconfig.txt file on your job server(s) is also required. I haven’t tried it yet. Will do on my sandbox this week though.

---

wahey (BOB member since 2007-05-31)

[system]

I have installed the patch and added this parameter.

After many test runs with jobs in which we previously could reproduce the problem easily, I haven’t seen the FROMDBLOVER error anymore.

---

Alterego (BOB member since 2003-09-23)

[system]

We installed SP3 Patch 2, but unfortunately another error arises. It’s almost the same though.

Any ideas?

Error: <[FROMLDBLOVER] RWDecimal: overflow converting from long double (0)>.

(Ps watch the difference, this time it’s FROMLDBLOVER instead of FROMDBLOVER)

---

H. Westerhof (BOB member since 2010-03-26)