Cannot find a database object in the database tree view
note
If steps 1, 2, and 3 did not resolve your problem, inform JetBrains of your situation by creating a Youtrack ticket. After you have created the ticket, try steps 4 and 5 as a workaround.
Step 1. Refresh the database state
To synchronize the database state automatically, in the Database tool window (), click the Data Source Properties button
and select the data source that you want to change. On the Options tab, select the Auto sync checkbox.If the Auto sync checkbox is cleared, the view of the data source in the Database tool window () is synchronized with the actual state of the database only when you click the Refresh icon
or press Ctrl+F5.
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. Refer to this troubleshooting article or report the situation to us.
You can change this default in connection settings of a data source. To change the default, click the Data Source Properties icon in the Database tool window (). In the data sources list, 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.
To display a schema in the Database tool window, perform one of the following actions:
In the Database tool window (), right-click a data source and navigate to . Select or clear checkboxes of schemas that you want to enable or disable. Press Enter.
Click the N of N link near the data source name. In the schema selection window, select or clear checkboxes of schemas that you want to enable or disable. Press Enter.
To hide all schemas, navigate to .
Step 3. Force refresh schema information
In the Database tool window (), right-click a data source and select .
Step 5. Switch to the JDBC-based introspector
warning
Switch to the JDBC-based introspector with caution. This step may lead to problems with code generation because some objects and properties become unavailable or return wrong values.
Temporary enable introspection with JDBC metadata
In the Database tool window (), click the Data Source Properties icon
.On the Data Sources tab, select the data source that you want to modify.
Click the Advanced tab and select the Introspect using JDBC metadata checkbox.
Synchronize the view (see Step 1. Synchronize the database state).
Collect information by using Diagnostic tools
Right-click a data source and navigate to . Select between the following options:
Dump Model: generates a RubyMine-specific representation of the database structure (a database model). You can include automatically generated content by clicking the Include auto-generated content icon.
Diagnostic Refresh: reloads the metadata from the database and generates a LOG file. This information might be helpful for the support team when you think that your introspection is slow.
Prepare Introspector Diagnostics: generates three files that include information about the data source (dataSource.txt), a module that was used to load the metadata from the database (introspector.txt), and a part of the database model (model.xml).
This information might be helpful when introspection works incorrectly. For example, when you see something outdated or do not see new objects.
The following screenshot shows the example output of these three files.