SQL Developer

I run the diagnostics tool after install/configuration. I get the error message below for some components.

ssbase / Essbase Administration Services
PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
FAILED REG: Datasource Checking if datasource property exists in the registry
Error: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
Recommended Action: **PlaceHolder-do-not-translate** 8 seconds
PASSED DB: Database Connectivity Checking connection to database jdbc:oracle:thin:@localhost:1521:hypdb 0 seconds
PASSED EXT: External Authentication Check Native Directory external authentication provider configuration 0 seconds
PASSED REG: Configuration Checking if product has only one product node in registry. 0 seconds
PASSED WEB: Libraries Check if all shared libraries are targeted for application "Oracle EPM EAS". 0 seconds
PASSED WEB: Web Application Availability of Web application context http://EPM1112:10080/easconsole/console.html

I hope this helps in understanding my issue.

H

Configuration tool didn't understand when I give my computer name as the host, displaying issue related to network. It accepts only if I enter it as localhost.

you can try adding ip/machine name in the hosts file.See if that makes any difference

you need, Install ODAC, in Oracle Database Client by Custom option....and select the ODAC.

Regards,
Cristian

Thanks.

Currenly I have installed Oracle 11g 32 bit client first.
And then the Oracle 11g 64 bit database.

Should I install 64 bit client with ODAC also? or Does the Oracle 11g 64 bit database and software installation include the client and ODAC?

Will there be any conflict and issues if I install Oracle 11g 64 bit client in addition to the above?
Should I install it in separate Oracle Base directories?

When I do a custom install I don't see anything called ODAC but I assume it is "Oracle Providers for .NET".

Hi Manoj,

I've added the host name and IP address to the hosts file but still same issue.

I wonder if it has anything to do with the Loop Back adapter.

I'm on Windows Server 2008 R2 Standard. After I install Loop Back adapter and set a static IP for it,
it shows as "Public" "unidentified network". In the properties, it shows "No Network Access" for both IPV4 and IPV6.
When I run the "Ping <hostname?" command in DOS prompt, it is successful but only shows the hexadecimal physicall address and not the IP address for IPV4.
Is this ok?

Is this similar to what you've done in order to setup your loopback adaptor?

http://www.experts-exchange.com/Networking/Windows_Networking/Q_21682149.html

Manoj,

Yes. I configured Loop Back adapter as described in the link you provided. These steps are given in Oracle database installation document also.
The only thing I did not do on those steps is that my computer is in a work group and not a domain.

1. Configuration tool didn't understand when I give my computer name as the host, displaying issue related to network. It accepts only if I enter it as localhost
>>
Why is EPM System Configurator having issues withresolving some hostnames, such as:"server-1.domain_s9"?

Look at the following url

http://www.oracle.com/technetwork/middleware/bi-foundation/epm-tips-issues-1-40-167121.pdf

Thanks Manjoj. I fixed the host name resolution issue. I think the hosts file entry was not right.
Also fixed the ODAC issue. I installated Oracle DB and clients in the following order.

Oracle 11g Database
Oracle 11g 32 bit client (custom install and choose Oracle Drivers for ASP.NET)
Oracle 11g 64 bit client (custom install and choose Oracle Drivers for ASP.NET)

Alll the products configured correctly. But a new issue now. When I start the EPM System using the option
available in the Program Files menu, all the services start but "Hyperion EPMA Server" is not starting.
I tried starting all the services manually as specified in the documentation too. Same issue.
When I start it from Windows control panel, I get a message like "The services started but stopped. Some services may stop if there are no
programs or other services using it".

I checked the Installation and configuration trouble shooting document where this issue is mentioned. I checked the BPMA_Server_Config.xml File
and the time our parameter is set to 600 seconds. I guess this should be more than enough for a POC installation.

The Diagnostic report shows the following for EPMA section.

Foundation / Performance Management Architect
FAILED AppMgrLoadAdf Launch external checker with next command: C:\Oracle\Middleware\EPMSystem11R1\..\jdk160_21/bin/java -DEPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1 -DEPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1 -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\validationTool-logging.xml com.oracle.epm.epma.config.validations.appmanager.AppMgrLoadAdf
Error: AppMgrLoadAdf failed when requesting information from EPMA. Please check that all EPMA services have started and are currently running.
Recommended Action: Make sure external checker is working. 12 seconds
PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
PASSED DB: Database Connectivity Checking connection to database jdbc:oracle:thin:@hypbi:1521:hypdb 0 seconds
FAILED DimEditorLoadAdf Launch external checker with next command: C:\Oracle\Middleware\EPMSystem11R1\..\jdk160_21/bin/java -DEPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1 -DEPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1 -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\validationTool-logging.xml com.oracle.epm.epma.config.validations.dimeditor.DimEditorLoadAdf
Error: DimEditorLoadAdf failed when requesting information from EPMA. Please check that all EPMA services have started and are currently running.
Recommended Action: Make sure external checker is working. 12 seconds
FAILED EnumApplications Launch external checker with next command: C:\Oracle\Middleware\EPMSystem11R1\..\jdk160_21/bin/java -DEPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1 -DEPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1 -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\validationTool-logging.xml com.oracle.epm.epma.config.validations.repository.EnumApplications
Error: EnumApplications failed when requesting information from EPMA. Please check that all EPMA services have started and are currently running.
Recommended Action: Make sure external checker is working. 11 seconds
FAILED EnumDataSyncs Launch external checker with next command: C:\Oracle\Middleware\EPMSystem11R1\..\jdk160_21/bin/java -DEPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1 -DEPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1 -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\validationTool-logging.xml com.oracle.epm.epma.config.validations.repository.EnumDataSyncs
Error: EnumDataSyncs failed when requesting information from EPMA. Please check that all EPMA services have started and are currently running.
Recommended Action: Make sure external checker is working. 11 seconds
FAILED EnumDimensions Launch external checker with next command: C:\Oracle\Middleware\EPMSystem11R1\..\jdk160_21/bin/java -DEPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1 -DEPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1 -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\validationTool-logging.xml com.oracle.epm.epma.config.validations.dimeditor.EnumDimensions
Error: EnumDimensions failed when requesting information from EPMA. Please check that all EPMA services have started and are currently running.
Recommended Action: Make sure external checker is working. 30 seconds
FAILED PMAJ: EPMA Service Validating whether jobmanager service is available.
Error: com.hyperion.cis.utils.BadResponseCodeException: Bad response code: 500
Recommended Action: Check that the application is started 2 seconds
PASSED DSC: EPMA DimensionServer Server Configuration Validating EPMA Dimension Server startup... Successful... 0 seconds
PASSED EXT: External Authentication Check Native Directory external authentication provider configuration 1 seconds
PASSED REG: Configuration Checking if product has only one product node in registry. 0 seconds
PASSED WEB: Libraries Check if all shared libraries are targeted for application "Oracle EPM EPMAWebTier". 0 seconds
PASSED WEB: Libraries Check if all shared libraries are targeted for application "Oracle EPM EPMADataSynchronizer". 0 seconds
PASSED WEB: Web Application Availability of Web application context http://hypbi:19091/awb/conf/AwbConfig.xml 0 seconds
PASSED WEB: Web Application Availability of Web application context http://hypbi:19101/DataSync

Thanks.
H

I had this problem too, and got it after similar ODAC issues as that you've mentioned. The way I got it to finally work was to re-config all EPMA components, and then run the configure web server as a second pass. Have you tried this?

Andy,

Yes. I re-configured EPMA (Configure Database, Deploy to Application Server, Configure Interface Datasource).
I did not run a second pass of Web Server Deployment though. But the EPMA Server service started now and problem solved.
After the re-config, all the 3 services associated with EPMA were set to Automatic. THis means next time the machine restarts,
these services start ahead of other services. Should I set all the services to Manual after install and configuration?

Yes, I usually set them to Manual on my development machine.

Most of my issues are solved and only a single issue with HFM Service.

The Diagnostic message showed a lot of errors related to the product launch URLs.

I re-deployed Foundation Services to Web Server and this made all the errors go away.
However, if I start IIS Admin Server Service, all those errors come back.
Is there a conflict between the Oracle HTTP Server and IIS?

H

I would suggest just have one web server.Since HFM/FDM use IIS as its web server, configure all products to use IIS as the web server.

Hi Manoj,

Yes. I did try to do that.

In the EPM Configurator, I selected the Web Server deployment option where I saw both IIS and Oracle HTTP Server listed.
I selected IIS and it ran successfully. But when I stop the Oracle HTTP Server service and then open the URLs for Workspace and others, they fail.
The Diagonistics report also shows error message for all the URL testing.

How to redeploy to IIS after initially deploying to Oracle HTTP server? I saw an entry for this in the EPM Troubleshooting guide and followed it.
The trouble shooting guide says that I first have to install Oracle HTTP Server and then redeploy to IIS on the second pass.
Because, in the first pass, the IIS option won't be listed in the Web Server list.

Anything I am missing?

H

On my system I use IIS for HFM and OHS for all the rest. Most of the config was done using the EPM System Configurator itself, with the only tinkering that I needed to do was due to my system being Win 7, and not Win Server 2k8.
With all the errors that you are seeing when you run the diagnostics, what can and what can you not launch? I guess you could get more information on the errors and such by trying to launch the tools and checking for errors in the log files.

Edited by: AndyT_PA on Jul 11, 2011 8:14 AM

Andy,

The Diagnostic report passes for everything except the following.

Financial Management

PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
PASSED DB: Database Connectivity Checking connection to database jdbc:oracle:thin:@hypbi:1521:hypdb 0 seconds
PASSED EXT: External Authentication Check Native Directory external authentication provider configuration 0 seconds
PASSED CCFG: Financial Management Cluster Configuration Validating Financial Management cluster registration Successful... 6 seconds

FAILED SVR: Financial Management Service Validation Verify that the Financial Management service is working.
Error: EPMVLD-01024: The Financial Management service check failed: ERROR: while test
Recommended Action: Verify that the HatEx utility is working. Check the hat.output file from the validation logs folder for details. 1 seconds

PASSED SVR: Financial Management Server Registration Validating Financial Management Server registration Successful... 0 seconds
PASSED WSVR: Financial Management Web Server Validating Financial Management Web application connection Successful... 0 seconds
PASSED ASC: Financial Management Application Server Configuration Validating Financial Management Server registration Successful... 0 seconds
PASSED LCM: LCM Provider Validating Financial Management LCM Provider connection Successful... 0 seconds
PASSED REG: Configuration Checking if product has only one product node in registry. 0 seconds
PASSED WEB: Libraries Check if all shared libraries are targeted for application "Oracle EPM Financial Management Web Service". 0 seconds
PASSED SVCS: SmartView Provider Validating Financial Management SmartView Provider connection Successful... 0 seconds
PASSED WEB: Web Application Availability of Web application context http://hypbi:6373/oracle-epm-fm-webservices/ApplicationService 0 seconds


I checked the hat.output file as recommended by the above Diagnostic report and I see the following.

-----------------------------------------------------------------------------
------------STARTING VALIDATION SCRIPTS----------
LOGGING IN HFM....
CREATING APPLICATION....
3002

File could not be opened.

ADODB.Stream
ERROR: while test
-----------------------------------------------------------------------------

H

The configtool is deploying the 32 bit versions of iisproxy.dll and iisforward.dll. This causes IIS not to be able to access the Hyperion application.
Solution
Follow the following steps to copy the 64 bit versions of iisproxy.dll and iisforward.dll files.


Stop IIS on the machine either from IIS console or by stopping appropriate Windows Services:

World Wide Web Publishing Service
HTTP SSL
IIS Admin Service


Copy iisforward.dll from

$EPM_ORACLE_HOME\..\wlserver_10.3\server\plugin\win\x64\iisforward.dll

move to $EPM_INSTANCE_HOME\<DomainName>\VirtualHosts\iisforward.dll


Copy iisproxy.dll from

$EPM_ORACLE_HOME\..\wlserver_10.3\server\plugin\win\x64\iisproxy.dll

move to every folder under $EPM_INSTANCE_HOME\<DomainName>\VirtualHosts\

Ex: $EPM_INSTANCE_HOME\<DomainName>\VirtualHosts\workspace
$EPM_INSTANCE_HOME\<DomainName>\VirtualHosts\WebAnalysis
$EPM_INSTANCE_HOME\<DomainName>\VirtualHosts\raframework


Start IIS.


hope this helps...

Hi Manoj,

Thanks. I haven't done this yet. But I hope this will fix the issue.

How do I avoid this issue in a fresh installation of EPM?

H

Hi

This is a known issue, so you will run into this and will have to change the files as suggested in my earlier post.

Thanks,
Manoj

Manoj, I tried that solution but it didn't work.
If I do that, then it doesn't open many of the application URLs and
there are more errors in the diagnostic log.

H

can you put the extract of the diagnostics log?

Manoj, please find below the diagnostic log.
==================================================================
Oracle EPM System
Diagnostics
Generated on 07/17/2011 01:32 AM
Validation run on hypbi
EPM System Diagnostics info: 11.1.2.1.0 drop 36-0 build 6321-on-03/01/2011 06:48 AM
Build version: 11.1.2.1.0.6765
OS name: Windows Server 2008 R2
OS version: 6.1


Test Status Service Test Description Duration
Hyperion Foundation
PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
PASSED DB: Database Connectivity Checking connection to database jdbc:oracle:thin:@hypbi:1521:hypdb 0 seconds
PASSED EXT: External Authentication Check Native Directory external authentication provider configuration 0 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/raframework/index.jsp
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/hyperion-bpma-server/Applications.asmx
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/interop
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/hfm
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/hfmofficeprovider/HFMOfficeProvider.aspx
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/DataSync
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/hfmlcmservice/LCMWS.asmx
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 0 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/workspace/status
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/hfmapplicationservice/Application.asmx
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/aps/APS
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/easconsole/console.html
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/calcmgr/index.htm
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 0 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/WebAnalysis
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/awb/conf/AwbConfig.xml
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/HyperionPlanning/
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/oracle-epm-fm-webservices/ApplicationService
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:80/hr/status.jsp
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/hyperion-bpma-server/Applications.asmx
Error: com.hyperion.cis.utils.BadResponseCodeException: Bad response code with GET method: 503
Recommended Action: Check that the application is started 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/hfm
Error: com.hyperion.cis.utils.BadResponseCodeException: Bad response code with GET method: 503
Recommended Action: Check that the application is started 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/hfmofficeprovider/HFMOfficeProvider.aspx
Error: com.hyperion.cis.utils.BadResponseCodeException: Bad response code with GET method: 503
Recommended Action: Check that the application is started 1 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/hfmlcmservice/LCMWS.asmx
Error: com.hyperion.cis.utils.BadResponseCodeException: Bad response code with GET method: 503
Recommended Action: Check that the application is started 0 seconds
FAILED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/hfmapplicationservice/Application.asmx
Error: com.hyperion.cis.utils.BadResponseCodeException: Bad response code with GET method: 503
Recommended Action: Check that the application is started 0 seconds
PASSED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/raframework/index.jsp 0 seconds
PASSED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/interop 0 seconds
PASSED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/DataSync 0 seconds
PASSED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/workspace/status 0 seconds
PASSED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/aps/APS 0 seconds
PASSED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/easconsole/console.html 0 seconds
PASSED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/calcmgr/index.htm 0 seconds
PASSED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/WebAnalysis 0 seconds
PASSED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/awb/conf/AwbConfig.xml 0 seconds
PASSED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/HyperionPlanning/ 0 seconds
PASSED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/oracle-epm-fm-webservices/ApplicationService 0 seconds
PASSED HTTP: HTTP Checking availability of HTTP context http://hypbi:19000/hr/status.jsp 0 seconds
PASSED WEB: Permissions All HIT entries are present in system-jazn-data.xml 0 seconds
PASSED Single Sign-On Checking availability of login http://hypbi:28080/interop/index.jsp 0 seconds
PASSED LNK: Registry Checking that all components in the registry have a link to host 2 seconds
PASSED CFG: Environment Checking whether system path variable length exceeds 2,000 0 seconds
PASSED REG: Configuration Checking if product has only one product node in registry. 0 seconds
PASSED WEB: Libraries Check if all shared libraries are targeted for application "Oracle EPM Shared Services". 0 seconds
PASSED WEB: Web Application Availability of Web application context http://hypbi:28080/interop 0 seconds
PASSED REG: Web Server Checking if Web Server linked to the all Web Applications 0 seconds
Essbase / Essbase
PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
PASSED EAS: Essbase Server Validating Essbase Server connection to hypbi 2 seconds
PASSED EAS: Essbase Server Validating Essbase Server startup using MaxL command 0 seconds
PASSED EXT: External Authentication Check Native Directory external authentication provider configuration 0 seconds
PASSED REG: Configuration Checking if product has only one product node in registry. 0 seconds
Essbase / Essbase Administration Services
PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
PASSED REG: Datasource Checking if datasource property exists in the registry 0 seconds
PASSED DB: Database Connectivity Checking connection to database jdbc:oracle:thin:@hypbi:1521:hypdb 0 seconds
PASSED EXT: External Authentication Check Native Directory external authentication provider configuration 0 seconds
PASSED REG: Configuration Checking if product has only one product node in registry. 0 seconds
PASSED WEB: Libraries Check if all shared libraries are targeted for application "Oracle EPM EAS". 0 seconds
PASSED WEB: Web Application Availability of Web application context http://hypbi:10080/easconsole/console.html 0 seconds
Essbase / Essbase Integration Services
PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
PASSED REG: Configuration Checking if product has only one product node in registry. 0 seconds
Essbase / Essbase Studio
PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
PASSED DB: Database Connectivity Checking connection to database jdbc:oracle:thin:@hypbi:1521:hypdb 0 seconds
PASSED ESS: Essbase Studio Server Validating Essbase Studio Server connection 0 seconds
PASSED EXT: External Authentication Check Native Directory external authentication provider configuration 0 seconds
PASSED REG: Configuration Checking if product has only one product node in registry. 0 seconds
Essbase / Provider Services
PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
PASSED REG: Configuration Checking if product has only one product node in registry. 0 seconds
PASSED WEB: Libraries Check if all shared libraries are targeted for application "Oracle EPM APS". 112 seconds
PASSED WEB: Web Application Availability of Web application context http://hypbi:13080/aps/APS 0 seconds
Financial Reporting
PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
PASSED REG: Datasource Checking if datasource property exists in the registry 0 seconds
PASSED DB: Database Connectivity Checking connection to database jdbc:oracle:thin:@hypbi:1521:hypdb 0 seconds
PASSED SVR: Essbase Java API Launch external checker with next command: C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\launchEssbaseJavaAPI.bat EssbaseJAPIConnect admin ****** hypbi:****** Embedded 8 seconds
PASSED REG: Configuration Checking if product has only one product node in registry. 0 seconds
PASSED WEB: Libraries Check if all shared libraries are targeted for application "Oracle EPM Financial Reporting". 0 seconds
PASSED WEB: Web Application Availability of Web application context http://hypbi:8200/hr/status.jsp 0 seconds
Foundation / Calculation Manager
PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
PASSED REG: Datasource Checking if datasource property exists in the registry 0 seconds
PASSED DB: Database Connectivity Checking connection to database jdbc:oracle:thin:@hypbi:1521:hypdb 0 seconds
PASSED EXT: External Authentication Check Native Directory external authentication provider configuration 0 seconds
PASSED REG: Configuration Checking if product has only one product node in registry. 0 seconds
PASSED WEB: Libraries Check if all shared libraries are targeted for application "Oracle EPM Calc". 0 seconds
PASSED WEB: Web Application Availability of Web application context http://hypbi:8500/calcmgr/index.htm 0 seconds
Foundation / Performance Management Architect
FAILED AppMgrLoadAdf Launch external checker with next command: C:\Oracle\Middleware\EPMSystem11R1\..\jdk160_21/bin/java -DEPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1 -DEPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1 -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\validationTool-logging.xml com.oracle.epm.epma.config.validations.appmanager.AppMgrLoadAdf
Error: AppMgrLoadAdf failed when requesting information from EPMA. Please check that all EPMA services have started and are currently running.
Recommended Action: Make sure external checker is working. 9 seconds
PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
PASSED DB: Database Connectivity Checking connection to database jdbc:oracle:thin:@hypbi:1521:hypdb 0 seconds
FAILED DimEditorLoadAdf Launch external checker with next command: C:\Oracle\Middleware\EPMSystem11R1\..\jdk160_21/bin/java -DEPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1 -DEPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1 -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\validationTool-logging.xml com.oracle.epm.epma.config.validations.dimeditor.DimEditorLoadAdf
Error: DimEditorLoadAdf failed when requesting information from EPMA. Please check that all EPMA services have started and are currently running.
Recommended Action: Make sure external checker is working. 9 seconds
FAILED EnumApplications Launch external checker with next command: C:\Oracle\Middleware\EPMSystem11R1\..\jdk160_21/bin/java -DEPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1 -DEPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1 -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\validationTool-logging.xml com.oracle.epm.epma.config.validations.repository.EnumApplications
Error: EnumApplications failed when requesting information from EPMA. Please check that all EPMA services have started and are currently running.
Recommended Action: Make sure external checker is working. 9 seconds
FAILED EnumDataSyncs Launch external checker with next command: C:\Oracle\Middleware\EPMSystem11R1\..\jdk160_21/bin/java -DEPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1 -DEPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1 -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\validationTool-logging.xml com.oracle.epm.epma.config.validations.repository.EnumDataSyncs
Error: EnumDataSyncs failed when requesting information from EPMA. Please check that all EPMA services have started and are currently running.
Recommended Action: Make sure external checker is working. 9 seconds
FAILED EnumDimensions Launch external checker with next command: C:\Oracle\Middleware\EPMSystem11R1\..\jdk160_21/bin/java -DEPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1 -DEPM_ORACLE_INSTANCE=C:\Oracle\Middleware\user_projects\epmsystem1 -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\validationTool-logging.xml com.oracle.epm.epma.config.validations.dimeditor.EnumDimensions
Error: EnumDimensions failed when requesting information from EPMA. Please check that all EPMA services have started and are currently running.
Recommended Action: Make sure external checker is working. 10 seconds
FAILED PMAJ: EPMA Service Validating whether jobmanager service is available.
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Start application 1 seconds
FAILED DSC: EPMA DimensionServer Server Configuration Validating EPMA Dimension Server startup... failed...
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 1 seconds
PASSED EXT: External Authentication Check Native Directory external authentication provider configuration 0 seconds
PASSED REG: Configuration Checking if product has only one product node in registry. 0 seconds
PASSED WEB: Libraries Check if all shared libraries are targeted for application "Oracle EPM EPMAWebTier". 0 seconds
PASSED WEB: Libraries Check if all shared libraries are targeted for application "Oracle EPM EPMADataSynchronizer". 0 seconds
PASSED WEB: Web Application Availability of Web application context http://hypbi:19091/awb/conf/AwbConfig.xml 0 seconds
PASSED WEB: Web Application Availability of Web application context http://hypbi:19101/DataSync 0 seconds
Foundation / Workspace
PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
FAILED LOG: Login Module test for raframework on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 1 seconds
FAILED LOG: Login Module test for hyperion-bpma-server on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 1 seconds
FAILED LOG: Login Module test for interop on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 1 seconds
FAILED LOG: Login Module test for hfm on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 1 seconds
FAILED LOG: Login Module test for hfmofficeprovider on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 1 seconds
FAILED LOG: Login Module test for DataSync on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 1 seconds
FAILED LOG: Login Module test for hfmlcmservice on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 0 seconds
FAILED LOG: Login Module test for hfmapplicationservice on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 1 seconds
FAILED LOG: Login Module test for aps on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 1 seconds
FAILED LOG: Login Module test for eas on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 0 seconds
FAILED LOG: Login Module test for calcmgr on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 1 seconds
FAILED LOG: Login Module test for WebAnalysis on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 1 seconds
FAILED LOG: Login Module test for awb on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 0 seconds
FAILED LOG: Login Module test for HyperionPlanning on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 0 seconds
FAILED LOG: Login Module test for oracle-epm-fm-webservices on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 1 seconds
FAILED LOG: Login Module test for hr on host hypbi:80
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check application is started. 1 seconds
PASSED Single Sign-On Checking availability of login http://hypbi:28080/workspace/status 0 seconds
PASSED REG: Configuration Checking if product has only one product node in registry. 0 seconds
PASSED REG: Registry All links are present in the registry. 0 seconds
PASSED WEB: Libraries Check if all shared libraries are targeted for application "Oracle EPM WORKSPACE". 0 seconds
PASSED WEB: Web Application Availability of Web application context http://hypbi:28080/workspace/status 0 seconds
Planning
PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
PASSED REG: Datasource Checking if datasource property exists in the registry 0 seconds
PASSED DB: Database Connectivity Checking connection to database jdbc:oracle:thin:@hypbi:1521:hypdb 0 seconds
PASSED EXT: External Authentication Check Native Directory external authentication provider configuration 0 seconds
PASSED REG: Configuration Checking if product has only one product node in registry. 0 seconds
PASSED WEB: Libraries Check if all shared libraries are targeted for application "Oracle EPM Planning". 0 seconds
PASSED WEB: Web Application Availability of Web application context http://hypbi:8300/HyperionPlanning/ 0 seconds
Reporting and Analysis
PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
PASSED REG: Datasource Checking if datasource property exists in the registry 0 seconds
PASSED DB: Database Connectivity Checking connection to database jdbc:oracle:thin:@hypbi:1521:hypdb 0 seconds
PASSED SVR: Essbase Java API Launch external checker with next command: C:\Oracle\Middleware\user_projects\epmsystem1\config\validation\11.1.2.0\launchEssbaseJavaAPI.bat EssbaseJAPIConnect admin ****** hypbi:****** Embedded 8 seconds
PASSED EXT: External Authentication Check Native Directory external authentication provider configuration 0 seconds
PASSED REG: Configuration Checking if product has only one product node in registry. 0 seconds
PASSED RA: Reporting and Analysis Check if the Reporting and Analysis Setup (RA_SETUP) component exists.
Found: 1. 0 seconds
PASSED RA: Reporting and Analysis Check if Reporting and Analysis Services and corresponding Agent Modules belong to the same host.
Reporting and Analysis Services and corresponding Agent Modules belong to the same host. 1 seconds
PASSED RA: Reporting and Analysis Check if every Reporting and Analysis Service is associated with some Agent Module.
Every Reporting and Analysis Service is associated with some Agent Module. 0 seconds
PASSED RA: Reporting and Analysis Check if the Agent (AGENT) components exist.
Found: 1. Hosts for the components: hypbi. 0 seconds
PASSED RA: Reporting and Analysis Check if the RAF Logical Web App (LOGICAL_WEB_APP) component exists.
Found: 1. 0 seconds
PASSED RA: Reporting and Analysis Check if IR DAS Services are available.
All IR DAS Services are available: default (Agent on hypbi). 0 seconds
PASSED RA: Reporting and Analysis Check if the Agent Module (AGENT_MODULE) components exist.
Found: 5. 0 seconds
PASSED RA: Reporting and Analysis Check consistency of the Service Agent properties between Registry and database tables (V8_SERVICEAGENT, V8_SA_PROPS).
Data in Registry and database are consistent. 0 seconds
PASSED RA: Reporting and Analysis Check if IR Log Services are available.
All IR Log Services are available: default (Agent on hypbi). 0 seconds
PASSED RA: Reporting and Analysis Check if IR Job Services are available.
All IR Job Services are available: default (Agent on hypbi). 0 seconds
PASSED RA: Reporting and Analysis Check if Agents are available.
All Agents are available: Agent on hypbi. 0 seconds
PASSED RA: Reporting and Analysis Check if all required Workspace configuration files exist under the RAF Logical Web App component.
All required files exist. 0 seconds
PASSED RA: Reporting and Analysis Check if Repository data folder exists.
Data file locations are valid. 0 seconds
PASSED RA: Reporting and Analysis Check if Agent Modules and corresponding Agents belong to the same host.
Agent Modules and corresponding Agents belong to the same host. 0 seconds
PASSED RA: Reporting and Analysis Check if the RAF Web App (RA_FRAMEWORK_WEB_APP) components exist.
Found: 1. Hosts for the components: hypbi. 0 seconds
PASSED RA: Reporting and Analysis Check if IR BI Services are available.
All IR BI Services are available: default (Agent on hypbi). 0 seconds
PASSED RA: Reporting and Analysis Check if the Reporting and Analysis Service (RA_SERVICE) components exist.
Found: 20. 0 seconds
PASSED RA: Reporting and Analysis Check if Job Factory data folder exists.
Data file locations are valid. 0 seconds
PASSED RA: Reporting and Analysis Check if all required RAF properties exist under the Reporting and Analysis Setup component.
All required properties exist. 0 seconds
PASSED RA: Reporting and Analysis Check if Event Server data folder exists.
Data file locations are valid. 0 seconds
PASSED RA: Reporting and Analysis Check if every Agent Module is associated with some Agent.
Every Agent Module is associated with some Agent. 0 seconds
PASSED RA: Reporting and Analysis Check consistency of the Service Agent sets between Registry and V8_SERVICEAGENT.
Data in Registry and database are consistent. 0 seconds
PASSED RA: Reporting and Analysis Check if every Agent is associated with some Agent Module(s).
Every Agent is associated with some Agent Module(s). 0 seconds
PASSED RA: Reporting and Analysis Check if the Interactive Reporting Product (INTERACTIVE_REPORTING_PRODUCT) component exists.
Found: 1. 0 seconds
PASSED RA: Reporting and Analysis Check if RAF Services are available.
All RAF Services are available: default (Agent on hypbi). 0 seconds
PASSED RA: Reporting and Analysis Check if all required RAF properties exist under the RAF Logical Web App component.
All required properties exist. 0 seconds
PASSED RA: Reporting and Analysis Check if every Agent Module (except IR Log) is associated with some Reporting and Analysis Service(s).
Every Agent Module (except IR Log) is associated with some Reporting and Analysis Service(s). 0 seconds
PASSED RA: Reporting and Analysis Check if Service Broker data folder exists.
Data file locations are valid. 0 seconds
PASSED WEB: Libraries Check if all shared libraries are targeted for application "Oracle EPM WebAnalysis". 0 seconds
PASSED WEB: Web Application Availability of Web application context http://hypbi:16000/WebAnalysis 0 seconds
Financial Management
PASSED CFG: Configuration Validating that configuration tasks have been completed 0 seconds
PASSED DB: Database Connectivity Checking connection to database jdbc:oracle:thin:@hypbi:1521:hypdb 0 seconds
PASSED EXT: External Authentication Check Native Directory external authentication provider configuration 0 seconds
PASSED CCFG: Financial Management Cluster Configuration Validating Financial Management cluster registration Successful... 0 seconds
FAILED SVR: Financial Management Service Validation Verify that the Financial Management service is working.
Error: EPMVLD-01024: The Financial Management service check failed: ERROR: while test
Recommended Action: Verify that the HatEx utility is working. Check the hat.output file from the validation logs folder for details. 0 seconds
PASSED SVR: Financial Management Server Registration Validating Financial Management Server registration Successful... 0 seconds
FAILED WSVR: Financial Management Web Server Validating Financial Management Web application connection failed...
Error: java.net.ConnectException: Connection refused: connect
Recommended Action: Check that the Financial Management Web application server is running and deployed successfully 1 seconds
PASSED ASC: Financial Management Application Server Configuration Validating Financial Management Server registration Successful... 0 seconds
FAILED LCM: LCM Provider Validating Financial Management LCM Provider connection failed...
Error: java.net.ConnectException: Connection refus

Anything going through port 19000 has passed.Since you have used Oracle HTTP as your web server.Port 80 has failed cause you have not used IIS as your web server.Hence the errors in the logs.

Manoj,

Since I redeployed to IIS server using Configurator, shouldn't it automatically use IIS and also update its start up scripts?

I tried stopping the Oracle HTTP Server from the Program Menu option and also the service "Oracle Process Manager (ohsInstancexxxxx)". But that didn't help.

How do I make everything use IIS ?

H

I know its a pain but I suggest you start from scratch in order to donfigure IIS as your web server.

Manoj, I would install it from scratch if that would solve the issue.

But looking at the "Installation and Configuration Troubleshooting Guide - RELEASE 11.1.2.1", page 70 has the following entry.
================================
Web Server Configuration

No Option Available for Configuring IIS as Web Server

Issue: You skipped Web server installation when running EPM System Installer because you are
using IIS as your Web server, but in EPM System Configurator there is no option for configuring
the Web server.

Solution: Install Oracle HTTP Server, then restart EPM System Configurator.
You must install Oracle HTTP Server even if you do not want to use it as your Web server,
because EPM System Configurator activates the Web server configuration task with the Oracle
HTTP Server installation. When Oracle HTTP Server is installed, you can choose Oracle HTTP
Server or IIS during Web server configuration.
================================

So it means, I have to install Oracle HTTP Server to have the option to select IIS as an option.
Then I would be back to square one again. Isn't it?

H

did you face this issue, if not I would not worry about it
No Option Available for Configuring IIS as Web Server

You should have two options for configuring web server in a fresh deployment
IIS
Oracle HTTP