Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Data Import - (System) User Issues

(0) ShareShare
ReportReport
Posted on by 15

Hi.  We are using CRM 2015 On-Premise, and I am attempting to load a substantial amount of users using the CRM "Data Management" --> "Imports" mechanism.  I am trying to import using the "User" entity (aka "System User").  I have imported data to several other entities without issue.  However, when I try using importing our user data, they are all failing with the following information:

  Error Code:  0x80040359

  Description:  The Microsoft Dynamics CRM record could not be created.

  More Information:  An unexpected error occurred   (<-- I know...gee, thanks for the details...right?)

What is very strange is that it does load the users -- even though it gives the error message.  The concern, of course, when we do this for real in Production, is that some of these will actually have legitimate errors (since we are loading many users) -- and it will be impractical to determine which rows are true errors and which rows are like this situation, where the users were indeed loaded even though they all produced an error.  Plus, even though the users are in the system, it just makes me uneasy that they are receiving this error.

Has anyone else encountered this behavior?  Are there any suggestions on how to avoid it?

Thanks,

Kevin

P.S.  If it matters at all, here is a list of columns that we are importing:

User Name

First Name

Last Name

Primary Email

Title

Main Phone

I also tried just using the first three (User Name, First Name, and Last Name), but I received the same error).

*This post is locked for comments

  • KAH7777 Profile Picture
    KAH7777 15 on at
    RE: Data Import - (System) User Issues

    When we do this in Production, we will have a file containing many users, but in order to work through this issue, I am using a test file that contains one user.  Once that imports (and I receive the errors shown in the trace), I update the test file with the next user from the big list -- tweak something (like disabling Workflows, as you suggested) -- and try the import again with the one user in the file.

    The error is encountered each and every time I run the import.  The only time it does not err is when I inadvertently did not change the user and it "updated" the existing user (it was successful, but it was the same user with the same info, so nothing had changed).  From my previous post (in case it helps):

     "The import process successfully updates a user.  As odd as that sounds, I noticed this when I tried an import -- without changing the user that I had just tried to process -- and it completed successfully.  It did not really update anything, however, as the user was already there.  (Just a reminder that even though I receive the errors I posted below, the import process does actually add the user)"

    So, thanks for the additional ideas, but it does not look like it is related to the number of records it is trying to process.

    I have also tried this in a CRM installation on another machine, but received the same results (I wanted to rule out something particular to the setup of my CRM installation).

    Any other ideas?

    Thanks,

    Kevin

  • ScottDurow Profile Picture
    ScottDurow 19 on at
    RE: Data Import - (System) User Issues

    I know that sometimes Active Directory can return errors if under high load so perhaps there is some issue with many users being queried at the same time?

    Does the error happen for the same user each time - or is it just random when you import?

  • KAH7777 Profile Picture
    KAH7777 15 on at
    RE: Data Import - (System) User Issues

    John, thanks for the suggestion, but I have the System Administrator role, so I should have the necessary permissions.

    Scott, thank you for your suggestions, as well.  I did have some out of box workflows active, but deactivating them had no effect.  I will put the "full" stack trace in the bottom portion of this message.  I say, "full", since it the same errors occurred 3 times.  Even though I only had one user in the file, it seems to try 3 times before giving up.  So, instead of copying the repeated information, I will only copy the one set of exceptions.

    Also, I should point out 2 things I have observed:

    1.  I can manually add a user (through the UI User front end).  I copied one of the users from my file and pasted it into the "User Name" field on the User form.  When tabbing out, it filled in all the relevant fields -- indicating that it did find it in Active Directory.
    2. The import process successfully updates a user.  As odd as that sounds, I noticed this when I tried an import -- without changing the user that I had just tried to process -- and it completed successfully.  It did not really update anything, however, as the user was already there.  (Just a reminder that even though I receive the errors I posted below, the import process does actually add the user)

    I just wanted to mention those two observations, in case that triggers another idea or suggestion.

    Thanks again for your time.  As promised, the "full" trace is below.

    Kevin

    ============================================================

    # CRM Tracing Version 2.0
    # LocalTime: 2016-10-25 15:54:35.395
    # Categories: *:Verbose
    # CallStackOn: Yes
    # ComputerName: xxxxxx8
    # CRMVersion: 7.0.0002.0099
    # DeploymentType: OnPremise
    # ScaleGroup:
    # ServerRole: AppServer, AsyncService, DiscoveryService, ApiServer, HelpServer, DeploymentService, SandboxServer, DeploymentManagementTools, VssWriter, EmailConnector

    [2016-10-24 16:40:46.388] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 143 |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: 651c824f-10f4-4abe-9be5-d175c8c41eb6 | CrmException..ctor ilOffset = 0x7

    at CrmException..ctor(String message, Exception innerException, Int32 errorCode, Boolean isFlowControlException) ilOffset = 0x7
    at CrmException..ctor(String message, Int32 errorCode) ilOffset = 0x5
    at ServerLocatorService.GetDefaultOrganization(String authenticationInfo) ilOffset = 0x21
    at WindowsAuthenticationProvider.QueryForOrganizationId(String userToken) ilOffset = 0xC
    at WindowsAuthenticationProviderBase.Authenticate(HttpApplication application, WindowsIdentity userIdentity) ilOffset = 0x90
    at AuthenticationStep.Authenticate(HttpApplication application) ilOffset = 0x4E
    at AuthenticationPipeline.Authenticate(HttpApplication application) ilOffset = 0x11
    at AuthenticationEngine.Execute(Object sender, EventArgs e) ilOffset = 0x147
    at SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() ilOffset = 0x5D
    at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) ilOffset = 0x15
    at ApplicationStepManager.ResumeSteps(Exception error) ilOffset = 0x10A
    at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) ilOffset = 0x5C
    at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) ilOffset = 0x16A
    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) ilOffset = 0x4B
    >Crm Exception: Message: User Was Not Found, ErrorCode: -2147220969
    [2016-10-24 16:40:46.388] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 143 |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: 651c824f-10f4-4abe-9be5-d175c8c41eb6 | CrmException..ctor ilOffset = 0x30
    at CrmException..ctor(String formattedErrorMessage, Int32 errorCode, Object[] arguments) ilOffset = 0x30
    at WindowsAuthenticationProvider.QueryForOrganizationId(String userToken) ilOffset = 0xC
    at WindowsAuthenticationProviderBase.Authenticate(HttpApplication application, WindowsIdentity userIdentity) ilOffset = 0x90
    at AuthenticationStep.Authenticate(HttpApplication application) ilOffset = 0x4E
    at AuthenticationPipeline.Authenticate(HttpApplication application) ilOffset = 0x11
    at AuthenticationEngine.Execute(Object sender, EventArgs e) ilOffset = 0x147
    at SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() ilOffset = 0x5D
    at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) ilOffset = 0x15
    at ApplicationStepManager.ResumeSteps(Exception error) ilOffset = 0x10A
    at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) ilOffset = 0x5C
    at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) ilOffset = 0x16A
    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) ilOffset = 0x4B
    >Crm Exception: Message: No Microsoft Dynamics CRM user exists with the specified domain name and user ID, ErrorCode: -2147220652
    [2016-10-24 16:40:46.390] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 143 |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: 651c824f-10f4-4abe-9be5-d175c8c41eb6 | CrmException..ctor ilOffset = 0x7
    at CrmException..ctor(String message, Exception innerException, Int32 errorCode, Boolean isFlowControlException) ilOffset = 0x7
    at CrmException..ctor(String message, Int32 errorCode) ilOffset = 0x5
    at ServerLocatorService.GetDefaultOrganization(String authenticationInfo) ilOffset = 0x21
    at WindowsAuthenticationProvider.QueryForOrganizationId(String userToken) ilOffset = 0xC
    at WindowsAuthenticationProviderBase.Authenticate(HttpApplication application, WindowsIdentity userIdentity) ilOffset = 0x90
    at AuthenticationStep.Authenticate(HttpApplication application) ilOffset = 0x4E
    at AuthenticationPipeline.Authenticate(HttpApplication application) ilOffset = 0x11
    at AuthenticationEngine.Execute(Object sender, EventArgs e) ilOffset = 0x147
    at SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() ilOffset = 0x5D
    at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) ilOffset = 0x15
    at ApplicationStepManager.ResumeSteps(Exception error) ilOffset = 0x10A
    at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) ilOffset = 0x5C
    at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) ilOffset = 0x16A
    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) ilOffset = 0x4B
    >Crm Exception: Message: User Was Not Found, ErrorCode: -2147220969
    [2016-10-24 16:40:46.390] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 143 |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: 651c824f-10f4-4abe-9be5-d175c8c41eb6 | CrmException..ctor ilOffset = 0x30
    at CrmException..ctor(String formattedErrorMessage, Int32 errorCode, Object[] arguments) ilOffset = 0x30
    at WindowsAuthenticationProvider.QueryForOrganizationId(String userToken) ilOffset = 0xC
    at WindowsAuthenticationProviderBase.Authenticate(HttpApplication application, WindowsIdentity userIdentity) ilOffset = 0x90
    at AuthenticationStep.Authenticate(HttpApplication application) ilOffset = 0x4E
    at AuthenticationPipeline.Authenticate(HttpApplication application) ilOffset = 0x11
    at AuthenticationEngine.Execute(Object sender, EventArgs e) ilOffset = 0x147
    at SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() ilOffset = 0x5D
    at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) ilOffset = 0x15
    at ApplicationStepManager.ResumeSteps(Exception error) ilOffset = 0x10A
    at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) ilOffset = 0x5C
    at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) ilOffset = 0x16A
    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) ilOffset = 0x4B
    >Crm Exception: Message: No Microsoft Dynamics CRM user exists with the specified domain name and user ID, ErrorCode: -2147220652
    [2016-10-24 16:40:46.391] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 143 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Warning |ReqId: 651c824f-10f4-4abe-9be5-d175c8c41eb6 | AuthenticationEngine.Execute ilOffset = 0x147
    at AuthenticationEngine.Execute(Object sender, EventArgs e) ilOffset = 0x147
    at SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() ilOffset = 0x5D
    at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) ilOffset = 0x15
    at ApplicationStepManager.ResumeSteps(Exception error) ilOffset = 0x10A
    at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) ilOffset = 0x5C
    at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) ilOffset = 0x16A
    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) ilOffset = 0x4B
    >A failure occurred during the execution of the AuthenticationPipeline: Microsoft.Crm.CrmException: No Microsoft Dynamics CRM user exists with the specified domain name and user ID
    at Microsoft.Crm.Authentication.WindowsAuthenticationProvider.QueryForOrganizationId(String userToken)
    at Microsoft.Crm.Authentication.WindowsAuthenticationProviderBase.Authenticate(HttpApplication application, WindowsIdentity userIdentity)
    at Microsoft.Crm.Authentication.AuthenticationStep.Authenticate(HttpApplication application)
    at Microsoft.Crm.Authentication.AuthenticationPipeline.Authenticate(HttpApplication application)
    at Microsoft.Crm.Authentication.AuthenticationEngine.Execute(Object sender, EventArgs e)
    [2016-10-24 16:40:46.398] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 143 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: 651c824f-10f4-4abe-9be5-d175c8c41eb6 | ErrorInformation.LogError ilOffset = 0x17
    at ErrorInformation.LogError() ilOffset = 0x17
    at ErrorInformation..ctor(Exception exception, Uri requestUrl, Boolean logError, IOrganizationContext context) ilOffset = 0x1F5
    at ErrorInformation..ctor(Exception exception, Uri requestUrl, IOrganizationContext context) ilOffset = 0x5
    at MainApplication.Application_Error(Object sender, EventArgs eventArguments) ilOffset = 0x81
    at EventHandler.Invoke(Object sender, EventArgs e) ilOffset = 0xFFFFFFFF
    at HttpApplication.RaiseOnError() ilOffset = 0x26
    at ApplicationStepManager.ResumeSteps(Exception error) ilOffset = 0x85
    at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) ilOffset = 0x5C
    at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) ilOffset = 0x16A
    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) ilOffset = 0x4B
    >MSCRM Error Report:
    --------------------------------------------------------------------------------------------------------
    Error: No Microsoft Dynamics CRM user exists with the specified domain name and user ID

    Error Number: 0x80040354

    Error Message: No Microsoft Dynamics CRM user exists with the specified domain name and user ID

    Error Details: No Microsoft Dynamics CRM user exists with the specified domain name and user ID

    Source File: Not available

    Line Number: Not available

    Request URL: localhost/.../ReportService2005.asmx

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Data Import - (System) User Issues

    The -2147220969 error code (0x80040217) specifies a problem with authentication. Since you say that the user you are creating is in Active Directory, do you have the proper permissions in CRM to add users? Wondering if the system is complaining that you don't have enough rights to add users.

  • ScottDurow Profile Picture
    ScottDurow 19 on at
    RE: Data Import - (System) User Issues

    That is rather strange I agree - do you have any plugins or workflows enabled on the user entity?

    Are there any other error stacks in the trace file?

  • KAH7777 Profile Picture
    KAH7777 15 on at
    RE: Data Import - (System) User Issues

    Thanks for the quick response, Scott.  I enabled tracing, but I am finding the messages confusing.  Let me share what I am seeing after running a test to import a User .csv file with one user (I'll share the first error in its entirety, but for reasons of conciseness, I will only share the "friendly" error messages after that one):

    [2016-10-24 14:55:46.405] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:  135 |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: 59cddae1-b62e-404f-b8af-485f32a984b4 | CrmException..ctor  ilOffset = 0x7
     at CrmException..ctor(String message, Exception innerException, Int32 errorCode, Boolean isFlowControlException)  ilOffset = 0x7
     at CrmException..ctor(String message, Int32 errorCode)  ilOffset = 0x5
     at ServerLocatorService.GetDefaultOrganization(String authenticationInfo)  ilOffset = 0x21
     at WindowsAuthenticationProvider.QueryForOrganizationId(String userToken)  ilOffset = 0xC
     at WindowsAuthenticationProviderBase.Authenticate(HttpApplication application, WindowsIdentity userIdentity)  ilOffset = 0x90
     at AuthenticationStep.Authenticate(HttpApplication application)  ilOffset = 0x4E
     at AuthenticationPipeline.Authenticate(HttpApplication application)  ilOffset = 0x11
     at AuthenticationEngine.Execute(Object sender, EventArgs e)  ilOffset = 0x147
     at SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()  ilOffset = 0x5D
     at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)  ilOffset = 0x15
     at ApplicationStepManager.ResumeSteps(Exception error)  ilOffset = 0x10A
     at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)  ilOffset = 0x5C
     at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)  ilOffset = 0x16A
     at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)  ilOffset = 0x4B

    >Crm Exception: Message: User Was Not Found, ErrorCode: -2147220969

    >Crm Exception: Message: No Microsoft Dynamics CRM user exists with the specified domain name and user ID, ErrorCode: -2147220652

    >A failure occurred during the execution of the AuthenticationPipeline: Microsoft.Crm.CrmException: No Microsoft Dynamics CRM user exists with the specified domain name and user ID

    ----------------------------------------------------------------------------------

    >MSCRM Error Report:
    --------------------------------------------------------------------------------------------------------
    Error: No Microsoft Dynamics CRM user exists with the specified domain name and user ID

    Error Number: 0x80040354

    Error Message: No Microsoft Dynamics CRM user exists with the specified domain name and user ID

    Error Details: No Microsoft Dynamics CRM user exists with the specified domain name and user ID

    Source File: Not available

    Line Number: Not available

    I find these messages confusing, as of course this user does not exist -- which is the entire reason I am adding these users.  Also, I have verified that the user has an Active Directory ID, so that is not an issue, either.

    Given these messages and further information, can you (or anyone) please advise?

    Thanks,

    Kevin

  • ScottDurow Profile Picture
    ScottDurow 19 on at
    RE: Data Import - (System) User Issues

    Perhaps you could enable tracing to find out what the real source of the error is - support.microsoft.com/.../907490

    The trace file will include a full verbose error message and any SQL exceptions.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,074 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,900 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans