My Oracle Support Banner

Essbase: After EPM Registry is Migrated to Oracle RAC database, Essbase Active-Passive Cluster Lease Manager fails: Attempt to connect to database failed with error [[DataDirect][ODBC Oracle Wire Protocol driver]Number contains an invalid character: -1] (Doc ID 2260989.1)

Last updated on DECEMBER 04, 2022

Applies to:

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

Symptoms

After updating the shared services database to use RAC Oracle Database:


Essbase is not starting with error in lease manager logs as below:

[2017-04-20T08:07:12.877-04:00] [ESSBASE0] [NOTIFICATION:16] [LM-60] [LM] [ecid] [tid] [20.99]sec is the time taken for [Wait-for-Lease-renewal] operation.
[2017-04-20T08:07:12.877-04:00] [ESSBASE0] [NOTIFICATION:16] [LM-61] [LM] [ecid] [tid] Going to call [Lease-renewal] operation.
[2017-04-20T08:07:12.884-04:00] [ESSBASE0] [NOTIFICATION:16] [LM-9] [LM] [ecid] [tid] Attempt to connect to database failed with error [[DataDirect][ODBC Oracle Wire Protocol driver]Number contains an invalid character: -1].
[2017-04-20T08:07:12.884-04:00] [ESSBASE0] [NOTIFICATION:16] [LM-9] [LM] [ecid] [tid] Attempt to connect to database failed with error [[DataDirect][ODBC Oracle Wire Protocol driver]Number contains an invalid character: -1].
[2017-04-20T08:07:12.885-04:00] [ESSBASE0] [NOTIFICATION:16] [LM-1] [LM] [ecid] [tid] Failed to acquire the lease after [6] consecutive attempts.
[2017-04-20T08:07:12.885-04:00] [ESSBASE0] [NOTIFICATION:16] [LM-16] [LM] [ecid] [tid] Lease is being surrendered.
[2017-04-20T08:07:12.885-04:00] [ESSBASE0] [NOTIFICATION:16] [LM-11] [LM] [ecid] [tid] Preparing to shutdown abort.
[2017-04-20T08:07:14.885-04:00] [ESSBASE0] [NOTIFICATION:16] [LM-12] [LM] [ecid] [tid] Terminating the process.

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
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.