Fields missing from the Historical Event Database

Edit online

You notice that fields are missing from the Historical Event Database.

Draft comment: DEIRDRELAWTON
RTC 69519 Nov 2019

Problem

Fields are missing from the Historical Event Database.

Cause

This situation typically occurs when you switch from one Historical Event Database to another, with different fields. Following this change, fields that were in use by Event Analytics, whether standard fields such as Node, Summary, or Acknowledged, or aggregate fields, are no longer present in the new Historical Event Database. In this case, when you reach the Configure Analytics > Report fields screen, you encounter a blank screen.

Resolution

To resolve this problem, perform the following steps:
  1. Complete one of the following options:
    • Add the missing field to the Historical Event Database.
    • Use a database view instead of the Historical Event Database table to add a dummy field for the missing aggregate field. For more information about creating a database view for the Event Analytics wizard, see Mapping customized field names.
  2. Open the Event Analytics wizard. and depending on the type of field you added, perform one of the following actions:
    • If you added a standard field, then no action is required.
    • If you added an aggregate field, and this field is no longer needed, then you can delete it. Now save the configuration.