My Oracle Support Banner

MetaSolv GUI Login Error: "Cannot Establish connection to database. | Please contact your system Administrator" (Doc ID 1345386.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Communications MetaSolv Solution - Version 6.3.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
 SOL 1
 SOL 2


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.