When Using Non_Default Port 9091, Hyperion Financial Management (HFM) Application Throws Error: "EPMHFM-69451 No Server Specified For Datasource Process For Application"
(Doc ID 2736937.1)
Last updated on NOVEMBER 13, 2023
Applies to:
Hyperion Financial Management - Version 11.2.3.0.000 to 11.2.3.0.000 [Release 11.2]Hyperion Financial Management - Version 11.1.2.4.209 to 11.1.2.4.209 [Release 11.1]
Information in this document applies to any platform.
Symptoms
HFM application servers are configured to use a port other than default of 9091/9092. HFM's oracle-epm-fm-hsx-server.log will contain this error when application startup is attempted:
[FM] [WARNING] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [SRC_METHOD: init] An error occurred retrieving property isSSL from EPM registry, using default value :false.
[FM] [NOTIFICATION] [EPMHFM-65983] [oracle.FM.HSX.SERVER.oracle.epm.fm.common.HsxServerConfig] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.common.HsxServerConfig] [SRC_METHOD: load] The path to the configuration file location is: <DRIVE>:\Oracle\Middleware\user_projects\epmsystem1/config/hfm/configom.properties.
[FM] [NOTIFICATION] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [SRC_METHOD: init] isSSLEnabled :false
[FM] [NOTIFICATION] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [SRC_METHOD: init] Base Port : <NOT PORT 9091>
[FM] [NOTIFICATION] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [SRC_METHOD: init] SSL Port : <NOT PORT 9092>
[FM] [NOTIFICATION] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [SRC_METHOD: init] Thread Pool Size :70
[FM] [NOTIFICATION] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.common.BaseSeviceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.common.BaseSeviceManager] [SRC_METHOD: isServerPortAvailable] Is Port :<NOT PORT 9091>is available ? true
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Database type : <Database Type>
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Default value is used for hfm.dal.dbcp.pool.MaximumIdleConnections.
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Default value is used for hfm.dal.dbcp.pool.TimeBetweenEvictionThreadRunsMillis.
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Default value is used for hfm.dal.dbcp.pool.SoftMinEvictableIdleTimeMillis.
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Default value is used for hfm.dal.dbcp.pool.NumConnectionTestsPerEvictionRun.
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Default value is used for hfm.dal.dbcp.pool.NumMinIdleConnections.
[FM] [NOTIFICATION] [] [oracle.FM.HSXDSLM.oracle.epm.fm.dslm.DatasourceManagerImpl] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dslm.DatasourceManagerImpl] [SRC_METHOD: <init>] This Server Name : <SERVERNAME>
[FM] [WARNING] [] [oracle.FM.HSXDSLM.oracle.epm.fm.dslm.DatasourceManagerImpl] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dslm.DatasourceManagerImpl] [SRC_METHOD: initializeRegistryData] An error occurred retrieving property port from EPM registry, using default value :9091.
[FM] [NOTIFICATION] [EPMHFM-65983] [oracle.FM.HSX.SERVER.oracle.epm.fm.common.HsxServerConfig] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.common.HsxServerConfig] [SRC_METHOD: load] The path to the configuration file location is: <DRIVE>:\Oracle\Middleware\user_projects\epmsystem1/config/hfm/configom.properties.
[FM] [NOTIFICATION] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [SRC_METHOD: init] isSSLEnabled :false
[FM] [NOTIFICATION] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [SRC_METHOD: init] Base Port : <NOT PORT 9091>
[FM] [NOTIFICATION] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [SRC_METHOD: init] SSL Port : <NOT PORT 9092>
[FM] [NOTIFICATION] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.hsxserver.service.HsxServerServiceManager] [SRC_METHOD: init] Thread Pool Size :70
[FM] [NOTIFICATION] [] [oracle.FM.HSX.SERVER.oracle.epm.fm.common.BaseSeviceManager] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.common.BaseSeviceManager] [SRC_METHOD: isServerPortAvailable] Is Port :<NOT PORT 9091>is available ? true
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Database type : <Database Type>
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Default value is used for hfm.dal.dbcp.pool.MaximumIdleConnections.
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Default value is used for hfm.dal.dbcp.pool.TimeBetweenEvictionThreadRunsMillis.
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Default value is used for hfm.dal.dbcp.pool.SoftMinEvictableIdleTimeMillis.
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Default value is used for hfm.dal.dbcp.pool.NumConnectionTestsPerEvictionRun.
[FM] [NOTIFICATION] [] [oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dal.manager.DALDataSource] [SRC_METHOD: initialize] Default value is used for hfm.dal.dbcp.pool.NumMinIdleConnections.
[FM] [NOTIFICATION] [] [oracle.FM.HSXDSLM.oracle.epm.fm.dslm.DatasourceManagerImpl] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dslm.DatasourceManagerImpl] [SRC_METHOD: <init>] This Server Name : <SERVERNAME>
[FM] [WARNING] [] [oracle.FM.HSXDSLM.oracle.epm.fm.dslm.DatasourceManagerImpl] [tid: 10] [ecid: ] [SRC_CLASS: oracle.epm.fm.dslm.DatasourceManagerImpl] [SRC_METHOD: initializeRegistryData] An error occurred retrieving property port from EPM registry, using default value :9091.
Changes
Either this is a new installation or some change has been applied to the existing deployment to use ports other than 9091/9092.
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 |