Good day,
I recently installed HFM version 11.1.2.4 on a single sandbox server successfully with a MS SQL database. The components installed were Foundation, Financial management, FDM EE and Reporting and analysis. I have subsequently uninstalled it, deleted the installation directory and drop the database.
Server - Windows server 2012 R2 with MS SQL 2016 installed on the server
I have repeated the steps to install the same software again. All the HFM Windows service started except the "Financial Management Java Server". This is the error from the "HyS9FinancialManagementJavaServer-sysout" log.
<13 Jan 2017 3:34:56 PM> <Error> <oracle.FM.HSSUTIL.oracle.epm.fm.hssservice.RegistryWrapper> <BEA-000000> <Invalid property isSSL for HIT Registry component POC000202.>
<13 Jan 2017 3:34:56 PM> <Warning> <oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager> <BEA-000000> <An error occurred retrieving property isSSL from EPM registry, using default value :false.>
<13 Jan 2017 3:34:56 PM> <Error> <oracle.FM.HSSUTIL.oracle.epm.fm.hssservice.RegistryWrapper> <BEA-000000> <Invalid property SSL_Port for HIT Registry component POC000202.>
<13 Jan 2017 3:34:56 PM> <Warning> <oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager> <BEA-000000> <An error occurred retrieving property SSL_Port from EPM registry, using default value :9092.>
<13 Jan 2017 3:34:56 PM> <Info> <oracle.FM.HSX.SERVER.oracle.epm.fm.common.HsxServerConfig> <BEA-000000> <The path to the configuration file location is: D:\Oracle\Middleware\user_projects\epmsystem1/config/hfm/configom.properties.>
<13 Jan 2017 3:34:56 PM> <Warning> <oracle.FM.HSX.SERVER.oracle.epm.fm.common.HsxServerConfig> <BEA-000000> <The system could not find file D:\Oracle\Middleware\user_projects\epmsystem1/config/hfm/configom.properties; using default location instead: /oracle/epm/fm/domainobject/config/configom.properties.>
<13 Jan 2017 3:34:56 PM> <Info> <oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager> <BEA-000000> < isSSLEnabled :false >
<13 Jan 2017 3:34:56 PM> <Info> <oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager> <BEA-000000> < Base Port : 9091 >
<13 Jan 2017 3:34:56 PM> <Info> <oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager> <BEA-000000> < SSL Port : 9092 >
<13 Jan 2017 3:34:56 PM> <Info> <oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.service.HsxServerServiceManager> <BEA-000000> < Thread Pool Size :70 >
<13 Jan 2017 3:34:56 PM> <Info> <oracle.FM.HSX.SERVER.oracle.epm.fm.common.BaseSeviceManager> <BEA-000000> < Is Port :9091 is avialable ? true>
<13 Jan 2017 3:34:56 PM> <Info> <oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource> <BEA-000000> < DB Max Active Connection Size : 70 >
<13 Jan 2017 3:34:56 PM> <Error> <oracle.FM.HSXDATAACCESS.oracle.epm.fm.dal.manager.DALDataSource> <BEA-000000> <HFM Database is not configured properly. Database related information is not available from HIT registry.>
<13 Jan 2017 3:34:56 PM> <Error> <oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.HsxModuleManager> <BEA-000000> <An error occurred while initializing module oracle.epm.fm.dal.DALHsxModuleInterface.
oracle.epm.fm.common.exception.HFMException: EPMHFM-66032: HFM Database is not configured properly. Database related information is not available from HIT registry.
at oracle.epm.fm.dal.manager.DALDataSource.initialize(DALDataSource.java:86)
at oracle.epm.fm.dal.DALModule.initialize(DALModule.java:58)
at oracle.epm.fm.dal.DALHsxModuleInterface.initialize(DALHsxModuleInterface.java:32)
at oracle.epm.fm.hsxserver.HsxModuleManager.initialzeModules(HsxModuleManager.java:86)
at oracle.epm.fm.hsxserver.HsxModuleManager.preServiceStartup(HsxModuleManager.java:59)
at oracle.epm.fm.hsxserver.HsxServer.init(HsxServer.java:41)
at oracle.epm.fm.hsxserver.HsxServer.main(HsxServer.java:27)
>
<13 Jan 2017 3:34:56 PM> <Error> <oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.HsxServer> <BEA-000000> <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.
at oracle.epm.fm.hsxserver.HsxModuleManager.initialzeModules(HsxModuleManager.java:94)
at oracle.epm.fm.hsxserver.HsxModuleManager.preServiceStartup(HsxModuleManager.java:59)
at oracle.epm.fm.hsxserver.HsxServer.init(HsxServer.java:41)
at oracle.epm.fm.hsxserver.HsxServer.main(HsxServer.java:27)
>
<13 Jan 2017 3:34:56 PM> <Info> <oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.HsxServer> <BEA-000000> <Shutting down...>
<13 Jan 2017 3:34:56 PM> <Error> <oracle.FM.HSX.SERVER.oracle.epm.fm.hsxserver.HsxServer> <BEA-000000> <An error occurred while stopping HSX_SERVER_NAME service.
java.lang.NullPointerException
at oracle.epm.fm.common.BaseSeviceManager.shutdown(BaseSeviceManager.java:205)
at oracle.epm.fm.hsxserver.HsxServer.shutdownServer(HsxServer.java:119)
at oracle.epm.fm.hsxserver.HsxServer.access$200(HsxServer.java:19)
at oracle.epm.fm.hsxserver.HsxServer$1.run(HsxServer.java:102)
>
I have tried to uninstall and re-install several times but this same error persists. Has anyone come across this issue? Additionally, does anyone know what is the "HIT registry", is this a table in the database or is it on the file system?.
Kind regards
AndrewL