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

[Former Member]

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

[Rushikesh_Yeole]

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.

[former_member541575]

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

[Former Member]

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