Scheduled For Release 2024-06-14
0006511: [Bug] Routing can include the same change in multiple batches with the same target node if an exception occurs (elong)
0006103: [Bug] Unregistration of client node at server node causes cleanup problems and registration problems when running with multiple queues (pmarzullo)
0006107: [Bug] Restart of instance creates USE_CHANGED_DATA/NEWER_WINS batches even when conflict.default.pk.with.fallback=true (pmarzullo)
0006530: [Bug] Conflict resolution needs to set source node ID when executing conflict resolution for a SQL Server log mining node (pmarzullo)
0006484: [Bug] Do not issue foreign key correction for non-DML events (elong)
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)
0006477: [Bug] If auto resolve missing foreign key fails, try again (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)
13 of 16 issue(s) resolved. Progress (81%). View Issues
Scheduled For Release 2024-07-12
0006496: [Improvement] Adding Indexes to Sym_ Tables
0006134: [Improvement] DBCompare excluded/included columns require specified names to be lower case
0006532: [Bug] Conflict resolution needs to set source node ID when executing conflict resolution for a Postgres trigger based node (pmarzullo)
0006535: [Improvement] Support for MySQL 5.1 with latest 3.15.x versions (josh-a-hicks)
0006529: [Improvement] Do not data load columns that are generated (computed) (josh-a-hicks)
0006528: [Improvement] Upgrade sybase JDBC driver to jconn4 version 16.0 build 27538 (pmarzullo)
0006512: [Bug] Routing can include the same change in multiple batches with the same target node if an exception occurs (elong)
0006497: [Bug] Bandwidth request needs authentication info (pmarzullo)
0006248: [Bug] H2 should check if auto increment will work instead of just always using a sequence for autoincrement implementation (pmarzullo)
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)
0006485: [Bug] Do not issue foreign key correction for non-DML events (elong)
0006513: [Bug] File Sync Tracker changes to improve performance and to collect completely the set of files (pmarzullo)
0006521: [Improvement] Initial load request should cancel outstanding load requests (elong)
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)
0006510: [Bug] SQLite with initial load in background can hang (elong)
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)
0006475: [Bug] New "Initial Load" not cancelling previous initial loads (elong)
0006482: [Bug] Could not find trigger history causes error of wrong number of columns data validation in wrong column (elong)
19 of 28 issue(s) resolved. Progress (67%). View Issues
Scheduled For Release 2024-08-31
0006462: [Improvement] Migrate from the Text data type to varchar(max) or nvarchar(max)
0002655: [Improvement] Parameters and/or programmatic way to control type and size for sym_data, sym_trigger fields
0006429: [Improvement] Upgrade dependencies to latest versions (emiller)
0004951: [Bug] Sybase: drop column needs to add "with no datacopy" clause to succeed (pmarzullo)
0006244: [Improvement] Upgrade H2 library to 2.2 (emiller)
0006351: [Bug] Text and icons disappear in SQL Explorer TreeGrid when switching nodes (emiller)
2 of 6 issue(s) resolved. Progress (33%). View Issues
Scheduled For Release 2024-06-14
0006481: [Bug] New Database Schemas Only Showing up in "Add Table(s) Wizard" After Service Restart
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)
8 of 9 issue(s) resolved. Progress (88%). View Issues
Scheduled For Release 2024-07-12
0006480: [Bug] New Database Schemas Only Showing up in "Add Table(s) Wizard" After Service Restart
0002448: [Improvement] When configuring triggers in pro, detect fk dependencies and prompt the user if they want to sync
0006116: [Bug] Creating node using import configuration does not keep the non-default values for the default channels (pmarzullo)
0006135: [New Feature] Add Parameters as replacement tokens in Notification templates (pmarzullo)
0006471: [New Feature] Allow REST API authorization using JWT (emiller)
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)
19 of 24 issue(s) resolved. Progress (79%). View Issues
Scheduled For Release 2024-08-31
0006262: [Improvement] Adding a Node Description
0005506: [Bug] Remove productionMode context parameter in web.xml (pmarzullo)
0006234: [New Feature] Web console logins with OAuth 2.0 and OpenID Connect (jvanmeter)
0006466: [Improvement] Adding File Sync Service for Azure Blob Storage (mdrouard)
0006436: [Improvement] Change how bulk loaders determine when to flush their data (emiller)
2 of 5 issue(s) resolved. Progress (40%). View Issues