Article ID: 324204 - Last Review: October 25, 2006 - Revision: 1.5 SMS: Collections That Are Based on Complex Queries Do Not Update
This article was previously published under Q324204 On This PageSYMPTOMS
The Systems Management Server (SMS) Collection Evaluator component (SMS_COLLECTION_EVALUATOR) may time out when it tries to refresh a collection that is based on one or more SMS queries. If you experience this problem, the following entries or entries that are similar to these entries may appear in the Colleval.log file:
**********~Processing file A01001F3.UDC Update flags for collection: 0xF, ChangeCount=1 Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... Waiting to recover from SQL Error... CCollectionSource_SQL::RefreshResults - query timed out. Cmd = insert into Temp1__RES_COLL_A01001F3 (MachineID,ArchitectureKey,Name,SMSID,Domain ,IsClient) select all... (remainder of query removed) CStatusReporter::Report() ERROR: Caller passed NULL for pSM. Could not refresh results for collection A01001F3. CAUSE
The hotfix for the following Microsoft Knowledge Base article changed the Collection Evaluator timeout from 18 hours to 18 minutes:
317337
(http://support.microsoft.com/kb/317337/EN-US/
)
SMS: Executive Services that Interact with SQL Appear to Hang
Collections that are based on complex queries or queries that connect to extremely large tables may take over 18 minutes to finish. When this occurs, the collection refresh does not work, and you receive the symptoms that are listed in the "Symptoms" section of this article.
RESOLUTION A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, submit a request to Microsoft Customer Service and Support to obtain the hotfix. Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site: http://support.microsoft.com/contactus/?ws=support
(http://support.microsoft.com/contactus/?ws=support)
Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.
The English-language version of this fix for SMS 2.0 Service Pack 3 (SP3) sites should have the following file attributes or later:
Date Time Version Size File name Platform --------------------------------------------------------------------- 01-Mar-2001 21:45 2.0.1493.3269 2,436,880 Basesvr.dll Alpha 01-Mar-2001 21:00 2.0.1493.3260 811,792 Baseutil.dll Alpha 01-Mar-2001 10:30 2.0.1493.3143 126,224 Cmprov.dll Alpha 01-Mar-2001 19:50 2.0.1493.3246 145,680 Colleval.dll Alpha 01-Mar-2001 13:30 2.0.1493.3182 171,792 Compmgr.exe Alpha 01-Mar-2001 21:40 2.0.1493.3268 76,048 Replmgr.dll Alpha 01-Mar-2001 19:40 2.0.1493.3244 11,803,408 Smsprov.dll Alpha 10-May-2002 23:51 1,193 Update.sql 01-Mar-2001 21:45 2.0.1493.3269 1,583,008 Basesvr.dll INTEL 01-Mar-2001 21:00 2.0.1493.3260 527,808 Baseutil.dll INTEL 01-Mar-2001 10:30 2.0.1493.3143 81,040 Cmprov.dll INTEL 01-Mar-2001 19:50 2.0.1493.3246 91,024 Colleval.dll INTEL 01-Mar-2001 13:30 2.0.1493.3182 121,440 Compmgr.exe INTEL 01-Mar-2001 21:40 2.0.1493.3268 46,944 Replmgr.dll INTEL 01-Mar-2001 19:40 2.0.1493.3244 4,205,008 Smsprov.dll INTEL After you apply the fix from Q324204, the Collection Evaluator timeout is set to 6 hours. If you have installed any of the following hotfixes and have collections that take longer than 18 minutes to update, you may want to install the hotfix that is documented in this article. Besides increasing the timeout, Q324204 also fixes all the issues that are documented in the following articles in the Microsoft Knowledge Base: 316258
(http://support.microsoft.com/kb/316258/EN-US/
)
Problems Connecting to SMS Provider Without Impersonation
317337
(http://support.microsoft.com/kb/317337/EN-US/
)
SMS: Executive Services that Interact with SQL Appear to Hang
303397
(http://support.microsoft.com/kb/303397/EN-US/
)
Cannot View Subcollections on Child Sites
320692
(http://support.microsoft.com/kb/320692/EN-US/
)
SMS: Transaction History Files Increase in Size
245579
(http://support.microsoft.com/kb/245579/EN-US/
)
SMS: Secondary Site Does Not Decompress Package
319189
(http://support.microsoft.com/kb/319189/EN-US/
)
SMS: Distribution Manager Continuously Processes .pkg Files
323614
(http://support.microsoft.com/kb/323614/EN-US/
)
SMS: Increasing Number Of Zero-Byte Files in the Replmgr.box/Incoming Folder
NOTE: The individual hotfixes for these Microsoft Knowledge Base articles are no longer available from Microsoft because they are all superceeded by the hotfix for Q324204.
The hotfix that is described in this article is included in the Hotfix Rollup Package (HRP) for customers who have installed SMS 2.0 Service Pack 4 (SP4).Note that the timeout problem that is described in Microsoft Knowledge Base article Q324204 is fixed in the HRP. The fixes for Q316258, Q317337, Q303397, and Q320692 are also included in the HRP. However, the fixes for Q245579, Q319189, and Q323614 are not included in the HRP. WORKAROUND
Do not create collections that are based on queries that take more than 18 minutes to finish.
STATUS
Microsoft has confirmed this to be a problem in Systems Management Server version 2.0. MORE INFORMATION
To install the hotfix, use the appropriate method.
Use the Hotfix InstallerNOTE: This method is only for Intel-based computers.
Manual InstallationManually Update the SMS Site Server
Additional Installation InformationTo update remote site computers such as SMS administrator consoles, an SMS SQL monitor, or an SMS provider that is not located on the site server, use the appropriate method.Manually Updating a Remote SMS Administrator ConsoleNOTE: Before you implement this update on your SMS administrator console, you must install it on the SMS site servers in your environment.
Updating a Remote SMS Provider ServerNOTE: Before you implement this update on your SMS provider server, you must install it on the SMS site servers in your environment.
Manually Updating a Remote SMS SQL Monitor ServerNOTE: Before you implement this update on your SMS site database server, you must install it on the SMS site servers in your environment.
| Article Translations
|
| United States | Change | | | All Microsoft Sites |
Back to the top
|
