6 Ответы Последний ответ: 24.10.2012 14:21, автор: JohnGoodwin

    Network Error: Error connecting to Essbase Studio server

    967222
      Hi......I am able to login to almost all the apps (shared services, Web Analysis, FIR, Web Services etc) except EssBase Studio. When i try to login to essbase studio it says "error connecting essbase studio server"
      with detailed error "Network communication with the server failed. Check your network connection and try again.
      Connection refused: connect"

      Any idea?
        • 1. Re: Network Error: Error connecting to Essbase Studio server
          JohnGoodwin
          Have you checked the studio server log to make sure it has started up without any issues e.g <MIDDLEWARE_HOME>\user_projects\<instancename>\diagnostics\logs\EssbaseStudio\server.log
          If it has started up fully then maybe you have a firewall blocking the port.

          Cheers

          John
          http://john-goodwin.blogspot.com/
          • 2. Re: Network Error: Error connecting to Essbase Studio server
            967222
            here is the log file

            0000JeIWmdLDwW05zzWByW1GXwyc000000,0] [SRC_CLASS: com.hyperion.cp.driver.util.DriverClassLoader] [SRC_METHOD: <init>] Failed to load driver for netezza.
            [2012-10-24T16:54:50.218+05:30] [hyperion] [ERROR] [ESSSTD-145015] [com.hyperion.cp.driver] [] [nwaddr: 10.0.2.15] [tid: 10] [userId: system] [ecid: 0000JeIWmdLDwW05zzWByW1GXwyc000000,0] [SRC_CLASS: com.hyperion.cp.driver.adapters.sql.oracle.OracleConnection] [SRC_METHOD: createSQLConnection] Unable to establish connection to Oracle server.
            [2012-10-24T16:54:50.369+05:30] [hyperion] [ERROR] [ESSSTD-145015] [com.hyperion.cp.driver] [] [nwaddr: 10.0.2.15] [tid: 10] [userId: system] [ecid: 0000JeIWmdLDwW05zzWByW1GXwyc000000,0] [SRC_CLASS: com.hyperion.cp.driver.adapters.sql.oracle.OracleConnection] [SRC_METHOD: createSQLConnection] Unable to establish connection to Oracle server.
            [2012-10-24T16:54:50.369+05:30] [hyperion] [ERROR] [ESSSTD-043002] [com.hyperion.cp.catalog] [] [nwaddr: 10.0.2.15] [tid: 10] [userId: system] [ecid: 0000JeIWmdLDwW05zzWByW1GXwyc000000,0] [SRC_CLASS: com.hyperion.cp.catalog.Catalog] [SRC_METHOD: initialize] Catalog.CannotInitializeStorage=Cannot initialize catalog storage. Make sure the server.properties file contains the correct information.[[
            com.hyperion.cp.catalog.exceptions.CatalogInitializationException: Cannot initialize data storage engine.
                 at com.hyperion.cp.catalog.storage.StorageFactory.initialize(StorageFactory.java:78)
                 at com.hyperion.cp.catalog.Catalog.initialize(Catalog.java:104)
                 at com.hyperion.cp.catalog.Catalog.initialize(Catalog.java:194)
                 at com.hyperion.cp.catalog.Catalog.<clinit>(Catalog.java:81)
                 at java.lang.Class.forName0(Native Method)
                 at java.lang.Class.forName(Class.java:169)
                 at com.hyperion.cp.catalog.CatalogInitializer.run(CatalogInitializer.java:71)
                 at com.hyperion.cp.server.RequestListener$SystemTask.run(RequestListener.java:1318)
                 at com.hyperion.cp.server.RequestListener.runSystemTask(RequestListener.java:184)
                 at com.hyperion.cp.server.RequestListener.<init>(RequestListener.java:130)
                 at com.hyperion.cp.server.ServerMain.initServer(ServerMain.java:209)
                 at com.hyperion.cp.server.ServerMain.main(ServerMain.java:289)
            Caused by: com.hyperion.cp.driver.util.DriverConnectionException: Cannot establish connection to Oracle server.
                 at com.hyperion.cp.driver.adapters.sql.oracle.OracleConnection.createSQLConnection(OracleConnection.java:283)
                 at com.hyperion.cp.driver.adapters.sql.SQLConnection$ConnectionPool.<init>(SQLConnection.java:1226)
                 at com.hyperion.cp.driver.adapters.sql.SQLConnection.construct(SQLConnection.java:450)
                 at com.hyperion.cp.driver.ConnectionManager.getConnection(ConnectionManager.java:112)
                 at com.hyperion.cp.driver.DriverEngine.getConnection(DriverEngine.java:60)
                 at com.hyperion.cp.server.QueueableTask.setMetadataConnection(QueueableTask.java:53)
                 at com.hyperion.cp.catalog.storage.StorageFactory.initialize(StorageFactory.java:61)
                 ... 11 more
            Caused by: java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress

                 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
                 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:397)
                 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
                 at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:448)
                 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
                 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
                 at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:409)
                 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:395)
                 at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)
                 at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:238)
                 at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
                 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
                 at java.sql.DriverManager.getConnection(DriverManager.java:582)
                 at java.sql.DriverManager.getConnection(DriverManager.java:154)
                 at com.hyperion.cp.driver.adapters.sql.oracle.OracleConnection.createSQLConnection(OracleConnection.java:273)
                 ... 17 more

            ]]
            • 3. Re: Network Error: Error connecting to Essbase Studio server
              JohnGoodwin
              Are you sure your oracle database was definitely fully running when you started the studio service

              Caused by: java.sql.SQLRecoverableException: ORA-01033: ORACLE initialization or shutdown in progress

              Check the Oracle database is running and you can log in, stop the studio service, clear the studio log, start the studio service, check the log

              Cheers

              John
              http://john-goodwin.blogspot.com/
              1 пользователь считает эту информацию полезной
              • 4. Re: Network Error: Error connecting to Essbase Studio server
                967222
                John...Thanks for responding quickly.

                Oracle is up and running. Just tried simple query select * from ess_failover_lease and am able to connect and it doesnot give any results.

                Cleared the logs, stopeed service and re-started, but no change.

                Could you please let me know which is good way of restarting studio service? either through scripts or Oracle EPM system--> Essbase --> Essbase Studio --> start server.

                Also it was working correctly few days back....i was able to login to Essbase studio...

                Edited by: User006 on Oct 24, 2012 6:30 AM
                • 5. Re: Network Error: Error connecting to Essbase Studio server
                  967222
                  Issue is resolved.

                  Stopped all EPM services including Oracle DB service and listener. Cleared Windows Event logs and restarted all services.

                  Thanks John for the help.
                  • 6. Re: Network Error: Error connecting to Essbase Studio server
                    JohnGoodwin
                    User006 wrote:
                    Issue is resolved.

                    Stopped all EPM services including Oracle DB service and listener. Cleared Windows Event logs and restarted all services.

                    Thanks John for the help.
                    No problem :)

                    Cheers

                    John
                    http://john-goodwin.blogspot.com/