My Oracle Support Banner

After Upgrade to BDA 4.11 or Higher Hue Fails to Start with "DATABASE_CHARACTER_SET Character set of search field in desktop_document2 table is not UTF-8." (Doc ID 2499685.1)

Last updated on JULY 20, 2024

Applies to:

Big Data Appliance Integrated Software - Version 4.11.0 and later
Linux x86-64

Symptoms

After BDA upgrade to BDA 4.11 or higher Hue fails to start with:

Configuration files located in /var/run/cloudera-scm-agent/process/<ID>-hue-HUE_SERVER

Potential misconfiguration detected. Fix and restart Hue.

DATABASE_CHARACTER_SET Character set of search field in desktop_document2 table is not UTF-8.
NOTE: Configure the database for character set AL32UTF8 and national character set UTF8.


Note: The "desktop_document2" table is a default table used in Hue to store user queries, reference https://community.cloudera.com/t5/Support-Questions/Where-can-I-find-Saved-Queries-from-HUE-UI/m-p/286908 .

Changes

 Upgrade to BDA version 4.11 or higher.

Cause

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.