adding a oracle datasource is not working in Datagrip

Answered

After setting all info in the add datasource form (test connections was succesfull) I get this error after a couple of minutes:

Error encountered when performing Introspect the schema IMPULSE stuff completely: ORA-00604: Fout opgetreden bij recursief SQL-niveau 1.
ORA-01000: Maximum aantal open cursors is overschreden.
ORA-00604: Fout opgetreden bij recursief SQL-niveau 1.
ORA-01000: Maximum aantal open cursors is overschreden.
ORA-01000: Maximum aantal open cursors is overschreden.
.
ORA-00604: Fout opgetreden bij recursief SQL-niveau 1.
ORA-01000: Maximum aantal open cursors is overschreden.
ORA-00604: Fout opgetreden bij recursief SQL-niveau 1.
ORA-01000: Maximum aantal open cursors is overschreden.
ORA-01000: Maximum aantal open cursors is overschreden.
and 1 duplicate reports (2 m 23 s 441 ms)

Anyone fimiliar with this problem?

1 comment
Comment actions Permalink

Hello,

this means that DataGrip consumes too many cursors (the number of cursors is limited because every cursor consumes memory, potential locks, etc.).

It could be in one of two following cases: 

  1. DataGrip contains a bug (it forgets to close cursors sometimes)
  2. The server configured with too small number of cursors

We could check the first case if you'd attached the logs (including SQL logs).

As of the 2.pt, please ask the DBA to check how many cursors are possible on this database.

0

Please sign in to leave a comment.