My Oracle Support Banner

HFM Application Doesn't Open after Database Password is changed Error: "An Unknown error occurred in creating an ODBC connection" "Cannot Load trust store" (Doc ID 2905688.1)

Last updated on NOVEMBER 15, 2022

Applies to:

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

Symptoms

HFM application won't open after changing HFM DB password , after configuring Database using EPM Configurator. ODL log shows these errors  "Cannot Load trust store" "An Unknown error occurred in creating an ODBC connection"

[XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: ] [File: c:\jenkins\workspace\hfm_11.2.9_build\hfm\source\xfmdatasourceroot\xfmdatasource\xfmdatasource.cpp] [Line: 579] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: 5476] [tid: 7916] [host: <HOSTNAME>] [nwaddr:] [errorCode: 0] [srcException: 0] [errType: 1] [dbUpdate: 2] [11.2.9.0.000.8] [[XDS: XFMDataSource process exiting now ...]]

[XFM] [ERROR:1] [EPMHFM-07392] [XFM] [ecid: ] [File: c:\jenkins\workspace\hfm_11.2.9_build\hfm\source\commonservercomponents\xfmcommon\xfmodbc.cpp] [Line: 234] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: 10472] [tid: 5448] [host: <HOSTNAME>] [nwaddr:] [errorCode: 800402B5] [srcException: 0] [errType: 1] [dbUpdate: 2] [11.2.9.0.000.8] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = 28000; NATIVE ERROR = 0; MSG = [oracle][ODBC Oracle Wire Protocol driver]Cannot load trust store.]]

[XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: ] [File: c:\jenkins\workspace\hfm_11.2.9_build\hfm\source\commonservercomponents\xfmcommon\xfmodbc.cpp] [Line: 883] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: 10472] [tid: 5448] [host: <HOSTNAME>] [nwaddr:] [errorCode: 800402C3] [srcException: 1] [errType: 1] [dbUpdate: 1] [11.2.9.0.000.8] An error occurred in creating an ODBC connection. [[08001]]

[XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: ] [File: c:\jenkins\workspace\hfm_11.2.9_build\hfm\source\commonservercomponents\xfmcommon\xfmodbc.cpp] [Line: 972] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: 10472] [tid: 5448] [host: <HOSTNAME>] [nwaddr:] [errorCode: 800402C3] [srcException: 1] [errType: 1] [dbUpdate: 1] [11.2.9.0.000.8] An error occurred in creating an ODBC connection. [[Failed to create DB connection.]]

Changes

HFM Database password has been changed.

 

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
Changes
Cause
Solution
References


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