Microsoft KB Archive/293318

= FIX: Analysis Services DTS Task Gets Timeout Error During Incremental Update =

Article ID: 293318

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q293318



BUG #: 11406, 12157 (plato7x)



SYMPTOMS
When performing an incremental update on an Analysis Services cube using the Analysis Services DTS Processing Task, the incremental update may fail with a timeout error if the fact table is large.

The DTS Package log will show the following error information:

Step Error Source: Microsoft OLE DB Provider for SQL Server

Step Error Description:Timeout expired

Step Error code: 80040E31 Step Error Help File:

Step Error Help Context ID:1000440



CAUSE
The incremental update process creates a temporary partition to hold the new data for the cube. This temporary partition is then populated with the new data and merged with the existing partition for the cube. During the creation of the temporary partition, the DTS task attempts to get a record count from the fact table for the cube. If this count is not returned within 30 seconds, the connection returns a timeout error and the DTS task is unable to continue.

Because the partition created by the DTS Processing Task is temporary and is removed after being merged with the existing partition, the count of the fact table is not necessary and has been removed from the partition creation sequence.



RESOLUTION
To resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

Hotfix
NOTE: The following hotfix was created prior to Microsoft SQL Server 2000 Service Pack 1.

The English version of this fix should have the following file attributes or later:   Date        Time    Version     Size      File name

3/14/2001  9:01p   8.0.0.267   368,716   Msmdtsp.dll NOTE: Due to file dependencies, the most recent hotfix or feature that contains the above files may also contain additional files.



STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0. This problem was first corrected in the Analysis Services Components of Microsoft SQL Server 2000 Service Pack 1.

Additional query words: DTS Timeout OLAP

Keywords: kbbug kbfix kbqfe kbsqlserv2000sp1fix KB293318

-

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

© Microsoft Corporation. All rights reserved.