PowerPivot SharePoint Integration Install Bug


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 (4)

  1. BJ Miller says:

    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.

  2. wq says:

    http://www.michaelkorsoutlets-online.us.com/
    http://www.pandora-charms-canada.ca/ and
    http://www.the-north-face.ca/
    http://www.nikeshoesoutlet.org.uk/ it
    http://www.ralphlaurenoutlet.us.com/
    http://www.tiffany-jewelry.in.net/ covers
    http://www.thejoreseproject.com/
    http://www.rolex-watches-canada.ca/ the
    http://www.uggbootsclearance.com.co/ http://www.yoga-pants.ca/ following
    http://www.northfaceoutlet.com.co/
    http://www.truereligionjeans.net.co/ points:
    http://www.nike-air-max.com.au/
    http://www.toms–outlet.com.co/ ManagingMany
    http://www.oakley-outletstore.us.com/
    http://www.ralph-laurenoutlet.co.uk/ of
    http://www.ugg-boots-australia.com.au/
    http://www.guccihandbags.net.co/ you
    http://www.marcjacobs.us.com/ http://www.reebok.com.de/ new
    http://www.uptocoachoutlet.com/
    http://www.cheapoakleysunglasses.ar.com/ SQL
    http://www.louis-vuitton-taschen.com.de/
    http://www.nfl-jersey.us.com/ Server http://www.new-balance.ca/
    http://www.nike-air-force.de/ DBAs
    http://www.ralph-laurenoutlet.ca/
    http://www.true-religion.com.co/ may
    http://www.the-tnfjackets.us.com/ http://www.jimmychoo.net.co/ be
    http://www.adidas.com.se/
    http://www.basketballshoes.com.co/ wondering
    http://www.michael-kors.com.co/
    http://www.longchampoutlet.com.co/ what
    http://www.swarovski-australia.com.au/
    http://www.cheap-baseballbats.net/ are
    http://www.jordanrelease-dates.us.com/
    http://www.outletonline-michaelkors.com/ the
    http://www.newbalance-outlet.org/ http://www.longchamp.com.co/ things
    http://www.ray–ban.ca/
    http://www.hollister.us.org/ to http://www.uhren-shop.com.de/
    http://www.louis-vuittonblackfriday.com/ lookout
    http://www.chanel-bags.com.co/
    http://www.tnfjackets.us.com/ for http://www.nikefree-run.net/
    http://www.ray-ban-sunglasses-outlet.in.net/ to
    http://www.pradahandbags.net.co/
    http://www.poloralphlaurenoutlet.net.co/ effectively
    http://www.barbour-factory.com/ http://www.pradaoutlet.com.co/ maintain
    http://www.michael-kors.com.es/
    http://www.moncler-outlet.us.org/ a
    http://www.ralphlaurenoutlet-online.us.com/
    http://www.burberryoutletonlinesale.in.net/ production
    http://www.weddingdressesuk.org.uk/
    http://www.louisvuitton.jp.net/ SQL
    http://www.bebeclothing.in.net/ http://www.prada.com.de/ Server
    http://www.hilfigeroutlet.in.net/
    http://www.abercrombieand-fitch.ca/ database.
    http://www.celine-bags.org/