Failed to execute delta collection update for filter full update will run instead. The multi-part identifier could not be bound.

Products

• Client Management Suite

Issue/Introduction

While reviewing your SMP logs you may notice a blue warning stating the following:

Failed to execute delta collection update for 'Filter Name Here', full update will run instead.
The multi-part identifier "#vComputerResource.Guid" could not be bound.
   [SqlException @ System.Data.dll]
   at System.Data.SqlClient.SqlConnection.OnError(SqlException, bool, Action<Action>)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject, bool, bool)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior, SqlCommand, SqlDataReader, BulkCopySimpleResultSet, TdsParserStateObject, out bool)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader, RunBehavior, string, bool, bool, bool)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior, RunBehavior, bool, bool, int, out Task, bool, bool, SqlDataReader, bool)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior, RunBehavior, bool, string, TaskCompletionSource<object>, int, out Task, out bool, bool, bool)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior, RunBehavior, bool, string)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at Altiris.NS.DataAccessLayer.DatabaseAbilities.ExecuteScalar(string, string, object)
   at Altiris.NS.StandardItems.Collection.NSDataSrcBasedResourceCollection.DeltaUpdateMembership()

SQL Exception details: code=4104, class=16, hr=0x80131904, line=10

Environment

ITMS 8.x

Cause

SQL alias not being used

Resolution

You will need to review the SQL logic being use for the filter mentioned in the warning.  In particularly if you look at the warning it will you show you the view or table where the problem is.  In this example vComputerResource.  Update the SQL to use aliases for the view and tables in your SQL query.  For example:

Query causing warning:

left join vComputerResource
on vComputerResource.Guid = Inv_AeX_AC_Identification._ResourceGuid

Updated query fixing the warning:

left join vComputerResource cr
on cr.Guid = Inv_AeX_AC_Identification._ResourceGuid