For the last day I’ve been attempting to process a measure group with 180 partitions in parallel. Every single time it would fail with the error: HYT00 – Query Timeout Expired. Most of the other measure groups had sucessfully processed, just not this one. This measure group happened to have 40 million rows per partition versus 100k to 20 million for the other measure groups.
After a little digging, I found a property called ExternalCommandTimeout (you’ll have to Select Show Advanced Properties) with a default value of 3600; I changed it to 50000. Problem solved and twelve hours later the measure group successfully processed.
Analysis Server Properties
Here’s a cool link listing all the SQL Return Codes:
Advertisement
Thanks for the tip, we had the same problem on when I added some large measure groups. I\’m hoping this will resolve the issue!
No problem, any other problems you have feel free to contact me!
You have saved me SO much time. As a site note, it appears that a "0" value means "infinite". Thanks!
I wish I\’d found this sooner!!! Been working on the same problem for better than 12 straight hours. Thanks, Jesse!
Top tip! thank you very much!