Network Management

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

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.

First published date

10/19/2018 6:04 PM

Last published date

3/3/2022 10:32 AM

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.

Product section

Orion Platform

Cause

n/a

Resolution

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.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.