Microsoft KB Archive/905840

= The SMS Collection Evaluator component stops the evaluation of the query of a collection in SMS 2003 =

Article ID: 905840

Article Last Modified on 1/30/2007

-

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 = &quot;B35-D2K3-1&quot;


 * 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 = &quot;B35-D2K3-1&quot;


 * [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 = &quot;B35-D2K3-1&quot;

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 &quot;Applies to&quot; section.



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

http://msdn2.microsoft.com/en-us/library/aa258709(SQL.80).aspx

Additional query words: CollEval SMS2003

Keywords: kbtshoot kberrmsg kbprb KB905840

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.