Microsoft KB Archive/278325

= BUG: OLAP Server Stops Responding When Data Files are Corrupted =

Article ID: 278325

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft SQL Server OLAP Services

-



This article was previously published under Q278325



BUG #: 11387 (plato7x)



SYMPTOMS
The OLAP server stops responding (hangs) in some situations if one or more data files are corrupted. Sometimes this occurs when OLAP Services is in a &quot;Starting&quot; state rather than a &quot;Started&quot; or &quot;Stopped&quot; state. Even if the service starts, the OLAP server does not accept connections from OLAP Manager, the MDX sample application or any other applications. The following error message occurs in the OLAP Manager:

Cannot open connection to OLAP server 'ServerName'

This error message occurs with the MDX sample application:

Unable to open connection. OLAP server error: The operation requested failed due to network problems.

The OLAP Server uses two TCP ports:
 * 2393

-and-


 * 2394

Typing in the following netstat command:

netstat -a

shows port 2393 to be in a SYN_SENT state under these conditions.  TCP    wsweceprocdb1t:3787    localhost:2393         SYN_SENT



WORKAROUND
As a work around:
 * 1) Stop the OLAP server.
 * 2) Remove or rename the &quot;..\Olap Services\Data\DatabaseName.odb&quot; file, and then start the OLAP server again. You should now be able to connect from OLAP Manager and other OLAP applications. If this method does not work, then you might consider reprocessing the OLAP databases after you remove the .odb files from the Data folder.

To test which database may have a corrupted data file, rename the data directory for the specific database that is in the \Program Files\Microsoft Analysis Services\Data folder. For example, in the Data folder there is a directory named FoodMart 2000. To test if the FoodMart 2000 database has a corrupted file, rename the directory to &quot;testFoodMart 2000&quot;, stop and then restart the service. The OLAP Service creates a new but empty directory named FoodMart 2000. If the service starts successfully you know that the FoodMart 2000 database has a corrupted file and must be reprocessed.



STATUS
Microsoft has confirmed that this is a problem in SQL Server OLAP Services version 7.0 and Microsoft SQL Server 2000 Analysis Services version 8.0.

Keywords: kbbug kbpending KB278325

-

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

© Microsoft Corporation. All rights reserved.