Existing Workflow/Coordinator/Bundle Jobs Inaccessible from Hue after BDA 3.0.1/CDH 5.0.1 Upgrade from CDH 2.*/CDH 4.*
(Doc ID 1906715.1)
Last updated on MARCH 25, 2020
Applies to:Big Data Appliance Integrated Software - Version 3.0.1 and later
After upgrading to BDA 3.0.1/CDH 5.0.1 from CDH 2.*/CDH 4.* Workflow/Coordinator/Bundle jobs existing prior to the upgrade do not show up. Another symptom is that trying to view existing Workflow/Coordinator/Bundle Jobs from the Hue UI raises "server 500". The "server 500" error can be resolved by following the steps documented in: Accessing Existing Workflow/Coordinator/Bundle Jobs from Hue Raises "server 500" after BDA 3.0.1/CDH 5.0.1 Upgrade from CDH 2.*/CDH 4.* (Doc ID 1906672.1). After following the steps in: 1906672.1, some existing Oozie Workflows will show up, but not all. The existing Workflows that do show up may be missing content. Existing Coordinator jobs are present but frequency details need to be updated for CDH 5.0.1.
Symptoms from the Hue UI
1. In the Hue UI navigate to Workflows > Editor
a) View workflows which existed before the upgrade. You can search for a particular workflow as well, In the example here the workflow is: owf-load-and-organize.
b) Select a workflow that existed prior to upgrade. The content will be empty.
2. In the Hue UI navigate to Workflows > Editor > Coordinator > Select a Coordinator job that existed prior to upgrade
The result might be: Server Error (500) as below. However this will not always be a symptom. The Coordinator jobs may be visible.
Note: The behavior/steps here differ by browser. This is an option verification which can be skipped.
1. Open up one of the existing oozie workflow jobs from the Hue UI: Workflows > Editor. The example here uses: owf-load-and-organize.
Note: You can select the "workflow" on the right as in the screenshot below:
4.Refresh the browser and replace the current URL (pointing to the workflow) as below.
5. The above step will bring up a JSON response. Within that JSON response there should be field "data" with an empty string ("") as a value.
Symptoms observed in the hue database
From Node 3 of the cluster verify the empty data in the Hue database.
1. Select the hue database:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Symptoms from the Hue UI|
|Symptoms observed in the hue database|
|Verify the workflows are accessible|