Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

In CRM Online we copied our production database to our sandbox and now get errors updating base entities like Accounts

Posted on by 70

We recently copied our production database over our Sandbox instance.  Since we did that we are no longer able to save to the base entities such as Accounts, or contacts even with users that have the System administrator Security Role.  We receive an "Access Error" every time we try.  We can save custom entities.

The error in the log file effectively says:

The user with SystemUserId=xxxxxxxx in OrganizationContext=xxxxxxx is disabled

*This post is locked for comments

  • billiardguy Profile Picture
    billiardguy 70 on at
    RE: In CRM Online we copied our production database to our sandbox and now get errors updating base entities like Accounts

    It turned out to be a third party solution that we installed a month earlier.  When we copied production to sandbox, the offending user which was needed to run a plug-in was not copied.  Lesson learned, beware of third party solutions when moving copies of one environment to another.

    There were several responses that are part of this thread that were pointing us in the right direction, but due to various situations, it took a while to look at the problem in the right way.

  • billiardguy Profile Picture
    billiardguy 70 on at
    RE: In CRM Online we copied our production database to our sandbox and now get errors updating base entities like Accounts

    Here it is:

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: The user with SystemUserId=<GUID> in OrganizationContext=<GUID> is disabledDetail:

    <OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance&quot; xmlns="schemas.microsoft.com/.../Contracts&quot;>

     <ActivityId>fd0ca327-0dd1-4dee-a6ea-fdc138ed40a0</ActivityId>

     <ErrorCode>-2147220955</ErrorCode>

     <ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic&quot; />

     <Message>The user with SystemUserId=<GUID> in OrganizationContext=<GUID> is disabled</Message>

     <Timestamp>2017-09-20T14:06:23.9374657Z</Timestamp>

     <ExceptionRetriable>false</ExceptionRetriable>

     <ExceptionSource i:nil="true" />

     <InnerFault i:nil="true" />

     <OriginalException i:nil="true" />

     <TraceText i:nil="true" />

    </OrganizationServiceFault>

  • prt33k Profile Picture
    prt33k 6,907 on at
    RE: In CRM Online we copied our production database to our sandbox and now get errors updating base entities like Accounts

    Can you try opening the the url:

    https://<orgname>.crm11.dynamics.com/main.aspx?etc=8&id=%7b<The error guid>%7d&pagetype=entityrecord

    to see which user it is actually referring to.

    Also can you download the access denied log file and post it here.

  • Verified answer
    ashlega Profile Picture
    ashlega 34,475 on at
    RE: In CRM Online we copied our production database to our sandbox and now get errors updating base entities like Accounts

    As for not handling properly.. the error is not related to the logged in user. There is a workflow or plugin running under the user account associated with that SystemUserId - you just need to identify the user account(see above), and, then, find that workflow.

  • ashlega Profile Picture
    ashlega 34,475 on at
    RE: In CRM Online we copied our production database to our sandbox and now get errors updating base entities like Accounts

    Yes, it would be "users" (sorry about that.. system user is the schema name)

    If you exported them earlier from a regular view (not from the advanced find), there would be some filters there. That's why I suggested using advanced find since you can remove the filters there before exporting to excel.

  • billiardguy Profile Picture
    billiardguy 70 on at
    RE: In CRM Online we copied our production database to our sandbox and now get errors updating base entities like Accounts

    Tried modifying Accounts in Sandbox logged in as different users and the systemuserid is the same in the generated error message.  So either it's not significant or the system is not handling the logged in user properly.  We submitted a ticket to MS, so we will see what happens.  When I get a solution, I will post it.

  • billiardguy Profile Picture
    billiardguy 70 on at
    RE: In CRM Online we copied our production database to our sandbox and now get errors updating base entities like Accounts

    Can't find "system users" entity in the online version.  Just users.  Which I did export before and got ObjectId.

  • ashlega Profile Picture
    ashlega 34,475 on at
    RE: In CRM Online we copied our production database to our sandbox and now get errors updating base entities like Accounts

    Open advanced find, select "system users" entity, and remove all filters.. then export.. you'll be able to find the id that way. It'll probably be one of the service account (System maybe)

    There was a similar thread recently - just can't find it right now. If I'm not mistaken, there was a workflow or plugin running under that account, so they had to disable it

  • billiardguy Profile Picture
    billiardguy 70 on at
    RE: In CRM Online we copied our production database to our sandbox and now get errors updating base entities like Accounts

    No - I don't know how to find out what user the Systemuserid maps to.

    I tried exporting all the users to see if I would get ids.  None of the ObjectIds associated with users matches the systemuserid referenced in the error message.

  • ashlega Profile Picture
    ashlega 34,475 on at
    RE: In CRM Online we copied our production database to our sandbox and now get errors updating base entities like Accounts

    Do you know which user account that SystemuserId corresponds to when the error occurs?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans