Migration of rollups in Netcool/Impact v7.1.0.13

Fix pack v7.1.0.13 uses a new format for the creation of rollups that is different to previous versions of Netcool/Impact. A migration script is automatically executed during the install or upgrade process to convert pre-existing rollups to the v7.1.0.13 format. Run the Event Analytics configuration wizard after the upgrade to v7.1.0.13 to verify and save your configuration (see note below).

• In v7.1.0.12 (or earlier) the rollup display names are free-form text with no formatting applied. For example:

  reevent_rollup_1_column_name=ORIGINALSEVERITY
  reevent_rollup_1_type=MAX
  reevent_rollup_1_display_name=MaxSeverity

  In this scenario, Netcool Operations Insight creates a new column in the database called MaxSeverity. The display name in Dashboard Application Services Hub will be MaxSeverity, or whatever is defined in the Netcool/Impact uiprovider/translation directory.

  With the introduction of the Event Analytics configuration wizard in v7.1.0.13, it was necessary to apply a new format to rollup display names.

• In v7.1.0.13 a format of <column_name>_<type> is applied to rollup display names: For example:

  reevent_rollup_1_column_name=ORIGINALSEVERITY
  reevent_rollup_1_type=MAX
  reevent_rollup_1_display_name=ORIGINALSEVERITY_MAX

  Using the wizard, you can apply any display name to a column, in any language. Because creating database columns in any language could have been error prone, the format of the names for rollup database columns is now set to <column_name>_<type>. The display name is stored in the uiproviderconfig/translation directory and files. This format makes it is possible to change display names using the Event Analytics configuration wizard. For this reason, a migration script is executed during install/upgrade to transform all pre-existing rollups to the v7.1.0.13 format.