Start a new topic

Error expanding views in Data Object Tree

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

I connect fine, can view tables in the Data Object Tree. But when trying to expand the Views, I get this error: DBVIS [SQL 0301] Input host variable *N or argument 2 not valid. I've tried google and searching this site but can't find anything. Any help appreciated, what the cause is, where to look, etc. Quick update, trying to double click the "view" icon in the Object tree I get the following error: An internal error occurred in: com.onseven.dbvis.sql.M: java.sql.SQLException: [SQL0301] Input host variable *N or argument 2 not valid. The error may have affected the application state. Please to vendor. Long Message: [SQL0301] Input host variable *N or argument 2 not valid. Details:    Type: com.onseven.dbvis.sql.M Stack Trace: com.onseven.dbvis.sql.M: java.sql.SQLException: [SQL0301] Input host variable *N or argument 2 not valid.    at com.onseven.dbvis.db.AbstractFacade.getTables(Z:456)    at com.onseven.dbvis.J.B.N.ā(Z:792)    at com.onseven.dbvis.J.B.N.execute(Z:315)    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:3320)    at com.onseven.dbvis.J.B.B.execute(Z:1626)    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.SQLException: [SQL0301] Input host variable *N or argument 2 not valid.    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:703)    at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getTables(AS400JDBCDatabaseMetaData.java:4758)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)    at java.lang.reflect.Method.invoke(Unknown Source)    at com.onseven.dbvis.g.B.E.ā(Z:3526)    at com.onseven.dbvis.g.B.F$A.call(Z:1474)    at java.util.concurrent.FutureTask.run(Unknown Source)    ... 3 more System Information: Product: DbVisualizer Pro 9.1.9 Build: #2154 (2014/06/16 16:42) Java VM: Java HotSpot(TM) Client VM Java Version: 1.7.0_51 Java Vendor: Oracle Corporation OS Name: Windows Server 2008 R2 OS Arch: x86 OS Version: 6.1 Edited by: Ric Roades on Jul 28, 2014 7:47 PM

[This reply is migrated from our old forums.]

Re: Error expanding views in Data Object Tree
Ric, What version of AS/400 are you using and what version of the JTOpen driver? The error is produced by the JDBC driver and an update of the driver may solve the issue. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

Re: Error expanding views in Data Object Tree
Thanks for the response... Couple things that may not matter. We used to have no problem connecting to AS/400. After some updates (at some point), going back to some old connections no longer worked. So something happened between the time we installed DBV and some upgrades. I also am now running the PRO version, and recently updated it. If this info is what I'm looking for to answer your question, this is what I've got. DB2 UDB 6.01.000 V6R 1m0 Driver name: AS/400 Toolbox for Java JDBC Driver Driver version: 9.4 Let me know if I need to look for more/different info.
[This reply is migrated from our old forums.]

Re: Error expanding views in Data Object Tree
Ric, Can you please enable debug mode for DbVisualizer in Tools->Debug Window (check Debug DbVisualizer only). Then re-connect and perform the failing operations. Post or email the debug output. Regards Roger support@dbvis.com
[This reply is migrated from our old forums. The original author name has been removed]

Re: Error expanding views in Data Object Tree
Roger - THANKS for the very quick responses. So very appreciated. Here is the log info from the window: ------------------------- Product Information ------------------------ Product: DbVisualizer Pro 9.1.9 Build: #2154 (2014/06/16 16:42) Java VM: Java HotSpot(TM) Client VM Java Version: 1.7.0_51 Java Vendor: Oracle Corporation OS Name: Windows Server 2008 R2 OS Arch: x86 OS Version: 6.1 ------------------------- Connected Databases ------------------------ Database Type: Generic Major Version: 6 Minor Version: 1 Profile: generic Connection Message: SSA 06.01.02.13324 JDBC-ODBC Bridge (sando.dll) 2.0001 (06.01.02.13117) Database Type: DB2 iSeries Major Version: 6 Minor Version: 1 Profile: generic Connection Message: DB2 UDB for AS/400 06.01.0000 V6R1m0 AS/400 Toolbox for Java JDBC Driver 9.4 --------------------------- Debug Printouts -------------------------- 09:06:19 [DEBUG ExecutorRunner-pool-3-thread-8 G.?] Disconnecting: 04B INEVA MS4 MM 09:06:19 [DEBUG pool-4-thread-9 C.?] RootConnection: AS400JDBCConnection.close() 09:06:19 [DEBUG ExecutorRunner-pool-3-thread-8 G.?] Connection closed: 04B INEVA MS4 MM 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 G.?] Connecting: 04B INEVA MS4 MM 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 L.?] Loading class using dynamic ClassLoader: com.ibm.as400.access.AS400JDBCDriver 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 L.?] Loading class using dynamic ClassLoader: com.ibm.as400.access.AS400JDBCDriver 09:06:31 [DEBUG pool-4-thread-9 D.?] RootConnection: AS400JDBCDriver.acceptsURL("jdbc:as400://10.155.132.36") 09:06:31 [DEBUG pool-4-thread-9 D.?] RootConnection: AS400JDBCDriver.connect("jdbc:as400://10.155.132.36", {user=*******, password=*********}) 09:06:31 [DEBUG pool-4-thread-9 C.?] RootConnection: AS400JDBCConnection.setAutoCommit(true) 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 G.?] Using facade: db2-iseries for 04B INEVA MS4 MM 09:06:31 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDatabaseProductName() 09:06:31 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDatabaseProductVersion() 09:06:31 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDriverName() 09:06:31 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDriverVersion() 09:06:31 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDriverName() 09:06:31 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDriverVersion() 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] Loading profile C:\Program Files (x86)\DbVisualizer/resources/profiles\generic.xml 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 P.?] Setting attribute: desc="Generic profile for any database" for: DatabaseProfile 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 P.?] Setting attribute: version="$Revision: 17469 $" for: DatabaseProfile 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 P.?] Setting attribute: date="$Date: 2014-04-01 19:45:47 +0200 (Tue, 01 Apr 2014) $" for: DatabaseProfile 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 P.?] Setting attribute: minver="9.1" for: DatabaseProfile 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] no match: If "#db.getDatabaseType().equals('firebird')" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] no match: If "#db.getDatabaseType().equals('firebird')" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: Else "null" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: If "! #db.getDatabaseType().equals('firebird')" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] no match: If "#db.getDatabaseType().equals('firebird')" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] no match: If "#db.getDatabaseType().equals('firebird')" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: Else "null" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] no match: If "#db.getDatabaseType().equals('informix')" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 A.?] Profile merging and post processing: 0.031 secs 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 L.?] Using profile: generic 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 B.execute] Execute Command: getCatalogs 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 N.?] DbConnection: 04B INEVA MS4 MM 09:06:31 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getCatalogs() 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 B.execute] Total rows/columns: 1/1. Rows after filtering: 1 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 B.execute] Execute Command: getSchemaNames 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 N.?] DbConnection: 04B INEVA MS4 MM 09:06:31 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getSchemas() 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 B.execute] Total rows/columns: 1282/2. Rows after filtering: 1282 09:06:31 [DEBUG ExecutorRunner-pool-3-thread-8 N.?] DbConnection: 04B INEVA MS4 MM 09:06:31 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getTypeInfo() 09:06:31 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDatabaseMajorVersion() 09:06:31 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDatabaseMinorVersion() 09:06:32 [DEBUG AWT-EventQueue-0 P.getChildCount] getChildCount() for: 04B INEVA MS4 MM in background 09:06:32 [DEBUG ExecutorRunner-pool-3-thread-8 K.?] elementName: 'DataNode' label: '${getCatalogs.TABLE_CAT}' type: 'Catalog' on-empty-output: 'continue' 09:06:32 [DEBUG ExecutorRunner-pool-3-thread-8 B.execute] Execute Command: getCatalogs 09:06:32 [DEBUG ExecutorRunner-pool-3-thread-8 N.?] DbConnection: 04B INEVA MS4 MM 09:06:32 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getCatalogs() 09:06:32 [DEBUG ExecutorRunner-pool-3-thread-8 B.execute] Total rows/columns: 1/1. Rows after filtering: 1 09:06:35 [DEBUG AWT-EventQueue-0 P.getChildCount] getChildCount() for: 04B INEVA MS4 MM/S1041829 in background 09:06:35 [DEBUG ExecutorRunner-pool-3-thread-8 K.?] elementName: 'DataNode' label: '${getSchemas.TABLE_SCHEM}' type: 'Schema' on-empty-output: 'continue' 09:06:35 [DEBUG ExecutorRunner-pool-3-thread-8 B.execute] Execute Command: getSchemas 09:06:35 [DEBUG ExecutorRunner-pool-3-thread-8 N.?] DbConnection: 04B INEVA MS4 MM 09:06:35 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getSchemas() 09:06:35 [DEBUG ExecutorRunner-pool-3-thread-8 B.execute] Total rows/columns: 1282/2. Rows after filtering: 1282 09:06:42 [DEBUG AWT-EventQueue-0 P.getChildCount] getChildCount() for: 04B INEVA MS4 MM/S1041829/AP#FILEA7 in background 09:06:42 [DEBUG ExecutorRunner-pool-3-thread-8 K.?] elementName: 'DataNode' label: '${getTableTypes.TABLE_TYPE}' type: 'Tables' on-empty-output: 'continue' 09:06:42 [DEBUG ExecutorRunner-pool-3-thread-8 B.execute] Execute Command: getTableTypes 09:06:42 [DEBUG ExecutorRunner-pool-3-thread-8 N.?] DbConnection: 04B INEVA MS4 MM 09:06:42 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getTableTypes() 09:06:42 [DEBUG ExecutorRunner-pool-3-thread-8 B.execute] Total rows/columns: 5/1. Rows after filtering: 5 09:06:42 [DEBUG ExecutorRunner-pool-3-thread-8 K.?] elementName: 'GroupNode' label: 'Procedures' type: 'Procedures' on-empty-output: 'stop' 09:06:45 [DEBUG AWT-EventQueue-0 P.getChildCount] getChildCount() for: 04B INEVA MS4 MM/S1041829/AP#FILEA7/VIEW in background 09:06:45 [DEBUG ExecutorRunner-pool-3-thread-8 K.?] elementName: 'DataNode' label: '${getTables.TABLE_NAME}' type: 'Table' on-empty-output: 'stop'' sort: 'getTables.TABLE_NAME' 09:06:45 [DEBUG ExecutorRunner-pool-3-thread-8 B.execute] Execute Command: getTables 09:06:45 [DEBUG ExecutorRunner-pool-3-thread-8 N.?] DbConnection='04B INEVA MS4 MM' Catalog='S1041829' Schema='AP#FILEA7' Table='%' Type(s)='VIEW' 09:06:45 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getTableTypes() 09:06:45 [DEBUG pool-4-thread-9 E.?] RootConnection: AS400JDBCDatabaseMetaData.getTables("S1041829", "AP#FILEA7", "%", ["VIEW"]) 09:06:45 [DEBUG pool-4-thread-9 E.?] RootConnection: EXCEPTION -> java.sql.SQLException: [SQL0301] Input host variable *N or argument 2 not valid. java.sql.SQLException: [SQL0301] Input host variable *N or argument 2 not valid. at com.ibm.as400.access.JDError.throwSQLException(JDError.java:703) at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getTables(AS400JDBCDatabaseMetaData.java:4758) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.g.B.E.?(Z:3526) 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)
[This reply is migrated from our old forums.]

Re: Error expanding views in Data Object Tree
Ric, Thanks for the log. The error is raised in the AS/400 driver but based on the input parameters when getting the tables the schema "AP#FILEA7" is used. I suspect the driver fail to handle the hashmark (#) properly and that it may be the reason it fail. There is the JTOpen JDBC driver for AS/400. I recommend you give it a try in case it handles this situation better. You find it at http://jt400.sourceforge.net Please let me know the progress. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Error expanding views in Data Object Tree
Not being a developer by trade, or server admin - I looked and could not find CLASSPATH as the install says. Since this is on a client's DEV server, I did not create that environment variable. I looked up how to install a jdbc driver in DBV, did that, restarted DBV, got a message that it had been processed/replaced and tried again. Got the same message. Just for grins... Here is the log ------------------------- Product Information ------------------------ Product: DbVisualizer Pro 9.1.9 Build: #2154 (2014/06/16 16:42) Java VM: Java HotSpot(TM) Client VM Java Version: 1.7.0_51 Java Vendor: Oracle Corporation OS Name: Windows Server 2008 R2 OS Arch: x86 OS Version: 6.1 ------------------------- Connected Databases ------------------------ Database Type: DB2 iSeries Major Version: 6 Minor Version: 1 Profile: generic Connection Message: DB2 UDB for AS/400 06.01.0000 V6R1m0 AS/400 Toolbox for Java JDBC Driver 10.2 --------------------------- Debug Printouts -------------------------- 10:24:29 [DEBUG ExecutorRunner-pool-3-thread-2 G.?] Disconnecting: 04B INEVA MS4 MM 10:24:29 [DEBUG pool-4-thread-3 C.?] RootConnection: AS400JDBCConnection.close() 10:24:29 [DEBUG ExecutorRunner-pool-3-thread-2 G.?] Connection closed: 04B INEVA MS4 MM 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 G.?] Connecting: 04B INEVA MS4 MM 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 L.?] Loading class using dynamic ClassLoader: com.ibm.as400.access.AS400JDBCDriver 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 L.?] Loading class using dynamic ClassLoader: com.ibm.as400.access.AS400JDBCDriver 10:24:32 [DEBUG pool-4-thread-3 D.?] RootConnection: AS400JDBCDriver.acceptsURL("jdbc:as400://10.155.132.36") 10:24:32 [DEBUG pool-4-thread-3 D.?] RootConnection: AS400JDBCDriver.connect("jdbc:as400://10.155.132.36", {user=*******, password=*********}) 10:24:32 [DEBUG pool-4-thread-3 C.?] RootConnection: AS400JDBCConnection.setAutoCommit(true) 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 G.?] Using facade: db2-iseries for 04B INEVA MS4 MM 10:24:32 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDatabaseProductName() 10:24:32 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDatabaseProductVersion() 10:24:32 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDriverName() 10:24:32 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDriverVersion() 10:24:32 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDriverName() 10:24:32 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDriverVersion() 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] Loading profile C:\Program Files (x86)\DbVisualizer/resources/profiles\generic.xml 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 P.?] Setting attribute: desc="Generic profile for any database" for: DatabaseProfile 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 P.?] Setting attribute: version="$Revision: 17469 $" for: DatabaseProfile 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 P.?] Setting attribute: date="$Date: 2014-04-01 19:45:47 +0200 (Tue, 01 Apr 2014) $" for: DatabaseProfile 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 P.?] Setting attribute: minver="9.1" for: DatabaseProfile 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] no match: If "#db.getDatabaseType().equals('firebird')" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] no match: If "#db.getDatabaseType().equals('firebird')" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: Else "null" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: If "! #db.getDatabaseType().equals('firebird')" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] no match: If "#db.getDatabaseType().equals('firebird')" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] no match: If "#db.getDatabaseType().equals('firebird')" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: Else "null" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] no match: If "#db.getDatabaseType().equals('informix')" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 E.?] match: If "#sp.getProperty('dbvis.license.type') in {'Personal', 'Pro'}" 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 A.?] Profile merging and post processing: 0.031 secs 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 L.?] Using profile: generic 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 B.execute] Execute Command: getCatalogs 10:24:32 [DEBUG ExecutorRunner-pool-3-thread-2 N.?] DbConnection: 04B INEVA MS4 MM 10:24:32 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getCatalogs() 10:24:33 [DEBUG ExecutorRunner-pool-3-thread-2 B.execute] Total rows/columns: 1/1. Rows after filtering: 1 10:24:33 [DEBUG ExecutorRunner-pool-3-thread-2 B.execute] Execute Command: getSchemaNames 10:24:33 [DEBUG ExecutorRunner-pool-3-thread-2 N.?] DbConnection: 04B INEVA MS4 MM 10:24:33 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getSchemas() 10:24:33 [DEBUG ExecutorRunner-pool-3-thread-2 B.execute] Total rows/columns: 1282/2. Rows after filtering: 1282 10:24:33 [DEBUG ExecutorRunner-pool-3-thread-2 N.?] DbConnection: 04B INEVA MS4 MM 10:24:33 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getTypeInfo() 10:24:33 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDatabaseMajorVersion() 10:24:33 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getDatabaseMinorVersion() 10:24:33 [DEBUG AWT-EventQueue-0 P.getChildCount] getChildCount() for: 04B INEVA MS4 MM in background 10:24:33 [DEBUG ExecutorRunner-pool-3-thread-2 K.?] elementName: 'DataNode' label: '${getCatalogs.TABLE_CAT}' type: 'Catalog' on-empty-output: 'continue' 10:24:33 [DEBUG ExecutorRunner-pool-3-thread-2 B.execute] Execute Command: getCatalogs 10:24:33 [DEBUG ExecutorRunner-pool-3-thread-2 N.?] DbConnection: 04B INEVA MS4 MM 10:24:33 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getCatalogs() 10:24:33 [DEBUG ExecutorRunner-pool-3-thread-2 B.execute] Total rows/columns: 1/1. Rows after filtering: 1 10:24:34 [DEBUG AWT-EventQueue-0 P.getChildCount] getChildCount() for: 04B INEVA MS4 MM/S1041829 in background 10:24:34 [DEBUG ExecutorRunner-pool-3-thread-2 K.?] elementName: 'DataNode' label: '${getSchemas.TABLE_SCHEM}' type: 'Schema' on-empty-output: 'continue' 10:24:34 [DEBUG ExecutorRunner-pool-3-thread-2 B.execute] Execute Command: getSchemas 10:24:34 [DEBUG ExecutorRunner-pool-3-thread-2 N.?] DbConnection: 04B INEVA MS4 MM 10:24:34 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getSchemas() 10:24:34 [DEBUG ExecutorRunner-pool-3-thread-2 B.execute] Total rows/columns: 1282/2. Rows after filtering: 1282 10:24:42 [DEBUG AWT-EventQueue-0 P.getChildCount] getChildCount() for: 04B INEVA MS4 MM/S1041829/AP#FILEA7 in background 10:24:42 [DEBUG ExecutorRunner-pool-3-thread-2 K.?] elementName: 'DataNode' label: '${getTableTypes.TABLE_TYPE}' type: 'Tables' on-empty-output: 'continue' 10:24:42 [DEBUG ExecutorRunner-pool-3-thread-2 B.execute] Execute Command: getTableTypes 10:24:42 [DEBUG ExecutorRunner-pool-3-thread-2 N.?] DbConnection: 04B INEVA MS4 MM 10:24:42 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getTableTypes() 10:24:42 [DEBUG ExecutorRunner-pool-3-thread-2 B.execute] Total rows/columns: 5/1. Rows after filtering: 5 10:24:42 [DEBUG ExecutorRunner-pool-3-thread-2 K.?] elementName: 'GroupNode' label: 'Procedures' type: 'Procedures' on-empty-output: 'stop' 10:24:48 [DEBUG AWT-EventQueue-0 P.getChildCount] getChildCount() for: 04B INEVA MS4 MM/S1041829/AP#FILEA7/TABLE in background 10:24:48 [DEBUG ExecutorRunner-pool-3-thread-2 K.?] elementName: 'DataNode' label: '${getTables.TABLE_NAME}' type: 'Table' on-empty-output: 'stop'' sort: 'getTables.TABLE_NAME' 10:24:48 [DEBUG ExecutorRunner-pool-3-thread-2 B.execute] Execute Command: getTables 10:24:48 [DEBUG ExecutorRunner-pool-3-thread-2 N.?] DbConnection='04B INEVA MS4 MM' Catalog='S1041829' Schema='AP#FILEA7' Table='%' Type(s)='TABLE' 10:24:48 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getTableTypes() 10:24:48 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getTables("S1041829", "AP#FILEA7", "%", ["TABLE"]) 10:24:48 [DEBUG ExecutorRunner-pool-3-thread-2 B.execute] Total rows/columns: 133/10. Rows after filtering: 133 10:24:53 [DEBUG AWT-EventQueue-0 P.getChildCount] getChildCount() for: 04B INEVA MS4 MM/S1041829/AP#FILEA7/VIEW in background 10:24:53 [DEBUG ExecutorRunner-pool-3-thread-2 K.?] elementName: 'DataNode' label: '${getTables.TABLE_NAME}' type: 'Table' on-empty-output: 'stop'' sort: 'getTables.TABLE_NAME' 10:24:53 [DEBUG ExecutorRunner-pool-3-thread-2 B.execute] Execute Command: getTables 10:24:53 [DEBUG ExecutorRunner-pool-3-thread-2 N.?] DbConnection='04B INEVA MS4 MM' Catalog='S1041829' Schema='AP#FILEA7' Table='%' Type(s)='VIEW' 10:24:53 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getTableTypes() 10:24:53 [DEBUG pool-4-thread-3 E.?] RootConnection: AS400JDBCDatabaseMetaData.getTables("S1041829", "AP#FILEA7", "%", ["VIEW"]) 10:24:53 [DEBUG pool-4-thread-3 E.?] RootConnection: EXCEPTION -> java.sql.SQLException: [SQL0301] Input host variable *N or argument 2 not valid. java.sql.SQLException: [SQL0301] Input host variable *N or argument 2 not valid. at com.ibm.as400.access.JDError.throwSQLException(JDError.java:705) at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getTables(AS400JDBCDatabaseMetaData.java:4883) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.onseven.dbvis.g.B.E.?(Z:3526) 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)
[This reply is migrated from our old forums.]

Re: Error expanding views in Data Object Tree
Ric, In Tools->Driver Manager select DB2 for AS/400 (JTOpen). What file is loaded in the User Specified tab? If no file is loaded, load the jtopen jar file and then make sure you use select the DB2 for AS/400 (JTOpen) driver in the Connection tab for the actual AS/400 connection. Do you get the issue accessing a schema not containing "#"? Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

Re: Error expanding views in Data Object Tree
I do get the error when expanding views from a schema with NO special characters. Tried one with @, and one called A3EP, both get the error. I copied the jt400.jar into the DBV directory as below:
[This reply is migrated from our old forums.]

Re: Error expanding views in Data Object Tree
Thanks Ric. May there have been some updates on the server side that can explain the issues? Some flavors of DB2 require binds on the server whenever a new version is installed. May that be the problem? There has been no updates in DbVisualizer lately that should affect generic JDBC connections such as for DB2 AS/400. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Error expanding views in Data Object Tree
I don't know, but doubt it. Will try to find out. It's an old server that all the data is being archived, which is the project I'm on. Since there are no updates to the apps on it, I think its unlikely they would be updating OS, etc. on it. But will try to find out. But another aspect of this, as I was looking around at it... I used to be able to connect to an ODBC/JDBC source on the server from which I'm running DBV. These are both problems that did not exist. Could it be something in the DBV installation? It seems when connecting to that we get the a media error, link severed. I didn't see anything really in the DBV log, so included the JDBC Driver log: ------------------------- Product Information ------------------------ Product: DbVisualizer Pro 9.1.9 Build: #2154 (2014/06/16 16:42) Java VM: Java HotSpot(TM) Client VM Java Version: 1.7.0_51 Java Vendor: Oracle Corporation OS Name: Windows Server 2008 R2 OS Arch: x86 OS Version: 6.1 ------------------------- Connected Databases ------------------------ Database Type: Generic Major Version: 6 Minor Version: 1 Profile: generic Connection Message: SSA 06.01.02.13324 JDBC-ODBC Bridge (sando.dll) 2.0001 (06.01.02.13117) --------------------------- Debug Printouts -------------------------- *DatabaseMetaData.getSchemas *DatabaseMetaData.getTables (,%,,null) Allocating Statement Handle (SQLAllocStmt), hDbc=6223856 hStmt=6224592 Tables (SQLTables), hStmt=6224592,catalog=, schema=%, table=, types=null Number of result columns (SQLNumResultCols), hStmt=6224592 value=5 *ResultSet.getMetaData *ResultSetMetaData.getColumnName (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=1 value (String)=TABLE_SCHEM *ResultSetMetaData.getColumnLabel (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=18 value (String)=TABLE_SCHEM *ResultSetMetaData.getTableName (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=15 value (String)= *ResultSetMetaData.getColumnTypeName (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=14 value (String)=VARCHAR *ResultSetMetaData.getColumnDisplaySize (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=6 value (int)=128 *ResultSetMetaData.isNullable (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=7 value (int)=0 *ResultSetMetaData.getColumnType (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=1, type=2 value (int)=12 *ResultSetMetaData.isAutoIncrement (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=11 value (int)=0 *ResultSetMetaData.getPrecision (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=4 value (int)=128 *ResultSetMetaData.getScale (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=1, type=5 value (int)=0 Fetching (SQLFetch), hStmt=6224592 Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=2 value (int)=12 Column attributes (SQLColAttributes), hStmt=6224592, icol=2, type=3 value (int)=128 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 AP#FILEM7 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_CALENDAR_2003 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_CALENDAR_2004 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_CALENDAR_2005 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_CALENDAR_2006 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_CALENDAR_2007 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_CALENDAR_2008 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_CAL_ARCHIVE Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_FISCAL_2004 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_FISCAL_2005 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_FISCAL_2006 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_FISCAL_2007 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 API_HRN_FISCAL_ARCHIVE Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST1997 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST1998 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST1999 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST2000 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST2001 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST2002 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BEST2003 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 BESTSYS1 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 CADBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 CLOCFL00M7 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 DBA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 DBO Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 EHSWTK Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 EXDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 FADBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 FADV333 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 FY10_SETON_FIXED_ASSET Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 FY11_SETON_FIXED_ASSET Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 FY12_SETON_FIXED_ASSET Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 FY13_SETON_FIXED_ASSET Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 GLCUST Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 GLDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 GTDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRCUST Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRCV707 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRCV888 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRCV999 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRDV707 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRDV888 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 HRDV999 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 ICDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 ILM Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 IRDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 JPDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 MA#FILEM7 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 NEW_SETON_2003 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 NEW_SETON_2004 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 NEW_SETON_2005 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 NEW_SETON_FY08 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PFM Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PFM_ARCHIVE Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PLDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PMDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PMM Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PMM_ARCHIVE Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PUBLIC Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 PX2000 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 SAGE_FAS1 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 SDS_REPOSITORY Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 SETNPROD Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 SETON_FY09 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 SSA_SERVICE Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 SSDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 SYSTEM Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TE70MHR Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TE712HR Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TIMECUSTM7 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TIMEGLOBM7 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TIMEKEEPM7 Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TKCSOWNER Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TRDBFA Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 TXAUS Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 VILM Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=2, maxLen=129 WFCDB Fetching (SQLFetch), hStmt=6224592 End of result set (SQL_NO_DATA) *ResultSet.close Free statement (SQLFreeStmt), hStmt=6224592, fOption=1 *ResultSet has been closed *DatabaseMetaData.getTableTypes *DatabaseMetaData.getTables (null,null,%,null) Allocating Statement Handle (SQLAllocStmt), hDbc=6223856 hStmt=6224592 Tables (SQLTables), hStmt=6224592,catalog=null, schema=null, table=%, types=null Number of result columns (SQLNumResultCols), hStmt=6224592 value=5 *ResultSet.getMetaData *ResultSetMetaData.getColumnName (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=1 value (String)=TABLE_TYPE *ResultSetMetaData.getColumnLabel (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=18 value (String)=TABLE_TYPE *ResultSetMetaData.getTableName (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=15 value (String)= *ResultSetMetaData.getColumnTypeName (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=14 value (String)=VARCHAR *ResultSetMetaData.getColumnDisplaySize (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=6 value (int)=256 *ResultSetMetaData.isNullable (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=7 value (int)=0 *ResultSetMetaData.getColumnType (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=1, type=2 value (int)=12 *ResultSetMetaData.isAutoIncrement (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=11 value (int)=0 *ResultSetMetaData.getPrecision (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=4 value (int)=256 *ResultSetMetaData.getScale (1) Column attributes (SQLColAttributes), hStmt=6224592, icol=1, type=5 value (int)=0 Fetching (SQLFetch), hStmt=6224592 Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=2 value (int)=12 Column attributes (SQLColAttributes), hStmt=6224592, icol=4, type=3 value (int)=256 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 Get string data (SQLGetData), hStmt=6224592, column=4, maxLen=257 UNKNOWN Fetching (SQLFetch), hStmt=6224592 RETCODE = -1 ERROR - Generating SQLException... SQLState(08S01) vendor code(531457) java.sql.SQLException: [ODBC][Nucleus ODBC Driver][TXAUS Kronos FAS]Communication media error. Link severed at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLFetch(Unknown Source) at sun.jdbc.odbc.JdbcOdbcResultSet.next(Unknown Source) at com.onseven.dbvis.J.B.U.?(Z:3187) at com.onseven.dbvis.J.B.U.?(Z:2910) at com.onseven.dbvis.J.B.Y.processResultSet(Z:2773) at com.onseven.dbvis.J.B.Y.processResultSet(Z:1331) at com.onseven.dbvis.J.B.N.?(Z:848) at com.onseven.dbvis.J.B.N.execute(Z:726) 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:3320) at com.onseven.dbvis.J.B.B.execute(Z:1626) 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:1170) 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) *ResultSet.close Free statement (SQLFreeStmt), hStmt=6224592, fOption=1 *ResultSet has been closed
[This reply is migrated from our old forums. The original author name has been removed]

Re: Error expanding views in Data Object Tree
According to my contact at the client, there have been no upgrades on the AS/400. I'm open to any other suggestions.
[This reply is migrated from our old forums.]

Re: Error expanding views in Data Object Tree
Ric, You said in one of your earlier posts that after some upgrades the problem occurred.Assuming you mean DbVisualizer upgrades, do you remember which DbVisualizer version it used to work with? It would be great if you can give an older version a test. If you don't already have the old working version installed, check the following page: http://www.dbvis.com/download/old-versions/ Does the problem occur for all your AS/400 connections or just some? Has the driver properties been changed for the failing connections (driver properties are edited in the Properties tab for the connection)? Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Error expanding views in Data Object Tree
Thanks again, Roger. Correct, upgrades to DBV. I don't know exactly when it stopped, as it worked on an AS/400 project phase, we moved on, then came back to that some months later, and I know the personal version of DBV was upgraded over time, then I purchased it. So don't know what version last worked. But yes, it appears it's all of our AS/400 connections, Oracle seems ok, so far, but I also used to use it with a proprietary ODBC/JDBC driver for a db local to the server DBV runs on. That quit working, as well. So I will try an older version - what about the purchased license? Will it matter?
[This reply is migrated from our old forums.]

Re: Error expanding views in Data Object Tree
Hi Ric, Thanks for the details. Generally speaking we don't recommend using the JDBC/ODBC driver if there is a pure Java driver available. Various issues has been reported with the JDBC/ODBC bridge driver over the years. Please give an old version of DbVisualizer a test. You find the release dates in the download page so that you can match with one that were available at the time of your last successful use. DbVisualizer Free or Pro doesn't matter as the database interaction is the same in both for DB2 AS/400. Regards Roger