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!
请先登录再写评论。
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.
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.