8 Replies Latest reply: Sep 5, 2012 10:11 AM by Madhusudhan.M RSS

    EPMA server service not started

    Madhusudhan.M
      Hi All,

      I installed Hyperion 11.1.2.2 Essbase, Planning, EPMA, Calculation Manager, FDM and HFM in the single machine in windows server 2008 R2.

      but i am facing two issues.

      1. In services, EPMA Server service not started.
      2. In FDM, I am getting error in connecting to Essbase.
      Error: Unable to retrieve target system data.

      Is any thing, i have to install additionally?

      Regards,
      mady
        • 1. Re: EPMA server service not started
          JohnGoodwin
          Check the windows event viewer for the error message after starting EPMA.

          In FDM check the error log for the error being generated, then go to Oracle Support and read doc - "FDM: How To Register The Essbase Adapter and Troubleshoot Common Issues [ID 1323041.1]"

          Cheers

          John
          http://john-goodwin.blogspot.com/
          • 2. Re: EPMA server service not started
            Madhusudhan.M
            Hi,

            In Windows Event Viewer i got this message.

            Log Name: System
            Source: Service Control Manager
            Date: 9/3/2012 12:46:12 AM
            Event ID: 7011
            Task Category: None
            Level: Error
            Keywords: Classic
            User: N/A
            Computer: hyperionepm
            Description:
            A timeout (30000 milliseconds) was reached while waiting for a transaction response from the Parallels Tools Service service.
            Event Xml:
            <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
            <System>
            <Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
            <EventID Qualifiers="49152">7011</EventID>
            <Version>0</Version>
            <Level>2</Level>
            <Task>0</Task>
            <Opcode>0</Opcode>
            <Keywords>0x8080000000000000</Keywords>
            <TimeCreated SystemTime="2012-09-03T07:46:12.612304600Z" />
            <EventRecordID>70587</EventRecordID>
            <Correlation />
            <Execution ProcessID="440" ThreadID="16540" />
            <Channel>System</Channel>
            <Computer>hyperionepm</Computer>
            <Security />
            </System>
            <EventData>
            <Data Name="param1">30000</Data>
            <Data Name="param2">Parallels Tools Service</Data>
            </EventData>
            </Event>
            • 3. Re: EPMA server service not started
              hyperionEPM
              You should take a look at the "Database Installation" part from the Installation Start here guide since if you are using Oracle Database to configure the EPMA components you need to install the Full Oracle Database Client since the PATH variable includes the path to the /bin folder for the Database client.

              Following is from the installation start here guide for EPM 11.1.2.2

              Install the full Oracle Database client on the following machines before you start your installation of EPM System products:
              Performance Management Architect Dimension server.

              Note:

              1. It is important to install the full database client as part of the installation because the PATH variable is updated to include the path to the /bin folder of the Oracle client.This setting is required for successful configuration.
              2. If you are using Oracle Database 10.2.0.4+, you must use a minimum of Oracle Database client 11.1.0.6.0.
              3. Performance Management Architect and Financial Management both require that a 64-bit Oracle Database client be installed.

              Thanks
              HyperEPM
              • 4. Re: EPMA server service not started
                hyperionEPM
                You need to check the Application Log in Event Viewer and look for the Source: EPMA Dimension server to get more clarity on the issue.


                Thanks,
                HyperEPM
                • 5. Re: EPMA server service not started
                  Madhusudhan.M
                  Hi,
                  Thanks for reply

                  I am using SQL server 2008 as Database.

                  As u mentioned, is it required for Sql sever?(Oracle database client)

                  Thanks,
                  mady
                  • 6. Re: EPMA server service not started
                    Tonka
                    On your EPMA database make sure you set
                    READ_COMMITTED_SNAPSHOT ON
                    ALLOW_SNAPSHOT_ISOLATION ON
                    • 7. Re: EPMA server service not started
                      hyperionEPM
                      Follow the steps provided by Tonka and I think your issue will get resolved. Since Database Client is required if Oracle Database is used.

                      Make sure that you run those queries on the database that was used to configure EPMA.


                      Thanks,

                      HyperEPM

                      Pl mark the answers as helpful or correct as per your issue.
                      • 8. Re: EPMA server service not started
                        Madhusudhan.M
                        Hi Tonka,

                        Thanks for reply.

                        Problem solved. EPMA server services started now.

                        regards,
                        mady