Novell Home

My Favorites

Close

Please to see your favorites.

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

This document (7012060) is provided subject to the disclaimer at the end of this document.

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.

Disclaimer

This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7012060
  • Creation Date:02-APR-13
  • Modified Date:02-APR-13
    • NetIQAnalysis Center

Did this document solve your problem? Provide Feedback