http://www.sqlservercentral.com/blogs/dknight/2009/03/02/cube-processing-error-hy008/

Printed 2014/08/29 06:19PM

Cube Processing Error HY008

2009/03/02

If you've ever had this error "OLE DB error: OLE DB or ODBC error: Operation canceled; HY008." appear while processing your cube you may be a little confused.  Here were some of my frustrations with it:

The only clue I had was one warning line after all the errors that referenced the column that was the culprit.  The warning didn't even really directly tell me the problem but it did show me a column to look at.  Turns out there were nulls in this column that caused the problem.  I should have known!  However, with the laundry list of errors that I was given it, that had nothing to do with the real problem attribute, it was hard to determine that nulls in a column was the real problem.  Hope this helps!

 


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.