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>
