Database view does not show database structure in DataGrip

Answered

I am trying to modify my database, however the Database View does not appear to be listing any tables in my database.

I found this page which shows exactly what I would expect: https://www.jetbrains.com/help/datagrip/2016.2/working-with-the-database-tool-window.html#open_db_tool_window

I do not believe my settings are incorrect and my server is definitely connected as I can use the console to select from tables.

 

Any help would be much appreciated.

 

Thanks

29 comments
Comment actions Permalink

Hello Ben,

Please select Synchronize button in the database tool window panel (at top). Also, please make sure that database connection settings are entered correctly. Please attach screenshot with connection settings and output from idea.log after trying to Synchronize if problem remains.

0
Comment actions Permalink

I have tried Synchronizing a number of times, each time with no luck.

The database connection definitely works as I am told it works correctly when I test, and can use normal queries in the console.

0
Comment actions Permalink

Please post content of idea.log file after restart and clicking the Synchronize action. Also attach screenshot with your connection settings. Thanks.

0
Comment actions Permalink

Hello Andrey,

 

Similar problem, I have faced with. I want to connect an As400 database. Connection status is OK, however, when I try to Synchronize, nothing happened.

Log file content like this:

 

2016-07-25 16:51:35,145 [ 0] INFO - #com.intellij.idea.Main - ------------------------------------------------------ IDE STARTED ------------------------------------------------------
2016-07-25 16:51:35,145 [ 0] INFO - #com.intellij.idea.Main - IDE: DataGrip (build #DB-162.1122.5, 20 Jul 2016 00:00)
2016-07-25 16:51:35,145 [ 0] INFO - #com.intellij.idea.Main - OS: Windows 7 (6.1, amd64)
2016-07-25 16:51:35,145 [ 0] INFO - #com.intellij.idea.Main - JRE: 1.8.0_101-b13 (Oracle Corporation)
2016-07-25 16:51:35,145 [ 0] INFO - #com.intellij.idea.Main - JVM: 25.101-b13 (Java HotSpot(TM) 64-Bit Server VM)
2016-07-25 16:51:35,145 [ 0] INFO - #com.intellij.idea.Main - JVM Args: -Xms128m -Xmx750m -XX:ReservedCodeCacheSize=240m -XX:+UseConcMarkSweepGC -XX:SoftRefLRUPolicyMSPerMB=50 -ea -Dsun.io.useCanonCaches=false -Djava.net.preferIPv4Stack=true -XX:+HeapDumpOnOutOfMemoryError -XX:-OmitStackTraceInFastThrow -Djb.vmOptionsFile=C:\Program Files (x86)\JetBrains\DataGrip 2016.2\bin\datagrip64.exe.vmoptions -Xbootclasspath/a:C:\Program Files (x86)\JetBrains\DataGrip 2016.2\lib\boot.jar -Didea.platform.prefix=DataGrip -Didea.paths.selector=DataGrip2016.2 -XX:ErrorFile=C:\Users\***2880\java_error_in_datagrip_%p.log -XX:HeapDumpPath=C:\Users\***2880\java_error_in_datagrip.hprof
2016-07-25 16:51:35,145 [ 0] INFO - #com.intellij.idea.Main - ext: C:\Program Files\Java\jdk1.8.0_101\jre\lib\ext: [access-bridge-64.jar, cldrdata.jar, dnsns.jar, jaccess.jar, jfxrt.jar, localedata.jar, meta-index, nashorn.jar, sunec.jar, sunjce_provider.jar, sunmscapi.jar, sunpkcs11.jar, zipfs.jar]
2016-07-25 16:51:35,145 [ 0] INFO - #com.intellij.idea.Main - JNU charset: Cp1254
2016-07-25 16:51:35,223 [ 78] INFO - #com.intellij.idea.Main - JNA library loaded (64-bit) in 78 ms
2016-07-25 16:51:35,223 [ 78] INFO - penapi.util.io.win32.IdeaWin32 - Native filesystem for Windows is operational
2016-07-25 16:51:35,223 [ 78] INFO - #com.intellij.idea.Main - Using "FocusKiller" library to prevent focus stealing.
2016-07-25 16:51:36,348 [ 1203] INFO - llij.ide.plugins.PluginManager - 2 plugins initialized in 344 ms
2016-07-25 16:51:36,348 [ 1203] INFO - llij.ide.plugins.PluginManager - Loaded bundled plugins: IDEA CORE (162.1122.5)
2016-07-25 16:51:36,348 [ 1203] INFO - llij.ide.plugins.PluginManager - Loaded custom plugins: IntelliLang (8.0)
2016-07-25 16:51:36,613 [ 1468] INFO - ellij.vfs.persistent.FSRecords - Marking VFS as corrupted: 'C:\Users\***2880\.DataGrip2016.2\system\caches\names.dat' does not exist
2016-07-25 16:51:36,613 [ 1468] INFO - ellij.util.io.PagedFileStorage - lower=100; upper=500; buffer=10; max=705
2016-07-25 16:51:36,676 [ 1531] INFO - pl.local.NativeFileWatcherImpl - Starting file watcher: C:\Program Files (x86)\JetBrains\DataGrip 2016.2\bin\fsnotifier64.exe
2016-07-25 16:51:36,691 [ 1546] INFO - pl.local.NativeFileWatcherImpl - Native file watcher is operational.
2016-07-25 16:51:37,081 [ 1936] INFO - .history.utils.LocalHistoryLog - local history version mismatch (was: 0, expected: 6), rebuilding...
2016-07-25 16:51:37,081 [ 1936] INFO - .history.utils.LocalHistoryLog - FS has been rebuild, rebuilding local history...
2016-07-25 16:51:37,379 [ 2234] WARN - nSystem.impl.ActionManagerImpl - keymap "Visual Studio" not found [Plugin: com.intellij]
2016-07-25 16:51:37,486 [ 2341] INFO - rains.ide.BuiltInServerManager - built-in server started, port 63342
2016-07-25 16:51:37,528 [ 2383] INFO - gs.impl.UpdateCheckerComponent - channel: release
2016-07-25 16:51:37,621 [ 2476] INFO - il.indexing.FileBasedIndexImpl - Index exts enumerated:40
2016-07-25 16:51:37,621 [ 2476] INFO - il.indexing.FileBasedIndexImpl - Index scheduled:3
2016-07-25 16:51:37,622 [ 2477] INFO - tellij.psi.stubs.StubIndexImpl - All stub exts enumerated:7
2016-07-25 16:51:37,622 [ 2477] INFO - tellij.psi.stubs.StubIndexImpl - stub exts update scheduled:0
2016-07-25 16:51:37,879 [ 2734] INFO - ij.psi.stubs.StubUpdatingIndex - Following new file types will be indexed:HTML,XML,SQL
2016-07-25 16:51:37,950 [ 2805] INFO - j.ide.script.IdeStartupScripts - 0 startup script(s) found
2016-07-25 16:51:38,015 [ 2870] INFO - plication.impl.ApplicationImpl - 75 application components initialized in 2011 ms
2016-07-25 16:51:38,186 [ 3041] INFO - pl$FileIndexDataInitialization - Initialization done:561
2016-07-25 16:51:38,299 [ 3154] INFO - exImpl$StubIndexInitialization - Initialization done:112
2016-07-25 16:51:38,922 [ 3777] INFO - .openapi.application.Preloader - Finished preloading com.intellij.openapi.actionSystem.impl.ActionPreloader@363a622b
2016-07-25 16:51:39,129 [ 3984] INFO - .openapi.application.Preloader - Finished preloading com.intellij.ide.ui.search.SearchableOptionPreloader@6be597a4
2016-07-25 16:51:51,017 [ 15872] INFO - net.ssl.ConfirmingTrustManager - Certificate was accepted by user
2016-07-25 16:51:53,831 [ 18686] INFO - net.ssl.ConfirmingTrustManager - Certificate was accepted by user
2016-07-25 16:52:07,901 [ 32756] INFO - .intellij.idea.IdeaApplication - App initialization took 40080 ms
2016-07-25 16:52:08,307 [ 33162] INFO - ellij.project.impl.ProjectImpl - 15 project components initialized in 156 ms
2016-07-25 16:52:08,307 [ 33162] INFO - le.impl.ModuleManagerComponent - 0 module(s) loaded in 0 ms
2016-07-25 16:52:08,704 [ 33559] INFO - ellij.project.impl.ProjectImpl - 89 project components initialized in 335 ms
2016-07-25 16:52:08,704 [ 33559] INFO - le.impl.ModuleManagerComponent - 0 module(s) loaded in 0 ms
2016-07-25 16:52:08,704 [ 33559] INFO - i.vcs.changes.ChangeListWorker - default list not found when copy
2016-07-25 16:52:08,704 [ 33559] INFO - i.vcs.changes.ChangeListWorker - default list not found when copy in original object too
2016-07-25 16:52:08,766 [ 33621] INFO - ion.impl.ConversionContextImpl - C:\Users\***2880\.DataGrip2016.2\config\projects\default\.idea\misc.xml: C:\Users\***2880\.DataGrip2016.2\config\projects\default\.idea\misc.xml (Sistem belirtilen dosyayı bulamıyor)
com.intellij.conversion.CannotConvertException: C:\Users\***2880\.DataGrip2016.2\config\projects\default\.idea\misc.xml: C:\Users\***2880\.DataGrip2016.2\config\projects\default\.idea\misc.xml (Sistem belirtilen dosyayı bulamıyor)
at com.intellij.ide.impl.convert.JDomConvertingUtil.loadDocument(JDomConvertingUtil.java:53)
at com.intellij.conversion.impl.SettingsXmlFile.<init>(SettingsXmlFile.java:42)
at com.intellij.conversion.impl.ConversionContextImpl.getOrCreateFile(ConversionContextImpl.java:458)
at com.intellij.conversion.impl.XmlBasedSettingsImpl.<init>(XmlBasedSettingsImpl.java:32)
at com.intellij.conversion.impl.ComponentManagerSettingsImpl.<init>(ComponentManagerSettingsImpl.java:33)
at com.intellij.conversion.impl.ConversionContextImpl.createProjectSettings(ConversionContextImpl.java:284)
at com.intellij.conversion.impl.ConversionContextImpl.getProjectFileVersionSettings(ConversionContextImpl.java:268)
at com.intellij.conversion.impl.ConversionContextImpl.a(ConversionContextImpl.java:440)
at com.intellij.conversion.impl.ConversionContextImpl.<init>(ConversionContextImpl.java:100)
at com.intellij.impl.ConversionServiceImpl.isConversionNeeded(ConversionServiceImpl.java:178)
at com.intellij.impl.ConversionServiceImpl.convert(ConversionServiceImpl.java:127)
at com.intellij.openapi.project.impl.ProjectManagerImpl.convertAndLoadProject(ProjectManagerImpl.java:440)
at com.intellij.platform.PlatformProjectOpenProcessor.doOpenProject(PlatformProjectOpenProcessor.java:172)
at com.intellij.database.ide.DatabaseProjectUtil.a(DatabaseProjectUtil.java:87)
at com.intellij.database.ide.DatabaseProjectUtil.a(DatabaseProjectUtil.java:60)
at com.intellij.openapi.progress.impl.CoreProgressManager.a(CoreProgressManager.java:494)
at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:443)
at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:54)
at com.intellij.openapi.progress.impl.CoreProgressManager.executeNonCancelableSection(CoreProgressManager.java:198)
at com.intellij.database.ide.DatabaseProjectUtil.openOrCreateProject(DatabaseProjectUtil.java:60)
at com.intellij.database.ide.DatabaseRecentProjectManager.b(DatabaseRecentProjectManager.java:90)
at com.intellij.database.ide.DatabaseRecentProjectManager.doReopenLastProject(DatabaseRecentProjectManager.java:49)
at com.intellij.ide.RecentProjectsManagerBase$MyAppLifecycleListener.appStarting(RecentProjectsManagerBase.java:636)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intellij.util.messages.impl.MessageBusConnectionImpl.deliverMessage(MessageBusConnectionImpl.java:117)
at com.intellij.util.messages.impl.MessageBusImpl.doPumpMessages(MessageBusImpl.java:377)
at com.intellij.util.messages.impl.MessageBusImpl.pumpMessages(MessageBusImpl.java:364)
at com.intellij.util.messages.impl.MessageBusImpl.sendMessage(MessageBusImpl.java:343)
at com.intellij.util.messages.impl.MessageBusImpl.access$200(MessageBusImpl.java:42)
at com.intellij.util.messages.impl.MessageBusImpl$2.invoke(MessageBusImpl.java:226)
at com.sun.proxy.$Proxy39.appStarting(Unknown Source)
at com.intellij.idea.IdeaApplication$IdeStarter.a(IdeaApplication.java:343)
at com.intellij.openapi.application.TransactionGuardImpl.a(TransactionGuardImpl.java:88)
at com.intellij.openapi.application.TransactionGuardImpl.access$300(TransactionGuardImpl.java:40)
at com.intellij.openapi.application.TransactionGuardImpl$2.run(TransactionGuardImpl.java:113)
at com.intellij.openapi.application.TransactionGuardImpl.submitTransaction(TransactionGuardImpl.java:123)
at com.intellij.openapi.application.TransactionGuard.submitTransaction(TransactionGuard.java:109)
at com.intellij.idea.IdeaApplication$IdeStarter.main(IdeaApplication.java:341)
at com.intellij.idea.IdeaApplication.a(IdeaApplication.java:196)
at com.intellij.openapi.application.TransactionGuardImpl.performUserActivity(TransactionGuardImpl.java:199)
at com.intellij.idea.IdeaApplication.run(IdeaApplication.java:196)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intellij.idea.MainImpl$1$1.a(MainImpl.java:63)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:358)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: java.io.FileNotFoundException: C:\Users\***2880\.DataGrip2016.2\config\projects\default\.idea\misc.xml (Sistem belirtilen dosyayı bulamıyor)
at java.io.FileInputStream.open0(Native Method)
at java.io.FileInputStream.open(FileInputStream.java:195)
at java.io.FileInputStream.<init>(FileInputStream.java:138)
at com.intellij.openapi.util.JDOMUtil.loadDocument(JDOMUtil.java:274)
at com.intellij.ide.impl.convert.JDomConvertingUtil.loadDocument(JDomConvertingUtil.java:47)
... 63 more
2016-07-25 16:52:08,797 [ 33652] INFO - ellij.project.impl.ProjectImpl - 89 project components initialized in 15 ms
2016-07-25 16:52:08,797 [ 33652] INFO - le.impl.ModuleManagerComponent - 0 module(s) loaded in 0 ms
2016-07-25 16:52:09,333 [ 34188] INFO - .diagnostic.PerformanceWatcher - Pushing properties took 0ms; general responsiveness: ok; EDT responsiveness: ok
2016-07-25 16:52:09,350 [ 34205] INFO - tor.impl.FileEditorManagerImpl - Project opening took 585 ms
2016-07-25 16:52:09,535 [ 34390] INFO - .diagnostic.PerformanceWatcher - Indexable file iteration took 202ms; general responsiveness: ok; EDT responsiveness: ok
2016-07-25 16:52:09,535 [ 34390] INFO - indexing.UnindexedFilesUpdater - Unindexed files update started: 219 files to update
2016-07-25 16:52:11,032 [ 35887] INFO - .diagnostic.PerformanceWatcher - Unindexed files update took 1497ms; general responsiveness: ok; EDT responsiveness: ok
2016-07-25 16:53:00,597 [ 85452] INFO - ution.rmi.RemoteProcessSupport - "C:\Program Files\Java\jdk1.8.0_101\jre\bin\java" -Djava.net.preferIPv4Stack=true -Dfile.encoding=UTF-8 -classpath "C:\Program Files (x86)\JetBrains\DataGrip 2016.2\lib\util.jar;C:\Program Files (x86)\JetBrains\DataGrip 2016.2\lib\trove4j.jar;C:\Program Files (x86)\JetBrains\DataGrip 2016.2\lib\groovy-all-2.4.6.jar;C:\Program Files (x86)\JetBrains\DataGrip 2016.2\lib\jdbc-console.jar;C:\Program Files (x86)\JetBrains\DataGrip 2016.2\lib\dekaf-single-2.0.0.264.jar;C:\Users\***2880\.DataGrip2016.2\config\jdbc-drivers\jtopen-driver-license.txt;C:\Users\***2880\.DataGrip2016.2\config\jdbc-drivers\jt400.jar" com.intellij.database.remote.RemoteJdbcServer com.ibm.as400.access.AS400JDBCDriver
2016-07-25 16:53:01,085 [ 85940] INFO - ution.rmi.RemoteProcessSupport - Port/ID: 25592/RemoteDriverImpl4f5c45a0
2016-07-25 16:53:01,194 [ 86049] INFO - ase.dataSource.LocalDataSource - Connecting to: jdbc:as400://**.**.**.***
2016-07-25 16:53:01,507 [ 86362] INFO - ution.rmi.RemoteProcessSupport - Terminating: 25592/RemoteDriverImpl4f5c45a0
2016-07-25 16:53:01,696 [ 86551] INFO - ution.rmi.RemoteProcessSupport - Process finished with exit code 1
2016-07-25 16:53:07,383 [ 92238] INFO - ution.rmi.RemoteProcessSupport - "C:\Program Files\Java\jdk1.8.0_101\jre\bin\java" -Djava.net.preferIPv4Stack=true -Dfile.encoding=UTF-8 -classpath "C:\Program Files (x86)\JetBrains\DataGrip 2016.2\lib\util.jar;C:\Program Files (x86)\JetBrains\DataGrip 2016.2\lib\trove4j.jar;C:\Program Files (x86)\JetBrains\DataGrip 2016.2\lib\groovy-all-2.4.6.jar;C:\Program Files (x86)\JetBrains\DataGrip 2016.2\lib\jdbc-console.jar;C:\Program Files (x86)\JetBrains\DataGrip 2016.2\lib\dekaf-single-2.0.0.264.jar;C:\Users\***2880\.DataGrip2016.2\config\jdbc-drivers\jtopen-driver-license.txt;C:\Users\***2880\.DataGrip2016.2\config\jdbc-drivers\jt400.jar" com.intellij.database.remote.RemoteJdbcServer com.ibm.as400.access.AS400JDBCDriver
2016-07-25 16:53:07,965 [ 92820] INFO - ution.rmi.RemoteProcessSupport - Port/ID: 20444/RemoteDriverImpl1619e3b7
2016-07-25 16:53:08,043 [ 92898] INFO - ase.dataSource.LocalDataSource - Connecting to: jdbc:as400://**.**.**.***
2016-07-25 16:53:51,214 [ 136069] WARN - om.intellij.util.ProfilingUtil - Profiling agent is not enabled. Add -agentlib:yjpagent to idea.vmoptions if necessary to profile IDEA.
2016-07-25 16:53:51,230 [ 136085] INFO - .script.IdeScriptEngineManager - javax.script.ScriptEngineManager initialized in 16 ms





0
Comment actions Permalink

Hello Okan,

See More Schemas... action in the Database tool window. Do you see a popup with schemas/databases list when selecting it?

2
Comment actions Permalink

Hello Andrey,

 

As you said, when I clicked them I could manually load them. However, after that when I tried to write some scripts, there were any intellisense suggestions.

CTRL + SPACE and as a result i saw "No suggestions" warning. I hope I clearly describe the problem.

 

In previous version (2016.1.4) when I clicked "Synchronize" action I could get the whole data with tables and views.

 

Many thanks for response.

0
Comment actions Permalink

Please select needed schemas/databases you want to resolve unqualified references for in Schemas tab of the Data Source.

We will rework this this workflow to make it more obvious in near versions.

0
Comment actions Permalink

Nothing has changed. Thanks for patience and helps.

I can write scripts without intellisense. 

0
Comment actions Permalink

I don't see that the selected shemas were actually introspected as there are no db objects listed for any schemas. Have you invoked Synchronize action in Database tool window?

What is the current schema you are working with? Do you see it listed in the <schemas> dropdown in the Editor? 

Do resolve work if you qualify the db object with the schema/database name explicitly?

0
Comment actions Permalink

So... I somehow resolved the issue removing the connection and adding it again.. 

I don't know if it can help anybody but it is working for me.

 

It would be great anyway to have an answer

3
Comment actions Permalink

Well blimey, that did it.

Seems like a bug...

0
Comment actions Permalink

By the way it seems i can see tables/views from just one connection, I have others and i can query those DB but it is not showing objects... I hope they will fix this..

0
Comment actions Permalink

i am also getting the same issue and tried deleting the connection and creating it again, didn't work.

also tried creating new workspace and creating new connection again didn't work.

please provide some solution

0
Comment actions Permalink

Having same issue with Phpstorm and Postgresql.

But I'm getting baloon with text "com/intellij/database/model/impl/PostgresImplModel" also

0
Comment actions Permalink

I am having similar problems to the one described in this issue. Its like I get to run once then have to drop and recreate the datasource to do another query. I am using SQL Server. The view won't refresh. Its a real pity because I am really liking the actual "writing SQL" part of this tool.

Its like it is forgetting I am dbo when it refreshes and not finding any objects for me in the database.

edit: as a follow up, it does seem related to filtering. When I expand the filter, select both "current schema (dbo)" and "dbo (current schema)" I get my tables back.

0
Comment actions Permalink

Same issue here. But if I remove the checkmark from Connection Properties -> Options -> Introspect using JDBC metadata then it does find the correct database views.

However, if I then check that checkbox again, it reverts back to the erroneous list of views. So it seems like the JDBC metadata is faulty and does not get updated correctly on inspection. 

1
Comment actions Permalink

It appears that you have to add any sub-schemas in the 'Data Sources and Drivers' window. To access this screen follow these steps:

  1. ctrl + alt + shift + s to open the window
  2. select the data source that is not synchronizing
  3. In the right pane, select 'Schemas'
  4. Ensure the schema you want to read is selected, if there is a drop down arrow select that and select any sub schemas you want to synchronize. For me, if I did not select a sub schema for an MSSQL the synchronization would not work.
  5. Click apply, click ok
  6. Right click the data source and select 'Synchronize'

4
Comment actions Permalink

The same issue here with Oracle data source. 

 

Here's the DDL I see on one of the views:

-- auto-generated definition
-- No source text available

On the other hand, TOAD generatest script for the very same view successfully.

Tried Synchronizing numerous times, played with other options - no luck.

1
Comment actions Permalink

We also have the same issue with Oracle and PHPSTORM 2016.3.

Impossible to have auto completion working.

Is there a fix?

0
Comment actions Permalink

For me this helped:
Data source and Drivers -> <Chose connection> -> Options -> check "Introspect using JDBC metadata"

2
Comment actions Permalink

For me, it is still failing to show the tables. The approaches mentioned above did not help.

0
Comment actions Permalink

I tried 2018.1.5, didn't work as well.

 

I reverted to 2017.3.7 and its working without changing anything. It is clearly a bug. Please fix it and release a patch.

0
Comment actions Permalink

@All
Could you send full IDE logs to me Vasily.Chernov@jetbrains.com for further investigation?

0
Comment actions Permalink

"uninstall" and "reinstall" seems to resolve the issue. 

0
Comment actions Permalink

@Kuang Lee

That's great, but do you have previous log files you can share? For us is better to find out the root cause of the problem.

0
Comment actions Permalink

 

@vasily chernov

I remember that I changed some parameters that caused that issue, which cannot get reverted. But the way, where are the log files located? I am not sure if the old log files are still there.

 

 

0
Comment actions Permalink

For me, what helped is:

In connection properties, select Advanced tab and set:

metadatasource: 0

It's retrieving tables, indices and primary keys. But no columns. At least something...

I must say that I only have the issue when I use JT400 and DB2 databases. Other RDBMS work perfectly.

0
Comment actions Permalink

@Luca Ferretti

Thank you, seems like an obvious first thing to do but it wasn't for me. Simply removing and adding it back sorted it out, though still have no idea what the original cause was.

1

Please sign in to leave a comment.