Definition loading failed: ORA-31603

Hello guys,

When entering into a Text tab on a table view, I'm receiving following error:

-- Definition loading failed:
-- java.sql.SQLException: W: object "..." of type TABLE not found in schema "..."
-- ORA-06512: at "SYS.DBMS_METADATA", line 5088
-- ORA-06512: at "SYS.DBMS_METADATA", line 7589
-- ORA-06512: at line 1
--
--     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
--     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
--     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
--     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
--     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
--     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
--     at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
--     at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
--     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1199)
--     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
--     at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)
--     at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
--     at com.intellij.database.remote.jdbc.impl.RemoteStatementImpl.executeQuery(RemoteStatementImpl.java:141)
--     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
--     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
--     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
--     at java.lang.reflect.Method.invoke(Method.java:606)
--     at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:322)
--     at sun.rmi.transport.Transport$1.run(Transport.java:177)
--     at sun.rmi.transport.Transport$1.run(Transport.java:174)
--     at java.security.AccessController.doPrivileged(Native Method)
--     at sun.rmi.transport.Transport.serviceCall(Transport.java:173)
--     at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:556)
--     at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:811)
--     at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:670)
--     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
--     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
--     at java.lang.Thread.run(Thread.java:724)
--     at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:275)
--     at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:252)
--     at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:161)
--     at java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:194)
--     at java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:148)
--     at com.sun.proxy.$Proxy100.executeQuery(Unknown Source)
--     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
--     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
--     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
--     at java.lang.reflect.Method.invoke(Method.java:606)
--     at com.intellij.execution.rmi.RemoteUtil.invokeRemote(RemoteUtil.java:124)
--     at com.intellij.execution.rmi.RemoteUtil.access$100(RemoteUtil.java:36)
--     at com.intellij.execution.rmi.RemoteUtil$RemoteInvocationHandler.invoke(RemoteUtil.java:227)
--     at com.sun.proxy.$Proxy101.executeQuery(Unknown Source)
--     at com.intellij.database.util.DbImplUtil.concatStringResults(DbImplUtil.java:455)
--     at com.intellij.database.util.DbImplUtil.concatStringResults(DbImplUtil.java:450)
--     at com.intellij.database.util.DbImplUtil.concatStringResults(DbImplUtil.java:442)
--     at com.intellij.database.dialects.OracleDialect.tryToLoadTableDefinition(OracleDialect.java:114)
--     at com.intellij.database.util.DbImplUtil.tryLoadTableDefinition(DbImplUtil.java:401)
--     at com.intellij.database.editor.DatabaseEditorHelper.a(DatabaseEditorHelper.java:218)
--     at com.intellij.database.editor.DatabaseEditorHelper.loadDefinition(DatabaseEditorHelper.java:201)
--     at com.intellij.database.editor.DatabaseEditorHelper.loadDefinition(DatabaseEditorHelper.java:191)
--     at com.intellij.database.editor.DatabaseEditorHelper$3.run(DatabaseEditorHelper.java:246)
--     at com.intellij.openapi.application.impl.ApplicationImpl$9.run(ApplicationImpl.java:446)
--     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
--     at java.util.concurrent.FutureTask.run(FutureTask.java:262)
--     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
--     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
--     at java.lang.Thread.run(Thread.java:724)
--     at com.intellij.openapi.application.impl.ApplicationImpl$1$1.run(ApplicationImpl.java:149)


I'm using:
- 0xDBE DB-138.1400.3
- Oracle driver: ojdbc6-11.2.0.3

I'm also receiving a message "unable to resolve column" in IDE across all fields and all tables.

Any idea what might be wrong?

Thanks!

2 comments
Comment actions Permalink

This is old but in case anyone else comes across it the user you are using needs to have the 'select_catalog_role' role assigned to them.

0
Comment actions Permalink

Hi,


Could you reproduce the problem in DataGrip 2017.1 EAP or in DataGrip 2016.3.4?
Could you provide any sources to reproduce the problem?

Thank you.

0

Please sign in to leave a comment.