IBM Support

Unable to upgrade clusters migrated from IOP 4.2.5 to HDP 3.1

Troubleshooting


Problem

On clusters that were previously migrated from IBM Open Platform (IOP) 4.2.5 to Hortonworks Data Platform (HDP) 2.6.x, upgrade to HDP 3.1 fails.

Symptom

As part of the upgrade to HDP 3.1, you upgrade Ambari. When you log in to Ambari to upgrade the HDP stack, you see the following errors:
500 status code received on GET method for API: /api/v1/clusters/power/stack_versions?fields=*,repository_versions/*,repository_versions/operating_systems/OperatingSystems/*,repository_versions/operating_systems/repositories/*

Error message: org.apache.ambari.server.controller.spi.SystemException: Could not load stack BigInsights-4.2.5 for Repository 1

Cause

Ambari no longer ships with the BigInsights stack.

Resolving The Problem

Steps to resolve the problem
  1. On the Ambari database, run the following SQL query:
    update repo_version set stack_id = (select stack_id from stack where stack_version = '2.3'), version = '2.3.0.0.01' where display_name like 'BigInsights%';
  2. Run the following command on all nodes:
    yum remove $(yum list installed | grep "IOP-4.2" | grep "4_2" | awk '{ print $1 }')
After you complete these steps, you will be able to log in to Ambari without errors.  You will also be able to install the HDP 3.1 packages and continue the HDP upgrade.

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Component":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"6.0.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Component":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"4.2.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 April 2021

UID

ibm10874462

Page Feedback