GoLand
 
2025.1EAP
Shortcuts: Windows
Get GoLand
Because GoLand 2025.1 is still in development, this documentation may not be entirely accurate and is subject to change.
  1. Database Tools and SQL
  2. Troubleshooting
  3. Cannot find a database object in Database tool window

Cannot find a database object in Database tool window

Last modified: 14 November 2024

If you see no objects below the schema level, cannot find changes in objects, experience broken tables or any other visualization problems, try the following steps to resolve the problem.

note

If steps 1, 2, 3, and 4 did not resolve your problem, inform JetBrains of your situation by creating a YouTrack ticket. After you have created the ticket, try step 5 as a workaround.

Step 1. Refresh the database state

If someone changed the remote database data or view, the local view of the database might differ from the actual state of the database.

Step 2. Verify that the necessary schemas are selected

note

If you see no schemas in the popup, check whether a connection to a data source is available. For more information, refer to this troubleshooting article or report the situation to us.

When you create a data source, the data source is created with no schemas selected. You need to select schemas with which you plan to work.

To select the schemas, do one of the following:

The Default schema or Default database is a schema or a database that will be current in connection to a data source. The current schema is a schema that is current in a session. You can change the current schema by using SET CURRENT_SCHEMA. The default schema depends on database settings and data source settings that you set in the JDBC URL.

You can change this default in connection settings of a data source. To change the default, click the Data Source Properties icon The Data Source Properties icon in the Database tool window (View | Tool Windows | Database). From the list of data sources, select your data source. In the Database field, type the name of a schema or a database that you want to use as a default.

Step 3. Verify that the tree filter is off

If the items of the object kind are filtered out from the view, the objects wil be hidden in the Database tool window.

To make sure the database object is not filtered out from the view, do the following:

Step 4. Force refresh schema information

The Force Refresh action clears the data source information from cache and loads it again from scratch.

Step 5. Clear and synchronize the schema cache

Collect information by using Diagnostic tools

To profile the introspection and diagnose possible issues, GoLand can generate three files that include information about the following:

  • dataSource.txt: the data source.

  • introspector.txt: a module that was used to load the metadata from the database.

  • model.xml: a part of the database model.

This information might be helpful when introspection works incorrectly. For example, when you see something outdated or do not see new objects.

To report an issue, you can use any option that is described in the Where to report an issue section. But we recommend using the JetBrains Support Center.

Submit a request in the JetBrains Support Center

  1. Click Help | Contact Support.

  2. Fill in the Submit a request form.

    If it is possible, attach some troubleshooting materials.

  3. Click Submit.

Switch to the JDBC-based introspector

warning

Switch to the JDBC-based introspector with caution and when requested by the JetBrains support team. This step may lead to problems with code generation because some objects and properties become unavailable or return wrong values.

Consider this step as a temporary workaround. If you cannot see objects in the Database tool window, you might have a bug. Collect troubleshooting materials and send them to our support team.