Event ID/Source search
Keyword searchExample: Windows cannot unload your registry file
Event ID: 22 Source: Analysis Service
|Source: Analysis Service|
File system error: The following error occurred during a file operation: The process cannot access the file because it is being used by another process. . (\\?\C:\Program Files\Microsoft SQL Server\MSSQL.4\OLAP\Data\Adventure Works DW.1.db\Dim Organization.0.dim\21.Organization Name.asstore).
|English: Request a translation of the event description in plain English.|
It turns out we had to start using Windows Low Fragmentation Heap instead of the OLAP Heap. Word has it that the OLAP Heap isn't an stable as Windows, especially if you have a large OLAP database (we're 500GB and I guess that's considered large).
This issue occurs when the Analysis Services service tries to delete a file during the final phase of the processing operation. However, the server cannot delete the file because the file is unexpectedly locked by another application. Frequently, the other application is antivirus software or backup software. See ME942121 for information on solving this problem.
|Private comment: Subscribers only. See example of private comment|
|Search: Google - Bing - Microsoft - Yahoo - EventID.Net Queue (0) - More links...|
Send comments or solutions
- Notify me when updated