Installation Troubleshooting Guide

Pre-requisites

If you install PowerSSAS on a computer with the SQL Server client tools, you will have everything it needs. If the computer does not have the SQL Server client tools you would need to install the AMO library and ADOMD.NET. (search for the "SQL Server Feature Pack" in your favourite search engine and you should be able to find the downloads for these)

Installation

There are two stages to the install of PowerSSAS:
  1. the files are unpacked and copied to a location on your computer (usuall c:\program files\powerssas)
  2. the snapin is registered using the .net installutil utility
I suspect that it is in stage 2. where something has gone wrong. In the install folder there should be some log files created, if there was an issue it should be listed in one of those.

Otherwise you could try running the installutil manually from the command line and see if it prints any error messages

if you navigate to "c:\windows\microsoft.net\framework\v2.0.50727" and then execute:

installutil "c:\program files\powerssas\powerssas.dll"

This should register the snapin, or print an error message if there is an issue. If there are any errors that you can't figure out please post them to the discussions area. If the registration has suceeded you should be able to run get-pssnapin -registered from a pwershell window and see that powerSSAS is listed. If you can see powerSSAS listed as a registered snapin you should be able to mount drives and use all the cmdlets.

Last edited Jun 29, 2009 at 1:45 AM by dgosbell, version 1

Comments

gaichholzer Apr 23, 2010 at 12:44 PM 
I have just received the same error and think this is because on my machine only SSAS 2008 is installed, but powerSSAS still refers to SSAS 2005 assemblies. At least this is what I guess from the Fusion log tool's output:

*** Assembly Binder Log Entry (23.4.2010 @ 13:36:37) ***

The operation failed.
Bind result: hr = 0x80070002. The system cannot find the file specified.

Assembly manager loaded from: C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll
Running under executable C:\windows\microsoft.net\framework\v2.0.50727\InstallUtil.exe
--- A detailed error log follows.

=== Pre-bind state information ===
LOG: User = ...
LOG: DisplayName = Microsoft.AnalysisServices, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
(Fully-specified)
LOG: Appbase = file:///C:/windows/microsoft.net/framework/v2.0.50727/
LOG: Initial PrivatePath = NULL
LOG: Dynamic Base = NULL
LOG: Cache Base = NULL
LOG: AppName = NULL
Calling assembly : powerSSAS, Version=0.3.0.0, Culture=neutral, PublicKeyToken=null.
===
LOG: This bind starts in LoadFrom load context.
WRN: Native image will not be probed in LoadFrom context. Native image will only be probed in default load context, like with Assembly.Load().
LOG: No application configuration file found.
LOG: Using machine configuration file from C:\Windows\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Post-policy reference: Microsoft.AnalysisServices, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
LOG: GAC Lookup was unsuccessful.
LOG: Attempting download of new URL file:///C:/windows/microsoft.net/framework/v2.0.50727/Microsoft.AnalysisServices.DLL.
LOG: Attempting download of new URL file:///C:/windows/microsoft.net/framework/v2.0.50727/Microsoft.AnalysisServices/Microsoft.AnalysisServices.DLL.
LOG: Attempting download of new URL file:///C:/windows/microsoft.net/framework/v2.0.50727/Microsoft.AnalysisServices.EXE.
LOG: Attempting download of new URL file:///C:/windows/microsoft.net/framework/v2.0.50727/Microsoft.AnalysisServices/Microsoft.AnalysisServices.EXE.
LOG: Attempting download of new URL file:///c:/program files (x86)/powerssas 2008/Microsoft.AnalysisServices.DLL.
LOG: Attempting download of new URL file:///c:/program files (x86)/powerssas 2008/Microsoft.AnalysisServices/Microsoft.AnalysisServices.DLL.
LOG: Attempting download of new URL file:///c:/program files (x86)/powerssas 2008/Microsoft.AnalysisServices.EXE.
LOG: Attempting download of new URL file:///c:/program files (x86)/powerssas 2008/Microsoft.AnalysisServices/Microsoft.AnalysisServices.EXE.
LOG: All probing URLs attempted and failed.

dgosbell Apr 20, 2010 at 1:09 AM 
Could you possibly trying running the Fusion log tool as described in this thread on the Powershell community extensions site http://pscx.codeplex.com/Thread/View.aspx?ThreadId=7117 The error seems to indicate that there is something wrong with one of the dependancies, but if BIDS and SSMS are working fine on that machine I can't think what the issue could be.

karolko Apr 19, 2010 at 12:08 PM 
I have all workstation components insalled with SSMS and BI studio. This is my BI server with all SQL components and tools installed. I have no problems connecting to SSAS from any tools so I assume that AMO is all well.
this is the error from install log.

Installing assembly 'C:\Program Files\powerSSAS 2008\powerSSAS.dll'.
Affected parameters are:
logtoconsole =
assemblypath = C:\Program Files\powerSSAS 2008\powerSSAS.dll
logfile = C:\Program Files\powerSSAS 2008\powerSSAS.InstallLog
An exception occurred while trying to find the installers in the C:\Program Files\powerSSAS 2008\powerSSAS.dll assembly.
System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
Aborting installation for C:\Program Files\powerSSAS 2008\powerSSAS.dll.
Rolling back assembly 'C:\Program Files\powerSSAS 2008\powerSSAS.dll'.
Affected parameters are:
logtoconsole =
assemblypath = C:\Program Files\powerSSAS 2008\powerSSAS.dll
logfile = C:\Program Files\powerSSAS 2008\powerSSAS.InstallLog
An exception occurred while trying to find the installers in the C:\Program Files\powerSSAS 2008\powerSSAS.dll assembly.
System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
Aborting installation for C:\Program Files\powerSSAS 2008\powerSSAS.dll.

dgosbell Apr 16, 2010 at 1:51 AM 
Does the server you are installing on to have either the client tools for Analysis Services or the AMO library from the feature pack page installed? (see here from the latest feature pack downloads as of the time of this posting: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4)

I am guessing that the error about loading types is possibly because AMO or ADOMD.NET cannot be found. Can you check that you have both of these installed on the machine that you are trying to run powerSSAS from? I ususally load powerSSAS on a machine with the client tools so it has both of these libraries already installed.

karolko Apr 15, 2010 at 5:25 AM 
This is what I get on Server 2008. I have UAC disabled. Any suggiestions are appreciated.

C:\Windows\Microsoft.NET\Framework\v2.0.50727>installutil "C:\Program Files\powerSSAS 2008\powerSSAS
.dll"
Microsoft (R) .NET Framework Installation utility Version 2.0.50727.4016
Copyright (c) Microsoft Corporation. All rights reserved.


Running a transacted installation.

Beginning the Install phase of the installation.
See the contents of the log file for the C:\Program Files\powerSSAS 2008\powerSSAS.dll assembly's pr
ogress.
The file is located at C:\Program Files\powerSSAS 2008\powerSSAS.InstallLog.
Installing assembly 'C:\Program Files\powerSSAS 2008\powerSSAS.dll'.
Affected parameters are:
logtoconsole =
assemblypath = C:\Program Files\powerSSAS 2008\powerSSAS.dll
logfile = C:\Program Files\powerSSAS 2008\powerSSAS.InstallLog
An exception occurred while trying to find the installers in the C:\Program Files\powerSSAS 2008\pow
erSSAS.dll assembly.
System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Re
trieve the LoaderExceptions property for more information.
Aborting installation for C:\Program Files\powerSSAS 2008\powerSSAS.dll.

An exception occurred during the Install phase.
System.InvalidOperationException: Unable to get installer types in the C:\Program Files\powerSSAS 20
08\powerSSAS.dll assembly.
The inner exception System.Reflection.ReflectionTypeLoadException was thrown with the following erro
r message: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property
for more information..

The Rollback phase of the installation is beginning.
See the contents of the log file for the C:\Program Files\powerSSAS 2008\powerSSAS.dll assembly's pr
ogress.
The file is located at C:\Program Files\powerSSAS 2008\powerSSAS.InstallLog.
Rolling back assembly 'C:\Program Files\powerSSAS 2008\powerSSAS.dll'.
Affected parameters are:
logtoconsole =
assemblypath = C:\Program Files\powerSSAS 2008\powerSSAS.dll
logfile = C:\Program Files\powerSSAS 2008\powerSSAS.InstallLog
An exception occurred while trying to find the installers in the C:\Program Files\powerSSAS 2008\pow
erSSAS.dll assembly.
System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Re
trieve the LoaderExceptions property for more information.
Aborting installation for C:\Program Files\powerSSAS 2008\powerSSAS.dll.
An exception occurred during the Rollback phase of the System.Configuration.Install.AssemblyInstalle
r installer.
System.InvalidOperationException: Unable to get installer types in the C:\Program Files\powerSSAS 20
08\powerSSAS.dll assembly.
The inner exception System.Reflection.ReflectionTypeLoadException was thrown with the following erro
r message: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property
for more information..
An exception occurred during the Rollback phase of the installation. This exception will be ignored
and the rollback will continue. However, the machine might not fully revert to its initial state aft
er the rollback is complete.

The Rollback phase completed successfully.

The transacted install has completed.
The installation failed, and the rollback has been performed.

C:\Windows\Microsoft.NET\Framework\v2.0.50727>