SQL 8115 : Arithmetic overflow error when running index analysis

[former_member211576]

Hi experts,

  I got an error: "SQL 8115 : Arithmetic overflow error converting float to data type numeric

row 1, col -1 [WP3 ] [sap_index_recommend:BUILD_N_E", please help.

[Former Member]

Hi Dennis,

do you have an S-User and the possibility to open an R/3 or WTS service connection for SAP? If so, it makes sense to open an incident for it with SAP.

Usually this error comes up when the underlying monitoring procedure has to handle higher numbers than expected and then the datatype in use is overflowing - I consider such an error a bug if the stored procedure which causes this is an SAP stored procedure. In your case it is.

Of course, with access to the system, one can trace back the problem to its root and _could_ adjust the stored procedure - but as it's delivered by SAP you shouldn't do so yourself even if you're able to identify the root cause.

Regards,

Beate