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 .