July 13, 2011 at 2:19 am
Morning.....
I currently experiencing a threading issue when trying to process cubes. Before starting the cube we select sql server the detemine the number of threads/cpus's to use. The error I am getting is.....
OLE DB error: OLE DB or ODBC error: The query processor could not start the necessary thread resources for parallel query execution.; 42000
The server in question has 16 cpu's (8 dual cores), MS 2008 R2 x64 o/s & SQL 2008 R2 x64, 32Gb RAM of which 22Gb is allocated to SQL.
I installed the newly released SP1 yesterday and "hoped" this service pack would fix the issue. Has anybody else had this problem ??
Also, 'MAXDOP' is set to '8', max degree of parallelism' is set to '0', 'max worker threads' is also '0'.
July 13, 2011 at 1:23 pm
ttt:-)
May 23, 2012 at 5:09 am
I just had this issue today, I have the same environment as the one you have described.
Seems like Analysis Engine can't figure out how many parallel Processes it can run to handle the Cube processing, seems like a bug to me !
ole db error: ole db or odbc error: the query processor could not start the necessary thread resources for parallel query execution.; 42000.
So to work around it, I went under "Change settings" and forced the parallel execution to 4 and it is now processing... i hope it will go back to normal after help desk installs the pending patches or it seems that I will need to restart SSAS services
October 24, 2012 at 2:46 pm
This might help...if you have already found a solution please let us know
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply