Dynamic Group Update Failed error in the Logger Health Messages Log

Feb 23, 2021
Knowledge

Title

URL Name

Dynamic-Group-Update-Failed-error-in-the-Logger-Health-Messages-Log

Article Number

000191556

Environment

Question/Problem Description

Customers may observe the following error message in the Logger Health Messages in WUG2017

Dynamic Group Update Failed: Name: "Dynamic Group Name", ID: 99, Message: Column name or number of supplied values does not match table definition., Error: 213

Steps to Reproduce

Clarifying Information

Error Message

Defect Number

Enhancement Number

Cause

Resolution

This message is seen because the SQL query used to create the Dynamic Group contains more than one column in it's select clause
When creating Dynamic Groups, only the nDeviceID column needs to be included in the select clause
All other columns, even those included in the where clause, should be omitted
Additionally, the statement should include bRemoved = 0 as part of the where clause
Below are some examples:

-- Example of a good query
select distinct nDeviceID
from Device
where bRemoved = 0
and sDisplayName like 'Win-%'

-- This query will generate errors in the Logger Health Messages Log, because it contains both nDeviceID and sDisplayName in the select clause
select nDeviceID, sDisplayName
from Device
where bRemoved = 0
and sDisplayName like 'Win-%'

-- This query may show devices that have previously been deleted, because it does not include bRemoved = 0 in the where clause
select distinct nDeviceID
from Device
where sSnmpOid like '1.3.6.1.4.1.9.%'

Workaround

Notes

Keyword Phrase

Last Modified Date

2/23/2021 4:21 PM

Dynamic Group Update Failed error in the Logger Health Messages Log

Files(0)

Was this article helpful?

Was this article helpful?

Dynamic Group Update Failed error in the Logger Health Messages Log

Information

Related Articles