This discussion is archived
8 Replies Latest reply: Jun 23, 2011 1:12 AM by 762351 RSS

EPM 11.1.2.1; Verifying Shared Services Deployment; Shared Services URL

762351 Newbie
Currently Being Moderated
Dear All,
I have Installed and Configured the assemblies for Essbase on Windows Server 2008 R2 (computer name ESSDATA).
I have checked and all the services are running. I could not verify Shared Services Deployment at the Shared Services URL.
When I run the EPM System Diagnostic, I get two types of Failed messages

1) At the end of each Web Application, e.g. for Provider Services:


Checking availability of login http://ESSDATA:13080/aps/APS
Error: com.hyperion.cis.utils.BadResponseCodeException: Bad response code with GET method: 404
Recommended Action: Check that the application is started

2) For Foundation/ Workspace, for every Web Application, e.g. for Provider Services:

Module test for aps on host ESSDATA:19000
Error: com.hyperion.cis.utils.BadResponseCodeException: Bad response code with POST method: 404
Recommended Action: Check that the application is started

Grateful for any pointers, thanks, Andrew.
  • 1. Re: EPM 11.1.2.1; Verifying Shared Services Deployment; Shared Services URL
    JohnGoodwin Oracle ACE
    Currently Being Moderated
    are foundation services, "Oracle Process Manager (ohsInstance..)", APS services running.

    Cheers

    John
    http://john-goodwin.blogspot.com/
  • 2. Re: EPM 11.1.2.1; Verifying Shared Services Deployment; Shared Services URL
    762351 Newbie
    Currently Being Moderated
    Hello John.

    The three Services you mention are all showing as "Started" under Services:

    1) foundation services= "Hyperion Foundation Services - Managed Server"
    2) APS services = "Hyperion Provider Services - Web Application"
    3) "Oracle Process Manager (ohsInstance..)

    I checked the HyS9FoundationServices - sysout log (per an earlier posting by you!). Every 3 hours this is posting a couple of warnings:

    <Warning> <JMX> <BEA-149515> <An error was encountered getting the attribute AdminServerListenPort on the MBean com.bea:Name=FoundationService0,Type--ServerRuntime during a call to getAttributes>
    <Warning> <JMX> <BEA-149515> <An error was encountered getting the attribute AdminServerHost on the MBean com.bea:Name=FoundationService0,Type--ServerRuntime during a call to getAttributes>

    Thanks, Andrew.

    Edited by: user9325875 on 22-Jun-2011 04:42
  • 3. Re: EPM 11.1.2.1; Verifying Shared Services Deployment; Shared Services URL
    JohnGoodwin Oracle ACE
    Currently Being Moderated
    Can you log into shared services - http://<foundationmachine>:28080/interop/index.jsp and http://<foundationmachine>:19000/interop/index.jsp

    Cheers

    John
    http://john-goodwin.blogspot.com/
  • 4. Re: EPM 11.1.2.1; Verifying Shared Services Deployment; Shared Services URL
    762351 Newbie
    Currently Being Moderated
    Hello John.
    Both of these URLs return an Error 404--not found.
    This mirrors the Failed messages in the EPM System Diagnostics output since this is the test that the diagnostic undertakes on each of the Web Apps?
    Thanks, Andrew.
  • 5. Re: EPM 11.1.2.1; Verifying Shared Services Deployment; Shared Services URL
    JohnGoodwin Oracle ACE
    Currently Being Moderated
    If you restart the foundation service and check the two HyS9FoundationServices logs are there no more errors being generated?

    Cheers

    John
    http://john-goodwin.blogspot.com/
  • 6. Re: EPM 11.1.2.1; Verifying Shared Services Deployment; Shared Services URL
    762351 Newbie
    Currently Being Moderated
    Thanks, John, for the prompt to check both theHys9FoundationServices log files (I had only checked sysout before.
    The salient lines from the logs are below (retyped so there may be minor syntax typos):

    1) sysout:
    Caused By:EPMCSS-00001:Failed to initialize EPM Shared Services Security Instance. Component SYSTEM9/FOUNDATION_SERVICES_PRODUCT/SHARED_SERVICES_PRODUCT is null in the EPM System Registry. Verify EPM Registry Configuration.

    2) syserr:
    Com.hyperion.lcm.common.managerException: Failed to connect to Registry databse. Exception – “com.hyperion.hit.registry.exceptions.RegistryException: com.hyperion.hit.registry.exceptions.RegistryException:
    com.hyperion.hit.registry.exceptions.RegistryException:
    java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.”
    Error: EPM System Security is not initialized properly

    1) sysout implies that there is a null files in the System Registry?

    2) syserr implies that the log in to the (SQL Server) Shared Services Registry is not trusted using Windows authentication? (Yet the "Installation and Configuration Guide" specifically suggest Windows authentication? I found a similar posting [see under the dotted line below] related to Remote Desktop but I am not running this.)

    Do you think the issue in (1) causes (2) as a side effect rather than due to Windows authentication?
    If (1) is the primary cause, is the best course to reconfigure by:
    a) exit EPM System Configurator
    b) delete the reg.properties file, located in user_projects/epmsystem1/config/foundation/11.1.2.0.
    c) start over in Configurator and configure with a clean Shared Services Registry database?

    Thanks, Andrew.

    -------------------------
    “Thread: 11.1.2.1 Foundation Service Problem
    Hi,

    I installed and configured EPM products on Win2008R2 x64 without any errors and all services are up, but shared service is not working properly, there are errors in service logs as below, in syserr service log file , there is a message like this; "Error: EPM System Security is not initialized properly"

    So I see Error 404--Not Found message on shared service screen. How can i fix this issue.

    We solved the problem via removing "delete temporary folders on exit" check box on win2008 r2 Remote Desktop Session Host Configuration screen.”
  • 7. Re: EPM 11.1.2.1; Verifying Shared Services Deployment; Shared Services URL
    JohnGoodwin Oracle ACE
    Currently Being Moderated
    The docs are incorrect, in the 11.1.2.1 known issues

    Defects - 7127257,7188590
    You must use native authentication with Microsoft SQL Server instead of Windows authentication. Both the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Troubleshooting Guide and the Oracle Hyperion Enterprise Performance Management System Installation Start Here state to use Windows authentication.

    Cheers

    John
    http://john-goodwin.blogspot.com/
  • 8. Re: EPM 11.1.2.1; Verifying Shared Services Deployment; Shared Services URL
    762351 Newbie
    Currently Being Moderated
    Spot on, thanks very much John.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points