Microsoft KB Archive/941153

= The proactive caching feature does not start on some partitions or on some dimensions after you start the SQL Server 2005 Analysis Services service =

Article ID: 941153

Article Last Modified on 8/27/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Analysis Services

-



SYMPTOMS
After you start the Microsoft SQL Server 2005 Analysis Services service, the proactive caching feature does not start on some partitions or on some dimensions. This behavior occurs after you enable the proactive caching feature. This behavior occurs even if you have specified an interval to update the proactive cache periodically.



CAUSE
This behavior occurs because the proactive caching feature does not start until the first time that you access the metadata objects of a partition or of a dimension. This behavior prevents SQL Server 2005 Analysis Services from loading the database that you do not use.



WORKAROUND
To work around this behavior, follow these steps:  Open SQL Server Management Studio, and then connect to the instance of SQL Server 2005 Analysis Services. Open a new Analysis Services XMLA Query window.  Run one of the following XMLA queries:

Query 1  DISCOVER_SCHEMA_ROWSETS     <PropertyList/> </Properties> </Discover> Query 2 <Discover xmlns=&quot;urn:schemas-microsoft-com:xml-analysis&quot;> DISCOVER_XML_METADATA</RequestType>  <RestrictionList/> </Restrictions> <Properties> <PropertyList/> </Properties> </Discover> </li></ol>

After you run one of the XMLA queries, the proactive caching feature starts on the partitions and on the dimensions.

<div class="status_section">

STATUS
This behavior is by design.

<div class="moreinformation_section">

MORE INFORMATION
After the proactive caching feature starts, SQL Server 2005 Analysis Services caches the objects based on the interval that you specify.

Keywords: kbsql2005bi kbsql2005as kbexpertiseadvanced kbtshoot kbprb KB941153

-

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

© Microsoft Corporation. All rights reserved.