# Databse Connection Issue **URL:** \ **Category:** Ignition\ **Created:** [March 31, 2022, 3:36pm UTC](https://forum.inductiveautomation.com/t/databse-connection-issue/57882 "2022-03-31T15:36:41Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![shubham\_savani](https://avatars.discourse-cdn.com/v4/letter/s/b487fb/32.png) [@shubham\_savani](https://forum.inductiveautomation.com/u/shubham_savani)\ **Post date:** [March 31, 2022, 3:36pm UTC](https://forum.inductiveautomation.com/t/databse-connection-issue/57882/1 "2022-03-31T15:36:41Z")
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. Rest of the databases are working fine. Please find attached screenshots. Thanks in advance ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/4/14d4302de88bb4b740562a71362eb017e2021fe9.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/3/f3c0d3451e04c2e799848a523fb6cc2ee6bf76f6.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/2/727f5ea76d435330ded9f641b04aec499fb669bb.png) ---
**Author:** ![andrews](https://avatars.discourse-cdn.com/v4/letter/a/898d66/32.png) [@andrews](https://forum.inductiveautomation.com/u/andrews)\ **Post date:** [March 31, 2022, 3:39pm UTC](https://forum.inductiveautomation.com/t/databse-connection-issue/57882/2 "2022-03-31T15:39:29Z")
What database software are you using and version number? ---
**Author:** ![kvane](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kvane/32/22228_2.png) [@kvane](https://forum.inductiveautomation.com/u/kvane)\ **Post date:** [March 31, 2022, 3:49pm UTC](https://forum.inductiveautomation.com/t/databse-connection-issue/57882/3 "2022-03-31T15:49:09Z")
The Hydroform database in that screenshot has 19/16 Connections. Does the connection count ever decrease below the maximum? Do the tables load then? ---
**Author:** ![shubham\_savani](https://avatars.discourse-cdn.com/v4/letter/s/b487fb/32.png) [@shubham\_savani](https://forum.inductiveautomation.com/u/shubham_savani)\ **Post date:** [March 31, 2022, 3:53pm UTC](https://forum.inductiveautomation.com/t/databse-connection-issue/57882/4 "2022-03-31T15:53:14Z")
When count decrease to 8, I tried to load database but negative. ---
**Author:** ![shubham\_savani](https://avatars.discourse-cdn.com/v4/letter/s/b487fb/32.png) [@shubham\_savani](https://forum.inductiveautomation.com/u/shubham_savani)\ **Post date:** [March 31, 2022, 3:53pm UTC](https://forum.inductiveautomation.com/t/databse-connection-issue/57882/5 "2022-03-31T15:53:46Z")
it is DB2/400 ---
**Author:** ![kvane](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kvane/32/22228_2.png) [@kvane](https://forum.inductiveautomation.com/u/kvane)\ **Post date:** [March 31, 2022, 3:59pm UTC](https://forum.inductiveautomation.com/t/databse-connection-issue/57882/6 "2022-03-31T15:59:01Z")
Are you seeing errors popup after leaving the Database Query Browser open? What does the “Details” tab of that error say. And how many tables do you estimate are in the database? ---
**Author:** ![shubham\_savani](https://avatars.discourse-cdn.com/v4/letter/s/b487fb/32.png) [@shubham\_savani](https://forum.inductiveautomation.com/u/shubham_savani)\ **Post date:** [March 31, 2022, 4:11pm UTC](https://forum.inductiveautomation.com/t/databse-connection-issue/57882/7 "2022-03-31T16:11:29Z")
GatewayException: Read timed out caused by SocketTimeoutException: Read timed out Ignition v8.1.3 (b2021030309) Java: Azul Systems, Inc. 11.0.9 Number of table, not sure how many and that was the sole purpose to figure out how many tables are there and what else is stored. I am able to generate the report which is basically from the same database. Thanks ---
**Author:** ![kvane](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kvane/32/22228_2.png) [@kvane](https://forum.inductiveautomation.com/u/kvane)\ **Post date:** [March 31, 2022, 4:22pm UTC](https://forum.inductiveautomation.com/t/databse-connection-issue/57882/8 "2022-03-31T16:22:07Z")
> caused by SocketTimeoutException: Read timed out 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. ---
**Author:** ![shubham\_savani](https://avatars.discourse-cdn.com/v4/letter/s/b487fb/32.png) [@shubham\_savani](https://forum.inductiveautomation.com/u/shubham_savani)\ **Post date:** [March 31, 2022, 4:35pm UTC](https://forum.inductiveautomation.com/t/databse-connection-issue/57882/9 "2022-03-31T16:35:56Z")
Kvane, I just noticed that I am having the same problem on MES\_CMS database, which is using the same driver. ---
**Author:** ![kvane](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kvane/32/22228_2.png) [@kvane](https://forum.inductiveautomation.com/u/kvane)\ **Post date:** [March 31, 2022, 4:45pm UTC](https://forum.inductiveautomation.com/t/databse-connection-issue/57882/10 "2022-03-31T16:45:26Z")
My most recent response still applies. 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. ---
**Author:** ![shubham\_savani](https://avatars.discourse-cdn.com/v4/letter/s/b487fb/32.png) [@shubham\_savani](https://forum.inductiveautomation.com/u/shubham_savani)\ **Post date:** [April 4, 2022, 3:26pm UTC](https://forum.inductiveautomation.com/t/databse-connection-issue/57882/11 "2022-04-04T15:26:39Z")
Thanks Kvane, Open that database on MS Query, yes it has numbers of table and could not able to load in 60 Seconds. Thanks again for the quick response.