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 laterInformation 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!
*************************************
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.
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))
/
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 |