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
Please sign in to leave a comment.
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.
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.
Please post content of idea.log file after restart and clicking the Synchronize action. Also attach screenshot with your connection settings. Thanks.
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
Hello Okan,
See More Schemas... action in the Database tool window. Do you see a popup with schemas/databases list when selecting it?
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.
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.
Nothing has changed. Thanks for patience and helps.
I can write scripts without intellisense.
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?
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
Well blimey, that did it.
Seems like a bug...
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..
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
Having same issue with Phpstorm and Postgresql.
But I'm getting baloon with text "com/intellij/database/model/impl/PostgresImplModel" also
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.
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.
It appears that you have to add any sub-schemas in the 'Data Sources and Drivers' window. To access this screen follow these steps:
The same issue here with Oracle data source.
Here's the DDL I see on one of the views:
On the other hand, TOAD generatest script for the very same view successfully.
Tried Synchronizing numerous times, played with other options - no luck.
We also have the same issue with Oracle and PHPSTORM 2016.3.
Impossible to have auto completion working.
Is there a fix?
For me this helped:
Data source and Drivers -> <Chose connection> -> Options -> check "Introspect using JDBC metadata"
For me, it is still failing to show the tables. The approaches mentioned above did not help.
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.
@All
Could you send full IDE logs to me Vasily.Chernov@jetbrains.com for further investigation?
"uninstall" and "reinstall" seems to resolve the issue.
@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.
@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.
@Kuang Lee
Follow https://intellij-support.jetbrains.com/hc/en-us/articles/207241085-Locating-IDE-log-files
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.
@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.
In case anyone is having this issue now. This solved it for me