Stelo Data Replicator v6 Release History

Release History

This section provides information about problems or enhancements that are made available as "point releases" and major releases of the Stelo Data Replicator software.

Version Number Release Date Description
v6.40.1129 Nov 2024 New Features/ Enhancements

1352 - Display ODBC Driver Version associated with a source or destination
1434 - monitor the outcome of memory allocation by SQDRSVC

Bug Fixes

1452 - "0 alter table generated for destination" when modifying smallint/tinyint/mediumint/int to bigint
1509 - Tier 3 is trying to change BQ destination columns that are timestamp to datetime
1523 - Reduce default replication buffer size to 10MB from 100MB. Monitor Memory for excessive consumption
1525 - Rebuild column list should display source data as it currently exists - regardless of whether or not a new generation is pending
1115 - NOT NULL fields replicated as NULLABLE fields instead of REQUIRED to BigQuery
1362 - Alter adding column blob data type is mapping to Binary data type from MySQL to Databricks
1366 - "Provided Schema does not match Table" when modifying column data type for column drop & create again using a different data type from MariaDB to BQ
1406 - "Create Lob column..." checkbox in service properties should be consistent after closing and re-open service properties dialog
1411 - Update columns control table with destination datatypes
v6.39.0819 Aug 2024 New Features/ Enhancements

608 - [HADR] T3 automatically refreshes the connection string to T2
826 - [HADR] sqdrsvc management of standby state
848 - Databricks destination should always be created without precision
852 - Enhance Drmgr to detect when SQDRSVC is in standby state
846 - Add defaults to Snowflake connection strings
865 - Add configurable option to "over-allocate" mbcs & wide character buffers
878 - Add new panel to the "Group" Properties - default columns to be "added" to when creating new subscriptions or rebuild column lists of existing subscriptions
899 - Expand default Replication Buffer Size to 100MB from default of 4MB
900 - ir_subscription query incorrectly reports capture option bit values
901 - Add new query - Subscription.sql
902 - support crash dump file for Docker
910 - Expand use of buffer for baseline to improve multirow performance. Expose more replication detail
892 - New MySQL driver 8.4
946 - Alter processing refresh - to handle changes that are associated with Postgresql; MySQL driver updates
1002 - drmgr: improve icon for standby SQDR service (HADR)
1004 - drmgr: eliminate pop-up errors during and after HADR role switch
1013 - Change to connection string-should invalidate typeinfo cache, too
1015 - Incorporate destination schema prior to performing alter processing
1018 - BigQuery can only handle up to five alters at a time
1021 - Alter processing should map source databases using StarSQL alters specifying BIGINT to BigQuery INT64
1036 - Reset dwell time between calls to pushchanges (streaming apply)
1086 - Modify the powershell commandlet for Read-SQLGetTypeInfo to return a list of rows, not individual objects
1067 - Touchup newly created or updated subscription meta data with Tier 4 version of datatypes.
1068 - Provide explanation of Alter mapping dispositions
1117 - Use json array for default_derived_columns. save with "raw" string - i.e. no need to escape quotation marks
689 - Upgrade ODBC - MySQL driver to 8.4.0-1
871 - Upgrade the SQDR Progress bundled drivers to 8.0.1.59
944 - Certify DB2 11.5.9 Special Build 42449 (2024-05-18) to be used by Stelo as control database
1118 - Upgrade ODBC - Databricks driver to 2.8.2.1013-1
1119 - Upgrade ODBC - BigQuery driver to 64_3.0.5.1011

Bug Fixes

1120 - Inflate settings in Column Mapping Options changed back to default after re-opened subscription
1123 - "Truncate table" option is disabled after selecting mariaDB destination when creating IR subscription
1074 - "Invalid character values" after creating IR subscription from iSeries to SQDR Postgres using name containing "_"
1077 - Different column names when creating single table and multi-table from iSeries to SQDR Postgres
1078 - IR subscription requires "Baseline snapshot" after creating IR subscription when during the creating process, click on properties and cancel on IR Group
1079 - Different behavior between creating single subscription and multi-subscription in case of "creating target unique index"
1080 - "error: Stored procedure SQDR0.NEWGENERATION" after dropping a columns with service properties DROP =ignore
1091 - "Invalid String or buffer length" message when mapping varchar (MAX), nvarchar(MAX) from SQL Server to SQDRPostgres/Snowflake
1092 - At the "Select the destination" tab, the default value of "Baseline replication options "when selecting Snowflake differs from the other databases.
1096 - Source did not exist when creating multi-subscription from table have wild card from SQL Server
1097 - Column displayed incorrectly when using table contain wildcard (_) from SQL Server
1107 - The "inflation" subscription service property is no longer being honored in the DRMGR.
1110 - Baseline Replication Options should change to "Truncate table..." after click back button and click next
1111 - DRMGR crashes after click Properties button when creating Snapshot and selecting an empty GROUP
1116 - Incorrect mapping from SQL Server to SQDR Postgres when using inflate
882 - db2diag logs churn due to permissions error
934 - drmgr crash after creating IR subscription to Oracle19 that is currently unavailable
940 - Unable to run dnf install in general inside of the Docker image
1028 - After the takeover of HADR, IR Group was not paused even after being modified
1029 - create of group fails in subscription wizard if group name is too long.
1033 - Should change default mapping from number (Oracle) to number (29,0) (BQ) - old mapping is number (38,0)
1034 - Could not alter add column Clob from SQDR Oracle to Snowflake
1035 - Alter process wrong column from SQL ORacle if last column using float data type
1047 - Precision of mapping character varying data is reduced from 1048576 -> 32767 after altering table from PINE to SQDR Postgres when using clob/nclob
1048 - "Invalid query: Type not found: CLOB at [1:47]" When altering table add clob column from iSeries/Oracle to BigQuery
1049 - "Invalid query: Type not found: CHAR at [1:46] " When altering table add char(n) column from iSeries to BigQuery
1051 - Precision of "Long varchar" has up and down based on the values ​​of the text data type
1052 - Precision of mapping character varying data is reduced from 1048576 -> 32767 after altering table from Oracle to SQDR Postgres when using clob/nclob
1053 - Date mapping data type change from "timestamp with timezone" -> timestamptz after altering column from SQDR Oracle to SQDR Postgres
1054 - "Invalid query: Type not found: NUMBER at [1:46] " When altering table add numeric(n,p) column from Oracle to BigQuery
1059 - IR subscription could not run after altering Int/smallint from Oracle to BQ
1062 - Could not alter add column Clob from SQDR Oracle to SQDR Postgres
1063 - Clob/nclob mapped to unsupported data type to SQDR Postgres
1066 - Could not alter datatype text from MySQL to Snowflake
1020 - "Narrowing type parameters is not compatible" when modifying "int" to "bigint" from PINE to BQ
981 - Alter add column Clob/nclob from PINE and insert some data that made IR subscription paused and could not be resumed
982 - "Replication Service Error" message displayed when modify "maxvarchar size" of connection string of SQDR Postgres/PostgreSQL
984 - Alter add column Clob from PINE to SQDRPostgres and insert some data that made IR subscription paused and could not be resumed
996 - SQDR interface crashes after selecting IR Group and inserting multi-subscription
953 - "Syntax or semantic analysis error thrown in server " when altering adding data to table that already has datetime/date/timestamp column from MySQL to Databricks
958 - Subscription statistics displayed incorrectly added column when alter table add a column
959 - Mapping "varchar" is incorrect from MySQL to Databricks
966 - "[Simba][Hardy] (80) Syntax or semantic analysis error " when altering add a column to an existing table that has longtext column from MySQL/Maria to Databricks
969 - "Unable to find suitable mapping type" error when replicating text datatype from SQL Server to MySQL using MySQL ODBC 8.0 driver
971 - "Datetime field overflow" when clicking on Logs after clicking cancel button on Group/IR Group properties windows
973 - ALTER has to be run manually for busy I/R groups
975 - Postgres - bool maps to STRING instead of BOOL
948 - Subscription statistics displayed incorrectly added column when alter table add a column
949 - "Token was not valid" when altering add a column to an existing table that has longtext column from MySQL to iSeries
950 - "Bind of destination insert parameters failed" when making baseline using datatype "longtext" from MySQL to Oracle19
921 - "SQL syntax" error message displayed after replicating XML from SQL Server 18 to MySQL 8.4
917 - "Invalid JSON text: "Invalid value."" after creating IR subscription using ntext & nvarchar(max) data type from SQL Server 18 to MySQL8.4
918 - "Save Subscription Error" message displayed when creating IR subscription using tinytext/mediumtext/longtext from MySQL to SQDR Postgres
872 - Message "Unable ControlDB" displayed when clicking standby after upgrading primary in docker
847 - Invalid schedule parameter causes scheduler to raise an assertion
853 - SQDR service crashes upon encountering an odd row
839 - 'Display Update Paused' should not be set
v6.38.0424 Apr 2024 New Features

715 - Watchdog for SQDR Service: monitor and automatically restart sqdrsvc when stopped abnormally

Bug Fixes / Enhancements

632 - Changing service properties should log the old and new values
799 - Merge need not stay in single row mode while in openwindow processing
801 - Add "NO_CACHE=1" touchup to MariaDB and MySQL driver connection strings
747 - Expand baseline truncation error detection & reporting
748 - Db2 license does not persist through upgrades
774 - IR subscription from MySQL keep active status in spite of drop source table
780 - Derived column prompt should default to non-Nullable
786 - "Invalid string or buffer length provided by the application" after inserting float value when using IR replication = Merge
787 - "Expression type does not match column..." displayed when replicated data from MariaDB to Snowflake with DML replication = Merge
716 - Creation of I/R group hangs while running baseline to BQ
636 - DB2 LUW ODBC Driver not present in Docker image
725 - Avoid string truncation warning when processing Postgresql destination
728 - "Unexpected Error Java heap space" displayed after making IR subscription from SQDR Postgres to BigQuery using a large table
723 - Exit condition for PushChanges - A completed streaming baseline (COPYDONE) should not prematurely end in-process incremental processing
741 - Stack corruption when checking auto commit state.
v6.37.0307 Mar 2024 Bug Fixes / Enhancements

665: Touch up BigQuery ODBC Driver NUMERIC and BIGNUMERIC to specify minScale=0
668: Certify DB2 11.5.9 Special Build 39210 (2024-02-08) to be used by Stelo as control database
v6.36.0227 Feb 2024 Bug Fixes / Enhancements

655 - An incremental group cannot contain two members referencing the same source table. Move operation should enforce this constraint.
656 - Assertion "sizeof (ts.first) == ..." raised when comparing timestamps for redo
v6.34.0206 Feb 2024 Bug Fixes / Enhancements

617 - PUSHCHANGES call should be optioned as Asynchronous
625 - 'Pause' using like instead of exact match
626 - DR Manager shows the same group and its subscriptions twice in the tree
v6.32.0108 Jan 2024 Bug Fixes / Enhancements

511 - [PostGreSQL] Bundled driver datatype "bit"; "bit varying"; &"serial" should be exact match
v6.30.1207 Dec 2023 New Features

405 - Add a new dialog on the advanced panel of the destination property page - the default group advance parameter value to be used when creating a new IR Group. Modify the Parameter Data page of the Group.
193 - Certify SAP/HANA ODBC Driver
278 - Create script for restoring control databases in the event of a restore operation
424 - Default the ""Stream"" destination advance property as selected, when Destination Database is either kSpark or kBigQuery. Supply corresponding default for Parameter corresponding to Stelo Support Tech notes
331 - Display which methods are timing out in 'Deadline exceeded ' error message
457 - Enhancements to the Drmg Service->Properties->Service panel
302 - Expand default Request Timeout to 120 s from 20 s
477 - Handling (VAR)CHAR for BIT DATA from iSeries to BigQuery or Databricks: set agent configuration property binaryCCSID = 37 (default is 65535)
188 - Improve loading objects speed in drmgr by incorporating filter as part of get to service to limit amount of data returned
379 - Improvements for 'Add Server' function: friendly name, resolve to IP if DNS is performing poorly, test button and more
478 - Make ""ODBC Driver"" default selection when defining a new source or destination
181 - pause must include a force cancel option
430 - Set Refresh Config option when group parameters have changed

Bug Fixes / Enhancements

183 - ""Login failed"" displayed after modified destination when creating new IR subscription
185 - Column of Subscription/Log page is disappeared if trying to change size of column with out of bound.
196 - Datatype ""BIGINT"" is mapped to ""STRING"" from source=informix and any destination.
336 - Do not honor checkpoint restart for streaming destination
488 - Ensure destination primary key columns marked prior to saving subscriptions.
404 - Error message displayed after export table to existing file
308 - Error message displayed when export or clear log after fresh install
353 - File -> Replay Updates... should be enabled for IR Group only
200 - Inconsistent for Data Type ""char/varchar/nvarchar"" is mapped to ""GRAPHIC/VARGRAPHIC"" between Linux and Win from any source and destination=DB2 for i
452 - IR group should keep running if the user did not change anything and click OK button
373 - Password for the SQDR and DB2INST1 users expire after 90 days
184 - Properties window should display after double click Source
294 - Strict apply rule with soft delete should not delete rows
176 - Unknown error shows when opening IR Group, Cancel this Group then clicking on IR subscription.
v6.22.1011 Oct 2023 Bug Fixes / Enhancements
Installer changes
v6.20.0817 Aug 2023 New Features
16085 - RBAC: Expand implementation of "Log Details"
16079 - Modifying schedule should not overwrite the destination
16053 - drmgr: Need indicator when display update is paused
16042 - Expand "rename" subscription and group dialog to full size of the column name
16026 - Support BigQuery ODBC Driver
16023 - Schedule query should return all available data for the scheduled task
15965 - Add filter based upon IR status for Incremental Group Members and Source subscriptions
15945 - Support Postgresql as incremental source
16015 - Implement new method to return current Scheduler queue contents
16021 - Provide new query for Control Table "schedule"

Bug Fixes / Enhancements
16131 - Use of "NOT LOGGED" not supported by DB2 for zOS
16123 - The Group icon change status when used with authorized account
16086 - Logs: clicking filter icon off does not disable filter
16073 - drmgr 6.2x crashes when communicating with sqdrsvc 6.1x
16068 - Revamp "rename/duplicate" dialogs
16066 - drmgr crashes when attempting to open a subscription under a group->member
16059 - Duplicate Group show incorrect help
16058 - Cannot launch help in rename textbox of Source & Destination
16027 - The Multi IR subscription did not run after created when using group with automatic snapshot turn off
16024 - Database/Schema does not display after creating a group without clicking in the Advanced tab
15986 - The new source does not display after using non-existed agent until after re-opening the source
v6.15.0531 May 2023 New Features
16001 - Permit cancel of a connection that is associated with either Apply or Staging

Bug Fixes / Enhancements
15979 - The Destination tab is missing parameters after renaming the destination of a running IR subscription
15985 - Parameters are not logged for Set commands (source/dest; group and subscription)
15989 - GetTableIndexesStatistics is not properly returning the value of the non_unique index column from SQLStatistics
15998 - Enable logging as default with a 7 day retention after running the Data Replicator Configuration
16005 - Set subscription hangs when saving a group with a schedule
16006 - Handle unknown datatype promotion to [LONG]VARCHAR by the staging agent
16009 - The refresh icon should refresh the log view
16010 - SQL_GUID type not allocated properly when replicating between Postgresql and SQL Server
16013 - Implement a tool that transforms sqdrmsg in Linux
16019 - Add a service property to force schedule recalculation at service startup
v6.14.0420 Apr 2023 New Features
15925 - New interface to run supplied queries for gathering statistics related to replications
15970 - Support "Unity" catalog for DataBricks
15977 - Add SingleStore ODBC driver to list of supported drivers
Bug Fixes / Enhancements
15920 - Improve visibility of MERGE performance
15921 - Adding parameter to -Json to cmdlet Import-Properties
15922 - Hang in SQDR when replaying group with pending transactions
15923 - Installer: VS Redistributables to 14.34.31938.0
15927 - Provide option to run Merge compression logic on destination
15928 - Add "more" processing back into Merge processing
15932 - Group icon does not show 'Synchronizing' when baseline is synchronizing
15933 - Destination object schema is auto changed to nonexistent schema
15936 - Merge using Tier 4 compressions requires Sequence number to be included
15938 - Snowflake: UTF8 storage of VARCHAR may exceed character precision of column
15941 - Provide means to display log messages in-full, given current sizing of window
15943 - Provide mechanism to configure larger gRPC send/receive message size (compress?)
15944 - Query of ir_subscription and ir_group does not return a value for "RPS" or "KBS"
15946 - Tier 4 compression should calculate max_sequence for only DML operations
15947 - PostGre: create merge statement must not contain "NOT NULL"
15948 - PostGre: UTF8 storage of VARCHAR may exceed character precision of column
15951 - Change of dml_Algorithm not working as intended
15952 - Merge: Change default to use Tier 4 compression
15953 - Add new attributes for Merge to ir_group.sql query
15954 - Unable to create subscription names with length greater than 30 characters
15956 - Merge Algorithm changes
15957 - Import of another group's subscriptions if another group is running baselines
15958 - Group baseline doesn't cancel
15959 - Limiting search for a particular group in the ir_subscription.sql and targetchecker.sql still results in all results being returned
15960 - Add filter option "ALL"
15962 - Provide service property to bypass use of MultiRow Apply
15963 - Merge: Commit merge statement without waiting for interlock
15966 - Use multirow for Snowflake even when synchronizing when using Merge
15967 - Autosnapshot option of incremental group does not appear to be functioning
15968 - Permit rename of source or destination object
15971 - Snapshot cannot re-run successfully after cancelling an already running snapshot replication
15972 - SQDR service stops after using ''' in Query textbox
15974 - Insure MultiRowApply does not inherit any bound parameters
15975 - Renaming a subscription does not work correctly after incorrectly renaming the subscription to an existing subscription
v6.12.0202 Feb 2023 15382 - ControlDB: allow longer passwords
15426 - Subscription/ Columns: Informix Interval data type - the precision shows as '%d' in the Add Column dialog
15465 - SQDR Manager: App hangs when importing subscription while having failure in destination connection
15471 - Subscription/ Column Properties: Long name datatype (INTERVAL YEAR(1) TO MONTH,datetime year to fraction) did not display fully
15479 - Adding subscription flow/Groups Schedule: The schedule shows "One Time'' when the group schedule set to 'Recurring'
15496 - Add Apache Spark (e.g. Databricks) as certified DBMS
15527 - PostgresSQL:Subscription/Add Column: decimal/numeric data types are not displayed in Source Type column
15528 - SQDR Manager/Source Properties: Allow Mixed-Case Input in New Capture Agent Schema input
15534 - Subscription: PostgreSQL to Informix - char(1) maps to MULTISET(1) by default
15562 - Installer: add SQDRConf and controlDB SQL scripts to drmgr installer
15575 - Installer: update to IS2021
15548 - Enhance destination object with new V6 functionality parameters
15563 - SQDR Manager: Empty Help content displayed when inserting IR Group while no Destination added
15580 - Installer: sign more binaries
15588 - sql_type used to bind source LOB primary key
15589 - Unable to create source/destinations when driver Name > 30 characters
15590 - Avoid use of Rollback if data source does not support transactional control
15600 - Avoid performing searched DML operation if subscription lacks key
15605 - SQDR Manager/Destination: The 'Create table' does not retain user's changes when creating/modifying destination in subscription flow
15636 - Qualify invocation of GNV function
15651 - Db2 to Snowflake- Subscription Column page: NCLOB/DBCLOB map to varchar(-1)
15665 - replication manager crashes when adding a derived column with more than 128 characters
15666 - SMTP email notifications for snapshot replication
15669 - MariaDB to Databricks: Subscription: Invalid mapping on LONGBLOB,TEXT,TINYTEXT,MEDIUMTEXT columns
15676 - "Replication Service Error" windows displayed after create Sources name with blank space first
15692 - MariaDB to otherDB: Subscription: Invalid mapping on LONGBLOB column
15708 - Report AccessControlDB startup problems to the event log
15713 - SQDRConf: recognize ODBC Driver 18 for SQL Server
15663 - Implement Role based access control (RBAC)
15731 - Implement Merge Apply algorithm
15795 - SDQR_ODBC 8.0.1.57
15801 - Installer: VS redistributables 14.34.31931.0
15886 - Add @SCHEMA and @DSN as macros interpreted as partitioning value

Contacting Stelo

If you need to contact technical support, please provide the following information to help the support engineers address your issue. You can contact Stelo via phone, email, or facsimile as indicated at the bottom of this page.

Company Information Address
Phone
Contact Information First and Last Name of individual contact
Email Address
Host Type Hardware and Operating System (i.e., IBM i 7.3)
Network Protocol/Gateways Protocol and/or Gateways used (i.e., TCP/IP, SSL/TLS)
Client Type Client Type and Operating System (i.e., Windows Server 2019, Oracle Linux 8.6)
Stelo Product,
Version, and Source
Which Stelo product and what version is installed (i.e., StarSQL for Windows v6.41.0719)
Where you obtained the software (i.e., direct from Stelo, name of specific reseller)
Problem Information Provide as much detail as possible, including information about any application that is using the Stelo product when the problem occurs and the exact error message that appears.

© 2023 Stelo. All rights reserved.

Stelo logoStelo, a StarQuest company
548 Market St, #22938
San Francisco, CA 94104-5401
Telephone: +1 415.669.9619
Sales information: https://www.stelodata.com/contact-stelo
URL: https://www.stelodata.com
Support: https://support.stelodata.com
Info Center: https://docs.stelodata.com