measure group process failed.

Question

Hi,

im doing full process for a measuregroup which contains 15 partitions. But 2 partitions fails with below error.

OLEDB error : ole db or odbc error : Query timeout expired; HYT00

If i process the 2 partitons alone it is working fine..pls let me know reason for the issue.

 

Answer 1

Check the SSAS server property "ExternalCommandTimeout". The default value is 3600 secs which is 1 hr and might be your complete measuregroup needs more than 1 hr to process and that's why it is failing. Set the property to 7200 and check either it is processing successfully.

http://msdn.microsoft.com/en-us/library/cc966526.aspx

---

Aniruddha http://aniruddhathengadi.blogspot.com/

Answer 2

Run a trace against the relational source and process all partitions again. You will at least be able to see if there are any issues such as deadlocks during processing.