I am having problem to pull up data from the database, at the same time when I run the projects on vision which use the same database, it is pooling up the data from the database but when I go to Datatbase query browser could not see anything for that database even could not able to see anything at DB Browse screen.
Please note that database is saying connected and valid.
Sounds like the Database connection could be timing out because it can't list all of its tables within 60 seconds. You should try to connect to the Database using a non-Ignition GUI/console tool to get an estimate of how many tables it might be trying to list.
There is a setting ("Table List Filter") within the Database Translator in Ignition that allows you to filter the tables listed here, so filtering out things like the system tables could help. You said this issue doesn't happen for other databases, so you could look at the tables for the "MES_CMS" database (which is using the same driver/translator) connection to confirm if it is listing unexpected tables that could be filtered.
The Ignition setting that may impact this is the Table List Filter. If the database has a lot of system tables, or other tables that shouldn’t be listed for the user/schema you are targeting, then you can try to filter them out with that translator setting. That setting is located on the Gateway webpage > Config > Databases > Drivers
Try to load either database in a different GUI tool or client to know more about what tables the database is trying to list.