All things Data Related....

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data

PowerPivot SharePoint Integration Install Bug

PowerPivot SharePoint Integration Install Bug

  • Comments 3
  • Likes

I have recently been doing a lot of work with PowerPivot, and installing it at customers site. I have on two occasions now come across the below error message:

 

PowrPivotInstallErrormessage_instanceofanobject_IMBI

 

Error: Your SQL Server 2008 R2 installation completed with failures.
            Object reference not set to an instance of an object.

When you view the detail.txt error log, check to see if you see the below towards the bottom of the log:

2010-08-20 14:03:38 AS: Updating IMBI Version of Engine Service instance on local machine failed. Reason:Object reference not set to an instance of an object.
2010-08-20 14:03:38 Slp: Error: Action "Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstallFarmAction" threw an exception during execution.
2010-08-20 14:03:38 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object.
2010-08-20 14:03:38 Slp:    at Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIConfigExtension.UpdateEngineServiceInstanceIMBIVersionAndUnprovisionedBySetupBit(Version imbiVersion)
2010-08-20 14:03:38 Slp:    at Microsoft.SqlServer.Configuration.AnalysisServices.ASSPIInstallFarmAction.ConfigExistingFarmFirstASServerUseSharedService()

Then you are experiencing a setup bug. Based on the couple of installs where I have experienced the issue, the above error is experienced when you have installed the SQL Server shared files on any other drive except C:. This is even if the case was for other SQL Serve instance instances, as the Shared directory is shared amongst all instances.

Workaround: To rectify this issue, I manually created the directory (shared directory at the following location - C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies) and ensured that the Microsoft.AnalysisServices.SharePoint.Integration.DLL file exists. After this I reran the setup and it worked fine.

Comments
  • ty!

  • ty!

  • My goodness, THANK YOU for this post! I had been searching for a week and tried multiple other solutions that didn't work. Thank you.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment