Dim Process failing with error [Analysis Services Execute DDL Task] Error: OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.

Question

Hi All,
I have over 35 dimensions, when I process individually they get processed , but when I process all of them together each one fails with the following error
[Analysis Services Execute DDL Task] Error: OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.

Please advice
Thanks

Answer 1

By default SSAS will do processing operations in parallel. When a fatal error happens in one object it halts the processing and rolls back the transaction and any other operations that were happening get cancelled. Therefore you will typically see an initial error message that is the root cause of the problem followed by a list of operation cancelled errors. So what you need to do is to scroll back and find the first error in the list to figure out what actually went wrong.

Answer 2

Hi @Amy Jandreau ,

Welcome to Microsoft Q&A!

HYT00 means DB_E_ABORTLIMITREACHED (0x80040E31) or a timeout expired. The timeout expired due to the SQL_QUERY_TIMEOUT setting. The command timeout or query timeout kicked in to kill the running query and cancel the work. When Analysis Services processes a cube or a lower-level object like a dimension or measure group, it sends many large SQL queries to the relational database engine through an OLE DB provider. So as dgosbell mentioned, you should find the first error. Please refer to Background on cube processing to get more information.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

@Darren Gosbell @CarrinWu-MSFT thanks.
Here is what I did so far. There are a total of 39 dimensions and i processed them individually (yes took some time) and all of them were success, please note i did this using VS. Then i selected all and processed then (UPDATE). The first error message on the first FAILED dimension does not give much info on why it failed, please see the below error message
Processing Dimension 'Claim Identifier' failed.
OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.

Then i went back and processed this same dimension and it processed without any errors