Syniti Data Replication (DBMoto) V9.7.2.28 Release Notes 1/26/21

NOTE: Before upgrading from a DBMoto/Syniti Data Replication version earlier than 9.7.0, take the following steps:  

• Stop the Replication Agent/Data Replicator of the current version of Syniti DR (DBMoto).
• Open the Management Center and select the metadata node.
• Back up the metadata.
  Metadata backup is not only important to keep a copy of the current metadata settings: it also commits any pending changes that are waiting to be saved in the metadata database that may be lost when a product upgrade is performed.
• Close the Management Center.
• Stop the Server Agent.
• Run the setup.exe for Syniti Data Replication V9.7.

General/Common

• Introduced a connection parameter for the maximum number of records to keep in memory while reading transactions.
• Added an alert when the Verifier scheduler reports differences.
• Improved message formatting for Replication Agent downtime alert.
• Included Ritmo/i version 7.1.0.3.
• Verified PostgreSQL partition table support.
• Improved browse connection rule to allow user to run the Verifier.
• Fixed the catalog query to get the primary key information from the IBM Db2 for i system table.
• Removed the Verifier Scheduler from the number of client connections.
•  

Management Center

• Added a column label for Transaction Latency values in Replication Monitor.
• Increased the size of the combo box in the Log panel.
• Added a warning in the Create Connection Wizard when choosing the wrong database type during Azure Synapse connection creation.
• Included the use of Extended Properties in the connection string for PostgreSQL LSA.
• Added a warning for the Oracle connection properties dialog where changing the password on the main connection does not change it on the log reader connection.
• Updated behavior of the "Override Identity Fields" option in Replication Properties.
• Set the "Transaction Latency Threshold" for each replication job, other than as global parameter.
• Source and Target connections are now mentioned in the Verifier details panel.
• In the Verifier, added support for Oracle default fetch size to improve performance.
• Redesigned the Verifier Options dialog to use tabs, fixing an issue where it was not displayed properly.
• Removed a warning message that occurred when resetting the AWS S3 "Output Folder Archive" parameter.
• Renamed Microsoft Azure Data Warehouse to Azure Synapse as DB Type in the Connection Properties dialog.
• Fixed an issue where last ID was not obtained when creating a replication from PostgreSQL using the Log Server Agent.
• Fixed an issue that occurred while retrieving PostgreSQL partitioned tables from the database.
• Fixed an issue where editing "Compare Subset of Columns option" was not possible in the Replication Properties Preferences.
• In the Replication Properties dialog, fixed an error that occurred when editing and saving multiple replications with an IBM Db2 source.
• Fixed an issue in PostgreSQL connection properties that occurred when changing the Max Pool Size and Min Pool Size (they should contain no spaces).
• Fixed an issue that occurred when setting Replication Agent trace filtered by replication: the trace was incorrectly enabled when adding or removing a replication from a group.
• Fixed an issue in Create Table Rule script where an exception occurred on creating a target table with target databases of type file (CSV, XML, JSON etc.)
• Fixed an issue that occurred when creating a target table from Oracle to SQL Server: timestamp to datetime2 would add an incorrect precision value.
• Fixed an issue with numeric data types (precision and scale undefined) in PostgreSQL.
• Fixed an error that occurred on disabling a replication from the Management Center right panel: Object reference not set to an instance of an object.
• Fixed a datatype issue when converting from long to varchar in the Create Table Wizard for Azure Synapse.
• Fixed an issue where a newly created Oracle connection was defined with Transactional Support = LogReader by default.
• Fixed an error with Reconcile for Multiple Verification: "...there are no cached data to reconcile..."
• In the Verifier, fixed a "Reconcile data error in replication" problem: the DELETE statement in some specific cases was not generated properly.
• Fixed an error that occurred in editing replicationa using Azure as target connection.
• Fixed an "object reference exception" error in the Connection Properties dialog when switching to a server with a different version than the one currently configured.
• Fixed an issue with table Aliases and catalog queries. Now columns, data types, foreign keys and indexes can be successfully loaded.
• Fixed an error related to a different script language in the metadata custom restore.
• Fixed an issue that occurred when setting up triggers: selecting existing master tables on schemas with no access permission would generate errors.
• Fixed the Custom Restore Wizard where the CommitMode and other options were not restored correctly.
• Fixed a datatype mapping issue in the Create Table wizard for Azure Synapse.
• Fixed an issue in the mirroring filter where the OR operator was not supported.
• Fixed an issue with the Start Page where links opened an Internet Explorer instead of the default browser.
• Fixed an object reference exception related to the Replication Monitor tab that occurred when loading the Management Center.
• Fixed an issue where in some cases the Management Center lost focus after clicking on a message box dialog.
• Fixed an issue with DTD where it was not saved in the connection properties dialog.
• In the Replication Monitor, removed msec portion from replication latency column.
• Adjusted the layout of the Enable Transactional Replication wizard.

Log Reading

• Added support for transactional replications using triggers with Progress OpenEdge as a source.
• For the IBM Db2 UDB log reader, added support for AutoXxx datatypes.
• For the Oracle log reader, fixed an issue that occurred in some cases when user ID is UNKNOWN.
• Introduced a new version of the Oracle Remote LSA with a simpler Java application that is easier to install and run on the database server.
• Added support for long passwords to the Log Server Agent for IBM Db2 for i.
• Fixed a problem where Log Server Agent config.ini files were not updated when mappings are changed via API.
• Fixed a problem that caused an error while parsing a SELECT LOB statement with a column value NULL.

Replication Agent

• Added support for replicating identity columns for Sybase ASE and SQL Anywhere databases.
• Added support for Progress OpenEdge database as a target in SDR replications.
• Implemented batch deletion of records for deleting all records from a table before running refresh for OpenEdge tables.
• Introduced refresh staging to improve refresh replication mode by keeping data in the target table during the refresh.
• Improved the DELETE JOIN statement for MySQL in bulk mirroring.
• Added support for Teradata version 16.
• Added support for AutoInteger in SQL Server bulk mirroring.
• Improved SAP HANA trigger-based replications.
• Conducted stress tests on some default parameters to find the best initial values. Increased default ""Max Concurrent Connections"" and ""Max Concurrent Threads"" from 20 to 50 and ""Thread Execution Factor"" from 10 to 100.
• Fixed a SQL Server LOB value reading error "System.IndexOutOfRangeException: Index was outside the bounds of the array."
• Fixed a Bulk Refresh issue that caused a failure in the recovery function when the bulk operation went into recovery: it could crash the Replication Agent.
• Fixed a bulk Refresh/Mirroring problem where, if an error was generated while recovering in single insert, the replication could not be disabled.
• Fixed an error (Index was outside the bounds of the array) reading LOB data from Microsoft SQL Server when the column name contains the character '_'.
• Fixed a bulk Mirroring issue with Microsoft Azure tablse without primary keys (uncommon.)
• Fixed a group bulk mirroring issue and added traces for a System.NullReferenceException error that occurred when saving a record in the local cache.
• Fixed an issue with staging tables where in case of errors the LOG Message output sometimes had column names not aligned with values.
• Fixed a SQL Azure Data Warehouse datetime error that occurred during bulk mirroring. Datetime2 was not used properly in the staging table.
• Fixed a replication scheduler issue where mirroring would start during a mirroring interruption period after rebooting the system running Syniti Data Replication.
• Fixed a regression bug recently introduced causing the Replication Agent crash after refresh.
• Fixed an issue with SAP ASE triggers where the identity gap when creating the master table is now explicitly defined (to avoid creating huge TID values in trigger tables).
• Fixed an issue in Oracle triggers to enforce order by where the transaction IDs were not ordered.
• Fixed a timestamp issue in IBM Db2 for i: when precision is 0 or 2 etc... not the default during mirroring.
• Fixed an issue where replication does not start automatically when CommitID value is "0-1#0".
• Fixed an issue with bulk mirroring for Microsoft SQL Server: "Cannot insert the value NULL into column" issue. The staging table was not using the right precision for a datetime2 data type and so the update join was failing to update some records causing an error.
• Fixed an issue where HANA triggers were created without quotes for column __ID.
• Fixed an issue in onExecuteError where, if the record was aborted, the error message was still written to the log.