Post reply

Parallel processing not supported on Standard edition of Analysis Services

  • March 22, 2011 at 6:44 am

    #142391

    I'm processing all the Dimensions related to the Cube through SSIS. I process the Cube separately once all the Dimensions have been processed.

    I use the SSIS component "Analysis Services Processing Task":

    - In the editor, I add the required Dimensions with the Process Options as : Process Update

    - I then click "Change Settings", in the Processing Order, as soon as I select Parallel the following warning appears, even though I'm using the Enterprise Edition of SQL Server:

    "Parallel processing not supported on Standard edition of Analysis Services"

    BIDS Cube Project to design and deploy:

    - The Deployment mode is "Enterprise"

    - Parallel Processing works correctly through this project when deploying - there is no warning

    There are also no warning's if Processing (Cubes/Dimensions) directly through SSAS, using SSMS.

    SQL version

    Edition: Enterprise Edition

    PatchLevel: 10.2.4000.0

    SP: 2

    Version: 10.2.4000.0

    In SSIS, my Analysis Services Processing Task has a version of: 10.0.1600.22.

    Any ideas or further settings to ensure SSIS is recognising SQL Server Enterprise Edition?

  • March 23, 2011 at 4:24 am

    #1302363

    According to the last comment on this thread, you also need to update your client components to the latest version:

    http://stackoverflow.com/questions/5330182/ssis-analysis-services

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 23, 2011 at 5:01 am

    #1302373

    Hi,

    I started that post on stackoverflow - I can't see how I can update my Client Tools?

    I'm in development, so I have SSAS is on the same machine as the SSIS project.

    The Installer comes up with the Shared Features: Integration Services already checked - ie this is checked and Disabled, so not sure what I can do further here to upgrade the Integration Services.

    What version of this SSIS component should I be on, as I am on:

    Analysis Services Processing Task has a version of: 10.0.1600.22

    thanks

  • March 23, 2011 at 7:09 am

    #1302435

    Does the installer have a checkbox for client tools?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 23, 2011 at 8:16 am

    #1302483

    I have since installed all features of SQL Server 2008 and SP2 over the top, so now there are no check boxes unchecked.

    Same issue.

    In SSIS, I'm still seeing "Analysis Services Processing Task" component with the following properties:

    - Language: Language Neutral

    - Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    Any ideas?

  • March 23, 2011 at 8:32 am

    #1302503

    A small question: where do you find the version information for that specific component?

    I tested it on my machine, and I get the same warning.

    It is however a (silly) warning, the package executes flawlessly.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 23, 2011 at 8:54 am

    #1302526

    yes, it executes okay - but I don't think it's doing it in Parallel. If I run the same Parallel processes through SSMS and compare to SSIS - SSIS is taking longer, and there's no warning in SSMS, so thought the Parallel is not working.

    Version can be found:

    Right Click on ToolBox -> "Choose Items..." -> SSIS Control Flow Items tab -> Click "Analysis Services Processing Task", you should see the version.

  • March 23, 2011 at 9:05 am

    #1302537

    Why not run the Profiler on SSAS when the package is executing - this iwll show you whether it's running in parallel or not.

    I tend to agree with Koen, it does appear to just be a warning. Perhaps badly worded? (ie *if* you run this on Std Edition, it won't run in parallel). Checking the trace for both direct execution (in parallel) and SSIS execution will tell you if there is a difference.

    HTH,

    Steve.

  • March 23, 2011 at 10:19 am

    #1302580

    I've also run this through Profiler and can see it running in Parallel.

    As you described - it must just be a warning / notification.

    Thanks

  • March 23, 2011 at 12:11 pm

    #1302653

    amritpal.parmar (3/23/2011)

    I've also run this through Profiler and can see it running in Parallel.

    As you described - it must just be a warning / notification.

    Thanks

    Allright, glad this is sorted out. And thanks for posting back...

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply