Cube processing failure on errors in the metadata manager

Products

• IT Analytics

Issue/Introduction

IT Analytics (ITA) cube processing jobs fail and return an error similar to the following:

ErrorCode="3239313437" Description="Errors in the metadata manager. An error occurred when loading the DLP Sender Profile Condition dimension, from the file, 'C:\Program Files\Microsoft SQL Server\MSAS.MSSQLSERVER\OLAP\Data\ITAnalytics.0.db\DLP Sender Profile Condition.504.dim.xml'."

In addition to this error, the ITAnalytics database on the SQL Server Analysis Services (SSAS) server now reports as being in SUSPECT mode.

Environment

Release : 2.9.1

Component : Microsoft SQL Server Analysis Services

Cause

This error is caused by file system corruption impacting the ITAnalytics database, dimensions, or cubes.

Resolution

To recover from this condition, uninstall and reinstall the ITA cubes via the ITA console:

1. Open the IT Analytics console in a browser
2. Navigate to Admin > Settings > Cubes Installation
3. Select the affected cube(s) and click Uninstall
4. Select the available cube(s) and click Install
5. Re-run the failed cube processing job(s)

If this process fails, contact Broadcom support for assistance.