Cube processing jobs fail and display the following error in the IT Analytics Events Viewer:
Cube processing error. Possible causes include insufficient permissions to read Cubes Data Sources, external connection timeout on the Analysis Server or remote connections timeout on SQL databases. Error: OLE DB or ODBC error: Query timeout expired; HYT00. Errors in the OLAP storage engine: An error occurred while the dimensions, with the ID of '<dimension ID>', Name of '<dimension name>' was being processed.
The SQL Server Agent job log contains the following error:
<Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00." Source="Microsoft SQL Server <version> Analysis Services" HelpFile="" />
Cube processing takes longer than the current query timeout values set on either the SQL Server database engine hosting the IT Analytics database or on the SQL Server Analysis Services (SSAS) server hosting the IT Analytics cubes.
To increase query timeout values, follow these procedures: