Microsoft OLE DB Provider for SQL Server 2012 Analysis Services." Hresult: 0x80004005 Description: "Server: The operation has been cancelled

Question

Hello:

I have a for each loop which pulls the data from the cube by using mdx query, it is working fine for the some of the loops(iterations), after some iterations it is failing with the following error

SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.  Source: "Microsoft OLE DB Provider for SQL Server 2012 Analysis Services."  Hresult: 0x80004005  Description: "Server: The operation has been cancelled.".

OLE DB Source failed the pre-execute phase and returned error code 0xC0202009.

am using SQL Server 2012

Thanks

Pavan

---

Pavan K

Answer 1

am able pull same data with SSIS 2008 

---

Pavan K

Answer 2

Hi Pavan,

It may be caused if the package is deployed in 64bit environment while the data provider is not available in 64bit. Please refer to http://blogs.msdn.com/b/debarchan/archive/2009/04/13/ssis-an-oledb-error-has-occurred.aspx with error code 0xC0202009 to further look at the package.

Regards,
Jerry

Answer 3

Hi Jerry,

In my case both are 64 bit only, if these are different it should not pull the data at all but its worked perfectly 14 to 16 loops after its failed wih the above specified error

---

Pavan K

Answer 4

As a temporary fix, I have implemented loop level Restartability (if ETL fails at particular loop, it will start from failure loop from the next run)

---

Pavan K

Answer 5

Your temporary fix is not a bad idea.

I would also connect to SSAS using Profiler while running your SSIS package. Then we you experience a failure, carefully read through all the errors visible in Profiler to see if maybe SSIS isn't reporting the root error message properly.

---

http://artisconsulting.com/Blogs/GregGalloway