Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

MR Integration error - "An item with the same key has already been added"

(0) ShareShare
ReportReport
Posted on by 1,042

We have a new SL2018 environment and we're trying to create the MR 2012/CU16 Data Mart, but keep getting this error message:

"An item with the same key has already been added". 

Has anyone seen this before?

The Windows Event Viewer shows the following:

- System
- Provider
[ Name] Management Reporter 2012 Services
- EventID 0
[ Qualifiers] 0
Level 2
Task 0
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2019-10-28T13:02:51.990085500Z
EventRecordID 9838
Channel Application
Computer SLDYN2018SVR.domain.local
Security

- EventData

Service cannot be started.
Microsoft.Dynamics.Performance.Reporting.Scheduler.SchedulerBootstrapper+SchedulerBootstrapper
Exception: Database validation failed, the scheduler service could not be started. at Microsoft.Dynamics.Performance.Reporting.Scheduler.SchedulerBootstrapper.
CreateAndStartScheduler() at Microsoft.Dynamics.Performance.Reporting.Scheduler.
SchedulerService.OnStart() at Microsoft.Dynamics.Performance.Common.ServiceComponent.
StateChangeHandler(RequestedStateChange requestedState) at Microsoft.Dynamics.Performance.Common.ServiceComponent.
<Load>b__9_0(RequestedStateChange s) at Microsoft.Dynamics.Performance.Common.StateProxy.OnStateChange
Requested(RequestedStateChange state) at Microsoft.Dynamics.Performance.Reporting.ServiceHost.ServiceCreator.
Start() at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

Thanks

John

  • Verified answer
    John_Joyce Profile Picture
    1,042 on at
    RE: MR Integration error - "An item with the same key has already been added"

    Thanks Carolyn/Jana (Header of reply says Carolyn, signature say Jana?).  Indeed, it was duplicate description in the FlexKey table that was causing the error and we have since resolved it and successfully created our MR>SL integration.

    John

  • Suggested answer
    CFROTON Profile Picture
    4,710 on at
    RE: MR Integration error - "An item with the same key has already been added"

    Hello John,

    In SQL Mgt Studio, run this against each SL application database:

    select Descr00, Descr01, Descr02, Descr03, Descr04, Descr05, Descr06, Descr07 from FlexDef where FieldClassName = 'SUBACCOUNT'

    Make sure you don’t have any two segments with the same description. For example, if you have a 4 segment subaccount, you will have values in Descr00, Descr01, Descr02 and Descr03. You don’t want any of those to be blank, and you don’t want any of them to be the same. It’s OK for there to be blanks in segments you are not using. As an example, if you have a six segment subaccount, it’s OK for Descr06 and Descr07 to be blank, but not the descriptions for the six segments that you are using. We don’t want any of those to be the same. So if Descr00 is “Reporting Unit”, then Descr02 cannot also be “Reporting Unit.

    Best Regards,

    Jana MacDonald

    MS dynamics sl support

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Product updates

Dynamics 365 release plans