Analysis Services Stops Accepting New Connections –Processing commit locks hurt

This common blocking symptom really can cause trouble if you get caught off guard. When you process an Analysis Services object, like FullProcess on a database or cube, near the end of processing is the phase where it needs to swap the old files out and replace it with the new files a lock is…

1

Analysis Services Cube processing fails with error "OLE DB error: OLE DB or ODBC error: Operation canceled; HY008."

  Lots of similar errors during processing Analysis Services processing (on Adventureworks DW cube in my example) can fail with this error “OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.” In SQL OLEDB terms HY008 means DB_E_CANCELED (aka your query was cancelled purposefully by the caller) If you get lucky, you can…

11