Home > Forum > General > OLAPActualization Error

OLAPActualization Error
0

MVP

Hello,

In the Local Service Status I see the following error (see attached image). I'm copying details below. Does anyone have an idea what this is about and how to fix it?

- - - ERROR DETAILS START - - -
OLAPActualization BPS_Content Error: Arithmetic overflow error converting expression to data type int.
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.
Warning: Null value is eliminated by an aggregate or other SET operation.
The statement has been terminated.
Warning: Null value is eliminated by an aggregate or other SET operation.
Warning: Null value is eliminated by an aggregate or other SET operation.
Warning: Null value is eliminated by an aggregate or other SET operation.
Category: OLAP
Role: OLAP
Microsoft.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type int.
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.
Warning: Null value is eliminated by an aggregate or other SET operation.
The statement has been terminated.
Warning: Null value is eliminated by an aggregate or other SET operation.
Warning: Null value is eliminated by an aggregate or other SET operation.
Warning: Null value is eliminated by an aggregate or other SET operation.
...
...
...
- - - ERROR DETAILS END - - -

MVP
In reply to: Krystian Golik

Hi Martin,
Check the database where the error occurs to see if someone has entered a numerical value greater than (2,147,483,647) in the WFD_Attext1-80 fields or in the DET_ATT1-40 item list fields.

Hi Krystian,

Thanks for your reply. Yes, there are approximately 800,000 rows in the database that match the criteria. I don’t see how this could be an issue. The text fields contain any number of digits (e.g., work order numbers, bank account numbers, etc.). However, I’m curious to know the solution to this error.

Thanks,
Martin