Log Information During Delta Resource Membership Update: Incorrect number of columns returned from the query. 1 GUID column is expected
Last Updated January 03, 2019
When the Delta Resource Membership Update schedule runs one or more instances similar to the following informational log entry are seen:
Description: Invalid collection definition query found for collection 'Computers with Symantec Agent in Domain EPM' New Filter (c6d5cd0c-e82a-4099-9200-0b337fb27dcd~) . Incorrect number of columns returned from the query. 1 GUID column is expected, but 5 is found. Collection membership update will ignore the other columns and continue with the operation.
Depending on the complexity of the inclusion query used by filter it may not be corrected until the Complete Resource Membership Update schedule is run. Either way the condition works the resource update schedules causing them to take much longer than they normally would.
Symantec Management Platform 7.x, 8.x
The filter is composed of an embedded query which calles multiple columns in the "SELECT" statement. Filters are not reports. They are only concerned with receiving the GUID of the computer(s) qualified by the SQL query.
For example the following query, if used in a filter, would cause the previous log entry to be thrown:
SELECT vc.Guid, vc.Name, Domain, vc.[IP Address], vc.IsManaged FROM vComputer vc join Inv_AeX_AC_Client_Agent ca on ca._ResourceGuid = vc.Guid and ca.[Agent Name] = 'Altiris Agent' WHERE vc.Domain = 'EPM'
NOTE: That the "SELECT" statement calls five differnet columns: vc.Guid, vc.Name, Domain, vc.[IP Address], vc.IsManaged
Change the query to only pass in the GUID of the resource qualified by the rest of the SQL statement.
SELECT vc.Guid FROM vComputer vc join Inv_AeX_AC_Client_Agent ca on ca._ResourceGuid = vc.Guid and ca.[Agent Name] = 'Altiris Agent' WHERE vc.Domain = 'EPM'
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe