Deleting a package in Microsoft Application Virtualization fails with Error code 0000B005

Article ID: 2760974
Expand all | Collapse all

Symptoms

When a Microsoft Application Virtualization (App-V) administrator attempts to delete an old App-V package on an App-V 4.5 SP2 Management server, the operation fails with the following error:

Unexpected error occurred.

Unable to delete the specified application.  Please report the following error code to your system administrator.
Error code: 0000B005.

Cause

This can occur if the Application_Usage table is too large (e.g. has millions of rows) and there is an Application record in the Application_Usage table associated to the Application ID of the App-V Package that is being deleted.

Resolution

To resolve this issue, truncate the Application_Usage table or delete the specific Application ID records from the Application_Usage table for the application you wish to delete.

First, check the Message_Log and Application_usage tables to determine if they are too large (have millions of rows). To do this, cut and paste the following script into a SQL query window focused on the AppVirt DB:

select count(*) from MESSAGE_LOG
go
select count(*) from APPLICATION_USAGE
go

If millions of rows are found in either table, backup the App-V database and truncate the tables using the following SQL script focused on the App-V Database. Please be aware that this will remove all data from both tables.

truncate table MESSAGE_LOG
go

truncate table APPLICATION_USAGE
go


More information

Troubleshooting SoftGrid Database Growth Issues: http://blogs.technet.com/b/appv/archive/2008/08/04/troubleshooting-softgrid-database-growth-issues.aspx

A Complete Guide to SQL 2008 App-V Database Migration: http://blogs.technet.com/b/appv/archive/2012/02/08/a-complete-guide-to-sql-2008-app-v-database-migration.aspx 
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2760974 - Last Review: December 4, 2012 - Revision: 5.0
Keywords: 
KB2760974

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com