Hyperion Financial Management Applications Will Not Start When Microsoft SQL Server is Enabled With Windows Authentication Mode Only (Doc ID 2276067.1)

Last updated on JUNE 20, 2017

Applies to:

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

Symptoms

The end-user will be presented with a pop-up notification stating:
"The system was unable to find the Datasource process for application The system was unable to find the Datasource process for application {appName}"

 

The xfm.odl.{appName}.log contains the following ODBC errors:
[{dateTime}] [XFM] [ERROR:1] [EPMHFM-07392] [File: XfmODBC.cpp] [Line: 203] [errorCode: 800402B5] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = HY000; NATIVE ERROR = 0; MSG = [DataDirect][ODBC SQL Server Wire Protocol driver]Insufficient information to connect to the data source.]]
[{dateTime}] [XFM] [ERROR:1] [EPMHFM-07406] [File: XfmODBC.cpp] [Line: 615] [errorCode: 800402C3] An error occurred in creating an ODBC connection. [[HY000]]
[{dateTime}] [XFM] [ERROR:1] [EPMHFM-07406] [File: XfmODBC.cpp] [Line: 700] [errorCode: 800402C3] An error occurred in creating an ODBC connection. [[Failed to create DB connection.]]

 

oracle-epm-fm-hsx-server.log contains the following details:
[{dateTime}] [FM] [ERROR] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] HFM Database is not configured properly. Database related information is not available from HIT registry.
[{dateTime}] [FM] [ERROR] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.HsxModuleManager] [SRC_CLASS: oracle.epm.fm.hsxserver.HsxModuleManager] [SRC_METHOD: initialzeModules] An error occurred while initializing module oracle.epm.fm.dal.DALHsxModuleInterface.[[
[{dateTime}] [FM] [ERROR] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.HsxServer] [SRC_CLASS: oracle.epm.fm.hsxserver.HsxServer] [SRC_METHOD: init] An error occurred while starting HSX_SERVER_NAME service.[[
oracle.epm.fm.common.exception.HFMException: EPMHFM-66021: An error occurred while initializing module oracle.epm.fm.dal.DALHsxModuleInterface.

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