8 Replies Latest reply on Sep 5, 2012 3:11 PM by Madhu. Meesala

    EPMA server service not started

    Madhu. Meesala
      Hi All,

      I installed Hyperion 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?

        • 1. Re: EPMA server service not started
          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]"


          • 2. Re: EPMA server service not started
            Madhu. Meesala

            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
            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">
            <Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
            <EventID Qualifiers="49152">7011</EventID>
            <TimeCreated SystemTime="2012-09-03T07:46:12.612304600Z" />
            <Correlation />
            <Execution ProcessID="440" ThreadID="16540" />
            <Security />
            <Data Name="param1">30000</Data>
            <Data Name="param2">Parallels Tools Service</Data>
            • 3. Re: EPMA server service not started
              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

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


              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, you must use a minimum of Oracle Database client
              3. Performance Management Architect and Financial Management both require that a 64-bit Oracle Database client be installed.

              • 4. Re: EPMA server service not started
                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.

                • 5. Re: EPMA server service not started
                  Madhu. Meesala
                  Thanks for reply

                  I am using SQL server 2008 as Database.

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

                  • 6. Re: EPMA server service not started
                    On your EPMA database make sure you set
                    READ_COMMITTED_SNAPSHOT ON
                    • 7. Re: EPMA server service not started
                      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.



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

                        Thanks for reply.

                        Problem solved. EPMA server services started now.