0x80040E21 or 0x80004005 error when a data flow task in an SSIS package runs an MDX query by using MSOLAP in SQL Server

Article translations Article translations
Article ID: 2861775 - View products that this article applies to.
Expand all | Collapse all

Symptoms

Consider the following scenario:
  • You run a Microsoft SQL Server Integration Services (SSIS) package in SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, or SQL Server 2005.
  • The SSIS package contains a data flow task.
  • The task runs a multidimensional expressions (MDX) query in SQL Server Analysis Services (SSAS) by using Microsoft Analysis Services OLE DB Provider for SQL Server (MSOLAP) in an SSIS connection manager.
In this scenario, you may receive an error message that resembles one of the following.

Error message 1
Error: 0xC0202009 at Data Flow Task, OLE DB Source [1]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for Analysis Services 2005" Hresult: 0x80004005 Description: "Internal error: An unexpected error occurred (file 'pcrsstore.cpp', line 325, function 'PCRSStore::UnLock').".
Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC0202009.

Error message 2
Hresult: 0x80004005  Description: "Unable to connect to the Analysis server. The server name 'giclssasbau\gi' was not found. Please verify that the name you entered is correct, and then try again".

Error message 3
Error: 0xC0202009 at Data Flow Task, OLE DB Source [1]: An OLE DB error has occurred. Error code: 0x80040E21.
Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC0202009.

Workaround

To work around this issue, add the following clause to the connection string of the MSOLAP provider in the connection manager:

Format=Tabular;

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 2861775 - Last Review: July 22, 2013 - Revision: 1.0
Applies to
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Evaluation Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • SQL Server 2012 Enterprise Core
Keywords: 
kbsurveynew kbtshoot kbexpertiseadvanced KB2861775

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com