First, you need to ensure that the databases / schemas you have selected need to be introspected. The more objects and data you have, the more time it'd take to synchronize everything.
Upload id: 2024_12_12_rMcU7w7Ly76TdKYstxgcuK (file: database.0.log) My other database links are normally synchronized, but this one isn't. The previous database link was able to synchronize normally, but it doesn't work anymore. I don't know what went wrong in between.
The log you provided is showing that all sessions were finished within milli seconds (execution and fetching). I can't inidicate any issues judging by the records I have seen.
Please turn on the diagnostic mode and click Refresh on the database in question to trigger the introspection. Upload the log once you are done. See here for more guidance
I see there's a query that's failing upon multiple attempts. Please see if you can manually execute this query over the problematic database
with V01 as (select 0 from sys.obj$ where 1 is null), V02 as (select 0 from sys.type$ where 1 is null), V03 as (select 0 from sys.ind$ where 1 is null), V04 as (select 0 from sys.ts$ where 1 is null), V05 as (select 0 from sys.con$ where 1 is null), V06 as (select 0 from sys.cdef$ where 1 is null), V07 as (select 0 from sys.col$ where 1 is null), V08 as (select 0 from sys.dependency$ where 1 is null), V09 as (select 0 from sys.trigger$ where 1 is null), V10 as (select 0 from sys.procedureinfo$ where 1 is null), V11 as (select 0 from sys.syn$ where 1 is null) select 1 from dual where not exists (select 1 from V01) and not exists (select 1 from V02) and not exists (select 1 from V03) and not exists (select 1 from V04) and not exists (select 1 from V05) and not exists (select 1 from V06) and not exists (select 1 from V07) and not exists (select 1 from V08) and not exists (select 1 from V09) and not exists (select 1 from V10) and not exists (select 1 from V11)
As a workaround, I'd suggest adding a separate data source by including only that database and activating Interspect JDBC metadata. See if it works
Are you referring to the introspection with Introspect JDBC metadata option turned on? Have you tried to execute the query above manually and what is the execution time? Please provide more details
First, you need to ensure that the databases / schemas you have selected need to be introspected. The more objects and data you have, the more time it'd take to synchronize everything.
https://www.jetbrains.com/help/datagrip/cannot-find-a-database-object-in-the-database-tree-view.html#step-2-verify-that-the-necessary-schemas-are-selected
To investigate this issue, please provide the database log from Help - Show SQL Log in Files and the following logs:
https://www.jetbrains.com/help/datagrip/reporting-loading-of-database-objects-takes-too-much-time.html
Please upload onto https://uploads.jetbrains.com/ and include the upload id in your reply
Upload id: 2024_12_12_rMcU7w7Ly76TdKYstxgcuK (file: database.0.log)
My other database links are normally synchronized, but this one isn't. The previous database link was able to synchronize normally, but it doesn't work anymore. I don't know what went wrong in between.
The log you provided is showing that all sessions were finished within milli seconds (execution and fetching). I can't inidicate any issues judging by the records I have seen.
Please turn on the diagnostic mode and click Refresh on the database in question to trigger the introspection. Upload the log once you are done. See here for more guidance
https://www.jetbrains.com/help/datagrip/reporting-loading-of-database-objects-takes-too-much-time.html
Upload ID: 2024_12_17_FBUcvKB31SnZffxVBpNJqX
New log has been uploaded
I see there's a query that's failing upon multiple attempts. Please see if you can manually execute this query over the problematic database
with V01 as (select 0 from sys.obj$ where 1 is null),V02 as (select 0 from sys.type$ where 1 is null),V03 as (select 0 from sys.ind$ where 1 is null),V04 as (select 0 from sys.ts$ where 1 is null),V05 as (select 0 from sys.con$ where 1 is null),V06 as (select 0 from sys.cdef$ where 1 is null),V07 as (select 0 from sys.col$ where 1 is null),V08 as (select 0 from sys.dependency$ where 1 is null),V09 as (select 0 from sys.trigger$ where 1 is null),V10 as (select 0 from sys.procedureinfo$ where 1 is null),V11 as (select 0 from sys.syn$ where 1 is null)select 1from dualwhere not exists (select 1 from V01)and not exists (select 1 from V02)and not exists (select 1 from V03)and not exists (select 1 from V04)and not exists (select 1 from V05)and not exists (select 1 from V06)and not exists (select 1 from V07)and not exists (select 1 from V08)and not exists (select 1 from V09)and not exists (select 1 from V10)and not exists (select 1 from V11)As a workaround, I'd suggest adding a separate data source by including only that database and activating Interspect JDBC metadata. See if it works
I couldn't find this option
Select your data source and go to Advanced tab where you need to click on Expert Options located at the bottom-right corner
The execution is very slow and has taken quite a long time, and the fields in the table have not been fully loaded
Yes I did it manually. I worked for a day but still couldn't complete the synchronization