When running a report, I get an error with "Arithmetic overflow error converting float to data type numeric" in it

Products

• IT Management Suite

Issue/Introduction

When running a report, you get an error with "Arithmetic overflow error converting float to data type numeric"

Environment

ITMS 7.x

Cause

When a report is written with the decimal (precision, scale) SQL function where the precision parameter is too small to fit the data supplied, you will get the error "Arithmetic overflow error converting float to data type numeric"

Resolution

Adjust the precision upward to fit the data.

<-- precision -->
XXXXXX.YYYYY      decimal ( 11, 5)  or  numeric (11, 5)
               < scale>


Precision is the total amount places on the left and right of the decimal point. (example: XXXXXX(6) + YYYYY(5) = 11 )
Scale is the total amount places on the right of the decimal point. (example: YYYYY = 5 )

The format of the function: decimal (precision, scale)
1.) Start by upping the precision from 7 to 9. decimal ( 7, 2)  to decimal ( 9, 2)
2.) This may also reflect in the numeric (precision, scale) SQL function as well. So please check the report SQL.

Some of the default reports that may need to be adjusted

·        Computer Usage (month to date)

·        Last N Logins

·        Memory Configuration by Computer