Tuesday, July 2, 2013

Query timeout expired; HYT00 in processing ssas 2008 cube

Some time while cube process this error comes 

"Query timeout expired; HYT00" 

After the Cube deployment:--

Right click on Analysis Services in Management Studio -> Properties. -> Show Advanced (all) Properties 
Set  ExternalCommandTimeout 0 , ExternalConnectionTimeout 0, DatabaseConnectionPoolMax = 0, DatabaseConnectionPoolTimeout = 0, DatabaseConnectionPoolConnectTimeout = 0