Question Status

Suggested Answer
Charuhas Jadhav asked a question on 29 Aug 2012 9:34 AM

Hello,

I get the following error when trying to load more than 1 product from source file to staging table using the data migration tool.

"Error occured while doing bulkcopy from temp table to entity table 0 Product records inserted in staging"

It works fine with 1 product but not more. Also it works fine when bringing in customers, vendors, customer addresses etc (bulk records)

The Microsoft.Dynamics.AX.DMF.SSISHelper.dll and Microsoft.Dynamics.AX.DMF.SSISHelper.tlb files are in place in the client and server directories 

C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin and C:\Program Files\Microsoft Dynamics AX\60\Server\<AosInstance>\bin

I have also increased the Maximim Buffer Size from 24 to 48 under database tuning in AX Server Config utility.

Could anybody please share thoughts on this?

Thanks,

Charu

 

 

Reply
Suggested Answer
UMESH PANDIT responded on 5 Jun 2014 5:37 AM

Hi Charu,

You need to find the duplicate (Primary key) records in the source file and delete it and try re-import.

--

Thank you
Note - This forum post is my own opinion and does not necessarily reflect the opinion or view of Microsoft.
Reply
Maxlude responded on 6 Sep 2012 6:10 AM

I have had the exact same error and eventually found that it was because there were duplicate (Primary key) records in the source file.

Once that was resolved, I just imported just under 6000 products which took just under 1hr.

Reply
Charuhas Jadhav responded on 6 Sep 2012 6:14 AM

Yup, that was exactly my issue too. I hope Microsoft improves the tool to provide more informative error messages in their next release.

Reply
Mansoor Adeel responded on 11 Dec 2012 3:34 AM

Error log helps a lot to understand the errors, please see section "How to see error log" in my blog post to check how Error Log helps identifying errors during data import.

dax2012dmfdataimport.blogspot.com/.../microsoft-dynamics-ax-2012-how-to.html

Mansoor Adeel

Mansoor Adeel

AX 2012 Techno Consultant

Reply
Suggested Answer
UMESH PANDIT responded on 5 Jun 2014 5:37 AM

Hi Charu,

You need to find the duplicate (Primary key) records in the source file and delete it and try re-import.

--

Thank you
Note - This forum post is my own opinion and does not necessarily reflect the opinion or view of Microsoft.
Reply