Error when importing a data package via Logic Apps

(6) Share

Report

Posted on by joelhtown80

Hi all,

I have a logic app that runs every 15 minutes and uploading 5 packages to F&O for import to General Ledger. I have successfully imported 200 packages so far but encountered an error on 2 packages. I re-ran the logic app to upload these 2 packages the second time and it was successful. Any idea why these errors happened and how to avoid it?

Here are the error details

Package 1 error:

SSIS package validation failed. Check execution log for details.
<?xml version="1.0"?><Errors><Error><ErrorCode>-1073450823</ErrorCode><SubComponent>SSIS.Pipeline</SubComponent><Description>"Flat File Source.Outputs[Flat File Source Output]" contains no output columns. An asynchronous output must contain output columns.
</Description></Error><Error><ErrorCode>-1073450996</ErrorCode><SubComponent>SSIS.Pipeline</SubComponent><Description>One or more component failed validation.
</Description></Error><Error>

Package 2 error:

Error adding columns to derived component
<?xml version="1.0"?><Errors><Error><ErrorCode>-2146233088</ErrorCode><SubComponent>Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper</SubComponent><Description>DMF021 - at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackage.AddColumnsToCopyComponent(IDTSComponentMetaData100 sqlDestinationDerivedComponent, List`1 lstEntColumn, CManagedComponentWrapper destSqlDestinationDerivedInstance, Dictionary`2 copyColumns, String decimalSeperator, String dateSeperator)
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFFlatFilePackageImport.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>-2146232969</ErrorCode><SubComponent>mscorlib</SubComponent><Description>The given key was not present in the dictionary. - at System.ThrowHelper.ThrowKeyNotFoundException()
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackage.EnumValueMapping(String colName, Int32 colSize, String staginColumn)
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackage.AddColumnsToCopyComponent(IDTSComponentMetaData100 sqlDestinationDerivedComponent, List`1 lstEntColumn, CManagedComponentWrapper destSqlDestinationDerivedInstance, Dictionary`2 copyColumns, String decimalSeperator, String dateSeperator)</Description></Error></Errors>

I have the same question (1)

All responses (5)

Answers (0)

Sort by

Anthony Blake 3,181 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Did you get these errors on a Cloud Hosted dev environment, or an MS hosted Tier 2+ Sandbox/Add-on?

Thanks

Anthony

Was this reply helpful? Yes No
deenairn 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Was a solution ever found to this? We are experiencing similar issues whenever loading DMF packages concurrently, although I cannot find any guidance about the maximum number of packages that can be uploaded consecutively.

Was this reply helpful? Yes No
Jonas "Jones&q... 5,016 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@deenairn it's an old thread, you might get a faster response if you create a new question.

Regardless: I don't recall there being any documentation of limitations of DMF, so as @Anthony Blake mentions I'd try to debug it in a development environment (I'd advice you try in a CHE/VHD environment if you have one, as you have access to the Windows event viewer).

Was this reply helpful? Yes No
joelhtown80 32 on at

Like
a
(1)

Report
Copy link

Link copied!

This has never been resolved. As a workaround, I created a retry step in the Logic App whenever this error occurs.

@Anthony Blake, I got the error from MS hosted Tier 2+ Sandbox/Add-on.

Was this reply helpful? Yes No
RY-22061731-0 6 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello @Dynamics365Community
Even I have the same issue, Anyone knows the solution?
Is it a file issue inside the dataproject ? Its an technical issue in d365?

I can see the error details in MS document -

0xC00470B9
-1073450823 DTS_E_NOOUTPUTCOLUMNS "%1" contains no output columns. An asynchronous output must contain output columns.

But unable to find the real root cause.

{
"DataProjectName": "**********************",
"LegalEntity": "****",
"ExecutionId": "************************",
"ErrorMessage": "[{\"RecordId\":\"\",\"Field\":\"\",\"ErrorMessage\":\"\n<?xml version=\"1.0\"?><Errors><Error><ErrorCode>-1073450823</ErrorCode><SubComponent>SSIS.Pipeline</SubComponent><Description>\"Flat File Source.Outputs[Flat File Source Output]\" contains no output columns. An asynchronous output must contain output columns.\r\n</Description></Error><Error><ErrorCode>-1073450996</ErrorCode><SubComponent>SSIS.Pipeline</SubComponent><Description>One or more component failed validation.\r\n</Description></Error><Error><ErrorCode>-1073594105</ErrorCode><SubComponent></SubComponent><Description>There were errors during task validation.\r\n</Description></Error></Errors>\nSSIS package validation failed. Check execution log for details.\"}]",
"D365ExecutionStatus": "Failed"
}

Was this reply helpful? Yes No