Error While Importing Data Using DIXF

(0) Share

Report

Posted on by Mayur Saini

155

Hello Everyone.

I am getting below while importing the data through DIXF in D365 F&O.

"Error occurred while doing bulk copy from temp table to entity table-'0' 'States' record(s) inserted in staging table."

I have an excel sheet which have 600 records but when we import this data through DIXF i'm getting the above error. But when we divided this single excel file into 6 different excel file which contains the same data then data will be imported without any issue.

I am already verify my data and found its don't have any issue like any indexing issue or some thing else. And it's a standard data entity & don't contain any customization.

Please help me to resolve this problem..

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Mayur Saini 155 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report
Copy link

Link copied!

Hello Mayur Saini,

You can check below link. Rahul Mohta explained this in his blog.

https://community.dynamics.com/ax/b/happyd365fo/posts/error-occurred-while-doing-bulk-copy-from-temp-table-to-entity-table-in-data-import-in-microsoft-dynamics-365-finance-and-operations

You can also check other links as below if this helps you.

https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/212000/dief---error-occurred-while-doing-bulk-copy-from-temp-table-to-entity-table/701719

http://fourone.se/blog/2012/11/06/dmf-error-occured-while-doing-bulkcopy-from-temp-table-to-entity-table/

Kindly check and provide us feedback.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Mayur Saini 155 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your quick responce.

I'm already try the solution that are mention in above shared link.

And i'm also verify my file it's does not contain wrong data. If my excel sheet contained any wrong data so why data is imported when i am divided same file into different files.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report
Copy link

Link copied!

Hello Mayur Saini,

Is it possible to share the full excel sheet here so that I can try importing it in my system to check?

Let us know if possible.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,042 on at

Like (0)

Report
Copy link

Link copied!

seen this error many times

possible cause is primary key violation, additional column in Excel in one of the primary key creating conflict, data management entity refresh pending after build deployment

pls try and suggest

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report
Copy link

Link copied!

Hello Mayur Saini,

In addition; you can also check if you have hidden any column in your excel sheet and then try to import that in system.

In that case too, system will show you this error.

Kindly check and suggest.

Also please share the full excel sheet if possible to share.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
SThakur 414 on at

Like (1)

Report
Copy link

Link copied!

Check the format of the cells [especially records with numeric values] is consistent across the existing worksheet. Just try copying the records into another excel file and import it through DIXF. If it has worked with different files and not the original one it could be some sort of data corruption.

Also use [Ctl -] to some blank rows and columns in the new worksheet other than the required copied records in your new workbook to remove any format issues.

Thanks,

Shilpi

Was this reply helpful? Yes No
Verified answer

Rahul Mohta 21,042 on at

Like (0)

Report
Copy link

Link copied!

also try to remove formats for the primary fields and ensure they are unique and matches the data format of the column in entity

Was this reply helpful? Yes No
Mayur Saini 155 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your quick responce.

Its working for me.

Was this reply helpful? Yes No