1 2 Previous Next 16 Replies Latest reply on Jul 10, 2013 2:02 AM by 965365

    Error 404--Not Found - After Installing Essbase 11.1.2.2

    880485
      Hi,

      I have experienced error.

      I have one box of EPM 11.1.2.2, using Windows 2008. After installing Foundation and configuring it, there's no problem at all. I can open workspace and interop as well.
      However I added Essbase, installing and configuring it. But after installing Essbase, I managed to turn on Hyperion Shared Service again, it didn't work.

      The error says:

      Error 404--Not Found
      From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
      10.4.5 404 Not Found
      The server has not found anything matching the Request-URI. No indication is given of whether the condition is temporary or permanent.

      If the server does not wish to make this information available to the client, the status code 403 (Forbidden) can be used instead. The 410 (Gone) status code SHOULD be used if the server knows, through some internally configurable mechanism, that an old resource is permanently unavailable and has no forwarding address.


      What I have done is reconfiguring Shared Service, Essbase also. But no luck at all.
      Does anybody have the clue, please advise. Thanks.
        • 1. Re: Error 404--Not Found - After Installing Essbase 11.1.2.2
          JohnGoodwin
          Have you checked the logs to make sure the web application have started up without issues, have you deployed to one managed server, which urls have you tested.

          Cheers

          John
          http://john-goodwin.blogspot.com/
          • 2. Re: Error 404--Not Found - After Installing Essbase 11.1.2.2
            880485
            Hi John,

            thanks for your response. May I know the exact log? I have seen so many logs here and I'm confused which one can tell me the exact error.
            Thanks.
            • 3. Re: Error 404--Not Found - After Installing Essbase 11.1.2.2
              JohnGoodwin
              check the service log in <MIDDLEWARE_HOME>\user_projects\<instancename>\diagnostics\logs\services

              Cheers

              John
              http://john-goodwin.blogspot.com/
              1 person found this helpful
              • 4. Re: Error 404--Not Found - After Installing Essbase 11.1.2.2
                880485
                Hi John,

                I got error like this on the log:

                <Jun 15, 2012 1:06:18 AM ICT> <Info> <Security> <BEA-090905> <Disabling CryptoJ JCE Provider self-integrity check for better startup performance. To enable this check, specify -Dweblogic.security.allowCryptoJDefaultJCEVerification=true>
                <Jun 15, 2012 1:06:18 AM ICT> <Info> <Security> <BEA-090906> <Changing the default Random Number Generator in RSA CryptoJ from ECDRBG to FIPS186PRNG. To disable this change, specify -Dweblogic.security.allowCryptoJDefaultPRNG=true>
                <Jun 15, 2012 1:06:18 AM ICT> <Notice> <WebLogicServer> <BEA-000395> <Following extensions directory contents added to the end of the classpath:
                C:\Oracle\Middleware\user_projects\domains\EPMSystem\lib\audit-client.jar;C:\Oracle\Middleware\user_projects\domains\EPMSystem\lib\css.jar;C:\Oracle\Middleware\user_projects\domains\EPMSystem\lib\ctg_custom.jar;C:\Oracle\Middleware\user_projects\domains\EPMSystem\lib\ldapbp.jar;C:\Oracle\Middleware\user_projects\domains\EPMSystem\lib\opencsv-1.8.jar;C:\Oracle\Middleware\user_projects\domains\EPMSystem\lib\registry-api.jar;C:\Oracle\Middleware\user_projects\domains\EPMSystem\lib\wlpool.jar>
                <Jun 15, 2012 1:06:19 AM ICT> <Info> <WebLogicServer> <BEA-000377> <Starting WebLogic Server with Oracle JRockit(R) Version R28.2.0-79-146777-1.6.0_29-20111005-1808-windows-x86_64 from Oracle Corporation>
                <Jun 15, 2012 1:06:20 AM ICT> <Info> <Management> <BEA-141107> <Version: WebLogic Server 10.3.6.0 Tue Nov 15 08:52:36 PST 2011 1441050 >
                <Jun 15, 2012 1:06:22 AM ICT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STARTING>
                <Jun 15, 2012 1:06:22 AM ICT> <Info> <WorkManager> <BEA-002900> <Initializing self-tuning thread pool>
                <Jun 15, 2012 1:06:22 AM ICT> <Notice> <Log Management> <BEA-170019> <The server log file C:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\EPMServer0\logs\EPMServer0.log is opened. All server side log events will be written to this file.>
                <Jun 15, 2012 1:06:58 AM ICT> <Notice> <Security> <BEA-090082> <Security initializing using security realm myrealm.>
                <Jun 15, 2012 1:06:58 AM ICT> <Notice> <Security> <BEA-090083> <Storing boot identity in the file: C:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\EPMServer0\security\boot.properties>
                <Jun 15, 2012 1:07:12 AM ICT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STANDBY>
                <Jun 15, 2012 1:07:12 AM ICT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STARTING>
                <Jun 15, 2012 1:07:15 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:07:43 AM ICT> <Warning> <Munger> <BEA-2156203> <A version attribute was not found in element application in the deployment descriptor in C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\aps\AppServer\InstallableApps\Common\aps.ear/META-INF/application.xml. A version attribute is required, but this version of the Weblogic Server will assume that the JEE5 is used. Future versions of the Weblogic Server will reject descriptors that do not specify the JEE version.>
                <Jun 15, 2012 1:07:43 AM ICT> <Warning> <Munger> <BEA-2156203> <A version attribute was not found in element application in the deployment descriptor in C:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\EPMServer0\tmp\servers\EPMServer0\tmp\_WL_user\APS_11.1.2.0\mizf54/META-INF/application.xml. A version attribute is required, but this version of the Weblogic Server will assume that the JEE5 is used. Future versions of the Weblogic Server will reject descriptors that do not specify the JEE version.>
                <Jun 15, 2012 1:07:45 AM ICT> <Warning> <Munger> <BEA-2156203> <A version attribute was not found in element web-app in the deployment descriptor in C:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\EPMServer0\tmp\servers\EPMServer0\tmp\_WL_user\SHAREDSERVICES_11.1.2.0\dt7o9d\interop.war/WEB-INF/web.xml. A version attribute is required, but this version of the Weblogic Server will assume that the JEE5 is used. Future versions of the Weblogic Server will reject descriptors that do not specify the JEE version.>
                <Jun 15, 2012 1:08:10 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:11 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                COMP ID = oracle.EPMOHPS
                Hyperion Provider Services - Release 11.1.2.2.100.2167
                Copyright (c) 1991, 2012 Oracle and / or its affiliates. All rights reserved.
                connection mode : HTTP
                essbase.properties: C:\Oracle\Middleware\EPMSystem11R1/common/EssbaseJavaAPI/11.1.2.0/bin/essbase.properties
                java System properties -DESS_ES_HOME: C:\Oracle\Middleware\EPMSystem11R1/common/EssbaseJavaAPI/11.1.2.0
                <Jun 15, 2012 1:08:12 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:13 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:13 AM ICT> <Error> <HTTP> <BEA-101216> <Servlet: "JAPI" failed to preload on startup in Web application: "/aps".
                javax.servlet.ServletException: Cannot initialize Provider Services server framework.
                     at com.essbase.server.plugins.http.EssbaseEnterprise.init(Unknown Source)
                     at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:283)
                     at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                     at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                     at weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:64)
                     Truncated. see log file for complete stacktrace
                >
                <Jun 15, 2012 1:08:13 AM ICT> <Error> <Deployer> <BEA-149231> <Unable to set the activation state to true for the application 'APS [Version=11.1.2.0]'.
                weblogic.application.ModuleException: [HTTP:101216]Servlet: "JAPI" failed to preload on startup in Web application: "/aps".
                javax.servlet.ServletException: Cannot initialize Provider Services server framework.
                     at com.essbase.server.plugins.http.EssbaseEnterprise.init(Unknown Source)
                     at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:283)
                     at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                     at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                     at weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:64)
                     at weblogic.servlet.internal.StubLifecycleHelper.createOneInstance(StubLifecycleHelper.java:58)
                     at weblogic.servlet.internal.StubLifecycleHelper.<init>(StubLifecycleHelper.java:48)
                     at weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.java:539)
                     at weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppServletContext.java:1981)
                     at weblogic.servlet.internal.WebAppServletContext.loadServletsOnStartup(WebAppServletContext.java:1955)
                     at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1874)
                     at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3155)
                     at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1518)
                     at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:487)
                     at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:427)
                     at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
                     at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
                     at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:201)
                     at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:249)
                     at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:427)
                     at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
                     at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
                     at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:28)
                     at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:672)
                     at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
                     at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)
                     at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:59)
                     at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)
                     at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
                     at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:184)
                     at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:361)
                     at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:52)
                     at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:200)
                     at weblogic.management.deploy.internal.AppTransition$2.transitionApp(AppTransition.java:31)
                     at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:240)
                     at weblogic.management.deploy.internal.ConfiguredDeployments.activate(ConfiguredDeployments.java:170)
                     at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:124)
                     at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:181)
                     at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:97)
                     at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
                     at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
                     at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

                     at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1520)
                     at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:484)
                     at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
                     at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
                     at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
                     Truncated. see log file for complete stacktrace
                Caused By: javax.servlet.ServletException: Cannot initialize Provider Services server framework.
                     at com.essbase.server.plugins.http.EssbaseEnterprise.init(Unknown Source)
                     at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:283)
                     at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                     at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                     at weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:64)
                     Truncated. see log file for complete stacktrace
                >
                <Jun 15, 2012 1:08:13 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:13 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:13 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>


                Essbase® Administration Services - Version 11.1.2.2.100.2176
                Copyright © 1991, 2012 Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. No portion hereof may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or information storage and retrieval systems, for any purpose other than the recipient's personal use, without the express written permission of Oracle.
                US Patent Number 5,359,724
                US Patent Number 6,317,750
                Current time stamp: Fri Jun 15 01:08:14 ICT 2012


                Server started successfully
                Waiting for client requests

                <Jun 15, 2012 1:08:14 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:14 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:14 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:14 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:14 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:15 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:15 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:16 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:18 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:18 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:18 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:18 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:18 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:18 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:18 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:18 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:18 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:18 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:18 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:19 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:19 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:19 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                **********Getting connection from hub connection pool..Testing JNDI connection....
                <Jun 15, 2012 1:08:19 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:19 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:19 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:19 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:19 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:19 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:19 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:19 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:19 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:19 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:19 AM ICT> <Error> <HTTP> <BEA-101216> <Servlet: "WorkflowEngine" failed to preload on startup in Web application: "interop".
                javax.servlet.ServletException: DSF initalization error null
                     at com.hyperion.cesdsf.server.framework.DsfServer.init(DsfServer.java:64)
                     at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:283)
                     at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                     at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                     at weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:64)
                     Truncated. see log file for complete stacktrace
                >
                <Jun 15, 2012 1:08:19 AM ICT> <Error> <Deployer> <BEA-149231> <Unable to set the activation state to true for the application 'SHAREDSERVICES [Version=11.1.2.0]'.
                weblogic.application.ModuleException: [HTTP:101216]Servlet: "WorkflowEngine" failed to preload on startup in Web application: "interop".
                javax.servlet.ServletException: DSF initalization error null
                     at com.hyperion.cesdsf.server.framework.DsfServer.init(DsfServer.java:64)
                     at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:283)
                     at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                     at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                     at weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:64)
                     at weblogic.servlet.internal.StubLifecycleHelper.createOneInstance(StubLifecycleHelper.java:58)
                     at weblogic.servlet.internal.StubLifecycleHelper.<init>(StubLifecycleHelper.java:48)
                     at weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.java:539)
                     at weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppServletContext.java:1981)
                     at weblogic.servlet.internal.WebAppServletContext.loadServletsOnStartup(WebAppServletContext.java:1955)
                     at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1874)
                     at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3155)
                     at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1518)
                     at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:487)
                     at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:427)
                     at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
                     at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
                     at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:201)
                     at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:249)
                     at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:427)
                     at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
                     at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
                     at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:28)
                     at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:672)
                     at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
                     at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)
                     at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:59)
                     at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)
                     at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
                     at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:184)
                     at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:361)
                     at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:52)
                     at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:200)
                     at weblogic.management.deploy.internal.AppTransition$2.transitionApp(AppTransition.java:31)
                     at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:261)
                     at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:220)
                     at weblogic.management.deploy.internal.ConfiguredDeployments.activate(ConfiguredDeployments.java:170)
                     at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:124)
                     at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:181)
                     at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:97)
                     at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
                     at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
                     at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

                     at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1520)
                     at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:484)
                     at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
                     at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
                     at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
                     Truncated. see log file for complete stacktrace
                Caused By: javax.servlet.ServletException: DSF initalization error null
                     at com.hyperion.cesdsf.server.framework.DsfServer.init(DsfServer.java:64)
                     at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:283)
                     at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                     at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                     at weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:64)
                     Truncated. see log file for complete stacktrace
                >
                <Jun 15, 2012 1:08:20 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:20 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:20 AM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                ".>
                <Jun 15, 2012 1:08:20 AM ICT> <Error> <HTTP> <BEA-101216> <Servlet: "prefs" failed to preload on startup in Web application: "workspace".
                EPMCSS-00001: Failed to initialize EPM Shared Services security instance. Component SYSTEM9/FOUNDATION_SERVICES_PRODUCT/SHARED_SERVICES_PRODUCT is null in EPM System Registry. Verify EPM System Registry configuration.
                     at com.hyperion.css.registry.RegistryManager.initRegistry(RegistryManager.java:111)
                     at com.hyperion.css.registry.RegistryManager.<init>(RegistryManager.java:95)
                     at com.hyperion.css.registry.RegistryManager.getInstance(RegistryManager.java:134)
                     at com.hyperion.css.CSSSystemFactory.getCSSMode(CSSSystemFactory.java:103)
                     at com.hyperion.css.CSSSystemFactory.getCSSSystem(CSSSystemFactory.java:71)
                     Truncated. see log file for complete stacktrace
                >
                <Jun 15, 2012 1:08:20 AM ICT> <Error> <Deployer> <BEA-149231> <Unable to set the activation state to true for the application 'WORKSPACE [Version=11.1.2.0]'.
                weblogic.application.ModuleException: [HTTP:101216]Servlet: "prefs" failed to preload on startup in Web application: "workspace".
                EPMCSS-00001: Failed to initialize EPM Shared Services security instance. Component SYSTEM9/FOUNDATION_SERVICES_PRODUCT/SHARED_SERVICES_PRODUCT is null in EPM System Registry. Verify EPM System Registry configuration.
                     at com.hyperion.css.registry.RegistryManager.initRegistry(RegistryManager.java:111)
                     at com.hyperion.css.registry.RegistryManager.<init>(RegistryManager.java:95)
                     at com.hyperion.css.registry.RegistryManager.getInstance(RegistryManager.java:134)
                     at com.hyperion.css.CSSSystemFactory.getCSSMode(CSSSystemFactory.java:103)
                     at com.hyperion.css.CSSSystemFactory.getCSSSystem(CSSSystemFactory.java:71)
                     at com.hyperion.css.CSSSystem.initCSSSystem(CSSSystem.java:318)
                     at com.hyperion.css.CSSSystem.getInstance(CSSSystem.java:272)
                     at com.oracle.workspace.Repository$PrefsStore.initialize(Repository.java:2917)
                     at com.hyperion.bpm.prefs.PrefsServlet.init
                • 5. Re: Error 404--Not Found - After Installing Essbase 11.1.2.2
                  JohnGoodwin
                  If it did originally work then it looks like you might have wiped out the shared services registry with a later configuration, can you confirm whether the tables still exist and are populated e.g. HSS_COMPONENT_TYPES
                  Another possibility is the data source has got messed up in WebLogic which would need manually updating.

                  Cheers

                  John
                  http://john-goodwin.blogspot.com/
                  • 6. Re: Error 404--Not Found - After Installing Essbase 11.1.2.2
                    880485
                    Hi John,

                    I didn't edit anything after installing Shared Service (Foundation). Just trying to up the services and that works well.
                    However after that I installed Essbase - after trying to login Interop etc, after installing Essbase seems like the services can't start.

                    I may have missed something, because I didn't touch anything on database except creating Oracle schema for configuration repository.
                    The table that mentioned (HSS_COMPONENT_TYPES) is exist with 154 rows. I don't see anything that strange on that table.
                    • 7. Re: Error 404--Not Found - After Installing Essbase 11.1.2.2
                      user10330106
                      Hi,

                      1)Check in services.msc that alll hyperion serivices are up.

                      2)Check in EM console and check all the services are up.

                      Because in services.msc it will show all services are up but in EM Console it will show only the services are started in green others are in red.

                      We faced the same issue.

                      Then we restarted the server and stopped all the services.Then through EPMConfiguratior we configure only "Configure Web Server".then we started services .it went fine.
                      • 8. Re: Error 404--Not Found - After Installing Essbase 11.1.2.2
                        880485
                        Hi user10330106

                        I've followed your solution but it still doesn't work :(
                        • 9. Re: Error 404--Not Found - After Installing Essbase 11.1.2.2
                          JohnGoodwin
                          If you start up the Weblogic admin server and log into the console e.g. http://machinename:7001/console

                          Go to services > Data Sources >EPMSystemRegistry

                          Under the Connection Pool tab is the user correct in the properties box.

                          Cheers

                          John
                          http://john-goodwin.blogspot.com/
                          • 10. Re: Error 404--Not Found - After Installing Essbase 11.1.2.2
                            880485
                            have updated the username and password on weblogic console. Still got errors :(
                            • 11. Re: Error 404--Not Found - After Installing Essbase 11.1.2.2
                              JohnGoodwin
                              Hold on, so the user name was incorrect?

                              If so then are the errors different in the log.

                              Cheers

                              John
                              http://john-goodwin.blogspot.com/
                              • 12. Re: Error 404--Not Found - After Installing Essbase 11.1.2.2
                                880485
                                Hi John,

                                the username and password are correct, but as you suggested to check on EPMSystemRegistry setting on Weblogic console, I've updated it once again. To ensure that the username and password are correct.

                                Edited by: fabregas on Jun 14, 2012 10:19 AM
                                • 13. Re: Error 404--Not Found - After Installing Essbase 11.1.2.2
                                  880485
                                  Hi John,

                                  on yesterday's log, another finding:
                                  <Jun 15, 2012 5:54:07 PM ICT> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                                  ".>

                                  I'm still wondering why after installing Foundation there's no problem at all but after adding Essbase this error occurs.
                                  • 14. Re: Error 404--Not Found - After Installing Essbase 11.1.2.2
                                    JohnGoodwin
                                    Sometimes that error can be because the datasource details are incorrect which I pointed you to yesterday in WebLogic.
                                    I am not sure how you have managed to cause the issues to foundation after adding essbase as I don't the process you carried out.

                                    If I go into WebLogic and change the user for the EPMSystemRegistry datasource and then start up the EPM Server service the same errors are generated.

                                    <15-Jun-2012 08:32:58 o'clock BST> <Error> <JDBC> <BEA-001112> <Test "select count(*) from HSS_COMPONENT_TYPES" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                                    ".>

                                    Cheers

                                    John
                                    http://john-goodwin.blogspot.com/
                                    1 2 Previous Next