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