You are unable to process cubes in IT Analytics. You are also unable to process the cubes manually in SQL Management Studio.

When you process the cube manually, the following error appears in SQL Process Progress window: "Timeout Period elapsed prior to completion of the operation or the server is not responding."

Or,

Server Error in '/Altiris/ITAnalytics/' Application.
Request timed out.

The processing of the cube needs more time to complete.

1. Using Microsoft SQL Server Management Studio, connect to the Analysis Services host.
2. In object explorer, right click the server name and choose edit properties.
3. On the General page, enable “Show Advanced (All) Properties”.
4. Increment the “ExternalCommandTimeout” parameter value. A value no higher than 360,000 is recommended. 
    

Related Articles

Error "Server Error in '/Altiris/ITAnalytics/Application. Request timed out" occurs when trying to access IT Analytics cubes
https://knowledge.broadcom.com/external/article?legacyId=TECH178239

IT Analytics cubes take too long to process
https://knowledge.broadcom.com/external/article?legacyId=TECH174994

Processing Patch Management ITA cubes causes excessive transaction log growth
https://knowledge.broadcom.com/external/article?legacyId=TECH172598

Applies To

IT Analytics 7.x

Microsoft SQL Server 2008