Link to home
Start Free TrialLog in
Avatar of Umesh
UmeshFlag for India

asked on

intra-query parallelism error in MS SQL Server 2000 Analysis Services

Hi,
We are getting following error while running queries over Analysis Server Cube Partition as below -

Data source provider error: Intra-query parallelism caused your server command (process ID #109) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).;

The version for Analysis services is Microsoft SQL Server  Analysis Services 2000 - 8.00.2039 with service pack SP4.
Avatar of dbaSQL
dbaSQL
Flag of United States of America image

If you're not using OPTION (MAXDOP 1), you probably should be.  check out SELECT in BOL, specifically the OPTION clause
Avatar of Umesh

ASKER

We had this option in our work list actually. But the client doesn't want to go for this option as the tool is Third party and rarely any change cane be made in queries.
ASKER CERTIFIED SOLUTION
Avatar of dbaSQL
dbaSQL
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial