locked
Application Virtualization Management Console : Permissions Error 0000B004 RRS feed

  • Question

  • Hello,

    We started to get a serious issue on the Management Console.

    We cannot add any group in «Access Permissions» in any application. However, we can delete them.

    Here is the showed code:

     

    Unexpected error occurred.

    Unabled to modify the specified application. Please report the following error code to your system administrator.

    error Code: 0000B004

     

    I've checked the sftmmc.log, this is was I found out.

     


    25/08/2011 11:58:30 AM http://serveurappv/
    ManagementConsole.MCException: Invalid object name 'Application_Capabilities'. ---> SoftGrid.Management.UpdateApplicationFailedException: Invalid object name 'Application_Capabilities'. ---> System.Data.OleDb.OleDbException: Invalid object name 'Application_Capabilities'.
       at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
       at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
       at SoftGrid.Management.DataAccess.ApplicationCapabilities.Add(ApplicationCapabilitiesData data)
       at SoftGrid.Management.Applications.UpdateAssignments(Int32 appId, ApplicationAssignment[] assigns, OleDbTransaction trans)
       at SoftGrid.Management.Applications.Update(ManagedApp app)
       --- End of inner exception stack trace ---

    Server stack trace:
       at SoftGrid.Management.Applications.Update(ManagedApp app)
       at SoftGrid.Management.Applications.UpdateApp(ManagedApp app)
       at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
       at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
       at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

    Exception rethrown at [0]:
       at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
       at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
       at SoftGrid.Management.IApplicationGroups.UpdateApp(ManagedApp app)
       at ManagementConsole.ManagementSession.ModifyManagedApp(ManagedApp app)
       --- End of inner exception stack trace ---

     

    We can insert manually an entry into the SQL Server from the SQL Server Express Studio, with the application ID, and the CSID of the group . (Though, this is not the normal way xD )

    Tried to install the SP2 Management_Server, didn't work (from Microsoft_Application_Virtualization_4.5SP2_upgrade)

    Thursday, August 25, 2011 4:04 PM

Answers

  • Ok, I have found the problem.

    Actually, the console was trying to call the table Application_Capabilities.

    Another technician read up the blog http://madvirtualizer.wordpress.com/2011/05/31/app-v-4-5-certain-database-tables-not-updating-or-empty-post-upgrade-from-4-1/

    And he added "NOT_USE" in the front of the deprecated tables, but the APPV management console calls up APPLICATION_CAPABILITIES when adding groups in access permissions.

    Just a note, that we installed APPV 4.1 then upgraded to 4.5

    ---

    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.

    • Marked as answer by SimBco Friday, August 26, 2011 5:52 PM
    Friday, August 26, 2011 5:52 PM

All replies

  • Were there any changes leading up to this?

    Did it just happen all of a sudden?

    Were there any Database Changes recently?

    Specifically permissions?

     


    JJ
    Thursday, August 25, 2011 5:23 PM
  • The last package we've done was June 26 2011, the features were working fine.

     

    The lastest operation was the stored procedure (21 July 2011) :: dbo.sp_SFTclosesessions (with line 212 modified) to fix a concurrent bug.

    http://support.microsoft.com/kb/2447513

     

    Tried restarting server, but no luck.

    Thursday, August 25, 2011 5:42 PM
  • Ok, I have found the problem.

    Actually, the console was trying to call the table Application_Capabilities.

    Another technician read up the blog http://madvirtualizer.wordpress.com/2011/05/31/app-v-4-5-certain-database-tables-not-updating-or-empty-post-upgrade-from-4-1/

    And he added "NOT_USE" in the front of the deprecated tables, but the APPV management console calls up APPLICATION_CAPABILITIES when adding groups in access permissions.

    Just a note, that we installed APPV 4.1 then upgraded to 4.5

    ---

    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.

    • Marked as answer by SimBco Friday, August 26, 2011 5:52 PM
    Friday, August 26, 2011 5:52 PM
  • Interesting issue. Just to confirm, was the management web service also upgraded? It is called the AppVirt management service from 4.5 on. I will reproduce this on our end and see if this in fact the case. I do want to make sure the 4.5 console was not talking to the data store through a lower version web service.
    Steve Thomas, SSEE, Microsoft
    App-V/MED-V/SCVMM/SCCM/AppCompat
    http://madvirtualizer.wordpress.com/
    The App-V Team blog: http://blogs.technet.com/appv/
    The MED-V Team Blog: http://blogs.technet.com/medv
    The SCVMM Team blog: http://blogs.technet.com/scvmm/

    “This posting is provided "AS IS" with no warranties, and confers no rights. User assumes all risks.”
    Monday, August 29, 2011 3:05 PM