Error Opening Webi report (IES 10901)

[Benachraf87]

Hello Experts ,

Please i need your help , i have this error when i try to run my report .

The following database error occurred: [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting expression to data type money.. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF )

Thank you in advance

[omacoder]

Is the measure doing a calculation or conversion of the data?

If not, is the query using a view at the RDBMS that the view might be using a calculation or conversion?

It sounds like that's where the problem may be as this is a database error and not a Webi error.

[Benachraf87]

Hello Ayman ,

I use BO 4.2 SP4 .

BR

[ayman_salem]

This may be due to a large amount of data that you want to retrieve.

Try filtering the data in your query to get a small amount of data and see if the problem persists or not.

Which BI version do you have?

there was issue by BI "Arithmetic overflow error converting expression to data type int.", and it solved in SP6-P700, SP7-P100 and SP8

see KBA 2741620 - "Arithmetic overflow error converting expression to data type int."