Unable to open Hyperion Financial Management (HFM) application with Oracle Advanced Security (OAS) enabled for Data Encryption, error “An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = 08001; NATIVE ERROR = -4; MSG = [DataDirect]" (Doc ID 2239410.1)

Last updated on JUNE 13, 2017

Applies to:

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

Symptoms

Enabling OAS on Oracle Database causes HFM Applications not to open, error:

An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = 08001; NATIVE ERROR = -4; MSG = [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead. This may have occurred because the server requires Oracle Advanced Security. To enable the driver to use OAS, please use the DataIntegrityLevel and/or EncryptionLevel connect options.]]

 

Changes

 Enabling OAS on Oracle Database to require Data Encryption

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