DMF (1073676279) - Issue Fix

 Problem Statement: 

    When  I tried to Import the data via DMF I got the following error message.

<?xml version="1.0"?><Errors><Error><ErrorCode>-2146233088</ErrorCode><SubComponent>Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper</SubComponent><Description>DMF2060 -    at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFXmlPackageImport.AddDataFlowComponent(Package _Package)

   at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackageControllerImport.CreateAndExecutePackage()

   at DMFExecutePackage.PackageCreator.processEntity()

   at DMFExecutePackage.Program.Main(String[] args)</Description></Error><Error><ErrorCode>-1073676279</ErrorCode><SubComponent>Microsoft.SqlServer.DTSPipelineWrap</SubComponent><Description>Exception from HRESULT: 0xC0010009 -    at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSOutputColumnCollection100.get_Item(Object Index)

   at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFXmlPackageImport.UpdateSourceProperties(IDTSComponentMetaData100 flatFileSourceComponent, CManagedComponentWrapper srcFlatFileInstance, String name, Package _Package)

   at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFXmlPackageImport.AddDataFlowComponent(Package _Package)</Description></Error></Errors>

Please ensure that the schema of the mapping matches that of the staging table and the import file. It is essential to verify that the import file contains the same fields as specified in the mapping for the data entity. If there are any columns set in the mapping that are not present in the import file, you have two options: either provide a value for the column in the import file, or remove the column from the mapping altogether. Additionally, if there is a field present in the mapping that does not exist in the staging table, it should be removed from the mapping to resolve the issue.

'0' 'XXXX' record(s) inserted in staging

Resolution 1: 

        Goto DataManagement >> Framework Parameters >> Refresh Entity.

Resolution 2: 

        Goto DataManagement >> Framework Parameters >> Truncate Entity List

        Goto DataManagement >> Framework Parameters >> Refresh Entity.

Resolution 3: 

        Goto DataManagement >> DataEntities >> Filter the Specific Entity >> Modify target mapping >> Generate Mapping.

Resolution 4: 

        Remove the Entity from the DMF and Recreate it.

Comments

Post a Comment

Popular posts from this blog

Read the JSON data via REST API (X++)

  Problem Statement:           Read the data from outside Application. Here I am fetch the JSON data from Shopify Integration and push it in to the D365FO System.   Development steps:       Step 1 : Create Runnable Class.      Step 2 : After create the Runnable class, use the following Library in your solution.                               using System.Net.HttpWebRequest;                               using System.Net.HttpWebResponse;                               using System.Text.Json;                               using System.Text.Json.Serialization;  ...
Read more

Activate Financial Dimension in Dynamics 365 FO. (On- Premises)

  If you want to activate the financial dimension in Dynamics 365 on on-premises, you need to do a following step. 1.      Open SQL and go to D365FO Database. 2.     Execute the following Query                   select * from SQLSYSTEMVARIABLES         update SQLSYSTEMVARIABLES SET VALUE = 1 WHERE PARM =                     'CONFIGURATIONMODE' 3.      Execute IIS Restart. 4.     Refresh the Page. 5.     After activating the financial dimension, you need to revert the option.              update SQLSYSTEMVARIABLES SET VALUE = 0 WHERE PARM                     =   'CONFIGURATIONMODE' 6.    Execute IIS Restart. 7.    Refresh the Page.
Read more