Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SSAS Server: The Operation Has Been Cancelled

Unanswered SSAS Server: The Operation Has Been Cancelled

  • Monday, January 21, 2013 7:20 PM
     
     
    Sign In to Vote
    0

    Hi I am new to SSAS and SSIS. I got a problem with one of my SSIS jobs.

    I have an SSIS job which contains 2 steps

    1. It will process Dimensions and cubes (Using proactive Caching--Client Initiated)
    2. Loading Database tables by running MDX query againest the above Cube.

    Some times the job is failing in Step 2 with below error. When it failed i ran that job manually and it was running fine.

    Started: 2:41:18 PM Error: 2013-01-10 14:42:55.15 Code: 0xC0202009 Source: Retrieve BU Labor Data OLE DB Source [1]
    Description: 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 Analysis Services 2008 R2." Hresult: 0x80004005 Description: "Server: The operation has been cancelled.". End Error Error: 2013-01-10 14:42:55.17 Code: 0xC004701A Source: Retrieve BU Labor Data SSIS.Pipeline
    Description: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC0202009. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:41:18 PM Finished: 2:42:55 PM Elapsed: 96.315 seconds. The package execution failed. The step failed.

     

All Replies

  • Friday, January 25, 2013 5:47 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Venky505,

    What's the specific version of your SQL Server 2008R2? Please try to install the latest Service Pack for SQL Server 2008R2 to see if this issue still persist. In addition, the insufficient memory will lead to jobs fail. Maybe you can try to add more Server memory.

    If this issue still persists, please describe your scenario with more detail. It benefit for other community members to help you troubleshoot this issue.

    Regards,

    Elvis Long
    TechNet Community Support

     
  • Friday, January 25, 2013 6:49 AM
     
     
    Sign In to Vote
    0

    Hi Elvis

    Thanks for the reply. The version we are using is Microsoft SQL Server 2008 R2 SP1. I will try to implement the modifications suggested and update you.

     
  • Wednesday, January 30, 2013 2:02 PM
     
     
    Sign In to Vote
    0

    Hi All,

    Please let me know how to find out the Latest service pack for  Microsoft SQL Server 2008 R2 (SP1) - 10.50.2861.0 (X64)   Aug 20 2012 19:28:58   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2)

     
  • Thursday, January 31, 2013 1:23 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi All,

    Please let me know how to find out the Latest service pack for  Microsoft SQL Server 2008 R2 (SP1) - 10.50.2861.0 (X64)   Aug 20 2012 19:28:58   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2)

    Hi Venky505,

    Please click the following link to get the Service Pack 2 for SQL Server 2008 R2:
    How to obtain the latest service pack for SQL Server 2008 R2: http://support.microsoft.com/kb/2527041

    Regards,

    Elvis Long
    TechNet Community Support

     
  • Thursday, January 31, 2013 7:20 AM
     
     
    Sign In to Vote
    0

    Hi Elvis,

    Thanks for the reply. A bit more description about the problem that we are facing.

    We have an SSIS package which will fetch the data from the cube using MDX query and loads it into SQL table. The cube is Writeback enabled.  When we try to run this package while users updating the CUBE using UPDATE CUBE command(Users update through front end screen but behind the scenes it uses UPDATE CUBE command) some times it is failing with the below error. The cube contains only one partition which has proactive caching enabled.  The MDX query normally takes around 6 min to get the data from cube.

    Started: 2:41:18 PM Error: 2013-01-10 14:42:55.15 Code: 0xC0202009 Source: Retrieve BU Labor Data OLE DB Source [1]
    Description: 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 Analysis Services 2008 R2." Hresult: 0x80004005 Description: "Server: The operation has been cancelled.". End Error Error: 2013-01-10 14:42:55.17 Code: 0xC004701A Source: Retrieve BU Labor Data SSIS.Pipeline
    Description: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC0202009. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:41:18 PM Finished: 2:42:55 PM Elapsed: 96.315 seconds. The package execution failed. The step failed.