Skip to Content
Former Member
Sep 30, 2010 at 09:15 AM

Error opening BPC 7.0 SP7 Appset after restore to BPC 7.5 SP3 patch 3


We get the following error after restoring a server manager backup of a BPC 7M SP7 application set to a BPC 7.5 SP3 patch 3 server when we log into the admin client:

==============[System Error Tracing]==============
[System  Name] : ApplicationService
[Message Type] : ErrorMessage
[Job Name]     : OSoft.Services.Webservice.ApplicationService.ApplicationService.Query()
[DateTime]     : 9/30/2010 2:40:27 AM
[UserId]       : *****
    Type      : System.Data.SqlClient.SqlException
    Errors    : System.Data.SqlClient.SqlErrorCollection
    Class     : 16
    LineNumber: 568
    Message   : {The statistics 'UserID' is dependent on column 'UserID'.
ALTER TABLE ALTER COLUMN UserID failed because one or more objects access this column.
Changed database context to 'AppsetExtra'.
Changed database context to 'Appset'.}
    Number    : 5074
    Procedure : 
    Server    : BPCSQLServer
    State     : 1
    Source    : .Net SqlClient Data Provider
    TargetSite: System.Object InvokeMethod(Method, System.Object[], Boolean[], System.Reflection.BindingFlags)
    HelpLink  : 
==============[System Error Tracing  End ]==============

I am guessing that the admin client is executing a query that expects a database table in a certain format. Any thoughts on why this is happening? Admin client dies at this point with a message to look at Log ID:<number>

In the above code, I have removed internally-identfiable information about the name of the server, customer name, etc.