7 Replies Latest reply on Dec 9, 2010 5:08 PM by Jasmine Pauline-Oracle

    EPM Process Manager and Workspace Error

    665157
      OS: Window Server 2003 usiing SQL 2005

      The error below is what I received when trying to start the Hyperion EMP Process Manager and I cannot access the Workspace but I am able to create application on the Client.

      I would appreciate your help to resolve this error. The installation and configuration came out fine without errors.



      Service cannot be started. Hyperion.DimensionServer.ProcessManager.Interface.ProcessManagerException: Cannot initialize the Session Manager. ---> Hyperion.DataAccessLayerCore.DataAccessLayerException: To run the Dimension Server, both ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT database settings must be set to 'ON'. Their values are currently 'ON' and 'OFF' respectively. Please consult the product documentation for details.
      at Hyperion.DataAccessLayerCore.DataAccessLayer..ctor(NameValueCollection settings, String tablePrefix, String baseNamespace, String schemaVersion, Boolean onlyLoadKnownTables)
      at Hyperion.DataAccessLayerCore.DataAccessLayer..ctor(NameValueCollection settings, String tablePrefix, String baseNamespace, String schemaVersion)
      at Hyperion.SessionManager.DAO.SessionManagerDataAccessLayer..ctor(NameValueCollection settings)
      at Hyperion.DimensionServer.SessionManager.SessionStoreRdbms.Initialize(String rdbmsVendor, String rdbmsConnParams, Int32 rdbmsCommandTimeout)
        • 1. Re: EPM Process Manager and Workspace Error
          Jasmine Pauline-Oracle
          * Have your DBA run the below two commands on the EPMA DB. Both ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT database settings must be set to 'ON'.

          ALTER DATABASE EPMDB
          SET READ_COMMITTED_SNAPSHOT ON

          ALTER DATABASE EPMDB
          SET ALLOW_SNAPSHOT_ISOLATION ON

          Where EPMDB is the name of the EPMA database.

          * For EPMA database and interface datasource configuration, if you are using a SQL Server named instance, you must specify a fixed port.

          HTH-
          Jasmine.
          • 2. Re: EPM Process Manager and Workspace Error
            665157
            Thank you for your immediate response. I am doing this on my own because I don't have a DB guy.

            This is what I did below and the query runs forever in SQL 2005 without fixing the problem. Please correct the Scripts or statement below for me and give me a step by step how this should be done in SQL 2005. I am aware of the severity of this DB Statement and could potentially damage by database.
            Thanks again for your help

            SET Omar;
            GO
            -- Check to see if database exists.
            Begin
            -- Set up the new default Read Committed.
            ALTER DATABASE OMAR
            SET READ_COMMITTED_SNAPSHOT ON
            ALTER DATABASE OMAR
            SET ALLOW_SNAPSHOT_ISOLATION ON
            END
            GO

            Edited by: user10392064 on Dec 7, 2010 5:48 AM
            • 3. Re: EPM Process Manager and Workspace Error
              Jasmine Pauline-Oracle
              You may run the commands individually:

              Run:
              ALTER DATABASE OMAR
              SET READ_COMMITTED_SNAPSHOT ON

              Once done, run the below:
              ALTER DATABASE OMAR
              SET ALLOW_SNAPSHOT_ISOLATION ON

              However, you may refer http://www.mssqltips.com/tip.asp?tip=1081

              HTH-
              Jasmine.
              • 4. Re: EPM Process Manager and Workspace Error
                665157
                ALTER DATABASE OMAR
                SET READ_COMMITTED_SNAPSHOT ON

                ALTER DATABASE OMAR
                SET ALLOW_SNAPSHOT_ISOLATION ON

                The command above worked, but the command below works better. Thanks for the SQL server link you provided.


                /*ALTER DATABASE OMAR
                SET READ_COMMITTED_SNAPSHOT ON;

                GO

                ALTER DATABASE OMAR
                SET ALLOW_SNAPSHOT_ISOLATION ON;

                GO*/


                However, I am now faced with another problem as indicated below. I have refreshed the DNS but no luck. Please I still need your assistance about this error.

                Service cannot be started. Hyperion.DimensionServer.ProcessManager.Interface.ProcessManagerException: Cannot initialize the Session Manager. ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 169.254.220.55:5255

                Server stack trace:
                at System.Net.Sockets.Socket.Connect(IPAddress[] addresses, Int32 port)
                at System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket(AddressFamily family)
                at System.Runtime.Remoting.Channels.RemoteConnection.CreateNewSocket()
                at System.Runtime.Remoting.Channels.RemoteConnection.GetSocket()
                at System.Runtime.Remoting.Channels.SocketCache.GetSocket(String machinePortAndSid, Boolean openNew)
                at System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.SendRequestWithRetry(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream)
                at System.Runtime.Remoting.Channels.Tcp.TcpClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders...

                Here is other related error received from diagnostic report:

                PASSED DB: Database Connection to database jdbc:weblogic:sqlserver://omar-serverltp.OMSGROUP.OMSTAX.COM:1433;databaseName=omar 0 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/hfmapplicationservice/Application.asmx
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 0 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/hfmlcmservice/LCMWS.asmx
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 1 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/hfmofficeprovider/HFMOfficeProvider.aspx
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 1 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/hfm
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 0 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/oracle-epm-fm-webservices
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 1 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/raframework/index.jsp
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 1 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/WebAnalysis
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 0 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/hr/status.jsp
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 1 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/HyperionPlanning
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 0 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/easconsole/easconsole.jnlp
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 1 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/mappingtool/faces/info.jspx
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 1 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/calcmgr/index.htm
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 1 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/awb
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 0 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/aps/APS
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 1 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/HSFWebServices/HSFWebService.asmx
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 1 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/HyperionFDM
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 1 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/hyperion-bpma-server/Applications.asmx
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 1 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/interop
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application 0 s
                FAILED HTTP: Http Availability of http context http://omar-serverltp.omsgroup.omstax.com:19000/workspace/index.jsp
                Error: java.net.ConnectException: Connection refused: connect
                Recommended Action: Start application

                For more information, see Help and Support Center at

                Edited by: user10392064 on Dec 8, 2010 7:00 AM
                • 5. Re: EPM Process Manager and Workspace Error
                  Jasmine Pauline-Oracle
                  For EPMA database and interface datasource configuration, if you are using a SQL Server named instance, you must specify a fixed port.

                  Change the 'named' SQL Server instance from using a dynamic port number to a fixed port, then re-run the configuration utility with the fixed port.

                  HTH-
                  Jasmine.
                  • 6. Re: EPM Process Manager and Workspace Error
                    665157
                    Great. Please show me how to change the SQL Instance from dynamic port to fixed port. Thanks for your help.
                    • 7. Re: EPM Process Manager and Workspace Error
                      Jasmine Pauline-Oracle
                      http://support.microsoft.com/kb/823938 might be of help.

                      HTH-
                      Jasmine.