cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mbanihani
Level: Powered On

Export Customer from FO to CE Accounts through error.

While trying to export data from Microsoft Dynamics 365 for Finance & Operation to CE through CDS, I got this error 

Spoiler
Precondition Failed {"error":{"code":"0x80060892","message":"A record that has the attribute values Account Number already exists. The entity key Account Number requires that this set of attributes contains unique values. Select unique values and try again.","innererror":{"message":"A record that has the attribute values Account Number already exists. The entity key Account Number requires that this set of attributes contains unique values. Select unique values and try again.","type":"System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]","stacktrace":" at Microsoft.Crm.Extensibility.OrganizationSdkServiceInternal.CreateInternal(Entity entity, InvocationContext invocationContext, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode, Dictionary`2 optionalParameters)\r\n at Microsoft.Crm.Extensibility.OData.CrmODataExecutionContext.CreateOrganizationResponse(Entity entity)\r\n at Microsoft.Crm.Extensibility.OData.CrmODataServiceDataProvider.CreateEdmEntity(CrmODataExecutionContext context, String edmEntityName, EdmEntityObject entityObject, Boolean isUpsert)\r\n at Microsoft.Crm.Extensibility.OData.EntityController.PostEntitySetImplementation(String& entitySetName, EdmEntityObject entityObject)\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()"}}}

the source field with issue from CDS in execution history is 

POST https://xxx/api/data/v9.0/accounts {"creditlimit":"0","accountnumber":"CR10001470","syncedtofinops":"true","name":"RBTEST_19SEP_07_4302_RETEST_FUNCTION","knownas":"","alias":"","paymenttermscode":"614020003","preferredpaymenttype":"5","transactioncurrencyid@odata.bind":"/transactioncurrencies(ae640bc0-2318-e911-a985-00224800510b)","creditonhold":"false","accountratingcode":"3","address1_line1":"1561655 State Highway 89","address1_line2":"","address1_city":"Loco","address1_stateorprovince":"OK","address1_postalcode":"73442-9520","address1_postofficebox":"","address1_country":"US","address1_latitude":"0","address1_longitude":"0","accountclassificationcode":"614020005","businessstarted":"2019-09-01","companychain":"","genusdeliveryterms":"2","ownerid@odata.bind":"/teams(4f4d0d55-8650-e911-a98a-0022480056f9)","tradingstatus":"614020000"}

Any idea about what's going on please ? 

 

Regards,

Bani Hani

1 REPLY 1
Administrator
Administrator

Re: Export Customer from FO to CE Accounts through error.

Bumping for visibility 

 

@TopShelf-MSFT 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 359 members 6,635 guests
Please welcome our newest community members: