SymmetricDS Pro - Change Log

0006775: [New Feature] Add functionality to have the purge job automatically rotate the SAML SP x509 certificate when it's near expiration (emiller) 0006773: [Bug] RabbitMQ should make "username" and "password" required fields (cquamme) 0006769: [New Feature] Add a parameter to allow specification of OneLogin SAML properties via a properties file (emiller) 0006764: [New Feature] Add functionality to read the SAML IdP certificate from the IdP metadata URL (emiller) 0006766: [Improvement] Sign SAML requests with SHA-256 instead of SHA-1 (emiller) 0006756: [Bug] Compare request keeps running after cancellation (elong) 0006712: [Bug] The Manage Startup Parameters screen throws a NullPointerException when the engine.name contains a variable or BSH script (emiller) 0006713: [Bug] During an upgrade, new monitors and insights do not get inserted if sym_monitor already existed before the upgrade (emiller)

0006785: [Improvement] On the Define Endpoint screen, change the "Endpoint" field's label to "Select New or Existing Endpoint" (cquamme) 0006784: [Bug] The Deploy Wizard doesn't display the Time-Based screen when adding new tables to an existing time-based endpoint (emiller) 0006783: [Bug] Exasol icon doesn't work in dark mode (emiller) 0006760: [Bug] Postgres binary bulk loader fails to parse times with 4+ digits of precision and timestamps with 4, 5, or 7+ digits of precision (emiller) 0006776: [New Feature] Add functionality to have the purge job automatically rotate the SAML SP x509 certificate when it's near expiration (emiller) 0006748: [Bug] RabbitMQ should make "username" and "password" required fields (cquamme) 0006771: [Bug] RabbitMQ fails to connect when using the Connect Database wizard (emiller) 0006770: [New Feature] Add a parameter to allow specification of OneLogin SAML properties via a properties file (emiller) 0006765: [New Feature] Add functionality to read the SAML IdP certificate from the IdP metadata URL (emiller) 0006759: [New Feature] Add support for timestamp with time zone data type to Postgres binary bulk loader (emiller) 0006767: [Improvement] Sign SAML requests with SHA-256 instead of SHA-1 (emiller)

0006543: [New Feature] Add a Configure Canvas to replace the Design tab (emiller) 0006551: [Improvement] Bulk export for SQL Server and Sybase ASE (elong) 0006544: [New Feature] Bulk loader for Sybase ASE (elong) 0006688: [New Feature] Dynamic reload queue to scale initial load (elong) 0002338: [Improvement] Bulk Extract for MSSQL (elong) 0006736: [New Feature] Documentation for OAuth 2.0 and OpenID Connect (cquamme) 0006234: [New Feature] Web console logins with OAuth 2.0 and OpenID Connect (cquamme) 0006436: [Improvement] Change how bulk loaders determine when to flush their data (emiller) 0006444: [Improvement] Improve how bulk loader flag is set and how bulk loaded percentage is calculated (mdrouard) 0006466: [Improvement] Adding File Sync Service for Azure Blob Storage (mdrouard) 0006549: [Improvement] Process panel able to interrupt if thread is available (elong) 0006650: [New Feature] Add a way to add a prefix or suffix to transforms when doing auto-create (cquamme) 0006696: [Improvement] Max Batch Size insight shouldn't check reload channels (emiller) 0006714: [New Feature] Package Microsoft's bcp utility into setup program (elong) 0006715: [New Feature] Package Oracle's SQL*Loader utility into a module (elong) 0006745: [Bug] RabbitMQ Errors when "data_loader_type" is bulk (cquamme) 0006750: [New Feature] Exasol Support as a Target Platform (josh-a-hicks)

0006747: [Bug] RabbitMQ Errors when "data_loader_type" is bulk (cquamme) 0006743: [Improvement] Add SymmetricDS label as a Client Provided Name for new RabbitMQ connections (pbelov) 0006731: [Bug] Failed to capture change from binary DB2 log because of the 0x00 byte incompatible with runtime tables in Postgres (elong) 0006732: [Bug] Snowflake support for variant data type (josh-a-hicks) 0006733: [Bug] In the Connect Database Wizard, clicking the "Previous" button and switching from log-based capture causes unexpected behavior (emiller) 0006738: [Bug] Compare and Repair has issues requesting more than one node at a time to compare (pmarzullo) 0006740: [Bug] Compare Repair status should indicate when repair is needed but not attempted (pmarzullo) 0006746: [Bug] Compare request when load transform is using variable for target table (elong)

0006679: [Bug] Oracle bulk loader fails to parse database URLs that use TNS format and contain spaces before the equals signs (elong) 0006694: [Bug] Insight count doesn't update when approving or dismissing an insight and then collapsing the insight manager (emiller) 0006698: [Bug] Wizard automatically opens without verifying that the console user has write permission (emiller) 0006699: [Bug] Logging Set Levels Advanced throws exception when running in servlet container (not standalone) (pmarzullo) 0006711: [Bug] MSSql bulk loader using bcp fails to load some special characters when bcp is running on Windows (pmarzullo) 0006719: [Improvement] The database performance test dialog initially displays a rating of 0.0, causing confusion (emiller) 0006720: [Improvement] The connection test dialog's error message should appear at the top of the dialog (emiller) 0006723: [Bug] The Add Tables Wizard allows duplicate triggers to be added when the source database doesn't support both catalog and schema (emiller) 0006724: [Bug] SQL Server windows authentication is missing DLL (elong)

0006635: [Bug] Add Tables Wizard gets info from the wrong database when not using the source node group's web console & metadata is unavailable (emiller) 0006668: [Bug] When resolving data by editing the values on the incoming side, null values are lost and replaced with empty strings (pmarzullo)

0006649: [Bug] Enabling or disabling extension resets the script to template (cquamme) 0006667: [Improvement] Add logging and user notification when exceptions occur on saving the Console User Form (cquamme) 0006669: [Bug] When resolving data by editing the values on the incoming side, null values are lost and replaced with empty strings (pmarzullo) 0006673: [Bug] When saving extension as a copy the copy does not have the same extension script as the original (cquamme) 0006674: [Bug] False conflict change detection on update of Null or Empty values in NVARCHAR(MAX) and VARCHAR(MAX) columns (SQLServer-specific) (pbelov) 0006680: [Bug] Reopening registration for a node that handles registration can orphan nodes from replication (josh-a-hicks)

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)

0006580: [Bug] Java job validation behaves incorrectly (emiller) 0006582: [Bug] Clicking outside of job script editor causes unexpected behavior (emiller) 0006601: [Bug] Upgrade chartjs library (elong)

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)

0006463: [Improvement] RabbitMQ support for username and password (josh-a-hicks) 0006455: [Improvement] Conflict detection newer wins for log miners (elong) 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)

0006306: [Bug] Syntax error when updating sym_table_reload_status using a Progress OpenEdge database (emiller) 0006308: [Bug] LOBs should not be included in where clauses when using a Progress OpenEdge database (emiller) 0006303: [Improvement] Progress OpenEdge platform should have a dirty SQL template (emiller) 0006265: [Bug] Registration failing when registering node is remote and SMTP password is set to null in sym_parameter (emiller)

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)

0005950: [Bug] Allowance of blank passwords (JishLong) 0005946: [Bug] Onprem to cloud infrastructure script makes routers in same direction (pmarzullo)

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)

0005688: [Bug] Logging out of UI after running a job like sync triggers can interrupt job (elong) 0005682: [Bug] Script editor doesn't always show error message when validation fails for Java code (emiller) 0005680: [Bug] Edit Script button on Configure Extensions screen gets disabled unnecessarily (emiller)

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)

0005633: [Improvement] Ensure that SQL Server log miner always captures deletes in foreign key order (emiller) 0005627: [Bug] Editing transform columns (add/edit/delete) does not specify the column transform order (pmarzullo)

0005533: [Bug] Sync Errors table in Active Errors dialog contains incorrect data when node IDs contain hyphens (emiller) 0005549: [Bug] Leaving table selection screen of Load Data Wizard while editing a where clause causes unexpected behavior (emiller) 0005600: [Bug] Upgrade Jetty, PostgreSQL driver, Vaadin (elong) 0005608: [Improvement] Replace deprecated cacls command with icacls command (emiller)

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)

0003789: [Improvement] Sort SQL configuration export by primary key to make it easier to diff (elong) 0005170: [Bug] Typing a class name in the Advanced Set Logging Levels dialog doesn't work as expected (emiller) 0005173: [Bug] DB2 zOS support for clobs (josh-a-hicks) 0005181: [Bug] Misspelling in message about license maintenance date exceeded (pmarzullo) 0005185: [Improvement] Upgrade Vaadin to 14.8.1 (emiller) 0005193: [Bug] Can't reject a registration request in error (elong)

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)