question

AmyJandreau-8392 avatar image
0 Votes"
AmyJandreau-8392 asked CarrinWu-MSFT commented

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

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

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

dgosbell avatar image
0 Votes"
dgosbell answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @AmyJandreau-8392,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmyJandreau-8392 avatar image
0 Votes"
AmyJandreau-8392 answered CarrinWu-MSFT commented

@dgosbell @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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AmyJandreau-8392, thanks for your reply. OLE DB error can cause by many reasons, have you see any information about why processing Dimension 'Claim Identifier' failed in the error details? If not, you could try to use SQL server profiler to capture the traces to get more details.

0 Votes 0 ·