Jesper M. Christensen

SharePoint and Security

A late night installing PowerPivot on an existing SharePoint 2010 Farm


“Okay, this feature should be a quick installation and afterwards I want to test my new ideas…..”

-like many products out there today this was no walk in the park either. 8 hours of troubleshooting, reading TechNet articles and blogs I finally nailed it!

I found a GREAT installation guide on installing PowerPivot for SharePoint 2010 that Cornelius J. van Dyk wrote, and I came 98% of the way.

Still I need 100% to have a working installation J

The error I constantly got was: The given key was not present in the dictionary

Digging through the log files I found an error – not a SQL Server installation issue but a result of the SharePoint Product and Services Configuration part of the installation (see the full error log last the end of the blog post):

2011-12-28 22:37:05 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: The given key was not present in the dictionary. ---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. 
2011-12-28 22:37:05 Slp: at System.ThrowHelper.ThrowKeyNotFoundException() 
2011-12-28 22:37:05 Slp: at System.Collections.Generic.Dictionary`2.get_Item(TKey key) 
2011-12-28 22:37:05 Slp: at Microsoft.SharePoint.Utilities.SPUtility.GetUserPropertyFromAD(SPWebApplication webApplicaiton, String loginName, String propertyName) 

-so I checked the permissions in Active Directory and found I have missed setting the READ flag on the SPServices and SPFarmAdmin accounts.

I followed this guide and if someone has a better solution, please advise me J

  1. Open up “Active Directory Users and Computer”
  2. Select “Advanced features” from the “View” menu
  3. Right-click the relevant account and select “Properties”
  4. Select the “Securities” Tab
  5. Scroll down and select “Authenticated users”
  6. Allow “Read” permissions
  7. Hit Ok

Afterwards I installed the PowerPivot again and it completed successfully.

Thanks again Cornelius – you lead me almost there and saved a good night’s sleep

Full error log:

2011-12-28 22:37:03 AS: Performing configuration task 3 of 3 
2011-12-28 22:37:03 AS: Finalizing the SharePoint Products configuration... 
2011-12-28 22:37:03 AS: 
2011-12-28 22:37:03 AS: Successfully completed the SharePoint Products configuration. 
2011-12-28 22:37:03 AS: 
2011-12-28 22:37:03 AS: Total number of configuration settings run: 3 
2011-12-28 22:37:03 AS: Total number of successful configuration settings: 3 
2011-12-28 22:37:03 AS: Total number of unsuccessful configuration settings: 0 
2011-12-28 22:37:03 AS: Successfully stopped the configuration of SharePoint Products. 
2011-12-28 22:37:03 AS: Configuration of the SharePoint Products has succeeded. 
2011-12-28 22:37:03 AS: Running function ConfigExistingFarmFirstASserverUseSharedService(). 
2011-12-28 22:37:03 AS: Running function GetSolutionProductVersion(). 
2011-12-28 22:37:03 AS: File name is Microsoft.AnalysisServices.SharePoint.Integration.DLL 
2011-12-28 22:37:03 AS: Found solution location in regsitry setting 
2011-12-28 22:37:03 AS: The location is C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.AnalysisServices.SharePoint.Integration.DLL. 
2011-12-28 22:37:03 AS: The product version of solution is 10.50.1600.1. 
2011-12-28 22:37:03 AS: Running function UpdateEngineServiceInstanceIMBIVersionAndUnprovisionedBySetupBit(). 
2011-12-28 22:37:03 AS: Running function GetLocalEngineServiceInstance(). 
2011-12-28 22:37:03 AS: Found Gemini Engine Service instance on current machine. 
2011-12-28 22:37:03 AS: Found Gemini Engine Service instance on current machine. 
2011-12-28 22:37:03 AS: Current IMBI version of engine service is null. It means the engine service is newly installed. It should be turned on by Setup if its version is desirable. 
2011-12-28 22:37:03 AS: Existing IMBI version is null 
2011-12-28 22:37:03 AS: CurrentIMBIVersion property of Gemini Engine Service instance on machine SHARE2010 is set to 10.50.1600.1 
2011-12-28 22:37:03 AS: Running function GetSolutionProductVersion(). 
2011-12-28 22:37:03 AS: File name is Microsoft.AnalysisServices.SharePoint.Integration.DLL 
2011-12-28 22:37:03 AS: Found solution location in regsitry setting 
2011-12-28 22:37:03 AS: The location is C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.AnalysisServices.SharePoint.Integration.DLL. 
2011-12-28 22:37:03 AS: The product version of solution is 10.50.1600.1. 
2011-12-28 22:37:03 AS: Running function UpdateMidTierServiceSolutionVersion(). 
2011-12-28 22:37:03 AS: CurrentSolutionVersion property of Gemini Mid Tier Service instance on machine is set to 10.50.1600.1. 
2011-12-28 22:37:03 AS: Entering function ChangeUserAccount() 
2011-12-28 22:37:03 AS: Switching Service Account to desired user 
2011-12-28 22:37:03 AS: Action: Failpoint id: Switching_Service_Account 
2011-12-28 22:37:03 AS: Result: Success 
2011-12-28 22:37:03 AS: Action: (Utility) Detecting Service Name 
2011-12-28 22:37:03 AS: Result: (Utility) MSOLAP$POWERPIVOT 
2011-12-28 22:37:05 AS: Exception!! 
2011-12-28 22:37:05 AS: The given key was not present in the dictionary. 
2011-12-28 22:37:05 Slp: Error: Action "Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstallFarmAction" threw an exception during execution. 
2011-12-28 22:37:05 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: The given key was not present in the dictionary. ---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. 
2011-12-28 22:37:05 Slp: at System.ThrowHelper.ThrowKeyNotFoundException() 
2011-12-28 22:37:05 Slp: at System.Collections.Generic.Dictionary`2.get_Item(TKey key) 
2011-12-28 22:37:05 Slp: at Microsoft.SharePoint.Utilities.SPUtility.GetUserPropertyFromAD(SPWebApplication webApplicaiton, String loginName, String propertyName) 
2011-12-28 22:37:05 Slp: at Microsoft.SharePoint.Administration.SPManagedAccount.GetUserAccountControl(String username) 
2011-12-28 22:37:05 Slp: at Microsoft.SharePoint.Administration.SPManagedAccount.Update() 
2011-12-28 22:37:05 Slp: at Microsoft.SharePoint.Administration.SPProcessIdentity.Update() 
2011-12-28 22:37:05 Slp: at Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIConfigExtension.ChangeUserAccount(String userName, SqlSecureString password) 
2011-12-28 22:37:05 Slp: at Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstallFarmAction.ConfigExistingFarmFirstASServerUseSharedService() 
2011-12-28 22:37:05 Slp: at Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstallFarmAction.ExecuteAction(String actionId) 
2011-12-28 22:37:05 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream) 
2011-12-28 22:37:05 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun) 
2011-12-28 22:37:05 Slp: --- End of inner exception stack trace --- 
2011-12-28 22:37:05 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun) 
2011-12-28 22:37:05 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream) 
2011-12-28 22:37:05 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream) 
2011-12-28 22:37:05 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream) 
2011-12-28 22:37:05 Slp: The configuration failure category of current exception is ConfigurationFailure 
2011-12-28 22:37:05 Slp: Watson Bucket 1 
 Original Parameter Values 
2011-12-28 22:37:05 Slp: Parameter 0 : SQL Server 2008 R2@RTM@ 
2011-12-28 22:37:05 Slp: Parameter 1 : Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper 
2011-12-28 22:37:05 Slp: Parameter 2 : System.ThrowHelper.ThrowKeyNotFoundException 
2011-12-28 22:37:05 Slp: Parameter 3 : Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException@1203@1 
2011-12-28 22:37:05 Slp: Parameter 4 : System.Collections.Generic.KeyNotFoundException@-2146232969 
2011-12-28 22:37:05 Slp: Parameter 5 : ASSPIInstallFarmAction 
2011-12-28 22:37:05 Slp: Parameter 6 : INSTALL@STARTUPFINALIZE@ANALYSIS_SERVER_SPI 
2011-12-28 22:37:05 Slp: 
 Final Parameter Values 
2011-12-28 22:37:05 Slp: Parameter 0 : SQL Server 2008 R2@RTM@ 
2011-12-28 22:37:05 Slp: Parameter 1 : 0xD42B86D4 
2011-12-28 22:37:05 Slp: Parameter 2 : 0xA0A72FEE 
2011-12-28 22:37:05 Slp: Parameter 3 : 0x30E00066@1203@1 
2011-12-28 22:37:05 Slp: Parameter 4 : 0xD05BC945 
2011-12-28 22:37:05 Slp: Parameter 5 : ASSPIInstallFarmAction 
2011-12-28 22:37:05 Slp: Parameter 6 : 0x0FF251A7 
2011-12-28 22:37:09 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111228_222512\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_ 
2011-12-28 22:37:09 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111228_222512\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_ 
2011-12-28 22:37:09 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111228_222512\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_ 
2011-12-28 22:37:09 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111228_222512\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_ 
2011-12-28 22:37:09 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111228_222512\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_ 
2011-12-28 22:37:09 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111228_222512\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_ 
2011-12-28 22:37:12 Slp: The given key was not present in the dictionary. 
2011-12-28 22:37:14 Slp: Watson bucket for exception based failure has been created 
2011-12-28 22:37:14 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()Error: Action "ASSPI_Install_ASSPIInstallStartupFinalize_Cpu64" failed during execution.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: