Article ID: 272006 - View products that this article applies to.
This article was previously published under Q272006
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 11261 (PLATO_7x)
All databases and cubes are no longer visible in OLAP Manager and the Repository table, OLAPObjects, is empty. This only occurs on OLAP systems that have migrated the repository to SQL Server 7.0.
This occurs because the SELECT INTO/Bulk Copy option is not set for the repository database in SQL Server 7.0.
After the problem occurs, you can browse the OLAPObjects_bak table in the OLAPRep database to see if any records exist. If records do exist, inspect the LastUpdated column to see if the rows are current enough to restore. If the records are current copy the records into the OLAPObjects table.
If there are no records or the records are too old in the OLAPObjects_bak table, you must restore the repository database from a backup.
Microsoft has confirmed this to be a problem in SQL Server OLAP Services version 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server OLAP Services version 7.0. For information about how to download and install the latest SQL Server OLAP Services Service Pack, see the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?familyid=F62F45E9-24ED-4FA6-BD74-8A26606F96D8For more information, contact your primary support provider.
The repository in OLAP Services contains three tables:
This is not a problem on Microsoft SQL Server 2000 because the Select Into/Bulk Copy option is set by default.
NOTE: Microsoft strongly recommends that you set the SQL Insert/Bulk Copy option on the OLAP repository database immediately after you migrate the repository. Microsoft also strongly recommends that you backup the OLAP repository on a regular basis.
REFERENCESFor additional information, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/275050/EN-US/ )BUG: OLAP Databases Missing in OLAP Manager with Migrated Repository Database