2021-08-03 10:29:43 INFO =================== Log started =================== 2021-08-03 10:29:43 INFO Using configdir: C:\AdApta\SQL-Workbench\.\Config 2021-08-03 10:29:43 INFO Setting default locale to: en 2021-08-03 10:29:43 INFO Starting SQL Workbench/J, Build 127.5 (2021-05-15 15:42) 2021-08-03 10:29:43 INFO Java version=14.0.2, java.home=C:\AdApta\SQL-Workbench\jre11, vendor=AdoptOpenJDK, name=OpenJDK 64-Bit Server VM 2021-08-03 10:29:43 INFO Operating System=Windows 10, version=10.0, platform=amd64 2021-08-03 10:29:43 INFO Available memory: 1024MB 2021-08-03 10:29:43 INFO Classpath: sqlworkbench.jar;.\ext\commons-codec.jar;.\ext\commons-collections4.jar;.\ext\commons-compress.jar;.\ext\commons-math3.jar;.\ext\flatlaf.jar;.\ext\jna-platform.jar;.\ext\jna.jar;.\ext\odfdom-java.jar;.\ext\poi-ooxml-schemas.jar;.\ext\poi-ooxml.jar;.\ext\poi.jar;.\ext\resolver.jar;.\ext\serializer.jar;.\ext\simple-odf.jar;.\ext\SparseBitSet.jar;.\ext\xercesImpl.jar;.\ext\xml-apis.jar;.\ext\xmlbeans.jar 2021-08-03 10:29:43 INFO Found 0 commands in 0ms 2021-08-03 10:29:43 INFO Loaded look and feel: WindowsLookAndFeel 2021-08-03 10:29:43 INFO Current DPI: 96, Default DPI: 96 2021-08-03 10:29:44 INFO Using sizes: toolbar: 16, menu: 16 2021-08-03 10:29:44 INFO POI version: 4.1.2 available 2021-08-03 10:29:45 INFO Checking for ext libs took: 0ms 2021-08-03 10:29:45 INFO Using libdir: C:\AdApta\SQL-Workbench\Driver 2021-08-03 10:29:45 INFO Changed invalid sample URL in driver "Oracle/XML" from: jdbc:oracle:thin://@hostname:port/service_name to: jdbc:oracle:thin:@//hostname:port/service_name 2021-08-03 10:29:45 INFO Loaded 23 connection profiles from C:\AdApta\SQL-Workbench\Config\WbProfiles.xml 2021-08-03 10:29:45 INFO 23 profiles loaded in 46ms from 1 files 2021-08-03 10:29:48 INFO Creating new connection for "{_S2}/Abano-Serrmacint": [user=informix, url=jdbc:informix-sqli://localhost:3011/serrmacint:INFORMIXSERVER=abano_ol11;DBDATE=DMY4/, driverClass=com.informix.jdbc.IfxDriver, driverName=Informix] 2021-08-03 10:29:48 INFO Adding ClassLoader URL=file:/C:/AdApta/SQL-Workbench/Driver/ifxjdbc.jar 2021-08-03 10:29:48 INFO Adding ClassLoader URL=file:/C:/AdApta/SQL-Workbench/Driver/bson-3.8.0.jar 2021-08-03 10:29:48 INFO WbWin-1 TAB-12: Using DBID=informix_dynamic_server 2021-08-03 10:29:48 INFO WbWin-1 TAB-12: Using identifier quote character: " 2021-08-03 10:29:48 INFO WbWin-1 TAB-12: Using search string escape character: \ 2021-08-03 10:29:48 INFO WbWin-1 TAB-12: Table types returned by the JDBC driver: [SYSTEM TABLE, TABLE, VIEW] 2021-08-03 10:29:48 INFO WbWin-1 TAB-12: Using catalog separator: : 2021-08-03 10:29:48 INFO Connected to: [Informix Dynamic Server], Database version info: [11.50.FC6], Database version number: [11.50], Driver version: [4.50.JC2], JDBC version: [4.2], ID: [WbWin-1 TAB-12] 2021-08-03 10:29:57 ERROR Error retrieving table source using: agregist A syntax error has occurred. [SQL State=42000, DB Errorcode=-201] java.sql.SQLSyntaxErrorException: A syntax error has occurred. at com.informix.util.IfxErrMsg.buildExceptionWithMessage(IfxErrMsg.java:408) at com.informix.util.IfxErrMsg.buildIsamException(IfxErrMsg.java:401) at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3096) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3368) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2292) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2217) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1461) at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:183) at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:968) at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:165) at workbench.db.TableSourceBuilder.getNativeTableSource(TableSourceBuilder.java:788) at workbench.db.TableSourceBuilder.getCreateTable(TableSourceBuilder.java:342) at workbench.db.TableSourceBuilder.getCreateTable(TableSourceBuilder.java:335) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:213) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:208) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:160) at workbench.sql.wbcommands.WbTableSource.execute(WbTableSource.java:90) at workbench.sql.StatementRunner.runStatement(StatementRunner.java:592) at workbench.gui.sql.SqlPanel.displayResult(SqlPanel.java:3501) at workbench.gui.sql.SqlPanel.runStatement(SqlPanel.java:2225) at workbench.gui.sql.SqlPanel$16.run(SqlPanel.java:2163) 2021-08-03 10:29:57 ERROR Error when retrieving table privileges No such column name [SQL State=IX000, DB Errorcode=-79738] java.sql.SQLException: No such column name at com.informix.util.IfxErrMsg.buildExceptionWithMessage(IfxErrMsg.java:416) at com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:397) at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:379) at com.informix.jdbc.IfxScrollableResultSet.findColumn(IfxScrollableResultSet.java:188) at com.informix.jdbc.IfxScrollableResultSet.getString(IfxScrollableResultSet.java:575) at workbench.db.TableGrantReader.getTableGrants(TableGrantReader.java:102) at workbench.db.TableGrantReader.getTableGrantSource(TableGrantReader.java:129) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:255) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:208) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:160) at workbench.sql.wbcommands.WbTableSource.execute(WbTableSource.java:90) at workbench.sql.StatementRunner.runStatement(StatementRunner.java:592) at workbench.gui.sql.SqlPanel.displayResult(SqlPanel.java:3501) at workbench.gui.sql.SqlPanel.runStatement(SqlPanel.java:2225) at workbench.gui.sql.SqlPanel$16.run(SqlPanel.java:2163) 2021-08-03 10:30:21 DEBUG DbMetadata.getObjects() WbWin-1 TAB-12: Calling getTables() using: catalog=serrmacint, schema=informix, name=agregist, types=[SYSTEM TABLE, TABLE] 2021-08-03 10:30:21 DEBUG DbMetadata.getObjects() WbWin-1 TAB-12: Retrieving table list took: 0ms 2021-08-03 10:30:21 DEBUG SqlUtil.dumpResultSetInfo() DatabaseMetaData.getTables() returned: 1: [table_cat], 2: [table_schem], 3: [table_name], 4: [table_type], 5: [remarks], 6: [type_cat], 7: [type_schem], 8: [type_name], 9: [self_referencing_col_name], 10: [ref_generation] 2021-08-03 10:30:21 DEBUG DbMetadata.getObjects() WbWin-1 TAB-12: Processing 1 tables took: 0ms 2021-08-03 10:30:21 DEBUG JdbcIndexReader.getPrimaryKey() PK Information for agregist, PK Name=null, PK Index=null, columns=[] (16ms) 2021-08-03 10:30:21 DEBUG JdbcTableDefinitionReader.getTableColumns() Calling getColumns() using: catalog=serrmacint, schema=informix, table=agregist 2021-08-03 10:30:21 DEBUG JdbcTableDefinitionReader.getTableColumns() Calling getColumns() took: 62ms 2021-08-03 10:30:21 DEBUG SqlUtil.dumpResultSetInfo() JdbcTableDefinitionReader.getColumns() for serrmacint:informix.agregist returned: 1: [table_cat], 2: [table_schem], 3: [table_name], 4: [column_name], 5: [data_type], 6: [type_name], 7: [column_size], 8: [buffer_length], 9: [decimal_digits], 10: [num_prec_radix], 11: [nullable], 12: [remarks], 13: [column_def], 14: [sql_data_type], 15: [sql_datetime_sub], 16: [char_octet_length], 17: [ordinal_position], 18: [is_nullable], 19: [scope_catalog], 20: [scope_schema], 21: [scope_table], 22: [source_data_type], 23: [is_autoincrement] 2021-08-03 10:30:21 DEBUG JdbcIndexReader.getIndexInfo() Calling getIndexInfo() using: catalog=serrmacint, schema=informix, name=agregist, unique=false, approximate=true 2021-08-03 10:30:21 DEBUG SqlUtil.dumpResultSetInfo() DatabaseMetaData.processIndexResult() returned: 1: [table_cat], 2: [table_schem], 3: [table_name], 4: [non_unique], 5: [index_qualifier], 6: [index_name], 7: [type], 8: [ordinal_position], 9: [column_name], 10: [asc_or_desc], 11: [cardinality], 12: [pages], 13: [filter_condition] 2021-08-03 10:30:21 DEBUG JdbcIndexReader.getTableIndexList() Retrieving index information for table serrmacint.informix.agregist took: 16ms 2021-08-03 10:30:21 DEBUG InformixUniqueConstraintReader.readUniqueConstraints() Retrieving unique constraints using: select c.idxname, t.owner, c.constrname from serrmacint:informix.sysconstraints c join serrmacint:informix.systables t on t.tabid = c.tabid where c.constrtype = 'U' and t.tabname = ? 2021-08-03 10:30:21 DEBUG TableSourceBuilder.getNativeTableSource() Retrieving table source using: agregist 2021-08-03 10:30:21 ERROR TableSourceBuilder.getNativeTableSource() Error retrieving table source using: agregist A syntax error has occurred. [SQL State=42000, DB Errorcode=-201] java.sql.SQLSyntaxErrorException: A syntax error has occurred. at com.informix.util.IfxErrMsg.buildExceptionWithMessage(IfxErrMsg.java:408) at com.informix.util.IfxErrMsg.buildIsamException(IfxErrMsg.java:401) at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3096) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3368) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2292) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2217) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1461) at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:183) at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:968) at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:165) at workbench.db.TableSourceBuilder.getNativeTableSource(TableSourceBuilder.java:788) at workbench.db.TableSourceBuilder.getCreateTable(TableSourceBuilder.java:342) at workbench.db.TableSourceBuilder.getCreateTable(TableSourceBuilder.java:335) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:213) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:208) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:160) at workbench.sql.wbcommands.WbTableSource.execute(WbTableSource.java:90) at workbench.sql.StatementRunner.runStatement(StatementRunner.java:592) at workbench.gui.sql.SqlPanel.displayResult(SqlPanel.java:3501) at workbench.gui.sql.SqlPanel.runStatement(SqlPanel.java:2225) at workbench.gui.sql.SqlPanel$16.run(SqlPanel.java:2163) 2021-08-03 10:30:21 DEBUG InformixTableSourceBuilder.readLockMode() Retrieving lock mode using: select locklevel , fextsize, nextsize from serrmacint:informix.systables where tabname = 'agregist' and owner = 'informix' 2021-08-03 10:30:21 DEBUG AbstractConstraintReader.getTableConstraints() Retrieving table constraints using: select c.constrname, ch.checktext from serrmacint:informix.sysconstraints c join serrmacint:informix.systables t on t.tabid = c.tabid join serrmacint:informix.syschecks ch on ch.constrid = c.constrid where c.constrtype = 'C' and ch.type = 'T' and t.tabname = ? 2021-08-03 10:30:21 DEBUG JdbcIndexReader.getPrimaryKey() PK Information for agregist, PK Name=null, PK Index=null, columns=[] (0ms) 2021-08-03 10:30:21 DEBUG TableGrantReader.getTableGrants() Calling DatabaseMetaData.getTablePrivileges() using: serrmacint, informix, agregist 2021-08-03 10:30:21 ERROR TableGrantReader.getTableGrants() Error when retrieving table privileges No such column name [SQL State=IX000, DB Errorcode=-79738] java.sql.SQLException: No such column name at com.informix.util.IfxErrMsg.buildExceptionWithMessage(IfxErrMsg.java:416) at com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:397) at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:379) at com.informix.jdbc.IfxScrollableResultSet.findColumn(IfxScrollableResultSet.java:188) at com.informix.jdbc.IfxScrollableResultSet.getString(IfxScrollableResultSet.java:575) at workbench.db.TableGrantReader.getTableGrants(TableGrantReader.java:102) at workbench.db.TableGrantReader.getTableGrantSource(TableGrantReader.java:129) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:255) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:208) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:160) at workbench.sql.wbcommands.WbTableSource.execute(WbTableSource.java:90) at workbench.sql.StatementRunner.runStatement(StatementRunner.java:592) at workbench.gui.sql.SqlPanel.displayResult(SqlPanel.java:3501) at workbench.gui.sql.SqlPanel.runStatement(SqlPanel.java:2225) at workbench.gui.sql.SqlPanel$16.run(SqlPanel.java:2163) 2021-08-03 10:30:21 DEBUG TableGrantReader.getTableGrants() Calling DatabaseMetaData.getTablePrivileges() took: 15ms 2021-08-03 10:30:24 DEBUG Settings.restoreWindowPosition() Restoring window position for 'workbench.gui.components.LogFileViewer', current screen size: [x: 0, y: 0, w:1366,h:768], requested position: [x: 235, y: 71, w:800,h:600] 2021-08-03 10:30:44 DEBUG FileVersioner.slideVersions() Adjusting backup versions for "C:\AdApta\SQL-Workbench\Config\Default.wksp" took 0ms 2021-08-03 10:30:44 DEBUG FileVersioner.createBackup() Created file "C:\AdApta\SQL-Workbench\Config\Default.wksp.5" as a backup of "C:\AdApta\SQL-Workbench\Config\Default.wksp" in 2ms 2021-08-03 10:30:44 DEBUG MainWindow._doSaveWorkspace() Workspace C:\AdApta\SQL-Workbench\Config\Default.wksp saved in 144ms 2021-08-03 10:30:44 DEBUG ConnectionMgr.disconnect() Trying to physically close the connection with id=WbWin-1 TAB-12 2021-08-03 10:30:44 INFO ConnectionMgr.closeConnection() Disconnecting: [Abano-Serrmacint], ID=WbWin-1 TAB-12 2021-08-03 10:30:44 DEBUG WbConnection.shutdown() Connection WbWin-1 TAB-12 closed. 2021-08-03 10:30:44 DEBUG ConnectionMgr.closeConnection() Disconnecting connection with ID=WbWin-1 TAB-12, informix@jdbc:informix-sqli://localhost:3011/serrmacint:INFORMIXSERVER=abano_ol11;DBDATE=DMY4/ took 0ms 2021-08-03 10:30:44 DEBUG MacroStorage.loadMacros() Macro file C:\AdApta\SQL-Workbench\Config\WbMacros.xml not found. No Macros loaded 2021-08-03 10:30:44 DEBUG MacroManager.loadMacros() Loaded 0 macros from file C:\AdApta\SQL-Workbench\Config\WbMacros.xml for clientId: 1 2021-08-03 10:30:44 DEBUG BookmarkManager.clearBookmarksForWindow() Removed all bookmarks for window: 1 2021-08-03 10:30:44 DEBUG WbTabbedPane.init() Installed custom TabbedPaneUI 2021-08-03 10:30:44 DEBUG SqlPanel.readFromWorkspace() Restoring panel 1 from workspace C:\AdApta\SQL-Workbench\Config\Default.wksp took 16ms 2021-08-03 10:30:44 DEBUG WbTabbedPane.init() Installed custom TabbedPaneUI 2021-08-03 10:30:44 DEBUG SqlPanel.readFromWorkspace() Restoring panel 2 from workspace C:\AdApta\SQL-Workbench\Config\Default.wksp took 0ms 2021-08-03 10:30:44 DEBUG WbTabbedPane.init() Installed custom TabbedPaneUI 2021-08-03 10:30:44 DEBUG SqlPanel.readFromWorkspace() Restoring panel 3 from workspace C:\AdApta\SQL-Workbench\Config\Default.wksp took 0ms 2021-08-03 10:30:44 DEBUG WbTabbedPane.init() Installed custom TabbedPaneUI 2021-08-03 10:30:44 DEBUG SqlPanel.readFromWorkspace() Restoring panel 4 from workspace C:\AdApta\SQL-Workbench\Config\Default.wksp took 0ms 2021-08-03 10:30:44 DEBUG WbTabbedPane.init() Installed custom TabbedPaneUI 2021-08-03 10:30:44 DEBUG SqlPanel.readFromWorkspace() Restoring panel 5 from workspace C:\AdApta\SQL-Workbench\Config\Default.wksp took 0ms 2021-08-03 10:30:44 DEBUG WbTabbedPane.init() Installed custom TabbedPaneUI 2021-08-03 10:30:44 DEBUG SqlPanel.readFromWorkspace() Restoring panel 6 from workspace C:\AdApta\SQL-Workbench\Config\Default.wksp took 0ms 2021-08-03 10:30:44 DEBUG WbTabbedPane.init() Installed custom TabbedPaneUI 2021-08-03 10:30:44 DEBUG SqlPanel.readFromWorkspace() Restoring panel 7 from workspace C:\AdApta\SQL-Workbench\Config\Default.wksp took 0ms 2021-08-03 10:30:44 DEBUG WbTabbedPane.init() Installed custom TabbedPaneUI 2021-08-03 10:30:44 DEBUG SqlPanel.readFromWorkspace() Restoring panel 8 from workspace C:\AdApta\SQL-Workbench\Config\Default.wksp took 0ms 2021-08-03 10:30:44 DEBUG WbTabbedPane.init() Installed custom TabbedPaneUI 2021-08-03 10:30:44 DEBUG SqlPanel.readFromWorkspace() Restoring panel 9 from workspace C:\AdApta\SQL-Workbench\Config\Default.wksp took 0ms 2021-08-03 10:30:44 DEBUG WbTabbedPane.init() Installed custom TabbedPaneUI 2021-08-03 10:30:44 DEBUG SqlPanel.readFromWorkspace() Restoring panel 10 from workspace C:\AdApta\SQL-Workbench\Config\Default.wksp took 0ms 2021-08-03 10:30:44 DEBUG WbTabbedPane.init() Installed custom TabbedPaneUI 2021-08-03 10:30:44 DEBUG SqlPanel.readFromWorkspace() Restoring panel 11 from workspace C:\AdApta\SQL-Workbench\Config\Default.wksp took 0ms 2021-08-03 10:30:44 DEBUG WbTabbedPane.init() Installed custom TabbedPaneUI 2021-08-03 10:30:44 DEBUG SqlPanel.readFromWorkspace() Restoring panel 12 from workspace C:\AdApta\SQL-Workbench\Config\Default.wksp took 0ms 2021-08-03 10:30:44 DEBUG BookmarkManager.lambda$updateInBackground$4() Panel 'Sys' was updated in 0ms (0 bookmarks) 2021-08-03 10:30:44 DEBUG MainWindow.loadWorkspace() Loading workspace C:\AdApta\SQL-Workbench\Config\Default.wksp took 530ms 2021-08-03 10:30:44 DEBUG BookmarkManager.updateBookmarks() Parsing bookmarks for 12 tabs took: 0ms 2021-08-03 10:30:44 INFO ConnectionMgr.getConnection() Creating new connection for "{_S2}/Abano-Serrmacint": [user=informix, url=jdbc:informix-sqli://localhost:3011/serrmacint:INFORMIXSERVER=abano_ol11;DBDATE=DMY4/, driverClass=com.informix.jdbc.IfxDriver, driverName=Informix] 2021-08-03 10:30:44 DEBUG DbMetadata. WbWin-1 TAB-12: Schema term: user 2021-08-03 10:30:44 DEBUG DbMetadata. WbWin-1 TAB-12: Catalog term: database 2021-08-03 10:30:44 DEBUG DbMetadata. WbWin-1 TAB-12: Identifier quote character obtained from driver: 2021-08-03 10:30:44 INFO DbMetadata. WbWin-1 TAB-12: Using DBID=informix_dynamic_server 2021-08-03 10:30:44 INFO DbMetadata. WbWin-1 TAB-12: Using identifier quote character: " 2021-08-03 10:30:44 INFO DbMetadata. WbWin-1 TAB-12: Using search string escape character: \ 2021-08-03 10:30:44 INFO DbMetadata.retrieveObjectTypes() WbWin-1 TAB-12: Table types returned by the JDBC driver: [SYSTEM TABLE, TABLE, VIEW] 2021-08-03 10:30:44 INFO DbMetadata. WbWin-1 TAB-12: Using catalog separator: : 2021-08-03 10:30:44 DEBUG GenericSchemaInfoReader.logSettings() WbWin-1 TAB-12: Re-Use statement: false, cache current schema: false, SQL: null 2021-08-03 10:30:44 DEBUG GenericCatalogInformationReader. WbWin-1 TAB-12: Cache current schema: false 2021-08-03 10:30:44 INFO ConnectionMgr.getConnection() Connected to: [Informix Dynamic Server], Database version info: [11.50.FC6], Database version number: [11.50], Driver version: [4.50.JC2], JDBC version: [4.2], ID: [WbWin-1 TAB-12] 2021-08-03 10:30:44 DEBUG ConnectionInfo.updateDBSwitcher() Removing DB switcher for: WbWin-1 TAB-12, informix@jdbc:informix-sqli://localhost:3011/serrmacint:INFORMIXSERVER=abano_ol11;DBDATE=DMY4/ 2021-08-03 10:30:46 DEBUG DbMetadata.getObjects() WbWin-1 TAB-12: Calling getTables() using: catalog=serrmacint, schema=informix, name=agregist, types=[SYSTEM TABLE, TABLE] 2021-08-03 10:30:46 DEBUG DbMetadata.getObjects() WbWin-1 TAB-12: Retrieving table list took: 0ms 2021-08-03 10:30:46 DEBUG SqlUtil.dumpResultSetInfo() DatabaseMetaData.getTables() returned: 1: [table_cat], 2: [table_schem], 3: [table_name], 4: [table_type], 5: [remarks], 6: [type_cat], 7: [type_schem], 8: [type_name], 9: [self_referencing_col_name], 10: [ref_generation] 2021-08-03 10:30:46 DEBUG DbMetadata.getObjects() WbWin-1 TAB-12: Processing 1 tables took: 0ms 2021-08-03 10:30:46 DEBUG JdbcIndexReader.getPrimaryKey() PK Information for agregist, PK Name=null, PK Index=null, columns=[] (0ms) 2021-08-03 10:30:46 DEBUG JdbcTableDefinitionReader.getTableColumns() Calling getColumns() using: catalog=serrmacint, schema=informix, table=agregist 2021-08-03 10:30:46 DEBUG JdbcTableDefinitionReader.getTableColumns() Calling getColumns() took: 47ms 2021-08-03 10:30:46 DEBUG SqlUtil.dumpResultSetInfo() JdbcTableDefinitionReader.getColumns() for serrmacint:informix.agregist returned: 1: [table_cat], 2: [table_schem], 3: [table_name], 4: [column_name], 5: [data_type], 6: [type_name], 7: [column_size], 8: [buffer_length], 9: [decimal_digits], 10: [num_prec_radix], 11: [nullable], 12: [remarks], 13: [column_def], 14: [sql_data_type], 15: [sql_datetime_sub], 16: [char_octet_length], 17: [ordinal_position], 18: [is_nullable], 19: [scope_catalog], 20: [scope_schema], 21: [scope_table], 22: [source_data_type], 23: [is_autoincrement] 2021-08-03 10:30:46 DEBUG JdbcIndexReader.getIndexInfo() Calling getIndexInfo() using: catalog=serrmacint, schema=informix, name=agregist, unique=false, approximate=true 2021-08-03 10:30:46 DEBUG SqlUtil.dumpResultSetInfo() DatabaseMetaData.processIndexResult() returned: 1: [table_cat], 2: [table_schem], 3: [table_name], 4: [non_unique], 5: [index_qualifier], 6: [index_name], 7: [type], 8: [ordinal_position], 9: [column_name], 10: [asc_or_desc], 11: [cardinality], 12: [pages], 13: [filter_condition] 2021-08-03 10:30:46 DEBUG JdbcIndexReader.getTableIndexList() Retrieving index information for table serrmacint.informix.agregist took: 0ms 2021-08-03 10:30:46 DEBUG InformixUniqueConstraintReader.readUniqueConstraints() Retrieving unique constraints using: select c.idxname, t.owner, c.constrname from serrmacint:informix.sysconstraints c join serrmacint:informix.systables t on t.tabid = c.tabid where c.constrtype = 'U' and t.tabname = ? 2021-08-03 10:30:46 DEBUG TableSourceBuilder.getNativeTableSource() Retrieving table source using: agregist 2021-08-03 10:30:46 ERROR TableSourceBuilder.getNativeTableSource() Error retrieving table source using: agregist A syntax error has occurred. [SQL State=42000, DB Errorcode=-201] java.sql.SQLSyntaxErrorException: A syntax error has occurred. at com.informix.util.IfxErrMsg.buildExceptionWithMessage(IfxErrMsg.java:408) at com.informix.util.IfxErrMsg.buildIsamException(IfxErrMsg.java:401) at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3096) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3368) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2292) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2217) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1461) at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:183) at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:968) at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:165) at workbench.db.TableSourceBuilder.getNativeTableSource(TableSourceBuilder.java:788) at workbench.db.TableSourceBuilder.getCreateTable(TableSourceBuilder.java:342) at workbench.db.TableSourceBuilder.getCreateTable(TableSourceBuilder.java:335) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:213) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:208) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:160) at workbench.sql.wbcommands.WbTableSource.execute(WbTableSource.java:90) at workbench.sql.StatementRunner.runStatement(StatementRunner.java:592) at workbench.gui.sql.SqlPanel.displayResult(SqlPanel.java:3501) at workbench.gui.sql.SqlPanel.runStatement(SqlPanel.java:2225) at workbench.gui.sql.SqlPanel$16.run(SqlPanel.java:2163) 2021-08-03 10:30:46 DEBUG InformixTableSourceBuilder.readLockMode() Retrieving lock mode using: select locklevel , fextsize, nextsize from serrmacint:informix.systables where tabname = 'agregist' and owner = 'informix' 2021-08-03 10:30:46 DEBUG AbstractConstraintReader.getTableConstraints() Retrieving table constraints using: select c.constrname, ch.checktext from serrmacint:informix.sysconstraints c join serrmacint:informix.systables t on t.tabid = c.tabid join serrmacint:informix.syschecks ch on ch.constrid = c.constrid where c.constrtype = 'C' and ch.type = 'T' and t.tabname = ? 2021-08-03 10:30:46 DEBUG JdbcIndexReader.getPrimaryKey() PK Information for agregist, PK Name=null, PK Index=null, columns=[] (0ms) 2021-08-03 10:30:46 DEBUG TableGrantReader.getTableGrants() Calling DatabaseMetaData.getTablePrivileges() using: serrmacint, informix, agregist 2021-08-03 10:30:46 ERROR TableGrantReader.getTableGrants() Error when retrieving table privileges No such column name [SQL State=IX000, DB Errorcode=-79738] java.sql.SQLException: No such column name at com.informix.util.IfxErrMsg.buildExceptionWithMessage(IfxErrMsg.java:416) at com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:397) at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:379) at com.informix.jdbc.IfxScrollableResultSet.findColumn(IfxScrollableResultSet.java:188) at com.informix.jdbc.IfxScrollableResultSet.getString(IfxScrollableResultSet.java:575) at workbench.db.TableGrantReader.getTableGrants(TableGrantReader.java:102) at workbench.db.TableGrantReader.getTableGrantSource(TableGrantReader.java:129) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:255) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:208) at workbench.db.TableSourceBuilder.getTableSource(TableSourceBuilder.java:160) at workbench.sql.wbcommands.WbTableSource.execute(WbTableSource.java:90) at workbench.sql.StatementRunner.runStatement(StatementRunner.java:592) at workbench.gui.sql.SqlPanel.displayResult(SqlPanel.java:3501) at workbench.gui.sql.SqlPanel.runStatement(SqlPanel.java:2225) at workbench.gui.sql.SqlPanel$16.run(SqlPanel.java:2163) 2021-08-03 10:30:46 DEBUG TableGrantReader.getTableGrants() Calling DatabaseMetaData.getTablePrivileges() took: 0ms 2021-08-03 10:31:00 DEBUG Settings.restoreWindowPosition() Restoring window position for 'workbench.gui.components.LogFileViewer', current screen size: [x: 0, y: 0, w:1366,h:768], requested position: [x: 235, y: 71, w:800,h:600]