MetaSolv GUI Login Error: "Cannot Establish connection to database. | Please contact your system Administrator"

(Doc ID 1345386.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Communications MetaSolv Solution - Version 6.3.0 and later
Information in this document applies to any platform.
****Checked for currency on 07-Jun-2016***

Symptoms

Users unable to login to the MetaSolv  GUI with below stated error message displayed in the Pop Up window:

java.lang.Exception: Cannot Establish connection to database. | Please contact your system Administrator.

Note: This Article only applies if below stated error gets logged to the SERVER_NAME.mss.log in addition to the symptom stated above:

 

java.sql.SQLSyntaxErrorException: ORA-01979: missing or invalid password for role ''
ORA-06512: at "ASAP.SP_CREDSTORE_SETROLE", line 21
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
-------------------------------------------------------------
-------------------------------------------------------------
at com.metasolv.jdbc.MSVConnection.TBSConnection(MSVConnection.java:68)
at com.metasolv.jdbc.MSVConnection.<init>(MSVConnection.java:49)
at com.metasolv.jdbc.MSVConnectionFactory.getConnection(MSVConnectionFactory.java:252)
at com.metasolv.jdbc.MSVConnectionFactory.getConnection(MSVConnectionFactory.java:244)
at com.metasolv.system.SystemManager.beginSession(SystemManager.java:336)
at com.metasolv.system.SystemManager.beginHeadless(SystemManager.java:520)
at com.metasolv.system.SystemManager.startup(SystemManager.java:248)
at com.metasolv.system.SystemManager.startup(SystemManager.java:265)
at com.metasolv.system.TBSCORBAAPIServer.startSystemManager(TBSCORBAAPIServer.java:273)
at com.metasolv.system.TBSCORBAAPIServer.init(TBSCORBAAPIServer.java:112)
at com.metasolv.system.GenericStartup.init(GenericStartup.java:55)
at com.mslv.webapp.context.listener.MSLVContextListener.contextInitialized(MSLVContextListener.java:39)
.............................................................
.............................................................
*************************************
GenericStartup.init() failed.
PLEASE CONSULT appserverlog.xml file in the $METASOLV_HOME/SERVER_NAME/appserver/logs directory for detailed message!
*************************************

 

Note: This article also applies if ORA-01979: missing or invalid password for role '' ORA-06512: at "ASAP.SP_CREDSTORE_SETROLE" is received when accessing tbs_util , jmanager & jmaster.
See the screen shot below.

Changes

CREDENTIAL_STORE table is introduced in MSS 6.2 for security purpose.  8637316.sql creates & inserts initial data in to this table.
As per MetaSolv Documentation MSS_6_2_DB_CHANGE.pdf

8637316.sql
Create Table CREDENTIAL_STORE (CRED_NAME
Varchar2(100 BYTE) NOT NULL ENABLE,
CRED_WORD RAW(32), CONSTRAINT
CREDENTIAL_STORE_PK PRIMARY KEY
(CRED_NAME))
/

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms