8 Replies Latest reply: Jun 23, 2011 3:12 AM by 762351 RSS

    EPM 11.1.2.1; Verifying Shared Services Deployment; Shared Services URL

    762351
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        Spot on, thanks very much John.