Dynamics Community Forum Thread Details

Error logging into D365 F&O OneBox after DB restore from UAT

Hi everyone,

I am facing an issue while logging into a D365 F&O OneBox environment. It was working fine before, but after restoring the database from UAT, I started getting a login error.

After the DB restore, I completed the following steps:

Synced the database
Ran Admin provisioning
Verified in the database that my new user record exists in the USERINFO table
Confirmed that the SID is correct by comparing it with the old database

Even after this, I am still unable to log in.

Here are the environment versions:

OneBox version

Installed product version: 10.0.46 (10.0.2428.63)
Installed platform version: Update 70 (7.0.7778.29)

UAT version

Installed product version: 10.0.46 (10.0.2428.95)
Installed platform version: Update 70 (7.0.7778.45)

Could the version mismatch between OneBox and UAT be the reason for this issue, or could there be some other cause I should check?

I have also attached screenshots of the error.

PS: Old database is USMF DB and In query result SS botton one is USMF DB (OLD) and top one is NEW one

Thanks in advance.

Categories:

Dynamics 365 Fraud Protection

Dynamics 365 Intelligent Order Management

Dynamics 365 Human Resources

Dynamics 365 Finance

Microsoft Dynamics GP

Microsoft Dynamics AX

Microsoft Dynamics SL

Dynamics 365 Project Operations

Dynamics 365 Project Service Automation

Hi ShahzaibAhmed52,

Can you please take care of the correct categories when you create a question on the community? You selected all of them, which will be confusing for people monitoring questions related to e.g. GP or SL.

In this case your question is only related to Human Resources, Finance, or Project Operations.

Concerning your issue. Can you tell more about the screenshot with the SQL output of your user? Why are there two records for your user in the second part? Is that the new database restored from your UAT version?

If you have two records, ensure only one will be referencing to your user details. Also check if the user record is enabled.

It is also recommended to have the application on the same version as your database.

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL