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

[Former Member]

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]       : *****
[SqlException] 
    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.

[james_lim · Accepted solution]

Tony,

7.0 appset might have some statistics setting.

Please remove any custom statistics or trigger etc and back up again and try to restore it.

Thank you.

Regards,

James.

[Former Member · Accepted solution]

Hi James,

Thanks for the response. We will try this - we just need to find out what the customer added.

Does BPC have any custom statistics or triggers by default, or can we just remove all of it?

[Former Member · Accepted solution]

James,

The custome stats and indexes were removed and now we can get into the admin client and proceed with the upgrade process.

Thanks for this tip.

Tony D.