Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > SQL script message: Warning: Null value is eliminated by an aggregate or other SET operation in swdebugmaintenance.log

SQL script message: Warning: Null value is eliminated by an aggregate or other SET operation in swdebugmaintenance.log

Table of contents

Updated May 17, 2017

Overview

This article provides information on the following error in the Orion database maintenance log (swdebugmaintenance.log):

      2017-05-15 02:45:45,753 [1] INFO

   SolarWinds.Data.DatabaseMaintenance.StandardTableHandlerDAL

   - SQL script message:Warning: Null value is eliminated by an aggregate or other SET

   operation.

Environment

All Orion Platform products

Detail

The errors are normal and the purpose is informational. The number of these informational errors depend on the table data. The errors are triggered by a change in the database which needs to be updated by replacing the NULL values with 0 or set values.

 

 

Last modified

Tags

Classifications

Public