11 Replies Latest reply on Oct 19, 2009 3:09 PM by timtow

    Not able to add Essbase server in EAS console

    686273
      Hi Friends,
      I hope someone will be able to assist me on, not able to figure out the exact cause..when i try to expand the essbase server in EAS.i do not see any applications.
      the following is the log file from logs\eas\easserver

      Information message (Oct 5, 2009 12:40:58 PM):
      [7D62824CF871EB996EC0A951EE2DC9AF.eas_thadak_10080]
      AdminCommandListener: Command 'com.essbase.eas.admin.defs.AdminCommands.GetUserServerList' routed to 'getUserServerList'
      op => com.essbase.eas.admin.defs.AdminCommands.GetUserServerList
      username => admin
      servertype => all
      Information message (Oct 5, 2009 12:40:58 PM):
      [7D62824CF871EB996EC0A951EE2DC9AF.eas_thadak_10080]
      AdminCommandListener: Command 'com.essbase.eas.admin.defs.AdminCommands.RemoveServerFromUserList' routed to 'removeServerFromUserList'
      op => com.essbase.eas.admin.defs.AdminCommands.RemoveServerFromUserList
      username => admin
      servertype => com.essbase.eas.essbase.server.EssSession
      easservername => thadak
      Information message (Oct 5, 2009 12:40:58 PM):
      [7D62824CF871EB996EC0A951EE2DC9AF.eas_thadak_10080]
      ServerCommandListener: Command 'com.essbase.eas.essbase.defs.ServerCommands.Disconnect' routed to 'disconnect'
      op => com.essbase.eas.essbase.defs.ServerCommands.Disconnect
      servername => thadak
      Information message (Oct 5, 2009 12:41:39 PM):
      [7D62824CF871EB996EC0A951EE2DC9AF.eas_thadak_10080]
      AdminCommandListener: Command 'com.essbase.eas.admin.defs.AdminCommands.AddServerToUserList' routed to 'addServerToUserList'
      serverpassword => ******
      op => com.essbase.eas.admin.defs.AdminCommands.AddServerToUserList
      External => false
      serverusername => admin
      username => admin
      servertype => com.essbase.eas.essbase.server.EssSession
      easservername => thadak
      Information message (Oct 5, 2009 12:41:39 PM):
      [7D62824CF871EB996EC0A951EE2DC9AF.eas_thadak_10080]
      ServerCommandListener: Command 'com.essbase.eas.essbase.defs.ServerCommands.Connect' routed to 'connect'
      op => com.essbase.eas.essbase.defs.ServerCommands.Connect
      servername => thadak
      Error message (Oct 5, 2009 12:41:39 PM):
      [7D62824CF871EB996EC0A951EE2DC9AF.eas_thadak_10080]
      Failed to get MaxlConnection
      Exception message (Oct 5, 2009 12:41:39 PM):
      [7D62824CF871EB996EC0A951EE2DC9AF.eas_thadak_10080]
      hasAppManOption
      java.lang.UnsatisfiedLinkError: hasAppManOption
      at com.essbase.eas.essbase.api.jni.EssCoreJni.hasAppManOption(Native Method)
      at com.essbase.eas.essbase.server.EssSessionPrimitives.connect(Unknown Source)
      at com.essbase.eas.essbase.server.EssSessionPrimitives.connect(Unknown Source)
      at com.essbase.eas.essbase.server.EssSession.connect(Unknown Source)
      at com.essbase.eas.server.SessionLogic.connect(Unknown Source)
      at com.essbase.eas.server.SessionManager.getSession(Unknown Source)
      at com.essbase.eas.server.SessionManager.getSession(Unknown Source)
      at com.essbase.eas.essbase.server.ServerCommandListener.connect(Unknown Source)
      at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at com.essbase.eas.framework.server.application.AbstractCommandListener.handleEvent(Unknown Source)
      at com.essbase.eas.framework.server.application.DefaultCommandDispatcher.dispatchEvent(Unknown Source)
      at com.essbase.eas.framework.server.application.DefaultEventController.handleEvent(Unknown Source)
      at com.essbase.eas.framework.server.application.EventDispatcherWorkListener.handleEvent(Unknown Source)
      at com.essbase.eas.framework.server.application.DefaultWorkDispatcher.dispatchEvent(Unknown Source)
      at com.essbase.eas.framework.server.application.DefaultEventController.handleEvent(Unknown Source)
      at com.essbase.eas.framework.server.application.DefaultApplication.generateWorkEvent(Unknown Source)
      at com.essbase.eas.framework.server.application.DefaultServlet.handleRequest(Unknown Source)
      at com.essbase.eas.server.AppManServlet.doPost(Unknown Source)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
      at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      at java.lang.Thread.run(Thread.java:595)
      thanks for your time and help
        • 1. Re: Not able to add Essbase server in EAS console
          Dornakal
          did you check your essbase service in your list of services.
          is it running.
          • 2. Re: Not able to add Essbase server in EAS console
            JohnGoodwin
            Are you on a windows platform and version11?, if so check the log \hyperion\logs\services\HyS9eas-sysout.log

            Failed to get MaxlConnection
            Exception message (Oct 5, 2009 12:41:39 PM):
            http://7D62824CF871EB996EC0A951EE2DC9AF.eas_thadak_10080
            hasAppManOption
            java.lang.UnsatisfiedLinkError: hasAppManOption

            This error points towards a classpath or pathing issue.

            Cheers

            John
            http://john-goodwin.blogspot.com/
            • 3. Re: Not able to add Essbase server in EAS console
              686273
              Hi Guys,
              thanks for your time. I hope that i get out of this issue with some one assistance

              1. Windows 2000 Adv Server with sp4
              2. EPM 11.1.1.3
              3. Essbase is running as service in services - I can connect to essbase server from excel and do a retrieve
              4. EAS server is running

              path variable value
              --------------------
              C:\Hyperion\common\JRE\Sun\1.5.0\bin; C:\Hyperion\common\CSS\9.5.0.0\bin;
              C:\Hyperion\products\Essbase\EssbaseClient\bin;
              C:\Hyperion\products\Essbase\EssbaseClient;

              C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;
              C:\Program Files\Oracle\jre\1.1.8\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;
              C:\Program Files\STRATEGY\Bin;

              C:\Program Files\STRATEGY\JRE\bin;
              C:\Program Files\STRATEGY\JRE\bin\client;
              C:\Program Files\Microsoft SQL Server\90\Tools\bin;

              C:\Hyperion\common\ODBC\Merant\5.2\Drivers;
              C:\Hyperion\products\Essbase\eas\server\bin;
              C:\Hyperion\products\Essbase\eas\console\bin
              -----------------------------------------------------------------------------------------------------------
              These are my system variables

              APS_HOME = C:\Hyperion\products\Essbase\aps
              ARBORPATH = C:\Hyperion\products\Essbase\EssbaseServer
              EAS_HOME = C:\Hyperion\products\Essbase\eas\server
              ESSBASEPATH = C:\Hyperion\products\Essbase\EssbaseServer
              ESSLANG = English_UnitedStates.Latin1@Binary
              HYPERION_HOME = C:\Hyperion
              ISLOADINFO = C:\Hyperion\products\Essbase\eis\server\loadinfo
              SMARTSEARCH_HOME = C:\Hyperion\products\Essbase\SmartSearch

              shared services URL: http://thadak:28080/interop/

              when i click on launch application i get the following error

              "an error was encounted while performing this operation"

              but the configuration tool is showing like successfully configured. - service is running

              please let me know if you need any further information
              • 4. Re: Not able to add Essbase server in EAS console
                686273
                guys, still not able to fix the issue,please can any one suggest the best way to resolve this issue.

                thanks for your time
                • 5. Re: Not able to add Essbase server in EAS console
                  723501
                  Rajender,

                  your shared services is not running, although in services it shows as started don't assume that it's really started. Please restart the shared services. With the same error last time I have wasted so much of time...

                  let me know the outcome..

                  Edited by: oracleSQR on Oct 8, 2009 8:13 AM
                  • 6. Re: Not able to add Essbase server in EAS console
                    686273
                    thanks for your time.
                    This is what i did. Stopped the following services in services

                    1.Hyperion Foundation OpenLDAP
                    2.Hyperion Foundation Shared Services - Web Application
                    3.Hyperion Administration Services - Web Application
                    4.Hyperion Essbase Services 11.1.1-hypservice_1

                    then started the ablove services in the same order - manually
                    all the services were started
                    in the essbase service window it is showing as - External Authentication Module - Sigle Sign On - Enabled

                    from the EAS console when i expand the essbase server - it gives the following error

                    java.exe - Entry Point Not Found

                    The procedure entry point MiniDumpWriteDump could not be located in the dynamic link library dbghelp.dll

                    thanks again for your time
                    • 7. Re: Not able to add Essbase server in EAS console
                      686273
                      thanks again for your time. I noticed the following logs and has got errors

                      The following is from registry log
                      --------------------------------------------
                      2009-09-29 12:58:17,109 [Foundation Server] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(BUF='32-bit Windows Error: 2: No such file or directory'))))
                      2009-09-29 13:33:36,000 [main] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver]Error establishing socket to host and port: thadak:1521. Reason: Connection refused: connect
                      2009-09-29 13:34:09,359 [start] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]ORA-01034: ORACLE not available
                      ORA-27101: shared memory realm does not exist

                      2009-09-29 13:34:14,671 [main] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]ORA-01034: ORACLE not available
                      ORA-27101: shared memory realm does not exist

                      2009-09-29 13:34:32,906 [main] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress

                      2009-09-29 13:34:36,796 [main] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress

                      2009-09-29 13:34:36,875 [main] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress

                      2009-09-29 13:35:10,187 [main] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress

                      2009-09-29 13:35:20,859 [main] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress

                      2009-09-29 13:35:21,406 [main] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress

                      ------------------------------------------------------------------------------------------------
                      The following is from sharedservices_audit_client log

                      2009-09-29 12:26:51,546 [main] INFO com.hyperion.audit.client.runtime.AuditRuntime - Audit Client has been created for the server http://thadak:28080/interop/Audit
                      2009-09-29 12:27:03,218 [pinging] INFO com.hyperion.audit.client.cache.AuditConfigFilter - Client Enable Status false
                      2009-09-29 12:27:04,156 [filterConfig] INFO com.hyperion.audit.client.cache.AuditConfigFilter - Client Enable Status false
                      2009-09-29 12:45:16,625 [http-10080-Processor4] INFO com.hyperion.audit.client.runtime.AuditRuntime - Audit Client has been created for the server http://thadak:28080/interop/Audit
                      2009-09-29 12:45:17,390 [pinging] INFO com.hyperion.audit.client.cache.AuditConfigFilter - Client Enable Status false
                      2009-09-29 12:45:17,921 [filterConfig] INFO com.hyperion.audit.client.cache.AuditConfigFilter - Client Enable Status false
                      2009-09-29 12:58:10,218 [filterConfig] ERROR com.hyperion.audit.client.commons.util.AuditClientValidateUser - Audit Client Not Started due to Authentication Failure
                      2009-09-29 13:42:12,359 [http-10080-Processor3] INFO com.hyperion.audit.client.runtime.AuditRuntime - Audit Client has been created for the server http://thadak:28080/interop/Audit
                      2009-09-29 13:42:12,578 [pinging] ERROR com.hyperion.audit.client.AuditXmlRpcClient - Not able to connect to the server http://thadak:28080/interop/Audit-
                      java.io.IOException: Server returned HTTP response code: 500 for URL: http://thadak:28080/interop/Audit
                           at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1170)
                           at org.apache.xmlrpc.DefaultXmlRpcTransport.sendXmlRpc(DefaultXmlRpcTransport.java:87)
                           at org.apache.xmlrpc.XmlRpcClientWorker.execute(XmlRpcClientWorker.java:72)
                           at org.apache.xmlrpc.XmlRpcClient.execute(XmlRpcClient.java:194)
                           at org.apache.xmlrpc.XmlRpcClient.execute(XmlRpcClient.java:185)
                           at org.apache.xmlrpc.XmlRpcClient.execute(XmlRpcClient.java:178)
                           at com.hyperion.audit.client.AuditXmlRpcClient.pingServerForStartUp(Unknown Source)
                           at com.hyperion.audit.client.runtime.PingForServerStartUp.run(Unknown Source)


                      2009-09-29 13:45:12,640 [pinging] ERROR com.hyperion.audit.client.AuditXmlRpcClient - Not able to connect to the server http://thadak:28080/interop/Audit-
                      java.io.IOException: Server returned HTTP response code: 500 for URL: http://thadak:28080/interop/Audit
                           at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1170)
                           at org.apache.xmlrpc.DefaultXmlRpcTransport.sendXmlRpc(DefaultXmlRpcTransport.java:87)
                           at org.apache.xmlrpc.XmlRpcClientWorker.execute(XmlRpcClientWorker.java:72)
                           at org.apache.xmlrpc.XmlRpcClient.execute(XmlRpcClient.java:194)
                           at org.apache.xmlrpc.XmlRpcClient.execute(XmlRpcClient.java:185)
                           at org.apache.xmlrpc.XmlRpcClient.execute(XmlRpcClient.java:178)
                           at com.hyperion.audit.client.AuditXmlRpcClient.pingServerForStartUp(Unknown Source)
                           at com.hyperion.audit.client.runtime.PingForServerStartUp.run(Unknown Source)


                      2009-09-29 13:48:12,718 [pinging] ERROR com.hyperion.audit.client.AuditXmlRpcClient - Not able to connect to the server http://thadak:28080/interop/Audit-
                      java.io.IOException: Server returned HTTP response code: 500 for URL: http://thadak:28080/interop/Audit
                           at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1170)
                           at org.apache.xmlrpc.DefaultXmlRpcTransport.sendXmlRpc(DefaultXmlRpcTransport.java:87)
                           at org.apache.xmlrpc.XmlRpcClientWorker.execute(XmlRpcClientWorker.java:72)
                           at org.apache.xmlrpc.XmlRpcClient.execute(XmlRpcClient.java:194)
                           at org.apache.xmlrpc.XmlRpcClient.execute(XmlRpcClient.java:185)
                           at org.apache.xmlrpc.XmlRpcClient.execute(XmlRpcClient.java:178)
                           at com.hyperion.audit.client.AuditXmlRpcClient.pingServerForStartUp(Unknown Source)
                           at com.hyperion.audit.client.runtime.PingForServerStartUp.run(Unknown Source)

                      -----------------------------------------------------------------------------------------------------------------------------------------
                      the following is from sharedservices_security log

                      2009-09-29 12:26:43,718 WARN [main] com.hyperion.css.spi.util.upgrade.UpgradeUtility.startMigration(Unknown Source) -- Native Directory Upgrade completed successfully.
                      2009-09-29 12:26:44,328 WARN [main] com.hyperion.css.spi.util.upgrade.UpgradeUtilityV3.startMigration(Unknown Source) -- Native Directory Upgrade completed successfully.
                      2009-09-29 12:28:52,828 WARN [http-28080-Processor9] com.hyperion.css.spi.impl.nv.XMLRoleRegDocumentModel.recurseDocumentTree(Unknown Source) -- The Product 'Reporting and Analysis' Version '9.3.1' in the Registration file does not match the application version '9.5.0'
                      2009-09-29 12:38:21,656 WARN [http-28080-Processor8] com.hyperion.css.spi.impl.nv.XMLRoleRegDocumentModel.recurseDocumentTree(Unknown Source) -- The Product 'Analytic Provider Services' Version '11.1.1' in the Registration file does not match the application version '9.5.0'
                      2009-09-29 13:35:10,890 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-09-29 13:35:11,015 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-09-29 14:36:08,890 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-09-29 14:36:08,921 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-09-29 22:08:36,359 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-09-29 22:08:36,750 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-09-29 22:35:46,031 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-09-29 22:35:46,062 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-09-29 22:46:24,546 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-09-29 22:46:24,609 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-09-29 23:15:10,859 WARN [main] com.hyperion.css.sync.impl.CSSMigrationAPIImpl.migrate(Unknown Source) -- Started Native Directory Migration!!!!
                      2009-09-29 23:15:10,937 WARN [main] com.hyperion.css.sync.impl.CSSMigrationAPIImpl.migrate(Unknown Source) -- Native Directory Migration log files are available at : C:\Hyperion\logs\SharedServices9\migration
                      2009-09-30 08:28:31,062 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-09-30 08:28:31,421 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-09-30 10:51:32,031 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-09-30 10:51:32,109 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-09-30 16:26:44,531 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-09-30 16:26:44,562 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-09-30 18:22:29,093 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-09-30 18:22:29,203 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-09-30 19:05:42,296 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-09-30 19:05:42,312 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-09-30 19:18:56,187 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-09-30 19:18:56,312 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-10-01 08:20:52,406 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-10-01 08:20:52,578 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-10-01 09:03:14,203 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-10-01 09:03:14,218 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-10-01 09:23:28,218 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-10-01 09:23:28,562 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-10-01 12:13:44,593 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-10-01 12:13:44,640 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-10-01 12:55:31,609 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-10-01 12:55:31,640 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-10-01 15:34:02,671 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-10-01 15:34:02,906 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-10-01 20:52:42,765 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-10-01 20:52:42,781 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-10-02 09:45:47,109 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-10-02 09:45:47,140 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-10-02 13:33:35,468 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]
                      2009-10-02 13:33:35,750 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                      2009-10-02 13:54:39,812 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                      ]



                      thanks for your time
                      • 8. Re: Not able to add Essbase server in EAS console
                        723501
                        Can you try connecting to shared services database(oracle ) from sqlplus ?

                        Edited by: oracleSQR on Oct 8, 2009 1:25 PM
                        • 9. Re: Not able to add Essbase server in EAS console
                          686273
                          yes.i can connect and i did check through sqlplus and toad.

                          for the first time after competion of configuration. the configtool_err has the below, but my guess is this is not an issue as i can connect to essbase server from excel.

                          (Oct 09, 2009, 05:44:24 AM), com.hyperion.essbase.config.EssbaseAgentTaskProcessor, ERROR,
                          Error in executing the script to register Essbase as a service: exitCode = 1


                          the following are from OlapAdmin properties file in eas/server
                          ----------------------------------------------------------------------------------

                          #Fri Oct 09 05:44:09 EDT 2009
                          SMTP_HOST=[smtp.yourcompany.com]
                          SECURITY_CONFIGURATION= ----- not sure if this is an issue
                          ESSLANG=English_UnitedStates.Latin1@Binary
                          HUBProvisionEnabled=true
                          ARCHIVE_CACHE_CAPACITY=20

                          the below are from configtool summary
                          -----------------------------------------------------

                          ---- Product Configuration Summary.....

                          ( Oct 9, 2009 5:41:08 AM ): ---- Hyperion Foundation Configuration......
                          ( Oct 9, 2009 5:41:16 AM ): Configure Database :: pass
                          ( Oct 9, 2009 5:41:16 AM ): Common Settings :: pass
                          ( Oct 9, 2009 5:42:12 AM ): Deploy to Application Server :: pass

                          ( Oct 9, 2009 5:43:15 AM ): ---- Provider Services Configuration......
                          ( Oct 9, 2009 5:43:22 AM ): Register with Shared Services :: pass
                          ( Oct 9, 2009 5:43:26 AM ): Deploy to Application Server :: pass

                          ( Oct 9, 2009 5:43:26 AM ): ---- Studio Configuration......
                          ( Oct 9, 2009 5:43:33 AM ): Register with Shared Services :: pass
                          ( Oct 9, 2009 5:43:37 AM ): Configure Database :: pass

                          ( Oct 9, 2009 5:43:37 AM ): ---- Essbase Administration Services Configuration......
                          ( Oct 9, 2009 5:43:39 AM ): Configure Database :: pass
                          ( Oct 9, 2009 5:43:43 AM ): Register with Shared Services :: pass
                          ( Oct 9, 2009 5:44:13 AM ): Deploy to Application Server :: pass

                          ( Oct 9, 2009 5:44:14 AM ): ---- Essbase Configuration......
                          ( Oct 9, 2009 5:44:14 AM ): Register with Shared Services :: pass
                          ( Oct 9, 2009 5:44:28 AM ): Essbase Custom Configuration :: pass

                          ( Oct 9, 2009 5:44:28 AM ): ---- Workspace Configuration......
                          ( Oct 9, 2009 5:44:36 AM ): Register with Shared Services :: pass
                          ( Oct 9, 2009 5:45:20 AM ): Configure Database :: pass
                          ( Oct 9, 2009 5:47:00 AM ): Deploy to Application Server :: pass
                          ( Oct 9, 2009 5:47:05 AM ): Configure Web Server :: pass
                          ----------------------------------------------------------------------------------------

                          the following is from eas server log
                          -----------------------------------------------
                          Information message (Oct 9, 2009 10:06:28 AM):
                          Initializing AppManServlet
                          Information message (Oct 9, 2009 10:06:28 AM):
                          EAS_HOME=C:\Hyperion\products\Essbase\eas
                          Information message (Oct 9, 2009 10:06:28 AM):
                          ESSBASEPATH is set from the OS environment
                          Information message (Oct 9, 2009 10:06:28 AM):
                          ESSBASEPATH=C:\Hyperion\products\Essbase\eas\server
                          Information message (Oct 9, 2009 10:06:28 AM):
                          ARBORPATH=C:\Hyperion\products\Essbase\eas\server
                          Information message (Oct 9, 2009 10:06:28 AM):
                          ESSLANG=English_UnitedStates.Latin1@Binary
                          Information message (Oct 9, 2009 10:06:28 AM):
                          PATH=C:\Hyperion\products\Essbase\eas\server\bin;C:\Hyperion\common\JRE\Sun\1.5.0\bin;C:\Hyperion\common\SAP\bin;C:\Hyperion\common\CSS\9.5.0.0\bin;C:\Hyperion\products\Essbase\EssbaseClient\bin;C:\Hyperion\products\Essbase\EssbaseClient;C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\STRATEGY\Bin;C:\Program Files\STRATEGY\JRE\bin;C:\Program Files\STRATEGY\JRE\bin\client;C:\Program Files\Microsoft SQL Server\90\Tools\bin ;C:\Hyperion\common\ODBC\Merant\5.2\Drivers;C:\Hyperion\products\Essbase\eas\server\bin;C:\Hyperion\products\Essbase\eas\console\bin;C:\Hyperion\common\JRE\Sun\1.5.0\bin
                          Information message (Oct 9, 2009 10:06:28 AM):
                          C:\Hyperion\products\Essbase\eas\server\bin added to PATH explicitly
                          Information message (Oct 9, 2009 10:06:28 AM):
                          PATH=C:\Hyperion\products\Essbase\eas\server\bin;C:\Hyperion\common\JRE\Sun\1.5.0\bin;C:\Hyperion\common\SAP\bin;C:\Hyperion\common\CSS\9.5.0.0\bin;C:\Hyperion\products\Essbase\EssbaseClient\bin;C:\Hyperion\products\Essbase\EssbaseClient;C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\STRATEGY\Bin;C:\Program Files\STRATEGY\JRE\bin;C:\Program Files\STRATEGY\JRE\bin\client;C:\Program Files\Microsoft SQL Server\90\Tools\bin ;C:\Hyperion\common\ODBC\Merant\5.2\Drivers;C:\Hyperion\products\Essbase\eas\server\bin;C:\Hyperion\products\Essbase\eas\console\bin;C:\Hyperion\common\JRE\Sun\1.5.0\bin
                          Information message (Oct 9, 2009 10:06:28 AM):
                          PATH=C:\Hyperion\products\Essbase\eas\server\bin;C:\Hyperion\common\JRE\Sun\1.5.0\bin;C:\Hyperion\common\SAP\bin;C:\Hyperion\common\CSS\9.5.0.0\bin;C:\Hyperion\products\Essbase\EssbaseClient\bin;C:\Hyperion\products\Essbase\EssbaseClient;C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\STRATEGY\Bin;C:\Program Files\STRATEGY\JRE\bin;C:\Program Files\STRATEGY\JRE\bin\client;C:\Program Files\Microsoft SQL Server\90\Tools\bin ;C:\Hyperion\common\ODBC\Merant\5.2\Drivers;C:\Hyperion\products\Essbase\eas\server\bin;C:\Hyperion\products\Essbase\eas\console\bin;C:\Hyperion\common\JRE\Sun\1.5.0\bin
                          Information message (Oct 9, 2009 10:06:28 AM):
                          java.library.path=C:\Hyperion\deployments\Tomcat5\bin;.;C:\WINNT\system32;C:\WINNT;C:\Hyperion\common\JRE\Sun\1.5.0\bin;C:\Hyperion\common\SAP\bin;C:\Hyperion\products\Essbase\eas\server\bin;C:\Hyperion\common\CSS\9.5.0.0\bin;C:\Hyperion\products\Essbase\EssbaseClient\bin;C:\Hyperion\products\Essbase\EssbaseClient;C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\STRATEGY\Bin;C:\Program Files\STRATEGY\JRE\bin;C:\Program Files\STRATEGY\JRE\bin\client;C:\Program Files\Microsoft SQL Server\90\Tools\bin ;C:\Hyperion\common\ODBC\Merant\5.2\Drivers;C:\Hyperion\products\Essbase\eas\server\bin;C:\Hyperion\products\Essbase\eas\console\bin;C:\Hyperion\common\JRE\Sun\1.5.0\bin
                          Exception message (Oct 9, 2009 10:06:40 AM):
                          20:1092:Failed to initialize EPM System registry.
                                    
                                    Error Code: 9
                                    com.hyperion.css.common.configuration.CSSConfigurationException: 20:1092:Failed to initialize EPM System registry.      Error Code: 9
                                    NestedException:
                                    com.hyperion.hit.registry.exceptions.RegistryException: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01034: ORACLE not available
                                    ORA-27101: shared memory realm does not exist
                          ---------------------------------------------------------------------------------------------------------------------------------------

                          the below is from shared_services_security log
                          ---------------------------------------------------------------

                          2009-10-09 05:42:49,078 WARN [main] com.hyperion.css.spi.util.upgrade.UpgradeUtility.startMigration(Unknown Source) -- Native Directory Upgrade completed successfully.
                          2009-10-09 05:42:50,578 WARN [main] com.hyperion.css.spi.util.upgrade.UpgradeUtilityV3.startMigration(Unknown Source) -- Native Directory Upgrade completed successfully.
                          2009-10-09 05:43:21,812 WARN [http-28080-Processor8] com.hyperion.css.spi.impl.nv.XMLRoleRegDocumentModel.recurseDocumentTree(Unknown Source) -- The Product 'Analytic Provider Services' Version '11.1.1' in the Registration file does not match the application version '9.5.0'
                          2009-10-09 05:44:33,156 WARN [http-28080-Processor4] com.hyperion.css.spi.impl.nv.XMLRoleRegDocumentModel.recurseDocumentTree(Unknown Source) -- The Product 'Reporting and Analysis' Version '9.3.1' in the Registration file does not match the application version '9.5.0'
                          2009-10-09 10:07:38,859 ERROR [main] com.hyperion.css.registry.RegistryManager.<init>(Unknown Source) -- 20:1092:Failed to initialize EPM System registry. [Root Cause: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                          ]
                          2009-10-09 10:07:38,968 ERROR [main] com.hyperion.css.CSSSystem.initCSSSystem(Unknown Source) -- Arguments: param1={}, param2=null, param3=null,
                          2009-10-09 10:53:23,453 WARN [main] com.hyperion.css.sync.impl.CSSMigrationAPIImpl.migrate(Unknown Source) -- Started Native Directory Migration!!!!
                          2009-10-09 10:53:23,578 WARN [main] com.hyperion.css.sync.impl.CSSMigrationAPIImpl.migrate(Unknown Source) -- Native Directory Migration log files are available at : C:\Hyperion\logs\SharedServices9\migration
                          ----------------------------------------------------------------------------------------------
                          the below is from registry log file
                          -------------------------------------------
                          2009-10-09 06:04:49,968 [Foundation Server] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12500)(ERROR_STACK=(ERROR=(CODE=12500)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)(EMFI=4))(ERROR=(BUF='32-bit Windows Error: 2: No such file or directory'))))
                          2009-10-09 10:06:23,500 [main] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver]Error establishing socket to host and port: thadak:1521. Reason: Connection refused: connect
                          2009-10-09 10:06:47,562 [start] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress

                          2009-10-09 10:07:07,062 [main] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress

                          2009-10-09 10:07:37,906 [main] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress

                          2009-10-09 10:07:56,328 [main] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress

                          2009-10-09 10:07:59,609 [main] ERROR com.hyperion.hit.registry.RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress
                          -------------------------------------------------------------------------------------------------------------------------------------------

                          the following is from HyS9eas-sysout log
                          ------------------------------------------------------
                          [INFO] RegistryLogger - REGISTRY LOG INITIALIZED
                          [INFO] RegistryLogger - REGISTRY LOG INITIALIZED
                          [ERROR] RegistryUtils - SQL Exception when trying to create a new connection [Hyperion][Oracle JDBC Driver][Oracle]ORA-01034: ORACLE not available
                          ORA-27101: shared memory realm does not exist


                          *******************************************************************************
                          * CRITICAL ERROR: Common Security Services initialization failed. Please *
                          * make sure that a valid entry is provided for SECURITY_CONFIGURATION in *
                          * OlapAdmin.properties. This is required if Shared Services is enabled. *
                          * Please restart the server after the changes. *
                          *******************************************************************************

                          Stopping DAO factory!
                          HBR Configuration has not been initialized. Make sure you have logged in sucessfully and there are no exceptions in the HBR log file.
                          java.lang.ExceptionInInitializerError
                               at java.lang.Class.forName0(Native Method)
                               at java.lang.Class.forName(Class.java:242)
                               at com.essbase.eas.framework.defs.ManifestUtilities.callHandlerForManifest(Unknown Source)
                               at com.essbase.eas.framework.defs.ManifestUtilities.callHandlerForFile(Unknown Source)
                               at com.essbase.eas.framework.defs.ManifestUtilities.callHandler(Unknown Source)
                               at com.essbase.eas.server.AppManServlet.destroy(Unknown Source)
                               at com.essbase.eas.server.AppManServlet.shutdown(Unknown Source)
                               at com.essbase.eas.server.AppManServlet.init(Unknown Source)
                               at javax.servlet.GenericServlet.init(GenericServlet.java:211)
                               at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
                               at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
                               at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3917)
                               at org.apache.catalina.core.StandardContext.start(StandardContext.java:4201)
                               at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
                               at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
                               at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
                               at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:904)
                               at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:867)
                               at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474)
                               at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
                               at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
                               at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
                               at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
                               at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
                               at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
                               at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
                               at org.apache.catalina.core.StandardService.start(StandardService.java:450)
                               at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
                               at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
                               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                               at java.lang.reflect.Method.invoke(Method.java:585)
                               at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
                               at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
                          Caused by: Exception HBR Configuration has not been initialized. Make sure you have logged in sucessfully and there are no exceptions in the HBR log file.
                          ClassName: java.lang.Exception

                               at com.hyperion.hbr.common.ConfigurationManager.getServerConfigProps(Unknown Source)
                               at com.hyperion.hbr.cache.CacheManager.<clinit>(Unknown Source)
                               ... 35 more
                          [INFO] eas] - Marking servlet AppManServlet as unavailable
                          [ERROR] eas] - Servlet /eas threw load() exception <javax.servlet.UnavailableException:

                          ** when i started the eas server manually it is showing as server started successfully

                          -----------------------------------------------------------------------------------------------

                          the following is from HyS9sharedservices-sysout log
                          ---------------------------------------------------------------------
                          Oct 9, 2009 10:06:24 AM org.apache.coyote.http11.Http11BaseProtocol init
                          INFO: Initializing Coyote HTTP/1.1 on http-28080
                          Oct 9, 2009 10:06:24 AM org.apache.catalina.startup.Catalina load
                          INFO: Initialization processed in 4906 ms
                          Oct 9, 2009 10:06:25 AM org.apache.catalina.core.StandardService start
                          INFO: Starting service Catalina
                          Oct 9, 2009 10:06:25 AM org.apache.catalina.core.StandardEngine start
                          INFO: Starting Servlet Engine: Hyperion Embedded Java Container/1.0.0
                          Oct 9, 2009 10:06:25 AM org.apache.catalina.core.StandardHost start
                          INFO: XML validation disabled
                          log dir isC:\Hyperion\logs\SharedServices9
                          urlManifest jar:file:/C:/Hyperion/deployments/Tomcat5/SharedServices9/webapps/interop/WEB-INF/lib/interop-mmc.jar!/META-INF/MANIFEST.MF
                          Shared Services Version: 11.1.1.3.24
                          Shared Services Drop Number: 6
                          Attempting to verify the database configuration
                          Attempting to verify the database configuration
                          com.hyperion.hit.registry.exceptions.RegistryException: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress

                               at com.hyperion.hit.registry.RegistryUtils.createNewConnection(RegistryUtils.java:213)
                               at com.hyperion.hit.registry.RegistryConnection.getInstance(RegistryConnection.java:155)
                               at com.hyperion.hit.registry.Registry.getInstance(Registry.java:309)
                               at com.hyperion.eie.config.util.xml.XMLUtils.getDBConfigProperties(Unknown Source)
                               at com.hyperion.eie.config.util.database.DBProperties.isDBConfigured(Unknown Source)
                               at com.hyperion.eie.common.cms.CMSFacade.isCMSConfigured(Unknown Source)
                               at org.apache.slide.common.Domain.selfInit(Unknown Source)
                               at org.apache.slide.common.Domain.accessNamespace(Unknown Source)
                               at org.apache.slide.webdav.WebdavServlet.init(Unknown Source)
                               at javax.servlet.GenericServlet.init(GenericServlet.java:211)
                               at org.apache.slide.webdav.WebdavServlet.init(Unknown Source)
                               at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
                               at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
                               at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3917)
                               at org.apache.catalina.core.StandardContext.start(StandardContext.java:4201)
                               at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
                               at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
                               at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
                               at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:904)
                               at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:867)
                               at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474)
                               at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
                               at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
                               at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
                               at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
                               at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
                               at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
                               at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
                               at org.apache.catalina.core.StandardService.start(StandardService.java:450)
                               at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
                               at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
                               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                               at java.lang.reflect.Method.invoke(Method.java:585)
                               at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
                               at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
                          Caused by: java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01033: ORACLE initialization or shutdown in progress

                               at hyperion.jdbc.base.BaseExceptions.createException(Unknown Source)
                               at hyperion.jdbc.base.BaseExceptions.getException(Unknown Source)
                               at hyperion.jdbc.oracle.OracleImplConnection.connectAndAuthenticate(Unknown Source)
                               at hyperion.jdbc.oracle.OracleImplConnection.open(Unknown Source)
                               at hyperion.jdbc.base.BaseConnection.connect(Unknown Source)
                               at hyperion.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)
                               at hyperion.jdbc.base.BaseConnection.open(Unknown Source)
                               at hyperion.jdbc.base.BaseDriver.connect(Unknown Source)
                               at java.sql.DriverManager.getConnection(DriverManager.java:525)
                               at java.sql.DriverManager.getConnection(DriverManager.java:171)
                               at com.hyperion.hit.registry.RegistryUtils.createNewConnection(RegistryUtils.java:203)
                               ... 36 more
                          Database configuration test passed.
                          09 Oct 2009 10:08:02 - org.apache.slide.common.Domain - INFO - Auto-Initializing Domain
                          09 Oct 2009 10:08:02 - org.apache.slide.common.Domain - INFO - Configuration found in classpath
                          09 Oct 2009 10:08:02 - org.apache.slide.common.Domain - INFO - Domain configuration : {org.apache.slide.lock=true, org.apache.slide.versioncontrol=true, org.apache.slide.debug=false, org.apache.slide.search=true, org.apache.slide.security=true, org.apache.slide.urlEncoding=UTF-8, org.apache.slide.domain=C:/Hyperion/deployments/Tomcat5/SharedServices9/config/Domain.xml}
                          configURL: file:///C:/Hyperion/deployments/Tomcat5/SharedServices9/config/CSS.xml
                          Done initialize: null
                          09 Oct 2009 10:08:10 - org.apache.slide.common.Domain - ERROR - Unable to migrate hub groups to css
                          connection pool registered:dbcpPool-org.apache.commons.pool.impl.GenericObjectPool@179f36b
                          connection pool registered:dbcpPool-org.apache.commons.pool.impl.GenericObjectPool@113e9fd
                          CMSOfflineServlet Initialized
                          Oct 9, 2009 10:08:25 AM org.apache.coyote.http11.Http11BaseProtocol start
                          INFO: Starting Coyote HTTP/1.1 on http-28080
                          Oct 9, 2009 10:08:25 AM org.apache.jk.common.ChannelSocket init
                          INFO: JK: ajp13 listening on /0.0.0.0:28082
                          Oct 9, 2009 10:08:25 AM org.apache.jk.server.JkMain start
                          INFO: Jk running ID=0 time=0/31 config=null
                          Oct 9, 2009 10:08:25 AM org.apache.catalina.startup.Catalina start
                          INFO: Server startup in 120735 ms
                          Oct 9, 2009 10:40:41 AM org.apache.coyote.http11.Http11BaseProtocol pause
                          INFO: Pausing Coyote HTTP/1.1 on http-28080
                          Oct 9, 2009 10:40:42 AM org.apache.catalina.core.StandardService stop
                          INFO: Stopping service Catalina
                          Warning: All the temp files created by the CMS webapp are being deleted
                          Oct 9, 2009 10:40:43 AM org.apache.coyote.http11.Http11BaseProtocol destroy
                          INFO: Stopping Coyote HTTP/1.1 on http-28080


                          thanks again for your time
                          • 10. Re: Not able to add Essbase server in EAS console
                            686273
                            hi guys i still the below error when i expand the essbase server in EAS console

                            the procedure entry point MiniDumpWriteDump could not be located in the dynamic link library dbghelp.dll

                            Error: 0: java.lang.UnsatisfiedLinkError: C:\Hyperion\products\Essbase\eas\server\bin\jmaxl.dll: The specified procedure could not be found

                            not able to figure it out. thanks for your time
                            • 11. Re: Not able to add Essbase server in EAS console
                              timtow
                              Rajender.Reddy.T wrote:
                              the procedure entry point MiniDumpWriteDump could not be located in the dynamic link library dbghelp.dll

                              Error: 0: java.lang.UnsatisfiedLinkError: C:\Hyperion\products\Essbase\eas\server\bin\jmaxl.dll: The specified procedure could not be found
                              We took a quick look at dbghelp.dll and it looks like the MiniDumpWriteDump function is not in the version of dbghelp.dll delivered with Windows 2000.

                              We have found that often when an OS is 'not supported', it simply means that Oracle hasn't tested with the OS and thus will not give you support. In a few rare other times, such as this, it simply won't work on the unsupported system.

                              Tim Tow
                              Applied OLAP, Inc.