Powerpivot Install Failure - Type Initializer threw an exception

Question

I'm doing a single server install on a development server with complete and farm settings choosen, SQL 2008 R2 and OS 2008 R2.   Using the new server install method - not adding to an existing farm.     Fails when creating the default service application.    The error is

 

The type initializer for 'Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplication' threw an exception. ---> System.NullReferenceException: Object reference not set to an instance of an object.

I've been round and round with this. At least 15 attempts to install with little tweaks here and there.   I've had this issue before on the same server the first time I installed sharepoint 2010 with powerpivot.   At that time I found a web site where someone had a similar problem because Microsoft Office was installed on the server.  I uninstalled office and the sharepoint installed fine.    Office is not on the server this time.   The server also had visual studio 2010 on it - I've removed that also and followed instructions I found for ensuring a complete removal of both.

I've tried doing the install with and without installing the sharepoint service pack 1 and a hotfix I found.  Same result. 

I've been unable to find anything on the internet or MSDN forum with this particular error regarding the type initialize.

I removed sharepoint 2010 because I needed to install sharepoint 2007 temporarily.  So I'm wondering if there is something left laying around from that installation causing the problem.   I can't find it if there is. 

It works without error to install sharepoint not via powerpivot. 

Below is the entire detail log entry for the default service application.

Thanks,

David

   

2012-02-27 02:13:50 AS: Running function CreateDefaultServiceApplication()

2012-02-27 02:13:50 AS: Check whether service application is created already or not.

2012-02-27 02:13:50 AS: Gemini Service applicaiton does not exist in the farm. Creating Gemini Service Application...

2012-02-27 02:13:50 AS: Default Service Application Could not be created. Reason:The type initializer for 'Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplication' threw an exception.

2012-02-27 02:13:50 Slp: Error: Action "Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstallFarmAction" threw an exception during execution.

2012-02-27 02:13:50 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: The type initializer for 'Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplication' threw an exception. ---> System.TypeInitializationException: The type initializer for 'Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplication' threw an exception. ---> System.NullReferenceException: Object reference not set to an instance of an object.

2012-02-27 02:13:50 Slp:    at Microsoft.AnalysisServices.SharePoint.Integration.ASSPIConfigExtension.RevisionIndependentVersionCompare(Version v1, Version v2)

2012-02-27 02:13:50 Slp:    at Microsoft.AnalysisServices.SharePoint.Integration.ASSPIConfigExtension.IsEngineVersionUpToDate(Version& imbiVersion, Version& diskVersion)

2012-02-27 02:13:50 Slp:    at Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplication..cctor()

2012-02-27 02:13:50 Slp:    --- End of inner exception stack trace ---

2012-02-27 02:13:50 Slp:    at Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplication.Create(String name, MidTierService service, SPDatabaseParameters databaseParameters, SPIisWebServiceApplicationPool appPool)

2012-02-27 02:13:50 Slp:    at Microsoft.AnalysisServices.SharePoint.Integration.MidTierService.CreateApplicationAndProxy(String applicationName, SPDatabaseParameters databaseParameters, Boolean addToDefaultProxyGroup, SPIisWebServiceApplicationPool appPool)

2012-02-27 02:13:50 Slp:    at Microsoft.AnalysisServices.SharePoint.Integration.MidTierService.CreateApplicationAndProxy(String applicationName, SPDatabaseParameters databaseParameters, Boolean addToDefaultProxyGroup)

2012-02-27 02:13:50 Slp:    at Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIConfigExtension.CreateDefaultServiceApplication(String databaseServerName)

2012-02-27 02:13:50 Slp:    at Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstallFarmAction.ConfigureNewFarm()

2012-02-27 02:13:50 Slp:    at Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstallFarmAction.ExecuteAction(String actionId)

2012-02-27 02:13:50 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

2012-02-27 02:13:50 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)

2012-02-27 02:13:50 Slp:    --- End of inner exception stack trace ---

2012-02-27 02:13:50 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)

2012-02-27 02:13:50 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)

2012-02-27 02:13:50 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)

2012-02-27 02:13:50 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

2012-02-27 02:13:50 Slp: The configuration failure category of current exception is ConfigurationFailure

2012-02-27 02:13:50 Slp: Watson Bucket 1

 Original Parameter Values

2012-02-27 02:13:50 Slp: Parameter 0 : SQL Server 2008 R2@RTM@

2012-02-27 02:13:50 Slp: Parameter 1 : Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplication.Create

2012-02-27 02:13:50 Slp: Parameter 2 : Microsoft.AnalysisServices.SharePoint.Integration.ASSPIConfigExtension.RevisionIndependentVersionCompare

2012-02-27 02:13:50 Slp: Parameter 3 : System.TypeInitializationException@-2146233036

2012-02-27 02:13:50 Slp: Parameter 4 : System.NullReferenceException@-2147467261

2012-02-27 02:13:50 Slp: Parameter 5 : ASSPIInstallFarmAction

2012-02-27 02:13:50 Slp:

 Final Parameter Values

2012-02-27 02:13:50 Slp: Parameter 0 : SQL Server 2008 R2@RTM@

2012-02-27 02:13:50 Slp: Parameter 1 : 0xF35C693F

2012-02-27 02:13:50 Slp: Parameter 2 : 0xAE7B08DA

2012-02-27 02:13:50 Slp: Parameter 3 : 0xABC67CAB

2012-02-27 02:13:50 Slp: Parameter 4 : 0x44A889F9

2012-02-27 02:13:50 Slp: Parameter 5 : ASSPIInstallFarmAction

2012-02-27 02:13:53 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\20120227_012956\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_

2012-02-27 02:13:53 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\20120227_012956\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_

2012-02-27 02:13:53 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120227_012956\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_

2012-02-27 02:13:53 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\20120227_012956\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_

2012-02-27 02:13:53 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\20120227_012956\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_

2012-02-27 02:13:53 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120227_012956\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_

2012-02-27 02:13:57 Slp: The type initializer for 'Microsoft.AnalysisServices.SharePoint.Integration.GeminiServiceApplication' threw an exception.

2012-02-27 02:13:57 Slp: Watson bucket for exception based failure has been created

2012-02-27 02:13:57 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()Error: Action "ASSPI_Install_ASSPIInstallStartupFinalize_Cpu64" failed during execution.

2012-02-27 02:13:57 Slp: Completed Action: ASSPI_Install_ASSPIInstallStartupFinalize_Cpu64, returned False

Answer 1

Hi,

Can you confirm that you are not setting up powerpivot on a standalone farm. PowerPivot for SharePoint is not supported on a standalone farm.
 Besides, please refer to below links for some possible cause and workaround of the issue:

http://social.msdn.microsoft.com/Forums/ar-SA/sqlkjpowerpointforsharepoint/thread/dd119dca-961b-4e8f-83a0-bba5c9ef81df
http://social.technet.microsoft.com/Forums/en-GB/sharepoint2010setup/thread/26632115-2479-4e54-b828-ff9e13ea0a5e

Thanks,

---

Challen Fu

TechNet Community Support

Answer 2

Thanks for the reply.

It is all on one server but not a standalone farm.  Installed choosing "complete".   It was working on this server before.  I've been through the first link you include over and over again and eliminated all of those issues as a possible cause.    The second like I'm not sure how it applies.