How to resolve “OLE DB error: OLE DB or ODBC error: Timeout expired; HYT00.”?

This error is typically logged with Windows Application Log with below details:

Event Type: Error

Event Source: MSOLAP$INSTANCENAME

Event Category: (289)

Event ID: 3

Date: DATE

Time: TIME

User: N/A

Computer: SERVERNAME

Description:

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

However most likely you will not get a log in SQL Error Log. Typically this error is caused because when some application faces time out error from SQL Server for it’s setting. This is normal and does not need any remediation unless this is a repetitive symptom. In case of a repetitive symptom, it can be assumed that some application/users is executing long query which is exceeding maximum time allowed per server setting and preventive measurements may be taken as needed.