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/