web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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

I have the same question (0)
  • Suggested answer
    CFROTON Profile Picture
    4,710 on at

    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

  • Verified answer
    John_Joyce Profile Picture
    1,042 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans