Share
Report
4,004I am having a problem with Import after making changes to a Composite Data Entity.
The customer has a custom Composite Data Entity that used the Depriciated Data Entity SalesOrderHeaderV2Entity.
So on the Composite Data Entity, I changed the Data Entity SalesOrderHeaderV2Entity to SalesOrderHeaderV3Entity, and I also changed SalesOrderLineV2Entity to SalesOrderLineV3Entity.
I did a build and Sync Database, and also ran "Truncate entity list" and "Refresh entity list"
I did a build and Sync Database, and also ran "Truncate entity list" and "Refresh entity list"
Then I tried importing an xml file that the customer used before, but I got this error:
<?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.DMFXmlCompositePackageImport.AddDataFlowComponent(Package _Package)
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackageControllerCompositeEntity.CreateAndExecutePackage()
at DMFExecutePackage.PackageCreator.processCompositeEntity()
at DMFExecutePackage.Program.Main(String[] args)</Description></Error><Error><ErrorCode>-2146233088</ErrorCode><SubComponent>Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper</SubComponent><Description>DMF2060 - at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFXmlCompositePackageImport.UpdateSourceProperties(IDTSComponentMetaData100 flatFileSourceComponent, CManagedComponentWrapper srcFlatFileInstance, String name, Package _Package)
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFXmlCompositePackageImport.AddDataFlowComponent(Package _Package)</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.DMFXmlCompositePackageImport.UpdateSourceProperties(IDTSComponentMetaData100 flatFileSourceComponent, CManagedComponentWrapper srcFlatFileInstance, String name, 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' 'CustomerSalesOrderCompositeEntity' record(s) inserted in staging
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackageControllerCompositeEntity.CreateAndExecutePackage()
at DMFExecutePackage.PackageCreator.processCompositeEntity()
at DMFExecutePackage.Program.Main(String[] args)</Description></Error><Error><ErrorCode>-2146233088</ErrorCode><SubComponent>Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper</SubComponent><Description>DMF2060 - at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFXmlCompositePackageImport.UpdateSourceProperties(IDTSComponentMetaData100 flatFileSourceComponent, CManagedComponentWrapper srcFlatFileInstance, String name, Package _Package)
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFXmlCompositePackageImport.AddDataFlowComponent(Package _Package)</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.DMFXmlCompositePackageImport.UpdateSourceProperties(IDTSComponentMetaData100 flatFileSourceComponent, CManagedComponentWrapper srcFlatFileInstance, String name, 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' 'CustomerSalesOrderCompositeEntity' record(s) inserted in staging
I have tried going through all the Mappings on the project and everything seems to be ok, and I also tried to Export the package from production, and go through the files in it making sure that any references to the V2 entities was changed to V3
Perhaps I also have to mention that the package contains an xsl file with transforms, and I also checked that file and everything seems to be fine.
So I am kind of stuck, since the error message mentions that perhaps I am having a problem with the mappings or missing fields, but does not mention witch mappings of field might be the problem.
And I have checked in the mappings that the fields there do exist.
Is there any way of debugging the process to get som actual help to what the problem might be?
Perhaps I also have to mention that the package contains an xsl file with transforms, and I also checked that file and everything seems to be fine.
So I am kind of stuck, since the error message mentions that perhaps I am having a problem with the mappings or missing fields, but does not mention witch mappings of field might be the problem.
And I have checked in the mappings that the fields there do exist.
Is there any way of debugging the process to get som actual help to what the problem might be?
Categories:
All responses (
Answers (
