Start a new topic

No longer seeing Schemas

[This topic is migrated from our old forums. The original author name has been removed]

When I expand the Schemas tree object I am no longer seeing child objects. If I double click I am presented with this error: *An error occurred while performing the operation:* You probably don't have the required privileges to view/manage this object. Edited by: ekaufman on May 15, 2014 4:42 PM

[This reply is migrated from our old forums.]

Re: No longer seeing Schemas
Hi, Which DbVisualizer version are you using and what database and driver? To further reveal what is going on, try enable debug of DbVisualizer in Tools->Debug Windows and then re-connect and perform the operation that fail. Post the debug output here. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: No longer seeing Schemas
V9.1.8, Oracle, Oracle Thin 11:51:17 [DEBUG AWT-EventQueue-0 P.getChildCount] getChildCount() for: XXXXXXXXX/Schemas in background 11:51:17 [DEBUG ExecutorRunner-pool-2-thread-12 K.?] elementName: 'DataNode' label: '${oracle.getSchemas.TABLE_SCHEM}' type: 'Schema' on-empty-output: 'stop' 11:51:17 [DEBUG ExecutorRunner-pool-2-thread-12 B.execute] Execute Command: oracle.getSchemas SQL: SELECT username AS TABLE_SCHEM FROM ${#cp.SystemTablePrefix}_users UNION SELECT 'PUBLIC' AS TABLE_SCHEM FROM dual ORDER BY TABLE_SCHEM 11:51:17 [DEBUG ExecutorRunner-pool-2-thread-12 J.execute] Executing... 11:51:17 [DEBUG ExecutorRunner-pool-2-thread-12 J.setCurrentCatalog] DbConnection='XXXXX' Catalog='null' Schema='null' NewCatalog='null' 11:51:17 [DEBUG pool-3-thread-11 C.?] RootConnection: T4CConnection.createStatement() 11:51:17 [DEBUG pool-3-thread-11 B.?] RootConnection: OracleStatementWrapper.execute("SELECT username AS TABLE_SCHEM FROM dba_users UNION SELECT 'PUBLIC' AS TABLE_SCHEM FROM dual ORDER BY TABLE_SCHEM") 11:51:17 [DEBUG pool-3-thread-11 B.?] RootConnection: EXCEPTION -> java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:299) at sun.reflect.GeneratedMethodAccessor61.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.g.B.B.?(Z:104) at com.onseven.dbvis.g.B.F$A.call(Z:1474) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 11:51:17 [DEBUG ExecutorRunner-pool-2-thread-12 AbstractFacade.getColumn] executing "select sys_context( 'userenv', 'current_schema' ) from dual" 11:51:17 [DEBUG pool-3-thread-11 C.?] RootConnection: T4CConnection.createStatement() 11:51:17 [DEBUG pool-3-thread-11 B.?] RootConnection: OracleStatementWrapper.executeQuery("select sys_context( 'userenv', 'current_schema' ) from dual") 11:51:17 [DEBUG ExecutorRunner-pool-2-thread-12 K.?] Execution of oracle.getSchemas resulted in error: com.onseven.dbvis.J.B.O: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at com.onseven.dbvis.J.B.J.execute(Z:2376) at com.onseven.dbvis.J.B.Y.?(Z:1386) at com.onseven.dbvis.J.B.Y.run(Z:337) at com.onseven.dbvis.J.B.B.?(Z:1145) at com.onseven.dbvis.J.B.B.execute(Z:1421) at com.onseven.dbvis.J.B.Y.?(Z:1386) at com.onseven.dbvis.J.B.Y.run(Z:337) at com.onseven.dbvis.m.A.K.?(Z:575) at com.onseven.dbvis.m.A.K.?(Z:76) at com.onseven.dbvis.m.A.K.execute(Z:258) at com.onseven.dbvis.J.B.Y.?(Z:1386) at com.onseven.dbvis.J.B.K.?(Z:1374) at com.onseven.dbvis.J.B.K.doInBackground(Z:1521) at javax.swing.SwingWorker$1.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at javax.swing.SwingWorker.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:299) at sun.reflect.GeneratedMethodAccessor61.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.g.B.B.?(Z:104) at com.onseven.dbvis.g.B.F$A.call(Z:1474) at java.util.concurrent.FutureTask.run(Unknown Source) ... 3 more 11:51:17 [DEBUG ExecutorRunner-pool-2-thread-12 K.?] Error may be the result if the driver don't support the JDBC call. Ignoring the error and continuing 11:51:19 [DEBUG ExecutorRunner-pool-2-thread-12 B.execute] Execute Command: oracle.getSchemas SQL: SELECT username AS TABLE_SCHEM FROM ${#cp.SystemTablePrefix}_users UNION SELECT 'PUBLIC' AS TABLE_SCHEM FROM dual ORDER BY TABLE_SCHEM 11:51:19 [DEBUG ExecutorRunner-pool-2-thread-12 J.execute] Executing... 11:51:19 [DEBUG ExecutorRunner-pool-2-thread-12 J.setCurrentCatalog] DbConnection='mn-ldvdbs03.rxhub.net/auddm.rxhub.net' Catalog='null' Schema='null' NewCatalog='null' 11:51:19 [DEBUG pool-3-thread-11 C.?] RootConnection: T4CConnection.createStatement() 11:51:19 [DEBUG pool-3-thread-11 B.?] RootConnection: OracleStatementWrapper.execute("SELECT username AS TABLE_SCHEM FROM dba_users UNION SELECT 'PUBLIC' AS TABLE_SCHEM FROM dual ORDER BY TABLE_SCHEM") 11:51:19 [DEBUG pool-3-thread-11 B.?] RootConnection: EXCEPTION -> java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:299) at sun.reflect.GeneratedMethodAccessor61.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.g.B.B.?(Z:104) at com.onseven.dbvis.g.B.F$A.call(Z:1474) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 11:51:19 [DEBUG ExecutorRunner-pool-2-thread-12 AbstractFacade.getColumn] executing "select sys_context( 'userenv', 'current_schema' ) from dual" 11:51:19 [DEBUG pool-3-thread-11 C.?] RootConnection: T4CConnection.createStatement() 11:51:19 [DEBUG pool-3-thread-11 B.?] RootConnection: OracleStatementWrapper.executeQuery("select sys_context( 'userenv', 'current_schema' ) from dual")
[This reply is migrated from our old forums.]

Re: No longer seeing Schemas
Hi, Thanks for the log. You need to open the Connection properties and choose the Objects Tree category. Select ALL_ for the System Views Prefix. Press Apply and re-connect. I hope this helps. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: No longer seeing Schemas
Hey Roger, This resolved the issue. Thanks! -Eric