Question Re: Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution. in Technology Q&A

Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution.

Former Member — Sun, 02 Aug 2015 15:16:25 GMT

Hi Experts,

I am in a serious problem and I have to deliver this tomorrow please help me to resolve this issue. I have never encountered this error before.

I am getting this error when i am executing my query through Analyzer I tried in RSRT too but in RSRT it automatically goes to Debugger mode.

I have tried to create new fresh query also but the same issue i am facing. Also, I am not calculating anything from key figures.

Below is the error screen shot form analyzer, Please help me to understand and solution.

your input will be much appreciated.

Thanks

Ansh

Re: Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution.

Former Member — Sun, 02 Aug 2015 15:40:43 GMT

Hi Ansh,

Can you please elaborate in more detail. On which object you have created your query(Info cube / DSO).

Arithmetic Overflow : This error come when number of digits increases. Can you please recheck your key figure info object length. The value coming is bigger than the specified length. Its a length issue,

so recheck again.

Regards

Rohit

Re: Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution.

roland_szajko — Sun, 02 Aug 2015 16:58:17 GMT

Hi Ansh

Try note:

1557321 - Numeric Overflow during standard BW processes

Roland

Re: Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution.

Former Member — Mon, 03 Aug 2015 02:43:02 GMT

Hi Rohit,

My query in on Multiprovider and Standard DSO.

I have tried to remove the key figure from the colum and executed but it is still same. How to find out this I have lots of keyfigure in my report so do I need to check one by one?

Thanks

Ansh

Re: Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution.

Former Member — Mon, 03 Aug 2015 02:55:40 GMT

Hi Roland,

I a trying to see the SAP Note 1557321 you provided but how to check this?

Please throw some light on this.

Thanks

Ansh

Re: Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution.

Loed — Mon, 03 Aug 2015 04:06:34 GMT

Hi,

Did you read the SOLUTION part in the note?

Regards,

Loed

Re: Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution.

Rushikesh_Yeole — Mon, 03 Aug 2015 04:13:00 GMT

I think first check ST22; It will give key figure name.

Try to display infor provider data using all keyfigures. Check if error occurs.

If it there, There may be changes in DSO structure level after locading data.

If not then check query design.

Re: Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution.

Former Member — Mon, 03 Aug 2015 04:39:00 GMT

Hi Ansh,

You will get the Key Figure info object name in ST22 T-Code

Run the DTP manually, if there will be an error, there also you may find the key figure name.

Regards

Rohit

Re: Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution.

former_member541575 — Mon, 03 Aug 2015 09:17:41 GMT

Hi,

Can you please check decimal places in additional properties of info objects.

please reduce the decimal places to 0.00 activate info objects, Re Load info providers and run query/report.

Just try this. it may be helpful.

Regards

Atul

Re: Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution.

Former Member — Mon, 03 Aug 2015 14:38:39 GMT

Hi Rohit,

I am getting this error in Date field. Also, tried to check in ST22 but as this error is not in KF so it doesnt give show anything.

Thanks

Ansh

Re: Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution.

Former Member — Mon, 03 Aug 2015 14:40:26 GMT

Hi Atul,

I have this error in date field my all KF are okay I checked, But because of the date field is not working and throw above mentioned error Arithmetic overflow.

Thanks

Ansh

Re: Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution.

Former Member — Tue, 04 Aug 2015 09:25:36 GMT

Hi Experts,

I am still looking for the solution please help me to resolve it.

I have read SAP Note 1557321. It is completely saying about KF and SQL.

In my problem Dates field and KF are not working together in query run time.

If i remove Dates field upon execution its works and vice versa.

I really need help.

Thanks

Ansh

Re: Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution.

Loed — Tue, 04 Aug 2015 09:27:53 GMT

Hi,

Why don't you open a SAP ticket? They will be your last resort if no one can answer your problem in the forum..

Regards,

Loed

Re: Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution.

Rushikesh_Yeole — Tue, 04 Aug 2015 11:09:38 GMT

I think before raising SAP ticket;

Please share ST 22 dump and query formulaes ragarding to particular characteristics Date.

Are you using char as key figure?

Have you displayed DSO data with this char? (Confirm wheather data is correct for Date in all rows)

Is it cutsomized char? If so check conversion routine/data type? Check with 0CALDAY

Re: Arithmetic Overflow error converting numeric to data type numeric in BEx upon execution.

roland_szajko — Tue, 04 Aug 2015 19:51:20 GMT

Hi Ansh

What do you mean under Dates field? Is this a characteristic or a key figure? If you use date as key figure ensure that the aggregation is either min or max. If its sum, then you have a problem, since the date type cannot be aggregated with SUM.

Also check the work process trace of the wp in which the query was running. The wp trace contains information about the specific SQL statement which could not be performed. Based on that, you can find the key figure which causes the overflow.

If you are using hana, the following notes could be helpful:

2080238

2078235

Roland