Error: "EPMCFG-10399: EPM System Configurator has detected use of a non-UTF-8 Oracle database; UTF-8 encoding needs to be used."

Error: "EPMCFG-10399: EPM System Configurator has detected use of a non-UTF-8 Oracle database; UTF-8 encoding needs to be used." [ID 1318128.1]
		Modified 05-MAY-2011 Type HOWTO Status PUBLISHED

In this Document
Goal
Solution

---

Applies to:

Hyperion BI+ - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Information in this document applies to any platform.

Goal

When running the Oracle Hyperion Enterprise Performance Management (EPM) System Configurator 11.1.2.1 to configure the Database (using an Oracle repository) the installing user sees the following error:
"EPMCFG-10399: EPM System Configurator has detected use of a non-UTF-8 Oracle database; UTF-8 encoding needs to be used."

Solution

Per the Oracle Database Creation Considerations:

For the best compatibility with non-ASCII character sets, the database must be created using Unicode Transformation Format UTF-8 encoding (character set). Use of UTF-8 is required if you need any characters beyond ASCII. Oracle supports the following character sets with UTF-8 encoding:

- AL32UTF8 (preferred/standard UTF-8 encoding)
- UTF8 (backward compatible/non-standard encoding for Oracle [only includes the base plane of Unicode])
- UTFE (UTF-8 encoding for EBCDIC platforms)

Note: The UTF-8 character set must be applied to the client and to the Oracle database.

Check with the DBA if the repository you are about to use for the Oracle EPM system meets this requirement or query via SQLPlus or a similar tool using the following SQL:

SELECT * FROM NLS_DATABASE_PARAMETERS

Recent versions of Microsoft SQL Server automatically communicate with Oracle Hyperion EPM 11 in UTF-8. IBM DB2 must also be configured for UTF-8.