SharePoint 2010 - PerformancePoint Service Application- An entry with the same key already exists

  • Article

Another interesting issue i have worked couple of months back, thought of sharing it with all Smile. Customer was trying to setup the performance point on the production environment and ran into the issue while configuring the “Unattended account”.

Environment:

Single Server farm.
SP 2010 Enterprise Edition

Issue:

1. Users were not able to connect to the performance point site using SharePoint designer, were getting the following error:

image001 (2)

2. Couldn’t configure the unattended service account for PerformancePoint service application. Getting an error “An entry with the same key already exists”

 

image

 

Solution:

1. Analysed the verbose logs and found the following information:

w3wp.exe (0x31A0) 0x36E4 SharePoint Foundation Runtime tkau Unexpected System.ArgumentException: An entry with the same key already exists. at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource) at System.Collections.Generic.SortedList`2.Add(TKey key, TValue value) at Microsoft.PerformancePoint.Scorecards.AdminUI.AdminUIHelper.GetProxiesConnectedByServiceApplication(BIMonitoringServiceApplication srviceApplication) at Microsoft.PerformancePoint.Scorecards.AdminUI.CreatePpsMAServiceAppData.HasADefaultProxy(BIMonitoringServiceApplication srviceApplication) at Microsoft.PerformancePoint.Scorecards.AdminUI.CreatePpsMAServiceAppData.UpdateUIForEditingMode() at Microsoft.PerformancePoint.Scorecards.AdminUI.CreatePpsMAServiceAppData.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.Pro... 7f42bbc7-e934-4e5e-9ada-38a5fc39fee5

w3wp.exe (0x31A0) 0x36E4 SharePoint Foundation Runtime tkau Unexpected ...cessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 7f42bbc7-e934-4e5e-9ada-38a5fc39fee5

2. Since its a new performance point setup decided to delete and recreate the for the performance point and Secure store SSA.

3.  Used the following STSADM command lines to stop and start the services: Performance Point service (PPS)  and Secure store services (SSS):

Stsadm -o provisionservice -action stop -servicetype "Microsoft.Office.SecureStoreService.Server.SecureStoreService, Microsoft.Office.SecureStoreService, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"

stsadm -o provisionservice -action stop -servicetype "Microsoft.PerformancePoint.Scorecards.BIMonitoringService, Microsoft.PerformancePoint.Scorecards.BIMonitoringService, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"

stsadm -o provisionservice -action start -servicetype "Microsoft.Office.SecureStoreService.Server.SecureStoreService, Microsoft.Office.SecureStoreService, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"

stsadm -o provisionservice -action start -servicetype "Microsoft.PerformancePoint.Scorecards.BIMonitoringService, Microsoft.PerformancePoint.Scorecards.BIMonitoringService, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"

5. Created the SSSA ( Secure store service application) Application and generated the new Key with the Passphrase.

6· Created the PPS application and ran the following commands to configure the unattended service accounts “Domain\username” :

Set-SPPerformancePointSecureDataValues

Get-SPPerformancePointSecureDataValues

7. Verified that the Unattended service account got created successfully on Secure store for PPS.

8.  Ran the following commands to grant access for PPS Application pool account on content databases:

$w = Get-SPWebApplication(“https://intranet”)

$w.GrantAccessToProcessIdentity("DOMAIN\USERNAME")

$w = Get-SPWebApplication(“https://myhub”)

$w.GrantAccessToProcessIdentity("DOMAIN\USERNAME")

9. Verified the users able to connect to the BI site using the SharePoint designer!

Cheers!

 

Bala