BUG: Error Message "Either BOF or EOF is True, or the current record has been deleted." Occurs When You Archive an OLAP Database (823871)

The information in this article applies to:

Microsoft SQL Server 2000 Analysis Services

Plato7x:13941

SYMPTOMS

When your Analysis Services repository is in a metadata format and you try to archive the OLAP database, the archive process might fail and you receive the following error message:

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

You may also notice that the Server table in the SQL Server 2000 database, where the repository is migrated, does not have any records.

WORKAROUND

To work around this problem, insert a <SERVER RepositoryVersion="9"></SERVER> value in the Server table, and then migrate the repository to the SQL Server database whose collation is case-insensitive. To do so, follow these steps:

Start SQL Query Analyzer.
Connect to the SQL Server database where the Analysis Server repository was migrated.

Run the following command in Query Analyzer:

INSERT INTO Server values('<SERVER RepositoryVersion="9"></SERVER>')

Migrate the Analysis Services repository to the database whose collation is case-insensitive.

Note You must make sure that the collation of the database where the Analysis Services repository is migrated to is case-insensitive.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

You may see the behavior that is mentioned in the "Symptoms" section when the repository is migrated to a SQL Server 2000 database and the collation of the database is case-sensitive.

Steps to Reproduce the Behavior

Connect to SQL Server 2000 and create a new database that has a Latin1_General_BIN collation.
Start Analysis Manager.
Migrate your Analysis Services repository to the metadata format in the new database you created in step 1.
Restore the FoodMart 2000 database from the Samples folder. By default, the location of the Foodmart2000.cab file is:

<drive>\Program Files\Microsoft Analysis Services\Samples
Archive the FoodMart 2000 database. You might receive the error message that is mentioned in the "Symptoms" section of this article.

Note When you try to migrate the repository, you might receive the error message that is mentioned in the "Symptoms" section of this article.

REFERENCES

For more information about migrating Analysis Services repositories, visit the following Microsoft Web sites:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/agregserver_23hv.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/aghtconfig_6w2s.asp

Modification Type:	Major	Last Reviewed:	9/8/2003
Keywords:	kbMigration kberrmsg kbbug KB823871 kbAudDeveloper