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

[Former Member]

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?

[Former Member]

Hi John

I had the same issue on our development instance,

Changed these parameters and the errors stopped happening.

ExternalCommandTimeout = 0

ExternalConnectionTimeout = 0

DatabaseConnectionPoolMax = 0

DatabaseConnectionPoolTimeout = 0

DatabaseConnectionPoolConnectTimeout = 0

Not sure why the errors happened,but I also noted that in my OLAP database there was an incorrect value in the connection string in the AppDef under Data Sources.

Regards

Daniel

[Former Member]

Hi

I think you can ignore this error message, unless it causes any performance issues, It is being raised by the background proactive caching thread that is waiting for a notification from SQL Server. If no notifications are received for the command timeout period, then the notification query will timeout and restart.

Regards,

if helpful, please thank by show of points.