donderdag 14 maart 2013

PKI-02002: Unable to open the wallet. Check password

A few days ago, a customer called and said that he could not login in EAS anymore. But when he was using HPL (Planning) or Smartview he could connect to the essbase.

I did some basic checks, and found the problem:
  • Disk where EPM was installed was 100% full (743kb free space).
  • EPM was not starting up anymore, after a restart
  • Log was showing:

oracle.security.jps.internal.credstore.ssp.CsfWalletManager openWallet
 WARNING: Opening of wallet based credential store failed. Reason java.io.IOException: PKI-02002: Unable to open the wallet. Check password. oracle.security.jps.service.credstore.CredStoreException: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException: PKI-02002: Unable to open the wallet. Check password. at oracle.security.jps.internal.credstore.ssp.CsfWalletManager.openWallet(CsfWalletManager.java:177) at oracle.security.jps.internal.credstore.ssp.SspCredentialStore.doInit(SspCredentialStore.java:218) at oracle.security.jps.internal.credstore.ssp.SspCredentialStore.<init>(SspCredentialStore.java:140) at oracle.security.jps.internal.credstore.ssp.SspCredentialStore.<init>(SspCredentialStore.java:127) at oracle.security.jps.internal.credstore.ssp.SspCredentialStoreProvider.getInstance(SspCredentialStoreProvider.java:114)
 
Solution
Because the disk was complete full the file ‘cwallet.sso’ was corrupte.
Oracle states that you could place a backup or generate a new file. This could be done:

ORACLE_MW_HOME/oracle_common/bin/orapki wallet create -wallet ORACLE_MW_HOME/user_projects/domains/EPMSystem/config/fmwconfig -auto_login_only

This solution did not work for me. EPM still does not start up and EAS was unable to login essbase.
The real solution was simple:

  • Rename ‘ORACLE_MW_HOME/user_projects/domains/EPMSystem/config/fmwconfig/cwallet.sso’ to ‘ORACLE_MW_HOME/user_projects/domains/EPMSystem/config/fmwconfig/cwallet.sso_corrupt’.
  • Copy ORACLE_MW_HOME/user_projects/domains/EPMSystem/config/fmwconfig/bootstrap/cwallet.sso’ to the directory ‘ORACLE_MW_HOME/user_projects/domains/EPMSystem/config/fmwconfig/
  • Restart EPM and your done.