Msg 7321 An error occurred while preparing the query "query-text-here" for execution against OLE DB provider "MSOLAP" for linked server "OLAP_SERVER_NAME_DEV"

• Dark Router

  SSC Veteran

  Points: 220

  More actions

  August 15, 2008 at 8:20 am

  #382255

  I have two instances of SQL 2005 on the same box one DEV and one QA - both are at version 9.00.3233.00, on Windows Server 2003 Standard SP2. The OLAP server is 64bit 2005 Enterprise on Windows Server 2003

  The following query works only on the DEV instance.

  SELECT *

  FROM OPENQUERY

  (

  OLAP_SERVER_NAME_DEV

  , 'SELECT FLATTENED PREDICT([Modified Related Items WebP_ID1].[v Assoc Seq Line Items], INCLUDE_STATISTICS, 4) AS WEBP_ID

  FROM [Modified Related Items WebP_ID1]

  NATURAL PREDICTION JOIN

  (

  SELECT

  (

  SELECT 4361542 AS [Web P ID]

  ) AS [v Assoc Seq Line Items]

  ) AS t '

  )

  WHERE [WEBP_ID.$ADJUSTEDPROBABILITY] > .1

  Here's the error it throws on the QA instance:

  Msg 7321 An error occurred while preparing the query "query-text-here" for execution against OLE DB provider "MSOLAP" for linked server "OLAP_SERVER_NAME_DEV"

  Here's the script that I used to create the linked server on both instances:

  USE [master]

  GO

  EXEC master.dbo.sp_addlinkedserver

  @server = N'OLAP_SERVER_NAME_DEV',

  @srvproduct=N'Analysis Services 2005',

  @provider=N'MSOLAP',

  @datasrc=N'OLAP_SERVER_NAME',

  @catalog=N'RelatedItems'

  GO

  EXEC master.dbo.sp_serveroption @server=N'OLAP_SERVER_NAME_DEV', @optname=N'rpc', @optvalue=N'true'

  GO

  EXEC master.dbo.sp_serveroption @server=N'OLAP_SERVER_NAME_DEV', @optname=N'rpc out', @optvalue=N'true'

  GO

  EXEC master.dbo.sp_MSset_oledb_prop N'MSOLAP', N'AllowInProcess', 1

  GO

  Here are the steps taken to resolve so far:

  1) Performed Windows Update

  2) Reinstalled Microsoft OLE DB Provider for Analysis Services 9.0 from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

  Anyone thoughts on this?

  Applications come and go, but data lasts forever!