IT Analytics reports are out of date

Products

• IT Analytics

Issue/Introduction

IT Analytics (ITA) reports are accessible but do not return the most current information when compared to the source system (DLP or SEP).

Environment

Release : 2.9.x

Component : Reports

Cause

ITA reports are populated by the information stored in the ITA cubes. If the cube processing jobs have failed to run for any reason, the information in the reports will only be as current as the last time the processing jobs ran successfully.

Resolution

Cube processing jobs can fail for a variety of reasons. To investigate the cause, follow this procedure to check the job history:

1. Using SQL Server Management Studio (SSMS), connect to the database engine hosting the ITAnalytics database
2. In Object Explorer, navigate to SQL Server Agent > Jobs
3. Locate the cube processing job(s) as defined in the ITA console under Settings > Processing Jobs
4. In Object Explorer, right-click on the cube processing job(s) and select View History
5. Expand the latest job run and review the row details to locate any error messages