Error: "Arithmetic overflow error converting float to data type numeric" when running a report

Products

• IT Management Suite

Issue/Introduction

When running a report, you get the following error:

Arithmetic overflow error converting float to data type numeric

Environment

ITMS 8.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 see the error "Arithmetic overflow error converting float to data type numeric"

Resolution

Adjust the precision upward to fit the data as shown here:

<-- 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 are:

• Computer Usage (month to date)
• Last N Logins
• Memory Configuration by Computer