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,040

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
    John_Joyce 1,040 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
    CFROTON 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans