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.