Upgrade paths to 6.5.4.0 or 6.5.4 MP1

book

Article ID: 205632

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

From the Information Centric Analytics 6.5.4 Release Notes:

The Symantec ICA environment must be at version 6.5.2.2 or later to upgrade to 6.5.4 or 6.5.4 MP1. If the environment is not at 6.5.2.2 or later, then upgrade to 6.5.2.2 and ensure that the 6.5.2.2 Post Deploy job running in the SQL server agent has completed before starting the upgrade to 6.5.4 or 6.5.4 MP1.

Upgrade Path Matrix

Release Version

Application & Database Version

Upgrade Path to 6.5.4 MP1

6.5.2.1 25000 → 6.5.2.2 → 6.5.4 MP1
6.5.2.1 (HF1) 25010 → 6.5.2.2 → 6.5.4 MP1*
6.5.2.1 (HF2) 25020 → 6.5.2.2 → 6.5.4 MP1
6.5.2.1 (HF3) 25030 → 6.5.2.2 → 6.5.4 MP1
6.5.2.1 (HF4) 25030 → 6.5.2.2 → 6.5.4 MP1
6.5.2.1 (HF5) 25050 → 6.5.2.2 → 6.5.4 MP1*
6.5.2.2 26000 → 6.5.4 MP1
6.5.2.2 (HF1) 26010 → 6.5.4 MP1*
6.5.2.2 (HF2) 26020 → 6.5.4 MP1
6.5.2.2 (HF3) 26020 → 6.5.4 MP1
6.5.2.2 (HF4) 26020 → 6.5.4 MP1
6.5.2.2 (HF5) 26020 → 6.5.4 MP1
6.5.2.2 (HF6) 26020 → 6.5.4 MP1
6.5.3.0 30000 → 6.5.4 MP1*
6.5.3.0 (HF1) 30010, 1 → 6.5.4 MP1*
6.5.4.0 40000 → 6.5.4 MP1*

* Tested upgrade path

Resolution

To upgrade Risk Fabric or ICA to version 6.5.4.0 or 6.5.4 MP1 from a version released prior to 6.5.2.2, do the following:

  1. Upgrade to version 6.5.2.2 (any build)
  2. Run the nightly RiskFabric Processing job
  3. Confirm the RiskFabric Processing job completed successfully
  4. Upgrade to 6.5.4.0 or 6.5.4 MP1.

Additional Information

If attempting a direct upgrade to 6.5.4.0 or 6.5.4 MP1 from a version released prior to 6.5.2.2, the following errors may be found in the installation logs:

Error - 6.5.2.2 upgrade
Invalid column name 'AcceptableCount'.
Invalid column name 'Accuracy'.
Invalid column name 'ActionPlanPriorityID'.
Invalid column name 'ActionPlanProgressID'.
Invalid column name 'ActionPlanReasonID'.
Invalid column name 'ActionPlanResolutionID'.
Invalid column name 'BypassMFA'.
Invalid column name 'CardActiveCount'.
Invalid column name 'CardCount'.
Invalid column name 'CardIsActiveDate'.
Invalid column name 'ColumnDataType'.
Invalid column name 'ContinentCode'.
Invalid column name 'ContinentName'.
Invalid column name 'CountryName'.
Invalid column name 'current_partition_range_boundary_value_left'.
Invalid column name 'current_partition_range_boundary_value_right'.
Invalid column name 'EndingIPAddress'.
Invalid column name 'FilterUnknownValueReplacement'.
Invalid column name 'GeoLocationPoint'.
Invalid column name 'InvestigateCount'.
Invalid column name 'IOCID'.
Invalid column name 'IsActiveDate'.
Invalid column name 'IsAnonymousProxy'.
Invalid column name 'IsInEuropeanUnion'.
Invalid column name 'IsIPv4Address'.
Invalid column name 'IsSatelliteProvider'.
Invalid column name 'Latitude'.
Invalid column name 'LocaleCode'.
Invalid column name 'Longitude'.
Invalid column name 'MaxCardIsActiveDate'.
Invalid column name 'MaxStageIsActiveDate'.
Invalid column name 'PostalCode'.
Invalid column name 'RegisteredCountryGeoLocationID'.
Invalid column name 'RepresentedCountryGeoLocationID'.
Invalid column name 'RFAdministrator'.
Invalid column name 'RiskModelIsActiveDate'.
Invalid column name 'RiskModelMaxCardIsActiveDate'.
Invalid column name 'RiskModelMaxStageIsActiveDate'.
Invalid column name 'SessionToken'.
Invalid column name 'StageActiveCount'.
Invalid column name 'StageIsActiveDate'.
Invalid column name 'StageMaxCardIsActiveDate'.
Invalid column name 'StartingIPAddress'.
Invalid column name 'Subdivision1IsoCode'.
Invalid column name 'Subdivision1Name'.
Invalid column name 'Subdivision2IsoCode'.
Invalid column name 'Subdivision2Name'.
Invalid column name 'TimeZone'.
Invalid column name 'TimeZoneName'.
Invalid column name 'ViolationCount'.

The upgrade will complete with errors, and the nightly RiskFabric Processing job will return errors as a result of these missing columns.