Microsoft KB Archive/309423

= BUG: Analysis Manager Stops Responding During Restore on Remote Server =

Article ID: 309423

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q309423



BUG #: 12658 (Plato7x)



SYMPTOMS
When you try to restore an Analysis Services archive on a remote Analysis Services server, the restore operation stops responding when it tries to update Decision Support Objects (DSO).



CAUSE
Analysis Manager is installed on a computer used for the remote administration of Analysis Services, which does not also have Analysis Services installed.



WORKAROUND
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To work around the problem, use these steps:  Start the Registry Editor (Regedt32.exe). Locate, and the click the following key in the registry:

HKEY_LOCAL_MACHINE\Software\Microsoft\OLAP Server

 On the Edit menu, click Add Key, and then add the following registry key:

HKEY_LOCAL_MACHINE\Software\Microsoft\OLAP Server\Server Connection Info

 Locate, and then click the following key in the registry:

HKEY_LOCAL_MACHINE\Software\Microsoft\OLAP Server\Server Connection Info

 On the Edit menu, click Add Value, and then add the following registry value:

Value name: Remote Locks Directory

Data type: REG_SZ

String: MSOLAPRepository$

 Quit the Registry Editor.</li></ol>

<div class="status_section">

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

<div class="moreinformation_section">

MORE INFORMATION
When you install Analysis Manager on a computer used for the remote administration of an Analysis Services server, without installing Analysis Server, the  sub-key of the HKEY_LOCAL_MACHINE\Software\Microsoft\OLAP Server registry key is not created.

For DSO to communicate with other instances about changes to the metadata, the Restore utility examines a timestamp on a file stored in the MSOLAPRepository$ share on the server. For remote servers, the Restore utility checks the local registry to obtain the name of the share that contains the file used to communicate changes to the metadata. Because the registry entry that specifies the location of the locks share does not exist, Analysis Manager cannot update the file and the Restore utility stops responding.

Additional query words: OLAP

Keywords: kbbug kbpending KB309423

-

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

© Microsoft Corporation. All rights reserved.