Hi,



Sometimes my AS2005 server log this event:

OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00.



when this error appeared for the next 4 to 6hours I see this error (1 time
by hour) and then the error stops and can come back later.

This error is a random one.

For example, yesterday at 8:49 PM the error starts and I have 7 times the
error until 2:49 AM



1 of my cubes use the proactive caching feature. but the silence interval is
10minutes, not 1 hour. so I'm not sure if the error is linked to this
feature.

I'm using AS2005 x64 edition on an Win 2003 x64 server.



any idea of what is the cause?



thanks.



Jerome.

I think you can ignore this -- I believe 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.

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

thanks.
so a warning will be enough, not an error.

"Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> wrote