RSDD_MSSQL_CUBEANALYZE table size too large
[alter table mssql] [Arithmetic] [CX_SY_NATIVE_SQL_ERROR] [DBIF_DSQL2_SQL_ERROR] [GET_TOPTABLIST] [mssql create table] [mssql table schema] [overflow] [RSDD_MSSQL_CUBEANALYZE] [too large]
Symptom
RSDD_MSSQL_CUBEANALYZE shows a table size which is much larger than the actual size.
You may also experience program terminations in transaction ST22 with the error text: “Arithmetic overflow error converting expression to data type int”.
This error only occurs on an SAP NetWeaver 7.0 installed on SQL Server 2008. If it is installed on SQL Server 2005 or SQL Server 2000 you will not get this error.
Other terms
RSDD_MSSQL_CUBEANALYZE, Arithmetic overflow, DBIF_DSQL2_SQL_ERROR, CX_SY_NATIVE_SQL_ERROR, RSDD_MSSQL_CUBEANALYZE, GET_TOPTABLIST
Reason and Prerequisites
The table size displayed is the actual size multiplied by the number of partitions.
Solution
Apply this Note to correct the code.
![[del.icio.us]](http://images.del.icio.us/static/img/delicious.small.gif){kind=small}