ITA Is Not Recording Any Dates Beyond Dec 31 2019 - Displays UNKNOWN
search cancel

ITA Is Not Recording Any Dates Beyond Dec 31 2019 - Displays UNKNOWN

book

Article ID: 184853

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

ITA is not recording dates beyond Dec 31 2019. Any data being generated past those dates is being rendered as UNKNOWN in the cube views.

None

Environment

IT Analytics for SEP, DLP, CCS, or ITMS

Cause

The DateDim table last date entry is December 31, 2019

Resolution

By running one of the two attached SQL scripts below, you will be able to extend the size of the DateDim (or ITAnalytics_DateDim) table to have date information thru Dec 31, 2025.  If you have a SEP or DLP standalone IT Analytics installation, use the ITA Datedim Fix.Sql.  If you have an ITMS installation of IT Analytics, use the ITAnalytics_Datedim.Sql file.

 

For Standalone SEP or DLP IT Analytics:

  1. Open SQL Server Management Studio, and connect to the SQL server housing the IT Analytics  database
  2. Connect to the IT Analytics database, and open a new query window.  Make sure the IT Analytics database ( or what it is called in your environment) is in focus.
  3. Copy the contents of the ITA Datedim Fix.Sql script into the new query window and execute it.
  4. Now, return to your ITA application, and execute your nightly processing job.

For Standalone IT Management Suite (ITMS)-based IT Analytics:

  1. Open SQL Server Management Studio, and connect to the SQL server housing the Symantec_CMDB database. 
  2. Connect to the IT Analytics database, and open a new query window.  Make sure the Symantec_CMDB database is in focus.
  3. Copy the ITAnalytics_Datedim.Sql script into the new query window and execute it.
  4. Now, return to your ITA application, and execute your nightly processing job.

If these steps seem unfamiliar, you can contact your DB Admininistrator, or you can raise a case with Support to receive assistance to implement the change.

This was fixed in a later release of IT Analytics standalone (DLP, SEP, CCS, etc) but has not been added to the ITMS version so the scripts will need to be used with ITMS.

 

 

Attachments

1591908554220__ITA Datedim Fix.Sql get_app
1587419333821__ITAnalytics_DateDim.SQL get_app