Change Log - SymmetricDS

0006663: [Bug] Logging of exceptions on data load can show values used in the wrong order when conflict resolution is in play (pmarzullo)

0006616: [Improvement] Save column references as numeric values for faster look-up in AbstractDatabaseWriter.getRowData() (pbelov)

0006577: [Improvement] Enable acceptance of cookies by default for compatibility with load balancers (elong)

0006538: [New Feature] Use source staging for incoming batch when engines are hosted together (elong)

0006244: [Improvement] Upgrade H2 library to 2.2 (emiller)

0006351: [Bug] Text and icons disappear in SQL Explorer TreeGrid when switching nodes (emiller)

0006537: [Improvement] Data gap detector should refresh cluster lock (elong)

0006620: [Improvement] Turn on UNLOGGED table mode during initial load into an empty PostgreSQL table (pbelov)

0002298: [Bug] DDL detection of a default value for real/float column type on the Interbase is wrong (elong)

0006647: [New Feature] Pause/Resume Nodes (josh-a-hicks)

0006654: [Improvement] Info URL handler to use channel cache (elong)

0006655: [Improvement] Add REST API to clear node host entries (elong)

0006657: [Bug] Data reload events with reload where clause should not be routed in common mode (pmarzullo)

0006659: [Bug] Custom data types causing sizing detection issues on table comparisons (josh-a-hicks)

0006662: [Bug] Logging of exceptions on data load can show values used in the wrong order when conflict resolution is in play (pmarzullo)

0006621: [Bug] NVARCHAR(MAX) and VARCHAR(MAX) columns get modified when another column is updated (SQLServer-specific) (pbelov)

0006608: [Improvement] Performance bottleneck in file change detection for >1M files (pbelov)

0006540: [Task] database.dtd could be updated to reflect support for NVARCHAR (and other n-types) (elong)

0006593: [Bug] DDL change cannot alter column to nullable on H2 (elong)

0006610: [Improvement] Move Tibero support to Pro (josh-a-hicks)

0006611: [New Feature] Auto resolve conflict of delete of missing rows by capturing delete (elong)

0006612: [Bug] MySQL 5.1 query error because generated columns not supported (elong)

0006617: [Bug] Update trigger to accommodate NULLs for unique index with NULLable columns (pbelov)

0006618: [New Feature] Group link flag to control syncing of SQL/DDL events (elong)

0006622: [Bug] Conflict detection for log miners need to use the correct database connection (pmarzullo)

0006623: [Bug] The isNull transform converts an empty string to NULL (pbelov)

0006624: [Improvement] Faster snapshot exports and more checkpoint progression (elong)

0006627: [Bug] DDL replication stuck from reader on another connection (elong)

0006630: [Bug] Initial load with delete first captures the deletes when source and target are log mining nodes (pmarzullo)

0006631: [Improvement] Deployment of WAR on Tomcat 10 (elong)

0006641: [Improvement] BasicDataSourceFactory should not set user and password if they are empty (pmarzullo)

0006645: [Improvement] Update jetty server dependency to 11.0.24 (elong)

0006646: [Bug] Setting node.offline parameter to true or false disables all communication (pmarzullo)

0006597: [Bug] Registration batch fails with foreign key error (elong)

0006592: [Improvement] Added currentRowCount to process info. Updated DataService (mdrouard)

0006600: [Bug] DDL replication of create table with insert in same transaction (elong)

0006603: [Bug] NULL-able trait is not preserved, when column referenced by a unique index (pbelov)

0006598: [New Feature] IPurgeListener needs to have the capability to run functionality before the purge outgoing/incoming is run (pmarzullo)

0006604: [Bug] Upgrade Spring libraries (elong)

0006594: [Improvement] Support DDL for automatic update of timestamp by database (elong)

0006602: [Bug] MySQL/MariaDB treat bit type with size greater than 1 as integer (elong)

0006590: [Bug] Empty LOB loads as null on Oracle (elong)

0006586: [Bug] StackOverflow on startup with DB2 LUW (elong)

0006578: [Improvement] SQL Server support for datetime and datetime2 column types when the paramter db.treat.date.time.as.varchar.enabled is true (josh-a-hicks)

0006575: [Improvement] Service wrapper should warn if incompatible Java version (elong)

0006576: [Improvement] Disallow HTTP methods not needed for data sync (elong)

0006572: [Bug] SQL Server updates create duplicate rows with datetime2 in primary key (elong)

0006571: [Bug] Database trigger is left on table after removing configuration for it (elong)

0006569: [Improvement] Symadmin option to drop SymmetricDS triggers (elong)

0006567: [Bug] Outgoing and incoming error tables sync to wrong targets (elong)

0006566: [Bug] Load cancellation not working from client node (mdrouard)

0006565: [Bug] Java Load Filter compilation error when some categories are blank. (mdrouard)

0006562: [Bug] Stream LOB when row is deleted can get exception ColumnNotFoundException (elong)

0006559: [Improvement] Purge and recapture can cause exception in routing (elong)

0006521: [Improvement] Initial load request should cancel outstanding load requests (elong)

0006475: [Bug] New "Initial Load" not cancelling previous initial loads (elong)

0006545: [Improvement] MSSQL create table support for user defined types (josh-a-hicks)

0006529: [Improvement] Do not data load columns that are generated (computed) (josh-a-hicks)

0006557: [Improvement] Filter extension point during extraction (elong)

0006552: [Bug] SQL Anywhere fails to call DatabaseMetaData.getSchemas() (pmarzullo)

0006535: [Improvement] Support for MySQL 5.1 with latest 3.15.x versions (josh-a-hicks)

0004000: [Bug] java.lang.NoClassDefFoundError: org.jumpmind.symmetric.io.stage.StagingManager$1, even though the class exists in the jar file

0006526: [Bug] Triggers aren't synced after schema changes. (elong)

0006482: [Bug] Could not find trigger history causes error of wrong number of columns data validation in wrong column (elong)

0006485: [Bug] Do not issue foreign key correction for non-DML events (elong)

0006510: [Bug] SQLite with initial load in background can hang (elong)

0006547: [Bug] Prevent registration of registration server or empty node group (elong)

0006524: [Bug] Symadmin sync-triggers command does not update triggers (emiller)

0006539: [Bug] FileSyncDataRouter should handle initial load that uses an initialloadselect like other routers (pmarzullo)

0006528: [Improvement] Upgrade sybase JDBC driver to jconn4 version 16.0 build 27538 (pmarzullo)

0006533: [Bug] mssql-jdbc 12.6.1 SocketTimeoutException (elong)

0006531: [Bug] 0006530: Conflict resolution needs to set source node ID when executing conflict resolution for a SQL Server log mining node (pmarzullo)

0006520: [Bug] Trigger template replacement for SQL Server and Sybase not replacing channel id variables correctlly (pmarzullo)

0006513: [Bug] File Sync Tracker changes to improve performance and to collect completely the set of files (pmarzullo)

0006517: [Bug] Multi primary incorrectly detected when group link is routes only (elong)

0006516: [Improvement] Routing process status and lock improvements (elong)

0006515: [Bug] Incoming batch from reload missing table summary when 0 rows (elong)

0006219: [Improvement] Make Sybase ASE triggers use an "insert ... select" statement instead of a cursor (pmarzullo)

0006514: [Bug] H2 always reconfiguring sym_node table when schema XML changes most_recent_active_table column from varchar to varchar(255) (pmarzullo)

0006507: [Bug] Values can be matched with the wrong columns during extraction when using targetExternalId variable and table definitions differ (emiller)

0006508: [Bug] SQL-Server DDL table alterations when change not needed (elong)

0006503: [Bug] Sync on incoming batch setting does not get applied if a group link exists with the same source and target group ID (emiller)

0006505: [Bug] Service error and bad request are using same 601 http error code (elong)

0006488: [Bug] org.hsqldb.HsqlException: length must be specified in type definition: VARCHAR (pmarzullo)

0006487: [Bug] Wildcard trigger definitions do not remove existing triggers when adding a NOT table name to wild carded definition (pmarzullo)

0006555: [Bug] CPU monitor is inaccurate for systems with a Mac or Linux OS and more than 1 core (emiller)

0006477: [Bug] If auto resolve missing foreign key fails, try again (elong)

0006484: [Bug] Do not issue foreign key correction for non-DML events (elong)

0006530: [Bug] Conflict resolution needs to set source node ID when executing conflict resolution for a SQL Server log mining node (pmarzullo)

0006506: [Bug] Values can be matched with the wrong columns during extraction when using targetExternalId variable and table definitions differ (emiller)

0006502: [Bug] Sync on incoming batch setting does not get applied if a group link exists with the same source and target group ID (emiller)

0006489: [Bug] CPU monitor should use Java routine if native command not available (pmarzullo)

0006486: [Bug] Wildcard trigger definitions do not remove existing triggers when adding a NOT table name to wild carded definition (pmarzullo)

0006483: [Bug] Could not find trigger history causes error of wrong number of columns data validation in wrong column (elong)

0006467: [Bug] Symadmin export-sym-tables subcommand doubles the table prefix when called without the --alters option (emiller)

0006446: [Improvement] Provide the ability to specify a no lock hint when reading DDL (pmarzullo)

0006441: [Bug] NullPointerException when searching for a matching trigger history and row_data or pk_data is null (emiller)

0006400: [Bug] Issue with file sync when successful, retry is tried even when bean shell script is successful (pmarzullo)

0006393: [Bug] When building DDL for SQL Server, default values of 'true' or null for bit columns get changed to 0 (emiller)

0006460: [New Feature] Add symadmin export-sym-objects subcommand (emiller)

0006459: [Bug] Unitext Columns fail during initial load (jvanmeter)

0006424: [Bug] Statistics for synchronization should not be saved when batch is in error (pmarzullo)

0006478: [Improvement] Column match router expression for has, starts with, and ends with (elong)

0006476: [Bug] If auto resolve missing foreign key fails, try again (elong)

0006473: [New Feature] Add a --use-sym-db option to the DbImport and DbSql commands (emiller)

0006469: [Improvement] Add a section to the user guide that explains how to add a new node without having SymmetricDS run any DDL (emiller)

0006468: [Bug] Symadmin export-sym-tables subcommand doubles the table prefix when called without the --alters option (emiller)

0006465: [Improvement] Prevent sync triggers from running the trigger DDL when it's called to export a SQL script (emiller)

0006458: [Bug] DB Compare unable to process Unitypes in both directions. (jvanmeter)

0006453: [Bug] SQL Explorer tree displays schemas incorrectly when using Postgres JDBC driver version 42.7.0 or later (emiller)

0006452: [Bug] Newer wins conflict detection table case when cross platform (elong)

0006449: [Improvement] Add a "Show Triggers" option to SQL Explorer (emiller)

0006448: [Improvement] Provide the ability to specify a no lock hint when reading DDL (pmarzullo)

0006447: [Bug] Stack overflow when inserting last gap (elong)

0006442: [Bug] NullPointerException when searching for a matching trigger history and row_data or pk_data is null (emiller)

0006433: [Bug] Exception when auto resolver tries to lock row in conflict (elong)

0006434: [Improvement] Logging of mismatch primary key that causes auto resolver action (elong)

0006435: [Improvement] Avoid checking newer capture time if table isn't being captured (elong)

0006406: [Bug] Trigger Sync do not capture updates on included_column_names or excluded_column_names (elong)

0006420: [Bug] SQL Server money data type error with commas (elong)

0006419: [Bug] Stopping an engine from JMX sets the auto.start.engine false for ALL engines. (jvanmeter)

0006415: [Bug] Recapture data for stranded data and for expired data gaps should keep the old data values to allow subselect routing to work (pmarzullo)

0006414: [Bug] Stream Lobs setting does not work with Sybase ASE Unitypes (jvanmeter)

0006413: [Improvement] DBImport should have option to adjust create.index.convert.unique.to.nonunique.when.columns.not.required param (cquamme)

0006401: [Bug] Issue with file sync when successful, retry is tried even when bean shell script is successful (pmarzullo)

0006394: [Bug] When building DDL for SQL Server, default values of 'true' or null for bit columns get changed to 0 (emiller)

0006373: [Bug] SQLite purge fails with unrecognized token: "{" (elong)

0006362: [Bug] Upgrade Jetty libraries (elong)

0006383: [Bug] DB Compare fails to work bidirectionally when using Unitypes (jvanmeter)

0006385: [Bug] Error on registration batch or import of config from newer 3.14 or 3.15 (elong)

0006375: [Improvement] File Sync exceptions thrown by bsh script should be retried for transient errors (pmarzullo)

0006363: [Bug] Auto resolve delete of blocking rows when binary type in primary key (elong)

0006365: [Improvement] Add logging when instance ID changes (emiller)

0006370: [Bug] MySQL 5.5 and earlier don't allow timestamp precision (elong)

0006369: [Improvement] REV_INITIAL_LOAD_TIME should be set in the NODE_SECURITY table if a reverse initial load is made (cquamme)

0006361: [Bug] NullPointerException when sending a load with file sync enabled and without a valid sym_trigger_hist row for sym_file_snapshot (emiller)

0006359: [Bug] Purge of stranded data fails on Sybase ASE (elong)

0006357: [Bug] Initial load with overridden symmetric table trigger definition should skip symmetric tables when creating create table events (pmarzullo)

0006347: [Bug] Support SQLServer float positive negative infinity value (elong)

0006374: [Improvement] File Sync exceptions thrown by bsh script should be retried for transient errors (pmarzullo)

0006384: [Bug] Error on registration batch or import of config from newer 3.14 or 3.15 (elong)

0006364: [Improvement] Add logging when instance ID changes (emiller)

0006367: [Bug] Auto resolve delete of blocking rows when binary type in primary key (elong)

0006360: [Bug] NullPointerException when sending a load with file sync enabled and without a valid sym_trigger_hist row for sym_file_snapshot (emiller)

0006311: [Bug] Failed to decrypt password counter measure if node registration is already open (elong)

0006323: [Bug] Routing file deletes causes null pointer exception when capturing statistics (pmarzullo)

0006326: [Bug] Spring Framework URL Parsing with Host Validation (part 2) (elong)

0006327: [Bug] Specifying a reload channel ID for the channel_id in sym_table_reload_request results in the load getting stuck (emiller)

0006331: [Improvement] Allow specification of initial load select for initial load of filesync channel (pmarzullo)

0006334: [Bug] File sync batches get synchronized when there is an error during extraction (emiller)

0006341: [Bug] Index out of bounds routing change to sym_node_group_link (elong)

0006350: [Bug] H2 version 2 LONGVARCHAR implementation uses VARCHAR(1000000000) (pmarzullo)

0006321: [Bug] Issues using DB Compare with Unitypes (jvanmeter)

0006356: [Bug] Creating a table in a load was not checking if platform column existed (jvanmeter)

0006355: [Bug] Support autosave=always mode on PostgreSQL (elong)

0006310: [Bug] Sybase ASE 12 can only quote column names 28 characters or less (elong)

0006313: [Bug] Sync triggers for table should treat null or blank catalog/schema as default catalog/schema (elong)

0006315: [Bug] MySQL and MariaDB create table support for UNSIGNED columns (josh-a-hicks)

0006318: [Bug] NullPointerException while extracting data on SQLite as the typeName is not being set by driver (jvanmeter)

0006320: [Improvement] Parameter for file sync compression of ZIP archive (elong)

0006325: [Bug] Spring Framework URL Parsing with Host Validation (part 2) (elong)

0006328: [Bug] Specifying a reload channel ID for the channel_id in sym_table_reload_request results in the load getting stuck (emiller)

0006333: [Improvement] File sync BeanShell script should place files in a separate error directory if any error occurs when they are copied (emiller)

0006335: [Bug] File sync batches get synchronized when there is an error during extraction (emiller)

0006343: [Bug] DbCompare on Postgres not using cursor with fetch size (elong)

0006346: [Improvement] Use read uncommitted for checking heartbeats and offline nodes (elong)

0006352: [Improvement] Improve logging when a problem occurs during repair of unrouted data (elong)

0006353: [Bug] Recapture data in purge service should not handle pre-routed data records (pmarzullo)

0006342: [Bug] Index out of bounds routing change to sym_node_group_link (elong)

0006332: [Improvement] Allow specification of initial load select for initial load of filesync channel (pmarzullo)

0006324: [Bug] Routing file deletes causes null pointer exception when capturing statistics (pmarzullo)

0006312: [Bug] Failed to decrypt password counter measure if node registration is already open (elong)

0006170: [Bug] DB Compare incorrectly comparing values (jvanmeter)

0006252: [Bug] ASE large column types for primary keys need to limit max size based on page size (pmarzullo)

0006253: [Bug] Issue with Initial loads when using Sybase ASE Unitypes while using JTDS driver (jvanmeter)

0006256: [Improvement] Add virtual column to sym_file_snapshot for easier routing by column match and bean shell routers (pmarzullo)

0006259: [Bug] Sync triggers is mis-detecting last update time on sym triggers (elong)

0006264: [Bug] Include source_node_id in the where clause when updating or deleting from sym_table_reload_status (emiller)

0006267: [Bug] Prevent columns from being created with a size of 0 (emiller)

0006270: [Bug] Prevent OracleSymmetricDialect from underestimating the current value of a sequence (emiller)

0006271: [Bug] Finding trigger histories should treat null or blank as default catalog/schema (elong)

0006272: [Improvement] Startup logging for specific node securities that can't decrypt (elong)

0006275: [Bug] FileSyncDataRouter gets FileTriggerRouters from database instead of cache (pmarzullo)

0006278: [Improvement] Change file sync processing to make immediate request when batches are received or sent (pmarzullo)

0006279: [Improvement] Make File Sync Tracker transactions smaller to minimize locking collision problems (pmarzullo)

0006283: [Bug] Spring Framework URL Parsing with Host Validation (elong)

0006285: [Bug] Memory leak in MSSQL JDBC driver 10.2.0 (elong)

0006292: [Improvement] File sync BeanShell script should place files in a separate error directory if they are not writable (emiller)

0006296: [Bug] DefaultDatabaseWriter sql(...) method parsing sql statement during exception needs changed (pmarzullo)

0006297: [Bug] Upgrade mysql, postgres, vaadin, jetty libraries (elong)

0006301: [Improvement] Update Rest Keys docs to reflect correct error code (cquamme)

0006302: [Bug] Unable to set web context path with symmetric.server.web.home (elong)

0006300: [Bug] Hot spot removing old node sessions in mixed environment with versions < 3.11 (elong)

0006201: [Improvement] Add support for NTypes in XML (cquamme)

0006288: [Bug] Writing table definitions from xml for indexes that do not have a corresponding platform index (josh-a-hicks)

0006217: [Bug] Schema information missing from drop index query generated by DDL on PostgreSQL

0006229: [Bug] Old stage files used after node is rebuilt (elong)

0006240: [Improvement] Failed to update a table_reload_request as processed for loadId (elong)

0006243: [New Feature] Support H2 version 2.2 (emiller)

0006251: [Bug] BSH column transform column names can conflict with built-in variable names (elong)

0006246: [Bug] Cancel Load needs to make sure processes threads shut down before updating outstanding load request records (pmarzullo)

0006226: [Bug] H2 DDL Builder incorrectly adds size information to "UUID" data type (cquamme)

0006263: [Bug] Include source_node_id in the where clause when updating or deleting from sym_table_reload_status (emiller)

0006266: [Bug] Prevent columns from being created with a size of 0 (emiller)

0006269: [Bug] Prevent OracleSymmetricDialect from underestimating the current value of a sequence (emiller)

0006274: [Bug] FileSyncDataRouter gets FileTriggerRouters from database instead of cache (pmarzullo)

0006282: [Bug] Spring Framework URL Parsing with Host Validation (elong)

0006298: [Bug] Upgrade mysql, postgres libraries (elong)

0006299: [Bug] Hot spot removing old node sessions in mixed environment with versions < 3.11 (elong)

0006273: [Improvement] Startup logging for specific node securities that can't decrypt (elong)

0006245: [Bug] Cancel Load needs to make sure processes threads shut down before updating outstanding load request records (pmarzullo)

0006198: [Improvement] Record failed sync trigger attempts to database in trigger history and stats (elong)

0004617: [Bug] Corrupted row data during extract

0006174: [Improvement] Could not find trigger history, causes error of had X columns but expected Y (elong)

0006188: [New Feature] Add boolean data type support for Oracle 23c (cquamme)

0006189: [Improvement] Issue with syncing BIGINT, INT, TINYINT, SMALLINT, and BIT data types to Oracle and Tibero databases (cquamme)

0006194: [Bug] Postgres XML incorrectly identifies "BOOLEAN" as "BIT" (cquamme)

0006195: [Bug] symadmin module error when file exists without a dot (elong)

0006205: [Bug] Syncing a NCLOB from Oracle to Postgres results in an error (cquamme)

0006206: [Improvement] Add LOB Mapping for SQL Server 2005 and later (cquamme)

0006207: [Bug] Reverse initial load sometimes doesn't start when also using forward initial load (elong)

0006210: [Improvement] "Node failed to authenticate" in server logs after server restarts or client session expires (elong)

0006214: [Bug] SQLite sync error on sym_table_reload_request when db.treat.date.time.as.varchar.enabled (elong)

0006224: [Bug] Imported configuration sometimes gets deleted from sym_data (emiller)

0006212: [Bug] Registration error: sym_parameter changes causing sync triggers need to be limited to DML changes (pmarzullo)

0006193: [Bug] Adjusting unique indexes to non-unique when columns can be null should be able to be turned off by parameter (pmarzullo)

0006165: [Improvement] During an upgrade, log DDL before executing it instead of afterwards (emiller)

0006168: [Bug] File sync push is rejected because of a lack of a reservation (pmarzullo)

0006171: [Bug] Cookies required error when both http and https enabled (elong)

0006176: [Bug] Upgrade Jetty (elong)

0006184: [Improvement] Multi-threaded routing and gap detection (elong)

0006185: [Improvement] Unnecessary unrouted batch appears along with routed batch (elong)

0006178: [Improvement] Snapshot util timeout for taking too long on table definitions (elong)

0006163: [Bug] Snapshot error from database time on Sybase ASE/ASA (elong)

0006192: [Bug] Adjusting unique indexes to non-unique when columns can be null should be able to be turned off by parameter (pmarzullo)

0006199: [Improvement] Remove securityToken parameter from /outgoingBatchSummary REST API call (emiller)

0006209: [Improvement] "Node failed to authenticate" in server logs after server restarts or client session expires (elong)

0006211: [Bug] Registration error: sym_parameter changes causing sync triggers need to be limited to DML changes (pmarzullo)

0006223: [Bug] Imported configuration sometimes gets deleted from sym_data (emiller)

0006162: [Bug] Snapshot error from database time on Sybase ASE/ASA (elong)

0006164: [Improvement] During an upgrade, log DDL before executing it instead of afterwards (emiller)

0006173: [Improvement] Could not find trigger history, causes error of had X columns but expected Y (elong)

0006175: [Bug] Upgrade Jetty (elong)

0006177: [Improvement] Snapshot util timeout for taking too long on table definitions (elong)

0006152: [Bug] DDL replication errors on SQL-Server with renaming columns and deadlocks (elong)

0006156: [Bug] Repair of unrouted data should go through routing (elong)

0006159: [Bug] Firebird sym_hex UDF can cause an access violation (emiller)

0006146: [Improvement] Additional trigger template variable to suppor primary key joins without an alias (josh-a-hicks)

0006154: [New Feature] Add parameters that can disable specific types of conflict resolution (emiller)

0006155: [Bug] Conflict resolver does not handle unique index violations correctly when a unique index ignores null values (emiller)

0006148: [Improvement] Remove individual jobs stats for push and pull and uri handlers (elong)

0006145: [Bug] Purge fails with incorrect syntax near 'd' on SQL Server (elong)

0006139: [Bug] Jtds driver does not work with Sybase ASE (jvanmeter)

0006144: [Bug] Postgres timestamp with time zone columns get their values formatted incorrectly when extracted for a load (emiller)

0006140: [Bug] DB compare was incorrectly hex-encoding Unitype columns (jvanmeter)

0006132: [Improvement] Too many "Expected but did not receive an ack for batch" (elong)

0006128: [Bug] Dbfill of nchar/nvarchar and avoid timestamp/rowversion (elong)

0006106: [Improvement] Some Bulk loaders don't process before filters (cquamme)

0006115: [Bug] Cancel of load at target does not clean up everything at the source and still shows active at target (pmarzullo)

0006076: [Bug] Protect against exceptions in CPU monitor (emiller)

0006080: [Improvement] Improve name and documentation for DBExport's --symmetric option (emiller)

0006150: [Bug] Firebird sym_hex UDF can cause an access violation (emiller)

0006153: [New Feature] Add parameters that can disable specific types of conflict resolution (emiller)

0006143: [Bug] Postgres timestamp with time zone columns get their values formatted incorrectly when extracted for a load (emiller)

0006133: [Bug] DB compare was incorrectly hex-encoding Unitype columns (jvanmeter)

0006131: [Improvement] Too many "Expected but did not receive an ack for batch" (elong)

0006127: [Bug] Dbfill of nchar/nvarchar and avoid timestamp/rowversion (elong)

0006124: [Improvement] Add documentation for PostGIS data types for Postgres (cquamme)

0006112: [Bug] Cancel of load at target does not clean up everything at the source and still shows active at target (pmarzullo)

0006098: [Bug] Many router types attempt to handle non-DML data event types when they do not support them (emiller)

0006032: [Bug] Multiple queues can cause contention when trying to register a node. (jvanmeter)

0006095: [Improvement] Contains big LOB check can be fooled by commas in data (elong)

0006082: [Improvement] SQLite nodes do not insert into sym_context correctly when disabling sync triggers (emiller)

0006073: [Bug] Sync triggers fails when checking for multiple active trigger histories if Sybase ASE page size is 2K (emiller)

0006064: [Improvement] Slow extract and load when using $(targetExternalId) variable (elong)

0006071: [Bug] sym_node gets updated unnecessarily when heartbeat.update.node.with.batch.status parameter is disabled (emiller)

0006130: [Improvement] Too many "Expected but did not receive an ack for batch" (elong)

0006050: [Bug] Sybase ASE result set has already been closed during trigger exists check (elong)

0005930: [Bug] log.slow.sql.threshold.millis and log.sql.parameters.inline parameters do not work and are not documented (emiller)

0005914: [Bug] Cannot Install swaggerui module by using symadmin ModuleManager (pmarzullo)

0005896: [Bug] ValidatorException while validating self-signed X509 certificate (emiller)

0005870: [Improvement] Improve documentation of sym_node_group_link.sync_config_enabled (emiller)

0005852: [Improvement] sym_monitor_event trigger should capture changes when monitor.events.capture.enabled=true even if auto.sync.configuration=false (emiller)

0005846: [Improvement] Try again when foreign key correction fails (emiller)

0006129: [Improvement] Too many "Expected but did not receive an ack for batch" (elong)

0005912: [Bug] Cannot Install swaggerui module by using symadmin ModuleManager (pmarzullo)

0005895: [Bug] ValidatorException while validating self-signed X509 certificate (emiller)

0005871: [Improvement] Improve documentation of sym_node_group_link.sync_config_enabled (emiller)

0005837: [Bug] Binary primary keys will not delete as part of conflict resolution (emiller)

0005851: [Improvement] sym_monitor_event trigger should capture changes when monitor.events.capture.enabled=true even if auto.sync.configuration=false (emiller)

0005845: [Improvement] Try again when foreign key correction fails (emiller)

0006016: [Bug] Missing Kafka dependencies when installing Kafka module (emiller)

0006081: [Improvement] Improve name and documentation for DBExport's --symmetric option (emiller)

0006057: [Improvement] Multi-threaded routing by channel (elong)

0006017: [Improvement] DDL Create Table Oracle with varchar columns that have a size > 4000 (josh-a-hicks)

0006104: [Improvement] Add indexes to sym_outgoing_batch (emiller)

0006087: [Bug] Upgrade from pre-3.15 to 3.15 loses H2 databases (emiller)

0006099: [Bug] Many router types attempt to handle non-DML data event types when they do not support them (emiller)

0006100: [Bug] Engine "filesync" not found (elong)

0006097: [Improvement] Cache trigger template hashcode (elong)

0006096: [Improvement] Contains big LOB check can be fooled by commas in data (elong)

0006094: [New Feature] Add symadmin take-snapshot subcommand (emiller)

0006086: [Improvement] Improve watchdog job and enable it by default (emiller)

0006083: [Improvement] SQLite nodes do not insert into sym_context correctly when disabling sync triggers (emiller)

0006079: [New Feature] Make it possible to use DBCompare's --config option to specify a suffix for each column in the order by clause (emiller)

0006074: [Bug] Sync triggers fails when checking for multiple active trigger histories if Sybase ASE page size is 2K (emiller)

0006072: [Bug] sym_node gets updated unnecessarily when heartbeat.update.node.with.batch.status parameter is disabled (emiller)

0006069: [Improvement] Slow extract and load when using $(targetExternalId) variable (elong)

0006040: [Bug] maxFormContentSize and maxFormKeys are no longer used (elong)

0006052: [Bug] Sybase ASE result set has already been closed during trigger exists check (elong)

0006046: [Bug] The watchdog job should not allow a node to detect itself as offline (emiller)

0006044: [Bug] ConcurrentConnectionManager expects nodeId-channel in the white list, but only the nodeId is put in the white list (pmarzullo)

0006041: [Improvement] Reject node registration request (elong)

0006035: [Improvement] Use the value of javax.net.ssl.trustStoreType as the truststore type if specified (emiller)

0006023: [Bug] SQLException when updating a non-OK outgoing batch on some database platforms (emiller)

0006015: [New Feature] Add :SOURCE_NODE_ID, :SOURCE_EXTERNAL_ID, and :SOURCE_NODE_GROUP_ID variables to column match routers (emiller)

0006012: [Bug] Do not attempt to "create or alter" triggers on SQL Server 2016 RTM (emiller)

0006007: [Improvement] Prevent node from starting up if the sync.url is invalid (emiller)

0006003: [Improvement] Upgrade Gradle Docker Plugin to latest version and get it working (emiller)

0006004: [Bug] SQL Explorer grid editor causes error in browser and "Edit" button is initially invisible (emiller)

0006055: [Improvement] Multi-threaded routing by channel (elong)

0005992: [Bug] Conflict resolver does not handle unique index violations correctly when a unique index ignores null values (emiller)

0005965: [Bug] Conflict Detection Fixes for Unique Keys (cquamme)

0006051: [Bug] Sybase ASE result set has already been closed during trigger exists check (elong)

0006043: [Bug] ConcurrentConnectionManager expects nodeId-channel in the white list, but only the nodeId is put in the white list (pmarzullo)

0006034: [Improvement] Use the value of javax.net.ssl.trustStoreType as the truststore type if specified (emiller)

0006021: [Bug] SQLException when updating a non-OK outgoing batch on some database platforms (emiller)

0006013: [New Feature] Add :SOURCE_NODE_ID, :SOURCE_EXTERNAL_ID, and :SOURCE_NODE_GROUP_ID variables to column match routers (emiller)

0005788: [Bug] The source_table_name wildcard behavior does not match the documentation on the website (emiller)

0006011: [Bug] Do not attempt to "create or alter" triggers on SQL Server 2016 RTM (emiller)

0006010: [Improvement] Add exception message to logging when bulk loader fails and falls back to default loading (pmarzullo)

0006006: [Improvement] Prevent node from starting up if the sync.url is invalid (emiller)

0005976: [Bug] User is incorrectly warned that table is missing primary key (elong)

0005986: [Bug] Method that selects from sym_node_security is not synchronized (emiller)

0005984: [Bug] Fixed compatibility for other databases to insert/update into Sybase ASE Unitypes (jvanmeter)

0005983: [Improvement] Improve accuracy of CPU monitor (emiller)

0005980: [Improvement] MonitorService should use the dirty SQL template when selecting from sym_monitor_event (emiller)

0005971: [Bug] Loads fail when they include a table with a SQL Server uniqueidentifier column (emiller)

0005966: [Improvement] SQLAnywhere support for stream row (pmarzullo)

0001132: [Improvement] Support Postgres Special Floating Point Values Infinity, -Infinity, NaN

0005770: [Improvement] Use 600 series HTTP codes to distinguish from network devices (elong)

0006039: [Bug] CVE-2016-1000027 - /opt/symmetric-server/web/WEB-INF/lib/spring-web-5.3.27.jar

0005740: [Improvement] Have file sync make better use of staging (emiller)

0005857: [Bug] Security Vulnerability in Spring Framework and h2 database (elong)

0005840: [Improvement] Purge should use "exists" clause instead of "in" clause for performance (elong)

0002530: [Bug] postgresql infinity timestamp (JishLong)

0004034: [New Feature] Create tables based on target table name and column names set by routers and transforms (emiller)

0005545: [New Feature] Add support for H2 2.x and upgrade the H2 driver to the latest version (emiller)

0005641: [Improvement] Increase default db.pool.max.active connections to match what is needed for http.concurrent.workers.max (pmarzullo)

0005827: [Improvement] Track expired data gaps and repair any data missed by routing (elong)

0005778: [Improvement] Change timestamp size on sym tables with a timestamp as a primary key (cquamme)

0005784: [Improvement] Cache list of enabled nodes used by routing (elong)

0005792: [Improvement] Better logging when ack fail (elong)

0005835: [Bug] column name containing a "/" causes error (JishLong)

0005842: [Improvement] Purge retention for monitor events and console events (elong)

0005843: [Improvement] Change default push/pull to 10 seconds (elong)

0005860: [Improvement] Increase the statement query timeout (elong)

0005925: [Bug] Ignore Row Count not getting updated in outgoing batch table when a row is ignored (cquamme)

0005926: [New Feature] Adding a corresponding sym_outgoing_error table connected to sym_incoming_error (cquamme)

0005927: [Improvement] Use sym_outgoing_error table to ignore a row in outgoing batch (cquamme)

0002826: [Bug] Monitor event duplicate key when syncing (cquamme)

0003505: [Bug] SYM_TABLE_RELOAD_REQUEST is updated via DateTime which sometimes fails due to precision mismatch (elong)

0005960: [Improvement] Add support for NTEXT to SQLAnywhere dialect (pmarzullo)

0005961: [Bug] SQL Anywhere long varbit values are inconsistent between change data capture and initial load (pmarzullo)

0005955: [Bug] Sybase Anywhere - channel_id size Problem on auto-create triggers (emiller)

0005921: [Improvement] Adding Uni* type support to Sybase ASE (jvanmeter)

0005944: [Improvement] Adding log info for subselect routers (cquamme)

0005948: [Bug] KafkaDataWriter by ROW method has a trailing comma (jvanmeter)

0005937: [Improvement] SymmetricDS User Guide Incorrectly Referencing Table Column Name Which Dropped From 3.14 Release Already (elong)

0005932: [Improvement] Update docs on using environment variables in engines properties (modified summary) (cquamme)

0005942: [Bug] SQLAnywhere DDL problems with dropping indexes and triggers, and trigger syntax issue for version 11 and earlier (pmarzullo)

0005935: [Bug] Failed to execute IHeartbeatListener PushHeartbeatListener java.lang.NullPointerException When Starting up SymmetricDS (elong)

0005934: [Bug] Getting null pointer from Column.java in new method anyPlatformColumnTypeContains on platformColumns (chenson)

0001180: [New Feature] Add option to symadmin --send-sql to specify a file containing the sql to send. (JishLong)

0005931: [Bug] log.slow.sql.threshold.millis and log.sql.parameters.inline parameters do not work and are not documented (emiller)

0001063: [Improvement] Add export-config and import-config command line options to symadmin (JishLong)

0005651: [Bug] Row in sym_table_reload_status can have incorrect values for completed, data_batch_loaded and finalize_batch_loaded (pmarzullo)

0005906: [Bug] Non transactional initial load setup can cause load events to be missed ini table_reload_status (pmarzullo)

0005834: [Bug] Unnamed constraint causes alter table error (JishLong)

0005848: [Bug] Security Vulnerbility in Spring Framework (elong)

0005886: [Improvement] Monitor enhancements for centralized support (josh-a-hicks)

0004952: [Bug] Cannot resolve monitors of type log (emiller)

0005893: [Improvement] DbCompare should write to standard error and not continue with an invalid date-time format (cquamme)

0005922: [Improvement] Added debug logging to File Sync Trigger Tracker (jvanmeter)

0005901: [Bug] DBCompare produces output SQL with invalid syntax (cquamme)

0005903: [Bug] Failing to create trigger on table (pmarzullo)

0005913: [Bug] Update postgres documentation on how to give access to schemas for a SymmetricDS user (pmarzullo)

0005915: [Bug] Cannot Install swaggerui module by using symadmin ModuleManager (pmarzullo)

0005865: [Bug] Estimated count from initial load does not work with SqlServer when using different schema than dbo (JishLong)

0005909: [Improvement] Some methods are synchronized unnecessarily in AbstractParameterService (cquamme)

0005907: [Improvement] Postgres support for ddl table creations with a default function on a GUID from MSSQL (josh-a-hicks)

0005885: [New Feature] MSSQL support for hierarchyid data types (josh-a-hicks)

0005904: [Bug] LOB data does not sync when sending a load with use_stream_lobs=1 (emiller)

0005894: [Bug] NotificationTypeEmail's deserializeOfflineNodes method always returns empty collection (cquamme)

0005897: [Bug] ValidatorException while validating self-signed X509 certificate (emiller)

0005892: [Bug] DbCompare fails to write comparison SQL for timestamp with timezone values (cquamme)

0005884: [New Feature] Add job monitor (emiller)

0005880: [Bug] Transform documentation missing Java Column Transform Type (pmarzullo)

0005873: [Improvement] Open Registration in Rest API doesn't allow user to specify node if 2 nodes have the same external ID (cquamme)

0003476: [Improvement] When a node is unregistered cancel all jobs / threads that are actively doing work for that node (JishLong)

0000706: [Improvement] Make sleep time between registration retries configurable (JishLong)

0005869: [Improvement] Improve documentation of sym_node_group_link.sync_config_enabled (emiller)

0005314: [Bug] Infinite synchronization loop when 3 nodes are connected to each other and sync_on_incoming_batch = 1 (emiller)

0005867: [Bug] Prevent file sync from syncing all files when first scanning a directory when initial load is enabled (emiller)

0005863: [New Feature] Add option to send additional batch error notifications when the number of batches in error increases (emiller)

0002260: [Improvement] Also sync the stored procedures with the schema (emiller)

0004151: [Bug] MSSQL DDL ERROR: View / function / stored procedure (emiller)

0005853: [Improvement] sym_monitor_event trigger should capture changes when monitor.events.capture.enabled=true even if auto.sync.configuration=false (emiller)

0005847: [Improvement] Try again when foreign key correction fails (emiller)

0005836: [Improvement] Specify jaxb api and implementation so that libraries will be available when running in Java 8 through 17 (pmarzullo)

0005565: [Improvement] Adding Character Set to Snapshot (cquamme)

0005812: [Improvement] MathColumnTransform uses Evaluator that is not thread-safe (cquamme)

0005805: [Improvement] Allow specification of database platform of symmetric when DbDxport execution with load only/extract only/log miner (pmarzullo)

0005782: [Improvement] Unique Index with Multiple Nulls not Properly Handled for Certain Databases (jvanmeter)

0005815: [Improvement] DDL Capture Changes - Three enhancements to DDL trigger capture (josh-a-hicks)

0005780: [Improvement] Slow routing when using $(targetExternalId) variable (elong)

0005790: [Improvement] Failed to decrypt node password from lost secret key in keystore (elong)

0005791: [Bug] Allow registration of other nodes after registration and initial load is complete (elong)

0005817: [Improvement] Snapshot util not returning (elong)

0004310: [Bug] Replicating to postgres to postgres timestamp with default

0005803: [Bug] Interbase fixes: failing to have prepared statement indicators in set and select portion of SQL statements (pmarzullo)

0005831: [Improvement] Sync triggers by $(targetExternalId) and call after registration (elong)

0005781: [Bug] DBCompare --use-sym-config true (cquamme)

0005779: [Improvement] Improve docs on db.init.sql property (emiller)

0005828: [Bug] Class Not Found Exception when connecting to Redshift (cquamme)

0005823: [Improvement] Capture timings when running Sync Triggers (pmarzullo)

0005826: [Bug] Data can become misaligned with column names during extraction after a column gets renamed (emiller)

0005822: [Bug] SQL Server create or alter trigger fails when table is not in default schema (dbo) (pmarzullo)

0005810: [Improvement] Redshift Bulk Loader increased versioning and dependencies (josh-a-hicks)

0005809: [Bug] NullPointerException when writing a delete to Kafka when old data has not been captured (emiller)

0005811: [Bug] When Capture of Old Data is disabled, Deletes get an Index Out Of Bounds Error with Kafka (jvanmeter)

0005766: [Bug] NPE when inserting into sym_incoming_batch on some platforms (emiller)

0005807: [Bug] Sybase ASE gets Misinterpreted as Sybase SQL Anywhere (jvanmeter)

0005799: [Bug] 3 tier deployment, 3rd tier does not get top level tier sym_node* tables (pmarzullo)

0005802: [Bug] SQL Server and Sybase stream row on updates trigger syntax issue (pmarzullo)

0005800: [New Feature] Add a gradle task that generates javadoc and publishes it to the website (emiller)

0005783: [Improvement] SymmetricDS seems to require Postgres 11, but the docs don't reflect that (emiller)

0005774: [New Feature] Support for capturing the row identifier on various platforms if available (default is false) (josh-a-hicks)

0005775: [New Feature] File sync batches to provide file name as the summary in outgoing and incoming batch. (josh-a-hicks)

0005765: [Improvement] Add quotation marks around values in threads-stats.csv file in support snapshot (emiller)

0005757: [New Feature] Add server parameter for setting a server's cookie name (cquamme)

0005753: [Improvement] Reopening registration should reset the failed login count (emiller)

0005752: [Improvement] Add support for H2 2.x (emiller)

0005825: [Bug] Data can become misaligned with column names during extraction after a column gets renamed (emiller)

0005613: [Bug] When upgrading from a varchar(xxx) to longvarchar the change isn't detected on H2 (emiller)

0005754: [Improvement] Reopening registration should reset the failed login count (emiller)

0005745: [Improvement] Read max-size VARCHAR columns as LONGVARCHAR columns on H2 (emiller)

0005717: [Bug] SQL Server DDL Builder needs to handle objects in different databases (pmarzullo)

0005710: [Bug] When connecting to Azure, set platform version to SQL Server 2016 (pmarzullo)

0005746: [Bug] When upgrading from a varchar(xxx) to longvarchar the change isn't detected on H2 (emiller)

0005737: [Bug] Serve Time Offsets Causing an Error in Determining if a Node is Offline (jvanmeter)

0005747: [Improvement] Read max-size VARCHAR columns as LONGVARCHAR columns on H2 (emiller)

0005742: [Improvement] Table sorting does not need to include sym tables (josh-a-hicks)

0005657: [Bug] SQLAnywhere CHAR is really a VARCHAR and should be mapped to VARCHAR for other dialects (emiller)

0003952: [Bug] Order table creation by foreign key dependency (pmarzullo)

0005722: [Bug] Tries to create foreign key before creating the referenced table (pmarzullo)

0005723: [Bug] The schema of the table that is being created is used instead of correct one when creating a foreign key (emiller)

0005721: [Bug] Query tries to address mixed-case column without quotes (Postgres) (pmarzullo)

0005731: [Bug] Functional indexes are only supported by Oracle (pmarzullo)

0005728: [Improvement] AbstractSymmetricEngine.isConfigured() should use the cache when querying for sym_node table (pmarzullo)

0005729: [Bug] DBImport- Allow the UI specification of the catalog and schema to override the catalog and schema specs in XML imported file (pmarzullo)

0005724: [Bug] SQL Server timestamp (rowversion) data type can not specify column size (pmarzullo)

0005720: [Improvement] sym_node trigger should capture changes even if auto.sync.configuration is set to false (pmarzullo)

0005718: [Bug] SQL Server DDL Builder needs to handle objects in different databases (pmarzullo)

0005711: [Bug] When connecting to Azure, set platform version to SQL Server 2016 (pmarzullo)

0005698: [Bug] Data truncation error when inserting/updating log event in sym_monitor_event on Interbase (emiller)

0005702: [Bug] Missing image in Manage Incoming Loads (pmarzullo)

0005699: [Bug] Missing image in Manage Nodes Load Data Where Clauses (pmarzullo)

0005700: [Bug] Grammar error (double word) in Manage Logging documentation (pmarzullo)

0005692: [Bug] Pulling corrupted batch gets null pointer in loop (elong)

0005693: [Bug] Fix multiple active trigger histories before sync triggers is run (pmarzullo)

0005675: [Improvement] Bidirectional sync causes need for trigger to be re-built on target side if table does not exist (cquamme)

0005686: [Bug] MariaDB JDBC Driver version 3 does not support a negative fetch size to indicate the use of streaming (pmarzullo)

0005679: [Bug] Extract fails with durationMillis must not be negative (elong)

0005671: [Improvement] Bring back java routers (emiller)

0005673: [Improvement] Sync triggers fails with deadlock on SQL-Server (elong)

0005593: [Bug] Incorrect Logic in various DDLBuilders for Processing Changes (cquamme)

0005664: [Bug] Tables are altered incorrectly on some platforms when their columns need to be made required or non-required (emiller)

0005663: [Improvement] Add table reload request to REST service (elong)

0005662: [Improvement] Snapshot util too slow for large multi-tenant deployment (elong)

0005636: [Improvement] Only cancel a full load in progress if the reload select is empty (josh-a-hicks)

0005598: [Bug] Sql Anywhere Drop Trigger (josh-a-hicks)

0005691: [Bug] Pulling corrupted batch gets null pointer in loop (elong)

0005685: [Bug] MariaDB JDBC Driver version 3 does not support a negative fetch size to indicate the use of streaming (pmarzullo)

0005676: [Bug] Initial load sends too many tables when using $(targetExternalId) variable (elong)

0005678: [Bug] Extract fails with durationMillis must not be negative (elong)

0005672: [Improvement] Sync triggers fails with deadlock on SQL-Server (elong)

0005659: [Improvement] Snapshot util too slow for large multi-tenant deployment (elong)

0005654: [Bug] sym_node_host trigger should capture changes even if auto.sync.configuration is set to false (pmarzullo)

0005652: [New Feature] Improve SQL Server DDL triggers and add DDL triggers for Oracle and Postgres (emiller)

0005655: [Bug] sym_node_host trigger should capture changes even if auto.sync.configuration is set to false (pmarzullo)

0005650: [Improvement] Problems replicating DDL to another node with the same database type but different database version (emiller)

0005648: [Improvement] Add "open registration" call to REST service (elong)

0005645: [Bug] Registration redirect URL does not have query parameters for older versions of SymmetricDS clients (pmarzullo)

0005646: [Bug] DBExport incorrectly formats time data (emiller)

0005640: [Bug] Filtering transactions for snapshot gets stack overflow error and never finishes creating snapshot (pmarzullo)

0005638: [Bug] Flush cache of routers when a router is changed (elong)

0005625: [Bug] Stack overflow while extracting batch containing a table removed from replication (elong)

0005610: [Improvement] SqlAnywhere support for v. 12 and higher (josh-a-hicks)

0005631: [Improvement] Full load request does not support a reload select statement (josh-a-hicks)

0005635: [Bug] Single Store extends MySQL dialect but does not need to check for an "innodb" engine (josh-a-hicks)

0005630: [Improvement] When deleting FK child rows during conflict resolution and old_data is null, query for the parent row on the target (emiller)

0005624: [Bug] Deletes get ignored when foreign key children exist but cannot be found (emiller)

0004424: [Improvement] Log monitor fails to insert because of duplicate key when logs are shared across instances of a node (pmarzullo)

0005597: [Bug] SymDS is not syncing specific record during initial load (pmarzullo)

0005619: [Bug] Insert statements generated by DBExport contain question marks when there are null values (emiller)

0005611: [Bug] Check sync URL ends with engine name or "sync" (elong)

0004168: [Improvement] SQL-Server capture rows that exceed 4000 characters (pmarzullo)

0005508: [Bug] Multiple active trigger history for same table (elong)

0005517: [Bug] Empty string default values not syncing to target (pmarzullo)

0005521: [Bug] Create trigger hist if routing can't find it (elong)

0005527: [Bug] Cannot set up SQL Server log-based replication without "ALTER ANY DATABASE" permission (emiller)

0005540: [Bug] Apache commons-text version 1.9 security vulnerability (pmarzullo)

0005573: [Bug] Unique index on function causes error when resolving a conflict (elong)

0005578: [Bug] Script error from newer wins conflict resolution with old nodes (elong)

0005584: [Bug] Trigger creation fails when 2 new triggers have trigger IDs that are identical when shortened (pmarzullo)

0005594: [Bug] Failure to Flush when using ConvertToReload router. (jvanmeter)

0005509: [Bug] Multiple active trigger history for same table (elong)

0005522: [Bug] Create trigger hist if routing can't find it (elong)

0005525: [Bug] Unsupported Postgresql data types

0005528: [Bug] Cannot set up SQL Server log-based replication without "ALTER ANY DATABASE" permission (emiller)

0005530: [Bug] Multi-homed clustered nodes stuck in loop of retry and resend of batches (elong)

0005518: [Improvement] Updating KafkaDataWriter to work with Filters (jvanmeter)

0005539: [Improvement] Support for a default value to generate a GUID using built in function on table creation (josh-a-hicks)

0005541: [Bug] Apache commons-text version 1.9 security vulnerability (pmarzullo)

0005543: [Bug] Initial load error on MySQL with parameter db.treat.date.time.as.varchar.enabled=true (elong)

0005556: [Bug] SQL-Server capture rows that exceed 4000 characters (pmarzullo)

0005574: [Bug] Unique index on function causes error when resolving a conflict (elong)

0005579: [Bug] Script error from newer wins conflict resolution with old nodes (elong)

0005585: [Bug] Trigger creation fails when 2 new triggers have trigger IDs that are identical when shortened (pmarzullo)

0005595: [Bug] Failure to Flush when using ConvertToReload router. (jvanmeter)

0005602: [Bug] Parse exception of batch should remove it from staging (elong)

0005519: [Improvement] Updating KafkaDataWriter to work with Filters (jvanmeter)

0005463: [Bug] Initial load of a table with a self referencing FK will not load if out of order (josh-a-hicks)

0005604: [Improvement] Check sync URL ends with engine name (elong)

0003313: [New Feature] Propagate default GUID from MSSQL to SQLITE (emiller)

0003545: [Bug] Mapped default values lead to always detecting a model change (emiller)

0005507: [Bug] Postgres LOCALTIMESTAMP function gets surrounded by quotes when imported as a default value (emiller)

0005510: [Bug] Multiple active trigger history for same table (elong)

0005511: [Bug] Error request path not supported for /server/config (elong)

0005512: [Bug] Default values for Oracle RAW columns get surrounded by quotes when exported (emiller)

0005513: [Bug] SQL Server GETDATE() and GETUTCDATE() functions get surrounded by quotes when imported as default values (emiller)

0005514: [Bug] SQL Server sysname type should not have its size specified (emiller)

0005515: [Improvement] When installing service for systemd, make sure to specify absolute path to java executable when creating systemd control file (pmarzullo)

0005520: [Improvement] Acknowledgement gets null SQL message (elong)

0005523: [Bug] Create trigger hist if routing can't find it (elong)

0005524: [New Feature] Adding New Monitor Types For OS Load Average and OS Open File Handles (cquamme)

0005526: [Improvement] Default max batch to send as 10 (elong)

0005529: [Bug] Cannot set up SQL Server log-based replication without "ALTER ANY DATABASE" permission (emiller)

0005531: [Bug] Multi-homed clustered nodes stuck in loop of retry and resend of batches (elong)

0005535: [Improvement] Improve how default values are handled when syncing DDL cross-platform (emiller)

0005536: [Improvement] Add support for Postgres' inet, cidr, macaddr and macaddr8 data types (emiller)

0005544: [Bug] Initial load error on MySQL with parameter db.treat.date.time.as.varchar.enabled=true (elong)

0005547: [Improvement] Treat any default value that contains "()" as a function (emiller)

0005551: [New Feature] Add parameters that specify how to sync default values (emiller)

0005553: [Improvement] Allow spaces in values within value map column transform expression (emiller)

0005554: [Bug] Example 25 in User Guide is missing permissions (emiller)

0005557: [Bug] SQL-Server capture rows that exceed 4000 characters (pmarzullo)

0005558: [Improvement] Create table without defaults if in error (elong)

0005563: [Improvement] Add functionality to symadmin export-sym-tables to export alters when upgrading (pmarzullo)

0005570: [New Feature] Add engine name and server name variables to notification templates (emiller)

0005571: [Bug] Unique index on function causes error when resolving a conflict (elong)

0005580: [Bug] Script error from newer wins conflict resolution with old nodes (elong)

0001960: [Improvement] Service start script always waits for 5s (elong)

0003109: [Bug] File replication routing job fails with error message when channel is not a file sync channel - needs better error message (emiller)

0005542: [Bug] Apache commons-text version 1.9 security vulnerability (pmarzullo)

0005560: [Bug] ORA-06502: PL/SQL: numeric or value error: character string buffer too small (elong)

0005582: [Bug] Database Platforms That Don't Support SQL Queries Throw Error with SQL Explorer (cquamme)

0005583: [Improvement] Service wrapper wait for "started" message instead of 5 second timeout (elong)

0005586: [Bug] Trigger creation fails when 2 new triggers have trigger IDs that are identical when shortened (pmarzullo)

0005596: [Bug] Failure to Flush when using ConvertToReload router. (jvanmeter)

0005603: [Bug] Parse exception of batch should remove it from staging (elong)

0005605: [Improvement] Parameter that alters table case should be for cross platform only (elong)

0005606: [Improvement] CPU monitor top threads should ignore threads waiting on I/O (elong)

0005456: [Bug] ORA-24816 when sync varchar2(4000) and long in same table (elong)

0005452: [Improvement] Backup keystore before saving it (elong)

0005438: [Bug] Conflict resolver fails if there are no primary keys on the target and it is set to not use primary keys from source (jvanmeter)

0005457: [Bug] Cannot write to more than one Kafka instance in a single instance of SymmetricDS (jvanmeter)

0005485: [Improvement] Ignore missing tables on config channel (elong)

0005488: [Improvement] Support snapshot fixes (elong)

0005491: [Improvement] Table reload request with "where" keyword gets error (elong)

0005494: [Bug] Batch error missing method sendMissingForeignKeyRowsForLoad (elong)

0005500: [Bug] Registration left pending when client is 3.12 or newer and server is 3.11 or older (elong)

0000765: [Improvement] Create table DDL and dbexport / dbimport should support generated / calculated / computed / virtual columns (emiller)

0005433: [Improvement] Sync triggers when parameters change that affect triggers (elong)

0005502: [Bug] Fix json deserialization issue with log summary object (josh-a-hicks)

0000697: [Task] Document the --client option in the User Guide. I've been told it is useful ;-) (elong)

0000922: [Bug] Float used on table without primary causes update to not capture (emiller)

0001753: [Bug] Default values that are functions do not work while creating tables in MySQL (emiller)

0003251: [Bug] Mysql BIGINT UNSIGNED processed as signed and gives error on larger than 63 bits numbers. (emiller)

0004116: [Bug] Syncing from Time to Timestamp (or vice versa) in Postgres produced inaccurate values (emiller)

0005392: [Bug] Unable to write to sym_outgoing_batch when using Postgres (elong)

0004295: [Bug] Detect when the order of a primary key changes in order to regenerate it (elong)

0004335: [Bug] Multiple transform_table rows per source table cause multiplication of rows in outgoing batch (elong)

0004514: [Bug] DbCompare: The output script to fix issues on the target does not support null values. (emiller)

0005427: [New Feature] Creating a Parameter That, Upon Registration, Will Automatically Create A Group Link Between Nodes if None Exist (cquamme)

0005430: [Bug] Android not implemented exception when sym_monitor syncs (elong)

0005431: [Improvement] Install triggers on registration server before configuration is complete (elong)

0005435: [Bug] NumberFormatException when querying for an integer greater than Long.MAX_VALUE in SQL Explorer (emiller)

0005436: [Bug] Sybase ASE issues when upgrading SymmetricDS from an older version to 3.14.* (pmarzullo)

0005439: [Bug] Conflict resolver fails if there are no primary keys on the target and it is set to not use primary keys from source (jvanmeter)

0005440: [Improvement] Change parameter treat.binary.as.lob.enabled to default to false (elong)

0005441: [Bug] Windows service won't start if tmp dir has trailing slash (elong)

0005449: [Improvement] Add SOURCE_NODE_ID_FROM_DATA to VariableColumnTransform to allow using the source_node_id from the data (pmarzullo)

0005450: [Improvement] Routing default batch algorithm protection against large transactions (elong)

0005453: [Improvement] Backup keystore before saving it (elong)

0005459: [Improvement] Adding Log Info For Queries for Lookup Table Routers (cquamme)

0005460: [Bug] Cannot write to more than one Kafka instance in a single instance of SymmetricDS (jvanmeter)

0005464: [Improvement] Parameter to use old conflict pk detect and fallback (elong)

0005476: [Improvement] Ability to disable sync triggers when sync on incoming is enabled (elong)

0005477: [Bug] Some default values do not sync correctly from Oracle to Oracle (emiller)

0005481: [Improvement] Cast TEXT types in MS SQL to VARCHAR for SymmetricDS tables (elong)

0005483: [Improvement] Cast TEXT to VARCHAR for all tables (elong)

0005486: [Improvement] Ignore missing tables on config channel (elong)

0005487: [Improvement] Support snapshot fixes (elong)

0005492: [Improvement] Table reload request with "where" keyword gets error (elong)

0005495: [Bug] Batch error missing method sendMissingForeignKeyRowsForLoad (elong)

0005472: [Bug] When a load filter changes catalog or schema the DML statement is not recreated with the updated values (josh-a-hicks)

0005496: [Improvement] Cast varchar to nvarchar (elong)

0005497: [Bug] NPE when running DbFill on a table with a foreign key that references a table in another catalog or schema (emiller)

0005501: [Bug] Registration left pending when client is 3.12 or newer and server is 3.11 or older (elong)

0005503: [Bug] New config tables are being routed to old nodes (elong)

0005504: [Bug] Oracle DATE type should not have its size specified (emiller)

0005505: [Bug] Oracle TO_TIMESTAMP() function gets surrounded by quotes when imported as a default value (emiller)

0003845: [Bug] Primary key constraint violation while replicating single table from MSSQL 2017 into PostgreSQL 9.6 (pmarzullo)

0004191: [Bug] dbexport: MSSQL geometry -> PGSQL varchar(2147483647); better would be TEXT (emiller)

0005389: [New Feature] Implement conflict_win_count and conflict_lose_count columns in sym_outgoing_batch and sym_incoming_batch (emiller)

0004001: [Bug] Default value being passed as string for MS Sql Server (emiller)

0004090: [Bug] Firebird ddl/schema problem when creating tables and deferring constraints (emiller)

0001282: [Bug] MySQL outputs schema with DEFAULT '0000-00-00' that is not compatible (emiller)

0005385: [Bug] Snapshots do not contain log files when the files are in a non-default location specified in log4j2.xml (emiller)

0000140: [Improvement] Check to see that the SymmetricDS tables are created to use the Innodb storage engine on MySQL. (emiller)

0005393: [Bug] MySqlDdlReader.getTriggers() throws SQLException when MySQL database name contains special character (emiller)

0005421: [Bug] Initial load won't start if registration_enabled is 1 (elong)

0005395: [Bug] H2 database (or load only database) gets alter timestamp(0) every time starting (elong)

0001421: [Bug] DbFill error arithmetic overflow error with money data type (emiller)

0003961: [Bug] Oracle XMLTYPE incorrectly mapped to invalid SQL Type SQLXML in MariaDB (emiller)

0002821: [Bug] dbcompare attempts to insert null into "not null default ..." field (emiller)

0003960: [Bug] NVARCHAR2() maps incorrectly to VARCHAR() when mapping from Oracle to MariaDB (emiller)

0003419: [Bug] MS SQL -> SQLite, don't translate "NEXT VALUE FOR" default value (emiller)

0003964: [Bug] Oracle's REAL datatype should map to DOUBLE in MariaDB, not FLOAT (emiller)

0003965: [Bug] Oracle's LONG type is incorrectly mapped to MariaDB's MEDIUMTEXT. Should be LONGTEXT (emiller)

0003966: [Bug] Oracle's CLOB (and NCLOB) type incorrectly maps to MariaDB's MEDIUMTEXT (emiller)

0003999: [Bug] Unable to translate default column for (new sequentialid()) (very easy fix) (emiller)

0004134: [Bug] DB Compare does not handle Oracle Timestamp with LOCAL time zone columns properly (emiller)

0004217: [Bug] Does not replicate index with upper function on PostgreSQL (emiller)

0005388: [Bug] Initial load delete or truncate with table transform (elong)

0004567: [Bug] sync.table.prefix parameter ignores for sequence in PostgreSQL (emiller)

0004667: [Bug] dbcompare prints each table multiple times (emiller)

0005106: [Bug] The PostgreSQL database cannot be synchronized under the USE_CHANGED_DATA and manual resolution strategy (emiller)

0005406: [Bug] Deleting a trigger doesn't inactivate its sym_trigger_hist entry when auto.sync.triggers.after.config.change=true (emiller)

0005413: [Bug] Bulk loaded flag is not being read from database for incoming and outgoing services (josh-a-hicks)

0005414: [Bug] JDBC Bulk Transactions Fallback While Using PostgreSQL (cquamme)

0005415: [Improvement] Detection of MSSQL Azure Managed Instance (josh-a-hicks)

0005416: [Improvement] Allow users to disable spatial data type support functions (josh-a-hicks)

0005417: [Bug] Fix NPE for conflict detection when table does not have a PK and all columns used including those with null values (josh-a-hicks)

0005422: [Task] Update IReloadListener example in user guide (emiller)

0005425: [Bug] Tables not created on reverse initial load (elong)

0005381: [Bug] [Postgres Data replication fails] ERROR: column "address" is of type inet but expression is of type character varying

0005386: [Improvement] Change index.html to redirect / to /app/ to minimize redirects through load balancers (pmarzullo)

0005387: [Bug] Initial load delete or truncate with table transform (elong)

0005347: [Bug] Incorrect implement in geometry type (emiller)

0005368: [Bug] DDL detects change in column data type for DATE on Oracle (elong)

0005370: [Bug] Send schema DDL detects widened varchar but does not alter (elong)

0005375: [Bug] Entire batch is ignored in PostgreSQL in case of error (emiller)

0005384: [Bug] Snapshots do not contain log files when the files are in a non-default location specified in log4j2.xml (emiller)

0005405: [Bug] Deleting a trigger doesn't inactivate its sym_trigger_hist entry when auto.sync.triggers.after.config.change=true (emiller)

0005401: [Bug] Since SymmetricDS version 3.13.5 MsSQL sync create tables in uppercase (emiller)

0005418: [Bug] Virtual Trigger Routers created for SymmetricDS tables do not make sure that the router ID is unique (pmarzullo)

0005423: [Bug] JDBC Bulk Transactions Fallback While Using PostgreSQL (elong)

0005424: [Bug] Tables not created on reverse initial load (elong)

0004201: [Bug] Failed to create update trigger for triggers that use and external_select with $(curTriggerValue) (pmarzullo)

0005437: [Bug] Conflict resolver fails if there are no primary keys on the target and it is set to not use primary keys from source (jvanmeter)

0004633: [Bug] Tables not created on reverse initial load (elong)

0005383: [Bug] Snapshots do not contain log files when the files are in a non-default location specified in log4j2.xml (emiller)

0005390: [Bug] Initial load delete or truncate with table transform (elong)

0005398: [Bug] Batch Locking issue when exceptions occur during locking (semaphore and batch file locking) (pmarzullo)

0005269: [Improvement] Variables of source catalog/schema names for use in target catalog/schema fields in routing (elong)

0002254: [Bug] sym_outgoing_batch and sym_incoming_batch should both use the same time for last_update_time and create_time (emiller)

0005157: [Improvement] Sybase and SQL Server update trigger should be made more efficient generating sym_data records when primary keys are changed (pmarzullo)

0005198: [Improvement] Clean up the consistent use of table constants for registration, trigger installation, extract, and export (elong)

0003724: [Bug] Conflict detection with Timestamps between DB2 and Derby (elong)

0005239: [Bug] Conflict resolution doesn't work if timestamp is in PK and different fractional second precision between databases (elong)

0004525: [Bug] Database name with special character like minus sign, fails to create trigger (emiller)

0002180: [Bug] H2 timestamp format creates conflict against ORACLE timestamp format (elong)

0003941: [Improvement] Data gap route reader could use multiple queries when exceeding max gaps (elong)

0005210: [Improvement] Routing reader may use multiple queries for a large number of gaps (elong)

0002972: [Improvement] Registration order of nodes should not matter (elong)

0005138: [Improvement] Build a cache manager to centralize the handling of data caches (pmarzullo)

0002261: [Bug] Schema from Postgres outputs TIMESTAMPTZ that is not compatible with other databases (elong)

0003778: [Bug] Send table fails when sending H2 Timestamp to MySQL (elong)

0003962: [Bug] Oracle's TIMESTAMP with Time Zone doesn't map to MariaDB (elong)

0003963: [Bug] char(n) and nchar(n) where n>255 is valid in oracle but maps to invalid types in MariaDB (elong)

0004298: [Bug] Sycing schemas from MSSQL with column type CHAR(400) to MySQL fails (elong)

0004723: [Improvement] Send column with Oracle DATE type to PostgreSQL (elong)

0004724: [Improvement] Send column with timestamp datatype from PostgreSQL to PostgreSQL (elong)

0005122: [Bug] Wrong conversion from mssql datetime(7) to mysql/mariadb (elong)

0005140: [Task] Upgrade to gradle version 7.4.2 (pmarzullo)

0005178: [New Feature] Push registration to nodes when group links indicate push (elong)

0005180: [New Feature] Schedule registration of a node for a window of time (elong)

0005203: [Improvement] Sync incoming load details to target node (table_reload_status, extract_request) (elong)

0005238: [Improvement] Bulk loaders should report missing table (elong)

0005243: [Bug] Change documentation on outgoing batch errors to set the status to 'IG' instead of 'OK' so target will get notified (pmarzullo)

0005265: [Improvement] Update drivers, modules, and libraries (emiller)

0005278: [Improvement] Alphabetize list of tables in user guide (emiller)

0005280: [Improvement] Table DDL with timestamp and fractional second precision (elong)

0005304: [Bug] Snapshot Fails to Find SingleStore Enum (cquamme)

0005305: [Bug] SingleStore Snapshot: Failed to execute SQL Error (cquamme)

0005306: [Bug] SingleStore Snapshot: 'Table 'sym_outgoing_batch' doesn't exist' (cquamme)

0005308: [Bug] Unable to Retrieve Database Time for Load-Only and Log-Based (cquamme)

0005309: [Improvement] Prepare for Gradle upgrade to version 8 (pmarzullo)

0005351: [Improvement] Use PKCS12 for keystore by default (elong)

0005353: [Improvement] Add gpg code signing to jar files (emiller)

0005364: [Improvement] Always execute shutdown hooks, even for embedded and war deployments (pmarzullo)

0005376: [Improvement] Parameter to disable logging of application data from a batch error (elong)

0005341: [New Feature] Add system property to control use of "on conflict" on Postgres (elong)

0005045: [Task] Errors in "ON CONFLICT " - need a new parameter (elong)

0004975: [Bug] insert with on conflict clause cannot be used with table that has insert or update rules (elong)

0005340: [Bug] Wrong character in document (emiller)

0003295: [Bug] Sync from MySql to MSSql initial load - table create fails on Decimal Precision when MySQL precision is more than 38 (elong)

0005329: [Bug] Sync triggers on selected tables without primary key gets trigger hist without primary key columns (elong)

0005333: [Bug] Oracle log mining throwing exception when finding mismatched LOB record in log mining result set (pmarzullo)

0005334: [Bug] Server not trusted when sending email (elong)

0005343: [Bug] Mathematical transform turns an integer into a decimal when the result has 8 or more digits (emiller)

0005349: [Improvement] Substring Transform support for all spaces (josh-a-hicks)

0005350: [Bug] Conflict resolution based on newer wins with transforms (josh-a-hicks)

0005162: [Bug] Keystore becomes invalid after Generating and adding a new Keypair (elong)

0002423: [Bug] Create table with max varchar supported by target (emiller)

0005272: [Bug] Conflict Resolution of deletes of parent records fail to delete child records when child tables have no primary keys (pmarzullo)

0005273: [Bug] Rebuild trigger does not take into account the target platform (pmarzullo)

0005274: [Bug] Prevent "Failed to get hash code for field delimiter" warning message for SQL Server (emiller)

0005279: [Bug] FK correction for self referencing table. (josh-a-hicks)

0005285: [Bug] Create tables xml needs to escape double quotes on the database type (josh-a-hicks)

0005289: [Bug] Method in AbstractSqlTemplate Causes Recursive Looping with Android (elong)

0005313: [Bug] Null default values become string values when replicating tables from Oracle to MariaDB (elong)

0005318: [Bug] Conflict resolution batch with token parsing error when newlines in data (elong)

0005320: [Improvement] Use unique index for PK column names in trigger hist when table is missing primary key (elong)

0005321: [Bug] SymmetricDS Not Properly Handling Unable to Write Batch to Kafka Error (jvanmeter)

0005327: [Bug] Upgrade spring and okhttp (elong)

0005200: [Improvement] Allow specification of local user/password for running Windows service (pmarzullo)

0005213: [New Feature] Allow to save startup parameters in local keystore or in Azure Key Vault (pmarzullo)

0005260: [Bug] Sybase ASE with 2k page file fails to create SYM tables (600 is the maximum allowable size of an index.) (elong)

0005194: [Bug] DBCompare support for load only target nodes and log based source nodes. (josh-a-hicks)

0005204: [Improvement] MSSQL support for engine edition (josh-a-hicks)

0005214: [Bug] Column count error when load transform falls back to an insert with a column that is included on insert only (emiller)

0005216: [Bug] Metadata error can skip data when using dataloader.ignore.missing.tables parameter (elong)

0005255: [Bug] Monitor doesn't run when its type requires a cluster lock and it's supposed to run less often than the monitor job (emiller)

0005263: [Bug] CVE-2022-22965: Spring Version needs to use 5.2.20.RELEASE or 5.3.18 in order to not be vulnerable to this security issue (pmarzullo)

0005264: [Bug] Update any driver, module, or library that has a security vulnerability or serious defect (emiller)

0005242: [Bug] DataGapFastDetector- needs to make sure that we find the last gap that is really the last gap (pmarzullo)

0005196: [Bug] "There are SymmetricDS tables that needed altered" on every start-up on Derby (emiller)

0002450: [Improvement] Preserve datetime precision, support for nanoseconds (elong)

0005207: [Bug] Multi-tenant SymmetricDS instance fails to allow User Interface to function when some engines fail to start (pmarzullo)

0005248: [Bug] CVE-2022-22965: Spring Version needs to use 5.2.20.RELEASE or 5.3.18 in order to not be vulnerable to this security issue (pmarzullo)

0005175: [Bug] JdbcBatchBulkDatabaseWriter only uses one record in the batches for deletes, and fails on record 10000 (pmarzullo)

0005164: [Bug] Duplicate entry on file sync (pmarzullo)

0005123: [Bug] ASE, ASA, and MSSQL support for stream lob optimizations (josh-a-hicks)

0005169: [Bug] Tibero reading of indexes fails when index is in another schema (pmarzullo)

0005177: [Bug] File Sync fails to create zip file when modify, followed by delete, followed by create is captured and sent in same batch (pmarzullo)

0005190: [Bug] Upgrade log4j2 again again (elong)

0004978: [Bug] Binary primary keys will not delete as part of conflict resolution (josh-a-hicks)

0005102: [Bug] Interbase Table SYM_TEMP_CONTEXT (elong)

0005113: [Bug] Data mapping is incorrect on an insert fallback to update potentially when column count on target is not the same as row data (josh-a-hicks)

0002970: [Bug] db connection leaks after engine stop (pmarzullo)

0003119: [Bug] Stopping service breaks connections with error in Interbase logs (pmarzullo)

0003382: [Bug] MV-Store DB corrupt after stopping SymmetricDS replication software (pmarzullo)

0003563: [Improvement] Purging large number of extract requests, query time out (elong)

0003897: [Improvement] Cleanly exit all job threads when engine is stopped (pmarzullo)

0004800: [Improvement] Subselect router expression improvement (elong)

0004955: [Improvement] Ignore batch status is sometimes overwritten (elong)

0004958: [Improvement] Initial load select boolean directly without template (elong)

0004993: [Improvement] Remove "databases" sub-directory (elong)

0004995: [Improvement] Upgrade Gradle to latest possible version (emiller)

0005013: [Bug] Registration server config_version not updating (elong)

0005015: [New Feature] Speed up start up by only checking tables when version changes (elong)

0005059: [Bug] var_row_data is defined as mediumtext (rudiejd)

0005098: [Improvement] Auto sync triggers at startup parameter default off and option to force rebuild (elong)

0005099: [New Feature] Purge trigger history (elong)

0005101: [Improvement] Changing parameters should not restart all jobs (elong)

0005107: [Improvement] Parameter staging.dir should be appended with the engine name (elong)

0005117: [Improvement] Increase size of file_name column in sym_file_snapshot (elong)

0004957: [Bug] Recording status of Batch with large payloads fails on Derby (rudiejd)

0005072: [Bug] Conflict resolution on Derby for batch with large payloads fails with SQLException (rudiejd)

0000653: [Bug] dbexport should export xml in utf-8 (rudiejd)

0002233: [Bug] IgnoreColumnException and IgnoreRowException are not handled correctly in bsh extension scripts (rudiejd)

0002382: [Bug] Source file creation time not retained at destination folder during file synchronization (rudiejd)

0005054: [Bug] UnixService for wrapper: needs to wait for cmdline object to show up when starting wrapper on Amazon EC2 (pmarzullo)

0004658: [Bug] Postgresql data type - character varying problem (rudiejd)

0005068: [Bug] Postgres operator doesn't exist when using domain user defined type (elong)

0005055: [Bug] DB2 filtering node list with a limit has invalid syntax (josh-a-hicks)

0005056: [Bug] DBExport for AS400 fails compatibility check (josh-a-hicks)

0005057: [New Feature] Record table stats by DML type (josh-a-hicks)

0005062: [Bug] Oracle SDO_GEOMETRY: problem inserting when both BLOB and SDO_GEOMETRY are in the table (pmarzullo)

0005066: [Bug] Sybase column of type unitext causing error when used in "where" clause (elong)

0005067: [Bug] Failing to sync stored procedures containing semi-colons (rudiejd)

0005070: [Bug] Error on purge on Firebird DB with Dialect 1 (rudiejd)

0005077: [Bug] Spaces prevent conflict configuration from working (elong)

0005078: [Bug] Tibero won't update table with LOB when missing PK (elong)

0005079: [Bug] Tibero bulk loader failing because table and columns quoted in control file (elong)

0005080: [Bug] Bulk loaders treat all conflicts as if their detection type is USE_CHANGED_DATA when forming where clauses (emiller)

0005082: [Bug] Mail service support for encrypted passwords (josh-a-hicks)

0005085: [Bug] Data loader gets ArrayIndexOutOfBoundsException on batch (elong)

0005086: [Bug] Wrong logic for deleting triggers on SQL Anywhere (josh-a-hicks)

0005088: [Bug] Duplicate column name error (elong)

0005089: [Bug] Sybase inserts a space instead of an empty string or null value (emiller)

0005091: [Bug] Table Reload Requests: create schema, delete data, before custom sql should honor initial load order less than 0 (pmarzullo)

0005092: [Bug] Lexical error when issuing a foreign key correction with a carriage return in the data (pmarzullo)

0005095: [Bug] Initial load before custom sql to support table replacement with delimiters (josh-a-hicks)

0005097: [Bug] Postgres default value support for gen_random_uuid() (josh-a-hicks)

0005105: [Bug] Transforms should return old and new values for updates when column is primary key (elong)

0005108: [Bug] Failed to route beanshell event from conflict resolution (elong)

0005115: [Bug] Kafka filtering of event types that are not an INSERT, UPDATE, OR DELETE (josh-a-hicks)

0004763: [Bug] Raima Create Snapshot does not work (pmarzullo)

0004196: [Bug] Azure Pipeline -> gradle build failed with java 11 (elong)

0003305: [Bug] Removing a channel can cause errors during push/pull (pmarzullo)

0004559: [Bug] Initial Load Status does not always capture complete set of batches completed (pmarzullo)

0004647: [Bug] Postgres Conflict Resolution blocks when trying to resolve (elong)

0004652: [Bug] Auto resolve ConflictException hides unique key exception (elong)

0004672: [Improvement] Quick test before upgrade of sym_data_event (elong)

0004714: [Improvement] Oracle fails to check compatible v$parameter (elong)

0004719: [Bug] MultiBatchStagingWriter writes "\r\n" on Windows for end of lines in child batch staging files (pmarzullo)

0004932: [Bug] Transforms break deletes when primary key columns are transformed because of issue 4552 (pmarzullo)

0004942: [Bug] Initial load blocking (elong)

0005017: [Improvement] HTTP timeout is used for both connect and read timeouts; should provide a separate HTTP connect timeout parameter (pmarzullo)

0005016: [Bug] SQL Server: make extract_request, table_reload_status, table_reload_request, and trigger_hist row level locking (pmarzullo)

0005020: [Bug] BigQuery type not found FLOAT (elong)

0005051: [Improvement] Improve performance with sync trigger call for list of triggers (elong)

0001387: [Bug] DB2 cannot synchronize tables from non-default schemas. (rudiejd)

0005035: [Improvement] Big Query support for bulk loading data with commas (josh-a-hicks)

0005043: [Improvement] Trigger router cache getting flushed every time initial load extract job runs (elong)

0005023: [Improvement] Sync Triggers should execute successfully in parallel by table (pmarzullo)

0005014: [Bug] BigQuery connectivity not loading security file properly (josh-a-hicks)

0004717: [Bug] Client ack rejected with server busy when using channel queues (elong)

0004991: [Bug] Kafka XML escaping needed (pmarzullo)

0005000: [Improvement] Turn on Jetty access logging (josh-a-hicks)

0005019: [Bug] Service fails to install on SUSE 15 (elong)

0005021: [New Feature] DBFill support for load only nodes (josh-a-hicks)

0005022: [Bug] BigQuery type not found FLOAT (elong)

0005025: [Improvement] Informix dialect with page size 2k (elong)

0005027: [Bug] Fix NPE when a trigger hist is rebuilt with a reason code of H during routing (josh-a-hicks)

0005029: [Bug] Push acknowledgements are not ordered by batch id (josh-a-hicks)

0005030: [Bug] Load Filter documentation indicates that Java and BSH are the only available scripting, but there is also SQL (pmarzullo)

0005041: [Bug] Upgrade from 3.7 to 3.11 fails to upgrade schema (elong)

0005049: [Improvement] Use session_context with JTDS driver (elong)

0004488: [Bug] UPDATE triggers have local variables defined with hardcoded "utf8" charset (elong)

0004973: [Bug] Unicode synchronization of utf8 strings with 4 byte characters in MySql and MariaDB does not work (elong)

0005047: [Bug] Windows install to directory with parenthesis (elong)

0004981: [Improvement] Allow the setting of a timeout for the Sync Triggers process (pmarzullo)

0004345: [Bug] Postgres array types improperly cast into non-array types (josh-a-hicks)

0004333: [Improvement] Monitor events purger condition (elong)

0004675: [Bug] SQL-Server trigger not implemented exception for NCHAR (elong)

0004970: [Bug] Auto resolve missing foreign key with load only or extract only node (elong)

0004971: [Bug] Connection leak during routing when a group link is added (chenson)

0004974: [Bug] Routing and extracting had X columns but expected Y (elong)

0004976: [Bug] MySQL: Drop trigger silently fails (elong)

0004977: [Bug] Oracle create index under same user/schema as table (elong)

0004980: [Bug] MySQL 8 CHAR data type needs spaces right trimmed (elong)

0004986: [Bug] Work with MySQL 8 JDBC driver (elong)

0004987: [Bug] Kafka escaping for special characters (pmarzullo)

0004988: [Bug] Batch in conflict won't load when unique key value is null (elong)

0004996: [Bug] Table PK column order mismatch with column order can cause errors (elong)

0004998: [Bug] Firebird error while dropping trigger, token unknown (elong)

0005001: [Bug] Postgres converts json and uuid types to text for create table (elong)

0005003: [Bug] Oracle: Geometry column type can not be used in a where clause (pmarzullo)

0005006: [Bug] Push, pull, extract thread name has wrong queue (elong)

0005009: [Improvement] Auto resolve missing foreign key for SYM tables (elong)

0004931: [Bug] Stream LOB when row is deleted can get not null error when required by constraint (elong)

0004948: [Bug] Bulk conflict resolution- when falling back to default writer, clear last error in context so context is clean (pmarzullo)

0004940: [Bug] NullPointerException in TriggerRouterService after conflict resolution (NEWER_WINS) (elong)

0001289: [New Feature] Ignore row in batch from source system (emiller)

0004857: [Bug] ClassNotFound exception in symadmin (elong)

0004920: [Bug] Initial load blocking (elong)

0004933: [Bug] Invalid MySQL update statement that queries same table when starting load to multiple nodes (elong)

0004941: [Bug] Null pointer on registration when conflict resolution is needed (elong)

0004944: [Bug] Docker container not being deployed with latest SymmetricDS artifacts (pmarzullo)

0004945: [Bug] USE_CHANGED_DATA / NEWER_WINS not working on Android (elong)

0004947: [Bug] Sybase ASE null byte with data type of TIME (elong)

0004949: [Improvement] Staging manager unrecognized path bulkloaddir (elong)

0004960: [Improvement] dbfill max text and binary sizes (elong)

0004965: [Bug] AndroidSymmetricEngine: (re)start after stop fails (elong)

0004966: [Bug] Upgrade Jetty, BC, Kotlin, okhttp libraries (elong)

0004929: [Bug] Fix SQL explorer row editor (emiller)

0002415: [Bug] Reload a table causes ORA-01652: unable to extend temp segment by 128 in tablespace (elong)

0004454: [Bug] Monitors: Memory and CPU do not provide detailed monitor information (pmarzullo)

0004847: [Improvement] MSSQL switch to use session_context instead of context_info() (josh-a-hicks)

0004849: [Bug] Firebird result set is closed after routing (elong)

0004859: [Bug] SQL-Server error cannot update identity column during auto resolution (elong)

0004860: [Bug] Invalid module during startup after upgrade (elong)

0004862: [Bug] Create WAR gets instance.uuid does not exist (elong)

0004865: [Improvement] Update deployment sub type on sym_node to include log based and load only (josh-a-hicks)

0004866: [Bug] Expandable trigger support for trigger names (josh-a-hicks)

0004867: [Bug] Fix ClassCastException in SQL explorer (emiller)

0004880: [Bug] Upgrade DBCP and Vaadin libraries (elong)

0004884: [Bug] Docker image doesn't start because security directory permissions (elong)

0004888: [Bug] SQL Server 2016 using SESSION_CONTEXT only works with SQL Server JDBC driver, not the JTDS driver (pmarzullo)

0004892: [Bug] NPE in mail service (elong)

0004900: [Bug] Symmetric upgrade with Firebird database fails to upgrade when upgrading to 3.12 (pmarzullo)

0004902: [Bug] Auto resolve when primary key has binary/varbinary (elong)

0004903: [Bug] Oracle bulk loader not being used on Oracle >= 12.2 (elong)

0004906: [Bug] Sybase ASE: update trigger needs to set nocount on on very first statement (pmarzullo)

0004916: [Bug] SYM_DESIGN_DIAGRAM and SYM_DIAGRAM_GROUP need to be filtered out when routing to certain nodes (pmarzullo)

0004925: [Improvement] Add a new parameter that allows you to control the trigger prefix independent of the table prefix (chenson)

0004764: [Bug] Raima Create Snapshot does not work (pmarzullo)

0004838: [New Feature] New extension point that can be used while obtaining a list of tables for a given trigger configuration (josh-a-hicks)

0004873: [Bug] "Old Data" comparison fails on Derby for LONG VARCHAR data types (nrichardson)

0004852: [Bug] Registration server script using extensions (elong)

0004571: [Bug] Password file read access must be restricted: security/jmxremote.password (elong)

0004573: [Bug] Dynamic Query Builder support for bit (josh-a-hicks)

0004765: [Improvement] Prevent blocking on Firebird with lock timeout (elong)

0004780: [Improvement] JMX batch and data count attributes (elong)

0004782: [Improvement] Reduce dependency on log4j2 for deployments without it (elong)

0004783: [Bug] Initial load can slow down when batches on other channels cause conflict resolution (elong)

0004786: [Bug] Force trigger regenerate does not work properly (elong)

0004797: [Bug] JMX local host name unknown (elong)

0004798: [Bug] No data found while correcting foreign key error for reload batch (elong)

0004802: [Bug] On Tomcat, ack was not sent successfully: java.io.IOException: Premature EOF (elong)

0004804: [New Feature] MSSQL log based change tracking loop protection and sync on incoming support (josh-a-hicks)

0004810: [Bug] Fix casting in MsSqlDmlStatement (emiller)

0004814: [Bug] binary column that is zero length (not null) sends to null to target during initial load (pmarzullo)

0004817: [Bug] "smallint out of range" exception when incrementing failed login count > 32767 (elong)

0004818: [Bug] Fix SqlException when generating snapshot from a node with an Oracle database (emiller)

0004819: [Improvement] Improve WAR deployment (elong)

0004821: [Improvement] Add unit tests for massageForLimitOffset() (emiller)

0004823: [Bug] Postgres unique constraint causes current transaction is aborted (elong)

0004828: [Improvement] Log an error instead of a warning when a trigger's source table doesn't exist (emiller)

0004831: [Bug] Initial Load events for config tables need to use correct dialect when running load only, extract only, or log miner (pmarzullo)

0004833: [Bug] Can't export batch that includes sym_node_security (elong)

0004835: [Improvement] Allow spaces in external id (josh-a-hicks)

0004840: [Bug] Sybase ASE primary key update should create update event when only one record is updated (pmarzullo)

0004842: [Bug] Exception during registration with multi-primary (elong)

0004843: [Bug] Push and pull errors while node registration is pending (elong)

0004631: [Bug] Default Conflict resolution (IS_CAPTURE_TIME_NEWER) doesn't work when target node is a load only node (pmarzullo)

0004779: [Bug] SQL Server error while syncing data with identity column (elong)

0001716: [New Feature] Conflict detect collision of primary key and/or unique key (elong)

0004743: [Improvement] Conflict resolver improvements, unique key detection (elong)

0004751: [Improvement] MSSQL ddl table creation support for varbinary(max) (josh-a-hicks)

0004709: [Bug] DB2 zOS uses long varchar instead of clobs (josh-a-hicks)

0004732: [Bug] Do not worry about conflict winner in load only or log based target nodes (josh-a-hicks)

0004644: [Bug] Multiple nodes need synchronized access to keystore (elong)

0004646: [Bug] Repetition in configuration file and registration batch (elong)

0004648: [Bug] Postgres Conflict Resolution blocks when trying to resolve (elong)

0004649: [Bug] Auto resolve ConflictException hides unique key exception (elong)

0004650: [Bug] Conflict with NEWER_WINS implicit conversion error (elong)

0004653: [Bug] NPE in PostgreSqlDmlStatement (elong)

0004660: [Bug] Multi-primary subsequent data loads blocked (elong)

0004661: [Improvement] Initial load foreign key error auto resolve when foreign key missing at source (elong)

0004668: [Improvement] Extensions global BSH functions (elong)

0004669: [Bug] Extensions should reload when changes to sym_extension (elong)

0004670: [Bug] Deletes and conflict detection USE_CHANGED_DATA with resolved NEWER_WINS (elong)

0004671: [Bug] sym command should log to standard error by default (elong)

0004673: [Improvement] Quick test before upgrade of sym_data_event (elong)

0004674: [Improvement] Notification of monitor event resolution (elong)

0004676: [Bug] Insert into sym_data replaces current_timestamp string with question mark to allow specified timestamp but fails sometimes (pmarzullo)

0004679: [Bug] Snowflake module is missing AWS libraries for bulk loading S3 (elong)

0004680: [Bug] Spaces in sym_trigger fields causes create trigger failure (elong)

0004686: [Bug] Push initial load in background gets early EOF log message (elong)

0004687: [Bug] Postgres conflict when unique index uses primary key index (elong)

0004696: [Bug] DB2 zOS trigger permission check (josh-a-hicks)

0004697: [Bug] Server can't open truststore after upgrade (elong)

0004698: [Bug] Sybase Quick Config fails to get schemas when changing catalog selection (pmarzullo)

0004699: [Bug] Date time values are not selectable in DB2 z/OS due to lpad function. (josh-a-hicks)

0004700: [Bug] DB2 zOS replace function will not work with CLOBs (josh-a-hicks)

0004701: [Bug] Windows unable to access log4j2.xml file on command line (elong)

0004706: [New Feature] DB2 zOS support for loop back prevention (josh-a-hicks)

0004707: [Bug] MSSQL load only nodes do not support identity inserts (josh-a-hicks)

0004708: [Improvement] Data loader lookup of meta data on table does not log appropriate error message (josh-a-hicks)

0004715: [Improvement] Oracle fails to check compatible v$parameter (elong)

0004720: [Bug] MultiBatchStagingWriter writes "\r\n" on Windows for end of lines in child batch staging files (pmarzullo)

0004722: [Bug] Invalid PK order on send-schema if source db is oracle (elong)

0004725: [Bug] Using same column twice in sync key names gets error (elong)

0004730: [Bug] MSSQL Bulk Writer continues to call start and end for the table even during fallback to default (josh-a-hicks)

0004737: [Improvement] Parameter for create or alter syntax (elong)

0004738: [Bug] The primary keys are out of order for H2 when returned from Table.java getPrimaryKeyColumns (chenson)

0004741: [Improvement] DB2 zOS clob columns attempt to drop auto generated rowid on restart (josh-a-hicks)

0004742: [Bug] Postgres conflict but can't ignore row (elong)

0004746: [Bug] Log4j should not be required. LogSummaryAppenderUtils currently throws a ClassCastException if a log4j2 is not present (josh-a-hicks)

0004750: [Bug] On SQL-Server can't drop trigger, incorrect syntax (elong)

0004752: [Improvement] DB2 support for XML data types (josh-a-hicks)

0004651: [Bug] Column match routers can mark batches unrouted with initial load select set in table reload request only (josh-a-hicks)

0004572: [Improvement] how to stop one node's service

0004612: [Bug] SQL Server primary key update should create update event when only one record is updated (pmarzullo)

0004625: [Improvement] Multi-primary out of sync with initial load on busy system (elong)

0004574: [Bug] Column match routers can mark batches unrouted with initial load select set in table reload request only (josh-a-hicks)

0004627: [Bug] Hardcoded KeyManagerFactory algorithm (sunX509). Symmetric doesn't work for IBM JRE (pmarzullo)

0004568: [Improvement] SQL Server supports filtered indexes, need to add support of filtered indexes in ddlutils (pmarzullo)

0004577: [Bug] Restrict pro tables from syncing to invalid versions and open source deployments (josh-a-hicks)

0004579: [New Feature] SQL Server supports data compression on tables and indexes, add support for this in DDLUtils (pmarzullo)

0004582: [Bug] Heartbeat job should catch exceptions from heartbeat listeners (pmarzullo)

0004591: [Bug] Multi-primary out of sync race condition with NEWER_WINS conflicts (elong)

0004593: [Improvement] Symadmin send-schema should allow specification to not send indices, foreign keys, and column default values (pmarzullo)

0004596: [Improvement] Upgrade dependent libraries (elong)

0004598: [Bug] SQL Server bulk loader data conversion with decimal scientific notation (elong)

0004600: [Bug] SQL-Server bulk loader not allowing create events (elong)

0004607: [Bug] JMX invalid username or password on Java 11 (elong)

0004610: [Bug] Postgres Conflict Resolution fails to resolve (pmarzullo)

0004614: [Improvement] SQL Server trigger creation should use CREATE OR ALTER TRIGGER syntax to eliminate the loss of data capture (pmarzullo)

0004619: [Bug] dbcompare using only first table on command line (elong)

0004630: [Bug] TransportManagerFactory needs to call SelfSignedX509TrustManager constructor with actual trust store used instead of null (pmarzullo)

0002325: [Bug] Create schema on sql server doesn't support creation of partial unique indexes

0004373: [Improvement] SQL Server supports filtered indexes, need to add support of filtered indexes in ddlutils (pmarzullo)

0004609: [Bug] Postgres Conflict Resolution fails to resolve (pmarzullo)

0004414: [New Feature] SQL Server supports data compression on tables and indexes, add support for this in DDLUtils (pmarzullo)

0004581: [Bug] Heartbeat job should catch exceptions from heartbeat listeners (pmarzullo)

0004597: [Bug] SQL Server bulk loader data conversion with decimal scientific notation (elong)

0004599: [Bug] SQL-Server bulk loader not allowing create events (elong)

0004611: [Bug] SQL Server primary key update should create update event when only one record is updated (pmarzullo)

0004490: [Bug] Log issue when data truncation occurs, causing null pointer exception (pmarzullo)

0004456: [Bug] StagedResource should use a more robust file rename function (pmarzullo)

0004470: [Bug] Database name with special character like minus sign, fails to create trigger when in same database (pmarzullo)

0004471: [Bug] DataExtractorService fails to set StagedResource for extracted file to DONE (pmarzullo)

0004472: [Bug] Staging Purge stops extracts from continuing on when running on the same instance (pmarzullo)

0004481: [Bug] NPE on startup from cluster service (elong)

0004489: [Bug] Node host channel stats sent count inflated (elong)

0004494: [Bug] If node registers, immediate pull causes server to indicate that node is not registered (pmarzullo)

0004529: [Bug] Postgres Varchar column with no defined length getting converted to a LONGVARCHAR (pmarzullo)

0004545: [Bug] Data Extractor gets "java.lang.IllegalStateException: There is no content to read" from staging (elong)

0004578: [Bug] SQL-Server bulk loader not allowing create events (elong)

0004580: [Bug] SQL Server bulk loader data conversion with decimal scientific notation (elong)

0004565: [Bug] New Group Link should send node info to nodes in source node group ID and to nodes in target node group ID (pmarzullo)

0004527: [Improvement] dbexport structure and data of tables from the database to tibero format files (pmarzullo)

0004519: [Bug] Database name with special character like minus sign, fails to create trigger when in same database (pmarzullo)

0004507: [Bug] Master to master setup fails to send initial load if registering with a node other than registration server (josh-a-hicks)

0004522: [Bug] DbCompare does not seem to support schema/database prefixed table names for at least the target node (elong)

0004526: [Bug] [dbcompare command] - Generate script wrongly (elong)

0004531: [Bug] Postgres Varchar column with no defined length getting converted to a LONGVARCHAR (pmarzullo)

0004538: [Improvement] Suppress first deadlock, FK, or protocol violation error to allow retry (elong)

0004544: [Improvement] Batch acknowledgement lookup failed data ID only once (elong)

0004547: [Bug] Data Extractor gets "java.lang.IllegalStateException: There is no content to read" from staging (elong)

0004548: [Bug] Oracle Bulk Loader: quote columns in control file if db.delimited.identifier.mode is set to true (pmarzullo)

0004549: [Bug] Documentation: Transform Column Policy has invalid choice (pmarzullo)

0004551: [Bug] Initial load time empty at client (elong)

0004553: [Bug] Transforms break deletes when transforming primary key column and not capturing old data as specified in trigger (pmarzullo)

0004557: [Bug] Stream to file, Illegal State Exception: There is no content to read. Memory buffer was empty (elong)

0004552: [Bug] Transforms break deletes when transforming primary key column and not capturing old data as specified in trigger (pmarzullo)

0004518: [Bug] Database name with special character like minus sign, fails to create trigger when in same database (pmarzullo)

0004530: [Bug] Postgres Varchar column with no defined length getting converted to a LONGVARCHAR (pmarzullo)

0004546: [Bug] Data Extractor gets "java.lang.IllegalStateException: There is no content to read" from staging (elong)

0004550: [Bug] Initial load time empty at client (elong)

0004497: [Bug] Load Filter wildcard specification does not work when catalog and table are wildcards, and schema is specified (pmarzullo)

0004483: [Bug] Role tables are not filtered for pre-3.9 installations (JJ_Starrett)

0004517: [Bug] Stream to file threshold, Illegal State Exception: There is no content to read. Memory buffer was empty (elong)

0004485: [Improvement] Log file rotation is reversed (elong)

0004484: [Bug] Log exception stack traces after log file rotates (elong)

0004492: [Bug] MySQL before 5.0.32 does not have drop trigger if exists (elong)

0004493: [Bug] Transforms start and end table for each row causing poor performance with bulk data loading (elong)

0004496: [Bug] If node registers, immediate pull causes server to indicate that node is not registered (pmarzullo)

0004502: [Bug] RouterService.routeDataForChannel checks incorrect reference for null (pmarzullo)

0004504: [Bug] NodeService needs to be more persistent when looking for authenticated nodes (pmarzullo)

0004506: [Bug] Regression NPE in Oracle, Tibero bulk loader and Hbase, and Mongo data loader factory (elong)

0004516: [Bug] Upgrade Jetty (elong)

0004498: [Bug] Load Filter wildcard specification does not work when catalog and table are wildcards, and schema is specified (pmarzullo)

0004461: [Bug] Oracle failed to create trigger, identifier is too long (elong)

0004491: [Improvement] Debug logging of node ID and remote address for acknowledgements (elong)

0004495: [Bug] If node registers, immediate pull causes server to indicate that node is not registered (pmarzullo)

0004501: [Bug] RouterService.routeDataForChannel checks incorrect reference for null (pmarzullo)

0004503: [Bug] NodeService needs to be more persistent when looking for authenticated nodes (pmarzullo)

0004505: [Bug] Regression NPE in Oracle, Tibero bulk loader and Hbase, and Mongo data loader factory (elong)

0004515: [Bug] Upgrade Jetty (elong)

0002358: [Bug] Sending required CLOB between H2 and ORACLE throws ""inconsistent datatypes: expected - got CLOB"" (elong)

0002362: [Bug] Sending CLOB with USE_OLD_DATA as conflict in ORACLE throws ""inconsistent datatypes: expected - got CLOB"" (elong)

0004464: [Bug] Failed to load batch ORA-00932: inconsistent datatypes: expected - got CLOB (elong)

0002861: [New Feature] Client certificate authentication (elong)

0004457: [Improvement] Batch conflict possible when blocking row has self referencing foreign key (elong)

0004458: [Bug] Null pointer exception while extracting batch (elong)

0004459: [Bug] Too many rows sent in reload for table when self-referencing foreign key (elong)

0004460: [Improvement] Ingres Dialect: Documentation (pmarzullo)

0004462: [Bug] Oracle failed to create trigger, identifier is too long (elong)

0004463: [Bug] Invalid node in sym_table_reload_request causes NPE (elong)

0004465: [Improvement] Missing JDBC driver for 'org.firebirdsql.jdbc.FBDriver'. (elong)

0004467: [Bug] MSSQL text fields are not permitted in where clause (josh-a-hicks)

0004473: [Bug] Convert to modules, module is already installed (elong)

0004474: [Improvement] Web server require or accept client ssl certificate authentication (elong)

0004476: [Bug] Kafka avro module missing, no errors from install (elong)

0004479: [Bug] Confluent jackson modules missing from install (JJ_Starrett)

0004421: [Bug] Primary key ordering based on the sequence of the PK (josh-a-hicks)

0004419: [Bug] HTTP2 Connection response body not closed (elong)

0004420: [Bug] Error "hostnameVerifier parameter specified as non-null is null" (elong)

0004453: [Improvement] Purge service high CPU for query data range (elong)

0004407: [Bug] Monitor Email Notifications Stopped Working (jvanmeter)

0004413: [Bug] MSSQL support for binary types in the primary key (josh-a-hicks)

0004415: [New Feature] Ingres Dialect Implementation (pmarzullo)

0004427: [Bug] Ingres Dialect: Foreign Key DDL Reader issue and System Generated Indexes (pmarzullo)

0004435: [Bug] Kafka key.serializer issue (josh-a-hicks)

0004436: [Bug] Unable to handle unknown csv values: ts (elong)

0004441: [Bug] Kafka module missing during setup of Kafka node. (josh-a-hicks)

0004442: [Bug] Invalid lines in batch with HTTP2 (elong)

0004444: [Improvement] Push job gets error writing request body (elong)

0004445: [Improvement] Log4j2 log entries missing engine name, jar in stack trace (elong)

0004448: [Improvement] Missing JDBC drivers - add "symadmin module convert" to download drivers as modules (elong)

0004449: [Bug] Authentication for JMX and default to localhost only (elong)

0004452: [Bug] Trigger Rebuild: custom_before_insert_text is ignored when rebuilding triggers (JJ_Starrett)

0003461: [Bug] mysql bulk loader doesn't work with binary() columns, tries to insert in wrong column. (elong)

0004433: [Bug] MySql Bulk loader fails on Hex encoded BLOBs and CLOBs (JJ_Starrett)

0004408: [Bug] Jetty error: KeyStores with multiple certificates are not supported (elong)

0004400: [Bug] Initial load breaks when changing parameters during initial load request processing with clustering (pmarzullo)

0003171: [Bug] Trigger Rebuild: custom_before_insert_text is ignored when rebuilding triggers (JJ_Starrett)

0004171: [Bug] Upgrade from 3.9.18 to 3.11.0 -> Symmetric Services shows not installed even though it is (pmarzullo)

0004426: [Improvement] Purge service high CPU for query data range (elong)

0004446: [Bug] MongoDB dialect does not successfully synchronize (pmarzullo)

0004334: [New Feature] Provide tool to backup and restore configuration that does not reside in the database (pmarzullo)

0002292: [Bug] Cannot replicate the table with foreign key to non-replicated table

0002278: [Bug] File sync during initial load doesn't work

0001866: [Bug] PostgreSQL, postgresql_bulk handle money type (elong)

0003919: [Bug] Symmetric does not locate engines.properties file upon application reload in WebLogic container (elong)

0002058: [Bug] Similar long table names fail to create trigger (elong)

0002439: [Bug] PostgreSQL 9.5 Beta 1 no longer supports autocommit option (elong)

0002579: [Improvement] authentication before using REST api (elong)

0004331: [Bug] symmetrcDS war deployment fails on tomcat (elong)

0004263: [Bug] mx4j without auth (elong)

0004360: [Improvement] Record node login failures and prevent too many logins (elong)

0004167: [Improvement] sym_router table should require router_type value, providing a default value of 'default' (elong)

0004226: [Bug] Table trigger configuration - Sync on Insert/Delete/Update Condition, wrong Sync Condition example (elong)

0004229: [Bug] [Docs] Invalid column name in "Example 2. Sample Group Links" (elong)

0004279: [Improvement] Remove JAR files that are not used as often to download separately (elong)

0004302: [Improvement] Conflict resolution NEWER_TIME based on capture time of row (elong)

0004351: [Improvement] Change registration to send request parameters as POST instead of GET (elong)

0004352: [Improvement] Sybase dialect should enable row locking and set identity gap (elong)

0004401: [Bug] Oracle ntype characters lost from conversion in capture (elong)

0004402: [Bug] Default the file.sync.fast.scan back to false since it only works reliably on Unix (elong)

0003972: [Bug] Tables become out of sync due incorrect conflict detection (and/or invalid conflict resolution) (elong)

0004192: [Improvement] Non-unique index on sym_data should be unique (elong)

0004303: [Improvement] Change default of dataloader.apply.changes.only to true to support better conflict resolution (elong)

0004322: [Improvement] Upgrade to swagger 2, optional swagger-ui as module (elong)

0004324: [Improvement] Upgrade to log4j2 (elong)

0004338: [New Feature] Use HTTP/2 for encrypted HTTPS synchronization (elong)

0004356: [New Feature] Extension points to provide credentials and authorize remote node registration (elong)

0004225: [Bug] Configuration SQLite as master db - crashes after first fresh configuration (elong)

0004403: [Bug] Authentication interceptor out of memory (elong)

0004393: [Bug] Regression NPE in Postgres bulk loader factory (elong)

0004405: [Bug] Initial Load: Retrieve active trigger histories after retrieving Sync Trigger lock (pmarzullo)

0004374: [Bug] NClob support fails on Oracle (elong)

0004375: [Bug] GSON parsing fails for logging stack traces (josh-a-hicks)

0004376: [Bug] Monitor 'offlineNodes' does not capture offline nodes in detail (elong)

0004380: [Bug] Systemd installation: need to specify -Djava.io.tmpdir on command line in systemd control file (pmarzullo)

0004383: [Bug] Initd installation: need to specify -Djava.io.tmpdir on command line in initd file (pmarzullo)

0004386: [Improvement] Better logging of max outgoing and pending loads (elong)

0004390: [Improvement] Upgrade commons-codec (elong)

0004397: [Bug] Bit Support for Postgresql (jvanmeter)

0004354: [Bug] MsSql - create trigger query fails when keys contain spaces (elong)

0004358: [Bug] JNA error from systemd on RHEL (pmarzullo)

0004369: [Bug] SQL Server 2000 gets Invalid object name 'sys.triggers'. (elong)

0004371: [Improvement] Kafka properties from engine pass through to producer (elong)

0004395: [Bug] Extract statistics can be overwritten and inaccurate (elong)

0004404: [Bug] Initial load leaves batch in RQ status with message "batch not ready for delivery" (elong)

0004381: [Bug] Systemd installation: need to specify -Djava.io.tmpdir on command line in systemd control file (pmarzullo)

0004382: [Bug] Initd installation: need to specify -Djava.io.tmpdir on command line in initd file (pmarzullo)

0004387: [Improvement] Raima: Convert to auto-commit all of the time (pmarzullo)

0004394: [Bug] Extract statistics can be overwritten and inaccurate (elong)

0004398: [Bug] Initial load leaves batch in RQ status with message "batch not ready for delivery" (elong)

0004326: [Improvement] Sybase: Enhance trigger definition to include ordering specification (elong)

0004343: [Bug] Raima create session variables does not commit/rollback/close transaction (pmarzullo)

0004368: [Bug] SQL Server 2000 gets Invalid object name 'sys.triggers'. (elong)

0004370: [Improvement] Kafka properties from engine pass through to producer (elong)

0004377: [Bug] Documentation shows offlineNodes monitor as nodesOffline instead of offlineNodes (elong)

0004378: [Bug] Kafka support for multiple sources (josh-a-hicks)

0004385: [New Feature] Kafka message key for ordering with partitioned topics (elong)

0004316: [Improvement] Sybase: Enhance trigger definition to include ordering specification (elong)

0004347: [Improvement] Kafka properties from engine pass through to producer (elong)

0004367: [Bug] SQL Server 2000 gets Invalid object name 'sys.triggers'. (elong)

0003762: [Bug] Bulk loader fallback to default loader and fails will mark batch ok on source when it did not load the batch. (josh-a-hicks)

0004314: [Bug] JdbcBatchBulk: Make it work for insert conflict resolution to be able to be used on reload channel (josh-a-hicks)

0004339: [Improvement] Oracle: Version 12.2 supports 128 character names for tables, columns, constraints, and foreign key names (pmarzullo)

0004284: [Improvement] Sync Triggers: Should enhance syncing of triggers to not delete trigger if platform supports create or replace syntax (elong)

0004349: [Improvement] Pass IAlterDatabaseInterceptors through the platform to DDLBuilders (josh-a-hicks)

0003029: [Improvement] Add a parameter that will force SymmetricDS to create nclobs in sym_data on Oracle. (elong)

0004289: [Bug] Oracle: rebuilding triggers can result in changed data not being captured (elong)

0004315: [Bug] JdbcBatchBulk: Make it work for all conflict resolution (josh-a-hicks)

0004327: [Improvement] Sybase: Enhance trigger definition to include ordering specification (elong)

0004341: [Bug] MySQL: Drop of transaction function when database upgrade occurs is happening after the create of the database objects (pmarzullo)

0004344: [Bug] Raima create session variables does not commit/rollback/close transaction (pmarzullo)

0004346: [Bug] Routing hash collision does not clean up properly (elong)

0004300: [Bug] Oracle Bulk Loader: Fails to parse dbUrl parameter when using service names for sqlldr connect string (pmarzullo)

0004304: [Bug] MySql and MariaDB: Streaming row mode does not call concat() on primary keys for insert and update reload triggers (pmarzullo)

0004305: [Bug] File sync null pointer exception reading acks (elong)

0004307: [Bug] Upgrade libraries with known vulnerabilities (elong)

0004308: [Improvement] Lazy load bouncy castle (elong)

0004309: [Bug] batchError incorrectly checks create time (elong)

0004311: [Bug] DataExtractorService: Stream row query with null values does not deal with the null values correctly (pmarzullo)

0004312: [Improvement] Routing data gap detection option for Postgres to use earliest transaction time (elong)

0004313: [Bug] MySQL and MariaDB: Streaming row mode does not capture updates correctly (pmarzullo)

0004320: [Bug] MySQL upgrade gets sym_transaction_id_pre_5_7_6 does not exist (elong)

0004288: [Bug] Oracle Bulk Loader: Support BLOB, CLOB, and NCLOB with lengths longer than 4000 (pmarzullo)

0004290: [Bug] Oracle bulk loader uses wrong user and password for load-only (elong)

0004292: [Bug] Auto resolve foreign keys not working when source is extract-only database (elong)

0004293: [Bug] Auto resolve fails for delete or update when existing child row references candidate key (elong)

0004294: [Bug] Primary key are dropped and created continuously (chenson)

0004296: [Bug] On MySQL, if some SymmetricDS table columns are uppercase and others are lowercase in the same table you get a null pointer (chenson)

0004262: [Bug] When max loads reached, new load with initial_load_enabled keeps entering rows into sym_table_reload_request (elong)

0004266: [Improvement] Snapshot: For MySql, add the 'show variables' output (elong)

0004269: [Bug] Multi-master configuration with 3 nodes doesn't work (pmarzullo)

0004270: [Improvement] Oracle Bulk Loader: Allow specification of input file character set (pmarzullo)

0004273: [Bug] FormatUtils parseTimestampWithTimezone interprets fractional seconds incorrectly (pmarzullo)

0004278: [Bug] Adding node to instance without registration server does not have access to all node groups (pmarzullo)

0004280: [Improvement] Oracle Bulk Loader: Allow specification of field terminator and line terminator (pmarzullo)

0004062: [Bug] SimpleDateFormat is incompatible with PostgreSql microsecond template

0004246: [Bug] Conflict Resolution: Problem with timestamp with time zones as the USE_TIMESTAMP column (pmarzullo)

0004224: [Bug] getTruncateSql() should use getDeleteSql() when dialect does not support truncate (pmarzullo)

0004227: [Improvement] Data gap detector should use batch mode to insert and delete sym_data_gap (elong)

0004228: [Improvement] Recreate keystore if missing (elong)

0004232: [Improvement] Java 9 and newer class not found javax.xml.bind.DatatypeConverter (elong)

0004234: [Improvement] Upgrade of sym_data_event is slow (elong)

0004235: [Improvement] Kafka driver outputs INFO log message, causing noise in the log (pmarzullo)

0004240: [Improvement] Parameter to route incoming changes as non-common batches when using common groups (elong)

0004241: [Improvement] Potential bottleneck from hitting sequence service during routing large number of nodes (elong)

0004242: [Bug] Jdbc Batch Loader support for MSSQL Identity Inserts and IllegalStateExceptions (josh-a-hicks)

0004250: [Improvement] MailService: Allow the specification of TO, CC, and BCC recipients in the MailService service (pmarzullo)

0004253: [Improvement] DbCompare: continue on processing rows when parse of value causes exception (pmarzullo)

0004256: [Bug] Oracle trigger creates row data and old data when streaming row (pmarzullo)

0004260: [Bug] Custom delete statement during initial load is overridden (elong)

0003834: [Bug] Startup fails on Interbase trying to insert sym_monitor bec "type" is reserved word (elong)

0004197: [Bug] In the documentation of lookup transform it says a column name can be accessed by :MY_COLUMN (elong)

0004199: [Bug] NPE loading batch with JdbcBatchBulkDatabaseWriter data loader "bulk" (elong)

0004202: [Bug] Oracle Decimal precision can contain 40 digits after the decimal but sync only sends 39 (elong)

0004204: [Improvement] Efficient logging of trigger hist and trigger router problems (elong)

0004205: [Improvement] Disable initial load in background if max batch size is 1 (elong)

0004209: [Bug] ArrayIndexOutOfBoundsException getPkDataFor while loading batch (elong)

0004211: [Bug] MSSQL JDBC 7.4 with Azure causing NullPointerException while reading tables (elong)

0004212: [Bug] Resolve foreign key violation can pick up table from wrong catalog or schema (elong)

0004218: [Improvement] Prevent hash collision when routing common batch groups (elong)

0004219: [Improvement] Routing should use transaction and batch mode to insert multiple sym_outgoing_batch rows (elong)

0004221: [Bug] DB2 delete statement should not specify "reuse storage immediate" (pmarzullo)

0004222: [Bug] DB2 truncate before table load needs to commit early in order for truncate to work (pmarzullo)

Enhanced performance of routing and purging, extract-only nodes, improved security of node authentication, and support for SAP HANA

0002979: [New Feature] Support SAP HANA as target for replication (josh-a-hicks)

0004103: [Improvement] Drop router_id column from sym_data_event to improve size and performance (elong)

0003901: [Bug] MSSQL: Updating multiple rows in source table results in reversed rows in destination table (pmarzullo)

0004079: [Improvement] Refresh lock for purge service (elong)

0004094: [New Feature] Routing common batch mode for groups of nodes (elong)

0004095: [Improvement] Unrouted count should check current sequence instead of running max(data_id) (elong)

0004096: [Improvement] Change routing parameter default to always query with gaps (elong)

0004099: [Improvement] Move default location of H2 and Derby database files to <SYM_HOME>/db instead of <SYM_HOME>/tmp (pmarzullo)

0002864: [Improvement] Raise an error if an MSSQL Update fails to get captured (pmarzullo)

0004097: [New Feature] Router convertToReload that converts multiple changes into a reload batch (elong)

0004041: [New Feature] Extract only nodes (josh-a-hicks)

0004093: [New Feature] Queue initial load in its own job (elong)

0004105: [Improvement] Snapshot: use log file names from log4j configuration to filter files to include in snapshot (pmarzullo)

0004113: [Bug] Postgres Time column type can't be converted to Timestamp column type without a cast when restoring the data (pmarzullo)

0004119: [New Feature] Security token in header and session authentication (elong)

0004120: [Improvement] Common batch staging with sub-directories (elong)

0004140: [Bug] Purge job performance with offline nodes (elong)

0004143: [Improvement] Remove ping back enabled from trigger router (elong)

0004080: [Bug] Sym file snapshot batch sent as part of initial load (josh-a-hicks)

0003920: [Improvement] In PostgreSQL trigger function should be SECURITY DEFINER (elong)

0003993: [Improvement] Truncate host name to fit into 60 char database limit (elong)

0004085: [Improvement] Logging of data gaps in router service can use too much memory (elong)

0004086: [Improvement] Optimize network usage on pull by closing connection as soon as batches are transferred (elong)

0004088: [Bug] Failed to delete blocking row (elong)

0004101: [Bug] Batch staging manager does not purge old .create files (elong)

0004104: [Improvement] Snapshot: use log file names from log4j configuration to filter files to include in snapshot (pmarzullo)

0004110: [Improvement] Improve performance of purge stranded data (elong)

0004112: [Bug] Postgres Time column type can't be converted to Timestamp column type without a cast when restoring the data (pmarzullo)

0004115: [Bug] MySQL zero date to null works on initial load but not change capture (elong)

0004118: [Bug] Bulk loading performance into Postgres degraded in 3.10 (elong)

0004081: [Improvement] DBFill support for auto increment columns (josh-a-hicks)

0004084: [Bug] DB2 AS400 dialect is mis-identified as Generic (elong)

0004106: [Bug] Extraction of double byte characters from sym_data exceeding a size of 4000 will fail and not fall back (josh-a-hicks)

0004122: [Improvement] Upgrade redshift driver (elong)

0004111: [Bug] Server node with at least one offline client does not update its heartbeat (elong)

0004125: [Improvement] Excluded columns that are part of an index but the index remains in table object (elong)

0004126: [New Feature] Add a IClientReloadListener to add a hook for reloads on the client (elong)

0004128: [Improvement] Processed count job stats for purge and staging clean (elong)

0004130: [Improvement] Add data_event_type variable to subselect router (elong)

0004131: [Bug] DB2 AS400 error trying to remove a column (elong)

0004136: [Bug] Oracle character set problem with "value too large for column" (elong)

0004137: [Bug] Initial load table with 0 rows doesn't close off all estimated batches (pmarzullo)

0004138: [Bug] LOBs that have values too large to store in a java array will crash the SymmetricDS JVM (josh-a-hicks)

0003726: [Bug] Delete or truncate should quote table name and include catalog/schema (JJ_Starrett)

0003560: [Bug] Unable to use SymmetricDS service in Ubuntu 18.04 / bionic beaver (Systemd in general) (pmarzullo)

0004028: [Bug] failed to sync when Oracle column which datatype is char changes it's value to chinese characters (elong)

0004026: [Bug] Registration server gets "Removing identity because registration is required" (elong)

0004065: [Improvement] Allow zero date on MySQL or convert to null otherwise (3.10) (elong)

0004025: [Bug] Duplicate Registration Requests when IP-Address of client changes (elong)

0003801: [Bug] Ignoring a batch in RQ status with an extract error can cause replication to stop

0004006: [Bug] CAST Error on auto.resolve.foreign.key.violation=true (JJ_Starrett)

0004068: [Bug] Row.getDate(String value, String[] pattern) not parsing String representations of Timestamp correctly (pmarzullo)

0004027: [Improvement] Oracle Numeric types used to return DECIMAL, but now returns NUMERIC with new driver (pmarzullo)

0004067: [Bug] Install using open jdk 11 fails on creation of service (pmarzullo)

0004033: [Improvement] Upgrade the embedded Jetty to newest version (elong)

0004035: [Bug] Firebird 3 gets wrong dialect, errors on sym_escape (elong)

0004044: [Improvement] Potential bottleneck from thread locking during initial load with multiple clients (elong)

0004045: [Bug] Load Data request with multiple nodes and "create table" option fails to create foreign key batches for all but one node (elong)

0004046: [Improvement] Potential bottleneck from flushing cache while processing extract requests (elong)

0004051: [New Feature] Allow dbsql to use list of sql statements from file (pmarzullo)

0004052: [Bug] H2 database: Capture of milliseconds on a date are incorrect (elong)

0004056: [Bug] WrapperService needs to make sure server process exits before looking at childValue() (pmarzullo)

0004058: [Improvement] LookupTableRouter should use initial load select when provided on the trigger router (josh-a-hicks)

0004060: [Improvement] Mac: Support Mac services for running SymmetricDS (pmarzullo)

0004063: [Bug] SQL Server table creation for varbinary(max) (josh-a-hicks)

0004066: [Improvement] Potential bottleneck from counting commas in rows of initial load (elong)

0004069: [Improvement] SQL Server tests failing because of out of date tests (pmarzullo)

0004071: [Improvement] Added method to retrieve active load status only (josh-a-hicks)

0004072: [Improvement] Potential bottleneck from checking exists() on staging files (elong)

0004073: [Bug] External ID unique parameter not working (elong)

0004074: [Bug] Multiple nodes initial load with wildcards sending table twice and missing table (elong)

0004075: [Bug] During upgrade, remove triggers for symmetric tables that changed, then add them back before doing any possible DML statements (pmarzullo)

0004076: [Bug] Get estimated row counts for initial load for SQL Server 2008 needs to use delimiter quoting if turned on (pmarzullo)

0003971: [Bug] fix possible null dereference issues (~~user606~~)

0003968: [Improvement] Inner classes should be made static for efficiency and to reduce coupling (~~user606~~)

0003984: [Bug] SymmetricDS doesn't respect the sticky session setting for AWS ELB ALB which can result in resending logging when under stress (elong)

0004009: [Improvement] Improve logging for conflict resolution (elong)

0003917: [Improvement] In the snapshot, include sym_data records for batches that are in ERROR (~~user606~~)

0003973: [Bug] Putting in non-numeric string for numeric parameters causes error (~~user606~~)

0000963: [Bug] Update and delete does not sync on tables with varbinary primary key (josh-a-hicks)

0003987: [Bug] Add varbinary support for H2 (elong)

0003953: [Bug] Firebird 2.5 trying to recreate existing tables (metadata problem with Jaybird 3.x driver) (elong)

0002563: [Bug] When Primary key is binary; SymmetricDS fails capture changes. (josh-a-hicks)

0002612: [Improvement] DBExport Should Allow Excluding Specific Columns From the Export (~~user606~~)

0003936: [Bug] MSSQL Server to allow varbinary and binary in the where clause (updates and deletes) (josh-a-hicks)

0003974: [Bug] Too many threads, crashing server (elong)

0003242: [Bug] Running DS as a Windows Service in a folder path that contains whitespace causes error (~~user606~~)

0004005: [Bug] Initial load batches are not purging immediately on incoming side (elong)

0003512: [Improvement] Make snapshot name configurable (~~user606~~)

0003659: [Bug] SqlAnywhere dialect crashes when DB name has special char (~~user606~~)

0003844: [Bug] "Failed to execute: CREATE TABLE" in PostgreSQL 9.6 (BIT data type with default) (pmarzullo)

0003868: [Bug] SymmetricDS fails to create SQLITE3 tables on initial load if table name conflicts with reserved SQL keywords. (~~user606~~)

0003977: [Bug] Stream LOB fails (NullPointerException) when row is missing during extraction (elong)

0003978: [Bug] SQLAnywhere will not create engine when database name contains hyphen (~~user606~~)

0003980: [Bug] Exception when dashboard refreshes node status panel (pmarzullo)

0003982: [Bug] MSSQL ddl reader fails if user does not have access to a catalog (josh-a-hicks)

0003988: [Bug] Table name with comma won't sync (elong)

0003989: [Improvement] Java versions 11 and 12 should work with SymmetricDS (pmarzullo)

0003992: [Bug] Create-Table batches resulting from a Load Data "Create Table" aren't being marked with a load id (elong)

0003994: [Bug] DbExport CSV file should escape quote characters with double quotes (~~user606~~)

0004003: [Bug] MySQL table creation failed for ENUM during initial load (elong)

0003990: [Bug] dbcompare use-sym-config ignore table name argument (~~user606~~)

0003991: [Bug] dbcompare null pointers with basic setup with two source tables to a target with no transforms (~~user606~~)

0004002: [Bug] Table name with special characters won't sync (elong)

0004011: [Bug] DBCompare does not use catalog/schema properly on MySQL (mmichalek)

0004012: [Bug] Post-create batches for a Load Data operation are not created in the case where wildcards are involved. (elong)

0004016: [Improvement] Lack of -s option in symadmin help send-schema (elong)

0004018: [Bug] User table creation fails when table exists in another user's schema (elong)

0004019: [Bug] Skipping a batch that contains a CREATE event gets a NullPointerException (elong)

0004020: [Improvement] Allow file router to include transaction ID (~~user606~~)

0004021: [Bug] On every startup with MariaDB, alters to SYM tables (elong)

0003959: [Bug] Possible race conditions in parameters, MongoDB, and initializing nodes (~~user606~~)

0003986: [Bug] Firebird mis-identified as DB2 (elong)

0003958: [Improvement] Add table_name variable to subselect router (elong)

0003957: [Bug] Configuration service contains missing sql statement (josh-a-hicks)

0002709: [Bug] documentation for Transforms - incorrect query for SYM_TRANSFORM_TABLE (elong)

0003934: [Improvement] Add simple request/response logging filter for HTTP troubleshooting (mmichalek)

0003927: [Bug] Excessive logging generated by ChannelRouterContext.logStats (3.9) (mmichalek)

0003954: [Bug] BIT from SQLServer comes in as Integer, Postgres needs value converted to String (VARCHAR) to handle it correctly (3.9) (pmarzullo)

0001279: [Bug] Derby - clob - primary key (date) (elong)

0003925: [Improvement] While using initial load and reverse initial load flags on node_security also create a table_reload_request (josh-a-hicks)

0001957: [Bug] Redundant condition in AbstractParameterService.getString (elong)

0003924: [Improvement] When load configured to clear table first, it should clear table again when restarting load (josh-a-hicks)

0003935: [Bug] Error "database is locked" on SQLite during initial load (elong)

0003319: [Bug] Stopping the engine on the main node via REST stops the whole system (elong)

0003932: [Bug] Routing fails when data data gaps exceed routing.max.gaps.to.qualify.in.sql $(selectDataUsingStartDataIdHint) (3.10) (mmichalek)

0003929: [Improvement] Improve logging of offline scenarios (3.10) (mmichalek)

0003921: [Improvement] Parameter to disable recursive querying of each level in table with self-referencing foreign key (elong)

0003905: [Bug] Table sym_extract_request not found when using different prefix (elong)

0003706: [Bug] Marking Log file type monitor events as resolved causes a new log file event to appear (hanes)

0001995: [Improvement] Update PostgreSQL jdbc driver to 42.2.5 (elong)

0003397: [Bug] Using Postgresql 9.6.6 as a Source DB Fails SymmetricDS Upgrade to version 3.9.2 due to old postgresql jdbc driver (elong)

0003895: [Improvement] Compare Url's case insensitive (elong)

0003898: [Bug] Tables created with VARCHAR instead of DATE (SQL-Server as source) (elong)

0003902: [Bug] When changing just a LOB field on SQL Server, the change is not captured by the trigger (fixed on 0003899 in version 3.9.19) (pmarzullo)

0003904: [Bug] Dashboard refresh data uses Vaadin UI component without locking (also fixed by 0003903 in 3.9.19) (pmarzullo)

0003906: [New Feature] HBase support as a load only node (josh-a-hicks)

0003907: [Improvement] MongoDB support for shared clusters (josh-a-hicks)

0003912: [New Feature] LDAP Base DN specification should be able to provide more than one LDAP tree for searching (fixed in 3.8 using 0003910) (pmarzullo)

0003916: [Bug] Symmetric service fails to start on windows 10 due to conflicting slf4j versions (mmichalek)

0003922: [Bug] Two pass LOB on Oracle should avoid binary variable types (elong)

0003793: [Improvement] Optimize routing query for Oracle when majority of sym_data is unrouted (mmichalek)

0003575: [Bug] Starting a new process even though the previous 'File Sync Push' process had not finished (mmichalek)

0003913: [Bug] Exception during keep alive can cause concurrent loading of batches (mmichalek)

0003792: [Bug] Routing bottleneck on long routing runs (mmichalek)

0003795: [Improvement] More efficient routing for non-transactional channels (mmichalek)

0003890: [Bug] DB2 for i version 6 and earlier: LPAD not available (elong)

0003880: [New Feature] Snowflake data loader (josh-a-hicks)

0003892: [Improvement] MySQL Version 8 returning error code 1216 when foreign key constraint is violated (used to be 1452) (pmarzullo)

0003899: [Bug] When changing just a LOB field on SQL Server, the change is not captured by the trigger (pmarzullo)

0003900: [Improvement] Improve performance of Oracle RAC routing processing (mmichalek)

0003903: [Bug] Dashboard refresh data uses Vaadin UI component without locking (pmarzullo)

0003911: [New Feature] LDAP Base DN specification should be able to provide more than one LDAP tree for searching (also in 3.8 using issue 0003910) (pmarzullo)

0003894: [Bug] Sync Triggers doesn't run after registration / initial load when cluster.lock.enabled=true (3.8) (mmichalek)

0003874: [Bug] The 'audit' router should not write rows to the audit table during a load (3.8) (mmichalek)

0003909: [Bug] When changing just a LOB field on SQL Server, the change is not captured by the trigger (fixed on 0003899 in version 3.9.19) (pmarzullo)

0003910: [New Feature] LDAP Base DN specification should be able to provide more than one LDAP tree for searching (pmarzullo)

0002244: [Bug] Self- Referential Foreign Keys result in Contraint violation when loading data (elong)

0003886: [Improvement] Initial load foreign key error auto resolve (elong)

0003806: [Improvement] Initial load large character (varchar 4000) columns and stay under SQL limit (elong)

0002760: [Improvement] Default the file.sync.fast.scan to true (elong)

0001229: [Bug] Opening registration causes nodes to complain until it registers

0003883: [Bug] Lost heartbeat when using more than two node groups (elong)

0003865: [Improvement] Improve logging readability and appropriate levels (elong)

0003858: [Improvement] Initial load share extract requests for multiple nodes (elong)

0003842: [Improvement] Immediately purge stage files for large loads (elong)

0003873: [Improvement] Keep alive for slow acknowledgement (elong)

0001452: [Bug] (firebird) schema creation fails

0002849: [Bug] Create Table maps a column originally created as an ENUM('y','n') to a Enum(2) (pmarzullo)

0000755: [Bug] When missing primary key, update where clause needs to use "is null" for null values (elong)

0003521: [Bug] Create Table First is creating table with all columns as primary key instead of none (josh-a-hicks)

0003882: [Bug] Registration stuck in "open" even though data still syncing over push link (elong)

0003384: [Bug] Various warnings appear when executing symadmin send-schema (elong)

0002751: [Bug] Incorrect Trig/Capture on Oracle Dialect When Lob Data > 4k and Channel contains_big_log = 0 & trigger use_capture_lobs = 1 (elong)

0003839: [Improvement] Trigger capture with fallback to slower use_capture_lob/contains_big_lob (Oracle) (elong)

0000827: [New Feature] Allow any error (not only unique constraint errors) be fixed using sym_incoming_error (josh-a-hicks)

0002546: [Bug] Foreign Keys Error not resolveable via INCOMING_ERROR resolve_ignore = 1 (elong)

0002434: [Improvement] Upgrade to Jaybird 3 for Firebird (elong)

0002426: [Bug] Sym server create Primary Keys for all fields in table without PK (josh-a-hicks)

0003853: [Improvement] Defer indexes and foreign key constraints for table creation until after initial load (elong)

0002904: [New Feature] Feature which allows one to exclude the Indexes getting replicated from server to clients (elong)

0003107: [Bug] Create table statement syntax error for tinyblob field (pmarzullo)

0003344: [Bug] start.refresh.cache.job=true leads to errors in cache refresh job - "query error" with query = 'null' (pmarzullo)

0003520: [Improvement] Symadmin should have an option to unregister a node (pmarzullo)

0003522: [Bug] Table creation Error while initial Load into oracle DB (initial.load.create.first=true) when using Default value SYS_GUID() (pmarzullo)

0003817: [Improvement] Initial load use estimated counts (elong)

0003610: [Bug] HSQLDB type OTHER support (pmarzullo)

0003647: [Bug] dbcompare: unclear error for duplicate table names in source tables argument (pmarzullo)

0003708: [Bug] Wildcard does not work when there is no wildcard at the beginning or the end of the text (pmarzullo)

0003748: [Bug] Batch was not complete (elong)

0003751: [New Feature] PostgreSQL 9.5 and newer can use "insert on conflict do nothing" for better performance (elong)

0003756: [Improvement] Change authentication failed from 403 to 659 (elong)

0003757: [Improvement] Stream LOB uses multiple queries per row when a table has multiple LOB columns (elong)

0003770: [Improvement] Remove deprecated and unused columns in SYM tables (elong)

0003784: [Improvement] More aggressive purge settings (elong)

0003785: [Improvement] Improve visibility of full and partial loads (josh-a-hicks)

0003809: [Improvement] Data extract and routing fallback to contains_big_lob (elong)

0003802: [Improvement] Faster two-pass initial load for tables with LOB on Oracle (elong)

0003814: [Improvement] Better handling of low disk space (elong)

0003818: [New Feature] Ability to ignore incoming error (josh-a-hicks)

0003824: [Improvement] Additional metrics on table_reload_request and extract_request to support loads (josh-a-hicks)

0003825: [Improvement] Oracle bulk loader using SQL*Loader sqlldr (elong)

0003830: [Improvement] Tibero bulk loader using tbLoader (elong)

0003833: [Improvement] Improve performance and accuracy of DDL retrieval of Oracle Indexes (3.10) (mmichalek)

0003836: [Bug] Fix DDL creation of ROWID column for Oracle (3.10) (mmichalek)

0003838: [Improvement] Ability to resolve a row in error on the incoming side and provide resolve data (josh-a-hicks)

0003847: [New Feature] Enhance fallback to handle duplicate key and foreign key errors (elong)

0003848: [Improvement] Upgrade of reload channels max batch size to be 10000 (josh-a-hicks)

0003857: [Improvement] NodeService.findNode(...) (cached versus non-cached), where to use correct one (pmarzullo)

0003863: [Bug] DbFill cascade and select handle composite and self-referencing foreign key (elong)

0003866: [New Feature] Support for oracle select hints to run parallel processes during initial load extraction (josh-a-hicks)

0003867: [Improvement] Increase default of max data to route (elong)

0003876: [Bug] The 'audit' router should not write rows to the audit table during a load (3.10) (mmichalek)

0003878: [Bug] MySQL Bulk loader support for BIT data types (josh-a-hicks)

0003881: [Improvement] Allow manual routing (pre-routing) of batches (elong)

0003884: [Improvement] Oracle LONG error when creating trigger (elong)

0003885: [Improvement] Routing run immediately when channel is full (elong)

0003537: [Improvement] initial load create: Cascade Delete rule is not syncing as part of the create DDL (pmarzullo)

0003543: [Bug] System tables should be ignored on MssqlDdlReader (elong)

0003704: [Bug] Documentation fix: Monitor Events sync on the monitor channel, not the heartbeat channel (elong)

0003705: [Improvement] Documentation for monitor.events.capture.enabled parameter is vague (elong)

0003850: [Bug] On startup with Postgres 10, always alters sym_sequence (elong)

0003851: [Bug] Postgres error column type tsvector but expression is of type character varying (elong)

0003852: [Bug] Startup on Postgres no relation for gp_id (elong)

0003854: [Improvement] Initial load use estimated counts (elong)

0003856: [Bug] Oracle bulk loader issue with a load only target node (josh-a-hicks)

0003861: [Bug] Table reload request by channel will be treated as a full load and mark all outgoing batches as OK (josh-a-hicks)

0003862: [Improvement] Oracle raw data type faster load extraction (josh-a-hicks)

0003869: [Bug] job.purge.first.pass=true does not work on firebird (pmarzullo)

0003870: [Bug] MSSQL Server datetime2 does not capture null values (josh-a-hicks)

0003872: [Bug] MSSQL Server datetimeoffset data type not converting to UTC and losing time zone (josh-a-hicks)

0003837: [Improvement] MSSQL Support for datetime2 values that are before January 1, 1753 (josh-a-hicks)

0003840: [Bug] Fix situation where SQLite DDL could not rebuild a table (mmichalek)

0003835: [Bug] Fix DDL creation of ROWID column for Oracle (mmichalek)

0003831: [Improvement] Be more lenient in the calculation of whether a channel is common (chenson)

0003821: [Bug] DB2 timestamp columns do not pad year if less than 4 chars (josh-a-hicks)

0003823: [Improvement] Improve performance and accuracy of DDL retrieval of Oracle Indexes (mmichalek)

0003777: [Bug] Multiple table reloads are put into single batch (elong)

0003786: [Bug] NullPointerException when batch in error trying to log SQL details (elong)

0003788: [Bug] When a database is offline, some symmetricds jobs can stop processing if the parameter cache times out and a job runs. (chenson)

0003791: [Bug] Windows service installation will not work if the directory contains spaces (elong)

0003798: [Bug] Allow a trigger router to be considered for common batches that sync in one direction even though ... (chenson)

0003807: [Bug] Symmetric startup is very slow when there are lots of staging files on a SAN (3.9) (mmichalek)

0003808: [Improvement] Allow override of Symmetric web home (which defaults to '/') (3.9) (mmichalek)

0003812: [Bug] Router exception can expire gaps that contain data (3.9) (elong)

0003813: [Bug] DBExport Option for no-foreign-keys not working with XML format (elong)

0003815: [Bug] Create tables with a source foreign key in a non default catalog and/or schema to a target with default catalog/schema (josh-a-hicks)

0003816: [Bug] Newer versions of H2 try to alter decimal scale every time because NUMERIC_SCALE is 0. DECIMAL_DIGITS should be used instead (chenson)

0003688: [Bug] Routing can fail due to ConcurrentModificationException while attempting to log "Routing for channel has been running..." (3.8) (mmichalek)

0003674: [Bug] Auto resolve foreign key can fail when primary keys are not first in table definition (elong)

0003675: [Improvement] Fix logging of servicing pull requests (elong)

0003693: [Improvement] XMLType support for Oracle (josh-a-hicks)

0003758: [Improvement] Allow override of Symmetric web home (which defaults to '/') (mmichalek)

0003760: [Bug] Symmetric startup is very slow when there are lots of staging files on a SAN (mmichalek)

0003377: [Bug] Android SQLite Register NullPointerException (maxwellpettit)

0003711: [Bug] Table reload request for a table with a foreign to itself and a data row where the row fk is to itself doesn't load any data (josh-a-hicks)

0003766: [Bug] Starting service gets NumberFormatException (elong)

0003772: [Bug] Cannot inactive table for sync when one of triggers is missing (elong)

0003773: [Bug] With wildcards, rebuilding specific table trigger can result in multiple active triggers (elong)

0003378: [Bug] SLF4J warnings using symadmin (chenson)

0003526: [Task] The spring core library has a vulnerability. (mmichalek)

0003527: [Task] The jackson databind library has a vulnerability. (mmichalek)

0003540: [Bug] Registration gets lost during the registration when File Sync is enabled (mmichalek)

0003622: [Bug] Monitoring of Heap space memory percent is not firing as expected (mmichalek)

0003727: [Bug] MySQL documentation needs updated to reflect need to grant the PROCESS priv for transaction id (josh-a-hicks)

0003744: [Bug] Improper variable replacement for ${sourceNodeId} was being replaced with the group name instead of nodeID (josh-a-hicks)

0003746: [Bug] Log "Unable to resolve foreign keys" only on full initial load (elong)

0003747: [Improvement] Symmetric should log full SQL Statement when conflict resolution SQL fails (mmichalek)

0003749: [Improvement] Log dynamic SQL when logging SQL data load exception (mmichalek)

0003752: [Bug] Create tables fails if there is a foreign key with multiple referenced columns (josh-a-hicks)

0003753: [Bug] Stream rows feature in oracle would fail to build insert template (josh-a-hicks)

0003754: [Bug] Oracle support for ROWID (josh-a-hicks)

0003764: [Bug] Loading of Oracle Geography/Geometry Type fails when SRID is explicit on the source column (mmichalek)

0003765: [Bug] If Sym_table_reload_request's router_id is invalid, a full table load occurs (any 'where' clause is ignored) (mmichalek)

0003767: [Improvement] Kafka performance improvements (josh-a-hicks)

0003768: [Bug] On SQL Server 2016 all datetime2 columns are altered on every restart (chenson)

0003774: [Task] Update gradle to support building with Java 11 (mmichalek)

0003709: [Improvement] Support row-by-row stream lob for DB2 (elong)

0003741: [Bug] Individual Table reloads should not clear a node's incoming batches (mmichalek)

0003737: [Bug] MSSQL 2008 Create table DDL for TIME data type incorrect when coming from a different source database (josh-a-hicks)

0003738: [Improvement] Batch in error on a reload channel by default blocks all other channels. Should not block config channel though. (josh-a-hicks)

0003733: [Improvement] Logging for authorization denied (elong)

0003734: [Bug] Raima dialect support for obtaining last inserted id (josh-a-hicks)

0003732: [Bug] Extract request should record last update time (elong)

0003731: [Bug] Gaps taking longer to expire and using slower method of querying sym_data (elong)

0003723: [Improvement] Purge stranded batches can get deadlock or timeout when outgoing_batches is large (elong)

0003722: [Bug] 3 Tier registration issue when trigger create before initial load is false. (josh-a-hicks)

0003715: [Bug] File sync extract batches sometimes show incorrect row counts (mmichalek)

0003716: [Bug] MSSQL bulk loader fails when truncate table is used as part of the load with a different target database and schema (josh-a-hicks)

0003717: [Improvement] Raima dialect rebuilds triggers with each restart (josh-a-hicks)

0003714: [Bug] Stream row with large number of columns on DB2 (elong)

0003713: [Bug] Extract row count statistics double when staging is cleared (elong)

0003710: [New Feature] Jdbc Batch bulk data loader (josh-a-hicks)

0003689: [Bug] Excluded columns that are part of a foreign key the foreign key remains in table object (josh-a-hicks)

0003539: [Improvement] Failed to extract batch 011-21 StackTraceKey.init [RuntimeException:2157757869] java.lang.RuntimeException: java.lang.NullPoint (hanes)

0003682: [Bug] XML table definitions with FK do not need to provide catalog and schema for the FK if it is in the same as the table (josh-a-hicks)

0003690: [Improvement] Add cluster.staging.enabled to indicate whether a shared staging area is being used. ** Upgrade Alert ** (chenson)

0003691: [Bug] initial.load.before.sql and initial.load.after.sql don't work with a full load anymore (chenson)

0003656: [Bug] Routing log messages can be excessively long (3.9) (mmichalek)

0003681: [Improvement] Add cached data gaps to snapshot (elong)

0003684: [Bug] Load Filter Beanshell variables are not properly scoped (mmichalek)

0003692: [Improvement] Purge stranded data and batches after channel is deleted (elong)

0003694: [Improvement] XMLType support for Oracle (josh-a-hicks)

0003695: [Improvement] Table xml contains FK source catalog and schema even if same as default (josh-a-hicks)

0003626: [Bug] Incorrect default value for stream.to.file.enabled (maxwellpettit)

0003624: [Bug] Some situations can cause a transformed value to be written to the old column value instead of the new column value. (chenson)

0003632: [Bug] When file sync is configured and enabled, initial load of files cannot be turned off (mmichalek)

0003658: [Bug] Routing can fail due to ConcurrentModificationException while attempting to log "Routing for channel has been running..." (mmichalek)

0003611: [Bug] Wildcard triggers cause conflicting trigger names when table names vary slightly (elong)

0003612: [Bug] Failed to update a table_reload_request during initial load (elong)

0003617: [Bug] Add better logging and handling for intermittent "Had trouble renaming file" message in the log (3.9 ticket) (mmichalek)

0003620: [Bug] File sync jobs do not auto start when enabling the file.sync.enable parameter (mmichalek)

0003621: [Bug] SQL Server has static "sym" prefix on sym_outgoing_batch (elong)

0003623: [Bug] Fix unintended side-effects involving push/pull node lists (mmichalek)

0003625: [Improvement] Don't set use capture lobs for sym_file_snapshot. An initial load of files can use a lot of temp space on Oracle unnecessarily (chenson)

0003627: [New Feature] File conflict resolve extension point (josh-a-hicks)

0003628: [Improvement] DBFill improvements to support UUID fields (josh-a-hicks)

0003630: [Bug] java.lang.ClassNotFoundException on com.jumpmind.symmetric.console.remote.ServerEndpoint (mmichalek)

0003635: [Bug] If a trigger is deleted after it has been queue'd for a reload, but before it has had batches created a null pointer can occur (chenson)

0003636: [Bug] 3rd party triggers can affect SymmetricDS data load (mmichalek)

0003637: [Bug] Table transforms update first setting bleeds into subsequent transforms (mmichalek)

0003639: [Bug] Initial load fails on delete first when router uses the "Use Source Catalog/Schema" setting (josh-a-hicks)

0003640: [Improvement] Oracle sequence noorder does not need extra index (elong)

0003643: [Bug] Error in DB2 select's for initial load and triggers (josh-a-hicks)

0003644: [Bug] Deleting a trigger associated with an unextracted batch causes invalid CSV (mmichalek)

0003646: [Bug] Auto resolve foreign key can fail on Oracle RAC in noorder mode (elong)

0003648: [Bug] Fix DEBUG logging - RouterService suggests that channels that don't have any data to route are disabled (mmichalek)

0003650: [Improvement] Parameter for routing to sort data in memory instead of using database (elong)

0003651: [Improvement] Log details about database permission failures (mmichalek)

0003598: [Improvement] Order rows in initial load for table with self-referencing foreign key (elong)

0003605: [Improvement] Transforms should return an old value for delete and new value for insert and updates (elong)

0003609: [New Feature] Kafka support as a load only node (josh-a-hicks)

0003595: [Improvement] DBFill improvements for JSONB in Postgres and not filling sym tables (josh-a-hicks)

0003599: [Improvement] Read instance.uuid one time for server instance (elong)

0003603: [New Feature] Deleted columns list transform (elong)

0003604: [Improvement] Additional variables for variable transform (elong)

0003606: [Improvement] H2 lost data from restart or power failure (elong)

0003565: [Improvement] Add a new staging.dir parameter that controls the location of the staging area. (chenson)

0003544: [Improvement] Not all unique sqlite error message are respected on unique error detection (mmichalek)

0003547: [Improvement] Improve Sqlite DdlBuilder support

0003580: [Improvement] Treat misconfiguration more serious: initial.load.use.extract.job.enabled=true and stream.to.file.enabled=false (mmichalek)

0003586: [Improvement] Noorder sequence for performance on Oracle RAC (elong)

0003581: [New Feature] Cassandra support as a load only node (josh-a-hicks)

0003312: [Bug] Compare tablename case insensitiv on SQLite on trigger creation (mmichalek)

0003504: [Improvement] SyncTrigger slow due to synchronized this.getClass() on AbstractDatabasePlatform.getTableFromCache (mmichalek)

0003541: [Improvement] Caches should be cleared on a server restart (mmichalek)

0003557: [New Feature] MSSQL support for datetimeoffset data types. (josh-a-hicks)

0003559: [Improvement] Log expiration of data gaps at info level (mmichalek)

0003572: [Improvement] Improve SymmetricDS acknowledgement logging (mmichalek)

0003573: [New Feature] TopSpeed (TPS) Router (josh-a-hicks)

0003574: [Improvement] Improved logging for data truncation issues in Postgres (josh-a-hicks)

0003583: [Bug] Windows service installer missing config files (elong)

0003584: [Bug] Update BSH variables documentation (elong)

0003585: [Improvement] Default BSH column transform to return old value for deletes (elong)

0003588: [Bug] Configuring a custom job with a cron schedule may result in exceptions in the log and the custom job failing to start (mmichalek)

0003589: [Improvement] Initial load extract job should check file.sync.enabled parameter (elong)

0003590: [Bug] If routing is backed up and a restart happens gaps with data can be expired causing missing data (chenson)

0003514: [Improvement] Improve purge performance of sym_data and sym_data_event (elong)

0003315: [Bug] Cache hash collision in ColumnsAccordingToTriggerHistory (mmichalek)

0003327: [Improvement] Support SQL Server geography type (mmichalek)

0003363: [Bug] A file reload is produced if an unrelated table reload is requested (mmichalek)

0003509: [Improvement] Postgres support for DDL table creation of JSONB data types (josh-a-hicks)

0003510: [Bug] Service wrapper hanging on start on Windows 2003 server (elong)

0003515: [Bug] Null pointer in AddForeignKeyChange (josh-a-hicks)

0003516: [Improvement] Support for DDL creation of a Postgres table with a JSONB data type (josh-a-hicks)

0003518: [Bug] Cross database foreign key support during table creation (josh-a-hicks)

0003524: [Improvement] Indicate when the JVM has optimized a stack in the log (mmichalek)

0003525: [Improvement] Service wrapper: remove reliance on SYM_HOME environment variable (elong)

0003531: [Improvement] Add parameter right.trim.char.values to always right trim CHAR fields

0003536: [Improvement] Documentation clarification/warning about clearing staging (josh-a-hicks)

0003538: [Bug] Batch left in status resend (RS) is never loaded on target and marked okay (OK) on source (elong)

0003542: [Bug] Somestimes jobs are loaded and executed on not assigned node groups

0003549: [Improvement] Add log files to snapshot as last operation (elong)

0003550: [Improvement] Timeouts on routing query and purge service (elong)

0003552: [Bug] Snapshot creations fails due to missing table sym_console_event on community edition

0003553: [Bug] NPE in SnapshotUtil due to returning null on getImplementationTitle()

0003498: [Bug] Batches with status of RS (resend) are flagged as In Error. (gwilmer)

0003501: [Bug] Service wrapper not finding process name correctly on Windows 10 (elong)

0003356: [Bug] Add initial.load.transport.max.bytes.to.sync parameter. transport.max.bytes.to.sync not respected in 3.9 during loads/reload (mmichalek)

0003375: [Bug] Data Capture Can't Handle Large XMLTYPE Values (josh-a-hicks)

0003487: [Bug] Executing ISqlTemplate.update() with multiple statements swallows errors (mmichalek)

0003492: [Bug] Postgres create table with Boolean default value needs to wrap with quotes (josh-a-hicks)

0003495: [Bug] Multiple channels in error, should sort batches order by oldest first (elong)

0003497: [Bug] Incoming staging files can be purged by the staging manager before they are processed (gwilmer)

0003500: [Improvement] Tibero date type columns will not be mapped as timestamp during dml statements (josh-a-hicks)

0003502: [Improvement] Increase the default values of transport.max.bytes.to.sync and initial.load.transport.max.bytes.to.sync parameters (mmichalek)

0003503: [Bug] Create/Alter table with a foreign key that crosses catalog or schema (josh-a-hicks)

0003329: [Bug] Unsuccessful upgrade from 3.7 to 3.8 (kpatierno)

0003446: [Bug] Batch extract locks aren't released when "java.lang.IllegalStateException: Had trouble renaming file." occurs. (mmichalek)

0003447: [Bug] Delaying triggers until after initial load when auto creating tables (elong)

0003448: [Bug] DataExtractorService can't create file lock first time due to missing 'common' directory (mmichalek)

0003450: [Bug] Prevent registration until sync triggers has run (elong)

0003453: [Bug] Purge of stranded data_events on PostgreSQL is too slow (elong)

0003456: [Bug] Stage management job does not use cluster locks (mmichalek)

0003491: [Bug] Incoming staging files can be purged by the staging manager before they are processed (gwilmer)

0003493: [Bug] Batches with status of RS (resend) are flagged as In Error. (gwilmer)

0003494: [Bug] Multiple channels in error, should sort batches order by oldest first (elong)

0003478: [Bug] Sync triggers in MySQL will fail if there is an active trigger history record but the table was removed manually (josh-a-hicks)

0003430: [Bug] Service wrapper should verify and kill abandoned processes (elong)

0002190: [Bug] PID file is not cleaned up on startup (elong)

0002280: [Improvement] Service stops working after upgrading Java (elong)

0003431: [Improvement] Recovery options for service wrapper (elong)

0003432: [Improvement] Change default start type of windows service to automatic (delayed) (elong)

0003435: [Bug] Error during sync triggers can result in dropping triggers (elong)

0003440: [Improvement] Warning in Java 9 illegal reflective access (elong)

0003441: [Improvement] Update the PostgreSQL JDBC driver. (kstojanovska)

0003444: [Bug] Delaying triggers until after initial load when auto creating tables (elong)

0003445: [Bug] Batch extract locks aren't released when "java.lang.IllegalStateException: Had trouble renaming file." occurs. (mmichalek)

0003451: [Bug] Prevent registration until sync triggers has run (elong)

0003454: [Bug] Purge of stranded data_events on PostgreSQL is too slow (elong)

0003455: [Bug] Stage management job does not use cluster locks (mmichalek)

0003457: [Bug] Oracle geometry/geography type fails to insert if geometry data > 4k (mmichalek)

0003459: [New Feature] Extension point for registration redirect (elong)

0003462: [Improvement] Adjust default parameter value for dataloader.apply.changes.only (josh-a-hicks)

0003463: [Bug] SyncTrigger via REST call does not return errorcode if trigger creation fails (mmichalek)

0003464: [Improvement] RemoteNodeStatuses actively waits for completeness (mmichalek)

0003465: [Bug] DBFill support for JSON types (josh-a-hicks)

0003466: [Improvement] Upgrade MySQL driver (josh-a-hicks)

0003467: [Bug] DataService insertReloadEvent(TableReloadRequest request, boolean deleteAtClient) fails to route without a channelID (josh-a-hicks)

0003468: [Bug] MySQL does not properly retrieve SYM triggers if they are in a different catalog than the connection catalog (josh-a-hicks)

0003470: [Bug] Table reload request for specific tables causes sync triggers to run (elong)

0003471: [Bug] Transport manager factory not using proper parameter (josh-a-hicks)

0003474: [Bug] java.lang.AbstractMethodError: java/sql/PreparedStatement.setNString (elong)

0003481: [Bug] Postgres create tables with an auto increment column create sequence without respect to schema (josh-a-hicks)

0003484: [Improvement] MySQL tinyint columns can be sent as boolean columns through DDL statements (josh-a-hicks)

0003361: [Improvement] Beanshell Version has CVE (mmichalek)

0003427: [Bug] Node host channel stats sent count inflated (josh-a-hicks)

0003381: [Bug] symadmin does not always return 1 on failure (kstojanovska)

0003390: [Bug] DB2 on ZOS error during snapshot: dbexport throws IllegalArgumentException for --compatible db2zos (kstojanovska)

0003391: [Bug] dbcompare command throws Null Pointer when no arguments passed. Should print help commands. (kstojanovska)

0003392: [New Feature] Resolve foreign key errors using target database metadata and request rows from source (elong)

0003394: [Bug] Booleans fields fail on Sybase 15 using Sybase 12 query optimizer (mmichalek)

0003395: [Improvement] Evaluate the use of the jsch dependency in SymmetricDS (mmichalek)

0003398: [Bug] new sym_job table causes registration error on clients older than 3.8 (chenson)

0003400: [Improvement] Additional information for snapshot file (elong)

0003404: [Bug] --jmx-disable command line option doesn't disable JMX. (mmichalek)

0003405: [Improvement] Default to strong crypto and fall back if not available (elong)

0003406: [Improvement] Improvements for Timeouts related to slow databases (mmichalek)

0003407: [Improvement] Add ability to specify a date time format for dbcompare (kstojanovska)

0003408: [Improvement] Update jackson-databind version (maxwellpettit)

0003416: [Improvement] Raima dialect support for global variables (josh-a-hicks)

0003420: [New Feature] Teradata bulk loader (josh-a-hicks)

0003423: [Bug] Node host stats not working (josh-a-hicks)

0003425: [Improvement] Adding and modifying variables used in initial load and configuration (elong)

0003429: [Bug] Compression of staging with initial load gets IllegalStateException (elong)

0003366: [Improvement] Support transactional sync triggers (kstojanovska)

0003359: [Improvement] Safeguard against initial.load.delete being routed to the wrong node (mmichalek)

0003369: [Bug] Null pointer when using CSV Router (maxwellpettit)

0003370: [Improvement] Handle exceptions while trying to determine the database version (josh-a-hicks)

0003371: [New Feature] Raima Dialect (josh-a-hicks)

0003374: [Improvement] Load only db passwords not encrypted (josh-a-hicks)

0003380: [Bug] If sym_trigger_hist is missing symmetricds will attempt to recreate the row, but rebuild of triggers fails (kstojanovska)

0003383: [Improvement] IReloadGenerator is not used when node security flag is used for initial loads (josh-a-hicks)

0003385: [Bug] Creating a FULLTEXT index in MySQL or MariaDB is not supported (josh-a-hicks)

0003386: [Improvement] Populate deployment sub type on sym_node (josh-a-hicks)

0003348: [Improvement] Add prompt for password in encrypt-text (kstojanovska)

0003357: [Bug] Extract file lock can't be created when "common" directory doesn't exist yet (mmichalek)

0003339: [Bug] Retrying batch gets ignored/OKed if stream.to.file.enabled = false

0003333: [Bug] Pull extract is broke when stream.to.file.enabled is set to false (chenson)

0002903: [Bug] DataExtractorService is not incrementing DataBytesSent and DataSent (elong)

0002445: [Bug] Reload channel can get "starved" after it goes into ER when there are lots of pending batches on other channels (elong)

0003274: [New Feature] Setting to block or unblock channels during initial load error (elong)

0002309: [Bug] Error during initial load - send from stage (elong)

0002911: [New Feature] Immediate re-pull when data was just pulled (elong)

0002502: [Improvement] Allow notes or comments for triggers, routers, table routing, and transforms (kstojanovska)

0002684: [New Feature] Support Custom Jobs (mmichalek)

0002912: [Improvement] Prevent reading out database password via rest api (elong)

0003124: [Improvement] Sym_sequence table change column name cycle to not be an ANSI reserved word (josh-a-hicks)

0002937: [Improvement] Disable and deprecate Grouplets feature in 3.9 (mmichalek)

0003053: [Improvement] Default handle_key_updates in sym_trigger to 1 (chenson)

0003060: [Bug] Data generated by a transform isn't visible to later transforms (when using multiple load transforms on one table) (mmichalek)

0003087: [Improvement] When a trigger_hist row can't be found use the catalog and schema from the trigger definition to look up the table to "recreate" (chenson)

0003092: [Improvement] Remove sym_trigger_router.initial_load_batch_count. It is no longer used. (chenson)

0003112: [Improvement] Make Outgoing Batch and Incoming Batch Similar (maxwellpettit)

0003113: [Bug] Typo in sym_service.conf (chenson)

0003114: [New Feature] Update service detects new software versions (elong)

0003115: [Bug] You can miss sym_monitor_event sync's because they are on the heartbeat channel. Create a new "monitor" channel. (chenson)

0003120: [Task] Upgrade build to the latest version of gradle (chenson)

0003138: [Task] Default monitor.events.capture.enabled to false (chenson)

0003142: [New Feature] Sync Columns Between Incoming and Outgoing Batch (maxwellpettit)

0003168: [New Feature] Create CSV Router to route data from a CSV file into a database and update documentation. (kstojanovska)

0003209: [Improvement] Delay detection of offline nodes after restart (elong)

0003232: [Improvement] Upgrade Jetty to the latest version. Require Java 8. (chenson)

0003186: [Improvement] Support throttling multi-homed node startup (chenson)

0003220: [Improvement] Cannot Register a remote node to another remote node before initial load (chenson)

0003252: [Improvement] When inserting extract in background reload batches record the data_row_count during the insert of the RQ batch (chenson)

0003253: [Bug] ProcessInfo which is used to gather information about processes can be corrupted on push and pull because of threading in 3.8 (chenson)

0003256: [Bug] Extract stats aren't updated on common outgoing batch rows for nodes that did not do the actual extract (chenson)

0003260: [Bug] Incoming heartbeat batch can be left stranded in error (chenson)

0003261: [Improvement] During the reading of data to route, log every minute the progress to the log file like other processes do (chenson)

0003262: [Improvement] Add sym_node_channel_ctl to the snapshot (chenson)

0003281: [Improvement] Add caching to FileSyncService (kstojanovska)

0003283: [Improvement] Trigger creation fails on some platforms when multiple trigger threads working. (kstojanovska)

0003291: [Improvement] Disable 3DES ciphers that are vulnerable to Sweet32 Birthday attacks (elong)

0003325: [Improvement] Support cluster lock keep-alive for routing (mmichalek)

0003328: [Improvement] Detect when more than one instance of SymDS is connected the same DB but not clustered. (mmichalek)

0003284: [Improvement] Add details to email notifications (kstojanovska)

0003294: [Bug] Loads that use a custom sql (truncate table %s) to not take into account transforms (josh-a-hicks)

0003286: [Improvement] dbcompare improvements (mmichalek)

0003275: [Improvement] Allow users to reset batch status to NE to force re-extraction of a batch (mmichalek)

0003297: [Bug] Treat Oracle DATE type as a TIMESTAMP (kstojanovska)

0003282: [Bug] Common batch extracts may fail when a cluster is using a shared staging area (mmichalek)

0002886: [Bug] Disabling self signed certificates (elong)

0003277: [Bug] null pointer during sorting of tables for initial load (josh-a-hicks)

0003278: [Bug] Fixes for NuoDB dialect (elong)

0003279: [Bug] Rest services return HTTP response code 200 when disabled, but should return a response code indicating something's wrong. (mmichalek)

0003285: [Improvement] Move loading of trigger_routers to more specific execution branch to reduce unneeded db calls (chenson)

0003288: [Bug] The cancellation of pending heartbeat batches can cause a deadlock on SQL Server (mmichalek)

0003293: [Bug] Resource leak when loading data from transport (chenson)

0003296: [Improvement] Routing should use a dirtySqlTemplate for getReadyChannels() (mmichalek)

0003298: [Bug] On Sybase ASE, SymmetricDS sometimes fails to detect triggers in different catalog (mmichalek)

0003300: [Improvement] Run fix data gaps by default the first time routing runs after a restart (chenson)

0003301: [Improvement] Don't package snapshot zip like a jar file. Use zip utility instead. (chenson)

0003302: [Improvement] Package all symmetric log files and wrapper log files in a system snapshot (chenson)

0003303: [Improvement] Include more outgoing batch rows in the snapshot (chenson)

0003304: [Improvement] For a failed batch log the channel it was on as well as the batch id. This will be useful to see in the log file (chenson)

0003287: [Bug] Invalid symbols in index name lead to sync error on SQLite (chenson)

0003250: [Bug] Clustered DataExtractorService re-extracts batches when they have already been extracted by another node in the cluster (gwilmer)

0003227: [Improvement] When pushing to a large number of nodes on limited number of thread, only allocate nodes that have pending changes (chenson)

0003236: [Improvement] Allow for an "all nodes" value in lookup table router (gwilmer)

0003212: [New Feature] Add NuoDB Dialect (kstojanovska)

0003239: [Bug] Observed that two load threads are loading the same batch at the same time during a pull (maxwellpettit)

0003247: [Improvement] Include check for next data_id to ensure within range of sym_data_gap (chenson)

0003259: [Improvement] Retry batch should be flushed when written to the output stream so we don't hit timeouts (chenson)

0003268: [Bug] symadmin encrypt-text requires a valid properties file that can connect to a database to encrypt new passwords. (chenson)

0003258: [Improvement] DB2 support for transaction id (josh-a-hicks)

0003243: [Bug] AS400 default catalog must be null and not empty string or readTables on the meta data will never return results (josh-a-hicks)

0003244: [Improvement] AS400 support for versions less than 7 (josh-a-hicks)

0002846: [Bug] SymmetricDS blocks on startup when AS400 password expires (elong)

0003210: [Bug] Turkish Locale Problem (elong)

0003224: [Bug] batch_to_send_count does not get reset in hybrid model (kstojanovska)

0003226: [Bug] Enabling File Sync doesn't start jobs on client nodes (maxwellpettit)

0003234: [Improvement] Ability to store additional statistics by channel (josh-a-hicks)

0003237: [Bug] DB2 zOS does not support to_clob function (josh-a-hicks)

0003240: [Bug] Each time a batch is loaded it uses the same thread name. This can be confusing if the same node is being loaded by two thread (maxwellpettit)

0003246: [Improvement] Check for journaling on DB2 for i (elong)

0003249: [Bug] Setting EXTERNAL.ID.IS.UNIQUE can create a race condition that allows to nodes to share registration (gwilmer)

0003263: [Improvement] Optimize inserting of initial load events for lots of nodes (chenson)

0003264: [Bug] The MySQL Bulk Loader throws a null pointer exception if the table is not found in the target database (chenson)

0003267: [Improvement] Log better error message when SymmetricDS fails to decrypt a db.password (chenson)

0003269: [Bug] If a file exists in staging with a done or create suffix and no period to separate the suffix, then the server won't startup (chenson)

0003270: [Improvement] Document how to import a pkcs12 formatted ssl cert into symmetricds (chenson)

0003271: [Bug] Postgres bulk loader will produce a stack overflow error on create tables (josh-a-hicks)

0003272: [Bug] Table reload requests that use the custom sql (for truncates or other) run agains the improper order of tables (josh-a-hicks)

0003273: [Bug] Initial load order was not correct for all cases. (josh-a-hicks)

0003211: [Bug] When a node is in "offline" mode (node.offline=true), the offline push and pull jobs don't always pick up incoming files (gwilmer)

0003229: [Improvement] Add Data Loader for Apache Ignite (maxwellpettit)

0003216: [New Feature] Tibero Database Dialect (josh-a-hicks)

0003204: [Bug] File Sync Fast Tracking doesn't initially populate sym_file_snapshot (maxwellpettit)

0003205: [Bug] Enabling File Sync doesn't create triggers on sym_file_snapshot (maxwellpettit)

0003206: [Improvement] Initial load extractor threading does not support multiple queues (josh-a-hicks)

0003194: [Bug] SymmetricDS fails to start on multi-homed installations using the exact same db.url (mmichalek)

0003207: [Bug] Error on Sybase 12.5 on setDecimalValue (josh-a-hicks)

0003173: [Improvement] dbcompare - support overriden target table names. (mmichalek)

0003213: [Improvement] dbcompare - support excluding individual columns from comparison (mmichalek)

0003214: [Bug] Close & delete resource if retry command comes through and the create file has been stranded in staging (chenson)

0003203: [Bug] list outgoing batches query does not work on Sybase ASE when a load is specified (maxwellpettit)

0003218: [Bug] Sybase ASE 12.5 updateHandleKeyUpdatesTriggerTemplate Syntax Error (maxwellpettit)

0003222: [Improvement] When restarting a cron job print out the next scheduled time (chenson)

0003223: [Bug] Batches that are corrupted on the file system in the outgoing staging area can cause the system to get stuck (chenson)

0003193: [Bug] Sybase ASE - If you turn off selection of old data during routing and use a column match routers an error is thrown (chenson)

0003163: [Improvement] Detect situations where there are invalid copies of engines.properties files in the engines directory (mmichalek)

0003165: [Bug] Common batch issue when nodes are pushed to or pulled from concurrently (chenson)

0003167: [Bug] Sybase ASE Errors Using Multithreaded Sync Triggers (maxwellpettit)

0003172: [Bug] Table Name for Triggers on Postgres is Case Sensitive (maxwellpettit)

0003174: [Bug] Purge should clean up abandoned sym_data_event rows (elong)

0003177: [Bug] Sync config on upgrade can lose registration (elong)

0003180: [Bug] When a node is re-registered it can propagate deletes of itself back to the registration effectively unregistering itself (chenson)

0003181: [Bug] Corrupt batch on remote target node after an "out of disk space error" (chenson)

0003182: [Bug] Resource is not closed after "out of disk space" error on a remote target node (chenson)

0003183: [Bug] After a failed extract in background batches should be cleaned up and the batch status should be set back to RQ (chenson)

0003184: [Bug] Multi-homed nodes that run out of disk space can end up with zero byte sized files due to the way that copy works (chenson)

0003152: [Bug] org.jumpmind.db.sql.SqlException: JZ0NK: Generated keys are not available because either the Statement.NO_GENERATED_KEYS was use (josh-a-hicks)

0003179: [Improvement] Make start.sync.config.job, auto.sync.config.at.startup editable on the UI. (mmichalek)

0003187: [Bug] Initial load delete first with transforms involving multiple tables (josh-a-hicks)

0003188: [Bug] The ddl builder for Sybase ASE is ignoring the unique='true' setting on the column even though the keyword unique does exist (chenson)

0003190: [Task] Update Supported Data Types in SqlServer in Docs (kstojanovska)

0003191: [Bug] Sybase useHandleKeyUpdates yields trigger that sets nocount incorrectly (chenson)

0003192: [Bug] Sybase ASE Errors in Metadata Using Reserved Words (maxwellpettit)

0003157: [Improvement] Allow bulk loaders to fall back to default loader when an error occurs (josh-a-hicks)

0003154: [Bug] Reopen registration sets created_at_node_id to be the selected node rather than registration server/managing node (kstojanovska)

0003145: [Improvement] Allow $(schemaName) variable in channel expression (elong)

0003147: [Improvement] Create table reload requests by channel (josh-a-hicks)

0003143: [Bug] Table reload request load sql using alias "t" will not work (josh-a-hicks)

0003148: [Bug] Stream rows does not honor sync key names if provided (josh-a-hicks)

0003150: [Bug] ProcessInfo duration is for the entire sync (versus batch) and the rows/sec is off because it is calculated using the total time (maxwellpettit)

0003155: [Bug] Refresh the group link cache when node group links are modified. (maxwellpettit)

0003156: [Improvement] Validate the number of table columns match the number of data elements before attempting to load data (chenson)

0003146: [Bug] Wildcards for schema and table on Oracle (elong)

0003162: [Bug] Empty batches are created on load when using subselect router (maxwellpettit)

0003133: [New Feature] Stream rows (josh-a-hicks)

0003104: [New Feature] Log Conflicts Resolutions (maxwellpettit)

0003118: [Bug] Only sync pro tables to professional target nodes. (mmichalek)

0003121: [Bug] Generic JDBC builder improperly handling delimiters (josh-a-hicks)

0003131: [Bug] null pointer when a table reload request is queued up and there is no sym_node_security row (chenson)

0002835: [Bug] Cannot access audit tables when db is postgressql (chenson)

0003129: [Bug] oracle.use.transaction.view=true can cause missing data on busy systems (chenson)

0003137: [Improvement] Updates to SymmetricDS tutorial (kstojanovska)

0003127: [Improvement] Add logging to the DBFRouter to log failed line number and field (chenson)

0003095: [New Feature] Add basic DDL replication (elong)

0003097: [Bug] Common batches can get an error if they are in memory and two nodes try to pull with just the right timing. (chenson)

0003105: [Improvement] The default cluster.lock.timeout.ms is set to 30 minutes. Default to 2 hours instead. (chenson)

0003094: [Bug] Status of batches set to resend when error on channel (elong)

0003096: [Improvement] Variables in router target catalog and schema (elong)

0003099: [Bug] target and source node caches don't get refreshed when sym_node is sync'd to other nodes for the first time (chenson)

0003093: [Bug] Greenplum client won't register properly with master node (gwilmer)

0003091: [Bug] A corrupt batch being sent to a target results in a NullPointerException by load writing the batch to staging (chenson)

0003085: [Bug] MySQL JSON columns being converted to hex representation on mysql data on extract at source node (chenson)

0003088: [Bug] The last update time on sym_incoming_batch comes from the app serve while the create time comes from the database (chenson)

0003089: [Bug] data_event_count is not being set for initial load batches (chenson)

0002984: [Bug] Batch was corrupted in incoming staging. The beginning of the batch was appended to the middle of the same batch. (chenson)

0001261: [Bug] reload-table doesn't work with tables that have collate latin1_bin

0003075: [New Feature] Sync configuration on upgrade and as periodic job (elong)

0003076: [Bug] MySQL binary collation sequence causes incorrect decoding of text data from source (gwilmer)

0003066: [Improvement] Cache frequent use of AppUtils.getHostName() and AppUtils.getIpAddress() (mmichalek)

0002964: [Bug] MEDIUMTEXT/LONGTEXT columns being converted to hex representation on mysql data on extract at source node (maxwellpettit)

0003077: [Task] custom_variable_classes not used in PostgreSQL 9.2+ (maxwellpettit)

0003079: [Improvement] Add capture only changes support for SQLite (chenson)

0003081: [Improvement] Give unique names to the data loader and data extractor threads (chenson)

0003070: [Improvement] Log error details when SymmetricDS is unable to read table metadata (gwilmer)

0003069: [Improvement] Update documentation for 3.8 load balancers to use sticky sessions (josh-a-hicks)

0003080: [Improvement] Show failed batch extract errors even if there is problems updating outgoing batch status for the failure (gwilmer)

0003074: [Bug] Extracted request gets stuck if connection failes while sending batch (chenson)

0003067: [Improvement] Log information about long running routing similar to extract and load (maxwellpettit)

0003068: [Bug] MySQL Create Table with Timestamps (josh-a-hicks)

0003083: [Bug] Support initial load in background with stream to threshold set to a non-zero value (chenson)

0003073: [Bug] When auto.resolve.foreign.key.violation=true and circular fk dependencies exist SymmetricDS can blow up with an OOM error (chenson)

0003086: [Bug] Missing foreign key reference of null is not handled properly in the foreign key recovery code (chenson)

0003034: [Bug] Failed to extract batch - IllegalStateException: There is no content to read (chenson)

0003046: [Bug] Table debug log statement causes slowness (maxwellpettit)

0002967: [Bug] SymmetricDS schema-send (sync) fails to create tables for autoindex-ed SQLite tables (maxwellpettit)

0003042: [Bug] Batch protocol incorrect when reload event with no data is followed by two different change events (chenson)

0002766: [Bug] Version 3.8.3 : Symmtric DS Installation on Interbase (maxwellpettit)

0003056: [Improvement] Make XmlPublisherDatabaseWriterFilter configurable to publish either on batch complete or batch commit (chenson)

0003054: [Bug] Support lower_case_names=1 setting for MySQL (chenson)

0003055: [Improvement] When the default database writer fails to execute a SQL event, the SQL that was executed is not logged (chenson)

0003045: [Bug] Sometimes insert on replicated tables fails on MySQL (maxwellpettit)

0003049: [Improvement] Update the documentation for BeanShell Script Transform to talk about how to access "other" columns (maxwellpettit)

0003058: [Bug] Every sql error causes "There is no content to read. Memory buffer was empty and <file> was not found" (chenson)

0003020: [Bug] Problem after upgrading from version 3.8.8 to version 3.8.18 (chenson)

0003030: [Improvement] Test SymmetricDS with Firebird 3 (maxwellpettit)

0003059: [Bug] 0003027 caused columns of type text on SQL Server to not work with handle_key_updates on (chenson)

0002962: [Bug] Fix typos and dead URLs in tutorials (maxwellpettit)

0003018: [Bug] On Oracle, nvarchar not syncing unicode characters when use_capture_lobs is on (chenson)

0003017: [New Feature] Assign MySQL data Types.OTHER to LONGVARCHAR (maxwellpettit)

0003003: [Improvement] Support JSON data types (maxwellpettit)

0002991: [Bug] Routing still runs with start.route.job=false (maxwellpettit)

0003024: [Improvement] Document sendStringParametersAsUnicode=false for improving performance on Sql Server (chenson)

0002992: [Bug] host.bind.name not being used (maxwellpettit)

0003025: [Improvement] Update the heartbeat (sym_node_host) immediately on an re-opened registration (chenson)

0003026: [Bug] null pointer exception on sqlite. jdbc type name can be null on sqlite (chenson)

0003027: [Bug] Unable to create trigger for varbinary in MsSql (maxwellpettit)

0003028: [Improvement] When jobs.synchronized.enable is true, sync triggers should only use 1 thread (chenson)

0003031: [Bug] Sqlite dialect is broken (chenson)

0003033: [Bug] A beanshell script transform should be able to return a non string value (which would be translated to a screen) (chenson)

0003035: [Bug] When using postgres bulk loader the dataloader.create.table.alter.to.match.db.case setting is not respected (chenson)

0003036: [Bug] ConcurrentModificationException while cleaning staging (chenson)

0003037: [Bug] Update the documentation for configuration of bulk loaders on the channel (chenson)

0003038: [Improvement] Sql Server - default sendStringParametersAsUnicode=false so we use the index when varchar primary keys are used (chenson)

0003039: [Bug] Wildcard table names don't work on Informix (chenson)

0003016: [Improvement] Don't refresh the sym_node cache on the update of sym_node records (chenson)

0003014: [Improvement] During Extract, ORA-01438: value larger than specified precision allowed for this column (mmichalek)

0003013: [Improvement] Update the heartbeat (sym_node_host) immediately on registration (chenson)

0002999: [Bug] When a node is disabled after it has expired sym_node_host should be deleted as well as sym_node_security (chenson)

0003000: [Bug] The registration ack for registration redirect does not work because the ack url is incorrectly rebuilt for the redirected ack (chenson)

0003002: [Improvement] Add a parameter to enable the old way to purge staging. Default will be stream.to.file.purge.on.ttl.enabled=false (chenson)

0003005: [Bug] SequenceFactory may issue duplicate outgoing_batch (batch_id) sequence numbers when shared db transactions are rolled back (mmichalek)

0003007: [Bug] Initial Load or Table Reload extract may stall when file.sync.enable=true (mmichalek)

0003010: [Improvement] Batches get stranded in ready state in staging on a cluster because the ack that moves them to done occurs on a different server (chenson)

0003011: [Bug] Batches that are behind a transform change batch in the same sync get deleted because of staging purge (chenson)

0002995: [Improvement] IllegalStateException - no content found after fixing transform (chenson)

0002996: [Bug] DB2 dialect fails to detect existence of sym tables (mmichalek)

0002998: [Bug] Batch incorrect when a reload event with no data followed by change capture data from a different table in the same batch (chenson)

0002978: [Improvement] Remove the packaging of symmetric.properties file in the conf directory. (chenson)

0002993: [Bug] ddl-utils should not drop tables when it can't update their structure (mmichalek)

0002969: [Improvement] Support offline mode for file sync (mmichalek)

0002968: [Bug] java.lang.NullPointerException in getForeignTableRows when foreign key is null (chenson)

0002971: [Bug] C Client crashes during sync triggers if two trigger routers point at the same trigger (mmichalek)

0002973: [Bug] Support http timeout in C client (mmichalek)

0002974: [Bug] 3.8 is not backwards compatible with pre 3.0 versions when multiple batches with the same table are received (chenson)

0002975: [Improvement] Generating a snapshot can fail if the SYM_NODE_COMMUNICATION table has issues while being added (josh-a-hicks)

0002977: [Improvement] SqlScriptReader is slow at parsing multi-line sql statements (chenson)

0002976: [Bug] Foreign key automatic resolution was not handling nested dependencies properly (josh-a-hicks)

0002963: [New Feature] Support file sync in the C client (mmichalek)

0002470: [New Feature] Add support for MySQL 5.7 (maxwellpettit)

0002959: [Bug] BatchStagingManager deleting incoming files from staging that are not yet processed (chenson)

0002960: [Improvement] Save on memory: StagingManager creates lots of empty maps that just take up memory as staging grows (chenson)

0002961: [Bug] Concurrent extractors of common batches can get into a state where the batch is not found in staging when it goes to sent it (chenson)

0002944: [Improvement] Attempt to recover if sym_trigger_hist is deleted. If the table and trigger can be found then recreate the row. (chenson)

0002947: [Bug] Auto resolve foreign key violation fails when table in different catalog or schema (elong)

0002909: [Bug] Built in extension points should be marked as built in extension points so they show up as such (chenson)

0002939: [Bug] MySQL store: Error after reload node (chenson)

0002936: [Improvement] Provide additional DB2 debug logging around global variables (mmichalek)

0002938: [Bug] Monitor event batches may get mistakenly ignored during heartbeat (mmichalek)

0002940: [Improvement] Sql Server - An implicit conversion on column [sym_outgoing_batch].[status] to data type "nchar" may be causing index su (chenson)

0002941: [Improvement] Update Oracle section to enhance 4k limit documentation and add subsections (chenson)

0002942: [Improvement] Make sym_data_gap regeneration more robust (mmichalek)

0002943: [Improvement] Add min and max sym_data.data_id to support snapshot (mmichalek)

0002945: [Improvement] Allow environment variables and system properties to be used as replacement properties in engine parameters at startup (chenson)

0002946: [Improvement] Provide explicit default and document the host.bind.name parameter (mmichalek)

0002948: [Bug] Columns mismatched with multiline clob and varchar columns with matching protocol data that happens to be in a new line (chenson)

0002949: [Bug] Statistics in sym_node_host_channel_stats are incorrect for extract and send as of 3.8.0 (chenson)

0002951: [Bug] Push HEAD request doesn't use the queue channel to reserve its connection so the request is effectively not doing anything (chenson)

0002952: [Bug] A sym_data row that can't be handled should be ignored. Not reprocessed over and over again. (chenson)

0002928: [Bug] Staging purge process fails to clean registration batch. Purge staging hourly based on absence of batch in batch tables (chenson)

0002920: [Bug] Offline mode extract is broken (chenson)

0002923: [Bug] Errors are being suppressed when they bubble up to the SymmetricDS Servlet and the nodes are multi-homed (chenson)

0002924: [Bug] java.util.concurrent.TimeoutException: Idle timeout expired: 60000/60000 ms (chenson)

0002925: [New Feature] Add REST service that invokes a job (chenson)

0002926: [Improvement] Reference the latest postgres jar file so that postgres 9.6.1 works (chenson)

0002930: [Improvement] Add node offline monitor (chenson)

0002910: [Bug] Node Communication Type FILE_EXTRACT is too long (mmichalek)

0002914: [Bug] Don't log full stack trace when registration is not open on client (chenson)

0002915: [Bug] Initial load batches get routed to everyone if initial load is interrupted by a reboot if cluster.lock.enabled is true (chenson)

0002916: [Bug] Sql script in doc is wrong (chenson)

0002917: [Improvement] Don't update the status of an outgoing batch to SE until it has been sending for outgoing.batches.update.status.millis (chenson)

0002822: [Improvement] DBCompare should support where clauses (mmichalek)

0002885: [Bug] Table reload request delete first out of order (chenson)

0002893: [Improvement] Set the defaults for pull.thread.per.server.count and push.thread.per.server.count to something bigger than 1 (chenson)

0002898: [Bug] DBCompare should consult sym_router when determining target catalog and schema (mmichalek)

0002892: [Bug] Monitor events cause issues when syncing to a node that is running SymmetricDS version less than 3.8. (chenson)

0002876: [Improvement] FileSync initial load batches should respect max batch size of the filesync_reload channel (mmichalek)

0002863: [Task] Update the documentation for initial loads (josh-a-hicks)

0002874: [Bug] [SQL Server] When capture changes only is enabled, pk is not compared and potential syntax error (elong)

0002875: [Improvement] log at the warning level, not the error level when an unrecognized engine is specified or a bad url is used (chenson)

0002878: [Improvement] Provide for BSH scripting when reading properties files (~~mhanes~~)

0002883: [Bug] DBCompare overrides SQL output when using a single SQL file (mmichalek)

0002887: [Improvement] Update sym_service.conf with setting for http server response timeout. Reduce the default timeout from 2 hours to 1 minute (chenson)

0002890: [Improvement] For long running batches, log not only the dml count, but the dml count by table (chenson)

0002768: [Bug] Abandoned batches in StagingArea if Batch is marked as "OK" (josh-a-hicks)

0002888: [New Feature] Remove any staging files that do not associate with a batch in the incoming or outgoing batch table when purged. (josh-a-hicks)

0002857: [Bug] PostgresBulkDatabaseWriter is not preserving spaces (josh-a-hicks)

0002859: [New Feature] Auto resolve foreign key violation by sending missing rows (elong)

0002852: [Improvement] Add batch summary to incoming batches (mmichalek)

0002860: [Improvement] Avoid locks in extract query with dirty reads (elong)

0002865: [Bug] Console event unique key exception on ignore multiple batches (josh-a-hicks)

0002868: [Bug] Fix really bad error message when a transform transforms a table name to a name that doesn't exist and the original name does (chenson)

0002870: [Improvement] Add getEngine(name) to SymmetricWebServer (elong)

0002871: [Bug] Initial loads and reload were not preserving spaces on an empty space field. (josh-a-hicks)

0002834: [Bug] SQL Server table create fails for date type numeric() identity (josh-a-hicks)

0002801: [Bug] Ignoring a batch will not send the ignore properly to targets (josh-a-hicks)

0002803: [Bug] Outgoing purge job is slower than it needs to be (chenson)

0002807: [Bug] DBCompare should process tables that have a PK mapped in a transform, even if they don't have a physical PK (mmichalek)

0002808: [Improvement] Update cacerts file to latest version (elong)

0002809: [Improvement] Parameter to trust mail server certificate (elong)

0002813: [Bug] Remove monitor event and console event from configuration (elong)

0002814: [Bug] Add debug logging for SMTP session (elong)

0002815: [Improvement] Add an online() call to IOfflineClientListener (elong)

0002805: [Bug] mysql_bulk may cause NullPointerException (elong)

0002816: [Bug] org.jumpmind.symmetric.service.impl.ConfigurationService#channelWindowsByChannelCache filling error (elong)

0002817: [Bug] User Guide misstype (elong)

0002818: [Bug] RouterService is deadlocking on SQLite when clustering enabled (mmichalek)

0002820: [Bug] Unclear meaning of dbcompare's --use-sym-config (mmichalek)

0002823: [Bug] Value too large for router_id in sym_data_event error (elong)

0002825: [Bug] Data with ID = 0 is routed perpetually when using DataGapFastDetector (mmichalek)

0002812: [Improvement] Provide a means to override the default semicolon delimiter for SQL event batches (~~mhanes~~)

0002831: [Bug] Newline converison in data can cause data truncation error (elong)

0002832: [Improvement] Sql server unable to read meta data (tables) from when using other databases (josh-a-hicks)

0002833: [Bug] Batch extraction stuck in loop (elong)

0002836: [Improvement] Reduce checks for old files in stage management (elong)

0002765: [Bug] MS SQL Server 2000 fails to alter table due to dropping of default constraints (josh-a-hicks)

0002788: [Bug] Sync of monitor events gets unique key violation (elong)

0002764: [New Feature] isNull, isBlank, and isEmpty Transform Types (josh-a-hicks)

0002770: [Bug] Monitor/console event tables not routing and syncing (elong)

0002773: [Improvement] Repeating startup messages about nodes being rejected (elong)

0002767: [Bug] Monitoring not working Firebird (elong)

0002771: [Bug] MSSQL 2000 fails to alter tables due to default constraint errors (josh-a-hicks)

0002774: [Bug] Batch with committed data_events was OK'd after server died after commit of sym_data_event but before batch status was updated (chenson)

0002769: [Bug] Initial load extraction gets into a loop if staging file was deleted before being sent. (josh-a-hicks)

0002777: [Bug] Initial load waits for extraction that never happens (elong)

0002782: [Bug] Duplicate data gap immediately after upgrade (elong)

0002748: [Bug] the Table 'sym_trigger' can not be created on informix (elong)

0002775: [Bug] Uninstall fails on version 3.5 database with 3.8 software on Postgres (elong)

0002780: [Improvement] org.jumpmind.db.sql.JdbcSqlReadCursor not using sqlTemplate.getSettings().getResultSetType() for creating statement (elong)

0002781: [Improvement] Loop is continuing even when condition is meet (elong)

0002784: [Bug] 3.5 version of SymmetricDS will not register with a 3.8.3 server (chenson)

0002776: [Bug] SQL Lite nodes fail to register 3.8 - 3.8.3 (josh-a-hicks)

0002787: [Improvement] Add sym_console_event to the support snapshot (josh-a-hicks)

0002792: [Bug] DBCompare leaks database resources (mmichalek)

0002786: [Improvement] Add sym_table_reload_request to support snapshot (josh-a-hicks)

0002793: [Improvement] Add count and is_resolved to monitor events (elong)

0002799: [Improvement] Adjust unrouted data count to not include gaps (josh-a-hicks)

0002761: [Bug] Stuck in loop of "Batch is marked as ready but it has been deleted" (elong)

0002759: [Improvement] Abstract File Parsing Router needs to remove context entries when file is deleted (josh-a-hicks)

0002756: [Improvement] Allow BSH transforms to control if old data is sent to target (josh-a-hicks)

0002757: [Bug] New tables in 3.8 will fail to load on systems that have a mix of 3.8 nodes and < 3.8 nodes (josh-a-hicks)

0002754: [Bug] iSeries can't detect sym tables on startup (elong)

0002752: [Improvement] Optimize DataExtractorService lookupAndOrderColumnsAccordingToTriggerHistory (elong)

0002753: [Improvement] Optimize calls from TransformWriter to enhanceWithImpliedColumns (mmichalek)

0002750: [Improvement] Firebird extract with configurable cast to varchar sizes (elong)

0002749: [Improvement] Firebird "arithmetic exception, numeric overflow, or string truncation" on extract (elong)

0002763: [Bug] UI Problems when a row in sym_data has a bad trigger_hist_id (mmichalek)

0002731: [Bug] Insert of TableReloadRequest fails in Oracle (josh-a-hicks)

0002730: [Improvement] Incoming batch has a new ignore row count (josh-a-hicks)

0002725: [Bug] docs have 404 (elong)

0002736: [Bug] TableReloadRequest does not work when sending data to central (josh-a-hicks)

0002737: [Improvement] Log Connection Failure Stack Trace (mmichalek)

0002740: [Bug] "Did not receive an acknowledgement" using sym_table_reload_request (elong)

0002743: [Bug] The entire list of nodes is looked up during a single node's authentication. This was introduced when caching logic was reverted (chenson)

0002711: [Bug] When system is busy, gaps should wait to expire (elong)

0002714: [New Feature] Upgrade Jetty to the latest 9.2 version and enable websockets (chenson)

0002716: [Bug] Unable to create HSQLDB node (josh-a-hicks)

0002718: [Improvement] Update the documentation for sym_trigger.use_capture_old_data (chenson)

0002705: [Improvement] Record Batch Summaries (mmichalek)

0002708: [Bug] symmetric-ds high cpu usage (elong)

0002710: [Improvement] Buffer Hybrid Pull Status Requests (mmichalek)

0002721: [Bug] Null Pointer on Initial load - sync triggers failed to create trigger (elong)

0002723: [Improvement] Auto configure registration server (elong)

0002728: [Bug] NPE on uninstall using symadmin (elong)

0003130: [Improvement] Guard against case mismatches in trigger id's and router id's when doing table reloads (mmichalek)

0002699: [Improvement] Copy directly to staging when nodes are on same server (elong)

0002997: [Bug] It's not possible to send a reload of just the files right now. (elong)

0002691: [New Feature] Partial initial loads (josh-a-hicks)

0001570: [Improvement] Add custom_before_insert/update/delete_text to trigger for help with routing dependent rows (chenson)

0002420: [Bug] Tutorial on the website gives 404 error (elong)

0002683: [New Feature] Add an api to get trigger text from the ddl utils IDdlReader and implement it for databases that support triggers (rsunderhaus)

0002548: [Improvement] Remove old heap dumps on startup (elong)

0002555: [Bug] REST : postRegisterNode (postRegisterNodeByEngine) using GET method (elong)

0002574: [Improvement] Improve performance of the transfer to and from staging (elong)

0002449: [Bug] File sync sometimes not deleting files with delete_after_sync option (elong)

0002458: [New Feature] Add arbitrary text at the beginning of the trigger (elong)

0002598: [Improvement] DbFill cascade foreign key dependencies (elong)

0002609: [Improvement] Disable file sync by default (elong)

0002611: [Improvement] Heartbeat batches build up when node offline (elong)

0002591: [Improvement] Add transactions to DbFill (elong)

0002618: [New Feature] Throttle network bandwidth usage on channel (elong)

0002638: [Improvement] Allow send-schema to send all tables when no tables as arguments (elong)

0002642: [New Feature] Table trigger configuration to provide included columns setting (josh-a-hicks)

0002651: [Improvement] Add built-in variables for use in beanshell extensions (elong)

0002653: [Improvement] Make unrouted data collection optional (elong)

0002565: [New Feature] Add VoltDB Dialect (mmichalek)

0002635: [Improvement] New data loader type on channels "bulk" to represent any bulk loader if support by platform (josh-a-hicks)

0002661: [Improvement] Perform locking in-memory when clustering is disabled (elong)

0002662: [Improvement] Perform node communication locks in-memory when clustering is disabled (elong)

0002665: [Improvement] Reduce number of times parameters are reread during startup (elong)

0002666: [Improvement] Cache offline node database parameters used by node communication (elong)

0001614: [Improvement] Parallelize the synchronization of triggers to improve performance in a system with lots of tables (elong)

0002667: [Improvement] Use node identity cache (elong)

0002670: [Improvement] Only update sym_node_channel_ctl when using extract millis on channel (elong)

0002671: [Improvement] Use node group link cache for source and target nodes (elong)

0002674: [Improvement] Route for only channels that have data waiting to route (elong)

0002580: [Improvement] Send keepalive during push or pull to prevent connection timeout (elong)

0002668: [Improvement] Use node security cache (elong)

0002677: [Improvement] High CPU for routing to determine common batch status on channels (elong)

0002679: [Improvement] Add event logging to service wrapper start up (elong)

0002680: [Improvement] Avoid updating status of outgoing batch for small batches (elong)

0002681: [Improvement] Only query incoming_error for batch being retried (elong)

0002682: [Improvement] Cache outgoing batch sequences (elong)

0002564: [New Feature] dbcompare feature (mmichalek)

0002577: [Improvement] Separate thread for transfer and loading or extract (elong)

0002603: [Improvement] Retry batches from staging instead of sending them again (elong)

0002658: [New Feature] Initial load defaults to initial load extract in background (josh-a-hicks)

0002675: [New Feature] Ability to add extension point for the purge service (josh-a-hicks)

0002687: [Improvement] Support File Sync on Android (mmichalek)

0002526: [Improvement] Improve performance of data gap detection (elong)

0002547: [New Feature] Notification of system event problems (elong)

0002664: [Improvement] Misc performance improvements (mmichalek)

0002693: [Improvement] Use node cache (elong)

0002701: [Improvement] Disable Offline Push/Pull By Default. (mmichalek)

0002702: [Improvement] High CPU usage from Table.getFullyQualifiedTableName() (elong)

0002704: [Improvement] AbstractDatabasePlatform.parseTimestamp should always return the Timestamp type (rsunderhaus)

0002625: [New Feature] Hybrid Pull Feature (mmichalek)

0002498: [Improvement] Service fails after Java upgrade (elong)

0002477: [Improvement] Add command line options to sym that allow me to run a single push or pull (elong)

0002525: [Improvement] Outgoing load summary was designed to only retrieve "reload" channel. (josh-a-hicks)

0006681: [Bug] Reopening registration for a node that handles registration can orphan nodes from replication (josh-a-hicks)

0006674: [Bug] False conflict change detection on update of Null or Empty values in NVARCHAR(MAX) and VARCHAR(MAX) columns (SQLServer-specific) (pbelov)

0006673: [Bug] When saving extension as a copy the copy does not have the same extension script as the original (cquamme)

0006667: [Improvement] Add logging and user notification when exceptions occur on saving the Console User Form (cquamme)

0006649: [Bug] Enabling or disabling extension resets the script to template (cquamme)

0006669: [Bug] When resolving data by editing the values on the incoming side, null values are lost and replaced with empty strings (pmarzullo)

0006650: [New Feature] Add a way to add a prefix or suffix to transforms when doing auto-create (cquamme)

0006551: [Improvement] Bulk export for SQL Server and Sybase ASE (elong)

0002338: [Improvement] Bulk Extract for MSSQL (elong)

0006549: [Improvement] Process panel able to interrupt if thread is available (elong)

0006436: [Improvement] Change how bulk loaders determine when to flush their data (emiller)

0006544: [New Feature] Bulk loader for Sybase ASE (elong)

0006466: [Improvement] Adding File Sync Service for Azure Blob Storage (mdrouard)

0006648: [New Feature] Support to Pause/Resume Replication For a Given Node (josh-a-hicks)

0006652: [Improvement] Setup panel on dashboard does not need to display progress bar after reaching 100% (josh-a-hicks)

0006653: [Improvement] For monitor dashboard panels check and use the isPinned boolean setting to determine what to display (josh-a-hicks)

0006656: [Bug] REST service NullPointerException when retrieving node with missing node security (elong)

0006658: [Bug] Job and Log monitors need to only report from the Monitor job when new events occur after the last run of the Monitor job (pmarzullo)

0006664: [Bug] DB2 AS400 log miner can lose precision when reading numeric values (emiller)

0006634: [Improvement] Added LoadDataWizard Warning Dialogs when sync Triggers is running, has an error, or is out of date (mdrouard)

0006638: [Bug] Panel on the Outgoing Loads screen (Workflow) has error indicator not cleared after an error was resolved. (mdrouard)

0006615: [Bug] Grid on Manage -> Processes screen is not displayed because of IllegalArgumentException (emiller)

0006607: [Bug] Check processInfo.getCurrentTableName() is not null in Load Detail (mdrouard)

0006609: [Improvement] Tibero 6 support (josh-a-hicks)

0006614: [Improvement] Checking to see if sync triggers has run. Display "?" instead of "-3" (mdrouard)

0006636: [Bug] Add Tables Wizard gets info from the wrong database when not using the source node group's web console & metadata is unavailable (emiller)

0006640: [Bug] Data refesh should exclude disabled trigger routers (elong)

0006558: [Improvement] Add IExtractDataFilter interface to Extension Form screen (pmarzullo)

0006563: [Bug] AS400 log miner support for negative numeric values (josh-a-hicks)

0006564: [Improvement] Various improvements to load detail and loads panel (mdrouard)

0006568: [Bug] Summary 0006563: AS400 log miner support for null numeric values (josh-a-hicks)

0006570: [Improvement] Display max memory on control center (elong)

0006573: [Improvement] SQL Server bulk loader should fail on first error (elong)

0006574: [Improvement] SQL Server bulk loader better row and field terminators (elong)

0006579: [Bug] Clustering does not enable after adding license key or changing from GUI (elong)

0006581: [Bug] Java job validation behaves incorrectly (emiller)

0006583: [Bug] Clicking outside of job script editor causes unexpected behavior (emiller)

0006587: [Improvement] SQL Server bulk loader bcp use quoted identifiers (elong)

0006588: [Bug] Setup program warns of memory available on Linux (elong)

0006589: [Bug] Restart needed after setup wizard downloads of driver (elong)

0006591: [Improvement] Load Detail, Load Panel, and Load Detail Pop up (mdrouard)

0006596: [Improvement] Compare default to chunking for remote and without for local (elong)

0006599: [Improvement] IPurgeListener needs to have the capability to run functionality before the purge outgoing/incoming is run (pmarzullo)

0006550: [Improvement] File Sync to and from S3 bucket storage (mdrouard)

0006546: [Improvement] The add table wizard will not refresh the table list if the database does not support schemas (josh-a-hicks)

0006556: [Bug] CPU monitor is inaccurate for systems with a Mac or Linux OS and more than 1 core (emiller)

0006554: [Bug] Java validation pop-up on extensions screen (elong)

0006553: [Improvement] SQL Explorer privileges for read-only queries (elong)

0006548: [Improvement] Enhancing REST API logging and tracking (jvanmeter)

0006536: [Bug] When importing configuration via the "Connect Database Wizard", sym_console_role does not get populated (cquamme)

0006542: [Improvement] Removed parameter changes associated with Dashboard Layout changes (jvanmeter)

0006534: [New Feature] Added functionality to support Prometheus integration (jvanmeter)

0006527: [Improvement] Added File Sync to Azure Blob Storage (mdrouard)

0006525: [Bug] Creating an extension for IDatabaseWriterFilter prevents batches from loading (elong)

0006523: [Bug] Compare extract table query can fail if initial load select uses table alias (elong)

0006522: [Bug] Failed to compare request with IOException stream closed (elong)

0006519: [Improvement] Split violation screen into tabs. Added ability to delete groups in group violation screen (mdrouard)

0006518: [Bug] Compare missing t alias, cluster lock, support Boolean and LocalDateTime (elong)

0006457: [Bug] Configure -> Table Triggers screen stuck in bulk edit mode (mdrouard)

0006504: [Bug] Compare with CHAR columns with databases using different padding (elong)

0006499: [Improvement] Enhance REST API to allow users to select xml or json for the return type (jvanmeter)

0006501: [Bug] Batch error monitor fails to convert batch details to JSON when they contain a java.sql.Timestamp (emiller)

0006500: [Bug] Kafka throws "Could not find target table" error when "bulk" is used (cquamme)

0006498: [Improvement] Data refresh job defer constraints on table (elong)

0006495: [Improvement] Added on click icon in Node status when node registration is in error (mdrouard)

0006494: [New Feature] License key for jumpmind commerce (jmc) (elong)

0006493: [Improvement] RabbitMQ add content type to header for JSON XML etc (josh-a-hicks)

0006491: [Improvement] Compare support excluded/included column names (elong)

0006490: [Bug] Compare with level 2 statistics gets null pointer exception (elong)

0006479: [Bug] SQL Server log miner replicating bit as true/false instead of 1/0 causing it to load as false (elong)

0006438: [Improvement] Add -b option to SQL Server bcp bulk loader (emiller)

0006430: [Improvement] Allow disabling the ordering of SQL Server log mining output by transaction ID, allowing ordering by foreign key constraints (pmarzullo)

0006404: [Improvement] On the Manage Nodes screen, move the Sync URL column's copy button to the left of the text (emiller)

0006402: [Bug] Transform column editor on Configure Transforms screen can get into a state where a column cannot be deselected (emiller)

0006397: [Improvement] Auto Create Transforms dialog should notify the user if it fails to auto create column mappings (emiller)

0006395: [Improvement] Move bulk loader parameters from symmetric-ds to symmetric-pro (emiller)

0006391: [Improvement] Add parameter to allow null values to remain null when loading into columns with default values using SQL Server bcp bulk loader (emiller)

0006389: [Bug] Bi-directional log-based intermittent unrouted batches that should have routed (elong)

0006455: [Improvement] Conflict detection newer wins for log miners (elong)

0006463: [Improvement] RabbitMQ support for username and password (josh-a-hicks)

0006472: [Improvement] Move REST API parameters to Pro (emiller)

0006464: [Bug] SQL-Server bcp error datetime fractional second precision exceeded (elong)

0006451: [Bug] The logminer fails to serialize/deserialize timestamps (jvanmeter)

0006450: [Bug] Oracle log miner stuck on resetting SCN number ORA-01281 (elong)

0006432: [Improvement] Fixed issue causing auto refresh to uncheck on scroll (mdrouard)

0006443: [Bug] Control -> Toggle Priority button on Manage Nodes screen is only enabled if the current node and selected node are multi-homed (emiller)

0006440: [Improvement] Repair script that handles different table case by using batch CSV (elong)

0006439: [Improvement] Add -b option to SQL Server bcp bulk loader (emiller)

0006426: [Improvement] The batch window should ignore a row in the same way the batch panel ignores a row (cquamme)

0006437: [Improvement] Batch Panels in the UI should show when a batch has rows that were ignored (cquamme)

0006431: [Improvement] Allow disabling the ordering of SQL Server log mining output by transaction ID, allowing ordering by foreign key constraints (pmarzullo)

0006428: [Bug] Compare request may not complete when non-initiating node is the target (elong)

0006427: [Improvement] User feedback on Comparison panel when request is cancelled (elong)

0006425: [Improvement] If a user ignores a row via the "Resolve Data" panel, no console event is logged (cquamme)

0006423: [Bug] Send Table Schema does not list the tables correctly when trigger is defined with wildcard characters for the table name (pmarzullo)

0006422: [Bug] Incorrect console event logging when ignoring a row from Outgoing Batch Panel (cquamme)

0006421: [Improvement] Added auto selection for load data if only one node exists (mdrouard)

0006417: [New Feature] Log miner support for update loop prevention and sync on incoming (elong)

0006418: [Improvement] SQL Server bcp trust server certificate parameter (elong)

0006416: [Bug] MySQL log-based permission check failure can exhaust connection pool (elong)

0006405: [Improvement] On the Manage Nodes screen, move the Sync URL column's copy button to the left of the text (emiller)

0006403: [Bug] Transform column editor on Configure Transforms screen can get into a state where a column cannot be deselected (emiller)

0006399: [Improvement] Auto Create Transforms dialog should notify the user if it fails to auto create column mappings (emiller)

0006396: [Improvement] Move bulk loader parameters from symmetric-ds to symmetric-pro (emiller)

0006398: [Improvement] Allow multi-line editing of delete first parameter (elong)

0006392: [Improvement] Add parameter to allow null values to remain null when loading into columns with default values using SQL Server bcp bulk loader (emiller)

0006390: [Bug] Bi-directional log-based intermittent unrouted batches that should have routed (elong)

0006388: [Bug] SQL Server bcp bulk loader converts zero-length binary values to null values (emiller)

0006379: [Bug] Fixed Use Windows Authentication option not showing in the Runtime Database Settings screen (jvanmeter)

0006382: [Bug] SQL Server log miner should use table cache (elong)

0006378: [Bug] NullPointerException in bcp bulk loader when a batch's row count exceeds the mssql.bulk.load.max.rows.before.flush (emiller)

0006376: [Improvement] Added functionality to support Elasticsearch 8 (jvanmeter)

0006372: [Bug] Source Table field can appear to be blank when editing an existing transform (emiller)

0006368: [Bug] License validation fails when the registration server's sym_node_host row is missing and there are unsent heartbeat batches (emiller)

0006358: [Bug] Filter on Configure Table Triggers screen doesn't work correctly (emiller)

0006348: [Bug] Issue using DbCompare on SQLServer with table names using reserved keywords (elong)

0006387: [Bug] SQL Server bcp bulk loader converts zero-length binary values to null values (emiller)

0006381: [Bug] SQL Server log miner should use table cache (elong)

0006377: [Bug] NullPointerException in bcp bulk loader when a batch's row count exceeds the mssql.bulk.load.max.rows.before.flush (emiller)

0006371: [Bug] Source Table field can appear to be blank when editing an existing transform (emiller)

0006366: [Bug] License validation fails when the registration server's sym_node_host row is missing and there are unsent heartbeat batches (emiller)

0006344: [Improvement] Update user guide to explain how to capture old data for updates when using DB2 for IBM i journaling (emiller)

0006339: [Bug] Debug logging for Db2As400LogMiner doesn't work (emiller)

0005969: [Bug] When using SQL Server Log based, you cannot select two different SQL Server Database instances (jvanmeter)

0006337: [Bug] SQL Server bcp bulk loader can't handle database URLs that specify the server name or port number via connection properties (emiller)

0006336: [Bug] Fix SQL Server bcp bulk loader when instance is unnamed and improve logging (emiller)

0006329: [Bug] When editing an email-type notification, the email address does not display (cquamme)

0006316: [Bug] Add Tables Wizard reads table from wrong database when opened from target node with *.auto.create.trigger.options enabled (emiller)

0006160: [New Feature] Add documentation for RabbitMQ (cquamme)

0006291: [Improvement] Enhance logging surrounding a failure to decrypt node password (elong)

0006345: [Improvement] Update user guide to explain how to capture old data for updates when using DB2 for IBM i journaling (emiller)

0006349: [Improvement] Log when refresh of screen runs longer than a threshold (elong)

0006354: [Improvement] Reduce time to login to web console and access important screens (elong)

0006340: [Bug] Debug logging for Db2As400LogMiner doesn't work (emiller)

0006261: [Improvement] Table group support with log based and time based captures (josh-a-hicks)

0006287: [Improvement] Add table wizard checks configured tables based on trigger id rather than table name (josh-a-hicks)

0006338: [Bug] SQL Server bcp bulk loader can't handle database URLs that specify the server name or port number via connection properties (emiller)

0006330: [Bug] When editing an email-type notification, the email address does not display (cquamme)

0006322: [Improvement] Console event for cancelling a load request (elong)

0006319: [Improvement] Replace deprecated vaadin.whitelisted-packages property (emiller)

0006317: [Bug] Add Tables Wizard reads table from wrong database when opened from target node with *.auto.create.trigger.options enabled (emiller)

0006314: [New Feature] Add symconsole subcommand to generate a REST API key (emiller)

0006249: [Improvement] CPU monitor should use Java routine if native command not available (elong)

0006231: [New Feature] Time-Based Capture Feature (josh-a-hicks)

0006254: [Improvement] Blocked transaction monitor continuously logs error if missing permissions (elong)

0006258: [Bug] Lookup table router with log mining (elong)

0006284: [Bug] Remote status with websockets broken after Spring Boot transition (elong)

0006290: [Improvement] MSSQL Bulk Loader (BCP) parameter to allow the instance value to be omitted from the command (josh-a-hicks)

0006305: [Improvement] Compare repair snapshot and logging (elong)

0006307: [Bug] Syntax error when updating sym_table_reload_status using a Progress OpenEdge database (emiller)

0006239: [Improvement] Deleting items on a Configure screen should not create the UI for the form (emiller)

0006309: [Bug] LOBs should not be included in where clauses when using a Progress OpenEdge database (emiller)

0006304: [Improvement] Progress OpenEdge platform should have a dirty SQL template (emiller)

0006232: [Bug] Node group summary database icons sometimes broken (cquamme)

0006295: [Bug] Compare repair table request gets stuck in inconsistent state (elong)

0006286: [Bug] IndexOutOfBoundsException occurs when trying to access incoming batch data in error via the UI (cquamme)

0006294: [Improvement] Compare repair allow tables without PK if user sets sync key names (elong)

0006293: [Improvement] Compare repair UI improvements (elong)

0006289: [Bug] Compare request can't update status, loops creating new request IDs (elong)

0006183: [Bug] Terminal on Manage Nodes screen does not work

0006137: [Bug] take snapshot from license violation screen does not show the snapshots to download them (pmarzullo)

0006268: [Bug] Registration failing when registering node is remote and SMTP password is set to null in sym_parameter (emiller)

0006250: [Bug] Registration failing when registering node is remote and SMTP Mail Server authentication is configured (pmarzullo)

0006230: [Bug] DB2 AS400 iSeries failed to mine log for numeric data types that had a scale. (josh-a-hicks)

0006260: [Bug] Comparison screen views repair script as garbage binary when encrypted staging is enabled (elong)

0006257: [Bug] Design wizard creates lookup table router with unknown type (elong)

0006255: [Improvement] Snowflake default connection to continue to use JSON instead of Apache Arrow (josh-a-hicks)

0006247: [Improvement] Unknown monitor type with older nodes causes excessive logging (elong)

0006238: [Bug] When the Process Builder returns non-zero for the Bulk Loader Screen, an UnknownFormatException can occur (cquamme)

0006236: [Improvement] Add logging for if the Bulk Loader Screen has a failure (cquamme)

0006242: [Improvement] Improve performance of table selection in Add Tables Wizard (emiller)

0006241: [Bug] Switching engine not taking effect on Manage Comparison panel (elong)

0006237: [Bug] Health panel should not count insights (emiller)

0006233: [Bug] SAML authentication does not work with a load balancer (emiller)

0006228: [Improvement] Prevent empty identifier on configure screens (elong)

0006227: [Bug] If import config during first setup contains license, don't prompt for license (elong)

0006005: [Bug] "Enter" keyboard shortcut in wizards does not consistently work when using Chrome or Edge (emiller)

0006204: [Bug] Selection on Manage Installed Triggers screen does not behave correctly when filtering the grid (emiller)

0006213: [Bug] Encrypted parameter values need to be decrypted before saving into the batch file when synchronizing (pmarzullo)

0006216: [Bug] MySQL Bulk Loading documentation in appendix missing images (pmarzullo)

0006218: [New Feature] Subselect router support for SOURCE_NODE_ID variable (josh-a-hicks)

0006220: [Bug] Incoming Panel on dashboard does not show bulk loading correctly (pmarzullo)

0006136: [Improvement] Look into using Launch4j to start java on Windows (pmarzullo)

0006172: [Improvement] Windows service executable that launches Java (elong)

0006225: [Improvement] Compare and repair subsets, also fixes for scale, sort column names, viewing scripts (elong)

0006215: [Bug] Violation Edit Panel throws exceptions when parsing JSON text for reset of statistics dates and when generating JSON strings (pmarzullo)

0006202: [Improvement] Make "Active Errors" dialog display all severe monitor events (emiller)

0006200: [Improvement] Remove securityToken parameter from /outgoingBatchSummary REST API call (emiller)

0006033: [Bug] Work queued via BackgroundRefresherService sometimes does not get done (elong)

0006197: [Bug] Failed to queue work because the background refresher service has been shut down (elong)

0006169: [Improvement] Improving and Re-evaluating the Email Verification Process (jvanmeter)

0006191: [Improvement] SQL-Server log mining should not require snapshot isolation (elong)

0006187: [Bug] Enabling change tracking on MSSQL should not use brackets (josh-a-hicks)

0006186: [Bug] Configure -> Table Routing screen stuck in bulk edit mode (elong)

0006182: [Bug] Table name filter in Load Data Wizard doesn't work (emiller)

0006180: [Bug] "Allow changes from SQL to be captured" checkbox doesn't work when sending SQL (emiller)

0006167: [Bug] Checking for root user during installation fails even when user is root (pmarzullo)

0006161: [Bug] Mail Server checked wrong class for encryption type and password (jvanmeter)

0006190: [Improvement] SQL-Server log mining should not require snapshot isolation (elong)

0006203: [Bug] Selection on Manage Installed Triggers screen does not behave correctly when filtering the grid (emiller)

0006208: [Bug] Encrypted parameter values need to be decrypted before saving into the batch file when synchronizing (pmarzullo)

0006221: [Bug] Incoming Panel on dashboard does not show bulk loading correctly (pmarzullo)

0006030: [Bug] Work queued via BackgroundRefresherService sometimes does not get done (elong)

0006196: [Bug] Failed to queue work because the background refresher service has been shut down (elong)

0006181: [Bug] Table name filter in Load Data Wizard doesn't work (emiller)

0006179: [Bug] "Allow changes from SQL to be captured" checkbox doesn't work when sending SQL (emiller)

0006063: [New Feature] Add support for RabbitMQ (cquamme)

0006147: [Bug] SQL-Server bulk load bcp integrated security (elong)

0006121: [Bug] Save As Copy in GUI always keeps saved object as selected (pmarzullo)

0006158: [Bug] Upgrade of module can fail on Windows because files are locked (elong)

0006125: [Improvement] Ensure subset data wizard does not create a router id that exceeds max length of table (josh-a-hicks)

0006157: [Bug] Getting logged out after returning to SymmetricDS with 'Session Limit Exceeded' (elong)

0006149: [Improvement] Set query time out for log based support to match trigger based (josh-a-hicks)

0006126: [Improvement] Prevent users from creating triggers for a load-only node group via the Add Tables Wizard (emiller)

0006142: [Bug] Postgres log miner parsing exception with NULL value (elong)

0006138: [Bug] Refresh loop after hitting refresh button in browser (elong)

0006123: [New Feature] Add Unknown Certificate Authority insight (emiller)

0006120: [Bug] JsonIOException fails to deserialize log summary event (elong)

0006114: [Improvement] Add process info to support snapshot (elong)

0006111: [New Feature] Make it possible to log in via SAML without having a corresponding console user (emiller)

0006109: [Bug] Web console is unresponsive after logging in via SAML (emiller)

0006110: [Bug] Logging in via SAML results in the web console repeatedly reloading itself (emiller)

0006108: [New Feature] Make it possible to log in via LDAP without having a corresponding console user (emiller)

0006118: [Bug] The logminer fails to serialize/deserialize timestamps (jvanmeter)

0006151: [Bug] StringIndexOutOfBoundsException when switching screens when the web console's URL doesn't end with "/app" (emiller)

0006141: [Bug] Postgres log miner parsing exception with NULL value (elong)

0006117: [Bug] Save As Copy in GUI always keeps saved object as selected (pmarzullo)

0006119: [Bug] JsonIOException fails to deserialize log summary event (elong)

0006113: [Improvement] Add process info to support snapshot (elong)

0006067: [Improvement] Windows service fails to start when desktop is slow to initialize (elong)

0006101: [Improvement] Add more details to the Rest Keys section of the User Guide (emiller)

0006092: [Bug] Add Table(s) Wizard should not specify the catalog/schema name for a new trigger if it is the default catalog/schema (emiller)

0006084: [Bug] ElasticSearch Data Writer should use upsert functionality when updating records (pmarzullo)

0006065: [Improvement] "Open Web Console" button in SymmetricDS Pro Control Center should get the hostname from the host.bind.name property (emiller)

0006062: [Improvement] Add Table(s) Wizard should not query for metadata when filtering table names (emiller)

0006077: [Bug] Protect against exceptions in CPU monitor (emiller)

0006027: [Bug] SQL Server Bulk issue when batch column count is different than target table column count (pmarzullo)

0006068: [Improvement] Windows service fails to start when desktop is slow to initialize (elong)

0006090: [Bug] Log off not closing session (elong)

0006105: [Bug] Setting up a new log based or extract only node via the Add Database Wizard causes a JdbcSQLFeatureNotSupportedException (emiller)

0006102: [Improvement] Add more details to the Rest Keys section of the User Guide (emiller)

0006093: [Bug] Add Table(s) Wizard should not specify the catalog/schema name for a new trigger if it is the default catalog/schema (emiller)

0006089: [Bug] Elastic Search module needs httpclient from apache to be installed (pmarzullo)

0006088: [Bug] Spring Boot builds unnecessary ElasticsearchRestClientAutoConfiguration bean when elastic search module jars are installed (pmarzullo)

0006075: [New Feature] Add stranded data insight (emiller)

0006085: [Bug] ElasticSearch Data Writer should use upsert functionality when updating records (pmarzullo)

0006078: [Bug] db.init.sql parsing needs to allow values to contain semicolons, specified as 2 semicolons in the value (pmarzullo)

0006070: [Bug] Compare and repair table using Sybase reserved keyword (elong)

0005882: [Improvement] Postgres Log Mining Enhancements (emiller)

0006066: [Improvement] "Open Web Console" button in SymmetricDS Pro Control Center should get the hostname from the host.bind.name property (emiller)

0006060: [Bug] Sybase ASE generated column query fails on versions older than 16 (elong)

0006061: [Improvement] Add Table(s) Wizard should not query for metadata when filtering table names (emiller)

0006058: [Improvement] Dashboard Health panel should have a separate message for system batches (emiller)

0006056: [New Feature] Add priority column and Control -> Toggle Priority button to Manage Nodes screen (emiller)

0006054: [Improvement] Move Unlock feature of Manage Nodes screen back to the Control dropdown (emiller)

0006053: [Bug] List of table names in Add Table(s) Wizard can extend below the bottom edge of the layout (emiller)

0006049: [New Feature] Add connection pool insight (emiller)

0006048: [Bug] Oracle statement parser does not handle the case when the column names in the where clause are prefixed with the table name (emiller)

0006045: [Improvement] Improve details of CPU and memory monitor events (emiller)

0006042: [New Feature] Add Registration -> Show Rejected menu option to Manage Nodes screen (emiller)

0006038: [Improvement] Upgrade to Vaadin 24.2 and use the new SvgIcon class (emiller)

0006037: [New Feature] Add LOB insight (emiller)

0006031: [New Feature] Add connection reset insight (emiller)

0006029: [Bug] LogMinerService debug log issue when logging close of miner and start and end SCN ids (pmarzullo)

0006024: [Bug] JsonSyntaxException when deserializing monitor event details (emiller)

0006022: [Improvement] Oracle log miner should skip the SQL statement instead of throwing an exception when the SQL is empty or the schema is null (emiller)

0006020: [Bug] Oracle log miner stuck on resetting SCN number ORA-01281 (elong)

0006009: [Improvement] Connect Database Wizard should prevent the user from using the Microsoft driver for SQL Server 2005 or older (emiller)

0006000: [New Feature] Add import-cert subcommand to symadmin (emiller)

0005998: [Bug] Error viewing job history on Manage -> Jobs screen (elong)

0005997: [Improvement] Selecting a multi-node row on the Manage Nodes screen should select all of the child rows (emiller)

0005995: [Improvement] Load screens should not reset their sort order on refresh (emiller)

0006019: [Bug] Oracle log miner stuck on resetting SCN number ORA-01281 (elong)

0006026: [Bug] SQL Server Bulk issue when batch column count is different than target table column count (pmarzullo)

0006059: [Bug] Sybase ASE generated column query fails on versions older than 16 (elong)

0006047: [Bug] Oracle statement parser does not handle the case when the column names in the where clause are prefixed with the table name (emiller)

0005989: [Bug] Details in Load Screen can contain information for the incorrect load (cquamme)

0006028: [Bug] LogMinerService debug log issue when logging close of miner and start and end SCN ids (pmarzullo)

0006018: [Improvement] Oracle log miner should skip the SQL statement instead of throwing an exception when the SQL is empty or the schema is null (emiller)

0006008: [Improvement] Connect Database Wizard should prevent the user from using the Microsoft driver for SQL Server 2005 or older (emiller)

0005999: [New Feature] Add import-cert subcommand to symadmin (emiller)

0005975: [Bug] Upgrading from open source to pro is missing pro tables (elong)

0005996: [Improvement] Selecting a multi-node row on the Manage Nodes screen should select all of the child rows (emiller)

0005994: [Improvement] Load screens should not reset their sort order on refresh (emiller)

0005993: [Improvement] Make columns on Manage Nodes screen sortable (emiller)

0005990: [Improvement] Silent uninstall (elong)

0005988: [Bug] OracleStatementParser should not throw exception for empty sql or sql that is a comment (cquamme)

0005987: [Improvement] Enhance logging for JSQLParserException in OracleStatementParser (cquamme)

0005979: [Bug] Load Data Wizard doesn't show multiple different table routers as options. (jvanmeter)

0005973: [Bug] DB2 iSeries journal based capture support when old data is not present on updates (josh-a-hicks)

0005978: [Improvement] Console event for cancel load include load ID (elong)

0005977: [Bug] Database performance test broken on SQL-Server and others (elong)

0005974: [Bug] DB2 iSeries log miner connection leak (josh-a-hicks)

0005968: [Bug] Microsoft MsSQL jdbc driver does not handle synchronization of uniqueidentifiers correctly. (jvanmeter)

0005967: [Bug] Unable to select a different runtime database than the same one used for application tables (log based setups) (josh-a-hicks)

0005962: [Bug] Manage->Outgoing Batches, selecting channel, moving away from screen and coming back loses previous selection (pmarzullo)

0005959: [Bug] Error when replicating DDL for table with SQL Server smallmoney column (emiller)

0005958: [Bug] SQLServerException when using the SQL Server Azure bulk loader with Azure cloud storage (emiller)

0005956: [Bug] Displays "logging off" forever if an engine doesn't start (elong)

0005951: [Bug] "Edit privileges" button in web console's Configure->Roles tab grayed out at wrong times (JishLong)

0005920: [Improvement] Snowflake Reload Duplicate Prevention (jvanmeter)

0005947: [Bug] Onprem to cloud infrastructure script makes routers in same direction (pmarzullo)

0005939: [Improvement] Upgrade S3 functionality and add JSON output (JishLong)

0005929: [Improvement] Remove use of javax.xml.bind.DatatypeConverter in ConsoleUser.java (JishLong)

0006235: [Bug] Linking table is failing to replicate with error "There is 1 table without a primary key, which can cause slow replication." (pmarzullo)

0005928: [Improvement] Use sym_outgoing_error table to ignore a row in outgoing batch (cquamme)

0005796: [Improvement] MongoDB bidirectional nested data sync (cquamme)

0005972: [Improvement] Unlock feature of Nodes Panel should be in Registration dropdown (cquamme)

0005830: [New Feature] Allow console users to login using SAML authentication (emiller)

0005758: [New Feature] Add break glass users (emiller)

0005589: [Improvement] Move REST API to SymmetricDS Pro (emiller)

0005637: [Improvement] Set SET MODE LEGACY in db.init.sql for H2 databases in engines, remove DB_CLOSE_ON_EXIT from db URL if AUTO_SERVER also set (pmarzullo)

0005789: [Improvement] Move and enhance monitors and notifications for SymmetricDS Pro (emiller)

0005838: [New Feature] Log miner for MariaDB database (emiller)

0005917: [New Feature] Add insight manager to dashboard and replace integrity checks with insights (emiller)

0005941: [Improvement] Enhance User Roles with Hierarchy (JishLong)

0005945: [New Feature] Compare and repair with remote nodes (elong)

0005952: [New Feature] Add job trending insight (emiller)

0005953: [New Feature] Replace unsent batch monitor with one for online nodes and another for offline nodes (emiller)

0001613: [New Feature] Add the ability to resend a batch by reload that has been ignored or has had a row ignored (cquamme)

0004968: [Bug] Oracle log miner SQL parser exception from backslash value (emiller)

0005137: [Improvement] Upgrade to Vaadin 24 (emiller)

0005591: [New Feature] Add symconsole subcommands to REST API (emiller)

0005769: [Improvement] Optimize startup of all screens by waiting until they're opened to query and populate data (emiller)

0005861: [Improvement] Improve accuracy of CPU monitor (elong)

0005963: [Improvement] License key command line operations (emiller)

0005900: [Improvement] Upgrade BigQuery functionality to work with current BigQuery version (JishLong)

0005924: [Bug] When you select "Sent Data" for an ignored batch it incorrectly says it "Failed to Parse Batch" (cquamme)

0005923: [Bug] Grid on Manage Nodes screen has no items selected but its select all checkbox is not unchecked (emiller)

0005918: [Bug] Cannot rebuild multiple missing triggers via the Rebuild button on the Manage Installed Triggers screen (emiller)

0005911: [Improvement] Add documentation for web console timezone setting (emiller)

0005910: [New Feature] Add option for the web console to display dates and times in the browser's timezone (emiller)

0005908: [Improvement] Improve debug logging for Oracle log miner (emiller)

0005888: [Bug] MSSQL log based support for wildcard triggers (josh-a-hicks)

0005887: [Improvement] Monitor enhancements for centralized support (josh-a-hicks)

0005905: [Improvement] Oracle log miner should reset the SCN when it encounters error ORA-01281 (emiller)

0005902: [Bug] The BCP writer for MsSql is not able to parse db urls with backslashes (cquamme)

0005899: [Bug] FileSync tries to process a file change if the Source Directory doesn't exist on a node in a cluster (jvanmeter)

0005891: [Improvement] Adding "Date Time Format" Option for DbCompare in the UI (cquamme)

0005890: [Improvement] Automatically install azurekv module when adding a new SQL Server Azure node with authentication=ActiveDirectoryPassword (emiller)

0005889: [Bug] NullPointerException when saving a new load profile for the first time (emiller)

0005876: [New Feature] Manage Jobs screen with run history and error status (emiller)

0005874: [Bug] Updated Snowflake Builder to handle Bit Type (jvanmeter)

0005881: [Bug] Snowflake DML Statement does not get the column name before trying to convert. (jvanmeter)

0005879: [Improvement] Email validation when configuring new notifications (JishLong)

0005878: [Improvement] Integrity check for high number of unique channel queue names (JishLong)

0005872: [New Feature] Add integrity checks for configuration, heartbeat, and user data loops (emiller)

0005875: [Improvement] Shutdown Hook is causing OutOfMemoryError for some users (cquamme)

0005859: [Bug] Some privileges not getting hidden from UI even when set as "Hidden" (cquamme)

0005866: [Bug] Batch ID in Sync Errors section of Active Errors dialog links to incorrect batch screen (emiller)

0005864: [Improvement] Make it possible to set a monitor's expression via the Configure Monitors screen (emiller)

0005862: [Bug] File Sync Activity Dashboard panel displays activity for all channels when file sync is disabled (emiller)

0005856: [Improvement] "Ignore Row" in Outgoing and Incoming Batch Panels should have an associated permission (cquamme)

0005841: [Improvement] Adding "Wizards" Tab in Console Role Edit Panel (cquamme)

0005844: [Improvement] Vaadin warning in logs about vaadin license checking and live reload not being enabled (pmarzullo)

0005804: [Bug] Deactivated table (dropped trigger) is allowed to be requested for a partial load (pmarzullo)

0005795: [Bug] SQL Server log miner skips over changes on a busy system (emiller)

0004179: [Bug] After cancelling an initial load in Interbase received a Data Type Unknown exception. (pmarzullo)

0005777: [New Feature] Outgoing and incoming batch screens to show file names for summary on file sync channels (josh-a-hicks)

0005776: [New Feature] DB2 iSeries AS400 support for RRN (row identifier column) to be captured and sent during CDC and initial load. (josh-a-hicks)

0005785: [Bug] DBCompare fixes (cquamme)

0005821: [Bug] DB Compare "use config" option not working as expected (cquamme)

0005829: [Bug] When connecting to Redshift a "Driver Not Found" popup will occur even when the driver is available (cquamme)

0005756: [Bug] Snowflake Bulk Loader fails to load values with special characters (pmarzullo)

0005819: [Improvement] OutgoingBatchService loadPendingBatches should use read uncommitted to minimize deadlocking possibilities (pmarzullo)

0005816: [Improvement] Control setting snapshot isolation on MSSQL through a parameter (josh-a-hicks)

0005813: [Bug] DB Compare dialog lists tables from the wrong database on a log-based node (emiller)

0005808: [Bug] SQL Explorer DB Compare does not refresh schemas when changing catalog selection (pmarzullo)

0005806: [Bug] Cloud bulk load fails when source and target table columns do not match (pmarzullo)

0005735: [Bug] Some Downloads Not Working on Firefox Browser (cquamme)

0005798: [Improvement] Order the batches on the Manage Outgoing Batches screen by both batch ID and node ID (emiller)

0005797: [New Feature] Make it possible to view the details of a registration request by double-clicking it on the Manage Nodes screen (emiller)

0005786: [Bug] Grid on Manage Nodes screen is empty when viewing the web console on a 3rd-tier (or lower) node (emiller)

0005771: [New Feature] Add File Sync Activity panel to Dashboard (emiller)

0005741: [Improvement] Java router code assistance (cquamme)

0005772: [Improvement] Add cluster information to info URI (elong)

0005773: [Bug] Login dialog should check if engine is initialized (cquamme)

0005768: [Improvement] Add schema names to where clause of Oracle log miner query (emiller)

0005764: [Improvement] Manage Outgoing/Incoming Loads screens should not query sym_table_reload_request once per load (emiller)

0005763: [New Feature] Add license and load subcommands to symconsole command (emiller)

0005761: [Bug] Validation fails for valid users on Windows when you try to setup "Install service to run automatically" (cquamme)

0005760: [Improvement] Conflict screen current detection should be based on conflict.default.pk.with.fallback parameter (cquamme)

0005759: [Bug] Oracle Log Mining should consume unknown DML type when reading transaction log (pmarzullo)

0005755: [Improvement] Next button on Connect Database Wizard's Registration URL screen should always be enabled (emiller)

0005748: [Improvement] License check should use cached call for find all nodes (cquamme)

0005814: [Bug] DB Compare dialog lists tables from the wrong database on a log-based node (emiller)

0005794: [Bug] SQL Server log miner skips over changes on a busy system (emiller)

0005787: [Bug] Grid on Manage Nodes screen is empty when viewing the web console on a 3rd-tier (or lower) node (emiller)

0005751: [Bug] Downloading Incoming/Outgoing batches does not Decrypt (jvanmeter)

0005750: [Bug] Conflict Strategy column on Configure File Routing screen shows incorrect value for OLDER_WINS and NEWER_WINS (emiller)

0005744: [Bug] Edit Script button on Configure Extensions screen has confusing behavior when multiple extensions are selected (emiller)

0005739: [Bug] Background refresher threads left behind on logout (elong)

0005733: [Bug] Images do not show up when deploying SymmetricDS Pro to Tomcat as a WAR file (emiller)

0005716: [Bug] IllegalArgumentException when editing a custom transform column (emiller)

0005730: [Bug] Downloading Incoming/Outgoing batches does not Decrypt (jvanmeter)

0005703: [New Feature] Log based setups can now choose another platform for runtime tables other than H2 (josh-a-hicks)

0005749: [Bug] Conflict Strategy column on Configure File Routing screen shows incorrect value for OLDER_WINS and NEWER_WINS (emiller)

0005743: [Bug] Edit Script button on Configure Extensions screen has confusing behavior when multiple extensions are selected (emiller)

0005704: [New Feature] DB2 iSeries AS400 support for log / journal based capture (josh-a-hicks)

0005738: [Bug] OracleStatementParser fails to parse lob write when lob contains semicolon newline (cquamme)

0005734: [Bug] Load Data Wizard prevents the user from continuing when file triggers are configured but no table triggers are configured (emiller)

0005726: [New Feature] Add support for Progress OpenEdge databases (emiller)

0005732: [Bug] Images do not show up when deploying SymmetricDS Pro to Tomcat as a WAR file (emiller)

0005727: [Bug] IllegalArgumentException on Manage Incoming/Outgoing Loads screens (emiller)

0005725: [Improvement] SetupDatabaseScreen Database Type drop down sorting change (pmarzullo)

0005715: [Bug] IllegalArgumentException when editing a custom transform column (emiller)

0005713: [Bug] Outgoing/Incoming Batch Panels fail when sorting grid by Bulk Loader Flag (pmarzullo)

0005701: [Bug] Processing of all event types except insert, update and delete are skipped in cloud bulk database writer (pmarzullo)

0005694: [New Feature] Pre-populate extension script based on interface name and extension type (emiller)

0005660: [Bug] On prem to cloud profile not correct (josh-a-hicks)

0005661: [New Feature] Load Data Wizard default setting for send or receive check box (josh-a-hicks)

0005666: [Improvement] Azure Managed Instance Bulk Loading hash azure tokens for blob storage and credentials recreation (josh-a-hicks)

0005674: [Bug] MongoDB fixes for bidirectional sync (cquamme)

0005689: [Bug] Logging out of UI after running a job like sync triggers can interrupt job (elong)

0005684: [Improvement] Allow interface name to be specified when creating/editing a Java extension (emiller)

0005683: [Bug] Script editor doesn't always show error message when validation fails for Java code (emiller)

0005681: [Bug] Edit Script button on Configure Extensions screen gets disabled unnecessarily (emiller)

0005670: [Bug] Incorrect logic in MongoDB DDL Reader causes alter SQL to try and drop primary key (cquamme)

0005669: [Bug] A trigger's sync on insert/update/delete conditions can get set to "1=1" when editing table routing (emiller)

0005668: [Bug] Prevent Add Tables Wizard from asking the user if triggers should be bidirectional when the source & target groups are the same (emiller)

0005643: [New Feature] Requesting a full load in load wizard will not cancel existing loads to same target node if reload select is populated (josh-a-hicks)

0005665: [Bug] Cloud bulk loader fails when create tables are requested (josh-a-hicks)

0005639: [Bug] Background refresher threads left behind on logout (elong)

0005647: [Bug] Appearance setting (light/dark mode) does not get correctly applied when page is refreshed (emiller)

0005642: [Bug] Console Table Stats inserts do not take into account a clustered environment (pmarzullo)

0005634: [Improvement] Ensure that SQL Server log miner always captures deletes in foreign key order (emiller)

0005626: [Bug] Editing transform columns (add/edit/delete) does not specify the column transform order (pmarzullo)

0005620: [Improvement] Warning from attempting to access user guide (elong)

0005618: [Bug] Allow user to unlock locked out remote node (pmarzullo)

0005616: [Bug] Pro Docker image contains unwanted files in tmp and logs directories (emiller)

0005614: [Bug] Router Form issue with router expression validator (pmarzullo)

0005555: [New Feature] Adding Console Event for Ignoring Incoming/Outgoing Rows in Batch (cquamme)

0005568: [Bug] Azure BCP Bulk Loading Fails (cquamme)

0003939: [Improvement] During Uninstall add option to remove nodes in database (emiller)

0003570: [New Feature] Allow create of SymmetricDS console users through either symadmin or rest service (emiller)

0005482: [Improvement] Adding Ability to Set Privileges To Determine Which Type of Roles Can Choose Specific Criteria in Data Load Wizard (cquamme)

0005516: [New Feature] Add initial.load.reload.select.override parameter and add associated screen to Load Data Wizard (emiller)

0005534: [Bug] Sync Errors table in Active Errors dialog contains incorrect data when node IDs contain hyphens (emiller)

0005537: [Bug] Checkbox on Configure Parameters screen hides parameters that aren't set at the selected level (emiller)

0005538: [New Feature] Integrity test that checks configuration and environment (elong)

0005548: [Improvement] Get rid of "<Not Specified>" option when selecting tables in the Load Data Wizard (emiller)

0005550: [Bug] Leaving where clause screen of Load Data Wizard while editing a where clause causes unexpected behavior (emiller)

0005552: [Improvement] Prevent adding same node multiple times locally hosted (elong)

0005561: [Bug] IndexOutOfBoundsException when opening missing primary key dialog (emiller)

0005562: [Bug] MsSQL BCP fails if the target node is Load-Only (jvanmeter)

0005564: [New Feature] Clustered custom job (elong)

0005566: [Bug] Default template does not appear in email notification template editor (emiller)

0005567: [New Feature] Add Import URL button to the Authorities tab of the Manage Security screen (emiller)

0005569: [Bug] Filter dropdowns on Configure Table Triggers screen can be blank (emiller)

0005572: [Improvement] Oracle Log Miner to omit changes for the 'APPLSYS' user (josh-a-hicks)

0005575: [Bug] Various bugs with editing and deleting jobs on the Configure Jobs screen (emiller)

0005576: [Improvement] Clear grid selection when switching to a different Configure screen (emiller)

0005590: [Bug] Cannot change a built-in cron job into a periodic job via the Configure Jobs screen (emiller)

0005601: [Bug] Upgrade Jetty, PostgreSQL driver, Vaadin (elong)

0005609: [Improvement] Replace deprecated cacls command with icacls command (emiller)

0005432: [Bug] Users With Read-Only Role Get NullPointerException When Accessing Parameters Screen (cquamme)

0005443: [Bug] Tables can be in wrong order in Auto Create Table Triggers dialog (emiller)

0005444: [Bug] Routers unexpectedly pre-selected in Auto Create Table Routing dialog (emiller)

0005446: [Bug] Pressing the escape key to exit a form while a select box is open results in the options remaining focused on the screen (emiller)

0005461: [Bug] Startup parameter console.explore.show is not functioning properly (pmarzullo)

0005470: [Bug] UI can become unstable when viewing batch screens (elong)

0005474: [Bug] Load filters do not work when using bcp bulk loader (emiller)

0005454: [Improvement] Connect Database Wizard Registration URL Screen Fixes (cquamme)

0005458: [Improvement] Router Expressions Now A Required Field for Routers That Won't Work Without Them (cquamme)

0005434: [Bug] Users with Read-Only Role Getting Exception When Logging In and Table Triggers Editable (cquamme)

0005442: [Bug] Unexpected behavior in Auto Create Table Triggers dialog (emiller)

0005445: [Bug] Routers unexpectedly pre-selected in Auto Create Table Routing dialog (emiller)

0005447: [Bug] Pressing the escape key to exit a form while a select box is open results in the options remaining focused on the screen (emiller)

0005448: [New Feature] Add Auto Create Group dialog (emiller)

0005451: [Improvement] Always create a default router after creating a new group link (emiller)

0005462: [Improvement] Adding Command and Variable Dropdowns To "Enter SQL to Send" Screen and Parameter Editing Screens With SQL (cquamme)

0005465: [Bug] UI can become unstable when viewing batch screens (emiller)

0005466: [Improvement] Push registration, when sync URL is empty for registering node, should allow Pull registration to recover from empty sync URL (pmarzullo)

0005467: [Improvement] Failed login notifications should close by themselves (emiller)

0005469: [Improvement] Adding Built-in Variables and Data Variables Dropdowns on "Enter BSH Script to Send" Screen (cquamme)

0005471: [Bug] Images fail to load on the Design tab for some database types (emiller)

0005473: [Improvement] Wizard screens with TwinColSelect components should have scrollbars on the components instead of the window (emiller)

0005475: [Improvement] Outgoing and incoming load screens are slow (elong)

0005478: [New Feature] Add "Send -> Send ..." option to Manage Nodes screen (emiller)

0005479: [Improvement] Installer should make control center exit (elong)

0005480: [Improvement] If installer stops service, then installer should start service when done (elong)

0005498: [Bug] UI detached error during registration (elong)

0004008: [Improvement] Web console "signing out" forever when database not available (cquamme)

0004406: [Bug] Logging in says "Logging Off" after selecting Clear Error then restarting instance (cquamme)

0005428: [Improvement] SQL Server Azure Managed Instance Detection while setting up bulk loading (josh-a-hicks)

0003554: [Improvement] Postgres bulk loader throws error if more columns in source than target (emiller)

0003947: [Bug] Dashboard configure is inaccurate for multiple views of same view (emiller)

0005391: [Bug] Settings missing from console-service-settings.json can cause NPEs (emiller)

0005396: [Bug] Postgres bulk loader skips SQL event if table is missing (elong)

0005377: [Improvement] Manage Load Screens Show When Batch Is In Error and Ignoring A Row Directly From Manage Batch Screens (cquamme)

0003490: [Improvement] Change sym_channel.reload_flag to 0/1 when its used by sym_trigger.channel_id/reload_channel_id (emiller)

0003702: [Bug] Dashboard Setting's Preview pane doesn't correctly refresh when you add components that cause a new row (emiller)

0005402: [Improvement] Improved support for MSSQL Azure Managed Instance (josh-a-hicks)

0005403: [Bug] Missing PK warning doesn't go away if the related trigger is deleted (emiller)

0005408: [Bug] Interrupt button disables and selection doesn't persist on Manage Processes screen (emiller)

0005407: [Bug] UniqueKeyException when bulk editing trigger routers (emiller)

0005409: [Bug] NPE on Bulk Loader screen of Connect Database Wizard when setting up a SQL Server node (emiller)

0005410: [Bug] Cancel load and some batches continue to load (elong)

0005411: [Bug] After installing SwaggerUI, engine won't start (elong)

0005420: [New Feature] In the Auto Create Transforms dialog, let the user choose whether all columns should be mapped for them (emiller)

0005426: [Improvement] Allow multi-selection when editing transform columns (emiller)

0005429: [Bug] Node registering over push is not sent config for professional tables (elong)

0005394: [Bug] An NPE can occur when editing or deleting transforms (emiller)

0005397: [Bug] Grid on Manage Installed Triggers screen maintains selection when it shouldn't (emiller)

0005379: [Bug] Options in change dropdown on outgoing batch screen get disabled when auto refresh is on (emiller)

0005367: [Bug] IllegalArgumentException prevents user from viewing batch data (emiller)

0005372: [Bug] Cursor skips to end of editor when entering a period into an Ace Editor (emiller)

0005373: [Bug] NPE when Choose Admin User screen of Node Setup Wizard updates its properties (emiller)

0005382: [Improvement] Improve appearance/behavior of batch window (emiller)

0005399: [Bug] Grid on Configure Jobs screen doesn't update automatically when a job is created or deleted (emiller)

0005338: [New Feature] Flag for If Batch Was Bulk Loaded and Showing Percentage of Batches Bulk Loaded in a Load (cquamme)

0005222: [Improvement] Improve quick config wizard when opened from Configure Table Triggers screen (emiller)

0005226: [Improvement] Improve how the router form handles Target Table, Target Catalog, and Target Schema fields (emiller)

0004795: [Improvement] Improve router expression editor (emiller)

0005344: [Improvement] Documentation for Bulk Loading (cquamme)

0005241: [Improvement] Log license validation error when license error occurs (pmarzullo)

0005076: [New Feature] S3 Dialect Implementation (jvanmeter)

0005311: [Bug] SingleStore Gives Trigger-Based as a Configuration Mode, But Does Not Currently Support Trigger-Based (cquamme)

0005336: [Bug] Snowflake Databases Fail to Bulk Load (cquamme)

0005348: [Bug] MySQL Fails to Bulk Load on Windows (cquamme)

0005352: [Bug] collectionSchema cannot be null -- while parsing sql insert Issue With Oracle Log Mining and Oracle Permissions (cquamme)

0005365: [Bug] Trigger Router Screen in Add Table(s) Wizard Fallbacks to Default Node (cquamme)

0005139: [Bug] Reconnecting node missing registration URL (elong)

0005142: [Improvement] Delete router from Configure -> Router screen is slow (elong)

0005143: [Bug] On refresh of nodes panel, expand/collapse indicator is wrong (emiller)

0005148: [Improvement] Faster save performance for Configure -> Table Triggers and Routing screens (elong)

0005149: [Improvement] Improve and add filters on Configure Table Triggers and Configure Table Routing screens (emiller)

0005281: [Improvement] Snowflake Log Mining Functionality (pmarzullo)

0003946: [Improvement] Update Load Data wizard to be like the Auto Create Table Triggers wizard (emiller)

0005283: [Improvement] Add tables from console-schema.xml to pro user guide (emiller)

0003805: [Improvement] Allow Notification Email Template to be Modified Through User Interface (emiller)

0004665: [Bug] On configure screens, add "Save as Copy" button and allow editing of ID (emiller)

0005112: [Improvement] Kafka Advanced Settings to include ability to specify kafkaclient properties (emiller)

0005161: [Improvement] Labels on Health panel should link to the relevant screens (emiller)

0005163: [New Feature] Add Test Database button and Database Performance dialog to Manage Nodes screen (emiller)

0005172: [New Feature] Add push registration screens (emiller)

0005174: [New Feature] Add TLS certificate expiration reminder (emiller)

0005176: [New Feature] Add monitor types for license expiration, certificate expiration and license usage (emiller)

0005182: [Improvement] Improve grid on Manage Nodes screen (emiller)

0005183: [Improvement] Improve node registration panel (emiller)

0005184: [Improvement] Include tables in side-by-side documentation (emiller)

0005186: [Improvement] Add Spotless plugin to SymmetricDS Pro (emiller)

0005187: [Improvement] Add Overrides column to Configure Parameters grid (emiller)

0005188: [New Feature] Settings button with display options (emiller)

0005189: [Improvement] Improve TriggerRouterScreen in quick config wizard (emiller)

0005197: [New Feature] Add warning and dialog for tables that lack a primary key (emiller)

0005202: [New Feature] Add Manage Incoming Loads screen (emiller)

0005206: [New Feature] Add SQL Server bcp bulk loader (emiller)

0005212: [New Feature] Improve how node setup wizard handles load only nodes and bulk loaders (emiller)

0005218: [New Feature] Add console events for viewing batches (emiller)

0005228: [Improvement] Make snapshot age more apparent on the Help Support screen (emiller)

0005229: [New Feature] Log miner for MySQL database (emiller)

0005237: [Bug] SQL Explorer queries on SQLite get IllegalStateException (elong)

0005244: [Improvement] Hide "Setup bulk loading" checkbox if not on registration server (emiller)

0005247: [Bug] SQL Server Date columns are being converted to DateTime (elong)

0005270: [Improvement] Better descriptions of DB import options (elong)

0005276: [Improvement] Add option to Data Load Wizard to both create/alter tables and truncate tables (emiller)

0005284: [Improvement] Check the hostname and the local_infile variable when setting up a MySQL node with bulk loading enabled (emiller)

0005288: [Improvement] Make it possible to ignore a row from an outgoing batch that is part of a load (emiller)

0005292: [Improvement] Make error messages more obvious on Manage Installed Triggers screen (emiller)

0005293: [Improvement] Improve how metadata is fetched for engines that are on the same instance (emiller)

0005295: [New Feature] Relational to JSON writer with nesting using group of tables (emiller)

0005302: [Improvement] Improve first-time setup experience (emiller)

0005307: [Improvement] Add a warning to the Manage Outgoing Loads screen when a channel in use is disabled (emiller)

0005328: [Improvement] Add filters to Auto Create Table Routing and Auto Create File Routing dialogs (emiller)

0005363: [Improvement] Database test runs on controller node instead of node selected (elong)

0005369: [Improvement] Make failure message easier to read on failed engines screen (emiller)

0005374: [New Feature] Add more information and an option to take ownership when a node fails to claim exclusive ownership of a database (emiller)

0005252: [Bug] Fix IllegalArgumentException on Manage Outgoing Batches screen (pmarzullo)

0005330: [Improvement] Improved Elasticsearch RestHighLevelClient Calling Method (jvanmeter)

0005331: [Bug] Elasticsearch Insert Appending Too Many Commas (jvanmeter)

0005332: [Improvement] Improved how the Mongo Client is Created and Used (jvanmeter)

0005337: [Bug] Oracle Log Mining of LOBs needs to handle lob writes across multiple result set records better (pmarzullo)

0005339: [Bug] NPE when rebuilding a trigger with a missing table (emiller)

0005342: [Bug] Group link names extend past layout boundaries on Design tab (emiller)

0005345: [Bug] Script editor validation doesn't work as intended (emiller)

0005346: [Bug] Update Script Not Properly Appending Semicolons (jvanmeter)

0005361: [Bug] JDBC connection fails when using Oracle DB in cloud (josh-a-hicks)

0005266: [Bug] OnPrem to Cloud profile configuration not working (josh-a-hicks)

0005267: [New Feature] SingleStore log based support for non ANSI SQL statements (josh-a-hicks)

0005268: [Bug] Test Connection Button Not Working With Elasticsearch (jvanmeter)

0005275: [Improvement] Make "The background refresher service is shutting down" messages debug level (emiller)

0005277: [Bug] Fix phantom table issue in SQL Explorer database tree (emiller)

0005286: [Improvement] Rearrange lookup table layout on subset screen of Quick Config Wizard (emiller)

0005287: [Improvement] Add system memory and jvm bitness to snapshot (elong)

0005291: [Bug] Unable to Unregister 3rd Tier Node from Registration Server (jvanmeter)

0005294: [Improvement] Move images to src\main\resources\META-INF\resources (emiller)

0005296: [Bug] Elasticsearch getting java.lang.AbstractMethodError (jvanmeter)

0005297: [Improvement] Automatically set column width in SQL Explorer results grid (emiller)

0005298: [Improvement] Open Node Setup Wizard before Quick Config Wizard after initial setup (emiller)

0005299: [Improvement] Add current node to grid on Nodes dashboard panel (emiller)

0005300: [Bug] Oracle Log Mining issue with deletes when no primary keys defined (pmarzullo)

0005301: [Bug] Manage Logging panel opens log file and never closes when layout in log4j2.xml is different from original installed layout (pmarzullo)

0005303: [Bug] izpack failing to find release-notes.html file in stream (too far back) (pmarzullo)

0005310: [Bug] MSSQL log based replication support for database names that include a "-" (josh-a-hicks)

0005316: [Bug] Snapshot error on sym_outgoing_batch_summary for load-only node (elong)

0005317: [Bug] Transform Expression Window Sized Improperly (jvanmeter)

0005323: [Bug] Potential to get Infinite Recursive Loop when Downloading Module (jvanmeter)

0005324: [Bug] Fixed an issue with NoClassDefFoundError not being caught or thrown (jvanmeter)

0005325: [Bug] Added missing dependencies for MongoDB Atlas (jvanmeter)

0005326: [Bug] Use Mongo Id's Checkbox not Properly Saving to Parameters (jvanmeter)

0005231: [Improvement] Support snapshot file improvements (elong)

0004348: [New Feature] Installer prompt for Windows logon as user

0005253: [Bug] Elasticsearch SSL Connection Issues (jvanmeter)

0005257: [Improvement] Rows in the SQL Explorer TreeGrid should only expand or collapse when the arrow is clicked (emiller)

0005259: [Bug] Log based configurations do not sort initial load properly by foreign keys (josh-a-hicks)

0005232: [Improvement] Oracle enhanced permission checks for log based replication (josh-a-hicks)

0005245: [Bug] Prevent duplicate Export button from appearing in DB Export dialog (emiller)

0005233: [New Feature] SingleStore dialect (josh-a-hicks)

0005201: [Bug] HSQLDB validation query results in "unexpected end of statement" error (emiller)

0005205: [Improvement] Azure managed instance support for bulk loading (josh-a-hicks)

0005208: [Bug] Design panel errors when transforms are not properly configured (josh-a-hicks)

0005209: [Bug] Auto.config.registration.svr.sql.script parameter doesn't get removed when setting up SymmetricDS with custom configuration (emiller)

0005215: [Bug] Test Connection button fails on Mail Server setup screen (emiller)

0005217: [Bug] Buttons in health panel on dashboard sometimes do nothing (emiller)

0005219: [Bug] On Login dialog, sort the nodes that are registration servers to the top safely (pmarzullo)

0005220: [Bug] Selecting multiple rows on a Configure screen and clicking the New button opens the wrong editor (emiller)

0005221: [Bug] Grid selection should not clear when filters change on Configure screens (emiller)

0005223: [Bug] Downloading snapshots doesn't always work in Firefox (emiller)

0005224: [Bug] Prevent triggers from being synced via the UI if they're already in the process of being synced (emiller)

0005225: [Improvement] Alphabetize items in catalog, schema, and table select fields in transform form (emiller)

0005230: [Bug] Transform form fields do not populate correctly (emiller)

0005234: [New Feature] SingleStore dialect (josh-a-hicks)

0005235: [Bug] Restarting engine from failed engine dialog not working (elong)

0005236: [Bug] Conflict winner can cause routing warning about mismatch table name (elong)

0005246: [Improvement] MSSQL auto create trigger options to exclude rowversion (elong)

0005249: [Improvement] Make it clear when links on Dashboard Shortcuts panel aren't working due to license violations (emiller)

0005250: [Bug] Fix database icons not always showing up in Design tab (emiller)

0005251: [Improvement] Suppress Vaadin's "Got an RPC for non-existent node" messages (emiller)

0005254: [Bug] Assigning a run period via the monitor form's "Customize" button doesn't work (emiller)

0005256: [Bug] Oracle log miner unsupported dmlType LOB_TRIM (elong)

0005258: [Bug] Catch exceptions when parsing an outgoing batch to view its sent data (emiller)

0005261: [Bug] Conflict form doesn't honor console.web.hide.system.info (emiller)

0005262: [Improvement] Make default node selection in Data Load Wizard less confusing (emiller)

0005165: [Bug] Selecting an engine that has failed to start doesn't open the Engine Startup Failure dialog (emiller)

0005154: [Bug] Detecting AS/400 as generic dialect instead of AS/400 dialect (elong)

0005084: [Improvement] Test Connection button on Manage Nodes screen should be disabled in some situations (emiller)

0005152: [Bug] Multiple license expiration reminder dialogs can open at the same time (emiller)

0005153: [Improvement] Improve appearance of reminder dialogs (emiller)

0005155: [Bug] Registration URL field in Node Setup Wizard does not keep its custom value when clicking Next (emiller)

0005156: [Bug] Grid on Configure Table Routing screen sometimes doesn't update after deleting all rows (emiller)

0005126: [Bug] UI can get stuck on the "Starting SymmetricDS" screen when the server can't connect to a database but the client(s) can (emiller)

0005124: [Improvement] Add "enabled for initial load" checkbox to table routing form (emiller)

0005125: [Improvement] Improve appearance of "Starting SymmetricDS" screen (emiller)

0005127: [Bug] Editing staging files via the Manage Staging Area screen doesn't work if compression or encryption is enabled (emiller)

0005129: [New Feature] Import configuration in the background instead of hanging the UI (emiller)

0005130: [Bug] MongoDB quick config support for changing databases to view other collections (josh-a-hicks)

0005131: [Bug] OutgoingLoadPanel is calling a query for each table reload request (emiller)

0005132: [Improvement] List registration nodes first in the login dialog (emiller)

0005135: [Improvement] Improve appearance of sample subselect SQL on subset screen of quick config wizard (emiller)

0005136: [Improvement] Improve node setup wizard when creating an additional master node (emiller)

0005147: [Improvement] Improve appearance of group link screen in quick config wizard (emiller)

0005119: [Improvement] Design Screen Permission Installation (jvanmeter)

0004943: [New Feature] Upgrade to Vaadin 14 user interface components (emiller)

0004953: [Bug] Switching nodes changes the column widths of the grids on the Dashboard screen (emiller)

0004954: [Improvement] Installer log which files modified (elong)

0004963: [Improvement] Console login is slow (elong)

0005044: [Improvement] Enhanced status in the node list (elong)

0005075: [New Feature] Elasticsearch Dialect Implementation (jvanmeter)

0005081: [New Feature] MongoDB change data capture or load-only node and upgraded driver to 4.3.1 (josh-a-hicks)

0005094: [New Feature] Log miner for Postgres database (elong)

0005096: [New Feature] Console event listener extension (elong)

0005100: [New Feature] OpenSearch Dialect Implementation (jvanmeter)

0005104: [Improvement] Uninstaller leaves folder and files behind (elong)

0005109: [New Feature] Microsoft Azure CosmosDB support (josh-a-hicks)

0005110: [New Feature] Add Engine Startup Failure Dialog (emiller)

0005111: [Improvement] Default parameter console.auth.config.client to true (elong)

0005087: [Bug] MS log miner permission check failing (elong)

0004994: [Improvement] Performance of sync trigger is very slow in SQL Server while synchronizing large number of triggers (elong)

0005114: [Bug] Initial Load for SQL Server shows completed when data load batches is more than calculated batches (elong)

0005058: [New Feature] Ability to store table stats by DML (josh-a-hicks)

0005065: [Bug] Support for encrypted pem certificates (josh-a-hicks)

0005071: [Bug] Oracle log miner handle multiplexed redo log file (elong)

0005073: [Bug] Table names for databases with empty string ("") default catalogs not present in quick setup wizard table selection screen (rudiejd)

0005083: [Bug] Fix SQLException on Manage Nodes screen (emiller)

0005090: [Bug] Prevent modal when adding more nodes than license allows (elong)

0005103: [Bug] Prevent expired certificates from being imported (elong)

0005018: [Bug] MS log miner needs snapshot isolation to work under heavy load (rudiejd)

0004366: [Bug] Manage outgoing loads screen does not update completed tables with last set of active tables when those tables are complete (elong)

0005039: [Bug] Process info panel uses wrong calculation for rows per second (elong)

0005040: [Improvement] Extract process info should be querying and extracting (elong)

0005038: [Bug] Select all checkbox missing on node selection in load wizard (elong)

0005012: [Bug] Oracle log miner uses deprecated CONTINUOUS_MINE during permission check (elong)

0005024: [Bug] Setup wizard for Informix fails with method not supported IfxSqliConnect.isValid(int) (elong)

0005026: [Bug] SQL Server: The data types time and datetime are incompatible in the equal to operator. (elong)

0005031: [Bug] UIDetachedException during sync triggers (elong)

0005033: [Bug] Oracle Log Miner fails to load transactions when SCN value is too old and gets stuck in loop (pmarzullo)

0005034: [Bug] Initial load shows up as pending and loading at the same time (elong)

0005036: [Bug] Outgoing batch panel remote status not working (elong)

0005050: [Bug] Screens call sync triggers in contention with config router (elong)

0005046: [Improvement] Support import of PKCS#1 RSA key for TLS X.509 certificate (elong)

0005052: [Bug] Batch window pop-up is slow to display (elong)

0005053: [Bug] SQL Explorer not showing triggers from another catalog on MS-SQL (elong)

0004967: [Bug] Oracle log miner SQL parser exception from functional index (elong)

0005008: [Bug] Push and pull threads panels are empty (elong)

0004972: [Improvement] Oracle log miner remove deprecated CONTINUOUS_MINE for Oracle 19c (elong)

0004979: [Bug] Log mining trigger hist error causes drop trigger to run (elong)

0004983: [Improvement] Rebalance channels ignore negative initial load order (elong)

0004992: [Improvement] Write console events to log (elong)

0004997: [Improvement] Setup database should set socket read timeout higher than SQL query timeout (elong)

0004999: [Bug] Oracle Log Miner needs to handle rollback to savepoints (pmarzullo)

0005002: [Bug] Manage Installed Triggers screen should filter out the symmetric tables on the source table name instead of the trigger id (pmarzullo)

0005005: [Bug] Table list from remote client is not populated (elong)

0004872: [Improvement] Design screen will display transforms that are not linked up properly (josh-a-hicks)

0004917: [Bug] Unable to configure mail server- bad credentials -irrespective of giving the correct credentials. (elong)

0004935: [Improvement] Skip a specific source row in batch thru the front-end (emiller)

0004936: [Bug] Fix date sorting in grids (emiller)

0004937: [Improvement] Save grid column visibility when switching screens (emiller)

0004938: [Improvement] Open quick config wizard when table or file sync icon is clicked (emiller)

0004939: [Improvement] Stop resetting the position of the vertical split in the Design tab (emiller)

0004946: [Bug] Fix ArrayIndexOutOfBoundsException in the resolve data tab of the batch details window (emiller)

0004956: [Bug] Fix ClassNotFoundException in quick config wizard (emiller)

0004959: [Bug] Mail server password not working (elong)

0004961: [Bug] Fix unknown error on the NodesPanel when there are nodes in multiple tiers (elong)

0004962: [Bug] Error on outgoing batch panel on postrgres (chenson)

0004969: [Bug] Enable debug logging for log miner (elong)

0004881: [Bug] Sybase issue with getting update counts (josh-a-hicks)

0004841: [Improvement] Improve batch screen grid performance (emiller)

0004853: [Improvement] Improve grids on batch details window (emiller)

0004855: [Improvement] Enable the Ignore Batch option for any batch that is not ok or ignored (emiller)

0004856: [Improvement] Improve columns of batch screen grids (emiller)

0004858: [Bug] Fix grid bug on captured data tab of outgoing batch details window (emiller)

0004861: [New Feature] Add Clear Error button to batch screens (emiller)

0004863: [Bug] Null Pointer on new Transform panel when meta data is turned off (josh-a-hicks)

0004864: [Improvement] Update design view to display log based and load only databases along with proper database icon (josh-a-hicks)

0004868: [Improvement] Add the target.* properties to the symmetric-default.properties file so that they show up on the Manage Startup Parameters (pmarzullo)

0004869: [Improvement] Get rid of deprecated usages in gradle build in preparation for upgrade of gradle (pmarzullo)

0004870: [Improvement] Improve grid on Help Support screen (emiller)

0004871: [New Feature] Add trigger synchronization progress bar (emiller)

0004875: [Improvement] Remove "Save Failed" pop-up from forms (emiller)

0004876: [Bug] SQL Server: log mining capture should wrap all non-null values in double quotes (pmarzullo)

0004877: [Bug] Fix exception in node setup wizard (emiller)

0004878: [Improvement] Improve appearance of schedule field in job form (emiller)

0004879: [Bug] Fix message on node status dashboard panel (emiller)

0004883: [Improvement] Improve batch screen grid filter (emiller)

0004885: [Improvement] Hide Resolve Data tab when it's empty (emiller)

0004886: [New Feature] Add node installation progress bar (emiller)

0004887: [Bug] Oracle log miner stops processing rows when running into a DML statement that is not parseable (pmarzullo)

0004889: [Bug] Fix table count in quick config wizard (emiller)

0004890: [Bug] dbcp2 package requires setting of validation query, otherwise it runs jdbc driver isValid() method, causing problems (pmarzullo)

0004891: [Bug] Oracle log miner fails to move forward in the log mining when starting SCN is too low (pmarzullo)

0004893: [Improvement] Add filters to the grid on the send table schema window (emiller)

0004894: [Improvement] Oracle Log Miner: should show SQL statement in log when parsing fails (pmarzullo)

0004896: [Bug] Fix TreeGrid style being changed when visiting the Design tab (emiller)

0004897: [Bug] Oracle Log Miner: handle parse exceptions by logging and moving on (pmarzullo)

0004898: [Improvement] Move remaining calls to syncTrigger() to background thread (emiller)

0004901: [Bug] Fix inability to open multiple form tabs at once (emiller)

0004904: [Improvement] Improve data load wizard's criteria screen (emiller)

0004905: [Bug] Fix authentication failure dialog style on Configure LDAP screen (emiller)

0004907: [Improvement] Add router selection to quick config wizard (emiller)

0004908: [Improvement] Add option to reset row replication statistics (emiller)

0004909: [New Feature] Add snapshot progress bar (emiller)

0004910: [Improvement] Oracle auto create trigger options for LONG and ROWID (elong)

0004911: [Improvement] Temporarily default to HTTPS 1.1 instead of 2 for stability (elong)

0004912: [New Feature] Add ignore batch progress bar (emiller)

0004918: [New Feature] Add auto create channels window (emiller)

0004919: [Bug] Fix custom transforms in transform column editor (emiller)

0004921: [Improvement] Improve node terminal window (emiller)

0004922: [Improvement] Prevent node installation dialog from being dismissed on first-time setup (emiller)

0004923: [Improvement] Improve appearance of violation panel (emiller)

0004924: [Improvement] Add a user-specific setting for showing advanced form fields (emiller)

0004926: [Improvement] Add insert button to transform column editor (emiller)

0004928: [Bug] Fix incoming batch download button (emiller)

0004930: [Bug] Fix NullPointerException in the resolve data tab of the batch details window (emiller)

0004837: [New Feature] Support for a new variable in trigger source table name to expand upon based on configured nodes (josh-a-hicks)

0004748: [Improvement] Add more console events (emiller)

0004753: [Improvement] Add server-side lazy loading to SQL Explorer tree (emiller)

0004754: [Improvement] Add lazy loading to Manage Console Events screen (emiller)

0004755: [Improvement] Firebird blocking transaction in support snapshot (elong)

0004756: [Improvement] Prevent table & file routing from being deleted via auto create wizard (emiller)

0004757: [Improvement] Open node setup wizard when database icon is clicked (emiller)

0004758: [Improvement] Parameter console.ip.addr.filter should apply to welcome wizard (elong)

0004759: [New Feature] Add option to require a user to change their password on their next login (emiller)

0004760: [Bug] Fix batch screen lazy loading bugs (emiller)

0004761: [New Feature] Add console.password.min.change.chars parameter (emiller)

0004766: [New Feature] Add shortcut to skip admin user configuration (elong)

0004767: [Bug] Cannot save integer parameters greater than 999 (emiller)

0004769: [Bug] Mixed Pro/OSS deployment syncs sym_console_role table (elong)

0004768: [Bug] Hide system channels from Configure Table Triggers screen dropdowns when console.web.hide.system.info is true (emiller)

0004770: [Bug] Include "https" instead of "http" in the default sync url when https.enable is true (emiller)

0004771: [Bug] Fix sorting on batch screens (emiller)

0004772: [Improvement] For upgrades, default https2 disabled (elong)

0004773: [Improvement] Require the interface name field when creating or editing a BeanShell extension (emiller)

0004774: [Improvement] Add failed logins column to grid on Configure Users screen (emiller)

0004775: [Improvement] Add validate button when entering BeanShell scripts to send to other nodes (emiller)

0004776: [Improvement] Lazily load the full list of nodes into the data load wizard's grid (emiller)

0004777: [Improvement] Improve BeanShell editors (emiller)

0004778: [Improvement] Allow disabling of node_password encryption (elong)

0004781: [Improvement] Improve cron schedule editor (emiller)

0004784: [Bug] SQL Server Log Miner formats row_data incorrectly when value contains backslash (pmarzullo)

0004785: [Improvement] Load user guide by section to conserve memory (elong)

0004788: [Improvement] Improve editor cancellation (emiller)

0004789: [Improvement] Adjust default sync URL (emiller)

0004790: [Bug] Fix batch screen "<Not Ok>" filter (emiller)

0004791: [Bug] Fix side-by-side documentation being cut off (emiller)

0004792: [Improvement] Improve update statements in SQL explorer (emiller)

0004793: [Bug] Trust store password is required when storing (elong)

0004794: [Bug] Installer error String index out of range: -1 (elong)

0004796: [Bug] Fix batch window NullPointerException (emiller)

0004799: [New Feature] Console user authentication with client certificate (X.509) (elong)

0004801: [Improvement] Update wording for the 3 setup options on welcome wizard (elong)

0004803: [Bug] Fix Configure Table Triggers screen slowness (emiller)

0004805: [New Feature] MSSQL Log based loop prevention and sync on incoming support (josh-a-hicks)

0004806: [Bug] Fix transaction file generation for MySQL 5.5 and earlier (emiller)

0004807: [Improvement] Monitor summary clearing all errors and delay (elong)

0004808: [Improvement] Add configure links to monitor summary dialog (emiller)

0004809: [Improvement] Enhance Send Table Schema window (emiller)

0004811: [Bug] Fix load wizard table selection screen (emiller)

0004813: [Improvement] Improve multi-select grid behavior (emiller)

0004815: [Improvement] Set node.password.encrypt.enable=false when a new node is added with cluster locks enabled (emiller)

0004816: [Bug] Design tab not displaying transforms correctly when "use source catalog/schema" turned on the router (josh-a-hicks)

0004820: [Bug] Fix Oracle SqlException on batch screens (emiller)

0004822: [Improvement] Improve background refresher registration (emiller)

0004827: [Improvement] Improve Manage Installed Triggers screen (emiller)

0004829: [Improvement] Improve appearance of validation error messages (emiller)

0004832: [Improvement] Replace invalid characters in group IDs (emiller)

0004834: [Improvement] Improve appearance of parameterized messages in monitor summary dialog (emiller)

0004836: [Improvement] Allow spaces in external id (josh-a-hicks)

0004839: [Bug] Push and pull threads panel shows file sync when not enabled (elong)

0004844: [Improvement] Alphabetize dropdowns in quick config wizard (emiller)

0004845: [Improvement] Fix default grid sort order on Manage Outgoing Loads screen (emiller)

0004846: [New Feature] Add profiles to Data Load Wizard (emiller)

0004848: [Improvement] Improve statistics on incoming batch details window (emiller)

0004850: [Improvement] Improve error resolution on incoming batch details window (emiller)

0004851: [Bug] Fix download CSV button on batch details window (emiller)

0004854: [Bug] Fix node selection grid in data load wizard (emiller)

0004721: [Improvement] Improve Configure Extensions screen (emiller)

0004703: [Bug] BigDecimal value in Row needs to use toPlainString() when returning string representation (pmarzullo)

0004410: [Bug] "Reconnect" to database for SymmetricDS installation fails with security exception (elong)

0003123: [Bug] License Key fails to synchronize (data truncated) to target node of DB2 on zSeries (josh-a-hicks)

0004632: [Improvement] Update deprecated classes in Outgoing Batches and Incoming Batches screens (emiller)

0004634: [Bug] Config Import from Overview Panel fails because of cleanup of design diagram records (pmarzullo)

0004637: [Bug] Installer overwrites setenv.bat and keystore password no longer matches (elong)

0004638: [Bug] Nodes panel allows attempt to control non-existent node engine (elong)

0004639: [Improvement] Update deprecated classes in common UI classes (emiller)

0004640: [Improvement] Update deprecated classes in MonitorSummaryDialog (emiller)

0004641: [Improvement] Improve Configure Monitors and Configure Notifications screens (emiller)

0004654: [Improvement] Add filter field to Manage JVM Properties screen (emiller)

0004655: [Improvement] Add "Show sym_ Batches" checkbox to Manage Incoming/Outgoing Batches screens (emiller)

0004656: [Improvement] Show the staging directory location on the Manage Staging Area screen (emiller)

0004659: [Improvement] Allow query results to be edited (emiller)

0004663: [Improvement] Add encryption to parameter screens (emiller)

0004677: [Bug] Allow transform column PK and order fields to be edited (emiller)

0004678: [Improvement] Add Edit button to Manage Staging Area screen (emiller)

0004681: [New Feature] Create Modules screen (emiller)

0004683: [Improvement] Update docker image to JDK slim (elong)

0004684: [Bug] Manage Incoming Batches screen should say "Source Node" when viewing a batch's details (emiller)

0004685: [New Feature] Add a limit for the number of sessions per user (emiller)

0004688: [Bug] Disconnect a user's session(s) when the user gets deleted (emiller)

0004689: [Bug] Make Interface Name field only selectable for BeanShell extensions (emiller)

0004690: [Improvement] Make the data load wizard resizable (emiller)

0004691: [Improvement] Alphabetize channel select fields (emiller)

0004692: [Improvement] Add validate button to BeanShell script editors (emiller)

0004693: [Improvement] Add confirmation dialog when canceling out of a form (emiller)

0004694: [Improvement] Improve channel filtering on batch screens (emiller)

0004695: [Improvement] Add grid paging to batch screens and Manage Nodes screen (emiller)

0004704: [Bug] Permission check for DB2 zOS is not valid (josh-a-hicks)

0004712: [Improvement] Logging panel push pull requests (elong)

0004713: [Bug] Console events retention parameter (elong)

0004716: [Improvement] Improve Configure Overview screen (emiller)

0004718: [Improvement] Improve Help Support screen (emiller)

0004727: [Bug] Prevent problematic characters from being included in group IDs (emiller)

0004728: [Improvement] Add confirmation dialog when disabling a TriggerRouter (emiller)

0004729: [Improvement] Add lazy loading to Manage Staging Area screen (emiller)

0004731: [Improvement] Add lazy loading to SQL Explorer tree (emiller)

0004733: [Improvement] Add delay between login prompts after a failed login attempt (elong)

0004734: [Improvement] Set cookies as http only and secure (elong)

0004735: [Improvement] Improve batch details window (emiller)

0004736: [New Feature] Add more security parameters (emiller)

0004739: [Improvement] Add more specific privileges for Manage Staging Area screen (emiller)

0004740: [Improvement] Add filters and export button to Manage Console Events screen (emiller)

0004744: [Improvement] Upgrade Vaadin to 8.12 (elong)

0004745: [Improvement] Fix and improve Manage Nodes screen (emiller)

0004749: [Bug] Value too long for column node_password (elong)

0004238: [Bug] Can't delete group links once created (emiller)

0004601: [Bug] Prevent registration server from being unregistered (emiller)

0004604: [New Feature] Add file containing information about blocking processes to snapshots (emiller)

0004628: [Bug] Fix various bugs with the Design tab (emiller)

0004564: [New Feature] Add option to allow changes from SQL to be captured (emiller)

0004569: [New Feature] Add a file to snapshots that contains thread CPU and memory usage information (emiller)

0004570: [Improvement] Fix all warnings on AbstractEditPanel and the classes that extend it (emiller)

0004575: [Improvement] Upgrade jQuery library to 3.5.1 (emiller)

0004576: [Bug] Filter in Design Overview tab does not work correctly (emiller)

0004587: [Improvement] Improve multi-select grid behavior (emiller)

0004588: [Improvement] Improve behavior of "Active Only" checkbox on Manage JVM Threads screen (emiller)

0004589: [Improvement] Update deprecated components on Dashboard tab (emiller)

0004590: [Improvement] Update deprecated components on Design tab (emiller)

0004592: [Improvement] Update deprecated components on Explore tab (emiller)

0004594: [Bug] First time setup admin user encryption strength (elong)

0004602: [Bug] Allow a group link to be deleted when its only dependencies are system transforms (emiller)

0004603: [New Feature] Indicate when nodes or users are locked out and add buttons to unlock them (emiller)

0004606: [Improvement] Widen Process Type combo box on Manage Processes screen (emiller)

0004608: [Improvement] Improve Configure Transforms screen (emiller)

0004613: [Bug] Fix query result grid bugs (emiller)

0004615: [New Feature] Add a notification for when the license is about to expire (emiller)

0004618: [Improvement] Add "View Text" button to Manage Installed Triggers screen (emiller)

0004620: [Bug] Preserve sort order when switching screens (emiller)

0004621: [Improvement] Registration secret for security (elong)

0004622: [Bug] Nodes panel buttons for send, registration, and test should be enabled for multi-primary (elong)

0004623: [Improvement] Update deprecated components in load, quick start and setup wizards (emiller)

0004624: [Improvement] Update deprecated components in login dialog (emiller)

0004626: [Improvement] Fix and improve Quick Config Wizard (emiller)

0004629: [Improvement] Improve node group selection in the node setup wizard (emiller)

0004566: [Improvement] Allow conflict edit panel to set ping back (elong)

0004537: [Bug] Nodes panel doesn't show hierarchy if multi-primary detected (elong)

0004520: [New Feature] New Screen Called Startup Parameters for Editing Engine Files (emiller)

0004532: [Improvement] Manage Startup Parameters screen needs its own privilege (emiller)

0004533: [Improvement] Batch data should be easily downloadable (emiller)

0004534: [Improvement] Update Support and Maintenance screens (emiller)

0004535: [Improvement] Improve Manage JVM Threads screen (emiller)

0004536: [Bug] Conflict timestamp or version column name not displayed on edit (elong)

0004539: [Improvement] Show query tab by default under the Explore tab (emiller)

0004540: [Improvement] Improve Manage Console Events Screen (emiller)

0004541: [Improvement] Fix all warnings on all Manage screens and classes (emiller)

0004542: [Bug] Admin privilege maintenance screen on remote nodes (elong)

0004554: [Bug] Staging encryption batch errors invalid lines and did not receive ack (elong)

0004558: [Bug] NPE during background refresh for session expiration (elong)

0004562: [Improvement] Manage Staging Area screen should hide folders when their contents don't match the filter value (emiller)

0003930: [Bug] Offline nodes shown with active spinning icon on Dashboard "nodes" panel (JJ_Starrett)

0003923: [Improvement] Table reload request: Show tables that have disabled trigger/router combinations, but have them unselectable by user (JJ_Starrett)

0004117: [Bug] Outgoing Loads screen reports Load not complete (when it is) when zero tables are synced (JJ_Starrett)

0004466: [Bug] Permission test during installation fails on MySQL Clusters (elong)

0004480: [Bug] Load data wizard does not check where conditions for a select tables case when all tables selected (JJ_Starrett)

0004482: [Bug] Control Center shows JMX is disabled after enabling from installer (elong)

0004486: [Improvement] Install license key on registration server (elong)

0004500: [New Feature] REST API Security keys (jvanmeter)

0004511: [Bug] NPE on incoming batch window when batch in error (elong)

0004513: [Bug] Setup of load only node hangs because of NPE (elong)

0004475: [Improvement] Manage -> Security screen import/export certificate authority (elong)

0004434: [Improvement] Add GUI support for before trigger scripts (JJ_Starrett)

0004455: [Improvement] Setup installer better validation, panel usability, NPE fix, error removing files on upgrade (elong)

0004468: [New Feature] Active Session Screen/Idle Timeout (jvanmeter)

0004477: [New Feature] New version notification GUI element (JJ_Starrett)

0004478: [Bug] Manage -> Logging panel is slow (elong)

0004422: [Bug] Node registration gets Bad Padding Exception (elong)

0004431: [Bug] Failure to reset the Failed Login Attempts on a successful login using Two-Factor Authentication (jvanmeter)

0004411: [Bug] NoClassDefFoundError during node setup for Kafka, Azure, Snowflake (elong)

0004416: [New Feature] Ingres Dialect Implementation (pmarzullo)

0004425: [Bug] Add load only node does not continue when node is not the master node (pmarzullo)

0004430: [New Feature] Forgot Password and Email Verification (jvanmeter)

0004432: [Bug] Diagram table foreign key name is too long for Oracle (josh-a-hicks)

0004438: [Bug] Table count should be case insensitive for license check (elong)

0004440: [Bug] Improve security for changing user password (jvanmeter)

0004443: [Improvement] Uninstalling node causes query errors (elong)

0004447: [Bug] MSSQL Log based replication fails on sync triggers (josh-a-hicks)

0004451: [Improvement] Installer should convert JDBC drivers to modules (elong)

0004412: [Bug] Add license violation to logging (elong)

0004428: [Bug] Change logging from apache commons logging to slf4j in Pro classes (pmarzullo)

0004418: [Bug] Statistics screen missing sent rows (elong)

0004423: [Bug] Add Node documentation has repeated sentence (pmarzullo)

0004429: [Improvement] License violation now redirects to appropriate screen instead of logout (JJ_Starrett)

0004437: [Bug] Table count should be case insensitive for license check (elong)

0004450: [Improvement] Ingres: db.init.sql=set lockmode session where level = row (pmarzullo)

0004301: [Improvement] Simplify conflicts screen to encourage valid settings (elong)

0004391: [New Feature] Rate staging performance (elong)

0004361: [Improvement] Encrypt node passwords (elong)

0002349: [Improvement] Provide more granular level of permissions (jvanmeter)

0004384: [New Feature] Password Complexity Meter (jvanmeter)

0001432: [Improvement] When a user cannot edit a panel, instead of hiding edit buttons, disable the buttons. (jvanmeter)

0001663: [Improvement] Windows authentication with SQL-Server (elong)

0001692: [Improvement] If you can't edit configuration, at least let you view it read-only (jvanmeter)

0004291: [New Feature] SQL-Server log miner (elong)

0004325: [New Feature] Two-Factor Authentication (jvanmeter)

0004357: [New Feature] Modify node registration panel to allow user to authorize opening registration (elong)

0004388: [Improvement] User Email Capture (jvanmeter)

0004160: [Improvement] Provide warning to user when disabling a trigger router (elong)

0004243: [Improvement] Ability to cancel a load with invalid request details (elong)

0004321: [Improvement] Manage->Outgoing Loads screen: Add message when max loads reached (elong)

0004328: [Bug] Servlet filter needs to be created with async-supported enabled (pmarzullo)

0004340: [Improvement] Installer should notify user of Java version requirement (elong)

0004350: [Improvement] Add IAlterDatabaseInterceptor to list of Extension interfaces available (josh-a-hicks)

0004353: [Bug] Unable to run as a service on RHEL because Java absolute path (elong)

0004159: [Installation] INTERBASE Length of ROW_DATA and OLD_DATA are now only varchar(3840) !! (pmarzullo)

0004157: [Installation] Impossible to see the webconsole (version pro) with Interbase (pmarzullo)

0004145: [Bug] SQL Explorer issue with Interbase as a node (pmarzullo)

0004154: [Bug] GUI mode installer not working on latest MacOS and latest Java (elong)

0004164: [Bug] BatchUpdateException: Duplicate entry '24-378' for key 'PRIMARY' (elong)

0004165: [Improvement] Security panel for managing TLS/SSL certificate (elong)

0004169: [Bug] NPE when attempting to add Snowflake Load Only Node (elong)

Enhanced performance of routing and purging, extract-only nodes, improved security of node authentication, and support for SAP HANA

0000829: [New Feature] Log reader of database transactions to use instead of database triggers (elong)

0003571: [Improvement] On Nodes Panel, support network diagnostics for remote nodes (elong)

0004023: [New Feature] Hana Database Support (josh-a-hicks)

0004042: [New Feature] Support for setting up log based, trigger based, extract only, or load only nodes (josh-a-hicks)

0004082: [Improvement] Sort the properties alphabetically by key in the engine property file before writing it out as part of the setup wizard. (elong)

0004057: [Improvement] On Load Data Wizard, when selecting all tables individually, treat as selecting all tables on previous screen (JJ_Starrett)

0004036: [Bug] Install directory selection results in duplicate directory name on MacOS (pmarzullo)

0004038: [Bug] Snapshot fails when batch in error (elong)

0004039: [Improvement] Add a confirm password field when setting up the admin user (JJ_Starrett)

0004043: [Bug] Load Data screen does not reflect the fact that a previous load has been cancelled (JJ_Starrett)

0004048: [Bug] Table reload request- routing service can break up table reload requests into multiple load requests (pmarzullo)

0004053: [Bug] Redshift node setup fails on advanced screen if bulk loading is not selected (josh-a-hicks)

0004061: [Improvement] Security, keystore, and cacerts permissions should only allow owner to read/write (pmarzullo)

0004070: [Bug] Outgoing load support for active only checkbox (josh-a-hicks)

0003707: [Bug] Dashboard Health Monitor Shows Orphaned Nodes as Offline. These nodes are not shown in Manage Nodes Screen (pmarzullo)

0004013: [Bug] Outgoing Batches screen incorrectly reports number of rows returned when a filter is applied and a refresh occurs (~~user606~~)

0002079: [Improvement] Add validation for editing numeric parameters (elong)

0003956: [Bug] Node Setup Wizard missing error checking (~~user606~~)

0003948: [Improvement] When over the limit for number of tables in the trial version, adding tables just logs you out and gives no message (josh-a-hicks)

0003944: [Bug] The Data Load Wizard search feature does not display nodes after cleared search (~~user606~~)

0003942: [Bug] Outgoing Loads display not being changed on node selection change (josh-a-hicks)

0003943: [Bug] Outgoing Loads detail icon not changing mouse to pointer (~~user606~~)

0003633: [Bug] MSSQL Server Pro Validation Query Fails with a hyphen in the DB Name (~~user606~~)

0003769: [Improvement] Increase size of parameter edit screen to better accomodate long descriptions (pmarzullo)

0003969: [Bug] "Monitors" window in Manage tab throws error on non-numeric input (~~user606~~)

0003970: [Bug] Monitor screen limit needs updated logic and code refactoring (~~user606~~)

0003981: [Bug] Explore tree and quick config wizard do not display schemas in another database properly for MSSQL (josh-a-hicks)

0003985: [Bug] Database setup wizard should allow MariaDB to use MariaDB driver instead of MySQL one (elong)

0003995: [Bug] Improve readability of Edit hyperlink on parameter edit screen (pmarzullo)

0003998: [Bug] DbExport dialog in SQLExplorer does not update file output type after first export (~~user606~~)

0004017: [Bug] Canceling load leaves batches in not-OK status on the target (elong)

0003887: [Improvement] Interrupt process from process info panel (elong)

0003436: [Bug] The 'Auto Create Triggers' screen clears all selected tables if the user enters a search into 'filter results' (josh-a-hicks)

0003914: [Bug] Some bulk loaders were not using parameters properly during a fall back to a default loader (josh-a-hicks)

0003940: [Bug] Trial Version Table Limit (josh-a-hicks)

0003475: [Improvement] stream_row option (bulk edit) on sym_trigger is not available via the Pro UI, nor is reload channel (elong)

0003506: [Bug] Transform screen incorrectly warns there isn't a trigger router combination (josh-a-hicks)

0003631: [Bug] Node missing from top-right drop-down switcher (josh-a-hicks)

0003699: [Bug] Clear Staging dialog box text cut off (josh-a-hicks)

0003700: [Bug] Manage / Console Events screen has incorrect explanation text at top (josh-a-hicks)

0003739: [Bug] Dashboard error summary screen takes you to the outgoing batch screen even if error is on an incoming batch (josh-a-hicks)

0003783: [Improvement] Add logging option for DataExtractor and initial load SQL (elong)

0003797: [Improvement] Filter threads shown on Manage -> JVM Threads and snapshot (elong)

0003803: [Improvement] Exclusive options for stream lob, capture lob, stream row (elong)

0003819: [New Feature] Ability to ignore a row on an incoming batch. (josh-a-hicks)

0003820: [Improvement] Interrupt processing when canceling load or ignoring batch (elong)

0003827: [Improvement] Enhanced load monitoring with updates to outgoing load page and new load detail page (josh-a-hicks)

0003841: [Bug] Outgoing batch panel and load batches (elong)

0003843: [Improvement] Enhanced user interfaces based on remote catalog,schema, and table meta data (josh-a-hicks)

0003855: [Improvement] Quick config wizard enhancements for filtering large tablesets (josh-a-hicks)

0003859: [Improvement] NodeService.findNode(...) (cached versus non-cached), where to use correct one (pmarzullo)

0003860: [Bug] SqlExplorer dbfill and dbexport should use the hide tables regex (elong)

0003888: [New Feature] Snowflake load only node support (josh-a-hicks)

0003889: [Improvement] Redshift upgraded driver to 4.2 (josh-a-hicks)

0003908: [New Feature] HBase support as a load only node through add node wizard (josh-a-hicks)

0003701: [Bug] NumberFormatException on Logging screen when field to right of refresh button is cleared. (mmichalek)

0003721: [Bug] SQL Explorer throws exception when using table name aliases in SQL Server (mmichalek)

0003780: [Bug] Install wizard doesn't detect existing node in database (elong)

0003779: [Bug] Load wizard cannot send specific tables for wildcarded tables (elong)

0003822: [Bug] Oracle Trigger Source is incorrect in SQL Explorer (mmichalek)

0003826: [Improvement] Raise error when initial load can't be properly queued up due to missing sym_trigger_hist rows (mmichalek)

0003761: [Bug] dbcompare should use sync key names and included/excluded columns (elong)

0003745: [Improvement] Load wizard backwards compatible with 3.7 and below for receiving an initial load (elong)

0003759: [Improvement] Confirmation dialog for ignoring batch (elong)

0003775: [Bug] The web UI shows wrong values for update time and create times from the database on newer versions of Sql Server (datetime2) (chenson)

0003776: [New Feature] License key support for a mobile modifier (josh-a-hicks)

0003613: [Improvement] Web Console logging - user create, delete, logout, and change password events (elong)

0003614: [Bug] Websocket errors when using HTTPS/SSL/TLS (elong)

0003615: [Bug] NullPointerException during RemoteStatus message reply (mmichalek)

0003618: [Improvement] If you access the web ux from two different symds instances on the same host with different ports the web ux becomes confused (chenson)

0003619: [Bug] Fix error during demo initialization (mmichalek)

0003629: [New Feature] New file conflict resolvers (newer and older wins). (josh-a-hicks)

0003638: [Bug] Throughput calculations were miscalculating (josh-a-hicks)

0003642: [Bug] Monitor exceptions when there is a dash in the node name (mmichalek)

0003653: [Bug] Oracle RAC using sequence noorder can expire last gaps (elong)

0003485: [Improvement] Do not log out users while trying to add a table trigger or table routing even if it would take them over the limit. (josh-a-hicks)

0003496: [Bug] Fix com.fasterxml.jackson.databind.exc.UnrecognizedPropertyException: Unrecognized field "stagedLocation" (mmichalek)

0003499: [Bug] Web Socket Null Pointer Exception after Unregistering a node from its parent, the parent continues to try to connect (gwilmer)

0003507: [Improvement] Mute RemoteStatus connection failure messages (mmichalek)

0003488: [Bug] Misnamed property for HTTP Transport manager to support remote status (josh-a-hicks)

0003433: [Improvement] Control center should re-read the sym_service.conf file before performing actions (elong)

0003437: [Improvement] Create first data gap to begin with 1 instead of 0 (josh-a-hicks)

0003439: [Bug] Installer should require Java 8 or higher (elong)

0003442: [Improvement] Upgrade IZPack (elong)

0003449: [Improvement] Relaunch SymmetricDS Control Center symcc as privileged on Windows (elong)

0003452: [Bug] Quick config fails to compare routers (josh-a-hicks)

0003458: [Improvement] Improve RemoteStatusService to use cached node lookup for performance (mmichalek)

0003460: [Improvement] Add default parameter for remote.status.follow.group.link.direction (josh-a-hicks)

0003469: [Bug] SQL Explore for MySQL (possibly others) not displaying tables on the Tree (josh-a-hicks)

0003472: [Bug] Remote status parameter remote.status.follow.group.link.direction not working (josh-a-hicks)

0003477: [Improvement] Ability to send create function/procedure statements through send sql feature (josh-a-hicks)

0003480: [Improvement] New statistics screen available under help (josh-a-hicks)

0003482: [Bug] Load data wizard allows you to send a load to node you are logged into (josh-a-hicks)

0003483: [Improvement] Cosmetic updates on Send Table Schema and removed initial load count help text from table routing (nrichardson)

0003402: [Improvement] Update lo4j.xml with 3.9 settings during upgrade (mmichalek)

0003368: [Bug] LDAP Security Principal (maxwellpettit)

0003396: [Bug] Sql Explore tab does not support load only databases (josh-a-hicks)

0003399: [Bug] Setup warns there is not enough memory on Linux (elong)

0003403: [New Feature] Compression and encryption of staging area (elong)

0003410: [Improvement] Change keystore password during installation (elong)

0003411: [Bug] Read only or write only users get an Error when clicking a node on the Manage > Nodes screen. (mmichalek)

0003417: [Improvement] Adjust throughput manager to not include reload channels (josh-a-hicks)

0003367: [Bug] Remote node replacing Master Node User (maxwellpettit)

0003379: [Bug] Import in Configure->Overview not working properly (kstojanovska)

0003393: [Improvement] Load data wizard to allow reverse loads (josh-a-hicks)

0003413: [Improvement] Ability to take a support snapshot when license violation page is displayed. (josh-a-hicks)

0003426: [Bug] Null pointer on dashboard with offline nodes (maxwellpettit)

0003428: [Improvement] Adjust table count calculation (josh-a-hicks)

0003241: [Bug] File sync should not sync all files when first scanning a directory (kstojanovska)

0003126: [New Feature] Support viewing Remote Status of Nodes (mmichalek)

0003257: [Bug] Syntax Formatting Error When Connected to ORACLE DB (elong)

0003166: [Bug] Memory leak cause by VAADIN websockets (chenson)

0003208: [Bug] Node Setup Wizard Fails (maxwellpettit)

0003219: [Improvement] Remote Node Registration Screen Layout (kstojanovska)

0003233: [Improvement] Upgrade to VAADIN 8 (chenson)

0003266: [Improvement] Add a new parameter to control the max number of batches on the Outgoing Batches screen (maxwellpettit)

0003330: [Improvement] On Logging Panel, manage auto-scroll based on users natural scroll position, fix multi-line logging (mmichalek)

0002567: [Installation] Postgresql 9.5 / Installation / autocommit parameter (josh-a-hicks)

0002934: [New Feature] Make the dashboard more useful. Allow different quadrants to be configured. (josh-a-hicks)

0003125: [New Feature] Encrypt and/or compress staging (elong)

0003159: [Improvement] Make enabling clustering an option during setup (kstojanovska)

0003160: [Task] Update Doc (jwilmer)

0003195: [Bug] Duplicate External Id Bug (kstojanovska)

0003164: [Improvement] Disallow the use of whitespace, and other URL unfriendly characters in external ids in the node setup wizard. (kstojanovska)

0003111: [Improvement] When running jobs manually, run in the background with a dismissible dialog box (chenson)

0001320: [Improvement] Replace the dashboard graph. (josh-a-hicks)

0002933: [New Feature] Redesign the outgoing and incoming batch screen more useful (maxwellpettit)

0003228: [Improvement] Minimize the amount of saves to sym_console_user during logging in (chenson)

0003248: [Improvement] Check DB2 for i (AS/400) journaling during setup wizard check permissions (elong)

0003254: [Bug] NuoDB validation query incorrect (josh-a-hicks)

0003255: [Improvement] Don't query metadata when looking of a console user. there is an opportunity for a deadlock there. (chenson)

0003265: [Bug] Outgoing batch query causes deadlocks (mmichalek)

0003245: [Bug] Importing configuration from the GUI works for CSV only not SQL (kstojanovska)

0003235: [New Feature] License support for number of tables and throughput (josh-a-hicks)

0003238: [Bug] License key parameters not refreshed when key is first installed or a new key is submitted (josh-a-hicks)

0003139: [Improvement] On the node screen. Allow nodes to be pre-registered. You should be able to enter the node id, external id and the group (kstojanovska)

0003153: [Improvement] Create loads by channel (kstojanovska)

0003144: [Bug] On a three tiered system the remove node option is not available at the root for nodes that are a tier away on Manage > Node (kstojanovska)

0003140: [Bug] On the node screen. Don't allow loads to be queued up for disabled nodes (missing sym_node_security or sync_enabled=0) (kstojanovska)

0003151: [Improvement] Add the ability in the Symmetric Pro installer to configure the com.sun.management.jmxremote.rmi.port property. (maxwellpettit)

0003149: [Improvement] Add setting to sql explorer to turn off auto complete (maxwellpettit)

0003161: [Improvement] Get rid of reference to 2 different versions of slf4j (chenson)

0003019: [New Feature] Add Registration Screen when Registering a Remote Node (maxwellpettit)

0003022: [Bug] Manage Outgoing Batches Sort Order Clears on Refresh (maxwellpettit)

0003023: [Bug] Reload Wizard Label is misleading "Delete all data in the table(s)." (mmichalek)

0003021: [Bug] Clicking OutgoingBatch.batchId may interrupt a batch's extraction (mmichalek)

0003032: [Bug] sym_consoler_user_hist should not be sent during registration to clients older than 3.8.18 (chenson)

0003040: [Bug] "Clear Batches" generates an error when you try to clear more than one batch at a time (chenson)

0003001: [Improvement] Add Console User Password Security Requirements (maxwellpettit)

0002902: [New Feature] Build triggers in the background when rebuilding from the Installed Triggers screen (chenson)

0002905: [New Feature] Present a dismissible in progress dialog during the installation of a SymmetricDS node (chenson)

0003004: [New Feature] Add Parameter to Disable Explore Tab (maxwellpettit)

0003006: [Bug] Dashboard Graph Select All and Select None not working (maxwellpettit)

0003012: [Bug] Node panel may not show hierarchy properly (mmichalek)

0002896: [Bug] You shouldn't be able to open registration on nodes that are two tier away in the pro console (chenson)

0002850: [Improvement] Highlight Row Differences in Batch Data View (mmichalek)

0002895: [Bug] node_communication and lock tables no longer export in snapshot when NOT in cluster mode (chenson)

0002897: [Task] Don't sync console events (chenson)

0002900: [Improvement] Improve performance of batch data lists by using Grid component instead of table (mmichalek)

0002901: [Bug] Websocket timeouts show up in log files as errors (chenson)

0002906: [Bug] Sql Explorer leaks a connection each time you login and navigate to the sql explorer panel (chenson)

0002907: [Bug] Uninstalling a child node causes null pointer exception (chenson)

0002908: [Bug] Fix layout issues with notice dialog that is used to display batch errors (chenson)

0002877: [Bug] Do Not Show check box for the quick config wizard does not work (chenson)

0002882: [Bug] Auto Create filters out tables with the same name that have been configured in a different schema (mmichalek)

0002881: [Improvement] Ability to override the default sync url in node setup wizard (josh-a-hicks)

0002884: [Bug] If you create a new trigger and use the same id as an existing trigger it overwrites the existing trigger (mmichalek)

0002891: [Bug] Null Pointer on Dashboard (chenson)

0002706: [Improvement] Make it possible to log raw Ldap exceptions (mmichalek)

0002851: [Bug] Fix ConcurrentModification on dashboard refresh (mmichalek)

0002853: [Improvement] Show Tables column on incoming batch panel (mmichalek)

0002854: [Bug] Stack trace and empty message when registration is not open (elong)

0002855: [Bug] Cannot change "from" address on configure mail server panel (elong)

0002741: [Bug] SQL Explorer with "results as text" on firebird (chenson)

0002856: [Task] Remove client polling now that server push is turned on for the web console (chenson)

0002858: [Bug] SQL Explorer hangs for truncate and create statements that are run on sql server (chenson)

0002862: [Task] Update the documentation for data loading (josh-a-hicks)

0002866: [Bug] Uninstall doesn't log out of console because of null pointer trying to audit the uninstall (chenson)

0002867: [Improvement] Get rid of Vaadin warnings in log file (chenson)

0002872: [Bug] Console Events fail when performing multi step actions (josh-a-hicks)

0002873: [Bug] The dashboard doesn't automatically refresh (chenson)

0002848: [Improvement] Use lower transaction isolation for dashboard, outgoing loads, outgoing/incoming batch screens (elong)

0002838: [Improvement] Adjust Incoming and Outgoing screens to show OK (ignored) only under ignored and any status filters (josh-a-hicks)

0002839: [Bug] Recent batch activity showed incorrect channel information (josh-a-hicks)

0002842: [Bug] String out of bounds error when using code complete in sql explorer (chenson)

0002844: [Improvement] Speed up ui refresh for sql explorer by enabling the vaadin push api (chenson)

0002827: [Bug] User gets NPE on dashboard for unregistered node (elong)

0002840: [Bug] ProcessInfo key contains channel thread not channel Id since 3.8.0 (josh-a-hicks)

0002802: [Improvement] Outgoing and Incoming batch panels show ignored batches as just OK (josh-a-hicks)

0002796: [Bug] File Channels are missing when first enabling file sync. (mmichalek)

0002810: [Improvement] Add button for sending test email from mail server edit panel (elong)

0002811: [Improvement] Filter status of <Any> on Manage->Monitors (elong)

0002829: [Improvement] Certain parameters (such as oracle.use.transaction.view) aren't editable on the UI, but should be. (mmichalek)

0002806: [Bug] Sync of console events gets unique key violation (josh-a-hicks)

0002791: [Improvement] Every network error is logged and alerts user on Dashboard (elong)

0002779: [Bug] sql explorer result pane doesn't display when pks aren't in the list of returned columns (chenson)

0002789: [Improvement] Manage nodes shows node in red for offline or batch in error but no indication (josh-a-hicks)

0002790: [Improvement] Outgoing batch screen requires you to hit refresh on filter changes (josh-a-hicks)

0002795: [Bug] Manage logging screen will not display any logging information if the log4j.xml layout pattern is changed (josh-a-hicks)

0002794: [Bug] Choosing profile - Ill configure things myself does not prompt for a web console user / password (josh-a-hicks)

0002797: [Bug] Quick config wizard only shows group link if there are multiple routers for the same group link (josh-a-hicks)

0002798: [Improvement] Dashboard adjust unrouted data count to not include gaps (josh-a-hicks)

0002800: [Improvement] Add node wizard registration url should be a text field instead of a drop down (josh-a-hicks)

0002778: [Bug] AS400 source node is captured in correctly when changes are made in the pro web console (josh-a-hicks)

0002727: [Improvement] Active load summary page (josh-a-hicks)

0002733: [Improvement] Outgoing and Incoming Panel display batch ignored only if it the entire batch was ignored. (josh-a-hicks)

0002735: [Improvement] File parsing routing to use new 3.8 context service to save file pointer information (josh-a-hicks)

0002739: [Bug] vaadin illegal state exception (chenson)

0002744: [Bug] Console events are not compatible with Firebird (josh-a-hicks)

0002745: [Bug] Load data wizard table selection for remote nodes (josh-a-hicks)

0002622: [Improvement] Partial initial loads (josh-a-hicks)

0002614: [Improvement] Quick config wizard does not capture the schema value if the default catalog is changed. (josh-a-hicks)

0002719: [Improvement] Incoming and Outgoing batch panels showed ignored status if any rows were ignored (josh-a-hicks)

0002473: [New Feature] Receive schema and data reloads from manage nodes screen of admin console (josh-a-hicks)

0002623: [Improvement] Filter out system information from the web console (josh-a-hicks)

0002637: [Bug] Quick config wizard throws null pointer on empty catalog (josh-a-hicks)

0002673: [Improvement] DBF Router to provide a parameter to ignore header validation (josh-a-hicks)

0002713: [New Feature] Added feature to incorporate DB Compare into SQL Explorer (rsunderhaus)

0002715: [Improvement] Upgrade vaadin to 7.6.8 (chenson)

0002717: [Improvement] Enable Vaadin's production mode for better security and performance (chenson)

0002398: [Improvement] Outgoing batches option to clear metadata (elong)

0002500: [Improvement] Report the original error message when a connection exception or unknown host exception happens during registration (chenson)

0002503: [New Feature] Add IP address filter for web console (elong)

0002507: [Improvement] Use license key from parameters and remove java prefs (elong)

0002521: [Improvement] Add number of error alerts to browser page title (elong)

0002527: [New Feature] More log level settings for logging panel (elong)

0002528: [Improvement] Log viewer with auto refresh off should keep scroll position (elong)

0002529: [Improvement] Colorize log viewer for warn, error, and filtering (elong)

0002543: [Improvement] Parameter to hide system information from the dashboard (josh-a-hicks)

0002552: [Improvement] Allow user to specify memory size for server (elong)

0002606: [Improvement] Add sym_service.conf to snapshot file (elong)

0002608: [Bug] Changing initial load delete SQL can break the configuration export (elong)

0002617: [Improvement] Allow user into web console as soon as one engine initializes (elong)

0002619: [Improvement] Easy to see drop-down list with arrows to scroll (elong)

0002620: [Improvement] Nodes Panel slow to pop-up Send->Table Data and Schema (elong)

0002652: [Bug] Using the standard 2 tier profile does not cleanup properly if there were previous entries in sym tables. (josh-a-hicks)

0002676: [New Feature] Record console user events (josh-a-hicks)

0002703: [Improvement] Data Load Wizard (josh-a-hicks)

0002712: [Improvement] Quick config wizard enhance trigger routing labels (josh-a-hicks)

0002588: [Improvement] Order files on the staging area screen (josh-a-hicks)

0002663: [Improvement] Display sql message and sql code when viewing batch details if one is present. (josh-a-hicks)

0002672: [New Feature] Ability to filter outgoing batches by load (josh-a-hicks)

0002692: [Improvement] Upgrade the SQL Explorer to show trigger text and have code complete functionality (chenson)

0002729: [Installation] Software upgrade listener extension (josh-a-hicks)

SymmetricDS - Change Log

SymmetricDS - 3.14.18

SymmetricDS - 3.15.12

SymmetricDS - 3.16.0

SymmetricDS - 3.15.11

SymmetricDS - 3.15.10

SymmetricDS - 3.15.9

SymmetricDS - 3.15.8

SymmetricDS - 3.14.16

SymmetricDS - 3.15.7

SymmetricDS - 3.15.6

SymmetricDS - 3.14.15

SymmetricDS - 3.14.14

SymmetricDS - 3.15.5

SymmetricDS - 3.15.4

SymmetricDS - 3.14.13

SymmetricDS - 3.15.3

SymmetricDS - 3.14.12

SymmetricDS - 3.15.2

SymmetricDS - 3.14.11

SymmetricDS - 3.13.13

SymmetricDS - 3.12.24

SymmetricDS - 3.9.26

SymmetricDS - 3.15.1

SymmetricDS - 3.14.10

SymmetricDS - 3.15.0

SymmetricDS - 3.14.9

SymmetricDS - 3.14.8

SymmetricDS - 3.14.7

SymmetricDS - 3.13.12

SymmetricDS - 3.12.23

SymmetricDS - 3.14.6

SymmetricDS - 3.14.5

SymmetricDS - 3.13.11

SymmetricDS - 3.12.22

SymmetricDS - 3.14.4

SymmetricDS - 3.13.10

SymmetricDS - 3.12.21

SymmetricDS - 3.12.20

SymmetricDS - 3.13.9

SymmetricDS - 3.14.3

SymmetricDS - 3.13.8

SymmetricDS - 3.14.2

SymmetricDS - 3.12.19

SymmetricDS - 3.14.1

SymmetricDS - 3.13.7

SymmetricDS - 3.12.18

SymmetricDS - 3.14.0

SymmetricDS - 3.12.17

SymmetricDS - 3.13.6

SymmetricDS - 3.13.5

SymmetricDS - 3.13.4

SymmetricDS - 3.12.16

SymmetricDS - 3.13.3

SymmetricDS - 3.12.15

SymmetricDS - 3.12.14

SymmetricDS - 3.13.2

SymmetricDS - 3.12.13

SymmetricDS - 3.13.1

SymmetricDS - 3.13.0

SymmetricDS - 3.12.12

SymmetricDS - 3.11.14

SymmetricDS - 3.10.14

SymmetricDS - 3.12.11

SymmetricDS - 3.12.10

SymmetricDS - 3.12.9

SymmetricDS - 3.12.8

SymmetricDS - 3.12.7

SymmetricDS - 3.12.6

SymmetricDS - 3.12.5

SymmetricDS - 3.11.13

SymmetricDS - 3.10.13

SymmetricDS - 3.12.4

SymmetricDS - 3.11.12

SymmetricDS - 3.12.3

SymmetricDS - 3.11.11

SymmetricDS - 3.12.2

SymmetricDS - 3.12.1

SymmetricDS - 3.11.10

SymmetricDS - 3.12.0