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

book

Article ID: 180061

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

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

Environment
Notification Server 6.0.6074

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