This article was previously published under Q293318
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 11406, 12157 (plato7x)
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
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.
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 theMicrosoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
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 126.96.36.1997 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.
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.