Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Data provider framework error in Microsoft Management Reporter 2012 for Dynamics GP

Data provider framework error in Microsoft Management Reporter 2012 for Dynamics GP

View products that this article applies to.

Symptoms

When you open a row definition or a column definition in Management Reporter Report Designer for Microsoft Dynamics GP, you receive the following error message:
The operation could not be completed due to a problem in the data provider framework
Additionally, one of the following events is logged in Event Viewer:

Microsoft.Dynamics.Performance.DataProvider.Core.RequestException: The source system request did not complete successfully. ---> 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.ObjectModel.KeyedCollection`2.AddKey(TKey key, TItem item)
   at System.Collections.ObjectModel.KeyedCollection`2.InsertItem(Int32 index, TItem item)
   at Microsoft.Dynamics.Performance.DataProvider.Collections.LockableKeyedCollection`2.InsertItem(Int32 index, TItem item)
   at System.Collections.ObjectModel.Collection`1.Add(T item)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.Data.AttributeElementCollection.CreateAttributeElementCollection(ChartElementCollection elementCollection, SourceSystemRepository repository)
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.GLProvider.EnsureAttributeElementsPopulated()
   at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GP.GLProvider.GetAttributes(GLAttributeRequest request)


Microsoft.Dynamics.Performance.DataProvider.Core.RequestException: The source system request did not complete successfully. ---> System.ArgumentException: An item with the same key has already been added.
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at System.Collections.ObjectModel.KeyedCollection`2.InsertItem(Int32 index, TItem item)
at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.DataMart.Data.AttributeAccess.RetrieveResultFromCache(IList`1 cacheItem, GLRequest request)
at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.DataMart.GLProvider.GetAttributes(GLAttributeRequest request)
at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.GLSystemProvider.HandleRequest(GLAttributeRequest request)
at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemRequest.Handle[TRequest](SourceSystemProvider provider, TRequest request)
at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.SubmitRequest(SourceSystemRequest request)
--- End of inner exception stack trace ---
at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.SubmitRequest(SourceSystemRequest request)
at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemProvider.HandleSubmit(SourceSystemRequest request)
at Microsoft.Dynamics.Performance.DataProvider.Core.SourceSystemConnection.Submit(SourceSystemRequest request)
at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService.SubmitRequestDirect(SourceSystemConnection connection, GLRequest request)
at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService.<>c__DisplayClass26.<SubmitRequestInternal>b__25(SourceSystemConnection glConnection)
at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkConnectionManager.UsingConnection[TResult](DataServiceConnection connection, Func`2 executor)
at Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService.SubmitRequestErrorHandler[T](Func`1 requestSubmission)
Component: Microsoft.Dynamics.Performance.Reporting.DataProvider.Server.DirectLinkService

↑ Back to the top

Cause

This problem occurs if one or more fields of the following types are blank or contain a duplicate or reserved name: 
  • A user-defined field in the General Ledger Setup window (Tools | Setup | Financial | General Ledger).
  • A Trx Dimension field in the Transaction Dimension Maintenance window (Cards | Financial | Analytical Accounting | Transaction Dimension) that has a Date Type of Alphanumeric, Numeric, or Date.
  • The following reserved attribute names:
    • Account Type
    • Account Category
    • Audit Trail Code
    • Batch ID
    • Currency ID
    • Customer ID
    • Distribution Reference
    • Employee
    • Exchange Rate
    • Item ID
    • Journal Entry
    • Originating Audit Trail Code
    • Originating Document Number
    • Originating Master Record ID
    • Originating Master Record Name
    • Originating Transaction Type
    • Reference
    • Reporting Ledger
    • Site ID
    • Source Document
    • Transaction Date
    • Vendor ID
    • Voided
    • Series
For example, the following conditions cause the error that is mentioned in the "Symptoms" section: 
  • A user-defined field is named "Reference."
  • A user-defined field is named "Customer" and an AA Dimension (Boolean) name of "Customer" already exists.

↑ Back to the top

Resolution

To resolve this problem in Dynamics GP, enter a name that is unique across the three groups that are listed in the "Cause" section, change the duplicate name to a unique name, or change the reserved name to a non-reserved name.

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2776705
Revision : 1
Created on : 1/7/2017
Published on : 9/2/2014
Exists online : False
Views : 304