An exception was thrown while activating Aras.Server.Core.EditItemModule after restoring the DB

I'm receiving the same error. Has anyone found a solution yet?

I too got the same error

An exception was thrown while activating Aras.Server.Core.EditItemModule -> Aras.Server.Core.UpdateItemInternal -> Aras.Server.Core.ChangeTracker.ChangeTrackerContainer -> λ:Aras.Server.Core.Abstractions.Internal.IDerivedRelationshipsChangeTracker.

So what I had to do was uninstall Aras, install a newer SQL Express Server (2019) and reinstall Aras. Even then I could not log in with "innovator" or "innovator_regular", but I was able to as "root" with password "innovator".

In my case, I have restore the DB of Aras 12 to Aras 14. So now I have two DBs, DB14 and DB12, I am able to login to DB14 but not to DB12 (restored one)

Hi,

I have received same error message after installing Aras 14.0.9, just wondering, if you have a resolution to this error message? I have uninstalled and re-installed the app, created a new database to no avail.

Appreciate your assistance.

Thanks

Hi,

It seems this error can occur when your database is corrupted, or is restored without the post-restore SQL queries. I'd recommend running the following queries on the database giving you issues.

-- Query 1 (should succeed)
sp_change_users_login 'Update_One','innovator','innovator'
GO
sp_change_users_login 'Update_One','innovator_regular','innovator_regular'
GO

-- Command(s) completed successfully.
-- Query 2 (should fail)
sp_grantdbaccess 'innovator','innovator'
GO

-- Msg 15023, Level 16, State 1, Line 1
-- User, group, or role 'innovator' already exists in the current database.
-- Query 3 (should succeed)
sp_addrolemember 'db_owner','innovator'
GO

-- Command(s) completed successfully.