Microsoft KB Archive/870954

= BUG: You may experience periodic failures of Data Transformation Services in SQL Server 2000 when you build data cubes with BizTalk Server 2004 data =

Article ID: 870954

Article Last Modified on 1/5/2005

-

APPLIES TO


 * Microsoft BizTalk Server 2004 Developer Edition
 * Microsoft BizTalk Server 2004 Enterprise Edition
 * Microsoft BizTalk Server 2004 Partner Edition
 * Microsoft BizTalk Server 2004 Standard Edition

-





SYMPTOMS
When you build data cubes with your Microsoft BizTalk Server 2004 data and the activity increases in your Business Activity Monitoring (BAM) databases, you may experience periodic failures of Data Transformation Services in Microsoft SQL Server 2000.



CAUSE
This problem occurs when the following conditions are true:
 * SQL Server 2000 Analysis Services Service Pack 3 is installed.
 * Analysis Services processes multiple cubes or partitions in parallel.



RESOLUTION
To fix this problem, follow the steps that are outlined in the following SQL Server 2000 Knowledge Base article:

814414 FIX: Error messages may occur during parallel processing of partitions after you apply SQL Server 2000 Analysis Services SP3



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbtshoot kbbug kbnofix kbbtsbam KB870954

-

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

© Microsoft Corporation. All rights reserved.