Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

User errors after data deployment from production environment

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello,

A little bit of context:

We have a stage environment which contains an exact copy of the production, from a few months ago. Several differences are:

  • Different passwords for several users, including ax-service related users
  • Two or three missing users in the stage environment.


We want to refresh our stage environment with the latest data from prod and we imported and restored all the databases (Ax, AXmodel, Baseline) and even the Reports databases.

The data is there, Database sync works, but now we have user-based issues.

Issues:

  • one of the administrator accounts can no longer log on to microsoft dynamics, even if we import it again from AD
  • another normal user but with administrator rights in ax receives all kinds of errors regarding "The record cannot be modified because it has not been selected"

Good part: the main administrator can use ax without issues. (even with a different user password)

Question:

Do we have to delete some caches or import the master database from SQL server?

We tried to restore the master db, but we couldn't restore it because it doesn't recognize the single-user mode.

I guess that some unknown service (we closed all sql services from the manager) is faster than my cmd run of sqlservr or our method/commands are wrong.

Any help is appreciated

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: User errors after data deployment from production environment

    Yes, it worked.

    We had to remove and add the normal user, but the others had conflicting SIDs.

    Thank you!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: User errors after data deployment from production environment

    Thank you.

    I will reply with the results.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: User errors after data deployment from production environment

    Thank you for your reply.

    It is the same domain and should be the same default companies.

    I will check the UserInfo table.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,711 Super User 2024 Season 2 on at
    RE: User errors after data deployment from production environment

    Hi CodexGuy,

    Are you using different domains for the environments? As you say some passwords are different, there might be separate domains used.

    If so, how did you update the UserInfo table to know which domain is used per user?

    Can you tell more about this scenario? For the normal user, is the default company changed?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans