System Error when trying to edit user

Thursday, April 27, 2017
Avatar

Hi,

We migrated a SpiraTest installation from a server to another by doing a fresh installation and then backing up the database of the old installation and restoring the backup on the new one. The new installation seems to mostly work but if I try to edit a user, I get an error page with text like " A system error has occurred... Please click on the 'My Page' link to return to the application ". It then instructs to provide the following backtrace when contacting support:


Offending URL: __Page
Source: System.Data.Entity
Message: An error occurred while executing the command definition. See the inner exception for details.
Stack trace: at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues) at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator() at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source) at System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source, Expression`1 predicate) at APPLICATION.Business.VaultManager.User_RetrieveWithTaraVault(Int64 userId) at APPLICATION.Web.Administration.UserDetails.LoadAndBindData_TaraVault(Int64 userId) at APPLICATION.Web.Administration.UserDetails.Page_Load(Object sender, EventArgs e) at APPLICATION.Web.PageLayout.OnLoad(EventArgs e) at APPLICATION.Web.Administration.AdministrationBase.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
Any tips on how to resolve this? Or is there some other, preferred mechanism for migrating to a new server?
 
2 Replies
Tuesday, May 2, 2017
Avatar
inflectra.jimx
re: erjoonas Thursday, April 27, 2017

Hi Joonas

Please could you log a help desk ticket and include all of the errors being displayed in the Event Log, there is an Inner Exception that contains more information that we will need to assist you.

Regards

Jim

Wednesday, May 3, 2017
Avatar
re: inflectra.jimx Monday, May 1, 2017

Hi Jim,

Thank you, the inner exception actually hinted at database structure being a bit out of sync with expectations of the software. Running the database patch program fixed this issue for us.

- Joonas

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Thursday, April 27, 2017
  • Last Reply: Wednesday, May 3, 2017
  • Replies: 2
  • Views: 6427