Resetting Hyperion Workspace Admin Password if you forgot

One day I found this post very interesting to me in my search. Hope it will use full to all :)

This Post describes how to reset admin password for Hyperion SS. We had a Hyperion 11.1.2.3 setup, we forgot our admin password. simply we followed the below points.

1) Stop all the hyperion services.
2) Connect to the SS schema in database and run below script to change the password to 'password' which is default.
3) update CSS_USERS
set PASSWORD='{SHA}W6ph5Mm5Pz8GgiULbPgzG37mj9g='
where name='admin';

4) commit.

5) start all the services and make sure that you are able to connect all the consoles with new password.

Run the below script to change the password to 'welcome1' :

Here CSS_USERS represents a table which holds information about SS schema security.

update CSS_USERS
set PASSWORD='{SSH2}FvSZVSvSmzvjT/02Nn1TrJyQk8SqNus4Fw4m2cNxa3zkSLe8HFiJy7cT8zUDGiWi'
where name='admin';

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