Essbase Studio log shows error during startup: Unable to establish connection to Oracle server: ORA-01017: invalid username/password; logon denied
Last updated on AUGUST 25, 2017
Applies to:Hyperion Essbase Studio - Version 22.214.171.124.000 and later
Information in this document applies to any platform.
When attempting to start up Essbase Studio, it fails and following error was shown in /Oracle/Middleware/user_projects/epmsystem1/diagnostics/logs/EssbaseStudio/server.log:
[2017-07-24T10:40:47.648-04:00] [hyperion] [ERROR] [ESSSTD-145015] [com.hyperion.cp.driver] [host: CW8353ALGE] [nwaddr: 126.96.36.199] [tid: 10] [userId: system] [ecid: 0000Lpp2hzX5Qd9xZc5Egb1PTWRX000001,0] [SRC_CLASS: com.hyperion.cp.driver.adapters.sql.oracle.OracleConnection] [SRC_METHOD: createSQLConnection] Unable to establish connection to Oracle server: ORA-01017: invalid username/password; logon denied[[
The database used for the Essbase Studio catalog tables had recently been upgraded to the Oracle 12c database.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms