Finance | Project Operations, Human Resources, ...

Error while pushing data from Dataverse to D365 F&O (Error message: Additional text encountered)

(0) Share

Report

Posted on by Rhushikesh R

758

Hi Everyone,

I have recently configured Finance Insight in Contoso environment.

As last step of it, we configure Data integration project in Power platform environment by choosing existing template of Payment prediction result.
Ref link: https://learn.microsoft.com/en-us/dynamics365/finance/finance-insights/create-data-integrate-project

I can see the AI builder model has completed it's run, but when I am trying to push data from Dataverse to F&O environment, the DMF execution job is getting failed with below error for all records,

/Additional text encountered after finished reading JSON content: a. Path '', line 1, position 3./

What's the rootcause of this error and how should we fix it? Am I missing any steps here?

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report
Hi,

Would you like to provide more information (such as JSON content) so that we can better solve the problem for you?

From the error content, it may be caused by the incorrect format of JOSN, you can take the following steps to solve the problem:

Check your data source to ensure that the JSON data is well-formed and does not contain any additional text.

Verify your data mapping and field mapping settings to ensure the correct conversion of data from Dataverse to D365 F&O.

Best regards,

Kevin

Was this reply helpful? Yes No
Rhushikesh R 758 on at

Like (0)

Report
Hi Kevin,

Thank you for your reply.

There are 2 fields named Explainability & Likelihoods and F&O is not showing field related information in the error message. And the field values are as below

Record 1 - Explainability: "[{""entityName"": ""msdyn_paypredcustinventity"" Likelihoods: ""attributeName"": ""msdyn_invoiceamountaccounting"" Record 2 - Explainability: "[{""entityName"": ""msdyn_paypredcustinventity"" Likelihoods: ""attributeName"": ""msdyn_sourcekey""

Also, please find Data integration project mapping below. Also the template mapping is default one, I haven't changed anything in the template.

Was this reply helpful? Yes No