Home > App-V > App-V: Certain Database tables not updating or empty post upgrade from 4.1

App-V: Certain Database tables not updating or empty post upgrade from 4.1


You may notice certain tables like ACTIVE_APPLICATIONS, APPLICATION_CAPABILITIES, or DISCONNECTED_EXPIRIES either not updating with information, empty, or missing when looking at an App-V datastore directly in SQL Management Studio or querying through T-SQL. 

The likely scenario is that the database was updated from Softgrid 4.1. During the upgrade process for whatever reason, the tables, views, and/or stored procedures that were deprectaed for App-V Server 4.5 were left in the database.

The following tables are deprecated as of 4.5. They may still appear in a database that has been upgrade from a pre-4.5 release, but they are no longer actively updated or accessed.

ACTIVE_APPLICATIONS
APPLICATION_CAPABILITIES
APPLICATION_EXTENSIONS
DISCONNECTED_EXPIRIES
MANAGEMENT_SERVERS
SOFTGRID_USERS

Deprecated Views

The following views are deprecated as of 4.5. They may still appear in a database that has been upgrade from a pre-4.5 release, but they are no longer actively updated or accessed.

VW_MANAGEMENT_SERVERS

Deprecated Procedures

The following procedures are deprecated as of 4.5. They may still appear in a database that has been upgrade from a pre-4.5 release, but they are no longer actively updated or accessed.

sp_SFTrpt_systemusagebyuser
sp_SFTrpt_usergroupusage
sp_SFTsetdbaccess

No action is needed. Manual deletion of these tables, views, and stored procedures can be done for the purpose of clarity although the fact they remain should have no bearing on the operation of the server or data store.
Categories: App-V Tags: , , , ,
  1. Stephane
    August 26, 2011 at 11:48 am

    You’re wrong, if you delete or rename APPLICATION_CAPABILITIES, you cannot add any groups from «Access Permissions» in any application.

  2. August 29, 2011 at 9:01 am

    ACTIVE_APPLICATIOSN should in fact be deprecated as of 4.5. I will follow up to see if this in fact reproducible on our end.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: