An item with the same key has already been added with AX2012 and SSRS
Had a bit of a panic today, while trying to post invoices we getting the following error in AX2012 Infolog.
”
An item with the same key has already been added”
We worked out (thanks MS Support) that we was able to post the invoices if we turned off printing.
To fix the problem we tried to restart the AOS that was running WCF interface talking to SSRS, but that did nothing.
THE FIX> We had to redeployed the offending report from the AOT, this fixed the problem. The thinking is that report and AOS meta data out of sync.
If you have this same problem, you should be able to find the logs on SSRS server
”
webserver!ReportServer_0-12!598!03/01/2012-17:57:57:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. —-> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. —-> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ‘PurchPurchaseOrderDS’. —-> System.ArgumentException: An item with the same key has already been added.
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at System.Collections.Generic.Dictionary`2.Add(TKey key, TValue value)
at Microsoft.Dynamics.Framework.Reports.SetQueryProjectionVisitor.ProcessQueryFieldMetadata(AxQuerySchemaAnalysisElement fieldElement, QueryFieldMetadata queryField)
…
“
#AX2012 #SSRS
