`.` error when MS SQL connection is trying to be made
Hey guys,
I did upgrade to the latest 2020.1 and noticed that it can't connect to any MS SQL DBs. It's not network issue as i even can't connect to my local SQL Server 2017. And the only error that i'm getting is just a dot. It's the same when i click Test Connection on connection properties and the same when i'm trying to execute any SQL for that DB so it will connect console. I'm not sure is it related to update or not as it was working some time after that but i'm not totally sure. My Local DB is on default port and doesn't have custom named instance and the same connection worked before. I also tried the latest 8 and previous 7.4.1 MS SQL driver as well and the same reslt
Here is my UI error:
Here is also AppData\Local\JetBrains\DataGrip2020.1\log\idea.log file as it has some exception with RemoteProcessSupport:
2020-06-03 16:16:59,393 [ 0] INFO - #com.intellij.idea.Main - ------------------------------------------------------ IDE STARTED ------------------------------------------------------
2020-06-03 16:16:59,421 [ 28] INFO - #com.intellij.idea.Main - IDE: DataGrip (build #DB-201.7846.70, 28 May 2020 21:23)
2020-06-03 16:16:59,424 [ 31] INFO - #com.intellij.idea.Main - OS: Windows 10 (10.0, amd64)
2020-06-03 16:16:59,424 [ 31] INFO - #com.intellij.idea.Main - JRE: 11.0.7+10-b765.53 (JetBrains s.r.o.)
2020-06-03 16:16:59,425 [ 32] INFO - #com.intellij.idea.Main - JVM: 11.0.7+10-b765.53 (OpenJDK 64-Bit Server VM)
2020-06-03 16:16:59,427 [ 34] INFO - #com.intellij.idea.Main - JVM Args: exit -Xms128m -Xmx2048m -XX:ReservedCodeCacheSize=240m -XX:+UseConcMarkSweepGC -XX:SoftRefLRUPolicyMSPerMB=50 -ea -XX:CICompilerCount=2 -Dsun.io.useCanonPrefixCache=false -Djava.net.preferIPv4Stack=true -Djdk.http.auth.tunneling.disabledSchemes="" -XX:+HeapDumpOnOutOfMemoryError -XX:-OmitStackTraceInFastThrow -Djdk.attach.allowAttachSelf=true -Dkotlinx.coroutines.debug=off -Djdk.module.illegalAccess.silent=true -Djb.vmOptionsFile=C:\Users\somename\AppData\Roaming\JetBrains\DataGrip2020.1\datagrip64.exe.vmoptions -Djava.library.path=C:\Program Files\JetBrains\DataGrip 2019.3.3\jbr\\bin;C:\Program Files\JetBrains\DataGrip 2019.3.3\jbr\\bin\server -Didea.platform.prefix=DataGrip -Dide.native.launcher=true -Didea.paths.selector=DataGrip2020.1 -XX:ErrorFile=C:\Users\somename\java_error_in_datagrip_%p.log -XX:HeapDumpPath=C:\Users\somename\java_error_in_datagrip.hprof
2020-06-03 16:16:59,429 [ 36] INFO - #com.intellij.idea.Main - Locale=en_US JNU=Cp1251 file.encoding=Cp1251
2020-06-03 16:16:59,794 [ 401] WARN - llij.ide.plugins.PluginManager - Resource bundle redefinition for plugin 'com.intellij'. Old value: messages.CommonProfilerBundle, new value: messages.DataGripBundle
2020-06-03 16:17:00,007 [ 614] INFO - #com.intellij.idea.Main - JNA library (64-bit) loaded in 589 ms
2020-06-03 16:17:00,012 [ 619] INFO - penapi.util.io.win32.IdeaWin32 - Native filesystem for Windows is operational
2020-06-03 16:17:00,690 [ 1297] INFO - ntellij.idea.ApplicationLoader - CPU cores: 6; ForkJoinPool.commonPool: java.util.concurrent.ForkJoinPool@1c36a41a[Running, parallelism = 5, size = 0, active = 0, running = 0, steals = 0, tasks = 0, submissions = 0]; factory: com.intellij.concurrency.IdeaForkJoinWorkerThreadFactory@378da1a3
2020-06-03 16:17:00,704 [ 1311] INFO - llij.ide.plugins.PluginManager - Loaded bundled plugins: IDEA CORE (201.7846.70), com.intellij.platform.images (201.7846.70), UML (201.7846.70), Windows 10 Light Theme (201.7846.70), IntelliLang (201.7846.70), Database Tools and SQL (201.7846.70), DataGrip Customization (201.7846.70)
2020-06-03 16:17:00,704 [ 1311] INFO - llij.ide.plugins.PluginManager - Loaded custom plugins: DataGrip Help (201.7846.70)
2020-06-03 16:17:00,830 [ 1437] INFO - ellij.util.io.PagedFileStorage - lower=100; upper=500; buffer=10; max=1978
2020-06-03 16:17:00,837 [ 1444] INFO - tellij.util.io.FileChannelUtil - un-interruptible FileChannel-s will be used for indexes
2020-06-03 16:17:00,942 [ 1549] INFO - til.net.ssl.CertificateManager - Default SSL context initialized
2020-06-03 16:17:01,061 [ 1668] INFO - rains.ide.BuiltInServerManager - built-in server started, port 63343
2020-06-03 16:17:01,115 [ 1722] INFO - com.intellij.ide.ui.UISettings - Loaded: fontSize=13, fontScale=1.0; restored: fontSize=13, fontScale=1.0
2020-06-03 16:17:01,143 [ 1750] INFO - com.intellij.ide.ui.UISettings - Loaded: fontSize=13, fontScale=null; restored: fontSize=12, fontScale=1.0
2020-06-03 16:17:01,155 [ 1762] INFO - com.intellij.ide.ui.UISettings - Loaded: fontSize=13, fontScale=null; restored: fontSize=12, fontScale=1.0
2020-06-03 16:17:01,170 [ 1777] INFO - gs.impl.UpdateCheckerComponent - channel: release
2020-06-03 16:17:01,202 [ 1809] INFO - m.PlatformProjectOpenProcessor - Opening C:\Users\somename\AppData\Roaming\JetBrains\DataGrip2020.1\projects\default
2020-06-03 16:17:01,305 [ 1912] INFO - BridgeProjectLifecycleListener - Using legacy project model to open project
2020-06-03 16:17:01,359 [ 1966] INFO - pl.local.NativeFileWatcherImpl - Starting file watcher: C:\Program Files\JetBrains\DataGrip 2019.3.3\bin\fsnotifier64.exe
2020-06-03 16:17:01,394 [ 2001] INFO - pl.local.NativeFileWatcherImpl - Native file watcher is operational.
2020-06-03 16:17:01,491 [ 2098] WARN - nSystem.impl.ActionManagerImpl - keymap "Visual Studio" not found [Plugin: com.intellij]
2020-06-03 16:17:01,493 [ 2100] WARN - nSystem.impl.ActionManagerImpl - keymap "Eclipse" not found [Plugin: com.intellij]
2020-06-03 16:17:01,493 [ 2100] WARN - nSystem.impl.ActionManagerImpl - keymap "NetBeans 6.5" not found [Plugin: com.intellij]
2020-06-03 16:17:01,494 [ 2101] WARN - nSystem.impl.ActionManagerImpl - keymap "Visual Studio" not found [Plugin: com.intellij]
2020-06-03 16:17:01,507 [ 2114] INFO - leBasedIndexDataInitialization - Initialization done: 434
2020-06-03 16:17:01,542 [ 2149] INFO - exImpl$StubIndexInitialization - Initialization done: 35
2020-06-03 16:17:01,722 [ 2329] INFO - rojectCodeStyleSettingsManager - Initialized from default code style settings.
2020-06-03 16:17:02,295 [ 2902] INFO - j.ide.script.IdeStartupScripts - 0 startup script(s) found
2020-06-03 16:17:02,572 [ 3179] INFO - llij.database.util.SqlDialects - SQL dialects initialized in 0 ms
2020-06-03 16:17:02,598 [ 3205] INFO - .diagnostic.PerformanceWatcher - Pushing properties took 66ms; general responsiveness: ok; EDT responsiveness: ok
2020-06-03 16:17:03,067 [ 3674] INFO - rationStore.ComponentStoreImpl - Registering unknown macros a.b.c in component DatabaseSettings
2020-06-03 16:17:03,077 [ 3684] INFO - penapi.application.Experiments - Experimental features enabled for user: wsl.p9.support, wsl.p9.show.roots.in.file.chooser, inline.browse.button, linux.native.menu, recent.and.edited.files.together, show.create.new.element.in.popup, copy.reference.popup, new.large.text.file.viewer
2020-06-03 16:17:03,196 [ 3803] INFO - ge.ExternalProjectsDataStorage - Load external projects data in 30 millis (read time: 25)
2020-06-03 16:17:03,339 [ 3946] INFO - .diagnostic.PerformanceWatcher - Post-startup activities under progress took 279ms; general responsiveness: ok; EDT responsiveness: ok
2020-06-03 16:17:03,559 [ 4166] WARN - openapi.wm.impl.ToolWindowImpl - ToolWindow icons should be 13x13. Please fix ToolWindow (ID: Problems View) or icon jar:file:/C:/Program%20Files/JetBrains/DataGrip%202019.3.3/lib/icons.jar!/general/warning.svg
2020-06-03 16:17:04,390 [ 4997] INFO - .diagnostic.PerformanceWatcher - Indexable file iteration took 1790ms; general responsiveness: ok; EDT responsiveness: ok
2020-06-03 16:17:04,638 [ 5245] INFO - tor.impl.FileEditorManagerImpl - Project opening took 3369 ms
2020-06-03 16:17:08,407 [ 9014] INFO - ution.rmi.RemoteProcessSupport - "C:\Program Files\JetBrains\DataGrip 2019.3.3\jbr\bin\java" -Ddomain.auth.library=/#BITNESS/sqljdbc_auth.dll -Djava.net.preferIPv4Stack=true -Djava.rmi.server.hostname=127.0.0.1 -Duser.timezone=UTC -Dfile.encoding=UTF-8 -classpath "C:\Program Files\JetBrains\DataGrip 2019.3.3\lib\util.jar;C:\Program Files\JetBrains\DataGrip 2019.3.3\lib\trove4j.jar;C:\Program Files\JetBrains\DataGrip 2019.3.3\lib\groovy-all-2.4.17.jar;C:\Program Files\JetBrains\DataGrip 2019.3.3\plugins\DatabaseTools\lib\jdbc-console.jar;C:\Users\somename\AppData\Roaming\JetBrains\DataGrip2020.1\jdbc-drivers\SQL Server\7.4.1\mssql-jdbc-7.4.1.jre8.jar;C:\Users\somename\AppData\Roaming\JetBrains\DataGrip2020.1\jdbc-drivers\SQL Server\7.4.1\sqlserver64-win-auth.jar" com.intellij.database.remote.RemoteJdbcServer com.microsoft.sqlserver.jdbc.SQLServerDriver
2020-06-03 16:17:08,749 [ 9356] WARN - ution.rmi.RemoteProcessSupport - WARNING: An illegal reflective access operation has occurred
2020-06-03 16:17:08,749 [ 9356] WARN - ution.rmi.RemoteProcessSupport - WARNING: Illegal reflective access by com.intellij.database.remote.RemoteJdbcServerBase (file:/C:/Program%20Files/JetBrains/DataGrip%202019.3.3/plugins/DatabaseTools/lib/jdbc-console.jar) to field java.lang.ClassLoader.sys_paths
2020-06-03 16:17:08,750 [ 9357] WARN - ution.rmi.RemoteProcessSupport - WARNING: Please consider reporting this to the maintainers of com.intellij.database.remote.RemoteJdbcServerBase
2020-06-03 16:17:08,750 [ 9357] WARN - ution.rmi.RemoteProcessSupport - WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
2020-06-03 16:17:08,751 [ 9358] WARN - ution.rmi.RemoteProcessSupport - WARNING: All illegal access operations will be denied in a future release
2020-06-03 16:17:08,751 [ 9358] WARN - ution.rmi.RemoteProcessSupport - Exception in thread "main"
2020-06-03 16:17:08,751 [ 9358] WARN - ution.rmi.RemoteProcessSupport - java.lang.ExceptionInInitializerError
2020-06-03 16:17:08,751 [ 9358] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.execution.rmi.RemoteServer.getLoopbackAddress(RemoteServer.java:161)
2020-06-03 16:17:08,751 [ 9358] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.execution.rmi.RemoteServer.access$000(RemoteServer.java:45)
2020-06-03 16:17:08,751 [ 9358] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.execution.rmi.RemoteServer$1.<init>(RemoteServer.java:118)
2020-06-03 16:17:08,751 [ 9358] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.execution.rmi.RemoteServer.setupRMI(RemoteServer.java:117)
2020-06-03 16:17:08,752 [ 9359] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.execution.rmi.RemoteServer.start(RemoteServer.java:58)
2020-06-03 16:17:08,752 [ 9359] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.database.remote.RemoteJdbcServerBase.start(RemoteJdbcServerBase.java:20)
2020-06-03 16:17:08,752 [ 9359] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.database.remote.RemoteJdbcServer.main(RemoteJdbcServer.java:14)
2020-06-03 16:17:08,752 [ 9359] WARN - ution.rmi.RemoteProcessSupport - Caused by: java.lang.NullPointerException
2020-06-03 16:17:08,752 [ 9359] WARN - ution.rmi.RemoteProcessSupport - at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2646)
2020-06-03 16:17:08,752 [ 9359] WARN - ution.rmi.RemoteProcessSupport - at java.base/java.lang.Runtime.loadLibrary0(Runtime.java:830)
2020-06-03 16:17:08,752 [ 9359] WARN - ution.rmi.RemoteProcessSupport - at java.base/java.lang.System.loadLibrary(System.java:1870)
2020-06-03 16:17:08,752 [ 9359] WARN - ution.rmi.RemoteProcessSupport - at java.base/java.net.InetAddress$1.run(InetAddress.java:323)
2020-06-03 16:17:08,752 [ 9359] WARN - ution.rmi.RemoteProcessSupport - at java.base/java.net.InetAddress$1.run(InetAddress.java:321)
2020-06-03 16:17:08,752 [ 9359] WARN - ution.rmi.RemoteProcessSupport - at java.base/java.security.AccessController.doPrivileged(Native Method)
2020-06-03 16:17:08,753 [ 9360] WARN - ution.rmi.RemoteProcessSupport - at java.base/java.net.InetAddress.<clinit>(InetAddress.java:320)
2020-06-03 16:17:08,753 [ 9360] WARN - ution.rmi.RemoteProcessSupport -
2020-06-03 16:17:08,753 [ 9360] WARN - ution.rmi.RemoteProcessSupport - ... 7 more
2020-06-03 16:17:08,783 [ 9390] INFO - ution.rmi.RemoteProcessSupport - Process finished with exit code 1
2020-06-03 16:17:10,454 [ 11061] INFO - j.ide.plugins.RepositoryHelper - Couldn't load plugins from : java.net.MalformedURLException: Malformed URL:
2020-06-03 16:17:10,493 [ 11100] WARN - ion.impl.NotificationCollector - Notification group 'System Messages' is already registered in whitelist
2020-06-03 16:17:36,308 [ 36915] INFO - ution.rmi.RemoteProcessSupport - "C:\Program Files\JetBrains\DataGrip 2019.3.3\jbr\bin\java" -Ddomain.auth.library=/#BITNESS/sqljdbc_auth.dll -Djava.net.preferIPv4Stack=true -Djava.rmi.server.hostname=127.0.0.1 -Duser.timezone=UTC -Dfile.encoding=UTF-8 -classpath "C:\Program Files\JetBrains\DataGrip 2019.3.3\lib\util.jar;C:\Program Files\JetBrains\DataGrip 2019.3.3\lib\trove4j.jar;C:\Program Files\JetBrains\DataGrip 2019.3.3\lib\groovy-all-2.4.17.jar;C:\Program Files\JetBrains\DataGrip 2019.3.3\plugins\DatabaseTools\lib\jdbc-console.jar;C:\Users\somename\AppData\Roaming\JetBrains\DataGrip2020.1\jdbc-drivers\SQL Server\7.4.1\mssql-jdbc-7.4.1.jre8.jar;C:\Users\somename\AppData\Roaming\JetBrains\DataGrip2020.1\jdbc-drivers\SQL Server\7.4.1\sqlserver64-win-auth.jar" com.intellij.database.remote.RemoteJdbcServer com.microsoft.sqlserver.jdbc.SQLServerDriver
2020-06-03 16:17:36,622 [ 37229] WARN - ution.rmi.RemoteProcessSupport - WARNING: An illegal reflective access operation has occurred
2020-06-03 16:17:36,622 [ 37229] WARN - ution.rmi.RemoteProcessSupport - WARNING: Illegal reflective access by com.intellij.database.remote.RemoteJdbcServerBase (file:/C:/Program%20Files/JetBrains/DataGrip%202019.3.3/plugins/DatabaseTools/lib/jdbc-console.jar) to field java.lang.ClassLoader.sys_paths
2020-06-03 16:17:36,622 [ 37229] WARN - ution.rmi.RemoteProcessSupport - WARNING: Please consider reporting this to the maintainers of com.intellij.database.remote.RemoteJdbcServerBase
2020-06-03 16:17:36,622 [ 37229] WARN - ution.rmi.RemoteProcessSupport - WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
2020-06-03 16:17:36,622 [ 37229] WARN - ution.rmi.RemoteProcessSupport - WARNING: All illegal access operations will be denied in a future release
2020-06-03 16:17:36,623 [ 37230] WARN - ution.rmi.RemoteProcessSupport - Exception in thread "main"
2020-06-03 16:17:36,623 [ 37230] WARN - ution.rmi.RemoteProcessSupport - java.lang.ExceptionInInitializerError
2020-06-03 16:17:36,623 [ 37230] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.execution.rmi.RemoteServer.getLoopbackAddress(RemoteServer.java:161)
2020-06-03 16:17:36,623 [ 37230] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.execution.rmi.RemoteServer.access$000(RemoteServer.java:45)
2020-06-03 16:17:36,623 [ 37230] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.execution.rmi.RemoteServer$1.<init>(RemoteServer.java:118)
2020-06-03 16:17:36,623 [ 37230] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.execution.rmi.RemoteServer.setupRMI(RemoteServer.java:117)
2020-06-03 16:17:36,623 [ 37230] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.execution.rmi.RemoteServer.start(RemoteServer.java:58)
2020-06-03 16:17:36,623 [ 37230] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.database.remote.RemoteJdbcServerBase.start(RemoteJdbcServerBase.java:20)
2020-06-03 16:17:36,623 [ 37230] WARN - ution.rmi.RemoteProcessSupport - at com.intellij.database.remote.RemoteJdbcServer.main(RemoteJdbcServer.java:14)
2020-06-03 16:17:36,623 [ 37230] WARN - ution.rmi.RemoteProcessSupport - Caused by: java.lang.NullPointerException
2020-06-03 16:17:36,623 [ 37230] WARN - ution.rmi.RemoteProcessSupport - at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2646)
2020-06-03 16:17:36,624 [ 37231] WARN - ution.rmi.RemoteProcessSupport - at java.base/java.lang.Runtime.loadLibrary0(Runtime.java:830)
2020-06-03 16:17:36,624 [ 37231] WARN - ution.rmi.RemoteProcessSupport - at java.base/java.lang.System.loadLibrary(System.java:1870)
2020-06-03 16:17:36,624 [ 37231] WARN - ution.rmi.RemoteProcessSupport - at java.base/java.net.InetAddress$1.run(InetAddress.java:323)
2020-06-03 16:17:36,624 [ 37231] WARN - ution.rmi.RemoteProcessSupport - at java.base/java.net.InetAddress$1.run(InetAddress.java:321)
2020-06-03 16:17:36,624 [ 37231] WARN - ution.rmi.RemoteProcessSupport - at java.base/java.security.AccessController.doPrivileged(Native Method)
2020-06-03 16:17:36,624 [ 37231] WARN - ution.rmi.RemoteProcessSupport - at java.base/java.net.InetAddress.<clinit>(InetAddress.java:320)
2020-06-03 16:17:36,624 [ 37231] WARN - ution.rmi.RemoteProcessSupport - ... 7 more
2020-06-03 16:17:36,661 [ 37268] INFO - ution.rmi.RemoteProcessSupport - Process finished with exit code 1
请先登录再写评论。
Thank you for feedback!
It's a known issue DBE-10912
We fixed it, but fix will be available in DataGrip 2020.1.5(approximately in a week). For workaround read about a workaround for SQL Server authentication issue.
I have the same problem!
Same issue here, has been happening for a while now, even with different versions of the MS SQL Driver.
@Vasily Thanks!
I've noticed the same after updating.
I previously followed the following to initially get connection working before the update.
1) download Microsoft JDBC Driver for SQL Server zipped driver from here https://go.microsoft.com/fwlink/?linkid=2122433
2) extract the driver mssql-jdbc_auth-8.2.2.x64.dll,
3) stick it in C:\Program Files\JetBrains\DataGrip 2020.1\jbr\bin
In the end reverting to 2020.1.3 is the only "fix" right now until 2020.1.5
The same in Rider 2020.1.3
The same in PHPStorm 2020.1.2
I have the same problem in PyCharm after upgrading to 2020.1.2 Professional Edition.
please fix it ASAP.
regards,
Vasja Jančič
Argh, damn it I thought this was something I'd messed up. Really could use a quick fix on this!
Yup, same issue with Goland, Rider, Pycharm, DataGrip here. Looking forward to the fix
as a workaround, I craeted a new SQL user (not AD authenticated) with the same permissions as the AD one. Until I get the fix in pycharm, I will be using the connection with this new SQL user, which works OK.
DataGrip 2020.2 EAP solves this if you are ok with running that.
Is there an ETA for 2020.2?
DataGrip 2020.1.5 with a fix was released at June 25 and my original issue was fixed. And this thread can be closed. If you have another issue, you can create a new thread as this one was fixed last week
Do I need a standalone DataGrip IDE for this? Is there a way to fix it in Idea 2020.1.2?
The fix is available in DataGrip 2020.1.5 and will be available in IU 2020.1.3
The issue still happens on Rider 2020.1.3. When it will be solved?
Thanks
Authentication via ActiveDirectoryPassword (see https://youtrack.jetbrains.com/issue/DBE-8312) is now available in DataGrip 2020.3 EAP 2 (https://blog.jetbrains.com/datagrip/2020/10/15/datagrip-2020-3-eap-2/)