FIX: Analysis Services DTS Task Gets Timeout Error During Incremental Update (293318)

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.