RSS

Exception from HRESULT: 0xC004802-Data Import/Export Framework AX 2012 R3

11 May

I have been trying to import data from an Excel file using Data Import Export Framework. The mapping and validation works but when I try to import the data into staging table – I get the below error:

Exception from HRESULT: 0xC0048021

I am using Dynamics AX 2012 R3 RTM with Excel 2013 64 bit.So before going in to solution please install 64-bit Microsoft Excel Driver on 64-bit machine (OS) with ‘Microsoft Access Database Engine 2010 Redistribute’ (AccessDatabaseEngine_x64.msi) by using “/passive” argument.

Let’s review the Problem statement and Solution in details

Problem Statement.

First off I’ll be using Source data format of Type = Excel to import the data from Excel file

Source data format

Please note that Source data format Type = “File” and File format = “Excel”.To begin with I’m going to use standard DIXF “Vendor” Target entity and I’ll introduce a processing group

Processing group

Pr

Then I selected Source file and I’ll use “Generate source mapping” option

Untitled1

I found entity mapping is done successfully.

Capture1

Now Select entities for processing group – Preview file contents. you will get below error.

Capture

Solution:

AX Version: Microsoft Dynamics AX 2012 R3 RTM
Microsoft Office: Office 2013, Excel 2013
OS: Windows Server 2012
SQL: SQL 2014
If you’re using Excel 2013 32 bit or 64 bit , the problem is caused by DMConfig XML file.

Go to the DMConfig.xml file in the “C:\Program Files\Microsoft Dynamics AX\60\DataImportExportFramework” folder and replace the PipelineComponentInfo_Multicast, PipelineComponentInfo_ExcelSource and  <PipelineComponentInfo_ExcelDestination> nodes by the following:

<PipelineComponentInfo_Multicast>
{EC139FBC-694E-490B-8EA7-35690FB0F445}
</PipelineComponentInfo_Multicast>
<PipelineComponentInfo_ExcelSource>
{8C084929-27D1-479F-9641-ABB7CDADF1AC}
</PipelineComponentInfo_ExcelSource>
<PipelineComponentInfo_ExcelDestination>
{1F5D5712-2FBA-4CB9-A95A-86C1F336E1DA}
</PipelineComponentInfo_ExcelDestination>

That solved the issue for me!

if above tags value does not work then try below lines

<PipelineComponentInfo_Multicast>
    {33D831DE-5DCF-48F0-B431-4D327B9E785D}
  </PipelineComponentInfo_Multicast>
  <PipelineComponentInfo_ExcelSource>
    {9F5C585F-2F02-4622-B273-F75D52419D4A}
  </PipelineComponentInfo_ExcelSource>
  <PipelineComponentInfo_ExcelDestination>
    {90E2E609-1207-4CB0-A8CE-CC7B8CFE2510}
  </PipelineComponentInfo_ExcelDestination>

Advertisements
 
Leave a comment

Posted by on May 11, 2015 in Uncategorized

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: