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:

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

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