Exception from HRESULT: 0xC0048021 at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.ShowPreview(Boolean isComposite) at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.Service.ServiceHelper.ShowPreview(DMFEntity entity)
Error:
Exception from HRESULT: 0xC0048021
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.ShowPreview(Boolean isComposite)
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.Service.ServiceHelper.ShowPreview(DMFEntity entity)
AX Version: Microsoft Dynamics AX 2012 R3 RTM
Microsoft Office: Office 2013, Excel 2013
OS: Windows Server 2012
SQL: SQL 2008 R2.
Solution:
The problem is caused by the DMConfig XML file.
Go to the DMConfig.xml file in the Microsoft Dynamics AX60DataImportExportFramework folder and replace the PipelineComponentInfo_Multicast, PipelineComponentInfo_ExcelSource and <PipelineComponentInfo_ExcelDestination> nodes by the following:
<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>
Happy DAX Infra!