The SMS Collection Evaluator component stops the evaluation of the query of a collection in SMS 2003 (905840)


The information in this article applies to:

  • Microsoft Systems Management Server 2003

SYMPTOMS

The SMS Collection Evaluator component stops the evaluation of the query of a collection. Additionally, the following error message is logged in the Colleval.log file:
SQL>>>insert into #CollTemp (MachineID,ArchitectureKey,Name,SMSID,Domain ,IsClient) select all SMS_R_System1.ItemKey,SMS_R_System.DiscArchKey,SMS_R_System.Name0,SMS_R_System.SMS_Unique_Identifier0,SMS_R_System.Resource_Domain_OR_Workgr0,SMS_R_System.Client0 from System_DISC AS SMS_R_System INNER JOIN Computer_System_DATA AS SMS_G_System_COMPUTER_SYSTEM ON SMS_G_System_COMPUTER_SYSTEM.MachineID = SMS_R_System.ItemKey where SMS_G_System_COMPUTER_SYSTEM.Domain0 = "B35-D2K3-1"
*** insert into #CollTemp (MachineID,ArchitectureKey,Name,SMSID,Domain ,IsClient) select all SMS_R_System1.ItemKey,SMS_R_System.DiscArchKey,SMS_R_System.Name0,SMS_R_System.SMS_Unique_Identifier0,SMS_R_System.Resource_Domain_OR_Workgr0,SMS_R_System.Client0 from System_DISC AS SMS_R_System INNER JOIN Computer_System_DATA AS SMS_G_System_COMPUTER_SYSTEM ON SMS_G_System_COMPUTER_SYSTEM.MachineID = SMS_R_System.ItemKey where SMS_G_System_COMPUTER_SYSTEM.Domain0 = "B35-D2K3-1"
*** [42000][107][Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'SMS_R_System1' does not match with a table name or alias name used in the query.
CCollectionSource_SQL::RefreshResults - could not execute SQL cmd insert into #CollTemp (MachineID,ArchitectureKey,Name,SMSID,Domain ,IsClient) select all SMS_R_System1.ItemKey,SMS_R_System.DiscArchKey,SMS_R_System.Name0,SMS_R_System.SMS_Unique_Identifier0,SMS_R_System.Resource_Domain_OR_Workgr0,SMS_R_System.Client0 from System_DISC AS SMS_R_System INNER JOIN Computer_System_DATA AS SMS_G_System_COMPUTER_SYSTEM ON SMS_G_System_COMPUTER_SYSTEM.MachineID = SMS_R_System.ItemKey where SMS_G_System_COMPUTER_SYSTEM.Domain0 = "B35-D2K3-1"
SQL>>>>> Done.
SQL>>>drop table #CollTemp
SQL>>>>> Done.
Could not refresh results for collection C0100018.
This symptom occurs if the following conditions are true:
  • The collection contains an SQL syntax error 107.
  • The collection is based on a query.
  • The SMS Collection Evaluator component encounters an error when it tries to evaluate the collection members.

CAUSE

This problem occurs because the SQL syntax error 107 is not interpreted as an SQL syntax error in the SMS Collection Evaluator component. However, the SQL syntax error 107 is reported by Microsoft SQL Server when SQL Server tries to run the query of a collection.

WORKAROUND

To work around this problem, correct the SQL syntax error 107 in the query of the collection.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about how to troubleshoot the SQL syntax error 107, visit the following Microsoft site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_1nsn.asp

Modification Type:MinorLast Reviewed:9/9/2005
Keywords:kbtshoot kberrmsg kbprb KB905840 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.