This discussion is archived
9 Replies Latest reply: Dec 1, 2012 8:58 PM by 974723 RSS

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

974723 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Any more suggestions or workarounds ?

    Dhana...

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points