My Oracle Support Banner

Hyperion Financial Management (HFM) Application Periodically Hangs With Error: "An unknown error occurred in an ODBC object" (Doc ID 2694915.1)

Last updated on JULY 29, 2020

Applies to:

Hyperion Financial Management - Version and later
Information in this document applies to any platform.


In a distributed environment with multi-node servers, HFM intermittently stops responding. Logged errors include: "An unknown error occurred in an ODBC object" and "Unable to access availability database '<database name>' because the database replica is not in the PRIMARY or SECONDARY role. Connections to an availability database is permitted only when the database replica is in the PRIMARY or SECONDARY role. Try the operation again later.".

Even after the cluster has recovered, the HFM application still cannot be opened. A restart of HFM services is required to continue using HFM.


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

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