9 Replies Latest reply: Dec 1, 2012 10:58 PM by 974723 RSS

    No Hyperion Workspace Services after installation, Hence page not found err

    974723
      I have installed the following 9.3.1 products in Windows 2003 on a single server:
      1. Oracle 10g
      2. Hyperion Shared Services
      3. Hyperion Essbase + Spreadsheet add-in
      4. Hyperion EAS.
      5. Hyperion Planning.
      6. Hyperion Reporting.
      6a. Hyperion Services.
      6b. Hyperion UIServices.
      6c. Hyperion Reporting Client

      After installing and configuration of all these products, I am unable to see service for Hyperion Workspace.

      So, When I use the below links, it gives page not found:
      http://server:19000/workspace
      http://server:45000/workspace

      Dhana...

      Edited by: 971720 on Nov 16, 2012 8:30 PM

      Edited by: 971720 on Nov 17, 2012 8:20 PM
        • 1. Re: No Hyperion Workspace Services after installation, Hence page not found err
          dwhpc
          Hi Dhana,

          Can you please check whether the Worskspace - Agent services is started or not....

          Please list below the services - Started list.

          Thanks
          • 2. Re: No Hyperion Workspace Services after installation, Hence page not found err
            974723
            Hi,

            By agent service did you mean the apache service. I could not find it.

            Do we need to install the Apache Tomcat or does it come with the Hyperion product?

            Dhana...
            • 3. Re: No Hyperion Workspace Services after installation, Hence page not found err
              dwhpc
              Hi Dhana,

              Can you please go the services.msc and let me know the Hyperion services started - List.

              Thanks
              • 4. Re: No Hyperion Workspace Services after installation, Hence page not found err
                974723
                List of Hyperion Services started are:
                Hyperion Essbase Service
                Hyperion S9 Administration Services WLS9
                Hyperion S9 BI+ 9.3 Core Services 1
                Hyperion S9 BI+ 9.3 Financial Reporting Java RMI Registry
                Hyperion S9 BI+ 9.3 Financial Reporting Print Server
                Hyperion S9 BI+ 9.3 Financial Reporting Report Server
                Hyperion S9 BI+ 9.3 Financial Reporting Scheduler Server
                Hyperion S9 BI+ 9.3 Interactive Reporting Service 1
                Hyperion S9 OpenLDAP
                Hyperion S9 Planning
                Hyperion S9 Shared Services
                HyperionRMIRegistry
                • 5. Re: No Hyperion Workspace Services after installation, Hence page not found err
                  JohnGoodwin
                  For workspace you should have the following services

                  Hyperion S9 BI+ 9.3 Workspace
                  Hyperion S9 BI+ 9.3 Core Services 1

                  Which app server are you using Tomcat? if you look in <HYPERION_HOME>\deployments\Tomcat5\bin
                  Do you have HyS9Workspace.exe, do you have installServiceWorkspace.bat, if so can you try running it

                  Cheers

                  John
                  http://john-goodwin.blogspot.com/
                  • 6. Re: No Hyperion Workspace Services after installation, Hence page not found err
                    974723
                    I Installed Apache Tomcat 2.0.52(G:\Apache\). Also have weblogic 9 installed(G:\bea\).

                    When configuring Reporting and Analysis, I choosed Application Server as weblogic 9 and web server as APACHE HTTP SERVER.

                    In <HYPERION_HOME>\deployments\, there is no Tomcat folder, but could see Weblogic9 folder. In weblogic9\bin could not see HyS9Workspace.exe but there are others like HyS9Planning.exe, HyS9SharedServices.exe e.t.c.
                    • 7. Re: No Hyperion Workspace Services after installation, Hence page not found err
                      JohnGoodwin
                      When you deploy Workspace then it should create in the weblogic bin folder

                      HyS9Workspace.exe
                      installServiceWorkspace.bat

                      You could delete <HYPERION_HOME>\logs\config\configtool.log and configtool_err.log
                      Run the configuration utility again and deploy the Reporting and Analysis application server again, make sure workspace is in the list when you deploy and "deploy as service" is enabled.
                      If it still has not created the files/service check the configtool logs.

                      Cheers

                      John
                      http://john-goodwin.blogspot.com/
                      • 8. Re: No Hyperion Workspace Services after installation, Hence page not found err
                        974723
                        As suggested, I deleted the config logs and started configuting. At the end of the configuration, the cofig tool said that configuration was successful.

                        But I could not find the workspace services. So, I looked into the logs and found the following error'ed out in the configuraion.

                        *(Nov 27, 2012, 05:01:25 PM), com.hyperion.cis.DBConfigurator, ERROR, CREATE VIEW V8_EVENT_VW (EVENT_ID,EVENT_NAME,SESSION_ID,USER_ID,START_TIME,END_TIME,DURATION,SERVER,PORT) AS SELECT A.EVENT_UUID,B.NAME,A.SESSION_UUID,A.SUBJECT_UUID,A.STARTTIME,A.FINISHTIME,A.FINISHTIME-A.STARTTIME,(SELECT C.VALUE FROM V8_DOMAIN_PROPS C WHERE C.NAME = 'GSM HOST'),(SELECT D.VALUE FROM V8_DOMAIN_PROPS D WHERE D.NAME = 'GSM PORT') FROM V8_USAGE_EVENT A, V8_USAGE_EVENT_TYPE B WHERE A.TYPE_UUID=B.TYPE_UUID*
                        *java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01031: insufficient privileges*


                        *(Nov 27, 2012, 05:01:25 PM), com.hyperion.cis.DBConfigurator, ERROR, CREATE VIEW V8_OBJECT_VW (EVENT_ID,OBJECT_TYPE,OBJECT_NAME,OBJECT_PATH,OBJECT_VERSION) AS SELECT A.EVENT_UUID,B.DESCRIPTION,C.NAME,D.VALUE,A.OBJECT_VERSION FROM V8_USAGE_EVENT A,V8_METATYPE B,V8_CONTAINER C,V8_USAGE_ATTRIBUTES D,V8_USAGE_EVENT_KEYVAL E WHERE A.EVENT_UUID=E.EVENT_UUID AND E.NAME = 'usageobjectpath' AND D.SEQUENCE_NUMBER =1 AND E.ATTRIBUTE_UUID=D.ATTRIBUTE_UUID AND A.OBJECT_UUID = C.CONTAINER_UUID AND C.META_TYPE_UUID = B.META_TYPE_UUID*
                        *java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01031: insufficient privileges*


                        *(Nov 27, 2012, 05:01:25 PM), com.hyperion.cis.DBConfigurator, ERROR, CREATE VIEW V8_QUERY_VW (EVENT_ID, QUERY_NAME,QUERY_STRING,START_TIME,END_TIME,ROWS_RETURNED, DATASOURCE,DATABASE_LOGIN,DB_USER) as select A.EVENT_UUID,B.QUERY_NAME,C.VALUE,B.STARTTIME,B.FINISHTIME,B.ROW_COUNT,substr(A.ERRORINFO,2,95),substr(A.ERRORINFO,1,1), case when length(A.ERRORINFO) < 97 then '' else substr(A.ERRORINFO,97, length(A.ERRORINFO)-96) end FROM V8_USAGE_EVENT A,V8_USAGE_TIMED_QUERY B,V8_USAGE_ATTRIBUTES C WHERE A.EVENT_UUID =B.EVENT_UUID AND B.ATTRIBUTE_UUID=C.ATTRIBUTE_UUID*
                        *java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01031: insufficient privileges*

                        *(Nov 27, 2012, 05:01:25 PM), com.hyperion.cis.DBConfigurator, ERROR, CREATE VIEW V8_USER_VW (USER_ID,USER_NAME,PROVIDER_NAME,NT_DOMAIN) AS SELECT DISTINCT(A.SUBJECT_UUID),A.LOGIN_ID, A.PROVIDER_NAME, A.NT_DOMAIN FROM V8_USAGE_EVENT A*
                        *java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-01031: insufficient privileges*


                        I could figure out that this error is due to insufficient privileges.

                        I have provided the following access. Isn't this access ok?
                        CREATE TABLESPACE TBS_BI
                        DATAFILE 'G:\oracle\product\10.2.0\oradata\ORACLEHY\TBS_BI.dbf'
                        SIZE 100M
                        AUTOEXTEND ON
                        BLOCKSIZE 8K
                        LOGGING
                        EXTENT MANAGEMENT LOCAL AUTOALLOCATE
                        SEGMENT SPACE MANAGEMENT AUTO;

                        CREATE USER HYP_BI IDENTIFIED BY password DEFAULT TABLESPACE TBS_BI;
                        GRANT CONNECT, RESOURCE TO HYP_BI;

                        Also I could not find HyS9Workspace.exe in the deployments folder.
                        • 9. Re: No Hyperion Workspace Services after installation, Hence page not found err
                          974723
                          Any more suggestions or workarounds ?

                          Dhana...

                          Edited by: 971720 on Dec 1, 2012 8:58 PM