Microsoft KB Archive/823871

= BUG: Error Message &quot;Either BOF or EOF is True, or the current record has been deleted.&quot; Occurs When You Archive an OLAP Database =

Article ID: 823871

Article Last Modified on 5/31/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-





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  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('')  Migrate the Analysis Services repository to the database whose collation is case-insensitive.</ol>

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

<div class="status_section">

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

<div class="moreinformation_section">

MORE INFORMATION
You may see the behavior that is mentioned in the &quot;Symptoms&quot; 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

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

< >\Program Files\Microsoft Analysis Services\Samples
 * 1) Archive the FoodMart 2000 database. You might receive the error message that is mentioned in the &quot;Symptoms&quot; section of this article.

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

<div class="references_section">