Microsoft KB Archive/323253

= SSABI-PRB: Master Delete Cannot Completely Remove Cube Partitions =

Article ID: 323253

Article Last Modified on 2/18/2003

-

APPLIES TO


 * Microsoft Solution Offering - Microsoft SQL Server Accelerator for Business Intelligence

-



This article was previously published under Q323253



SYMPTOMS
When you use the Master Delete (Master_delete.dts) package to delete all records in all tables in the Subject Matter database and cube partition in Analysis Services, the following error may be seen in the Master Delete log file:

Error = -2147220482 (800403FE)

Error Source = Microsoft JET Database Engine

Error Description: Could not update; currently locked by user 'Admin' on machine



CAUSE
This problem is caused by the poor locking capability of Jet driver when Analysis Services Repository file format is in Microsoft Access.



RESOLUTION
To resolve this issue, migrate the Analysis Services Repository to SQL Server 2000 and then use the Analysis Services native format. For more information about migrating to SQL Server 2000, see &quot;Migrating Analysis Services Repositories&quot; in Books Online.

Additional query words: Master_Delete

Keywords: kbprb KB323253

-

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

© Microsoft Corporation. All rights reserved.