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
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
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?
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:
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
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.
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?
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
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.
André Arnaud de Cal...
292,074
Super User 2025 Season 1
Martin Dráb
230,900
Most Valuable Professional
nmaenpaa
101,156