HYT00 Error – Query Timeout Expired

 

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:
 
 
 
Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

7 Responses to HYT00 Error – Query Timeout Expired

  1. Arjun says:

    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!

  2. Jesse says:

    No problem, any other problems you have feel free to contact me!

  3. Keith says:

    You have saved me SO much time.  As a site note, it appears that a "0" value means "infinite".  Thanks!

  4. Peter says:

    I wish I\’d found this sooner!!! Been working on the same problem for better than 12 straight hours. Thanks, Jesse! 

  5. Alex W says:

    Top tip! thank you very much!

  6. Pingback: Marco's .NET Blog » Analysis Services :: Query Timeout Expired HYT00

  7. Abdul Khan says:

    As always…You are the Man!!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s