BUG: Analysis Manager Stops Responding During Restore on Remote Server (309423)


The information in this article 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:
  1. Start the Registry Editor (Regedt32.exe).
  2. Locate, and the click the following key in the registry:

    HKEY_LOCAL_MACHINE\Software\Microsoft\OLAP Server

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

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

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

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

  5. 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$

  6. Quit the Registry Editor.

STATUS

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

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 Server Connection Info 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.
Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kbBug kbpending KB309423
©2004 Microsoft Corporation. All rights reserved.