Skip to Content
0
Former Member
Oct 31, 2008 at 06:34 PM

Win2003 Server error: OLE Database error: OLE DB or ODBC error

91 Views

I've noticed we're getting this message in the event viewer of our single server, dev environment BPC 5.1 SP3 install:

OLE DB error: OLE DB or ODBC error: Timeout expired; HYT00

I believe this means Analysis Services is waiting for SQL server to provide something or processing cubes...but I'm not sure. The odd thing is this message is popping up at odd hours when no one is using the system (ie, overnight). It also happens during regular hours.

I've read elswhere that changing these AS properties will resolve the error:

ExternalCommandTimeout = 0

ExternalConnectionTimeout = 0

Does anyone have any experience with this error message or these settings? Why we might be getting the error (what's triggering it?), or if it's wise to change these settings?