Workspace Accessing issue: Interactive Reporting Error: "Service Temporarily Unavailable Error Occurred Communicating With The Server"

Applies to:

 Hyperion BI+ - Version 11.1.2.1.000 and later
Information in this document applies to any platform.

Symptoms

When attempting to log into Workspace getting the following series of error messages:
"The Startup Document Specified does not exist in the Repository."

Clicking OK, the following error presents:
"A 'Service Temporarily Unavailable' error occurred communicating with the server.
Status 503 - Service Temporarily Unavailable"
Clicking OK, a third error presents:
"A 'Not Found' error occurred communicating with the server.
Status 404 - Not Found"

The "stdout_console_agent.log" log file located in
Oracle\Middleware\user_projects\epmsystem4\diagnostics\logs\ReportingAnalysis directory contains the following error:
"...Caused by: com.sqribe.transformer.DBConnectionException: Database Server error: DBConnectionPool::get: ORA-28001: the password has expired"

Cause

The Repository Database password expired.

Solution

Perform one of these solutions: I followed the first point

A) Ask your Oracle DBA to restore the repository database password and/or make sure passwords are not set to expire. 

B) Reconfigure EPM to use the new repository database password following the process outlined in "epm_install.pdf" chaper 10 "Reconfiguring EPM System Products" section "Changing Repository Passwords and Database Connection Information"

Ref : (Doc ID 1419079.1)

Weblogic Admin Server issues :

1) Problem 1: Today we got the below error while starting the Web logic Admin server.

We have deleted cache (tmp and logs) for the admin and managed servers.After that when we trying start the admin server we have faced following exception in log file.

<Feb 13, 2014 7:56:55 PM IST> <Notice> <Log Management> <BEA-170019> <The server log file /u02/Middleware/user_projects/domains/EPMSystem/servers/AdminServer/logs/AdminServer.log is opened. All server side log events will be written to this file.>
Feb 13, 2014 7:57:00 PM oracle.security.jps.internal.credstore.ssp.CsfWalletManager openWallet
WARNING: Opening of wallet based credential store failed. Reason java.io.IOException
<Feb 13, 2014 7:57:00 PM IST> <Error> <Security> <BEA-090892> <The loading of OPSS java security policy provider failed due to exception, see the exception stack trace or the server log file for root cause. If still see no obvious cause, enable the debug flag -Djava.security.debug=jpspolicy to get more information. Error message: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException>
<Feb 13, 2014 7:57:00 PM IST> <Critical> <WebLogicServer> <BEA-000386> <Server subsystem failed. Reason: weblogic.security.SecurityInitializationException: The loading of OPSS java security policy provider failed due to exception, see the exception stack trace or the server log file for root cause. If still see no obvious cause, enable the debug flag -Djava.security.debug=jpspolicy to get more information. Error message: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException
weblogic.security.SecurityInitializationException: The loading of OPSS java security policy provider failed due to exception, see the exception stack trace or the server log file for root cause. If still see no obvious cause, enable the debug flag -Djava.security.debug=jpspolicy to get more information. Error message: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.loadOPSSPolicy(CommonSecurityServiceManagerDelegateImpl.java:1402)
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1022)
        at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:873)
        at weblogic.security.SecurityService.start(SecurityService.java:141)
        at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
        Truncated. see log file for complete stacktrace
Caused By: oracle.security.jps.JpsRuntimeException: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException
        at oracle.security.jps.internal.policystore.PolicyDelegationController.<init>(PolicyDelegationController.java:170)
        at oracle.security.jps.internal.policystore.JavaPolicyProvider.<init>(JavaPolicyProvider.java:383)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        Truncated. see log file for complete stacktrace
Caused By: oracle.security.jps.JpsException: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException
        at oracle.security.jps.internal.policystore.PolicyUtil.getDefaultPDPService(PolicyUtil.java:2984)
        at oracle.security.jps.internal.policystore.PolicyUtil.getPDPService(PolicyUtil.java:3228)
        at oracle.security.jps.internal.policystore.PolicyDelegationController.<init>(PolicyDelegationController.java:167)
        at oracle.security.jps.internal.policystore.JavaPolicyProvider.<init>(JavaPolicyProvider.java:383)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        Truncated. see log file for complete stacktrace
Caused By: oracle.security.jps.service.credstore.CredStoreException: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException
        at oracle.security.jps.internal.credstore.ssp.CsfWalletManager.openWallet(CsfWalletManager.java:184)
        at oracle.security.jps.internal.credstore.ssp.SspCredentialStore.doInit(SspCredentialStore.java:359)
        at oracle.security.jps.internal.credstore.ssp.SspCredentialStore.<init>(SspCredentialStore.java:176)
        at oracle.security.jps.internal.credstore.ssp.SspCredentialStore.<init>(SspCredentialStore.java:160)
        at oracle.security.jps.internal.credstore.ssp.SspCredentialStoreProvider.getInstance(SspCredentialStoreProvider.java:118)
        Truncated. see log file for complete stacktrace
>
<Feb 13, 2014 7:57:00 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED>
<Feb 13, 2014 7:57:00 PM IST> <Error> <WebLogicServer> <BEA-000383> <A critical service failed. The server will shut itself down>
<Feb 13, 2014 7:57:00 PM IST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN>

wallet based credential store failed. Reason java.io.IOException
tail: admin.log: file truncated
java version "1.6.0_37"
Java(TM) SE Runtime Environment (build 1.6.0_37-b06)
Oracle JRockit(R) (build R28.2.5-50-153520-1.6.0_37-20121220-0843-linux-x86_64, compiled mode)

What we did : 

1)  firstly, we thought problem with credentials (boot.properties and ldap files). Deleted ldap file and  have opened boot.properties file and deleted date line and modified username and password with same values. (before modification they were in encoding).

when we start same problem exists.

2)  secondly, we have searched in Google with a key word wallet based credential store failed. Reason java.io.Io Exception.

and found some solutions.

Help full solution:

Here is the fix:    We navigated to <Middleware_Home>/user_projects/domains/<Your Domain>/config/fmwconfig/ folder and observed that cwallet.sso is corrupted and file size is 0(zero) kb . Here we renamed this file(cwallet.sso_bkp) and successfully started Adminserver .

Hyperion EPM 11.1.2.3 Issues and solutions

1)

Error while creating planning application through work space :

Hi,

I am getting the following error when i am trying to create the classic planning application through work space.

Invalid or could not find module configuration.

Required application module Hyperion Planning. App Wizard is not configured. Please contact your administrator.

Communication Error.
http://localhost:28080/Hyperion Planning/conf/HspJSConfig.xml?LOCALE_LANGUAGE=en

Please suggest me how to resolve this error. Also please share the order in which services to start.

What I did : Because it said no application module configured at that time two things came into my mind

1) Restarting all the services may help us.

2) do some manual planning application configuration and copy to that planning apps location restart all services.

Solution for this :

If you are going through work space and using Apache plugin (HTTP realted), you should access work space on port 19000.
http://<workspace machine>:19000/workspace/index.jsp

Ref : https://forums.oracle.com/thread/841482

2) After adding a machine name to the EAS console. we got an issue when we try to add Essbase server.

It is giving network configuration failed. could not connect to localhost:1423

What I did:  As shown in some blogs i thought restarting of OPMN will give the solution.

Then I did it. It works for me.

3) Work space – Dimension library issue:

Today when we are trying to open Dimension library and Application library through workspace

We came across below issue:

Right Hostname could not be parsed.

Epm.web.dimensionlibrary exception.

Solution: When I am looking into the services  status running or stopped, everything is running except EPMA process manager.

I restarted it and logout ,login workspace.

Now we are able to open dimension library. J

Oracle Hyperion Enterprise Performance Management (EPM) System Component overview

This post is brief overview of Oracle Hyperion Enterprise Performance Management (EPM) System Products which consists of

1) Hyperion Foundation Services

1.1) EPM Shared Services - provides EPM System Products identity management, user provisioning, and task flow management.
1.2) EPM workspace – thin client interface to work with EPM content.
1.3) Performance Management Architect – enables creation and deployment of financial applications from central location.
1.4) Calculate Manager – module used by Planning, Essbase, and Financial Management users can use to design, validate and administer business rules.
1.5) Smart view for Office – microsoft office add-in for Hyperion System Products.

2) Essbase

2.1) Essbase – is business analysis software to develop custom analytics and enterprise performance management applications.
2.2) Essbase Administration Service – administration tool to manage Essbase deployed on application server.
2.3) Business Rules – installed and configured as part of Administration Services, is used to create, execute and manage business rules.
2.4) Integration Services – tool to create OLAP models, outlines and Essbase Database.
2.5 ) Provider Services – is middle tier data source provider for essbase, planning, and so on
2.6) Essbase Studio – consolidates cube-construction activities in one interface.

3) Hyperion Reporting and Analysis

3.1) Hyperion Interactive Reporting – intuitive user-directed query and analysis capabilities.
3.2) Hyperion Financial Reporting – book-quality financial and management reports that comply with regulations and external requirements.
3.3) Hyperion SQR production Reporting – high-volume, formatted reports coming form different sources
3.4) Hyperion Web Analysis – provides online analytical processing (OLAP) analysis.

4) Hyperion Financial Performance Management Application

4.1) Planning – is a centralized planning, budgeting, and forecasting solution that integrates financial and operational planning processes.
4.2) Financial Management – is financial systems software application that provides global collection reporting and analysis in single solution.
4.3) Financial Close Management – to define, execute, and report on interdependent activities of financial close period.
4.4) Performance Scorecard – is a balanced scorecard collaborative certified application to articulate strategy and goals, communicate them across enterprise and monitor KPI.
4.5) Hyperion Strategic Finance – is financial modelling application to identify and understand full financial impact of alternative corporate strategies.
4.6) Profitability and Cost Management – is an analytic application for managing cost and revenue allocation to compute profitability for business segment.
4.7) Disclosure Management – used to assemble a reporting package for submission to a regulatory agency.

5) Data Management

5.1) Hyperion Financial Data Quality Management (FDM) – helps finance users develop standardised financial data management processes.
5.2) ERP Integrator – Module of FDM, to integrate metadata and data from ERP source system to Hyperion EPM target application.
5.3) Hyperion Data Relationship Manager (DRM) - enables to build consistency within master data assets despite changes within the underlying transactional and analytical systems.

Oracle Hyperion Database Administrator

Oracle Hyperion EPM Installation and Administration : Part1


Oracle Hyperion Enterprise Performance Management (EPM) as name suggests is enterprise performance management software that provides planning, budgeting and forecasting solution.

Hyperion was acquired by Oracle in 2007 and consists of following components

• Hyperion Foundation Services
• Hyperion Essbase
• Hyperion Reporting and Analysis
• Oracle Hyperion Data Management
• Hyperion Financial Performance Management Application that consists of

• Hyperion Financial Close Management
• Hyperion Financial Disclosure Management
• Hyperion Financial Management – Fusion Edition
• Hyperion Strategic Management – Fusion Edition
• Hyperion Performance Scorecard – Fusion Edition
• Hyperion Profitability and Cost Management – Fusion Edition

This post covers high level steps to install Oracle Hyperion EPM 11.1.1.2.1

1. Download Oracle Hyperion EPM Software from eDelivery (select product Oracle Enterprise Performance Management System)
2. Install Database for Hyperion (Database character set must be with UTF-8 encoding (AL32UTF8, UTF8, UTFE)
3. Install Java Development Kit (JDK or JRockit) 1.6 or higher
4. Install Hyperion EPM System Components using installTool.sh/bat (This will install WebLogic Server, Oracle HTTP Server, and EPM System)
5. Configure Hyperion EPM System Components using configTool.sh/bat ( This will create Weblogic Domain, configure OHS Server, System Component for EPM i.e. EPM ORACLE_INSTANCE and configure EPM applications)
6. Start Hyperion EPM System Components using EPM_ORACLE_INSTANCE /bin/start.sh
7. Validate/Access Hyperion EPM System Components

ExternalTables_OracleDirectory

Hi Folks,

I have a task to create an oracle directory and assign access privileges to the users. And create an external table; load the data through .CSV file.

So that I have a created a directory in oracle and assigned access privileges to the users as below:

General Related Data Dictionary Objects dir$ all_directories ku$_directory_t dba_directories ku$_directory_view System Privileges GRANT create any directory TO <user_name>; GRANT drop any directory TO <user_name>; GRANT create any directory TO uwclass; GRANT drop any directory TO uwclass; Create Directory Create A Directory CREATE OR REPLACE DIRECTORY <directory_name> AS '<operating_system_path>'; conn / as sysdba desc dba_directories set linesize 121 col owner format a15 col directory_name format a20 col directory_path format a70 SELECT * FROM dba_directories; CREATE OR REPLACE DIRECTORY ctemp AS 'c: emp'; SELECT * FROM dba_directories; Granting Privileges To A Directory Grant Read On A Directory GRANT READ ON DIRECTORY <directory_name> TO <schema_name> col grantor format a20 col grantee format a20 col table_schema format a20 col table_name format a20 col privilege format a10 SELECT grantor, grantee, table_schema, table_name, privilege FROM all_tab_privs WHERE table_name = 'CTEMP'; GRANT READ ON DIRECTORY ctemp TO uwclass; SELECT grantor, grantee, table_schema, table_name, privilege FROM all_tab_privs WHERE table_name = 'CTEMP'; Grant Write On A Directory GRANT WRITE ON DIRECTORY <directory_name> TO <schema_name> GRANT WRITE ON DIRECTORY ctemp TO uwclass; SELECT grantor, grantee, table_schema, table_name, privilege FROM all_tab_privs WHERE table_name = 'CTEMP'; Revoke Read On A Directory REVOKE READ ON DIRECTORY <directory_name> FROM <schema_name> REVOKE READ ON DIRECTORY ctemp FROM uwclass; Revoke Write On A Directory REVOKE WRITE ON DIRECTORY <directory_name> FROM <schema_name> REVOKE WRITE ON DIRECTORY ctemp FROM uwclass; Drop Directory Drop A Directory DROP DIRECTORY <directory_name>; SELECT * FROM dba_directories; DROP DIRECTORY ctemp; SELECT * FROM dba_directories;

Creating an External Table:

Create a directory object pointing to the location of the files.

CREATE OR REPLACE DIRECTORY test2 AS 'D:/test2';

EXAMPLE:

create table forecastforOct2013

(YYYYMM number(20),

YYYYMMDD number(20),

DAY_NUMBER varchar2(25),

ship_day number(20),

channel varchar2(25),

reporting_group varchar2(26),

item_type varchar2(25),

forecast_qty_lbs varchar2(26),

forecast_amt varchar2(25)

)

organization external

(

type oracle_loader

default directory test2

access parameters

(

records delimited by newline

badfile 'forecastforOct2013.bad'

discardfile 'forecastforOct2013.dsc'

logfile 'forecastforOct2013.log'

fields terminated by ','
optionally enclosed by '"'

missing field values are null

)

location ('forecastforOct2013.csv')

)
reject limit unlimited ;

1. 1.      Before executing this script we have created a directory called “test2” under D:/ folder and assigned read, wrote permissions to the oracle user .
2. 2.      Place the file (here: forecastforOct2013) in test2 directory.
3. 3.      Make sure that you have all the access permissions to the test2 directory and forecast... Files.

1. Reference: http://www.oracle-base.com/articles/9i/external-tables-9i.php
2. https://forums.oracle.com/thread/2576750

OC4J Configuration issue - Unable to openDBCONSOLE

[oracle@localhost ~]$ emctl status dbconsole
OC4J Configuration issue. /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_localhost.localhost.com_fmw not found.
[oracle@localhost ~]$ emctl start dbconsole
OC4J Configuration issue. /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_localhost.localhost.com_fmw not found.
This is due to a misconfiguration of dbconsole during database setup. The fastest solution is usually to recreate repository and configuration.
First, deconfigure dbconsole:
[oracle@localhost ~]$ emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Aug 5, 2013 7:54:35 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: fmw
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: Y
Aug 5, 2013 7:54:54 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/fmw/emca_2013_08_05_19_54_34.log.
Aug 5, 2013 7:54:55 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Aug 5, 2013 7:54:55 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Aug 5, 2013 7:57:04 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 5, 2013 7:57:04 PM

Now, let's configure it again
[oracle@localhost ~]$ emca -config dbcontrol db -repos create
STARTED EMCA at Aug 5, 2013 7:58:22 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: fmw
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/dbhome_1 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
Local hostname ................ localhost.localhost.com
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
Listener port number ................ 1521
Database SID ................ fmw
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: Y
Aug 5, 2013 7:58:53 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/fmw/emca_2013_08_05_19_58_21.log.
Aug 5, 2013 7:58:54 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Aug 5, 2013 8:05:56 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Aug 5, 2013 8:06:02 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Aug 5, 2013 8:07:14 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Aug 5, 2013 8:07:17 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Aug 5, 2013 8:07:17 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Aug 5, 2013 8:08:07 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Aug 5, 2013 8:08:07 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Aug 5, 2013 8:08:53 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Aug 5, 2013 8:08:53 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Aug 5, 2013 8:10:16 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Aug 5, 2013 8:10:17 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://localhost.localhost.com:5500/em <<<<<<<<<<<
Aug 5, 2013 8:10:28 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0/dbhome_1/localhost.localhost.com_fmw/sysman/config/emkey.ora.   Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager Configuration completed successfully
FINISHED EMCA at Aug 5, 2013 8:10:28 PM

[oracle@localhost ~]$