Select the product you need help with

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

Article ID: 2760974

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.

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

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

Back to the top | Give Feedback

More information

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

(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

(http://blogs.technet.com/b/appv/archive/2012/02/08/a-complete-guide-to-sql-2008-app-v-database-migration.aspx)

Back to the top | Give Feedback

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

(http://go.microsoft.com/fwlink/?LinkId=151500)

for other considerations.

Back to the top | Give Feedback