Unable To Start Essbase Studio Server, Receive Error 'Unable to establish connection to MySQL server: Communications link failure" (Doc ID 1902364.1)

Last updated on JULY 05, 2017

Applies to:

Hyperion Essbase Studio - Version 11.1.2.3.500 and later
Information in this document applies to any platform.

Symptoms

On 11.1.2.3.500 version unable to start Essbase Studio Server.   The service makes an attempt to start, but then it almost immediately aborts.  The error log has references to MySQL, which is not used in the environment or referenced in any configuration.

Error:
20:46:14 06/08/14 (system) SEVERE Unable to establish connection to MySQL server: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server..
20:46:16 06/08/14 (system) SEVERE Unable to establish connection to MySQL server: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server..
20:46:16 06/08/14 (system) SEVERE Cannot initialize catalog storage. Make sure the server.properties file contains the correct information.
  -------------- Exception --------------
@ com.hyperion.cp.catalog.exceptions.CatalogInitializationException: Cannot initialize data storage engine.

Cause

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