Datagrip throws error about MaterializedView which is a Table
Datagrip 2026.1. (and many former versions) with OracleDB using 23.5.0.24.07 JDBC4.3
We have two nearly identical users WWWADM and WWWTEST.
With WWWADM all looks fine and works. Ok, performance sometimes is worst, but…
With WWWTEST Datagrip throws this error:
Unexpected error (ResultIsNull) encountered when performing Retrieve materialized view sources via XML for 1 views (KVTOP3_MENU): Result is null when retrieving materialized view sources pack 0 of 1, the pack size is 1.
Result is null when retrieving materialized view sources pack 0 of 1, the pack size is 1
But KVTOP3_MENU is a table and not a MaterializedView!
If I look into the tree “tables” of this user, it's damaged, because tables, views, sequences and materialized views are displayed together, mixed together, while in “views” or “sequences” I see tables…
请先登录再写评论。
Hi Johannes Schulz,
As we've discussed in the separate support ticket, running Diagnostics | Force Refresh helped retrieve the metadata from scratch and display the objects correctly.
However, if the issue occurs again, please share the following logs with us so that we can investigate the root cause and work on a permanent fix: