This project has moved and is read-only. For the latest updates, please go here.

Installation Issues (Windows Server 2008 R2/SQL Server 2008 R2)

Apr 21, 2011 at 7:10 PM

I have downloaded the latest release 0.3.1.1 installer and, unfortunately, was not able to complete the installation (log file below).

I also attempted to manually install and register the module; however, it failed as well.  I copied the module files into the required directory and then ran 'import-module powerSSAS' command.  No errors were yielded.  However, the command 'Get-ASConnection localhost' failed with the following error:

Get-ASConnection : The SelectCommand property has not been initialized before calling 'Fill'.
At line:1 char:17
+ Get-ASConnection <<<<  localhost
    + CategoryInfo          : NotSpecified: (:) [Get-ASConnection], InvalidOperationException
    + FullyQualifiedErrorId : System.InvalidOperationException,Gosbell.PowerSSAS.Cmdlets.CmdletGetASConnection
Log file:
Running a transacted installation.
Beginning the Install phase of the installation.
See the contents of the log file for the C:\Program Files (x86)\powerSSAS 2008\powerSSAS.dll assembly's progress.
The file is located at C:\Program Files (x86)\powerSSAS 2008\powerSSAS.InstallLog.
An exception occurred during the Install phase.
System.InvalidOperationException: Unable to get installer types in the C:\Program Files (x86)\powerSSAS 2008\powerSSAS.dll assembly.
The inner exception System.Reflection.ReflectionTypeLoadException was thrown with the following error 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 (x86)\powerSSAS 2008\powerSSAS.dll assembly's progress.
The file is located at C:\Program Files (x86)\powerSSAS 2008\powerSSAS.InstallLog.
An exception occurred during the Rollback phase of the System.Configuration.Install.AssemblyInstaller installer.
System.InvalidOperationException: Unable to get installer types in the C:\Program Files (x86)\powerSSAS 2008\powerSSAS.dll assembly.
The inner exception System.Reflection.ReflectionTypeLoadException was thrown with the following error 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 after the rollback is complete.
The Rollback phase completed successfully.
The transacted install has completed.
Running a transacted installation.
Beginning the Install phase of the installation.
See the contents of the log file for the C:\Program Files (x86)\powerSSAS 2008\powerSSAS.dll assembly's progress.
The file is located at C:\Program Files (x86)\powerSSAS 2008\powerSSAS.InstallLog.
An exception occurred during the Install phase.
System.InvalidOperationException: Unable to get installer types in the C:\Program Files (x86)\powerSSAS 2008\powerSSAS.dll assembly.
The inner exception System.Reflection.ReflectionTypeLoadException was thrown with the following error 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 (x86)\powerSSAS 2008\powerSSAS.dll assembly's progress.
The file is located at C:\Program Files (x86)\powerSSAS 2008\powerSSAS.InstallLog.
An exception occurred during the Rollback phase of the System.Configuration.Install.AssemblyInstaller installer.
System.InvalidOperationException: Unable to get installer types in the C:\Program Files (x86)\powerSSAS 2008\powerSSAS.dll assembly.
The inner exception System.Reflection.ReflectionTypeLoadException was thrown with the following error 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 after the rollback is complete.
The Rollback phase completed successfully.
The transacted install has completed.
Coordinator
Apr 27, 2011 at 12:26 AM

The only dependancy that powerSSAS has is to have AMO installed. 

If you run this in Powershell:

[System.Reflection.Assembly]$assembly::LoadWithPartialName("Microsoft.AnalysisServices")

Do you see the following output:

GAC    Version        Location                                                                                                                            
---    -------        --------                                                                                                                            
True   v2.0.50727     C:\Windows\assembly\GAC_MSIL\Microsoft.AnalysisServices\10.0.0.0__89845dcd8080cc91\Microsoft.AnalysisServices.dll       

Apr 27, 2011 at 2:07 AM

[Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices")


GAC    Version        Location                                                                                                                                                                                                                                                                               
---    -------        --------                                                                                                                                                                                                                                                                               
True   v2.0.50727     C:\Windows\assembly\GAC_MSIL\Microsoft.AnalysisServices\10.0.0.0__89845dcd8080cc91\Microsoft.AnalysisServices.dll 

Coordinator
Apr 27, 2011 at 3:12 AM

Actually I just noticed that there was a bug in the 0.3.1.1 beta that has to do with all the commands that are based over XMLA discover calls that I fixed last September (but is not in the leates release).

Can you test if the get-ASServer works for you?

I'm not sure why the installer is throwing an error, but we should be able to get the module install working.