OLAP job failing on Step 8: EXCEPTION System.IO.FileNotFoundException:

  • 7012060
  • 02-Apr-2013
  • 02-Apr-2013

Environment

NetIQ Analysis Center 2.x
Microsoft SQL Analysis Center (OLAP Processing) Job

Situation

Your Microsoft Analysis Services OLAP job is failing on Step 8 with the following error:
 
** Error [NQOLAP]
 EXCEPTION System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.AnalysisServices, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
   at NQOLAP90.OLAPPROCESS.DBVersion()
   at NetIQ.UtilOLAP.OLAPPROCESS..ctor()

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
Connecting to OLAP Server Failed
[2/14/2013 2:00:24 PM](3636) ** Error [NQOLAP]
 EXCEPTION Microsoft.AnalysisServices.ConnectionException: A connection cannot be made. Ensure that the server is running. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   --- End of inner exception stack trace ---
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   at Microsoft.AnalysisServices.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
   at Microsoft.AnalysisServices.DimeRecord.ReadHeader()
   at Microsoft.AnalysisServices.DimeRecord..ctor(Stream stream)
   at Microsoft.AnalysisServices.DimeReader.ReadRecord()
   at Microsoft.AnalysisServices.TcpStream.GetResponseDataType()
   --- End of inner exception stack trace ---
   at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
   at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId)
   at Microsoft.AnalysisServices.Server.Connect(String connectionString)
   at NQOLAP100.OLAPPROCESS.get_Server()
   at NQOLAP100.OLAPPROCESS.DBVersion()

Resolution

Please download and install/reinstall the ADOMD.NET provider which is part of the Microsoft SQL Server Feature Pack for your version of SQL Server.
 

SQL Server 2008 R2 SP1 feature pack: http://www.microsoft.com/download/en/details.aspx?id=26728

Cause

The above error is most likely caused because ADOMD.NET is not installed or needs to be reinstalled on your server. You can check by browsing to C:\windows\assembly.