January 16, 2015 at 4:35 am
Hi all,
I have a dimension in my cube and currently every time I process it it fails on
OLE DB error: OLE DB or ODBC error: The query processor could not start the necessary thread resources for parallel query execution.; 42000.
And then I do a rerun and it works the second time. There doesnt seem to be any issues with the dimension. At the moment Im manually running then running again. Its just very odd that it fails on the first run and succeeds on the second run every time. Has any one seen this kind of behaviour before?
January 16, 2015 at 5:51 am
Could be a lot of things, but I don't think it's SSAS I think the problem is with the source data server. What is the MAXDOP setting? It could be that this is the issue. Is there anything else running concurrently? A little googling suggests that this problem is known as "worker thread starvation". Have a look around - there are many steps and checks to perform (many of which are described here: http://dba.stackexchange.com/questions/47237/need-to-understand-parallel-query-execution-error) to check this and resolve the problem. I don't want to plagiarize so have a look at the link 🙂
January 21, 2015 at 3:23 am
MAXDOP Settings? Im guessing that would be a question I should ask the DBA team? I wouldnt want to be messing with things that might cause issues. I will have a read of that documentation. thank you
January 21, 2015 at 3:27 am
Debbie Edwards (1/21/2015)
MAXDOP Settings? Im guessing that would be a question I should ask the DBA team? I wouldnt want to be messing with things that might cause issues. I will have a read of that documentation. thank you
Yes your DBAs would be the best people to ask about this problem.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply