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 MAY 02, 2017

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: 1492689926111,0] [tid: 139861226637632] [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: 1492689926111,0] [tid: 139861226637632] Going to call [Lease-renewal] operation.
[2017-04-20T08:07:12.884-04:00] [ESSBASE0] [NOTIFICATION:16] [LM-9] [LM] [ecid: 1492689926111,0] [tid: 139861226637632] 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: 1492689926111,0] [tid: 139861226637632] 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: 1492689926111,0] [tid: 139861226637632] Failed to acquire the lease after [6] consecutive attempts.
[2017-04-20T08:07:12.885-04:00] [ESSBASE0] [NOTIFICATION:16] [LM-16] [LM] [ecid: 1492689926111,0] [tid: 139861226637632] Lease is being surrendered.
[2017-04-20T08:07:12.885-04:00] [ESSBASE0] [NOTIFICATION:16] [LM-11] [LM] [ecid: 1492689926111,0] [tid: 139861226637632] Preparing to shutdown abort.
[2017-04-20T08:07:14.885-04:00] [ESSBASE0] [NOTIFICATION:16] [LM-12] [LM] [ecid: 1492689926111,0] [tid: 139861226637632] Terminating the process.

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