Release Notes Fivetran HVR Version 6.2.0/44 (windows-x64-64bit) 2026-06-23 COMPATIBILITY FOR PLATFORM WINDOWS-X64-64BIT -------------------------------------------- Fivetran HVR version 6.x is not compatible with the versions 5.x and 4.x. So, ensure that the HVR version is 6.x on the Hub machine and Agent machine. - Operating System: Windows Server 2012 R2, 2016, 2019, 2022, and 2025. NTFS and FAT file systems - Ingres: versions 10.0, 10.1, 10.2, 11.0, 11.1, 11.2 (with patch 15820 or later) and 12.0 Capture of X100 tables is not supported - Vector: versions 5.0, 5.1 and 6.0 as hub and target, not capture. - Oracle: versions 11.1, 11.2, 12.1, 12.2, 18, 19c and 21c - Netweaver: versions 7.5 and higher - SQL Server: versions 2012, 2014, 2016, 2017, 2019, 2022, 2025 and Azure SQL Database SQL Server: Azure Synapse Analytics as target, but not capture and not hub - DB2 on Linux, Unix, Windows: versions 10.5, 11.1 and 11.5 - DB2 for i: versions 7.2, 7.3, 7.4, 7.5 and 7.6 Requires IBM i Access Client Solutions ODBC Driver 13.64.22.00 Driver versions newer than 13.64.22.00 (up to 13.64.28.00) cause a SIGSEGV error. The issue can be resolved by downgrading the driver or by requesting a patch from IBM. (bug ID DT393413, support ticket TS01648646) - DB2 for z/OS: versions 11.1, 12.1 and 13.1 Version 11.1 requires DB2 client, DB2 server or DB2 Connect version 10.5 or higher Versions 12.1 and 13.1 requires DB2 client, DB2 server or DB2 Connect version 11.1 fixpack 1 or higher - PostgreSQL: versions 9.5, 9.6, 10, 11, 12, 13, 14, 15, 16 and 17 DIRECT capture method is only available until PostgreSQL 16 Aurora PostgreSQL: versions 11, 12, 13, 14, 15, 16 and 17 - MySQL: versions 5.6, 5.7, 8.0, 8.1, 8.2, 8.3 and 8.4 MariaDB: versions 10.3, 10.4, 10.5, 10.6 and 10.11 Aurora MySQL: versions 1, 2 and 3. - Snowflake: as target, but not hub or capture Requires Snowflake ODBC driver 2.13.20 or higher - SingleStore: versions 7.1 (7.1.8 or higher) as target, but not as hub or capture - Databricks on Azure: versions 10.x, 11.x, 12.x, 13.x and 14.x as target, but not as hub or capture Requires Simba Spark ODBC Driver 64-bit version 2.6.19 or higher - Databricks on AWS: versions 10.x, 11.x, 12.x, 13.x and 14.x as target, but not as hub or capture Requires Simba Spark ODBC Driver 64-bit version 2.6.19 or higher - Google BigQuery: version 2.3 as target, but not as hub or capture Requires Simba ODBC Driver for Google BigQuery version 2.3.2 or higher - HANA: versions 1.0 SPS 11 and 12, and versions 2.0 SPS 00 up to SPS 08 as target, but not capture. Requires HANA ODBC driver 2.00 or higher - Teradata: versions 16.x and 17.x, as target and hub, not capture Requires Teradata ODBC driver 16.10 for Teradata 16.x Requires Teradata ODBC driver 17.10 for Teradata 17.x Requires TTU 16.10 libraries for Teradata 16.x Requires TTU 17.10 libraries for Teradata 17.x - Greenplum: versions 6.0.x to 6.90 as target, not as capture or hub. Requires DataDirect Connect64 XE ODBC 7.1.3.99 - 7.1.5 driver for Greenplum provided by Pivotal - Amazon Redshift: version 1.0.x, as target, not as capture or hub. Requires Amazon Redshift driver 1.2.6.1006-1 - File replication: local, FTP/FTPS and SFTP - Apache Hive: version 1.1, 2.1, 2.3, 3.0, 3.1 with UnixODBC driver manager HVR can create Hive external tables above S3/HDFS files. Hvr only uses these during compare. Refresh or integration of this data is done into the S3/HDFS file location. Capture from Hive and hub database in Hive are not supported. Requires ODBC driver manager UnixODBC. Requires HortonWorks ODBC 2.1.2 or above for Hadoop Hive Requires Cloudera ODBC 2.5.15 or above for Hadoop Hive - Apache Kafka: versions 0.8 and above (including 0.11) - Amazon S3: supported - Google Cloud Storage: supported - Azure Blob File System: supported - Azure Data Lake Store: Gen2 supported - Installation: Hub and Agent - Perl 5.8 or higher (only needed for hub machine). BUNDLED IN THIS INSTALLATION ------------------------------------- - Fivetran Proxy Agent 1.2.2 - Procrun Service Application 1.4.1-x64 from Apache Commons Daemon - Java Runtime Environment (JRE) 17.0.18 API VERSIONS SUPPORTED BY THIS HUB SERVER AND FOR REMOTE CLI ------------------------------------------------------------ /api/v0 /api/v6.0.5 /api/v6.0.5.1 /api/v6.0.5.2 /api/v6.1 /api/v6.1.0.3 /api/v6.1.0.4 /api/v6.1.0.5 /api/v6.1.0.6 /api/v6.1.0.7 /api/v6.1.0.11 /api/v6.1.0.15 /api/v6.1.0.26 /api/v6.1.0.36 /api/v6.1.5 /api/v6.1.5.2 HOSTED DATABASE SUPPORT POLICY ----------------------------- Often HVR supported source and target locations that can be installed on premises will be hosted by third parties such as cloud providers including (but not limited to) Alibaba, Amazon, Google, Microsoft and others. These hosted systems are generally supported by HVR as sources and targets insofar as they are compatible with their downloadable counterparts. The certification of compatibility is incumbent on the hosting provider, not HVR. Platforms have been separately documented where compatibility is not comparable and HVR has been able to implement interoperability code changes (for example, Amazon Aurora PostgreSQL). If a provider claims compatibility then they must offer the same SQL and API calls and responses that support the features as indicated in the HVR documentation for the corresponding location class requirements in the appropriate source and target sections. In cases where compatibility is not complete then support is not guaranteed. Any issue that may exhibit itself on the hosted platform must be reproducible on an equivalent downloadable version to be considered a bug in the HVR software. INSTALLING A FIVETRAN HVR UPGRADE ------------------------- Often all machines are upgraded at the same time. Current HVR version are fully compatible with two previous major versions; it is not necessary to upgrade all machines in a channel at once. Instead it is possible to only upgrade certain machines. E.g. only the hub machine, agent machine, capture (could be the hub or an agent), or the integrate machine (could be the hub or an agent). If this is done, it should be understood that each HVR release fixes some bugs and/or contains new features. Each bug fix or feature is only effective if the specific machine(s) indicated for it are upgraded. New features should not be used until all machines that are specified for that feature are upgraded, otherwise errors can occur. For example, if a new HVR release fixes an integrate bug, then that release must be installed on the machine(s) which do integrate. So if only the hub machine is upgraded, then there will be no benefit. To decide whether each machines needs to be upgraded, see the descriptions in the release notes below. Each description ends with a line says which machine must be upgraded for that specific bug fix or feature to be effective. LOG BASED CAPTURE SUPPORT ------------------------- - Ingres Log based capture is supported for all Ingres versions supported by HVR. No support for dual or partitioned DBMS log-files. No support for page-spanning rows. DDL replication (using action AdaptDDL) is not supported. - Oracle Log based capture is supported for all Oracle versions supported by HVR. Oracle RAC (cluster) and Oracle ASM are supported. For Oracle version 9, log-based capture is not supported for LOBs or tables without a primary key. Compressed tables are only supported for Oracle 11.2 and higher. Log based capture is supported from Data Guard standby database for Oracle 11 and higher. HVR can also capture from an database that was previously a Data Guard target. If HVR was capturing changes from one primary Oracle database and a role transition occur (so that a different Data Guard target becomes the new primary) then HVR can continue capturing from the new primary, including capturing any changes which occurred before the transition. This process is automatic, providing that the HVR location is connecting to Oracle in a way which 'follows the primary'. Log based capture from tables that are encrypted using Oracle TDE is supported for Oracle version 11 and higher. Both tables in an encrypted tablespace and tables with encrypted columns are supported. HVR supports software and hardware (HSM) wallets. If the wallet is not configured as auto-login (Oracle internal file cwallet.sso), the password for the software wallet or HSM needs to be set on the HVR Live Wallet port using the hvrlivewallet command. The software wallet can be in ASM or in a local filesystem. Capturing from Oracle TDE is not supported on HP-UX. Platforms that use OpenSSL version 3 do not support auto-login wallets for Oracle version 11. - SQL Server Log based capture is supported for SQL Server 2008, 2012, 2014, 2016, 2017, 2019, 2022 and 2025. Data Compression is supported. Capture from compressed backup transaction log files is supported. Capture from encrypted backup transaction log files is supported. Capture from memory optimized tables is not supported. Capture from tables with XML_COMPRESSION = ON is not supported. Capture of typed XML columns containing xsd:float and xsd:double values is not supported. Log based capture from databases that are encrypted using the SQL Server TDE is supported. The log based capture is supported only for the databases whose Database Encryption Key (DEK) is protected by Certificates. Log based capture is not supported from databases whose DEK is protected by Asymmetric Key. Column level encryption is not supported. Always Encrypted feature is not supported. - DB2 on Linux, Unix, Windows (LUW) Log based capture is supported for DB2 on Linux, Unix, Windows (LUW). The following table types are supported - regular tables, multidimensional clustering (MDC) tables, insert time clustering (ITC) tables, uncompressed tables, row compressed tables (both static and adaptive) and value compressed tables (both static and adaptive). - DB2 for i Log based capture is supported for DB2 for i - DB2 for z/OS Log based capture for DB2 for z/OS is supported. The following table types are supported - regular tables, compressed tables, partitioned tables, history tables and archive tables. Capture from LOAD is not supported. - PostgreSQL Log based capture is supported for all PostgreSQL versions supported by HVR. - HANA Log based capture is supported on Linux (not Windows) for HANA: version 1.0 SPS 11 and 12, and version 2.0 SPS 00 up to SPS 07 Only column-store tables are supported (no row-store tables). - MySQL and MariaDB Log based capture is supported for all MySQL and MariaDB versions supported by HVR. FIVETRAN HVR NETWORK ENCRYPTION ---------------------- An HVR connection to a remote location can be configured so that all communication over the network is encrypted. For network encryption, HVR uses OpenSSL, which is developed by the OpenSSL Project (http://www.openssl.org). HVR uses OpenSSL version "3.2.1" CREDITS ------- - License Agreements, Copyrights, and Notices for the third-party software are listed in the hvr.3rdparty file in HVR_HOME directory NEW FEATURES IN HVR 6.2.0/44 (2026-06-23) ---------------------------------------- [RD-1155847] DB2 FOR I: ADDED SUPPORT FOR DB2 FOR I VERSION 7.6 To use this feature, upgrade HVR on all machine(s). Added support for Db2 for i version 7.6. [RD-1162930] ORACLE: ADDED FILE SIZE AND TIME RANGE LOGGING FOR ARCHIVE LOGS To use this feature, upgrade HVR on the capture machine(s). This improvement adds logging of file size and approximate start and end times for each Oracle archive log opened during capture. PROBLEMS FIXED IN HVR 6.2.0/44 (2026-06-23) ---------------------------------------- [RD-1214929] FIXED ORPHANED TRANSACTION EXPIRY To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where orphaned open transactions could keep capture scan state pinned. This fix adds an opt-in orphan transaction expiry setting, HVR_SCAN_EXPIRE_TX_ORPHAN, so orphaned transactions with an unreliable begin timestamp can be discarded after the configured age and later syncs do not repeatedly rewind to a stale scan position. [RD-1221993] DATABRICKS: FIXED NULL ROWS INSERTED DURING INTEGRATE AFTER BULK REFRESH To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where HVR inserts rows with all columns set to NULL into the Databricks target table when Integrate processed changes captured during a Bulk Refresh. This occurred when column names used different casing between the source definitions and the target table. HVR now handles these column name comparisons case-insensitively. [RD-1183942] DB2 FOR I: FIX F_JD22E1 WHILE CAPTURING EMPTY AND NULL LOBS To fix this bug, upgrade HVR on the capture machine(s). HVR could occasionally encounter F_JD22E1: Log record has unexpected length when capturing NULL and empty LOBs. Some Db2 for i installations prefix NULL and empty LOB value entries in their transaction logs, while others do not. HVR now detects the log format automatically and handles both cases correctly. [RD-1207125] SQL SERVER: FIXED DUPLICATE PRIMARY KEY ERRORS FOR FIXED-LENGTH BINARY COLUMNS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where SQL Server capture could replicate inserts incorrectly for tables with wide fixed-length binary columns. This could cause duplicate primary key errors during integration. [RD-1207225] SQL SERVER: FIXED PARTITION SWITCH CAPTURE FAILURE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where SQL Server capture could fail after an ALTER TABLE SWITCH PARTITION operation moved a partition between tables, when the receiving table or both tables were enrolled in the channel. Capture now re-associates the moved partition with the receiving table and correctly processes the affected enrolled tables. [RD-1220957] SQL SERVER: FIXED F_JD20F2 FOR REFRESH WITH DISABLE TRIGGERS ON UTF-8 DATABASES To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where using the Disable Triggers option during refresh caused refresh to fail with error F_JD20F2 on SQL Server databases configured with the 65001 (UTF-8) charset. PROBLEMS FIXED IN HVR 6.2.0/43 (2026-06-09) ---------------------------------------- [RD-1197893] FIXED ADAPTDDL VALIDATION FOR COMBINED PRESERVE OPTIONS To fix this bug, upgrade HVR on the integrate and capture machine(s). Fixed an issue where setting KeepExistingStructure=1 and OnPreserveAlterTableFail=fail_integ_job together in an AdaptDDL action caused a validation error. These options can now be used together, correctly preserving extra target columns while stopping the integrate job on ALTER TABLE failure instead of dropping and recreating the target table. [RD-1211093] FIXED TABLE FILTER FOR NETWEAVER_NATIVE_DB_DICTIONARIES To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where table search results were not filtered correctly when using NetWeaver_Native_DB_Dictionaries. All tables appeared in the results regardless of the filter criteria applied. [RD-1213075] FIXED PRESERVED TARGET COLUMN VALUES AFTER SOURCE COLUMN DROP To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where AdaptDDL with KeepExistingStructure set to 1 would silently nullify preserved column values in the target after a source column drop. [RD-1214358] FIXED HVR HUB NOT APPLYING CHANGED ENVIRONMENT ACTIONS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where HVR Hub cached environment variables and did not apply them correctly when changed. This could cause commands issued directly from HVR Hub, such as "Redefine Source" from the Table Explorer menu, to use outdated Environment action values. [RD-1215702] FIXED DATA TYPE VALIDATION FOR NCHAR AND NVARCHAR COLUMNS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where changing a column's data type to nchar, nvarchar, or nvarchar2 without setting the charlen attribute was allowed. HVR now validates this requirement, preventing error F_JR0148. [RD-1207778] DATABRICKS: FIXED INSECURE S3 ACCESS WHEN DROPPING EXTERNAL TABLES To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where external table drop operations would use insecure HTTP access when the table location was specified with an s3://, s3a://, or s3n:// URL scheme. HVR now normalizes these URL schemes to s3s://, ensuring all S3 access uses secure HTTPS. [RD-1220565] DB2 FOR I: RESTORED SELECTION LOGIC WHEN CHOOSING LOGICAL FILE KEYS To fix this bug, upgrade HVR on the capture and agent machine(s). Fixed an issue where the logical file key selection logic for some tables differed from previous versions. This fix restores the original selection behavior and maintains backwards compatibility. [RD-1210093] ORACLE: FIXED LONG IDENTIFIER CHECK DURING ACTIVATION To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where channel activation could miss Oracle table names longer than 30 characters when enable_goldengate_replication was not enabled. HVR now validates long table names consistently during activation and reports the correct error before capture starts. [RD-1210674] ORACLE: FIXED F_JZ1985 ERROR DURING INSERT ON HCC TABLES To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where Log-based Capture encountered an F_JZ1985 error while processing INSERT operations on Oracle tables using Hybrid Columnar Compression (HCC). [RD-1218090] ORACLE: FIXED LOGMINER CAPTURE CRASH DURING TEARDOWN To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where Oracle Logminer capture could crash during teardown after processing change rows. [RD-1183351] SYBASE ASE: FIXED UNNECESSARY REFRESH AFTER COLUMN CHANGES To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where HVR could interpret certain Sybase ASE column changes as a table drop even though the table still existed. This could cause AdaptDDL to treat the table as recreated and schedule an unnecessary refresh. HVR now treats these cases as table alterations when the table still exists, avoiding the unnecessary refresh. [RD-1212906] SYBASE ASE: FIXED FAULT F_JZ270C IN DIRECT CAPTURE AFTER DEFERRED UPDATE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where the capture job could encounter fault F_JZ270C when a deferred UPDATE occurred during DIRECT capture. The capture job now handles this correctly. PROBLEMS FIXED IN HVR 6.2.0/42 (2026-05-26) ---------------------------------------- [RD-1212607] FIXED LATENCY API RETURNING INCORRECT EPOCH VALUES To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where the latency API (GET /api/v/hubs/{hub}/jobs?fetch=latency) intermittently returned epoch values instead of calculated latency. The bug occurred when metric data contained only a single timestamp without a second value, causing the parser to attempt conversion of an empty string, resulting in invalid latency calculations. HVR now correctly validates that parsed timestamp values are non-empty before conversion. [RD-909459] FIXED TRUSTED CAPTURE CHECKPOINT PERMISSIONS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where capture jobs using a trusted executable could create checkpoint directories with incorrect permissions. This would prevent capture from writing checkpoint files and cause intermittent F_JG20CD errors until a later checkpoint file repaired the directory permissions. [RD-1201480] DB2 FOR I: FIXED PREMATURE TERMINATION IN LOB JOURNAL PROCESSING To fix this bug, upgrade HVR on the capture and agent machine(s). Fixed an issue where processing journal data could terminate prematurely when encountering LOB (Large Object) entries. The system now correctly processes the entire set of records without stopping early. [RD-1207405] DB2 FOR I: FIX QUERY TO FIND KEYS ON TABLES WITHOUT CONSTRAINTS To fix this bug, upgrade HVR on the capture machine(s). Improved key discovery for DB2 for i sources. HVR now correctly identifies and includes DDS-defined keys on Physical Files as a fallback when standard SQL Primary Keys or Unique constraints are not present. [RD-876774] ORACLE: FIXED TRIMDATATYPE CHARACTER COMPARE MISMATCHES To fix this bug, upgrade HVR on the capture and hub machine(s). Fixed an issue where compare could report differences for tables with Oracle character or national character columns when ColumnProperties used TrimDatatype. HVR now uses consistent datatype metadata for truncated character values across describe and scan paths, so compare no longer reports datatype mismatches when the source and target rows are otherwise identical. NEW FEATURES IN HVR 6.2.0/41 (2026-05-14) ---------------------------------------- [RD-1210230] UPDATED BUNDLED FIVETRAN PROXY TO VERSION 1.2.2 To use this feature, upgrade HVR on the agent machine(s). Updated the bundled Fivetran Proxy to version 1.2.2. PROBLEMS FIXED IN HVR 6.2.0/40 (2026-05-12) ---------------------------------------- [RD-1204990] FIXED F_JT0490 SKIP-HINT ARGUMENT ORDER To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where, after integrate raised F_JT0490 following a projection failure, the suggested hvrcontrol workaround command showed the location and table arguments in the wrong order (-l ... -t), so you could not copy and run the hint as-is. This fix now emits the arguments in the correct order so the hint matches the expected template: -l ... -t
. [RD-1175060] DB2 FOR LINUX, UNIX AND WINDOWS: FIXED INCORRECT LSN ADJUSTMENT DURING RECORD SEARCH IN REWIND To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where the rewind record search used incorrect LSN values, causing prolonged searches and replication errors during Db2 LUW capture. [RD-1172717] DB2 FOR I: FIX JOURNAL CACHING ISSUE LEADING TO F_JT1478 ON MISSING RECORDS To fix this bug, upgrade HVR on the capture machine(s). This update addresses the F_JT1478 error that could occur when missing records are detected. The fix updates the query used to read entries from DB2 for i journals, ensuring correct behavior in environments where journal caching is enabled. [RD-1177215] DB2 FOR I: FIXED JOURNAL QUERY CAUSING SQL0443 ENDING_SEQUENCE NOT VALID ERRORS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where capture queries for Db2 for i could fail with SQL0443 ("ENDING_SEQUENCE NOT VALID") when reading journal receiver sequence information. This fix corrects how the receiver end sequence is determined so that HVR passes a valid ending sequence to journal data retrieval. [RD-1156404] DB2 FOR Z/OS: FIXED F_JG2302 FOR TABLES SHARING A NON-UTS TABLE SPACE To fix this bug, upgrade HVR on the capture machine(s). Fixed an "F_JG2302: Assignment from list did not use all available elements" error when handling multiple tables in the same segmented non-UTS table space. [RD-1186488] GOOGLE BIGQUERY: FIXED F_JD2133 OVERFLOW FOR LARGE DECIMALS To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where replication to a BigQuery target could fail with F_JD2133 when decimal or numeric source columns had more than 29 integer digits, such as SQL Server NUMERIC(38,0). HVR incorrectly mapped these columns to BigQuery NUMERIC instead of BIGNUMERIC. This fix updates the BigQuery type mapping so columns that exceed the NUMERIC integer-digit limit are now mapped correctly to BIGNUMERIC. [RD-1206994] ORACLE: FIXED MISSING REDO LOG WARNING MESSAGE To fix this bug, upgrade HVR on the capture machine(s). Fixed an unclear warning message in Oracle capture. New message clearly states which archived log was searched for and was missing. NEW FEATURES IN HVR 6.2.0/39 (2026-04-28) ---------------------------------------- [RD-1029806] ADDED MIGRATION FOR CASE-SENSITIVE SCHEMA NAMES DURING ACTIVATE To use this feature, upgrade HVR on the hub machine(s). Added a migration utility to correct stored schema name casing for locations with Case_Sensitive_Names location property enabled after upgrading from HVR 6.1.0 to 6.2.0 or later. Older binaries stored schema names in lowercase defined in action TableProperties with parameter Schema. Newer binaries treat schema names case-sensitively, which can cause activate to fail with F_JD0006 when the stored schema name does not match Oracle's uppercase catalog entries. This utility detects the mismatch by querying the database for the actual schema names and updates the stored values accordingly. [RD-1192254] BUNDLE FIVETRAN PROXY 1.2.0 To use this feature, upgrade HVR on the agent machine(s). Upgraded bundled Fivetran Proxy to 1.2.0 Upgraded bundled JRE version to Azul Zulu 17.64.17 (Java 17.0.18) PROBLEMS FIXED IN HVR 6.2.0/39 (2026-04-28) ---------------------------------------- [RD-1029805] ADDED WARNING FOR CASE-SENSITIVE SCHEMA UPGRADE RISK To fix this bug, upgrade HVR on the capture machine(s). Added a warning during activation to help you identify legacy schema-name casing metadata that can cause activation failures when Case_Sensitive_Names location property is enabled on capture runtimes version 6.2 and later. This improvement helps you detect affected tables before upgrade-related table lookup failures occur. If you see this warning, update the affected metadata before proceeding. The hvrmigrateschemacase script can help migrate schema-name casing created on older builds. [RD-1157323] UPDATED ABAP TRANSPORT TO V1000012 To fix this bug, upgrade HVR on the capture machine(s). Replaced the SAP transport files with the latest version v1000012. This update includes fixes to avoid open cursor overflow due to failed S_TABU_SQL checks. Also, it includes fixes to improve data packet size estimation when syncing tables with LOB columns. [RD-1171671] ORACLE: FIXED ASM SESSION LEAK DURING RAC VASM CAPTURE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where log-based capture using the VASM method on Oracle RAC could leave unused ASM sessions open after log switch events. This fix closes the active online redo log before end-of-thread detection opens the related archive log, preventing unnecessary VASM worker processes and reducing ASM session usage. [RD-1194541] ORACLE: FIXED WALLET DIRECTORY SEARCH FOR MULTITENANT DATABASES To fix this bug, upgrade HVR on the capture and agent machine(s). - Fixed an issue where TDE capture could fail on Oracle RAC with CDB/PDB architecture using ASM-based keystores in UNITED keystore mode. - During enrollment, the wallet directory could not be resolved when the PDB inherited its TDE keystore from the root container. This could cause the capture agent to skip encrypted redo data and lead to missing target changes. - This fix improves wallet discovery for UNITED keystore configurations by deriving the wallet path from the `WALLET_ROOT` database parameter. PROBLEMS FIXED IN HVR 6.2.0/38 (2026-04-14) ---------------------------------------- [RD-1175831] FIXED INTEGRATION FAILURE WITH FORCE_CASE ON CASE-SENSITIVE TARGETS To fix this bug, upgrade HVR on the capture and hub machine(s). Fixed an issue where integration startup could fail when the Force_Case location property was used with a case-sensitive target database, such as PostgreSQL. During table description, HVR used the original source column names instead of the case-adjusted target column names, which could cause column-not-found errors. This fix ensures that the correct case-adjusted column names are used during integration startup. [RD-1178225] FIXED DATABRICKS BURST TABLE CLEANUP WHEN USING BURSTTABLESCHEMA To fix this bug, upgrade HVR on the integrate and hub machine(s). Fixed an issue where, for Databricks target locations, burst table cleanup could fail when action DbObjectGeneration with parameter BurstTableSchema was defined. This could leave burst tables behind after activation or deactivation. The fix ensures burst tables are dropped correctly from the schema specified by BurstTableSchema. [RD-1180269] FIXED CLI DEFINITION IMPORT ORDERING ISSUES To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where definitions exported with hvrdefinitionexport -m -a could fail to import into another hub with F_JR1732. This fix ensures location changes are applied before channel changes during CLI export and import processing. This update also preserves missing-member location handling when you use -m -r during import. After upgrading, you should no longer need to manually reorder exported JSON files before importing them. [RD-1185933] FIXED DUPLICATE FILE NAME USED DURING COERCEERRORPOLICY WARNING_FILE To fix this bug, upgrade HVR on the integrate machine(s). During parallel refresh the same name might be used for the WARNING_FILE when more than one table has coerce errors. This has now been fixed by adding the table name to the name of the warning file when more than one table is involved. [RD-1187582] FIXED CAPTURE CRASH DURING SESSION NAME MATCHING To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where capture could crash while matching session names for refresh state table during cascade replication when parameter IgnoreSessionName was defined. [RD-1169937] GREENPLUM: FIXED MISSING SCHEMA NAMES IN TABLE EXPLORER To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where user-defined schema names starting with "pg" or "gp" were missing in the Table Explorer. This fix ensures all user-defined schemas are now properly displayed. [RD-1065193] ORACLE: FIXED A REGRESSION WHEN CLOB COLUMNS WERE SET TO NULL To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where Oracle capture could incorrectly set CLOB columns to null on the target during soft delete processing. This fix restores the previous update behavior and corrects the conditions used to generate null values, including the delete case. [RD-1175801] ORACLE: FIXED MISSING COLUMN VALUES IN UPDATE OPERATIONS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where log-based capture could reconstruct incomplete row images for some UPDATE operations on compressed Oracle tables with chained rows. This could cause capture to fail with a "Missing value for column" error when Restrict parameter was applied. No additional action is required after upgrading. [RD-1187724] ORACLE: FIXED BFILE DIRECTORY COLLISION IN TDE ENVIRONMENTS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where Oracle BFILE capture could fail with ORA-22287 in TDE-enabled multitenant environments. Under certain conditions, a newly created Oracle directory could overwrite an existing directory with the same name, which could disrupt access to redo logs or wallet files. This fix ensures that newly created Oracle directories use unique names, preventing conflicts during capture. [RD-1188391] ORACLE: FIXED ACTIVATION FAILURE FOR CASE-SENSITIVE CDB USERS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where channel activation could fail with ORA-01017 when you configured a case-sensitive CDB root username with a c## prefix, such as "c##CS_MJSRC2". During activation script generation, the ## characters could be removed from the username, causing authentication to fail. This fix preserves these characters so activation succeeds with these usernames. [RD-1189554] SYBASE ASE: FIXED ASE DRIVER TRACING ISSUE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue in the ASE driver that could affect CT-Library tracing during data fetch operations. NEW FEATURES IN HVR 6.2.0/37 (2026-03-31) ---------------------------------------- [RD-1183285] DB2 FOR I: RESTRICTED USE OF QSYS2.GROUP_PTF_INFO TO DB2 FOR I 7.4 AND OLDER To use this feature, upgrade HVR on the integrate and capture machine(s). Db2 for i system catalog QSYS2.GROUP_PTF_INFO is now used only for Db2 for i versions 7.4 and older. It is no longer used for versions 7.5 and newer. This change avoids SQL0443 - NOT AUTHORIZED TO COMMAND WRKPTFGRP when the HVR user does not have the required permissions. [RD-1030967] SQL SERVER: ADDED SUPPORT FOR SQL SERVER 2025 To use this feature, upgrade HVR on all machine(s). Added support for SQL Server 2025. PROBLEMS FIXED IN HVR 6.2.0/37 (2026-03-31) ---------------------------------------- [RD-1164896] FIXED PERFORMANCE METRICS MEMORY CORRUPTION CAUSING STATISTICS FAILURES To fix this bug, upgrade HVR on the hub machine(s). This fix addresses a memory corruption in performance metric collection causing statistics failures. Resolved a bug in disk statistics collection that led to system instability. Disk statistics collection is unsupported when HVR runs in Docker containers with overlay filesystems. [RD-1167742] FIXED INVALID BYTE SEQUENCE ERRORS IN STATS JOB To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where the HVR statistics job could fail with "invalid byte sequence" errors on databases that strictly validate UTF-8 (for example, Aurora PostgreSQL). In some cases, the hub name used by the statistics pipeline could become corrupted during processing, resulting in empty or garbled values being sent in statistics queries. This fix ensures the hub name remains stable and correctly encoded throughout statistics collection. [RD-1170541] FIXED F_JD024D DUPLICATE ROW ERROR IN BURST INTEGRATE WITH RESILIENCE To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where Burst Integrate could fail with F_JD024D duplicate row errors when the Resilient parameter was enabled and multiple target rows had the same key. [RD-1172122] FIXED F_JD20D7 ERROR ON ADAPTDDL DROP COLUMN To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where the integrate job could throw error F_JD20D7 when processing an AdaptDDL drop column control on a table containing date values beyond the year 2038. This fix ensures that such date values are handled correctly during AdaptDDL processing, preventing unexpected job termination. [RD-1174382] FIXED NEGATIVE DURATION IN PER-TABLE SYNC LOG To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where the per-table sync log reported a negative duration after a TRUNCATE operation. Because TRUNCATE operations are not included in the changes_total count, the duration calculation could result in a division by zero. This fix adds a safeguard to prevent division by zero, ensuring that duration values are calculated correctly and reported accurately in the sync log. [RD-1179709] SAP HANA: FIXED F_JZ0A02 DURING CAPTURE REWIND To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where SAP HANA capture rewind could fail when sequence header information occurred exactly at a log block boundary, resulting in error F_JZ0A02. [RD-1179440] SYBASE ASE: FIXED LOGINFO() MINIMAL PERMISSIONS CAPTURE FAILURE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where capture could fail with F_JD02A5 when loginfo() was called directly instead of through the minimal permissions model. This fix improves support for DBMS stored procedures that use loginfo() under minimal-permissions configurations. NEW FEATURES IN HVR 6.2.0/36 (2026-03-17) ---------------------------------------- [RD-1157017] ADDED DECRYPTED CHECKPOINT LOGGING FOR CAPTURE DIAGNOSTICS To use this feature, upgrade HVR on the capture machine(s). Added optional trace logging that outputs the decrypted capture checkpoint JSON when preparing checkpoints at trace level 1. This helps you diagnose long-running transactions by showing the exact checkpoint context, such as scan start position, transaction state, and table details. No setup changes are required. Checkpoint files remain encrypted; only the trace log output is expanded. [RD-1165320] ADDED REMOTE AGENT PID LOGGING FOR CAPTURE JOBS To use this feature, upgrade HVR on the hub machine(s). Added a log message that reports the remote agent process PID when a capture job runs on a remote agent. This complements the existing hub-side "Job started (pid=XXXX)." message and helps you troubleshoot and monitor remote capture processes more easily. [RD-1170378] ADDED GUIDANCE FOR NON-UNIQUE REPLICATION KEYS To use this feature, upgrade HVR on the integrate machine(s). This improvement adds clearer guidance to coalesce strict errors and trace warnings when same-operation row pairs differ only by transaction sequence. The message now suggests that the replication key may not be unique. When this guidance appears, validate that the replication key matches a primary key or unique index. If you update the replication key, refresh the affected table to ensure replication uses the corrected key. [RD-1176954] DB2 FOR Z/OS: ADDED CONFIGURABLE LOCKING HINT FOR SELECT STATEMENTS To use this feature, upgrade HVR on the capture machine(s). Added a configurable "read committed" locking hint for Db2 for z/OS and Db2 for LUW SELECT statement generation. By default, Db2 for z/OS and Db2 for LUW SELECTs now include the WITH CS locking hint. You can override the default by setting HVR_SQL_LOCK_HINT_RCOM to the desired clause (for example, HVR_SQL_LOCK_HINT_RCOM="WITH UR" or HVR_SQL_LOCK_HINT_RCOM="FOR READ ONLY WITH CS"). [RD-1171507] KAFKA: ADDED READ-ONLY SCHEMA REGISTRY SCHEMA LOOKUP To use this feature, upgrade HVR on the integrate machine(s). Added support for Kafka Integrate to work with a read-only Confluent Schema Registry by allowing you to disable automatic schema registration and instead look up pre-registered schemas. Control this behavior with the HVR_KAFKA_AUTO_REGISTRY_SCHEMAS environment variable (enabled by default: HVR_KAFKA_AUTO_REGISTRY_SCHEMAS=1). When set to disable auto-registration (HVR_KAFKA_AUTO_REGISTRY_SCHEMAS=0), HVR retrieves the schema ID from the registry and, if the required schema is missing, returns a dedicated 404 error that includes a suggested curl command to register the schema manually. PROBLEMS FIXED IN HVR 6.2.0/36 (2026-03-17) ---------------------------------------- [RD-1146148] FIXED CAPTURE HANDLING OF DDL VERSION MISMATCHES To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where TRUNCATE DDL could leave capture metadata out of sync with redo, leading to version mismatch errors and failures. Capture now refreshes metadata more reliably after DDL reducing the risk of unexpected stops. [RD-1165551] FIXED ALERTS JOB ERROR DURING LOG ROTATION To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where the Alerts job could report F_JX0011 ("Information from offset file did not match any logfile. Data may be lost") when it started while hub log rotation was running. Although no data was lost and the next Alerts run would continue normally, the message was confusing. The Alerts job now detects an in-progress log rotation and skips the run to avoid the misleading error. [RD-1167877] FIXED STALE DISPLAY OF STATISTICS METRICS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where the UI displayed outdated "Changes Queued" metrics when the Statistics job lagged behind repository updates under high Hub load, especially with many router files on Windows NTFS file systems. This fix ensures that Deactivate immediately resets Capture and Integrate Router metrics in the repository when related transaction files are deleted. Similarly, Activate with the "Capture Time and Transaction Files" option now resets Capture Router metrics directly. As a result, the UI reflects cleared metrics immediately without waiting for the statistics job to complete. [RD-1169505] FIXED INTEGRATE CRASH WITH STALE CONTROL FILE To fix this bug, upgrade HVR on the integrate and hub machine(s). Fixed an issue where Integrate could crash if a restarted run reused a stale control file that referenced a missing column not present in the current table metadata (for example, after a previous integration failure). Integrate now handles missing column information safely to prevent a termination during startup or processing. [RD-1173864] FIXED WHITESPACE TRIMMING FOR LONG VARCHAR, CLOB AND VARCHAR(MAX) To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where whitespace was not trimmed from clobs. HVR action TableProperties with the TrimWhiteSpace parameter now also applies to LONG VARCHAR, CLOB and VARCHAR(MAX). [RD-1174392] REDUCED MEMORY ALLOCATION OVERHEAD IN PER-COLUMN CHECKSUM COMPUTATION To fix this bug, upgrade HVR on the integrate machine(s). Improved integrate performance for MAR with re-sync detection, especially for wide tables with many non-key columns. Reduced memory allocation overhead during per-column checksum computation, resulting in lower CPU usage and higher throughput during replication. RD-1157585 RD-1062642 [RD-658553] IMPROVED SNAPSHOT ZIP ERROR MESSAGES To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where snapshot zip and unzip errors did not include the affected file path or filename. Error details now include the specific path or name, so you can quickly identify which file caused the failure during snapshot archive creation or extraction. [RD-1169078] DB2 FOR I: FIXED REPLICATION KEY FOR TABLES WITH INDEXES WITH RENAMED COLUMNS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where HVR could choose the wrong replication key for a Db2 for i table when the table had an index with renamed columns. HVR now maps index key columns back to the underlying table columns using system identifiers, so the correct replication key is selected. For this, HVR started using Db2 for i system catalogs QSYS.QADBILFI, QSYS.QADBLDEP, QSYS.QADBKATR, QSYS.QADBXATR and requires SELECT privilege on those system catalogs. According to IBM documentation, the tables and views in the catalogs are shipped with the SELECT privilege to PUBLIC. This privilege may be revoked and the SELECT privilege granted to individual users. [RD-1168627] ORACLE: FIXED F_JZ1157 ERROR IN LOG-BASED CAPTURE ROW CHAINING PROCESSING To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where Oracle log-based capture could fail with an F_JZ1157 error while assembling composite column values during certain row chaining sequences. [RD-1158675] POSTGRESQL: FIXED IDLE IN TRANSACTION STATE DURING CAPTURE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where PostgreSQL capture could leave a database connection in an "idle in transaction" state after scan initialization. This could block vacuum operations on PostgreSQL system catalog tables and lead to maintenance delays. NEW FEATURES IN HVR 6.2.0/35 (2026-03-03) ---------------------------------------- [RD-1077878] RESTRICTED HUB USER AND PERMISSION VISIBILITY To use this feature, upgrade HVR on the hub machine(s). Hub user and hub-level permission visibility is now restricted based on access control. A new role, ViewFullUserList, controls whether a user can view the full list of hub users and permissions. By default, users without this role will no longer see full user/permission lists, and API responses are filtered to avoid returning user and permission details they are not allowed to view. System admins can still view hub users and permissions. To restore the previous behavior, grant ViewFullUserList to the relevant users. [RD-1058636] DATABRICKS: ENABLED IDEMPOTENCY FOR BURST TABLE LOADS To use this feature, upgrade HVR on the integrate machine(s). The SQL used to load data into a table in Databricks has been updated to enable idempotency. This change affects only burst table loading. If needed, you can revert to the previous behavior by setting HVR_DATABRICKS_COPY_INTO_FORCE=1. [RD-1147991] ORACLE: ENHANCED ARCHIVE LOG CORRUPTION DIAGNOSTICS To use this feature, upgrade HVR on the capture machine(s). This improvement adds a targeted warning when capture encounters corrupted archive or redo logs. The warning includes the affected file name and the related error code, along with guidance to help you restore or replace the file or re-activate capture. [RD-1167611] ORACLE: ADDED VARNUM BYTE DUMP TO INVALID NUMBER ERRORS To use this feature, upgrade HVR on the capture machine(s). This improvement adds additional diagnostic context when Oracle NUMBER (VARNUM) decoding fails due to an illegal byte. The conversion error message now includes the raw VARNUM byte sequence (Typ=2 Len=: ,,...) to help you identify malformed source values and troubleshoot failures faster. PROBLEMS FIXED IN HVR 6.2.0/35 (2026-03-03) ---------------------------------------- [RD-1148859] FIXED OPEN TRANSACTIONS DURING HUB CONNECTION CHECKS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where, when your hub repository is on SQL Server and you use ODBC driver version 17.6 or later, the hub could leave an uncommitted transaction open during connection initialization. [RD-1148959] FIXED A BUG WITH MULTIPLE REFRESH CONTEXTS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where the refresh operation did not correctly apply multiple target contexts when you specified more than one context (for example, in the Refresh Data dialog or with the hvrrefresh -C option). Only the last context in the list was honored. After this fix, the refresh operation evaluates the full set of contexts you provide. Actions scoped to any of the supplied contexts (such as Restrict, ColumnProperties, or AgentPlugin actions) are now applied during the same refresh run. [RD-1149673] FIXED FILE ACCESS ERRORS DURING INTEGRATE ON WINDOWS NETWORK STORAGE To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where integrate jobs on Windows SMB/DFS network storage could fail with F_JG20D3 ("Access is denied") while processing files that were being deleted. HVR now retries file status checks when Windows temporarily reports access denied during a pending deletion and treats the file as deleted once the deletion completes. [RD-1152156] FIXED F_JD2E02 DURING STRING COERCION ACROSS ENCODINGS To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where refresh or integrate could fail with F_JD2E02 when coercing between string types that use different encodings. This could occur when UTF-16-encoded data (for example, ASCII characters stored as UTF-16) was validated by byte length and incorrectly rejected when converting into a UTF-8 target column, even though the value fits by character length. The coercion length check now accounts for the source encoding so the conversion can proceed without error. [RD-1157326] FIXED OLD TIMESTAMP PARSING IN HVRSTATISTICS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where hvrstatistics could fail with "Month 'X' out of range 0..11" when parsing log files that use the old timestamp format (Mon DD HH:MI:SS). The timestamp fields are now mapped correctly during epoch conversion, preventing invalid month values. This fix also adds year inference for old-format timestamps that do not include a year. [RD-1164230] FIXED CAP_STATE ERROR MESSAGE PATH FORMAT To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where error messages referenced an outdated HVR 5 cap_state file path format. These messages now report the correct HVR 6 path. [RD-1165594] IMPROVED MAR WITH RE-SYNC DETECTION PERFORMANCE To fix this bug, upgrade HVR on the integrate machine(s). Improved MAR with re-sync detection performance by avoiding unnecessary per-column hashing for rows that are excluded from the change data sample. This reduces CPU overhead and increases throughput during high-volume replication, especially for wide tables with many non-key columns. RD-1157585 [RD-1168478] FIXED F_JD024D AFTER RENAMING TARGET KEY COLUMN To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where an integrate cycle could fail with F_JD024D due to an "invalid identifier" error when a key column had been renamed on the target database. This occurred when HVR ran an initial cleanup delete at the start of the first integrate cycle after a refresh; the delete query now uses the correct burst table column name. [RD-1156330] DB2 FOR Z/OS: FIXED 0C4 FAILURE IN THE HVRCAPLG STORED PROCEDURE ON Z/OS 3.1 AND 3.2 To fix this bug, upgrade HVR's stored procedures on the DB2 for z/OS capture machine(s). Fixed an intermittent 0C4 memory access violation that could occur when running the HVRCAPLG capture stored procedure on z/OS 3.1 and 3.2. [RD-1161092] ORACLE: FIXED MODULO SLICING FOR NON-FINITE FLOAT VALUES To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where refresh and compare modulo slicing on Oracle float columns could miss rows containing NaN or plus/minus Infinity values. HVR now handles non-finite float values consistently during slicing so these rows are included in the correct slice. [RD-1169732] POSTGRESQL: FIXED CAPTURE CYCLE NOT ENDING ON IDLE CHANNELS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where the PostgreSQL Logical Replication (SQL) capture job would never end a capture cycle when using Streaming Replication Protocol (where `HVR_PQ_STREAMING_REPLICATION_RESTART_AT_END_OF_WAL` is set as `0`) on an idle channel. The capture job kept processing keepalive messages as real data records, preventing the cycle from completing. This fix ensures keepalive messages that advance the LSN position do not count as captured records, allowing empty capture cycles to end properly. NEW FEATURES IN HVR 6.2.0/34 (2026-02-17) ---------------------------------------- [RD-1164668] BUNDLED FIVETRAN PROXY 1.1.8 To use this feature, upgrade HVR on the agent machine(s). Upgraded bundled Fivetran Proxy to 1.1.8. [RD-1054124] ORACLE: ADDED LOGGING FOR MISSING ARCHIVES To use this feature, upgrade HVR on the capture machine(s). This improvement adds detection and reporting for missing archive logs when using an Archive-Log-Only source location. When HVR identifies gaps in the expected archive sequence, it now provides clear, user-facing log messages to help you identify and resolve missing archives more quickly. PROBLEMS FIXED IN HVR 6.2.0/34 (2026-02-17) ---------------------------------------- [RD-1065905] FIXED TIMEKEY COALESCE ORDERING ERRORS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue in TimeKey Integrate mode where coalesce processing could order rows incorrectly and trigger F_JT0527 errors. When the TimeKey uses hvr_integ_tstamp, rows are now sorted by the key columns, then hvr_integ_tstamp, then hvr_integ_seq to ensure consistent ordering during coalesce in both Integrate and Refresh. [RD-1080151] FIXED F_JG2142 ERROR WITH TIMEKEY TABLES WITHOUT KEYS To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where error F_JG2142 could occur during integration when replicating a table without an explicit key and one or more target columns with the TimeKey parameter. The replication logic incorrectly treated the TimeKey columns as explicit key columns when determining the replication key format. This fix ensures that only explicitly defined key columns are used for replication key determination, while TimeKey columns are handled correctly. This prevents the error when integrating tables without keys that rely on the TimeKey columns to preserve row history. [RD-1155984] FIXED F_JD5E13 FOR BINARY-TO-STRING LOCALIZATION WHEN USING INTEGRATEEXPRESSION To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where IntegrateExpression could fail with F_JD5E13 when localizing a binary datatype to a string datatype. This could occur, for example, when an IntegrateExpression uses a BLOB value that is mapped to a CLOB by default on targets such as Amazon Redshift. [RD-1163119] FIXED MEMORY CORRUPTION CAUSED BY TIME PROFILER To fix this bug, upgrade HVR on the integrate, capture and hub machine(s). Fixed an issue where enabling the time profiler via the HVR_TIME_PROFILER_TRACE environment variable could cause memory corruption, leading to segmentation faults and application crashes during job execution. This fix ensures proper memory initialization in the time profiler, providing stable performance analysis capabilities. [RD-1149675] AZURE DATA LAKE STORAGE: FIXED PROXY USAGE WHEN HVR_URL_PROXY_DISABLE IS ENABLED To fix this bug, upgrade HVR on the hub machine(s). Updated HVR Azure (ADLS) to honor HVR_URL_PROXY_DISABLE=1 by disabling proxy settings for Azure connections. [RD-1061941] DB2 FOR LINUX, UNIX AND WINDOWS: HANDLE F_JD2528 ON DB2READLOG CALL TO ALLOW REWIND To fix this bug, upgrade HVR on the capture machine(s). Customer is getting F_JD2528 on rewind when activating in db2 LUW environment where the logs have been purged. Handle the exception to allow HVR to find the correct start location in the transaction logs. [RD-1080389] ORACLE: FIXED ACTIVATION FAILURES WITH ASM FILE-GROUP TEMPLATES To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where channel activation could fail when Oracle Database DB_RECOVERY_FILE_DEST was configured with an ASM file-group template suffix (for example, +RECO(FG$...)), which could trigger error F_JD2287. HVR now correctly handles these recovery destinations to prevent activation failures. [RD-1006932] POSTGRESQL: FIXED NON-DETERMINISTIC SORTING OF TIMEKEY SEQUENCE COLUMN To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where PostgreSQL integrate could experience non-deterministic sorting behavior for TimeKey sequence columns. This fix ensures that TimeKey sequence columns are created with COLLATE "C" to guarantee deterministic byte-order sorting, which is essential for proper sequence ordering and data consistency during replication. [RD-1072396] SAP HANA: FIXED F_JZ0A4E ERROR IN ARCHIVE_ONLY CAPTURE MODE To fix this bug, upgrade HVR on the capture machine(s). Fixed F_JZ0A4E error in ARCHIVE_ONLY capture mode where backup lookup incorrectly checked the primary backup location before the alternate archive location. The primary location is now skipped in ARCHIVE_ONLY mode, preventing W_JZ3401 warnings and F_JZ0A4E errors when log files have been moved to the archive directory. [RD-1164053] SAP HANA: FIXED F_JZ0A36 FOR SHORT CHAR COLUMNS ON SAP HANA SP08 To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where capture on SAP HANA 2.0 SP08 and later could fail with F_JZ0A36 while processing CHAR-based columns with defined lengths under 256 characters. [RD-1157021] SQL SERVER: FIXED BACKWARD COMPATIBILITY ISSUE WITH TDE ENCRYPTION To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where SQL Server capture could fail when a newer agent (6.1.0/94+, 6.2.0/32+, 6.3.0/1+) connected to an older hub after TDE support was introduced. The capture now only uses the TDE-related hub call on hub versions that support it, preventing failures when you upgrade the agent but keep the hub unchanged. This affects environments using encrypted backups and/or TDE. [RD-1156155] UI: FIXED TEST CONNECTION FAILING WITH SSH KEYS VIA ENVIRONMENT ACTION To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where testing location connections from the UI failed with SSH authentication errors when SSH keys were configured via channel Environment actions. The UI now passes channel context to the test connection API when available, allowing SSH keys from Environment actions to be retrieved correctly. This fix addresses the most common test connection scenarios when channel context is available. RD-969820, RD-1068019 NEW FEATURES IN HVR 6.2.0/33 (2026-02-03) ---------------------------------------- [RD-1149277] SQL SERVER: ADDED SUPPORT FOR AZURE BLOB STORAGE BACKUPS FOR SQL ACCESS To use this feature, upgrade HVR on the capture machine(s). Added support for reading transaction log backups stored in Azure Blob Storage when using SQL Access capture mode. Previously, SQL Access could read transaction log backups only from local disk (DISK) backups. PROBLEMS FIXED IN HVR 6.2.0/33 (2026-02-03) ---------------------------------------- [RD-1145917] FIXED DUPLICATE COLUMN ERROR DURING UPSERT REFRESH To fix this bug, upgrade HVR on the integrate and hub machine(s). Fixed an issue where creating the __rb table during an upsert refresh would fail with a duplicate column error if the hvr_op column already existed in the base table. [RD-1156485] FIXED F_JG200A SEGMENTATION VIOLATION DURING HVRLICENSE RUN To fix this bug, upgrade HVR on the hub machine(s). Fixed an F_JG200A internal error (segmentation violation) that could occur when running hvrlicense during metering data compaction. The hvrlicense command now handles missing metering signature data safely, preventing the crash. [RD-1150686] DB2 FOR Z/OS: FIXED COMPARE DIFFERENCES FROM ADDED XML DECLARATIONS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where XML declarations were added to XML values selected from DB2 for z/OS, which could cause unnecessary compare differences. HVR now disables XML declarations in the DB2 for z/OS ODBC connection, so the selected XML values match the source data. [RD-1060743] MARIADB: FIXED HANDLING OF NULL DEFAULT VALUES IN MARIADB To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where columns with a default value of `NULL` in MariaDB were not correctly recognized. This fix ensures accurate detection of `NULL` defaults during metadata processing. [RD-1144540] ORACLE: FIXED F_JZ197C ERROR DURING POSITIONING ON RAC IN ARCHIVE LOG ONLY MODE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where Capture could fail with error F_JZ197C while positioning on Oracle RAC systems running in Archive Log Only mode if Capture started immediately after activation and the required archive logs had not yet been copied to the configured archive log directory. Capture now waits and retries until the archive logs become available instead of terminating with a fatal error. [RD-1152535] ORACLE: REMOVED INCORRECT _HVR SUFFIX FROM ARCHIVED LOG DIRECTORY LOOKUP To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where HVR would incorrectly append a _hvr suffix to the archived log directory path shown in error messages, creating confusion. This non-existent directory appeared in positioning error messages even though it did not exist on the server. If you need to specify an alternative release directory, use the HVR_LOG_RELEASE_DIR environment variable. RD-1148204 [RD-1153145] ORACLE: FIXED NETWEAVER ON ORACLE 11G METADATA QUERY FAILURE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where activation or metadata retrieval could fail for NetWeaver sources on Oracle 11g when invisible columns were enabled. HVR no longer queries the USER_GENERATED column on Oracle versions earlier than 12c, preventing these failures. If you previously encountered this issue, upgrade and re-activate your channel. [RD-1070500] SQL SERVER: FIXED LONG-RUNNING UNCOMMITTED TRANSACTIONS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where connections to SQL Server over ODBC could leave transactions open, resulting in long-running uncommitted transactions when SQL Server was used as a source database. The fix ensures transactions are properly closed to prevent unnecessary locking and resource consumption. If you continue to observe open transactions after upgrading, it is recommended to use Microsoft ODBC Driver 17.6 or later for SQL Server. [RD-1147220] SQL SERVER: FIXED F_JD0A98 FOR TDE WITH OPTIMIZED COMPRESSION To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where SQL Server capture would fail with F_JD0A98 when using Transparent Data Encryption (TDE) with Optimized Compression. [RD-1051215] SYBASE ASE: FIXED DIRECT CAPTURE UPDATE-BEFORE RECORD HANDLING To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where Sybase ASE Direct Capture could fail while processing UPDATE-BEFORE transaction log records. This fix ensures that the replication process now correctly handles this scenario. [RD-1147355] SYBASE ASE: FIXED INCOMPLETE FIX FOR DIRECT CAPTURE LOG TRUNCATION STALL To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where the transaction log truncation point could still get stuck in Sybase ASE Direct Capture mode, even after the earlier fix for RD-1042818. This could prevent expected log truncation and lead to log growth. When this issue occurred, trace output included messages similar to: $HVR_SQL_TRACE=1[dbzread]: Transaction log truncation request is skipped due to pending results upon connection. This fix ensures the capture process clears the pending results state when results complete normally (CS_END_RESULTS) during cursor close operations. No action is required after upgrading. [RD-1149018] SYBASE ASE: FIXED DIRECT CAPTURE PARTITION ID HANDLING To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue in ASE Direct capture where partition IDs were being mishandled, leading to incorrect data replication for partitioned tables. This fix ensures that partition IDs are correctly processed during data capture, improving the accuracy and reliability of data replication for partitioned tables in ASE databases. To deploy this fix in a new Channel, simply install the upgrade with this fix before creating a channel. For existing channels, install the upgrade with this fix, then re-activate the channel selecting Table Enrollment and Replace All Old Enrollment. NEW FEATURES IN HVR 6.2.0/32 (2026-01-20) ---------------------------------------- [RD-1144750] ADDED SUPPORT FOR WINDOWS SERVER 2025 To use this feature, upgrade HVR on all machine(s). This new feature enables HVR deployment on Windows Server 2025, allowing customers to run hub, capture, and integrate components on the latest Windows Server operating system with modern infrastructure and security features. [RD-805801] SQL SERVER: INTRODUCED ROLE NAME FOR CDC TABLES CREATED WHEN ENABLING SUPPLEMENTAL LOGGING To use this feature, upgrade HVR on the capture and hub machine(s). Added a new location property, SqlServer_Role_Name, to control and restrict access to database objects created during enabling supplemental logging with CDC tables. This enhancement ensures that only authorized users can access these objects. If the property is not set, a NULL value is assumed and passed to maintain compatibility. This feature replaces the previous environment variable HVR_MSSQL_CDC_ENABLE_ROLENAME, which will remain supported temporarily for backward compatibility. [RD-985304] SNOWFLAKE: IMPLEMENTED SUPPORT FOR 128MB VARCHAR AND 64MB BINARY DATATYPES To use this feature, upgrade HVR on the integrate and hub machine(s). Implemented support for 128MB varchar datatype and 64MB binary datatype. This is only supported for ODBC versions >= 3.6.0. Support for this is turned off by default, but can be turned on by setting these variables: - `HVR_SNOWFLAKE_VARCHAR_128MB_SUPPORTED` enables varchar datatype to go up to 128MB. 0 (off), 1 (on) - `HVR_SNOWFLAKE_BINARY_64MB_SUPPORTED` enables binary datatype to go up to 64MB. 0 (off), 1 (on) PROBLEMS FIXED IN HVR 6.2.0/32 (2026-01-20) ---------------------------------------- [RD-1037413] FIXED UNNECESSARY ALTER TABLE DURING COLUMN RECREATION To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where a refresh with column recreation triggered an unnecessary `ALTER TABLE` operation on existing SQL Server tables. This occurred due to a mismatch in column encoding metadata. The fix ensures that if the target table already exists, its column metadata is used to avoid redundant schema changes. [RD-1039666] CREATE BURST JOURNAL TABLES BEFORE INTEGRATION STARTS To fix this bug, upgrade HVR on the integrate machine(s). Fixed a bug where burst journal tables were created during the integrate cycle. Issuing DDL at this stage triggers a commit of current changes, which could interfere with HVR's recovery logic. Burst journal tables are now created before the integrate cycle begins to avoid unexpected commits and ensure reliable recovery. [RD-1080548] FIXED TEST CONNECTION FOR READ-ONLY USERS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where you could not test a connection as a read-only user after location properties were changed but not yet cached. This resulted in an error stating the user was missing write permissions. The test connection now works correctly for readonly users regardless of cache state. [RD-1080582] REDUCED MAXIMUM MEMORY USAGE IN HVRLICENSE To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where hvrlicense consumed excessive memory when processing large MAR files. This fix ensures memory is released promptly after operations complete, reducing overall memory usage significantly. [RD-946152] DB2 FOR LINUX, UNIX AND WINDOWS: FIXED F_JZ320A ERROR FOR DB2 LUW To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where HVR would throw an F_JZ320A error when processing Db2 LUW transaction logs which contain unexpected order of the transaction records. This fix ensures proper handling of partial rollback operations for column fragments. [RD-1061944] DB2 FOR I: FIXED F_JR0557 REFRESH FAILURE FOR DATALINK COLUMNS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where refreshing Db2 for i tables with DATALINK columns could fail with error F_JR0557 because the system catalog reported a CCSID value of 0. HVR now retrieves CCSID values from the appropriate catalog by default and uses the legacy catalog only as a fallback when needed. [RD-1061595] ORACLE: FIXED F_JG200A CRASH DURING ORACLE LOG MINING ERROR HANDLING To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where HVR Capture could crash with F_JG200A SIGSEGV when handling Oracle log mining errors in specific transaction group enrollment scenarios. This fix improves robustness in error handling to prevent the segmentation fault and allows replication to continue without interruption. [RD-1067558] ORACLE: FIXED CLOB COLUMN IS SET NULL ON A TARGET WHEN A SOFT DELETE OCCURS To fix this bug, upgrade HVR on the capture machine(s). If one or more last columns in a table are nullable then Oracle can skip them in redo records for rows updates and deletes. There was the logic in jtscan (see JTxScanRow()) which set missed columns to null. That was done for deletes only and was done incorreclty because the order of columns in an enroll and in the table itself can be different. Furthermore, it was done for ALL nullable missed columns instead of last ones. The logic has been transferred into zizzy oracle parser and applied for deleting and for updating rows. Any lobs columns in a delete are removed and marked as missed. But it is done AFTER generating nullable columns. This, in turn, will lead to preserving a lob in soft deletes on a target. [RD-1074471] ORACLE: FIXED DELETE STATEMENTS UPPERCASING COLUMN NAMES WITH CASE_SENSITIVE_NAMES ENABLED To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where DELETE statements with NULL key columns incorrectly uppercased column names when you set Case_Sensitive_Names location property for CDB/PDB locations, causing ORA-00904 errors. This fix ensures DELETE statements properly respect Case_Sensitive_Names setting. [RD-1144360] POSTGRESQL: FIXED MISSING SCHEMA NAMES IN TABLE EXPLORER To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where user-defined schema names starting with "pg" were missing in the Table Explorer. This fix ensures all user-defined schemas are now properly displayed. [RD-1144650] POSTGRESQL: FIXED F_JD2232 ERROR CAUSED BY NULL VALUES IN COLUMNS REFERENCED BY SQL EXPRESSIONS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where updating or deleting a row could result in the F_JD2232 error when a CaptureCondition with SQL expressions was defined in Restrict and a column referenced in the SQL expression contained a NULL value. This issue only affected the Logical Replication (SQL) capture method using the test_decoding plugin and has now been resolved. [RD-1009104] SQL SERVER: FIXED COLUMN COLLATION HANDLING To fix this bug, upgrade HVR on the integrate and capture machine(s). Fixed an issue where SQL Server per-column collation settings were ignored and the database-level collation was applied instead. HVR now correctly respects and applies the collation defined on each column during capture and integration. [RD-1065746] SQL SERVER: FIXED ISSUE WITH SQL SERVER 2025 TDE CAPTURE To fix this bug, upgrade HVR on the capture and hub machine(s). Fixed an issue that prevented TDE capture from working with SQL Server 2025. The new SQL Server release introduced a backup encryption format that was not previously supported. The fix updates the capture process to correctly handle both legacy PKCS1 padding and the new OAEP padding, and to recognize the new DEK encryption type. With these changes, TDE-encrypted backup data from SQL Server 2025 can now be decrypted and captured reliably. [RD-1075793] SQL SERVER: FIXED ACCESS TOKEN CONNECTION USING CUSTOM AZURE ENDPOINT To fix this bug, upgrade HVR on the integrate, capture and hub machine(s). Fixed an issue where HVR would fail to connect to an Azure SQL Server instance using an access token when a custom endpoint URL was specified. Previously, only URLs matching "*.database.windows.net" were supported, causing connections to fail for other valid Azure SQL endpoints. NEW FEATURES IN HVR 6.2.0/31 (2026-01-06) ---------------------------------------- [RD-1041538] IMPROVED PERFORMANCE OF NUMERIC-TO-STRING CONVERSION To use this feature, upgrade HVR on all machine(s). This update improves several internal routines for converting integers to strings, resulting in average performance gains of 45-60%, with some operations it can be faster depending on the input data. These improvements may benefit performance in areas that involve frequent numeric formatting, such as diagnostics, statistics output, or logging. [RD-1071442] BUNDLED FIVETRAN PROXY 1.1.5 To use this feature, upgrade HVR on the agent machine(s). Upgraded bundled Fivetran Proxy to 1.1.5. [RD-1076988] BUNDLED FIVETRAN PROXY AGENT VERSION 1.1.6 To use this feature, upgrade HVR on the agent machine(s). This update includes version 1.1.6 of the Fivetran Proxy Agent in the HVR installation package. [RD-889156] DB2 FOR I: ADDED A DROP-DOWN TO SHOW JOURNALS To use this feature, upgrade HVR on the capture and hub machine(s). Added a JOURNAL drop-down for DB2 for i locations to display journals required for configuration. [RD-1070778] SQL SERVER: ADDED LOCATION PROPERTY FOR MULTISUBNETFAILOVER To use this feature, upgrade HVR on the hub machine(s). This new feature enables you to configure SQL Server's MultiSubnetFailover connection setting directly through the location property. This change replaces the previous use of an environment variable and provides a more explicit configuration option. PROBLEMS FIXED IN HVR 6.2.0/31 (2026-01-06) ---------------------------------------- [RD-1051083] FIXED BURST TABLE ISSUE WHEN SWITCHING BETWEEN BURST AND CONTINUOUS INTEGRATE MODES To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where burst tables were not properly truncated when switching between Burst and Continuous integrate modes. This could cause duplicate key violations during subsequent Burst integrates. [RD-1061123] FIXED COALESCE HANDLING OF DUPLICATE TRANSACTION SEQUENCES To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where the coalesce pipe mishandled duplicate rows with the same `hvr_tx_seq`. You can now enable the `HVR_COALESCE_KEEP_LOWEST_TX_COUNTDOWN` environment variable to retain only the row with the lowest `hvr_tx_countdown`, allowing replication to proceed without manual intervention. [RD-1064733] FIXED RESOURCE INTENSIVE ALERTS JOB BEHAVIOR To fix this bug, upgrade HVR on all machine(s). Fixed an issue where the alerts job searched months of archived log files when looking for alert headlines causing latency in other HVR jobs. The alerts job now searches at most the last 10 days of archived log files. You can override this limit using the environment variable HVR_ALERT_ARCHIVE_SEARCH_DAYS. [RD-1065993] IMPROVED PERFORMANCE FOR TIMESTAMP CONVERSIONS INVOLVING TIMEZONES To fix this bug, upgrade HVR on the integrate machine(s). Added an optimization that improves the performance of timestamp conversions during refresh and integrate operations when timezones are involved. The change streamlines how Daylight Saving Time transitions are handled by skipping DST checks for timestamps that fall outside transition periods. [RD-1076064] ADDED WARNING FOR ADAPTDDL KEEPOLDROWS WITHOUT ROW-BY-ROW GRANULARITY To fix this bug, upgrade HVR on the hub machine(s). Added a validation check that shows a warning during channel activation when an AdaptDDL action is configured with KeepOldRows but the RefreshOptions parameter does not use row-by-row granularity. This improvement helps you detect misconfigurations at activation time so you can correct them before running a refresh. [RD-1077050] DB2 FOR LINUX, UNIX AND WINDOWS: FIXED DEFAULT DEGREE OF PARALLELISM FOR SELECT STATEMENTS To fix this bug, upgrade HVR on the capture and hub machine(s). Fixed an issue where Db2 for Linux, Unix & Windows did not automatically use the maximum degree of parallelism for SELECT statements. HVR now sets the current degree to ANY, improving the performance of operations such as HVR Refresh and HVR Compare. Note that HVR will only set the maximum degree of parallelism when it has the privileges to do so. [RD-1072412] DB2 FOR I: FIXED HVRSTATISTICS IGNORING DB2 FOR I SCANNED MESSAGE To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where hvrstatistics incorrectly flagged certain Db2 for i trace output as irregular messages. [RD-1076969] DB2 FOR I: FIXED DEFAULT DEGREE OF PARALLELISM FOR SELECT STATEMENTS To fix this bug, upgrade HVR on the capture and hub machine(s). Fixed an issue where Db2 for i did not automatically use the maximum degree of parallelism for SELECT statements. HVR now sets the current degree to MAX, improving the performance of operations such as HVR Refresh and HVR Compare. Note that HVR will only set the maximum degree of parallelism when it has the privileges to do so. [RD-889153] DB2 FOR I: FIXED SCHEMA DROP-DOWN TO SHOW INTERNAL JOURNAL SCHEMAS To fix this bug, upgrade HVR on the capture and hub machine(s). Fixed an issue where the SCHEMA drop-down for DB2 for i locations displayed external journal schemas instead of the internal journal schemas required for configuration. [RD-1075432] DB2 FOR Z/OS: FIXED DEFAULT DEGREE OF PARALLELISM FOR SELECT STATEMENTS To fix this bug, upgrade HVR on the capture and hub machine(s). Fixed an issue where Db2 for z/OS version 12 and higher did not automatically use the maximum degree of parallelism for SELECT statements. HVR now sets the current degree to ANY, improving the performance of operations such as HVR Refresh and HVR Compare. [RD-1054202] ORACLE: FIXED MEMORY LEAK WITH XMLTYPE CAPTURE USING GETCLOBVAL To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where Oracle capture jobs using CaptureExpression with xmltype.getClobVal() on XMLType columns experienced progressive memory growth. This memory leak occurred because temporary CLOBs created by Oracle's getClobVal() function were not being released during the capture process, eventually leading to ORA-04030: out of process memory errors. The fix ensures proper cleanup of temporary LOBs to prevent uncontrolled memory usage. [RD-1064616] ORACLE: FIXED F_JZ1156 ERROR IN LOG-BASED CAPTURE CHAINROW PROCESSING To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where log-based capture failed with an F_JZ1156 error while constructing composite column data during a specific sequence of chainrow operations. [RD-1075307] POSTGRESQL: FIXED WAL RELEASE HANDLING IN IDLE CHANNELS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue that prevented the PostgreSQL capture job from advancing the replication slot position in idle channels. HVR incorrectly ignored keepalive messages from the PostgreSQL server when their timestamps were not later than previously captured changes, blocking WAL archival. This fix ensures keepalive messages are processed by incrementing their timestamps internally, allowing the replication slot to advance and enabling timely WAL release. [RD-1067145] SNOWFLAKE: FIXED INCORRECT HANDLING OF TRANSACTIONAL TRUNCATE To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where HVR incorrectly treated Snowflake's TRUNCATE operation as an implicit commit. Snowflake executes TRUNCATE fully within the current transaction, so HVR no longer forces an unnecessary commit before issuing the statement. This improves transactional consistency when integrating changes into Snowflake. [RD-1046551] SYBASE ASE: FIXED ERROR HANDLING FOR BULK LOAD FAILURES To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where certain Sybase ASE bulk load failures were not detected, which could lead to misleading follow-up errors such as: "Cannot call API blk_done(CS_BLK_BATCH) from this state: initialized". Due to a known Sybase issue (SAP CR 783571), some bulk load failures may occur without triggering the normal error callback. To improve troubleshooting, the system now records enhanced diagnostic information when a bulk load operation fails, including table name, row number, return status, and column-level details (name, datatype, maxlen, actlen, indicator, and hex dump of the column data). A new error message F_JD1D00_BULK_ROWXFER_FAILED has been added to present this information more clearly and help identify data-specific issues that cause bulk load failures. [RD-1071941] SYBASE ASE: FIXED SEGMENTATION FAULT IN ASE DIRECT CAPTURE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue that caused a segmentation fault when using the Direct Capture method in Sybase ASE under certain conditions. This issue could result in the unexpected termination of the HVR process during data capture operations. [RD-1072075] SYBASE ASE: FIXED FALSE POSITIVE TABLE DROP DETECTION IN SYBASE ASE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where internal Sybase ASE operations (such as database upgrades, `REORG`, or partition drops) were incorrectly interpreted as `DROP TABLE` DDL statements. This resulted in unnecessary table refreshes on the target. NEW FEATURES IN HVR 6.2.0/30 (2025-12-09) ---------------------------------------- [RD-1054526] ORACLE: IMPROVED HANDLING OF RMAN-CREATED ARCHIVE LOGS To use this feature, upgrade HVR on the capture machine(s). This improvement filters logs created by RMAN from the archive search. This change allows HVR to handle situations where duplicate archive logs exist and prevents conflicts caused by RMAN backup copies. [RD-425167] SAP HANA: IMPLEMENTED EXTRACT VOLUME METRIC To use this feature, upgrade HVR on the capture and hub machine(s). Implemented an extract volume metric for HANA locations. [RD-773518] UI: CLARIFY IN UI THE LIST OF HVR_OPS POSSIBLE FOR TIMEKEY CHANNEL To use this feature, upgrade HVR on the hub machine(s). When creating a timekey channel, the UI specified that hvr_change_op could only be 0,1, or 2. It is now possible to also get resilient hvr_op codes. This change clarifies the statement in the UI and provides a link to the documentation. PROBLEMS FIXED IN HVR 6.2.0/30 (2025-12-09) ---------------------------------------- [RD-1037917] FIXED SFTP OPERATIONS HANGING WITH UNRESPONSIVE SERVERS To fix this bug, upgrade HVR on all machine(s). Fixed an issue where SFTP operations hang indefinitely when servers accept connections but don't respond during handshake or file operations. By default, SFTP operations have no timeout (preserving original behavior). Set HVR_SFTP_TIMEOUT environment variable to a positive value in seconds to enable timeout for problematic SFTP servers that may become unresponsive. [RD-1038529] FIXED UPSERT REFRESH NOT APPLYING BURST TABLE SETTINGS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where Upsert-style refresh did not recreate the temporary burst table when required, which could lead to refresh failures (F_JT1472). Additionally, this fix ensures that the following settings are now properly applied during upsert refresh: - Parameter BurstTableStorage of action DbObjectGeneration - Parameter BurstTableCreateClause of action DbObjectGeneration - Distribution key for refresh burst table [RD-1050911] FIXED ERROR F_JG0E24 WHEN ADDING TABLE TO CHANNEL To fix this bug, upgrade HVR on all machine(s). Fixed an issue where adding tables to channels with more than 32 locations using remote agents would fail with error F_JG0E24 (Link set object is full). Channels can now support a larger number of remote agent locations. [RD-1064843] FIXED CAPTURE FAILING WITH F_JT1496 ON UNENROLLED TABLE DDL To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where Oracle capture using the AdaptDDL action could fail with error F_JT1496 when processing CREATE TABLE statements for unenrolled tables. The problem occurred because the table comparison logic did not correctly handle NULL metadata, causing unenrolled tables to be incorrectly matched to enrolled tables. [RD-664415] DB2 FOR LINUX, UNIX AND WINDOWS: FIXED CASE-SENSITIVE SCHEMA HANDLING FAILURE ON DB2 LUW To fix this bug, upgrade HVR on the capture and agent machine(s). Fixed an issue where DB2 LUW replication failed when using case-sensitive schema names. DDL statements were incorrectly ignored, causing the process to stop with warnings. This fix ensures DDL operations are handled correctly when schema names use case-sensitive formatting. [RD-1067176] DB2 FOR I: FIXED START SEQUENCE FOR SUBSEQUENT LOG-BASED CAPTURE CYCLES To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where log-based capture cycles did not always resume from the exact position reached in the previous cycle. [RD-1067478] DB2 FOR I: FIXED START SEQUENCE AFTER RESTART OF CAPTURE JOB To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where log-based capture jobs did not always resume from the exact position reached in the previous job. [RD-1069524] DB2 FOR I: FIXED EXCESSIVE DISPLAY_JOURNAL QUERIES FOR CHANNELS WITH MANY TABLES To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where HVR could generate an excessively high number of display_journal queries when a channel contained a very large number of tables. HVR now limits the number of display_journal queries to 11 by default. You can adjust this limit by setting the HVR_DB2I_DISPLAY_JOURNAL_QUERY_MAX environment variable. [RD-1062647] ORACLE: FIXED CRASH ON SPARC WHEN READING SHORT VALUES To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue that caused HVR to crash on SPARC systems when the Oracle redo log parser read short values from unaligned memory. This could also affect other architectures that enforce strict memory alignment. [RD-1068034] ORACLE: FIXED USERNAME CASE SENSITIVITY IN LOCATION GRANTS TEST To fix this bug, upgrade HVR on the capture and hub machine(s). Fixed an issue where the location grants test incorrectly treated database usernames as case-sensitive. This could cause the test to report missing privileges even when the configured login had the required grants. The comparison now correctly handles usernames in a case-insensitive manner, ensuring accurate validation. [RD-1031782] POSTGRESQL: FIXED REPLICA IDENTITY RESET DURING TABLE CREATION To fix this bug, upgrade HVR on the integrate and capture machine(s). Fixed an issue where REPLICA IDENTITY settings were not preserved when HVR created missing target tables or recreated tables during a refresh. This could cause replication activation failures if a table lacked a primary key and was used in a bi-directional channel or replicated as a source in another channel. With this fix, REPLICA IDENTITY is now preserved automatically, removing the need for manual ALTER TABLE ... REPLICA IDENTITY ... configuration. [RD-1068346] POSTGRESQL: FIXED F_JR6503 WITH EARLIER VERSIONS OF POSTGRESQL SOURCE AGENT To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where upgrading the hub could trigger error F_JR6503 (REPLICA IDENTITY for table is incorrectly configured. Please re-configure REPLICA IDENTITY by "ALTER TABLE ... REPLICA IDENTITY ...") when the HVR Agent running on the PostgreSQL source location was using a version earlier than 6.1.5/4. The fix ensures backward compatibility, allowing you to upgrade the hub without upgrading the HVR Agent on the PostgreSQL source location at the same time. [RD-409489] SYBASE ASE: FIXED ASE SQL BASED CAPTURE WHERE MISSING COLUMNS SHOULD BE MARKED AS INCOMPLETE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where, in ASE SQL Based Capture mode, missing columns were not being marked as incomplete. This could lead to data integrity issues during replication when certain columns were absent in the source database schema. PROBLEMS FIXED IN HVR 6.2.0/29 (2025-11-25) ---------------------------------------- [RD-1040530] IMPROVED ORACLE ADD TABLE PERFORMANCE To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue that caused slow performance when adding Oracle tables through the user interface. The fix skips costly metadata queries related to partitions and extended table properties, and introduces caching to reduce repeated lookups. [RD-1040934] FIXED MEMORY CORRUPTION CAUSING ERROR F_JG200A IN TIMEKEY INTEGRATE To fix this bug, upgrade HVR on the integrate machine(s). Fixed a memory corruption issue that triggered error F_JG200A during resilient TimeKey integration. This fix improves the stability of the integration process when using resilient mode. [RD-1055374] FIXED F_JG21D9 FOR TRUNCATED LOB COLUMNS WHEN DROPPING DUMMY UPDATES To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where capture would fail with error F_JG21D9 when processing truncated LOB columns, while environment variable HVR_SCAN_DROP_DUMMY_UPDATE is set. For example truncation could happen with SQL capture on SQL Server. [RD-1057189] REDUCED MEMORY USAGE IN HVRLICENSE To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where hvrlicense consumed excessive memory during execution. This fix ensures that memory is released promptly after operations complete, reducing overall memory usage. [RD-908901] FIXED SCHEMA REGISTRY SUBJECT GENERATION FOR JSON To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where the Schema Registry subject for JSON format was generated with an incorrect topic value. Subject generation for JSON now aligns with Avro and uses the correct topic. [RD-980276] HARDENED FILE FLUSH HANDLING ON WINDOWS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where file flush operations could fail on Windows if the operating system unexpectedly closed an open file handle. This fix improves the reliability of file writing and reduces the risk of flush-related errors during operation. [RD-1035780] DB2 FOR LINUX, UNIX AND WINDOWS: FIXED ODBC DATATYPE HANDLING FOR DB2 LUW QUERIES To fix this bug, upgrade HVR on the capture and hub machine(s). Fixed an issue where DB2 LUW queries would fail with error F_JD20FF when the ODBC driver returns DECFLOAT datatype for numeric values in restrict conditions. This fix ensures proper handling of the DECFLOAT datatype. [RD-1045645] DB2 FOR I: FIXED HANDLING OF PACKED DECIMALS WITH UNEXPECTED DUAL SIGN To fix this bug, upgrade HVR on the capture and agent machine(s). Fixed an issue where packed decimal values containing a sign value in both the first and last nibbles caused errors when reading Db2 for i transaction log records. The is now interpreted correctly, ensuring reliable processing of affected records. [RD-1059822] DB2 FOR I: FIXED ADDING SQL TABLES WITH POUND STERLING SIGN IN NAME TO CHANNEL To fix this bug, upgrade HVR on all machine(s). Fixed an issue where adding SQL tables with names containing a pound sterling sign to an HVR channel failed. This issue occurred on Db2 for i systems using the French EBCDIC encoding 297, where table names can include a pound sterling sign. [RD-1060479] DB2 FOR I: FIXED ADDING PHYSICAL FILES WITH POUND STERLING SIGN IN NAME TO CHANNEL To fix this bug, upgrade HVR on all machine(s). Fixed an issue where adding physical files with names containing a pound sterling sign to an HVR channel failed. This issue occurred on Db2 for i systems using the French EBCDIC encoding 297, where physical file names can include a pound sterling sign. [RD-1052420] ORACLE: FIXED F_JG200A SIGSEGV WHILE USING LOGMINER TO CAPTURE CHANGES FROM ORACLE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where accessing union members for non-row operations caused a segmentation violation error while capturing changes using Logminer for Oracle databases. This occurred when transaction operations (commits, rollbacks, etc.) were processed. [RD-1036364] POSTGRESQL: FIXED F_JD2272 FOR INDEX NAME CONFLICTS To fix this bug, upgrade HVR on the integrate and capture machine(s). Fixed an issue where index creation failed when a name already existed, triggering F_JD2272: DBMS error [ERROR: relation "" already exists]. HVR now checks for existing index names and appends a numeric suffix to ensure uniqueness. [RD-1056605] SAP HANA: FIXED F_JG290B MEMORY ISSUE IN HVRADAPT FOR SAP HANA To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue that could cause hvradapt to crash or behave unexpectedly when listing tables in SAP HANA databases. This fix improves stability and prevents memory corruption during table discovery operations. [RD-1042818] SYBASE ASE: FIXED ISSUE WHERE WITH ASE DIRECT CAPTURE THE LOG TRUNCATION POINT COULD GET STUCK To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where, in ASE Direct Capture mode, the transaction log truncation point could get stuck. This occurred when ASE incorrectly reported pending results on the capture connection, preventing log truncation even after all results has been processed and the select was closed. When this issue occurred, trace output ( `HVR_SQL_TRACE=3`) included messages similar to: `$HVR_SQL_TRACE=1[dbzread]: Transaction log truncation request is skipped due to pending results upon connection.` preceded by: `$HVR_SQL_TRACE=2[dbzread]: Closing select. $HVR_SQL_TRACE=3[dbzread]: Handle result 1: [4047] {CS_CMD_SUCCEED}. $HVR_SQL_TRACE=3[dbzread]: Handle result 1: [4046] {CS_CMD_DONE}. $HVR_SQL_TRACE=1[dbzread]: Closed select.` NEW FEATURES IN HVR 6.2.0/28 (2025-11-11) ---------------------------------------- [RD-1049570] BUNDLED FIVETRAN PROXY AGENT VERSION 1.1.3 To use this feature, upgrade HVR on the agent machine(s). This update includes version 1.1.3 of the Fivetran Proxy Agent in the HVR installation package. [RD-1056961] BUNDLED FIVETRAN PROXY AGENT VERSION 1.1.4 To use this feature, upgrade HVR on the agent machine(s). This update includes version 1.1.4 of the Fivetran Proxy Agent in the HVR installation package. PROBLEMS FIXED IN HVR 6.2.0/28 (2025-11-11) ---------------------------------------- [RD-1033382] FIXED HVR SCHEDULER REMAINING IN RESTARTING MODE FOR OVER AN HOUR To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where the HVR Hub Server did not reset the HVR Scheduler retry counter after a successful start. This caused the HVR Scheduler to remain in restarting mode for over an hour. The retry counter is now correctly reset, allowing timely HVR Scheduler restarts. [RD-1039774] FIXED F_JG200A SIGSEGV WHEN RECONNECTING TO REPOSITORY TABLES To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue that caused a segmentation violation (SIGSEGV) with error code F_JG200A when retrying connections to HVR repository tables. This occurred when the hub database dropped a connection and HVR successfully reconnected. [RD-1046840] DB2 FOR I: FIXED F_JT1478 ERROR CAUSED BY MISSED RECORDS ON BUSY SYSTEMS To fix this bug, upgrade HVR on the capture and agent machine(s). Fixed an issue where capture could miss records on busy Db2 for i systems, resulting in fewer rows being applied during integration and triggering error F_JT1478. Ensure that the HVR user has SELECT permission on the QSYS2.JOURNAL_RECEIVER_INFO catalog view. [RD-1046958] ORACLE: FIXED INCORRECT HANDLING OF NEGATIVE INTERVAL VALUES To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where interval values with a leading negative sign were not calculated correctly. Previously, negative intervals such as -1 10:55:22 were interpreted as -1 day and positive hours, minutes, and seconds. This fix ensures the entire interval is treated as negative, preserving the correct value during replication and transformation. [RD-1041162] POSTGRESQL: FIXED SUPPLEMENTAL LOGGING WHEN CONTEXT IS DEFINED ON RESTRICT To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where supplemental logging was not correctly enabled during replication activation if a Restrict action was defined with the Context parameter. [RD-1025281] SYBASE ASE: FIXED LOB COMPARISON FAILURES AFTER ASE BULK REFRESH To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where Large Object (LOB) columns were incorrectly loaded during ASE Bulk Refresh, causing subsequent comparisons with the source data to fail. This fix ensures that LOB columns are correctly loaded and validated after Bulk Refresh operations. [RD-1043829] SYBASE ASE: FIXED FAILURE IN ASE DIRECT CAPTURE WITH BACKSLASH CHARACTERS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where ASE Direct Capture could fail with an "illegal byte sequence" error when processing data containing backslash () characters. This fix ensures that backslash characters are handled correctly during capture, preventing replication failures. PROBLEMS FIXED IN HVR 6.2.0/27 (2025-10-28) ---------------------------------------- [RD-1024610] INCREASED STRING BUFFER TO HANDLE LONG ODBC MESSAGES To fix this bug, upgrade HVR on all machine(s). Increased internal buffer size across all ODBC-based databases to reliably handle long diagnostic messages, which were causing channel activation failures. Teradata is specifically excluded, as larger buffers corrupt output parameters from it's driver API. [RD-1024622] UPDATED ABAP TRANSPORT TO V1000011 FOR SAP 7.4 SUPPORT To fix this bug, upgrade HVR on the capture machine(s). Replaced the SAP transport files with the latest version v1000011. This update includes fixes that improve compatibility and support for SAP ABAP 7.4 environments. NEW FEATURES IN HVR 6.2.0/26 (2025-10-14) ---------------------------------------- [RD-1038530] ADDED PATTERN MATCHING FOR WARNINGS IN HVR_TRACE_OUTPUT To use this feature, upgrade HVR on all machine(s). This enhancement adds support for pattern matching on warning messages using the -x option in HVR_TRACE_OUTPUT. Previously, pattern matching only applied to failures and exceptions. [RD-1040743] BUNDLED FIVETRAN PROXY AGENT VERSION 1.1.2 To use this feature, upgrade HVR on the agent machine(s). This update includes version 1.1.2 of the Fivetran Proxy Agent in the HVR installation package. PROBLEMS FIXED IN HVR 6.2.0/26 (2025-10-14) ---------------------------------------- [RD-1030797] JOBS AUTO-TRIGGERED BY SYSTEM ATTRIBUTES To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue that caused the HVR scheduler to incorrectly start pending jobs if the `retry_delay` system attribute was configured. [RD-1038531] FIXED PATTERN MATCHING BUG IN HVR_TRACE_OUTPUT To fix this bug, upgrade HVR on all machine(s). Fixed an issue where the pattern specified with the -x option in HVR_TRACE_OUTPUT did not match as expected. [RD-1013490] DB2 FOR I: FIXED HANDLING OF SQL0443 ERROR WITH FRENCH LOCALE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where HVR did not recognize the SQL0443 error message when returned in French from DB2 for i. This fix ensures correct error detection and handling when using a French system locale. [RD-1039344] DB2 FOR I: FIXED ERROR F_JD0E2B CAUSED BY NULL VALUES IN NOT NULL COLUMN To fix this bug, upgrade HVR on the capture machine(s). Fixed error F_JD0E2B, which occurred when the Db2 for i DISPLAY_JOURNAL API returned NULL for columns defined as NOT NULL. To address this, a new environment variable HVR_DB2I_DESCRIBE_COLUMN_ALWAYS_NULLABLE has been introduced. When set to TRUE on the source location, HVR will treat all columns as nullable to prevent the error. After setting the variable, you must redefine the tables in the channel using the UI (Redefine Table > From Actual Source), CLI (hvradapt), or the corresponding REST API endpoints. Then re-activate replication. [RD-1039407] DB2 FOR I: FIXED ERROR F_JD2133 CAUSED BY DECIMAL PRECISION MISMATCH To fix this bug, upgrade HVR on the capture machine(s). Fixed error F_JD2133, which occurred if a Db2 for i DECIMAL column defined with an even precision contained values with one digit more than expected. To address this, a new environment variable HVR_DB2I_DESCRIBE_EVEN_DECIMAL_ALWAYS_ONE_LARGER has been introduced. When set to TRUE on the source location, HVR will treat all even-precision decimals as if their precision is one higher than defined in the Db2 for i catalog. After setting the variable, you must redefine the tables in the channel using the UI (Redefine Table > From Actual Source), CLI (hvradapt), or the corresponding REST API endpoints. Then re-activate replication. [RD-1028045] ORACLE: FIXED OUT-OF-SYNC ISSUE ON INSERT INTO INDEX-ORGANIZED TABLES To fix this bug, upgrade HVR on the capture machine(s). Fixed an out-of-sync issue in Oracle index-organized tables caused by inserting a row with the same primary key but different non-key values as a previously deleted row in the same transaction. [RD-1034166] ORACLE: FIXED MISSING SCHEMAS WITH ONLY VIEWS IN TABLE VIEW To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where schemas containing only views were not displayed in the HVR UI. All schemas, including those without tables, now appear correctly in the table view. [RD-929312] SAP HANA: FIXED F_JG2215 ERROR THAT OCCURRED WHEN RUNNING HVRLOGENCAP FOR SAP HANA LOG BACKUPS To fix this bug, upgrade HVR on the capture machine(s). Fixed F_JG2215 error that occurred when running hvrlogencap on SAP HANA log backups. [RD-1032803] SYBASE ASE: FIXED F_JZ0AA6 ERROR DURING DIRECT CAPTURE IN TRANSACTIONS INVOLVING MULTIPLE TABLES WITH LOB COLUMNS To fix this bug, upgrade HVR on the capture machine(s). Fixed F_JZ0AA6 error during direct capture in Sybase when processing transactions involving multiple tables with LOB columns. The error occurred when an UPDATE operation on a table with LOB columns was followed by a WRITETEXT update on another table within the same transaction, causing improper row image handling. PROBLEMS FIXED IN HVR 6.2.0/25 (2025-09-30) ---------------------------------------- [RD-1015392] FIXED HIGH CPU USAGE WHEN RE-ENABLING ALERTS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where re-enabling an alert after a long period could trigger multiple instances of hvralert.py to run in parallel, resulting in high CPU usage and system load. Now, if an alert check is overdue by more than 5 hours, it scans only from the beginning of the current hvr.out file. [RD-1033912] AZURE DATA LAKE STORAGE: FIXED CRITICAL SECURITY VULNERABILITY WITH ADLS LOCATIONS To fix this bug, upgrade HVR on all machine(s). Fixed critical security vulnerability with ADLS locations in HVR 6.2.0/9 and above. [RD-1025552] DB2 FOR Z/OS: FIXED SQL0330N WHILE CAPTURING XML COLUMNS FROM DB2 FOR Z/OS TABLES WITH CHAR KEY COLUMNS To fix this bug, upgrade HVR on the capture machine(s). Fixed a bug where char key column values were incorrectly read due to character encoding mismatches when XML type columns are present in DB2 z/OS. The update ensures the correct encoding is applied when querying augmented columns. [RD-1031646] INGRES: FIXED F_JT0400 LOG SCANNING ERROR F_JZ251C. CORRUPT READ OF INGRES CNF FILE EXTENSIONS To fix this bug, upgrade HVR on the capture machine(s). Fixed parsing of Ingres CNF file extensions while capturing from Ingres 12.0. [RD-1021684] ORACLE: FIXED NESTED TABLE COLUMN TYPE DISPLAY IN UI To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where nested table column types were not displayed correctly in the UI. This fix ensures that nested table columns are now shown with the correct data type, even when the database incorrectly marks them as virtual. [RD-1013610] SYBASE ASE: IMPROVE SYBASE TRANSACTION LOG VALIDATION PERFORMANCE DURING CATCH-UP SCENARIOS To fix this bug, upgrade HVR on the capture machine(s). Fixed performance issues in Sybase transaction log reading when the reader falls behind the active log area. The system was performing excessive validation checks on every page, causing significant delays. Implemented a progressive validation relaxation mechanism that: - Always performs critical validation : Page headers, offsets, partition IDs, and basic structure checks - Uses relaxed validation for backup files : Automatically skips expensive checks when reading stable backup transaction log files - Progressively relaxes validation for online logs : When consecutive validation failures occur, gradually disables expensive checks in order: - Page number regression checks (after 10 failures) - DateTime regression checks (after 20 failures) - Row timestamp validation (after 40 failures) - De-escalates safely : Only restores strict validation once sufficiently caught up and still safely behind the active log area to avoid processing incomplete writes Environment variables added: - `Env_hvr_sy_read_validation_escalate_threshold` (default: 10) - Base threshold for first validation relaxation level - `Env_hvr_sy_read_validation_deescalate_safety_margin` (default: 1000) - Page Timestamp units required behind active log area before allowing validation de-escalation [RD-1024447] SYBASE ASE: REVERTED NEXT PAGE VALIDATION LOGIC IN SYBASE LOG-BASED CAPTURE To fix this bug, upgrade HVR on the capture machine(s). Reverted the next page validation logic in Sybase log-based capture. The validation logic was originally implemented under the assumption that only a single process writes to Sybase transaction logs, but this assumption seems to be incorrect. [RD-1025832] SYBASE ASE: FIXED HANDLING OF CONSUMED ROW IMAGES IN DIRECT CAPTURE FOR UPDATE OPERATIONS WITH LOB COLUMNS To fix this bug, upgrade HVR on the capture machine(s). Fixed improper handling of consumed row images in Sybase direct capture during UPDATE operations involving LOB columns. The issue occurred when row image data was marked as consumed but not properly transferred to INOOP operations, causing inconsistent state management. NEW FEATURES IN HVR 6.2.0/24 (2025-09-16) ---------------------------------------- [RD-578774] RE-ENABLED MASK PARAMETER FOR REFRESH AND COMPARE To use this feature, upgrade HVR on the hub machine(s). This feature re-enables the -m (mask) parameter in the hvrrefresh and hvrcompare commands, as well as in the UI. The mask parameter is useful for scenarios where more data exists in the target than in the source, such as when deletes are ignored during capture. This change restores essential functionality for filtering target data during refresh and compare operations. PROBLEMS FIXED IN HVR 6.2.0/24 (2025-09-16) ---------------------------------------- [RD-969178] PREVENT DUPLICATE ROWS AFTER ONLINE REFRESH WITH BURST INTEGRATE To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where duplicate rows could be applied after an online refresh when using Burst Integrate with single-merge optimization. To prevent this, the optimized single-merge logic is now temporarily disabled during the first replication cycle after a refresh when resilient control is enabled. The target databases affected by this behavior change are BigQuery, Databricks, Snowflake, and Db2 for z/OS. [RD-1021111] AZURE DATA LAKE STORAGE: FIXED ADLS INCORRECT BLOB SENSE To fix this bug, upgrade HVR on the integrate machine(s). Fixed a bug with sense for the existence of a path if a partial name is used for sense [RD-975295] DB2 FOR I: FIXED F_JG2430 ERROR WHEN ADDING A TABLE WITH EXPRESSION INDEX To fix this bug, upgrade HVR on the hub machine(s). Adding a table for replication causes F_JG2430 error for db2 for i source when the table being added contains an index with an expression. The fix now allows this scenario by adjusting the query which caused this failure. [RD-1029825] GOOGLE BIGQUERY: FIXED ERROR F_JD02D6 WHEN WORKING WITH RE-CREATED DATASETS To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue that caused refresh and integration to fail with error F_JD02D6 when the target BigQuery dataset had been dropped and re-created. This occurred due to use of region-qualified INFORMATION_SCHEMA queries, which can return stale metadata from deleted datasets. HVR now uses dataset-qualified queries to avoid this issue. [RD-925089] ORACLE: IMPROVED PERFORMANCE OF SYSTEM PROPERTIES QUERY To fix this bug, upgrade HVR on the capture and hub machine(s). Modernized the system properties query used in Oracle to retrieve tables and their metadata. This change improves performance in certain environments without altering query behavior or results. [RD-938166] ORACLE: FIXED A MEMORY ISSUE ON SOLARIS FOR SPARC THAT COULD LEAD TO A SEGMENTATION FAULT WHEN AN ERROR OCCURS WHILE CONNECTING TO THE DATABASE To fix this bug, upgrade HVR on the integrate and capture machine(s). Fixed a memory issue on Solaris for SPARC that could lead to a segmentation fault when an error occurs while connecting to the database. [RD-1009575] SNOWFLAKE: FIXED F_JD20EC ERROR FOR VARIANT DATATYPE To fix this bug, upgrade HVR on the hub machine(s). Fixed the "F_JD20EC: An unknown datatype..." error for the VARIANT datatype on agent versions that don't support it. For more details, see our "Data Type Mapping for Snowflake" documentation page. [RD-1013749] SYBASE ASE: FIXED ASE INTEGRATION FAILURE WITH RESILIENCE To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where the ASE integration was failing when resilience was enabled. [RD-1011930] UI: IMPROVED GRAPH TOOLTIP ACCURACY To fix this bug, upgrade HVR on the hub machine(s). Resolved an issue where the tooltip could display an incorrect date after snapping to the nearest data point on the graph. NEW FEATURES IN HVR 6.2.0/23 (2025-09-02) ---------------------------------------- [RD-1018297] DB2 FOR LINUX, UNIX AND WINDOWS: REMOVED DEPRECATED ENVIRONMENT VARIABLE HVR_DB2_LUW_COPY_YES_PATH To use this feature, upgrade HVR on the integrate and hub machine(s). The environment variable HVR_DB2_LUW_COPY_YES_PATH, originally introduced as part of T-872874, was deprecated in versions 6.2.0/15 and 6.2.5/6 as part of T-927916. Use the Copy_Yes_Path location property instead. T-872874 T-927916 PROBLEMS FIXED IN HVR 6.2.0/23 (2025-09-02) ---------------------------------------- [RD-1018666] FIXED THE ENRICHMENT OP CLEANUP QUERY WHEN IT IS ISSUED FOR MULTIPLE STATEMENTS To fix this bug, upgrade HVR on the integrate machine(s). If integrate fails during burst, and if the target does not support multi-statement transactions, then the insert statements used to enrich rows that have column values missing may be issued a second time. If HVR_BURST_ENRICHMENT_CLEANUP is set, integrate will remove any existing enrichment rows from the burst table before issuing the enrichment insert SQL. There are cases where the enrichment insert SQL is issued more than once. In these cases, and if HVR_BURST_ENRICHMENT_CLEANUP was enabled, then some enrichment rows needed for replication would be removed. This issue has been fixed. [RD-1021411] FIXED INCORRECT PARSING OF SAP METADATA IN DDNTF TABLE To fix this bug, upgrade HVR on the capture machine(s). Fixed incorrect parsing of SAP metadata in DDNTF table due incorrect checking of metadata version. To use old-style metadata version user has to add the environment variable HVR_SAP_DESCRIBE_DDNTF_VERSION=1 on capture location. [RD-1025146] FIXED F_JG2017 WHILE PROCESSING SAP CLUSTER TABLES To fix this bug, upgrade HVR on the integrate machine(s). Ignore dummy table blocks with 0 row count in cluster document. [RD-276641] FIXED ISSUE WHERE DATETIME GOT LOCALIZED TO TIMESTAMP(0) RATHER THAN TIMESTAMP(3) To fix this bug, upgrade HVR on the integrate and hub machine(s). Fixed an issue where datetime would get localized to timestamp(0) even though it has subsecond precision. It now correctly localizes to timestamp(3). [RD-702980] FIXED F_JD1202 THROWN WHEN A SKIP CONTROL WHERE CLAUSE IS APPLIED TO THE ENCRICHMENT INSERT JOIN SQL To fix this bug, upgrade HVR on the integrate machine(s). When a skip control has been issued, and if the skip where clause is applicable, the skip where clause will be added to all the SQL applied in the burst phase. Where this is true and integrate issues the insert join to generate enchriched rows in the burst table, integrate would fail with an F_JD1202. This has been fixed. [RD-1002499] GOOGLE BIGQUERY: FIXED THE GHOST SESSION QUERY TO INCLUDE SESSIONS THAT FAILED DURING COMMIT OR ROLLBACK To fix this bug, upgrade HVR on the integrate machine(s). Upon startup, integrate issues a query to find any sessions that may have been left running in BigQuery due to a previous failure, and aborts any sessions returned by the query. The query disregards sessions that are marked as committed or rolled back. This change ensures that sessions that have been committed or rolled back, and where the commit and rollback failed, will also be aborted. [RD-1016718] GOOGLE BIGQUERY: FIXED ERROR F_JR1779 WHEN THE BIGQUERY DATASET AND GS BUCKET ARE NOT IN THE SAME (MULTI-)REGION To fix this bug, upgrade HVR on the hub machine(s). Fixed error F_JR1779 when the BigQuery dataset and GS bucket are not in the same (multi-)region. [RD-971455] ORACLE: FIXED REPLICATION ISSUE DURING BULK REFRESH WITH FORCE LOGGING To fix this bug, upgrade HVR on the integrate and hub machine(s). Fixed an issue where, in a cascade replication setup with Refresh filtering enabled, Bulk Refresh operations were incorrectly replicated from an intermediate Oracle node when the database or tablespace was configured with force logging. The intermediate node's Capture process can now correctly identify and filter these operations, preventing unintended replication. [RD-861321] SAP HANA: ALLOWED TO GENERATE OF FIFO PIPE NAME ACCORDING TO MS AZURE BACKINT REQUIREMENTS To fix this bug, upgrade HVR on the capture machine(s). Allowed to generate of FIFO pipe name according to MS Azure Backint requirements: restored file name should be located in /usr/sap//SYS/global/hdb/backint/DB_ directory. To use this feature the environment varibale HVR_BACKINT_AGENT_MODE=1 should be set on Capture side. NEW FEATURES IN HVR 6.2.0/22 (2025-08-21) ---------------------------------------- [RD-1009361] AZURE DATA LAKE STORAGE: RE ADDED USERNAME AND PASSWORD AUTHENTICATION TYPE To use this feature, upgrade HVR on the hub machine(s). Re added username and password authentication type for Azure ADLS. PROBLEMS FIXED IN HVR 6.2.0/22 (2025-08-21) ---------------------------------------- [RD-1008587] FIXED F_JD200A SEGMENTATION FAULT ERROR WHEN EMITTING WARNINGS DURING INTEGRATE To fix this bug, upgrade HVR on the integrate machine(s). Fixed F_JD200A segmentation fault error when emitting warnings during integrate. [RD-1016988] FIXED SETTING THE WRONG IDENTIFIER OF THE USED COMPRESSION METHOD(LZ4_RAW) WITH FILEFORMAT /PARQUET To fix this bug, upgrade HVR on the integrate machine(s). Fixed setting the wrong identifier of the used compression method (LZ4_RAW). [RD-969820] FIXED OUT OF SCOPE ENVIRONMENT VARIABLE PASSED DURING LOCATION TEST To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where a location test could fail because of an Environment action of an unrelated channel. For example, if channel 'my_chn' had an Environment action with Name=MY_ENV_VAR Value=SomeValue, this Environment action would be applied to the test of a location that is not even part of channel 'my_chn'. Depending on the environment variable and its value, that could fail the test. Now, only Environment actions from the correct scope are considered during location test. [RD-971391] FIXED INCOMPLETE VALIDATION FOR GCS LOCATIONS To fix this bug, upgrade HVR on the hub machine(s). Fixed an incorrect validation rule that allowed creation of a Google Cloud Storage location without specifying a value in the DIRECTORY field (or File_Path location property). The fix makes this field/property mandatory, requiring you to specify a valid directory path to ensure proper configuration. [RD-973197] RESTORED RANGE QUERY OPTIMIZATION FOR BURST INTEGRATE WITH OLAP TARGETS To fix this bug, upgrade HVR on the integrate machine(s). Restored the use of range-based queries for burst integration with OLAP targets. This optimization was previously available only for Snowflake and was later disabled in version 6.1.0/58. It is now reintroduced to improve performance during burst processing for supported OLAP databases and data warehouses. [RD-973702] FIXED TRUSTED EXECUTABLE VALIDATION FEATURE To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where HVR failed to recognize trusted executables defined using the HVR_TRUST_EXE_USER environment variable. The comparison logic did not properly match the configured name with files in the $HVR_HOME/sbin directory, causing validation to fail. [RD-977749] DATABRICKS: FIXED ERROR F_JS0820 WHEN TRYING TO FETCH RECOVERY SEQUENCE DURING ACTIVATION To fix this bug, upgrade HVR on the integrate machine(s). Fixed error F_JS0820 when trying to fetch recovery sequence during activation. [RD-976278] DB2 FOR Z/OS: FIXED SQL0330N WHILE CAPTURING XML COLUMNS FROM DB2 FOR Z/OS TABLES WITH (VAR)CHAR KEY COLUMNS To fix this bug, upgrade HVR on the capture machine(s). Fixed a bug where key column values were incorrectly read due to character encoding mismatches when XML type columns are present in DB2 z/OS. The update ensures the correct encoding is applied when querying augmented columns. [RD-982722] DB2 FOR Z/OS: FIXED EXCESS WHITESPACES BEING ADDED FOR CHAR TYPES To fix this bug, upgrade HVR on the capture machine(s). Fixed excess whitespaces being added for CHAR types when a source is Db2 z/OS and HVR_CHAR_TRAILING_SPACES_TRIM_DISABLE=1 [RD-1011963] ORACLE: FIXED F_JG200A SIGSEGV WHILE USING LOGMINER TO CAPTURE CHANGES To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue that caused a segmentation violation (SIGSEGV) error while capturing changes using Logminer for Oracle databases. [RD-935940] ORACLE: FIXED CORRUPTION IN SCN MAPPING FOR CAPTURE RECOVERY To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where Oracle Capture could store incorrect SCN values when reading from the v$database_incarnation view. This occurred when the RESETLOGS_CHANGE# value exceeded 32 bits, causing corruption in the internal SCN-to-resetlogs_id mapping. The issue could lead to errors during RAC recovery. [RD-1010875] SYBASE ASE: FIXED F_JT0406 ERROR FOR LOB UPDATES IN ASE DIRECT CAPTURE To fix this bug, upgrade HVR on the capture machine(s). Addressed an issue where Direct Capture encountered the `F_JT0406` error during update operations on tables containing LOB columns, caused by improper handling of DOL_UPDATE records. [RD-1010875] SYBASE ASE: FIXED F_JZ0C2B ERROR DURING LOB COLUMN UPDATES IN ASE DIRECT CAPTURE To fix this bug, upgrade HVR on the capture machine(s). Fixed a Direct Capture failure that resulted in `F_JZ0C2B` error when processing update operations on tables containing LOB columns, caused by improper handling of TEXTINSERT and INOOP records. [RD-1015352] SYBASE ASE: FIXED F_JZ270C ERROR IN ASE DIRECT CAPTURE BATCH UPDATE PROCESSING To fix this bug, upgrade HVR on the capture machine(s). Fixed a Direct Capture issue that caused `F_JZ270C` error during batch update processing for tables with LOB columns in ASE environments. [RD-958752] SYBASE ASE: FIXED SYBASE DIRECT CAPTURE DELAY CAUSED BY RE-READING THE PAGES To fix this bug, upgrade HVR on the capture machine(s). Fixed performance issue in Sybase Direct capture where corrupted or partially written pages caused unnecessary re-reading and validation delays. Added proactive next page validation to quickly identify valid pages and avoid redundant processing. The check is controlled by environment variable `HVR_SY_READ_NEXT_PAGE_VALIDATION` (default: 1). When enabled, the system reads and validates the next page in the chain to determine if the current page is valid. If next page validation passes, the current page is immediately accepted without performing additional checks. NEW FEATURES IN HVR 6.2.0/21 (2025-08-05) ---------------------------------------- [RD-1009366] BUNDLE FIVETRAN PROXY 1.1.1 To use this feature, upgrade HVR on the agent machine(s). Upgraded bundled Fivetran Proxy to 1.1.1 Upgraded bundled JRE version to Azul Zulu 17.60.17 (Java 17.0.16) [RD-1007545] DB2 FOR LINUX, UNIX AND WINDOWS: ADDED SUPPORT FOR SOME ENCODINGS FOR DB2 LUW To use this feature, upgrade HVR on all machine(s). Added support for the following encodings for Db2 LUW: ISO8859-5, ISO8859-6, TIS620-1, Big5, Windows-1250, Windows-1253, Windows-1254, Windows-1255, Windows-1256, Windows-1257, Windows-1258. [RD-978697] ORACLE: ADDED RETRY MECHANISM FOR DELAYED ORACLE ARCHIVE LOG ACCESS To use this feature, upgrade HVR on the capture machine(s). This new feature enables the Capture process to retry reading archive logs in Oracle environments where log availability on disk is delayed such as with Data Guard setups using NFS-mounted directories. Capture can now be configured to wait and retry when a required archive log appears in Oracle's system view but is not yet available on the file system. This behavior is controlled by two environment variables: - HVR_ORA_READ_RETRIES_IF_ARCHIVE_MISSING: number of retry attempts - ZENVBIND_HVR_ORA_READ_SLEEP_IF_ARCHIVE_MISSING: wait time in milliseconds between retries To preserve the original behavior, the default value of HVR_ORA_READ_RETRIES_IF_ARCHIVE_MISSING is set to 0 (no retries). No action is required unless you choose to enable retry handling in environments with delayed archive log visibility. [RD-1010645] SQL SERVER: USE DECIMAL INSTEAD OF NUMERIC WHEN CREATING TABLES IN SQL SERVER To use this feature, upgrade HVR on all machine(s). Introduce environment variable HVR_MSSQL_NUMERIC_AS_DECIMAL to instruct HVR to use DECIMAL instead of NUMERIC when creating tables in SQL Server. [RD-935947] SQL SERVER: ADDED SUPPORT FOR CHARACTERSET 65001 (UTF-8) To use this feature, upgrade HVR on the integrate, capture and hub machine(s). This new feature enables connections to SQL Server when its default CharacterSet is set to 65001 (UTF-8). PROBLEMS FIXED IN HVR 6.2.0/21 (2025-08-05) ---------------------------------------- [RD-1004005] FIXES ATOMIC WRITING OF STATS STATUS FILE To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where the 'stats.status' file was not written atomically, which could result in an empty file if an error occurred during the write operation. This issue could cause the error "Can not read offset in state file" to be raised by 'hvrstatistics.pl', leading to the error F_JG2142 in 'hvrstats'. This fix ensures that the file is written atomically, preventing partial writes. [RD-977765] FIXED CURL SEEK CALLBACK WITH S3-BASED DESTINATION To fix this bug, upgrade HVR on the integrate machine(s). Fixed incorrect rewinding position for S3-based target location if TmpStore is used for source data. [RD-974015] DB2 FOR I: FIXED BINARY DECIMAL VALUES WITH EXCESS LEADING PRECISION DIGITS To fix this bug, upgrade HVR on the integrate and capture machine(s). System i RPG IV compiled programs only allow BINARY DECIMAL values with the specified precison and scale. Db2 for i's SQL interface, however, accomodates storing BINARY DECIMAL values in the range -32768 to 32767 (for BINARY DECIMAL with precision 2 to 4) and values in the range -2147483648 to 2147483647 (for BINARY DECIMAL with precision 5-9). System i RPG IV compiled programs will silently ignore any excess leading digits when out of range values are encountered. HVR will now do the same. [RD-871447] ORACLE: MODERNIZE ORACLE DB PROPERTY QUERY To fix this bug, upgrade HVR on the capture and hub machine(s). Fixed a performance issue that caused slow retrieval of table properties information from Oracle databases in certain environments. The query is now optimized for better performance without changing its behavior or results. [RD-978690] SQL SERVER: FIX REFRESH FOR DATABASES WITH 65001 (UTF8) CHARSET To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where SQL Server databases configured with the 65001 (UTF8) charset caused refresh to fail with error F_JD20F2. PROBLEMS FIXED IN HVR 6.2.0/20 (2025-07-22) ---------------------------------------- [RD-1002257] FIXED UNDERBILLING FOR WIDE TABLES WITH MANY ROWS ON CONSUMPTION BASED PRICING PLANS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where wide tables with many rows were underbilled on Consumption Based Pricing (CBP) plans. This fix ensures accurate usage tracking and billing for row-heavy tables. [RD-969878] FIXED ERROR DISPLAYING JOB ATTRIBUTES WITH MULTIPLE INTEGRATESTARTTIMES To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue that caused error F_JG0735 when displaying job attributes in the hub after activating a channel with multiple IntegrateStartTimes parameters. Job attributes now load correctly without triggering errors. [RD-984254] FIXED HVRLICENSE FAILURE F_JG2014 CAUSED BY LEFTOVER TEMPORARY FILES To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where leftover temporary files were incorrectly processed while hvrlicense was handling MAR files, triggering error F_JG2014. Temporary files are now skipped to prevent failures during MAR processing. [T-925010] FIXED F_JD024D DUPLICATE ROW ERROR ON BURST INTEGRATE WITH KEY REUSE To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where 'Burst Integrate' would cause duplicate rows on the target if an Integrate cycle included a back-and-forth key change. The fix ensures that such key changes are properly coalesced to prevent duplication. [T-958695] DO NOT USE PARALLEL EXECUTION OF ADAPTDDL AND INTEGRATION JOBS TO AVOID DATA LOSS To fix this bug, upgrade HVR on the capture machine(s). Using the AdaptDDL action with the preserve KeepOldRows option or the setting OnPreserveAlterTableFail=CREATE_AS_SELECT can lead to data loss if Integrate jobs are in a RUNNING state. If an `ALTER TABLE` operation on the target requires exclusive access, HVR suspends the Integrate job to apply the DDL change. [T-976045] ENHANCED MEMORY MANAGEMENT FOR MAR WITH RE-SYNC DETECTION To fix this bug, upgrade HVR on the integrate and hub machine(s). This improvement optimizes memory management for MAR with re-sync detection. The change reduces memory usage significantly, improving performance and efficiency during integration cycles and refresh operations. [T-983706] DATABRICKS: FIXED AN ISSUE THAT CAUSED CORRUPTED FLOAT VALUES DURING REPLICATION To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue that caused corrupted FLOAT values during replication [RD-873485] ORACLE: IMPROVED PERFORMANCE OF ORACLE SUPPLEMENTAL LOGGING QUERY To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where retrieving supplemental logging information from Oracle databases could be slow in some environments. The query has been optimized for better performance without changing its behavior or results. [RD-980350] ORACLE: ENHANCED ARCHIVED LOG TRACING WITH ADDITIONAL TIMESTAMPS To fix this bug, upgrade HVR on the capture machine(s). Enhanced archived log tracing with additional timestamps, providing more visibility into log processing progress and completion. [RD-984656] ORACLE: FIXED RBA PARSING FOR LARGE FILE VALUES To fix this bug, upgrade HVR on the integrate, capture and hub machine(s). Fixed an issue where Oracle RBA parsing failed when the 'file' value exceeded six hexadecimal digits. This fix expands support for larger RBA file values, ensuring correct parsing in environments where these values exceed the previous limit. [RD-951099] SAP HANA: FIXED HANA PARTIAL ROLLBACK TO SAVEPOINT To fix this bug, upgrade HVR on the capture machine(s). Fixed incorrect sequence boundary handling during partial rollbacks to a SAVEPOINT in HANA replication. [T-985277] SQL SERVER: FIXED TABLE EXPLORER SOMETIMES ADDING INCORRECT CASE FOR TABLE NAMES To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where searching for table names through the table explorer in SQL Server would result in the same case being returned as was searched for, instead of the table name's stored case in the database. This also fixes possible capture issues for AdaptDDL. [RD-983644] SNOWFLAKE: FIXED ADAPTDDL FAILING ON TRYING TO INTEGRATE SURROGATE KEY To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where AdaptDDL fails on trying to integrate surrogate key as primary key. [T-955492] SYBASE ASE: FIXED LOGGING OF DELETE AND INSIND FOR BATCH UPDATES To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where Sybase ASE logged all DELETE and INSIND operations for multiple updates in a batch, instead of logging INSERT and UPDATE operations for each update individually. This caused HVR to capture only one update, which has now been fixed. [T-979462] SYBASE ASE: FIXED F_JT0406 ERROR WITH LOB UPDATES IN ASE DIRECT CAPTURE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where Direct Capture failed with error `F_JT0406` during update operations on tables with LOB columns due to incorrect TEXTINSERT record handling. [T-980894] UI: FIXED UI ISSUES IN THE SLICING FORM To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue that caused outdated or incorrect data to appear in the slicing form. NEW FEATURES IN HVR 6.2.0/19 (2025-07-08) ---------------------------------------- [T-862691] IGNORE SAP DATA TYPES CONVERSION IF COLUMN WITH DATS DATATYPE IS A PART OF KEY To use this feature, upgrade HVR on the capture machine(s). Ignore SAP Data Types Conversion if column with DATS datatype is a part of key. Old behaviour is applied if environment variable HVR_SAP_DESCRIBE_DATS_KEY_NATIVE is set 0. [T-892672] ORACLE: ADDED SUPPORT FOR ORACLE AUTO-LOGIN ORACLE KEY VAULT WALLET To use this feature, upgrade HVR on the capture machine(s). When activating a TDE-enabled Oracle source with auto-login Oracle Key Vault (OKV) wallet, activation failed in locating and verifying the configuration of the OKV wallet even though the OKV wallet has been configured properly. These changes allow Activation to properly locate the auto-login OKV configuration in the Oracle wallet. Additionaly, a new environment variable (HVR_ORA_OKV_HSM_PASSWORD) has been added, which can hold an encrypted password and be used to override the OKV or HSM password stored in Oracle's auto-login wallet. To ensure the security of the password specified in the environment variable, it should be encrypted using the `hvrcrypt` command. PROBLEMS FIXED IN HVR 6.2.0/19 (2025-07-08) ---------------------------------------- [T-911673] FIXED ERROR WITH MULTIPLE ONENROLLBREAK VALUES PER LOCATION To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where the HVR hub throw an F_JR0206 error when AdaptDDL actions defined different OnEnrollBreak values for multiple target locations in the same channel. This fix ensures per-location OnEnrollBreak values are now processed correctly during DDL replication. [T-370557] GOOGLE BIGQUERY: FIXED INCORRECT TIMESTAMP CONVERSION To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue that occurred when replicating a timestamp with a time zone column value to a BigQuery TIMESTAMP column. The timestamp was not converted to UTC before insertion, resulting in incorrect values in the target. [T-952790] ORACLE: FIXED A CRC CHECK DURING THE PRE-POSITIONING STEP To fix this bug, upgrade HVR on the capture machine(s). Fixed a problem that happened when we checked the CRC during the pre-positioning step. This was when we used online log logic on archived logs. [T-961623] SNOWFLAKE: FIX PRECISION ISSUE DURING BULK LOAD OR REFRESH WHEN USING FLOAT DATATYPE To fix this bug, upgrade HVR on the integrate machine(s). Fix precision issue during bulk load or refresh when using FLOAT datatype [T-766579] SYBASE ASE: FIXED PARTIAL ROLLBACK HANDLING FOR SYBASE ASE LOG-BASED CAPTURE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue in Sybase ASE Log-Based Capture where WRITETEXT operations from a partially rolled-back transaction were incorrectly replicated. These operations are now correctly excluded from replication. [T-911173] SYBASE ASE: FIXED TIMESTAMP REGRESSION WARNING IN SYBASE DIRECT CAPTURE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue in Sybase capture where minor timestamp regressions triggered unnecessary warnings. A new environment variable HVR_SY_READ_TIME_DIFF_MAX (default: 10,000 milliseconds) now defines the allowable regression threshold. The warning "W_JZ1D07: Encountered a transaction control" is now issued only if this threshold is exceeded. [T-971061] UI: FIXED CONFIGURATION ORACLE TDE AUTO-OPEN WALLETS FROM THE UI To fix this bug, upgrade HVR on the hub machine(s). Fixed an UI issue that prevented an Oracle TDE password to be left blank in some cases, while this is required for auto-open wallets to be configured. NEW FEATURES IN HVR 6.2.0/18 (2025-06-24) ---------------------------------------- [T-806400] ADDED IBM-930 SUPPORT (JAPANESE) FOR DB2 FOR I AND DB2 Z/OS To use this feature, upgrade HVR on all machine(s). Added the IBM-930 character set support (Japanese Katakana/Kanji, union of IBM-290 and IBM-300) for Db2 for i and Db2 z/OS. This patch doesn't affect character sets supported previously. [T-972416] ADDED SUPPORT FOR DATA TYPE DB2 ROWID IN HVRDATAGEN To use this feature, upgrade HVR on the hub machine(s). HVRDATAGEN can now also generate values for the Db2 ROWID data type. [T-972940] ENHANCED RESILIENCE OF HVRLICENSE ERROR HANDLING To use this feature, upgrade HVR on the hub machine(s). This improvement enhances the resilience of hvrlicense by converting several specific errors into warnings. The following error codes are now treated as warnings: `F_JR4508`, `F_JR4509`, `F_JR450A`, `F_JR450B`, `F_JR450D`, and `F_JR450F`, all related to missing cols_key_sorted or cols_nkey_sorted fields in sample or metadata files. Additionally, when MAR with re-sync detection fails, hvrlicense now automatically falls back to MAR without re-sync detection to improve reliability. [T-973046] ADDED SUPPORT FOR DATA TYPE DATALINK IN HVRDATAGEN To use this feature, upgrade HVR on the hub machine(s). HVRDATAGEN can now also generate values for the DATALINK data type. [T-928438] DATABRICKS: ADDED SUPPORT FOR DATABRICKS ODBC DRIVER VERSION 2.9.1 To use this feature, upgrade HVR on the integrate machine(s). Added support for Databricks ODBC driver version 2.9.1. [T-953583] DB2 FOR LINUX, UNIX AND WINDOWS: ENABLED DISPLAY OF ALL SCHEMA NAMES IN TABLE SELECTION UI To use this feature, upgrade HVR on the integrate and capture machine(s). This new feature enables all schema names, including those starting with reserved prefixes such as "SYS " and "Q ", to be displayed in the schema list of the table selection UI for Db2 LUW. Previously, these schemas were hidden based on IBM recommendations. You can now view and select tables from all available schemas regardless of their names. [T-949935] ORACLE: ADDED OPTION TO EXCLUDE REDO LOGS DATED IN THE FUTURE To use this feature, upgrade HVR on the capture and hub machine(s). This feature allows you to exclude redo log files -archived or online- if their timestamp is ahead of the current system time on the database host. Such logs can cause issues in certain environments. To enable this behavior, set the environment variable HVR_ORA_EXCLUDE_FUTURE_DATED_LOGS to 1. The default is 0. PROBLEMS FIXED IN HVR 6.2.0/18 (2025-06-24) ---------------------------------------- [T-890325] FIXED F_JS0610 DURING REST API REQUEST GET HUBS/{HUB}/DEFINITION To fix this bug, upgrade HVR on the hub machine(s). This fix improves the hub configuration cache policy, reducing unnecessary database access and preventing the error. [T-922064] FIXED INVALID TIMESTAMP FORMAT ERROR THROWN BY HVR ALERT To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where HVR alert was throwing an invalid timestamp format error. This fix ensures that HVR alert correctly reads timestamp entries, even if the last line in the log file is incomplete. The check has been made more resilient to ignore invalid timestamps. [T-923959] FIXED INTEGRATE PERFORMANCE ISSUE WITH PRUNERANGE HIGH CPU USAGE To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue that caused the integrate job to have high CPU usage in the prune range logic. [T-938624] FIXED LEADING ZERO TRUNCATION FROM USERNAME BY HVR CONFIG TOOLS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where HVR configuration tools would truncate leading zeros from usernames that looks like number. This fix ensures that usernames are processed correctly without losing leading zeros. [T-945452] FIXED F_JG200A DUE TO INCOMPLETE VALIDATION OF COLUMN PROPERTIES SETUP To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue that caused a segmentation fault when multiple IntegrateExpression parameters were defined for the same column without using ExpressionScope. This fix adds validation to ensure such configurations are only allowed when ExpressionScope is present. [T-948938] FIXED F_JR433B WHEN UPLOADING MAR FILE WITH LONG PATH ON WINDOWS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where uploading a MAR file on Windows failed with F_JR433B if the file path exceeded 260 characters. This fix allows HVR to handle long file paths correctly during MAR file uploads. [T-959003] FIXED MEMORY LEAK FOR ORACLE ASM CAPTURE To fix this bug, upgrade HVR on the capture machine(s). Fixed memory leak for Oracle ASM capture. In some cases this would expose it self as the capture job consuming ever more memory. T-945883 T-845313 T-866826 T-912925 T-915330 [T-972885] FIXED MEMORY CORRUPTION IN HVRLICENSE To fix this bug, upgrade HVR on the hub machine(s). Fixed memory corruption in hvrlicense [T-965214] DATABRICKS: FIX ERROR F_JD1202 FOR DATABASE NAMES STARTING WITH DIGITS To fix this bug, upgrade HVR on the integrate machine(s). Fixed error F_JD1202 that occurred when using a database with a name beginning with a digit. [T-972933] DB2 FOR I: FIXED F_JD22D3 SQL0406 WHILE INTEGRATING ROWID VALUES To fix this bug, upgrade HVR on the integrate machine(s). Fixed F_JD22D3 SQL0406 while integrating ROWID values into Db2 for i. [T-973789] DB2 FOR I: FIXED F_JD22D3 SQL0332 WHILE INTEGRATING NULL INTO DATALINK OR ROWID To fix this bug, upgrade HVR on the integrate machine(s). Fixed F_JD22D3 SQL0332 while integrating NULL into Db2 for i DATALINK or ROWID. [T-936692] ORACLE: FIXED QUERY BUILDER ISSUE GENERATING INVALID WHERE CLAUSE To fix this bug, upgrade HVR on the capture machine(s). This fix addresses an issue where the Oracle query builder would incorrectly include WHERE (NULL) in certain scenarios, leading to invalid SQL syntax. [T-968201] POSTGRESQL: FIXED F_JG2430 WHEN ACTIVATING REPLICATION WITH SUPPLEMENTAL LOGGING To fix this bug, upgrade HVR on the hub machine(s). Fixed F_JG2430 error occured during replication activation when checking a PostgreSQL table's replica identity, specifically for tables outside the default schema. [T-930191] SYBASE ASE: CORRECTED UNNECESSARY LOG PAGE READS DUE TO PERCEIVED TIMESTAMP INCONSISTENCIES To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where the capture process misidentified timestamp inconsistencies, resulting in unnecessary log page reads. This fix improves performance by optimizing how timestamp consistency is evaluated during log reading. T-924886 NEW FEATURES IN HVR 6.2.0/17 (2025-06-10) ---------------------------------------- [T-959196] UPDATED OPENSSL VERSION IN CMVP-CERTIFIED BUILDS TO 3.0.8 To use this feature, upgrade HVR on all machine(s). Updated the OpenSSL version used in CMVP-certified builds to 3.0.8. [T-964651] BUNDLE FIVETRAN PROXY 1.1.0 To use this feature, upgrade HVR on the agent machine(s). Upgraded bundled Fivetran Proxy to 1.1.0 PROBLEMS FIXED IN HVR 6.2.0/17 (2025-06-10) ---------------------------------------- [T-865957] ADDED ENVIRONMENT VARIABLE TO DISABLE SQL SERVER MAXIMUM KEY LENGTH ERROR. To fix this bug, upgrade HVR on the integrate machine(s). By default, HVR would reject the creation of a primary key constraint in SQL Server if the combined key length exceeded 900 bytes, resulting in an error. This update adds `HVR_MSSQL_MAX_KEY_LEN_ERROR_DISABLE` environment variable to disable reporting error in such cases and continue to creation of primary key constraint. [T-920516] FIXED F_JR0E14 ON HUBS RUNNING ON GOOGLE CLOUD INSTANCES To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where fingerprinting failed with F_JR0E14 on hubs running on Google Cloud instances. This fix updates the signature verification process to correctly use the public certificates published by Google. [T-924657] ADDED AN ENVIRONMENT VARIABLE TO CONTROL THE MAPPING BINARY TO UUID To fix this bug, upgrade HVR on the integrate machine(s). Added an environment variable to control byte order adjustment when replicating from binary columns to UUID columns. By default, HVR adjusts the byte order of the first three groups in a UUID on little endian machines. Set the environment variable to disable adjustment when targeting UUIDs. The variable applies to all columns in all tables for the associated integrate job. [T-957443] FIXED COMPARE REPORTING DIFFERENCES FOR DECIMAL/NUMERIC -0 VERSUS 0 To fix this bug, upgrade HVR on all machine(s). Some DBMS allow both -0 and 0 as value in decimal/numeric data type columns. In some situations HVR compare would report differences for those values. That has now been fixed. [T-961690] ENHANCED MEMORY MANAGEMENT IN HVRLICENSE FOR MAR WITH RE-SYNC DETECTION To fix this bug, upgrade HVR on the hub machine(s). Enhanced hvrlicense memory management for MAR with re-sync detection. [T-947468] DATABRICKS: FIXED ERROR F_JD1203 WHEN COLUMN NAMES CONTAIN SPECIAL CHARACTERS To fix this bug, upgrade HVR on the integrate machine(s). Fixed error F_JD1203 when column names contain certain special characters. [T-954964] DB2 FOR I: FIXED F_JD22D3 WHEN SWITCHING RECEIVERS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where Db2 for i capture failed with F_JD22D3: DBMS error [SQL0443 - STARTING_SEQUENCE OR ENDING_SEQUENCE NOT FOUND] when switching between journal receivers. [T-962665] DB2 FOR I: FIXED REFRESH CRASH WHEN SOME DATABASE ERRORS ARE HIT To fix this bug, upgrade HVR on the capture and hub machine(s). Fixed call when cleaning up statements on some error handling. [T-951847] DB2 FOR Z/OS: FIXED F_JZ9240 WHEN CAPTURING WITH ADAPTDDL To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where capturing from Db2 for z/OS with AdaptDDL enabled could fail with error F_JZ9240: "SYSTABLES 'x,x,x::hvr_systables' delete log record encountered with unexpected length." This occurred when views or aliases were deleted from the Db2 for z/OS source database. [T-948826] POSTGRESQL: FIXED MEMORY LEAK IN POSTGRESQL STREAMING REPLICATION To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where a memory leak could occur during capture from PostgreSQL when using streaming replication. [T-965105] SNOWFLAKE: FIXED A BUG WHERE A NEW PRIMARY KEY WAS NOT REPLICATED VIA ADAPTDDL To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where AdaptDDL did not replicate a new primary key constraint to the target when the source table initially had no primary key. NEW FEATURES IN HVR 6.2.0/16 (2025-05-27) ---------------------------------------- [T-956617] ADDED 'CMVP' TO PACKAGE NAMES FOR HVR BUILDS USING FIPS-VALIDATED OPENSSL VIA CMVP To use this feature, upgrade HVR on all machine(s). Package names now include a "cmvp" when HVR is built with OpenSSL that has been validated under the Cryptographic Module Validation Program (CMVP). [T-912224] DB2 FOR LINUX, UNIX AND WINDOWS: ADDED SUPPORT FOR DB2 LUW VERSION 12.1 ON AIX To use this feature, upgrade HVR on the integrate and capture machine(s). Added support for Db2 LUW version 12.1 on AIX. [T-919966] MYSQL: ADDED SUPPORT FOR MYSQL 8.4 To use this feature, upgrade HVR on the integrate, capture and hub machine(s). This new feature enables replication and integration with MySQL 8.4, allowing full compatibility across capture, hub, and integration components. [T-844072] ORACLE: ALLOW FOR LONGER BANNERS IN ORACLE DB To use this feature, upgrade HVR on the capture machine(s). This new feature enables HVR to capture the full database banner in newer Oracle Database versions. Previously, longer banners could be truncated, which may have caused minor connection or validation issues. [T-797120] SNOWFLAKE: IMPROVED CREDENTIAL MASKING IN COPY INTO ERRORS To use this feature, upgrade HVR on the integrate machine(s). This improvement enhances credential masking in the integrate log when COPY INTO statements fail for Snowflake targets. Sensitive AWS credentials (such as aws_key_id, aws_secret_key, and aws_token) are now automatically obfuscated in error messages to prevent unintended exposure in log files. PROBLEMS FIXED IN HVR 6.2.0/16 (2025-05-27) ---------------------------------------- [T-844018] FIXED ERROR MESSAGE FOR EMPTY TIMESTAMP ON INACTIVITY ALERT To fix this bug, upgrade HVR on the hub machine(s). Fixed error message for empty timestamp on alert. Now, it will skip the inactivity alert if it cannot retrive the time timestamp of the last activity. [T-860721] FIXED HUB SERVER CONFIGURATION PARTIALLY RESET DURING SETUP To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where the hub server configuration was partially reset during setup, which is only relevant if the user pre-configures advanced properties not available in the setup UI before running the actual setup. E.g. Hubserverconfig properties `HTTPS_PrivateKey_Password` and `Public_Key` were explicitly deleted during the setup process, when the customer clicked the Confirm Repository Connection button. This fix ensures that any hubservconfig properties are not deleted during the setup process. [T-905188] FIXED F_JD2236 DUPLICATE KEY ERROR IN HVR_STATS To fix this bug, upgrade HVR on the hub machine(s). Fixed a rare issue that caused the F_JD2236 duplicate key error when processing HVR statistics. The process now logs duplicate rows as warnings instead of stopping execution when this condition occurs. T-868131 T-823623 [T-919530] FIXED F_JR0E14 FOR CLOUD VMS WITH TEMPORARY FINGERPRINT QUERY FAILURE To fix this bug, upgrade HVR on the hub machine(s). Fixed the F_JR0E14 error on cloud VMs caused by a temporary failure in the cloud metadata query used for fingerprint generation. This bug could cause licenses from registered HVR installations on Consumption Based Pricing to not work properly. [T-921880] FIXED F_JD1202 ERROR CAUSED BY MULTI-DELETE OPERATIONS TO TIMEKEY TARGET To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where multi-delete operations caused an F_JD1202 error during integration into a TimeKey target. This fix ensures that multi-delete operations are now processed correctly without triggering errors. [T-947603] FIXED HVRLICENSE FAILURE DUE TO MISSING METADATA IN MAR FILES To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where `hvrlicense` failed due to missing cols_key_sorted or cols_nkey_sorted metadata in MAR files. This occurred when the hub had previously written MAR files without the required metadata, leading to any of the following errors: - F_JR4508: Missing cols_key_sorted from Main Sample file of the following configurations - F_JR4509: Missing cols_key_sorted from .mar_meta file of the following configurations - F_JR450A: Missing cols_key_sorted from Main Sample file and .mar_meta file of the following configurations - F_JR450B: Missing cols_nkey_sorted from Main Sample file of the following configurations - F_JR450D: Missing cols_nkey_sorted from .mar_meta file of the following configurations - F_JR450F: Missing cols_nkey_sorted from Main Sample file and .mar_meta file of the following configurations This fix ensures that the hub now correctly writes complete metadata in new MAR files. T-949470 T-945873 [T-949533] FIXED MAR ISSUE FOR COLUMNS WITH BASENAMES To fix this bug, upgrade HVR on the integrate machine(s). Fixed MAR issue for columns with base names configured in the repository catalogs or through action ColumnProperties with parameter BaseName [T-950403] FIXED POSSIBLE DEADLOCKS WITH UPSERT-STYLE REFRESH JOBS To fix this bug, upgrade HVR on the hub machine(s). Fixed a possible deadlock that could occur when running an upsert-style refresh job. [T-934209] DATABRICKS: FIXED F_JD2150 ERROR FOR DEFAULT DATE VALUES ON DATABRICKS To fix this bug, upgrade HVR on the integrate machine(s). Fixed F_JD2150 error that occurred when a default value was generated for a datetime or timestamp column in Databricks. [T-946217] DB2 FOR I: FIXED DBMS ERROR SQL0502 DURING REFRESH To fix this bug, upgrade HVR on the capture and hub machine(s). Fixed the F_JD22D3 : DBMS error [SQL0502 - Cursor SQL_CUR0578EA90 already open or allocated] that caused Refresh to restart. [T-944399] ORACLE: FIXED A BAD COLUMN DATA PARSING ON ORACLE HCC TABLE INSERT OPERATION To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue with bad column data parsing from Oracle redo-record for an insert operation into HCC table, triggering error F_JD2E00 on Integrate side. [T-947231] ORACLE: FIXED A MEMORY CORRUPTION DURING ORACLE HCC ZLIB DECOMPRESSION To fix this bug, upgrade HVR on the capture machine(s). Fixed a memory corruption during Oracle HCC Zlib decompression. [T-952037] ORACLE: FIXED AN ISSUE IN THE HCC PARSER THAT TRIGGERED ERROR F_JD2E00 ON INTEGRATE SIDE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue in the HCC parser that triggered error F_JD2E00 on Integrate side. NEW FEATURES IN HVR 6.2.0/15 (2025-05-13) ---------------------------------------- [T-927916] DB2 FOR LINUX, UNIX AND WINDOWS: CREATED LOCATION PROPERTY TO ALLOW LOGGING OF BULK LOAD To use this feature, upgrade HVR on the integrate and hub machine(s). This new feature adds the location property Copy_Yes_Path to to allow bulk load operations during integrate or refresh to be logged into the recovery log. The target database must be recoverable for this feature to function. [T-886071] POSTGRESQL: ADDED SUPPORT FOR POSTGRESQL 17 To use this feature, upgrade HVR on all machine(s). Added support for PostgreSQL 17. DIRECT capture method is only available until PostgreSQL 16 [T-945542] SAP HANA: ADDED SUPPORT FOR HANA 2.0 SP8 To use this feature, upgrade HVR on the capture machine(s). Added support for HANA 2.0 SP8, which introduces a new log encoding format. PROBLEMS FIXED IN HVR 6.2.0/15 (2025-05-13) ---------------------------------------- [T-910794] FIXED SIGBUS ON SPARC WHEN READING DECFLOAT VALUES To fix this bug, upgrade HVR on the integrate, capture and hub machine(s). Fixed an issue that caused a SIGBUS error on SPARC systems, and potentially other architectures with strict memory alignment requirements, when reading decfloat values. This fix ensures memory is properly aligned before invoking decNumber functions, which require aligned memory access. [T-922783] FIXED INTEGRATION OF DOUBLE-PRECISION FLOATING-POINT NUMBERS INTO SNOWFLAKE To fix this bug, upgrade HVR on the integrate machine(s). Fixed integration of double-precision floating-point numbers into Snowflake by increasing the precision from 15 to 17 significant digits. [T-928439] FIXED PASSING INCORRECT LIST OF PREDEFINED SUBSTITUTIONS TO USE WITH INTEGRATE /MESSAGEKEY OPTION FOR KAFKA-BASED LOCATION To fix this bug, upgrade HVR on the integrate and hub machine(s). Passed a valid set of predefined substitutions for Kafka-based location used in with Integrate /MessageKey option [T-936774] ENHANCED MEMORY TRACKING IN CERTAIN ORACLE ASM SCENARIOS To fix this bug, upgrade HVR on all machine(s). This fix enhances memory tracking to ensure all allocations are correctly monitored during capture from Oracle ASM sources. The fix extends the previous enhancements made in T-926960, addressing a case where memory usage could appear to grow continuously due to previously untracked allocations. [T-938801] FIXED F_JG4518 MAR SAMPLE BUFFER CAPACITY EXCEEDED To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue that caused the MAR sample buffer to exceed capacity during sliced loads, triggering error F_JG4518. [T-941966] FIXED F_JG0EA2 INVALID OR NOT SUPPORTED MAR SIGNATURE VERSION 4 To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue that caused error F_JG0EA2 due to an unsupported MAR signature version. This occurred when using a newer MAR with re-sync detection on older installations lacking support for version 4. The fix ensures backward compatibility with earlier versions. [T-945364] FIXED BROKEN LINKS TO DOCUMENTATION FOR LOCATION CONNECTION FOR DATABRICKS AND DATABRICKS REQUIREMENTS. To fix this bug, upgrade HVR on the hub machine(s). Fixed broken links to documentation for Location Connection for Databricks and Databricks Requirements. [T-872400] DB2 FOR I: FIXED WARNING W_JT044C DUE TO SKIPPED RECORDS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue in Db2 for i capture where missing begin transaction records triggered Warning W_JT044C. This issue could also cause other record types to be skipped, potentially leading to ignored changes. [T-931862] POSTGRESQL: FIXED POSSIBLE ERROR F_JG221D OCCURRING AFTER ENROLL REVISION To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue (F_JG221D) encountered in the capture job after processing an enroll revision involving a source table schema change. For example, adding a partition that was detected by Activation. [T-933697] SAP HANA: FIXED F_JZ0A36 WHILE DECODING STRING-BASED DATATYPES FOR HANA SP8 To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where the wrong length encoding method was selected when decoding string-based datatypes for HANA SP8. The fix ensures that both the HANA release version and the column description are considered. Backward compatibility was also implemented to process archived log files from previous HANA versions. [T-887151] SQL SERVER: FIXED OPERATION ORDERING FOR SQL SERVER SETWISE OPERATIONS To fix this bug, upgrade HVR on the capture machine(s). Fixed a data integrity issue where SQL Server could emit deletes after inserts during setwise operations. This issue occurred when HVR_SETWISE_KEYUPDATE_DECOMPOSE was set to "default" or "auto". The fix ensures that deletes are always processed before inserts during setwise updates to maintain data integrity. [T-923646] SQL SERVER: FIXED F_JD0A62 FOR SQL SERVER STRIPED BACKUPS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where reading from certain SQL Server striped backups resulted in error F_JD0A62. [T-923953] SQL SERVER: FIXED F_JD21AE WHEN GENERATING STATISTICS FOR OAUTH2 SQL SERVER CONNECTIONS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where the F_JD21AE error occurred when generating statistics for OAuth SQL Server connections. NEW FEATURES IN HVR 6.2.0/14 (2025-04-24) ---------------------------------------- [T-602875] ENABLED MAR WITH RE-SYNC DETECTION To use this feature, upgrade HVR on the integrate and hub machine(s). This new feature enables MAR with re-sync detection for consumption-based pricing. It ensures accurate measurement by charging only for changed data during a refresh, eliminating the need to restrict refreshes within the 5-day troubleshooting window. To use this feature, upgrade the HVR Hub and the HVR Agent (on integrate machines). If you don't upgrade prior to renewal, data used in the system (MAR without re-sync detection) will be applied to the new service consumption table: https://www.fivetran.com/legal/service-consumption-table-update. Transition to the updated pricing model is a contractual/billing task that needs to be aligned between customer and sales representative. Additional disk storage is required on the hub system in $HVR_CONFIG. This feature is not supported for HANA sources. Hubs not registered under consumption-based pricing remain unaffected. [T-909508] ADDED SUPPORT FOR JOIN CONDITIONS IN RESTRICT REFRESH AND COMPARE To use this feature, upgrade HVR on the agent and hub machine(s). This new feature allows you to add table joins in action Restrict with parameters RefreshJoinCondition and CompareJoinCondition. It is available only for SQL Server source locations. [T-919463] BUNDLE JRE 17.0.14 To use this feature, upgrade HVR on the agent machine(s). Upgraded the bundled JRE to version 17.0.14 and updated the release notes generation to use JRE versions instead of Zulu versions. [T-866318] DB2 FOR I: ADDED TRACE MESSAGES FOR DB2 FOR I To use this feature, upgrade HVR on the capture machine(s). Added more trace messages for Db2 for i capture. This shows more information when HVR_DB2I_READ_TRACE is set regarding create timestamps of journals. [T-861450] ORACLE: ENABLED THE ASM/BFILE CHANNEL TO SAVE REDOS USING A UNIQUE PATH To use this feature, upgrade HVR on the capture machine(s). This feature enables saving archive logs in different directories, providing more flexibility and control over data management. It is particularly beneficial for Oracle RAC ASM-BFile configurations with multichannel setups. [T-893563] SAP HANA: ADDED SUPPORT FOR NEW LOG TRANSACTION FORMAT IN SAP HANA SP8 To use this feature, upgrade HVR on the capture machine(s). SAP HANA SP8 introduced a new encoding format for short string lengths between 128 and 255. This feature ensures support for the updated log transaction format, maintaining compatibility with SAP HANA's latest changes. PROBLEMS FIXED IN HVR 6.2.0/14 (2025-04-24) ---------------------------------------- [T-899132] FIXED CHANGE IN EXTENDED DATATYPE NOT BEING HANDLED IN TABLE REDEFINITION To fix this bug, upgrade HVR on the hub machine(s). Fixed issue that occurred when redefining a table from source, and a column changed from one extended datatype to another. The change was not detected, leaving the column with the original data type. [T-901920] UPDATED MARIADB CONNECTOR/C TO VERSION 3.4.0 To fix this bug, upgrade HVR on all machine(s). Updated HVR to use MariaDB Connector/C version 3.4.0 for improved compatibility and performance. [T-902011] SECURITY ENHANCEMENTS FROM UPGRADING GO To fix this bug, upgrade HVR on the hub machine(s). Go version used to compile hvrhubserver upgraded on all build systems. [T-906341] ENHANCED TRACING SYSTEM FOR CAPTURE JOB To fix this bug, upgrade HVR on the capture machine(s). This feature enables you to more easily control and observe logs produced during a capture job. It helps simplify debugging of incidents that may occur while using HVR. [T-921746] FIXED SLOW PERFORMANCE OF BATCH TABLE PROCESSING BY SAP DESCRIBE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where redundant SQL requests caused slow performance during batch table processing with SAP Describe. [T-926960] ENHANCED MEMORY TRACKING IN CERTAIN ORACLE ASM SCENARIOS To fix this bug, upgrade HVR on all machine(s). Fixed an issue where certain memory allocations were not included in HVR's internal tracking. This enhancement improves visibility for debugging in rare scenarios, such as when using Oracle ASM capture. [T-932854] FIXED F_JD21AE SSL ERROR IN MEMSQL To fix this bug, upgrade HVR on all machine(s). Fixed a F_JD21AE error in MemSQL where SSL is not being disabled on servers where it is not supported. [T-925810] AZURE DATA LAKE STORAGE: FIXED INCORRECT PROXY FORMAT FOR GENERATING AZURE TOKEN To fix this bug, upgrade HVR on all machine(s). - Fixed an issue where token generation Azure SQL Server was failing due to incorrect proxy format. [T-911874] DB2 FOR I: FIXED DBMS ERROR SQL0519 DURING REFRESH To fix this bug, upgrade HVR on the capture and hub machine(s). Fixed the F_JD22D3 : DBMS error [SQL0519 - Prepared statement STMT0002 in use] during refresh when the receiver before the current receiver has been purged. [T-911681] ORACLE: FIXED LOB HANDLES LEAKING DURING POSITIONING STEP To fix this bug, upgrade HVR on the capture machine(s). Fixed LOB handles leaking during positioning step [T-922929] ORACLE: FIXED FREEING OF UNALLOCATED MEMORY To fix this bug, upgrade HVR on the capture and hub machine(s). Fixed an issue where the initial capture setup could fail when reading logs, leading to an attempt to free unallocated memory. This fix improves the stability of the capture process when starting replication. [T-905310] SAP HANA: FIXED HANDLING SAVEPOINT (PARTIAL ROLLBACK) IN SAP HANA To fix this bug, upgrade HVR on the capture machine(s). This change fixes the handling of SAVEPOINT (partial rollback) operations in SAP HANA log replication. [T-926240] SQL SERVER: FIXED SQL SERVER MEMORY LEAK ON CONNECTION To fix this bug, upgrade HVR on all machine(s). Fixed an issue where a memory leak occurred during the SQL Server connection process. [T-903871] SNOWFLAKE: FIXED LOCALIZATION FOR SMALL FIXED-SIZE LONG DATA TYPES To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where small fixed-size long data types were not correctly localized during integration. This fix ensures accurate data handling for these types in Snowflake. NEW FEATURES IN HVR 6.2.0/13 (2025-04-08) ---------------------------------------- [T-911813] ORACLE: ADDED ERROR HANDLING FOR LONG TABLE NAMES IN ORACLE SUPPLEMENTAL LOGGING To use this feature, upgrade HVR on the capture and hub machine(s). This feature adds validation for Oracle supplemental logging to throw an error if a table name exceeds the 30-character limit. HVR previously enforced this limit only for column names. With this change, table names are also checked for compliance. If you are using a GoldenGate license, this limit increases to 128 characters. [T-913609] ORACLE: ADD SUPPORT FOR ORACLE CHARACTERSET WE8ISO8859P9 To use this feature, upgrade HVR on the capture machine(s). HVR main driver already had support for ISO-8859-9 [Latin 5, Turkish]; this feature enables it for Oracle DB. The name of this encoding in Oracle is WE8ISO8859P9. PROBLEMS FIXED IN HVR 6.2.0/13 (2025-04-08) ---------------------------------------- [T-887772] FIXED DATE FORMATTING ISSUE IN REFRESH WITH SLICING To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue in the Refresh dialog where selecting the Slicing option with a date field and using boundary-type slicing would format the boundaries with an added time and timezone. A new option, Plain Date, has been added to the dropdown menu to format date boundaries without appending time or timezone. Previously, entering a date would format it as 2025-01-01T00:00:00+0100 or 2025-01-01T00:00:00Z based on the Local Time or UTC selection. With the new Plain Date option, the format is now 2025-01-01. [T-901035] FIXED SQL SERVER TIME COLUMN REPLICATING TO NEGATIVE INTEGER IN KAFKA To fix this bug, upgrade HVR on the integrate and hub machine(s). Fixed an issue where a SQL Server time(7) column was incorrectly replicated to a negative integer in Kafka. [T-911315] IMPROVED 'OUT-OF-RANGE' MESSAGES To fix this bug, upgrade HVR on all machine(s). Improved 'out-of-range' messages according to English rules [T-911391] FIXES UNEXPECTED CONDITION READING TMPSTORE DURING INTEGRATE To fix this bug, upgrade HVR on the integrate machine(s). Fixes an issue where integrate jobs are failing with an `F_JG21DF: Unexpected condition while reading of temp store` error during replicating a channel with a Surrogate key. This fix ensures that tempstores are internally copied when needed to avoid reading potentially corrupted tempstore. [T-844978] AZURE DATA LAKE STORAGE: FIXED INCORRECT PROCESSING 403 ERROR WITH AZURE FS PRIVATE ENDPOINTS To fix this bug, upgrade HVR on the integrate and capture machine(s). Fixed an issue where a 403 (Unauthorized) error was incorrectly processed when using private endpoints to access Azure Data Lake Storage. This fix implements a fallback mechanism to allow continued access if one of the interfaces is forbidden. [T-911883] AZURE DATA LAKE STORAGE: FIXED FLUSH FAILURE CAUSED BY MEMORY ALLOCATION ERROR To fix this bug, upgrade HVR on all machine(s). - Fixed an issue where flush operations to Azure Data Lake Storage (ADLS) could fail due to a memory allocation error. The underlying Azure SDK has been updated to resolve this problem. [T-919123] DB2 FOR I: FIXED F_JD22E8 ERROR MESSAGE TEXT To fix this bug, upgrade HVR on the capture machine(s). Fixed the F_JD22E8 error message text [T-914519] POSTGRESQL: FIXED CAPTURE HANG WHEN USING RESTART SETTING To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where the capture job could hang when the environment variable `HVR_PQ_STREAMING_REPLICATION_RESTART_AT_END_OF_WAL` was set to `1` . The default value of this setting is now changed from 0 to 1 for PostgreSQL 16, aligning it with other PostgreSQL versions. [T-905515] SQL SERVER: FIXED CAPTURE CRASH IN SQL SERVER WHEN NO BACKUPS FOUND To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where a segmentation fault occurred during capture in SQL Server if the query to determine backup locations returned no rows. [T-895365] SNOWFLAKE: FIXED UNNEEDED ALTER TABLE STATEMENTS FOR VARIANT COLUMNS To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where a column of type VARIANT resulted in unnecessary ALTER TABLE statements. [T-851063] SYBASE ASE: LOCALIZING SYBASE ASE DATATYPE DATETIME FOR CSV INTEGRATION FAILED To fix this bug, upgrade HVR on the integrate machine(s). When replicating from Sybase ASE to a CSV file, one may experience an error message like this one: `F_JD0F01: Localizing datatype 'sybase_datetime' to dbms [file..v0] for column 'dt' of table 'ff_csv_sybase_datetime' was unsuccessful` With this change the error will no longer be thrown and the replication will work as expected. [T-913680] SYBASE ASE: FIXED F_JD02A5 NUMBER OF ROWS VERY LARGE WHILE COMPARING To fix this bug, upgrade HVR on all machine(s). Fixed an issue while comparing Sybase ASE tables with a very large number of rows. Using COUNT_BIG( ) instead of COUNT( ). PROBLEMS FIXED IN HVR 6.2.0/12 (2025-03-27) ---------------------------------------- [T-888438] FIXED UPSERT REFRESH TABLES NOT ADHERING TO ACTION DBOBJECTGENERATION WITH PARAMETER BURSTTABLESCHEMA To fix this bug, upgrade HVR on the integrate and hub machine(s). Fixed an issue where the upsert refresh tables were not created in a schema defined by Action DbObjectGeneration with parameter BurstTableSchema. [T-901526] FIXED INCORRECT DATABASE LABEL IN DATETIME CONVERSION ERRORS To fix this bug, upgrade HVR on the integrate machine(s). Fixed incorrect database labels in log messages for datetime conversion errors. Previously, error messages incorrectly referenced a specific database system (e.g., "DB2") instead of reflecting the general HVR data type. Each relevant message has been updated to use a standardized format, ensuring clarity and accuracy when reporting datetime conversion issues across different database systems. Additionally, incorrect datetime constants in these messages have been corrected. [T-891207] DB2 FOR LINUX, UNIX AND WINDOWS: FIXED DBMS ERRORS DURING CAPTURE START MOMENT ACTIVATION To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where using the Capture Start Moment (capture) option during replication activation could cause DBMS errors (SQL2657N or SQL2651N). This fix ensures that rewind start ranges are correctly determined based on valid log sequence numbers and timestamps present in the recovery logs. [T-898076] ORACLE: FIXED TDE WALLET PATH ESCAPING To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where TDE wallet path escaping was not handled correctly. This fix ensures automatic detection of path styles and proper handling of Windows-style paths within a Linux hub. [T-895947] POSTGRESQL: MOVED REPLICA IDENTITY ERROR CHECK TO CHANNEL ACTIVATION To fix this bug, upgrade HVR on the capture and hub machine(s). Fixed an issue where refresh-only channels failed with the F_JR6501 error when adding tables. This happened due to the PostgreSQL table's REPLICA IDENTITY configuration. The error check is now performed during channel activation if the Supplemental Logging option is selected. [T-901315] SAP HANA: ADDED ENVINOMENT VARIABLE TO DETECT STATE TABLES IN ALL SCHEMAS To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where the Loopback Adapter in HANA only detected loopback if the HVR_I* state tables existed in the schema owned by the location user. Introduced the HVR_STATE_TBL_GLOB_ALL_SCHEMAS environment variable to enable scanning for state tables across all schemas. This ensures loopback detection works as expected. [T-888220] UI: FIXED 'REPLICATION COMPONENTS NOT ACTIVATED' ERROR IN FILE-TO-FILE CHANNELS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where file-to-file channels incorrectly displayed the error "Some replication components not activated for location", despite being correctly activated. NEW FEATURES IN HVR 6.2.0/11 (2025-03-11) ---------------------------------------- [T-896515] ADDED SUPPORT FOR CMVP-CERTIFIED HVR RELEASES To use this feature, upgrade HVR on all machine(s). Added support for CMVP (Cryptographic Module Validation Program)-certified releases of HVR. You can now choose between standard HVR releases and CMVP-certified releases, ensuring compliance with cryptographic security standards. [T-872874] DB2 FOR LINUX, UNIX AND WINDOWS: ADD COPY YES OPTION TO BULK LOAD IN DB2 To use this feature, upgrade HVR on the integrate and hub machine(s). Add new parameter HVR_DB2_LUW_COPY_YES_PATH to set a location to save backup images for db2 LUW bulk LOAD COPY=YES option. This was added to allow bulk LOAD in refresh or integrate to log entries in the recovery log. PROBLEMS FIXED IN HVR 6.2.0/11 (2025-03-11) ---------------------------------------- [T-873674] FIXED TIMEKEY COMPARE ERROR AFTER MIGRATION FROM HVR 5 To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where 'hvr_integ_seq' and 'hvr_tx_seq' integrate expressions were not resized during migration from HVR 5 to HVR 6, leading to coalesce errors in HVR compare. These expressions are shorter in HVR 5 than in HVR 6. The hvrconvert5to6 script now updates the action to ensure the correct expression size and prompts users to update their target tables. [T-894732] FIXED LEGACY FLOAT NON-NUMERIC VALUE REPRESENTATION ON WINDOWS To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where non-numeric float values were represented in a legacy format on Windows (for example, NaN was represented as 1#QNAN000000000). [T-896929] FIXED F_JD20FF WHEN PROCESS SAP DATA ON SQL SERVER 2008 To fix this bug, upgrade HVR on the integrate, capture and hub machine(s). SQL Server 2008 uses deprectated IMAGE data type to store binary data, added support to process it [T-903823] FIXED F_JC0516 ON SERVICE NAME WITH HYPHEN FOR ORACLE RAC To fix this bug, upgrade HVR on the hub machine(s). Fixed TNS redirection when connecting to Oracle RAC clusters with a dash ( `-`) in their service name. [T-342436] ORACLE: FIXED SEGMENTATION VIOLATION ON ORACLE PLUGGABLE DATABASE WITH AUTO-LOGIN TDE WALLET To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue that caused a segmentation violation (SIGSEGV) during activation on Oracle pluggable databases using an auto-login TDE wallet. [T-872373] ORACLE: FIXED SEGMENTATION VIOLATION ON INSERT INTO ORACLE HCC TABLE To fix this bug, upgrade HVR on the capture machine(s). This fix addresses a segmentation violation in the capture process when processing specific insert operation on Hybrid Columnar Compression (HCC) tables. This issue was caused by a specific column encoding in compressed data, which depended on the table structure and data. [T-886892] ORACLE: FIXED FAILURE IN CONNECTING TO AN ORACLE RAC DATA GUARD INSTANCE To fix this bug, upgrade HVR on the capture and agent machine(s). This fix addressed a failure when capturing from an Oracle RAC Data Guard physical standby instance, which requires a SYSDBA privilege. [T-881786] POSTGRESQL: FIXED ADVANCING THE REPLICATION SLOT IN IDLE CHANNELS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where PostgreSQL logical replication capture was failing to update the capture state and advance the replication slot when the channel was idle. This fix ensures that keepalive messages from logical replication are correctly processed. The fix only works when `HVR_PQ_STREAMING_REPLICATION_RESTART_AT_END_OF_WAL` is set to `0`. [T-896858] POSTGRESQL: DO NOT ALTER REPLICA IDENTITY TO FULL WHEN CREATING TABLE WITH KEYS To fix this bug, upgrade HVR on all machine(s). When creating tables in a PostgreSQL database, HVR always set replica identity to full using ALTER TABLE. This has been fixed for tables with keys to preserve the default replica identity. [T-888313] SYBASE ASE: FIXED SYBASE ASE MULTI-DIRECTIONAL REPLICATION To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue with multi-directional replication in Sybase ASE where the capture process was incorrectly recapturing changes made by integrate job, causing an infinite replication loop. [T-796337] TERADATA: FIXED PARAMETERS BINDING ISSUE To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue (F_JD20F0) where SQL_NEED_DATA error occurred in Teradata location when using parameters binding. NEW FEATURES IN HVR 6.2.0/10 (2025-02-25) ---------------------------------------- [T-891077] ADD ENVIRONMENT VARIABLE HVR_CAP_STATE_TRACE TO ENABLE LOGGING OF CAP_STATE DATA. To use this feature, upgrade HVR on the capture machine(s). Environment variable `HVR_CAP_STATE_TRACE` has been introduced to enable logging of `cap_state` data. [T-821229] INGRES: ADDED SUPPORT FOR INGRES 12.0 To use this feature, upgrade HVR on all machine(s). Added support for Ingres 12.0. [T-830951] ORACLE: ADDED SUPPORT FOR WE8DEC CHARACTER SET FOR ORACLE CAPTURE To use this feature, upgrade HVR on all machine(s). Added support for capturing data from columns using the WE8DEC character set encoding in Oracle. This character set, also known as DEC-MCS, IBM1100, CP1100, and csDECMCS, is specified by setting NLS_LANG=AMERICA_AMERICAN.DECMCS in the Oracle client environment. Previously, using this character set resulted in the F_JD5E07 unsupported character set error. [T-863905] SQL SERVER: ADDED SQL SERVER ENVIRONMENT VARIABLE TO SET CDC TABLE ROLE-NAME To use this feature, upgrade HVR on the capture machine(s). This new feature adds the environment variable HVR_MSSQL_CDC_ENABLE_ROLENAME, which allows you to set the database role that is passed to `sys.sp_cdc_enable_table` when enabling supplemental logging during activation. PROBLEMS FIXED IN HVR 6.2.0/10 (2025-02-25) ---------------------------------------- [T-892683] FIXED ERROR MESSAGES WHEN HTTPS_PRIVATE_KEY_PASSWORD IS INCORRECT To fix this bug, upgrade HVR on the hub machine(s). Added errors for missing cases when password was missing or incorrect. [T-873078] KAFKA: FIXED DATATYPE ERROR DURING SLICED REFRESH TO KAFKA To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where datatype errors occurred when performing a sliced refresh to Kafka with specific slice selections. T-762287 [T-506235] ORACLE: FIXED ORACLE CAPTURE STUCK IN AN INDEFINITE CYCLE ON A RAC ENVIRONMENT To fix this bug, upgrade HVR on the capture machine(s). This fix addresses an issue in Archive Log Only (ALO) mode Oracle Capture for getting stuck in an indefinite cycle looking for archive log on a RAC environment with more than 7 clusters. [T-864118] SQL SERVER: FIXED F_JD1A16 FOR SQL SERVER BACKUPS WITH TDE OPTIMIZED COMPRESSION To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where reading from some SQL Server Backups created with TDE and Optimized Compression errored out with F_JD1A16. [T-868226] SQL SERVER: FIXED F_JD0A6A FOR SQL SERVER STRIPED BACKUPS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where reading from certain SQL Server striped backups resulted in error F_JD0A6A. [T-894808] SQL SERVER: FIXED F_JD0A6B FOR SQL SERVER STRIPED BACKUPS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where reading from certain SQL Server striped backups resulted in error F_JD0A6B. [T-893129] SNOWFLAKE: FIXED ERROR MESSAGE F_JD22C1 WHEN HAVING CUSTOM SQL DATATYPES DISABLED To fix this bug, upgrade HVR on the integrate machine(s). Fixed error message F_JD22C1 when having custom SQL datatypes disabled ( `HVR_SNOWFLAKE_ODBC_USE_CUSTOM_SQL_DATA_TYPES=FALSE`). NEW FEATURES IN HVR 6.2.0/9 (2025-02-11) ---------------------------------------- [T-867133] BUNDLE PRUNSRV-1.4.1-X64 To use this feature, upgrade HVR on the agent machine(s). Upgraded bundled prunsrv-1.4.1-x64.exe. T-791943 - Investigate and Fix Popup when stopping windows proxy service PROBLEMS FIXED IN HVR 6.2.0/9 (2025-02-11) ---------------------------------------- [T-853293] FIXED BULK REFRESH FAILURE FOR ORACLE LOCATIONS WITH CASE-SENSITIVE NAMES To fix this bug, upgrade HVR on the integrate and capture machine(s). Fixed an issue where bulk refresh fails for Oracle locations when case-sensitive names are enabled. [T-871969] AZURE DATA LAKE STORAGE: FIXED F_JG0B15 ERROR WHEN GETTING AUTHENTICATION TOKEN FOR AZURE To fix this bug, upgrade HVR on the integrate, capture and hub machine(s). We have made the following improvement to the Azure SDK for HVR: - Fixed F_JGOB15 when getting token from Azure FS when using Azure Client credentials mode [T-876036] DATABRICKS: ALLOW NAN/INF VALUES IN FLOAT COLUMNS WHEN REPLICATING TO DATABRICKS To fix this bug, upgrade HVR on the integrate machine(s). Fixed a bug where NaN and +/-Inf float values raised an error when replicating to Databricks. [T-872905] GOOGLE BIGQUERY: FIXED BURST STRING CONTROLS FOR BIGQUERY To fix this bug, upgrade HVR on the integrate machine(s). This fixes the generation of string controls for Burst Integrate for BigQuery. [T-876031] GOOGLE BIGQUERY: ALLOW NAN/INF VALUES IN FLOAT COLUMNS WHEN REPLICATING TO BIGQUERY To fix this bug, upgrade HVR on the integrate machine(s). Fixed a bug where NaN and +/-Inf float values raised an error when replicating to BigQuery. [T-863796] ORACLE: REVERTED TO ZLIB DUE TO ISSUES WITH ZLIB-NG To fix this bug, upgrade HVR on all machine(s). Reverted to the zlib library due to issues with zlib-ng causing segmentation faults. [T-862244] SAP NETWEAVER: FIXED F_JD200A SEGMENTATION FAULT ERROR WHEN ACTIVATING ORACLE SOURCE DATABASE To fix this bug, upgrade HVR on the capture and agent machine(s). Fixed an issue where a segmentation fault (error F_JD200A) occurred when activating an Oracle source database. [T-866198] SNOWFLAKE: ALLOW NAN/INF VALUES IN FLOAT COLUMNS WHEN REPLICATING TO SNOWFLAKE To fix this bug, upgrade HVR on the integrate machine(s). Fixed a bug where NaN and +/-Inf float values raised an error when replicating to Snowflake. [T-853916] SYBASE ASE: FIXED SYBASE ASE LOG READER HANDLING OF LOG PAGE ROLLOVER To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where the Sybase ASE Log Reader incorrectly flagged log corruption during transaction log rollover. This fix ensures that wrapped log pages are now handled correctly. [T-876052] SYBASE ASE: FIXED ERROR MESSAGE F_JZ0C27 FOR COMPRESSED TRANSACTION LOG RECORDS To fix this bug, upgrade HVR on the capture machine(s). Updated error message F_JZ0C27 to clearly differentiate between fully compressed dump files, which are supported, and transaction log files with compressed records, which are not supported. NEW FEATURES IN HVR 6.2.0/8 (2025-01-28) ---------------------------------------- [T-717373] TERADATA: ADDED AN ENVIRONMENT VARIABLE PROVIDING DEFAULTS FOR MISSING TIMESTAMP VALUES To use this feature, upgrade HVR on the integrate machine(s). Added the environment variable HVR_TERADATA_DEFAULT_MISSING_TIMESTAMP, which allows you to set a default value for missing values of the timestamp type in Teradata targets. PROBLEMS FIXED IN HVR 6.2.0/8 (2025-01-28) ---------------------------------------- [T-840520] FIXED ROW DUPLICATION AFTER ONLINE REFRESH FAILS ON SEQUENCE QUERY To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where a failed sequence query during an online refresh could result in duplicate rows. This fix moves the sequence query to a separate subtask in the refresh job, ensuring that only the failed query is retried without affecting the rest of the process. [T-844466] FIX HVRAGENTLISTENER STARTUP FAILURE ON AIX 7.3 To fix this bug, upgrade HVR on the capture and agent machine(s). The hvragentlistener fails to start on AIX 7.3 because of loading environment variables with floating point data types. [T-867908] FIXED CRASH DUMP GENERATION ON LINUX To fix this bug, upgrade HVR on all machine(s). Fixed crash dump generation on Linux. [T-859707] DATABRICKS: FIXED AN ISSUE WITH DUPLICATE ROWS IN TARGET TABLE AFTER RECOVERY DURING A MERGE REFRESH To fix this bug, upgrade HVR on the integrate and hub machine(s). Fixed an issue with duplicate rows in target table after recovery during a merge refresh. [T-828238] ORACLE: FIX LOOPBACK WHEN CASE-SENSITIVITY IS ENABLED. To fix this bug, upgrade HVR on the capture and agent machine(s). The internal loopback adapter's functionality to ignore deletions is not working correctly for Oracle source locations with enabled case-sensitive names. [T-866950] ORACLE: FIXED F_JG220F PROCEDURE 'SCANORADBENROLL' ENCOUNTERED UNEXPECTED OPTION To fix this bug, upgrade HVR on the capture machine(s). Fixed a bug wherein the scalar context of the DbOraScanEnroll FProc threw an error when it encountered the -c flag in the enroll. This bug arose after the changes made in T-578960 which added the -c flag to enrollment but did not correctly handle it during the validity check. T-578960 [T-861790] SYBASE ASE: RESOLVED SEGMENTATION ISSUE WITH SYBASE ASE AS REPOSITORY DATABASE To fix this bug, upgrade HVR on the hub machine(s). Fixed a segmentation issue that could occur when Sybase ASE was used as the repository database. [T-862025] SYBASE ASE: IMPROVED ERROR HANDLING FOR BEGIN OPERATION PAGE NUMBER MISMATCH To fix this bug, upgrade HVR on the capture machine(s). In this change, the check to ensure the page number inside the `BEGIN` operation matches the page number in the header has been moved to mandatory checks. This means the number of retries for this check is now controlled by `HVR_SY_READ_CORRUPT_PAGE_MAX` (instead of `HVR_SY_READ_CORRUPT_OPERATION_MAX`). If the maximum number of retries is reached, the system throws a continuable error `F_JZ270A` instead of `W_JZ1D03`. [T-844023] UI: FIXED UI ISSUE HIDING 'MERGE INTO TARGET' FOR BIGQUERY REFRESH To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where the 'Merge Into Target' option was unavailable in the Refresh Data dialog for BigQuery targets. NEW FEATURES IN HVR 6.2.0/7 (2025-01-14) ---------------------------------------- [T-791634] UPDATE OPENSSL AND RELATED LIBRARIES TO THE HVR VERSION. To use this feature, upgrade HVR on all machine(s). This change updates OpenSSL and related libraries to the HVR version. After this change, the OpenSSL version in HVR will include an `_HVR` prefix. For example, `OPENSSL_3.0.0` will become `OPENSSL_HVR_3.0.0`, preventing any conflicts with the system's OpenSSL libraries. [T-853368] BUNDLE FIVETRAN PROXY 1.0.22 To use this feature, upgrade HVR on all machine(s). Upgrade bundle Fivetran Proxy to 1.0.22 [T-827322] AZURE DATA LAKE STORAGE: IMPROVED PERFORMANCE FOR READ/WRITE OPERATIONS FOR AZURE ADLS2 To use this feature, upgrade HVR on the hub machine(s). Improved performance by fixing a slow read/write issue for Azure SDK. [T-844978] AZURE DATA LAKE STORAGE: REDUCED PERMISSIONS NEEDED FOR USING AZURE FS To use this feature, upgrade HVR on the hub machine(s). HVR now supports handling the 403 Unauthorized exceptions, reducing the permissions required for Azure integration. You no longer need to assign the Storage Account Contributor role to enable functionality. [T-848830] DATABRICKS: ADDED SUPPORT TO RECONNECT TO DATABRICKS WHEN THE SESSION GETS INVALIDATED To use this feature, upgrade HVR on the integrate machine(s). Added support to reconnect to Databricks when the session gets invalidated. [T-766016] ORACLE: ADDED SUPPORT FOR CONFIGURABLE LOB PREFETCH SIZE To use this feature, upgrade HVR on the integrate and capture machine(s). This change allows you to configure the LOB prefetch size for Oracle databases at the session level. The new environment variable HVR_ORA_LOBPREFETCH_SIZE enables setting a prefetch size that applies to all LOB columns (such as CLOB and BLOB) in replicated tables. To maintain the current behavior, avoid modifying the new environment variable, and you will see no changes in your workflow. This change is available for Oracle versions 12.2 and newer. [T-779320] ORACLE: ADDED MULTIPLE CHANNELS READING FROM THE SAME DB To use this feature, upgrade HVR on the capture machine(s). Added multiple channels reading from the same DB [T-810525] ORACLE: OPTIONALLY TREAT PERMISSIONS ERROR ON FILE REMOVING AS A WARNING To use this feature, upgrade HVR on the capture machine(s). Optionally treat permissions error on file removing as a warning to allow capture to continue [T-851665] ORACLE: IMPLEMENT LOB PREFETCHING ON SESSION WIDE LEVEL To use this feature, upgrade HVR on the integrate and capture machine(s). This change allows you to configure the LOB prefetch size for Oracle databases at the session level. The new environment variable HVR_ORA_LOBPREFETCH_SIZE enables setting a prefetch size that applies to all LOB columns (CLOB, BLOB, NCLOB and BFILE) in replicated tables. To maintain the current behavior, avoid modifying the new environment variable, and you will see no changes in your workflow. With this setting on, you'll avoid doing a roundtrip between HVR and your Oracle DB, as long as the LOB object in this specific row is smaller or equal in size (expressed in characters, not bytes) to HVR_ORA_LOBPREFETCH_SIZE. This change is available for Oracle versions 19.0 and newer. PROBLEMS FIXED IN HVR 6.2.0/7 (2025-01-14) ---------------------------------------- [T-689331] FIXED INCORRECT PROCESSING OF HANA UTCL DATATYPE, IMPROVED ERROR HANDLING To fix this bug, upgrade HVR on the capture machine(s). Replace SAP transport files with newest version. Delivers fixes to for T-689331 and T-734793: Fixed incorrect processing of SAP Hana UTCL datatype for Netweaver driver; Correctly sends error reports in case of SQL processing [T-821848] FIX OCCURRENCE OF F_JG2305 DURING CAP_STATE CONVERSION To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where older versions of HVR5 generated a reduced cap_state file with insufficient fields for HVR6, causing the "F_JG2305: Attempt to fetch non-optional elements from a list that already is exhausted" error during cap_state conversion. This fix repairs the cap_state file by populating the missing fields with default values, ensuring compatibility with HVR6. [T-852696] FIXED F_JG20CD DURING SNAPSHOT CREATION To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue affecting snapshot creation on Windows hubs with extended file paths. Previously, zipping the hub content would open excessive file handles, resulting in an F_JG20CD error. This fix resolves the issue by periodically closing and reopening the zip archive after every 100 files. - T-583853 - T-684900 [T-833817] AZURE DATA LAKE STORAGE: FIXED SIGSEGV WITH AZURE FS IN AZURE GOV CLOUD To fix this bug, upgrade HVR on the hub machine(s). A segmentation fault was happening during delete using azure us govenment cloud, now it is fixed. [T-821054] DATABRICKS: FIXED CONSISTENCY ISSUE WHEN USING HVR_STAGING_NULL_INDICATOR To fix this bug, upgrade HVR on the integrate machine(s). The environment variable HVR_STAGING_NULL_INDICATOR can be used to change the null indicator written to the CSV staging file from the default value of "\N". This is useful in cases where the "\N" string is a valid column value in the source. This fix addresses data inconsistencies introduced if the HVR_STAGING_NULL_INDICATOR environment variable is used with a BigQuery or Databricks target. [T-763638] INGRES: FIXED SEGMENTATION VIOLATION ERROR F_JT0287 (F_JG200A) FOR INGRES To fix this bug, upgrade HVR on the integrate machine(s). Resolved the F_JT0287 (F_JG200A) error that occurs when action Restrict with parameter IntegrateCondition is defined for Ingres, which also caused the Integrate job to fail. [T-851006] INGRES: FIX F_JD21B5 ON COMPARE/REFRESH WITH ABSENT COLUMN To fix this bug, upgrade HVR on the hub machine(s). Fix "F_JD21B5 DBMS error [Column ''###'' not found in any specified table]" for Ingres when running compare or refresh on table with absent column properties. [T-644743] ORACLE: FIXED LOG SCAN ERROR WHEN HVR COULD NOT FIND REDO COVERING SCN To fix this bug, upgrade HVR on the capture machine(s). Fixed log scan error when HVR could not find redo covering SCN [T-810525] ORACLE: FIXED DELAYED FILE REMOVING To fix this bug, upgrade HVR on the capture machine(s). Optionally treat file removal permission errors as a warning, allowing capture to continue and retry on subsequent capture cycles to remove archived logs. [T-833193] ORACLE: FIXED STRING FORMATTING THAT CAUSED IDENTIFIER LENGTH OVERFLOW To fix this bug, upgrade HVR on the capture machine(s). Fixed string formatting that caused identifier length overflow [T-834092] ORACLE: FIXED CONNECTION HANDLING FOR RAC WITH SCAN. To fix this bug, upgrade HVR on the capture machine(s). Fixed connection handling for RAC with SCAN. New environment variable was provided to use single connection. [T-834880] ORACLE: REDUCE NUMBER OF ROUNDTRIPS TO ORACLE DB WHILE SELECTING WITH TABLES WITH LOB COLUMNS To fix this bug, upgrade HVR on the integrate and capture machine(s). This change reduces number of roundtrips that HVR makes towards the Oracle DB while extracting LOB columns from an Oracle DB. [T-849129] SAP HANA: FIXED DUPLICATE INDEX NAME ERROR IN ADAPTDDL FOR HANA To fix this bug, upgrade HVR on the capture and agent machine(s). Fixed an issue where adding or removing a column from a HANA source table caused an AdaptDDL error F_JD0215: "cannot use duplicate index name". NEW FEATURES IN HVR 6.2.0/6 (2024-12-17) ---------------------------------------- [T-830301] ADDED RESILIENCE TO UNKNOWN PROPERTIES AFTER DOWNGRADE To use this feature, upgrade HVR on the hub machine(s). After a downgrade of HVR, there may be properties in the repository database or in files on disk. An older version of HVR will throw validation errors on unknown properties. This fix will instead print a warning and ignore them. Since properties are validated in various places, and HVR spawns many processes, many warnings may come out. These are safe to ignore, but are important to log because just ignoring properties may or may not cause further issues. PROBLEMS FIXED IN HVR 6.2.0/6 (2024-12-17) ---------------------------------------- [T-825975] FIX DUPLICATE ROW ERROR F_JD024D DURING INTEGRATION OF KEY CHANGE To fix this bug, upgrade HVR on the integrate machine(s). Fix duplicate row error F_JD024D during integration of multiple resilient key updates. [T-827122] FIXED F_JT1550 CRASH IN ORACLE ASM LOG-BASED CAPTURE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue causing crashes in Oracle ASM log-based capture worker processes. The issue produced errors such as: `Nov 04 04:41:27: hub-cap-src[bc0]: F_JG2166: Unexpected I/O detected on link to parent job process Nov 04 04:41:27: hub-cap-src: F_JT1550: Coprocess 'bc0' terminated with signal 9.` The specific process name 'bcXXX' may vary, but will always start with 'bc', and this fix only applies to such cases. [T-838145] DATABRICKS: FIXED F_JD1202 WHEN USING REFRESH MERGE OPTION WITH DATABRICKS EXTERNAL TABLES To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue that occured when refreshing data into a Databricks table that has an external location, and where the refresh "Merge into Target" option is selected. [T-844400] DATABRICKS: FIXED F_JG2919 THROWN DUE TO A NEGATIVE STRING LENGTH To fix this bug, upgrade HVR on the integrate machine(s). Fixed 'F_JG2919: Encountered internal error while encoding string from' thrown due to a negative length. Note that this change also fixes 'F_JG2228: Unable to allocate' with a very large number of bytes reported. [T-840417] GOOGLE BIGQUERY: FIXED ISSUE WITH BIGQUERY WHEN DATASET AND BUCKET ARE IN MULTI-REGION EU To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where the error "F_JR1779 The BigQuery region 'EU' (from location property Bigquery_Region) is not the same as the discovered region 'eu-west-1' of the Google Cloud Storage" occurred when both the target dataset and the staging bucket were configured in the multi-region "EU". [T-831999] SAP HANA: FIXED FALSE-POSITIVE THROWING F_JZ0A3F WHILE PARSING PARTIAL UPDATES FOR SAP HANA To fix this bug, upgrade HVR on the capture machine(s). Fixed F_JZ0A3F false-positive throwing when partial update has more then 16 Million rows in one transaction. [T-846665] UI: FIXED SNOWFLAKE CLIENT PRIVATE KEY DIRECTORY OPENS IN STAGING DIRECTORY INSTEAD OF HUB DIRECTORY To fix this bug, upgrade HVR on the hub machine(s). Fixed a UI bug where specifying an integrate staging directory on Snowflake caused the "CLIENT PRIVATE KEY" in "Database Connection" to open the integrate staging directory instead of the hub directory. NEW FEATURES IN HVR 6.2.0/5 (2024-12-05) ---------------------------------------- [T-249606] SAP HANA: ADD SUPPORT OF SAP DATA TYPES D16/34N,TIMN,DATN,UTCL FROM SAP DICTIONARIES To use this feature, upgrade HVR on the integrate and capture machine(s). HVR introduced support of SAP HANA datatypes D16/34N,TIMN,DATN,UTCL from SAP Dictionaries. PROBLEMS FIXED IN HVR 6.2.0/5 (2024-12-05) ---------------------------------------- [T-816245] FIXED "TIMESTAMP HAS UNEXPECTED FORMAT" IN HVRSTATS. To fix this bug, upgrade HVR on the hub machine(s). Made hvrstats more resilient against unexpected timestamp formats. Previously, the stats job threw an F_JG231B error: "Timestamp has unexpected format". The fix is to skip processing such lines, adding them to the irregular output lines. [T-817227] FIXED CRASH LIKE F_JT04C6 FOR SOFTDELETE CHANNELS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue with Softdelete pipe injection where Softdelete pipe was injected once per table when customers used table_scope. [T-811598] ORACLE: FIX DELETE ON ORACLE TABLE WITH EXTENDED VARCHAR2 COLUMN To fix this bug, upgrade HVR on the capture machine(s). This fix addressed a corruption on target table when Capture processed a delete operation on Oracle table with extended varchar2 column on a channel with soft-delete. The reason for the corruption is the inclusion of the LOB data header in the extended varchar2 data and the fix detects the extended varchar2 column and excludes the column data from the Delete record. [T-826536] SYBASE ASE: FIXED READING OF PARTIALLY WRITTEN PAGES IN SYBASE BY ADDING CONSISTENCY CHECKS FOR RECORDS. To fix this bug, upgrade HVR on the capture machine(s). Fixed reading of partially written pages in Sybase by adding consistency checks for records. Added two additional checks while reading pages: 1. Page Number Consistency Check When the page number inside any record is higher than the current page number, it is considered a partially written page. The system will retry reading pages up to a maximum number defined by the environment variable `HVR_SY_READ_CORRUPT_PAGE_MAX` (default value: 10, maximum value: 255). If the number of retries reaches the maximum, an error `F_JZ1D02: The indicated page number ...` will be thrown, and the capture job will exit. 1. INSERT/DELETE/INSIND/DOL_INSIND Consistency Check Consistency of the page number and page timestamp within INSERT/DELETE/INSIND/DOL_INSIND operations is checked. If the page number or page timestamp of these operations is greater than the current page number or page timestamp, it is assumed to be a partially written page. Upon the first occurrence, a warning message, `W_JZ1D03: The indicated page number` ... or `W_JZ1D04: The page timestamp in the ...`, will be logged. The capture job will attempt to reread the page up to the maximum number of retries specified by the environment variable HVR_SY_READ_CORRUPT_OPERATION_MAX (default value: 10, maximum value: 255). If the maximum retries are reached without resolution, a warning `W_JZ1D05: Earlier, a record at address (%u, %hu) was encountered with an unexpected page number ...` will be logged, and the capture job will consider it a valid record and continue processing. [T-831523] SYBASE ASE: FIX THE OCCURENCE OF F_JZ270C - AN AFTER OPERATION IS SEEN BEFORE A BEFORE OPERATION To fix this bug, upgrade HVR on the capture machine(s). In some circumstances, UPDATEs to an "All Pages Locked" table will result in a fault similar to the following: `F_JZ270C: The [INSERT] record at (42156,10) will output a [update_after] operation, but the associated [update_before] operation has not been found.` This was due to a bug in identifying when update_before operations were output. As a result of this fix, the fault should no longer be observed. [T-833372] SYBASE ASE: FIXED THE OCCURRENCE OF F_JZ270C - DNOOP IS ALREADY MATCHED To fix this bug, upgrade HVR on the capture machine(s). In a scenario where a transaction affects multiple rows, we were encountering the error `F_JZ2709: The %s record at (%u, %hu)` in the logs. This occurred because the latest `DNOOP` was already matched with the previous `DELETE` record, but the `DNOOP` of the current `DELETE` record had not yet arrived. We mistakenly matched the `DNOOP` of the previous `DELETE` record with the current `DELETE` record. This issue has now been fixed. [T-837327] SYBASE ASE: FIXED THE OCCURRENCE OF F_JZ270A WHEN PAGE NUMBERS ARE REUSED AFTER ROLLING OVER TO OLD NUMBERS. To fix this bug, upgrade HVR on the capture machine(s). Fixed the occurrence of F_JZ270A when page numbers are reused after rolling over to old numbers. In addition, the following errors are now also continuable: `F_JZ0A91`, `F_JZ0A92`, and `F_JZ270A`. [T-833926] UI: FIXED THE REDEFINE BUTTON TO WORK ON VIEWS To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue with the Redefine button on the UI that caused it to fail when used on a database view. NEW FEATURES IN HVR 6.2.0/4 (2024-11-20) ---------------------------------------- [T-775861] DATABRICKS: ADDED SUPPORT FOR BC DATES IN DATABRICKS TIMESTAMP To use this feature, upgrade HVR on the integrate and hub machine(s). This change adds support for BC (Before Christ) dates in the Databricks TIMESTAMP data type. PROBLEMS FIXED IN HVR 6.2.0/4 (2024-11-20) ---------------------------------------- [T-795635] FIXED FALSE DIFFERENCES IN ONLINE COMPARE WITH CUSTOM TASK NAME To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where correct behavior of online compare depended on the compare job using the default task name of "cmp". In some edge cases, compare jobs with custom task names could report incorrect results. [T-821576] FIXED F_JD5E12 (MISSING INPUT ENCODING FOR DATATYPE '106' DATALINK) WHILE RUNNING HVRDATATYPEMAP To fix this bug, upgrade HVR on the hub machine(s). This fixes hvrdatatypemap outputting mapping for data type datalink [T-826502] FIXED SIGSEGV CONDITION DURING CHANNEL ADAPT To fix this bug, upgrade HVR on the hub machine(s). A segmentation fault condition was present in the adapt code. This has been removed. [T-826645] FIXED SPACE IN HVR_HOME CAUSING F_JG057F WITH CONNECTION RESET BY PEER To fix this bug, upgrade HVR on the proxy and agent machine(s). Fixed space in %HVR_HOME% causing F_JG057F: TLS negotiation failed: I/O error occurred: Connection reset by peer. This fix specifically applies to a Connection reset by peer error: - When the customer has an HVR_HOME with whitespace in it - That exposes itself as F_JG057F: TLS negotiation failed, and explicitly not another F_J error code that may have the same underlying Connection reset by peer. [T-830358] FIXED F_JG2459 IN HVRREFRESH AND HVRCOMPARE INVOCATIONS To fix this bug, upgrade HVR on the hub machine(s). Fixes F_JG2459: Get value of variable 'opt_E_is_time' failed. Variable not set. when calling hvrrefresh and hvrcompare on repository databases configured with overridden library environment (e.g. PostgreSQL_Pglib location property) [T-822430] ORACLE: FIXED ADDITIONAL SLASH IN THE FRONT OF THE WINDOWS DIRECTORY NAME To fix this bug, upgrade HVR on the capture machine(s). Fixed additional slash in the front of the windows directory name. [T-816669] SQL SERVER: FIXED F_JD0A3D DURING CAPTURE FROM SQL SERVER To fix this bug, upgrade HVR on the capture machine(s). SQL Server log-based capture may fail with the F_JD0A3D error if one or more of the source tables contain DECIMAL SPARSE columns. This fix addresses the issue. [T-814453] SYBASE ASE: FIXED F_JT0268 IN A TRANSACTION THAT UPDATES MULTIPLE TABLES. To fix this bug, upgrade HVR on the capture machine(s). Fixed `F_JT0268` in a transaction that updates multiple tables. The issue occurred when a transaction affecting multiple tables triggered a special case: only the ROWIMAGE operation with status ZSY_RWI_XSTAT_WRITETEXT and ZSY_RWI_XSTAT_AFTER_IMAGE was logged for the first table, while the second table's operations were logged in the following order: DNOOP, INOOP, DELETE, and finally INSIND. The first ROWIMAGE caused us to emit `UPDATE_BEFORE`. Since we received DNOOP and INOOP for the second table before the DELETE operation, we did not emit anything on DELETE. Then, when INSIND occurred, we mistakenly believed `UPDATE_BEFORE` for this table had already been emitted, so we incorrectly emitted `UPDATE_AFTER`. NEW FEATURES IN HVR 6.2.0/3 (2024-11-05) ---------------------------------------- [T-821955] BUNDLE FIVETRAN PROXY 1.0.21 To use this feature, upgrade HVR on the agent machine(s). Upgraded bundled Fivetran Proxy to 1.0.21 [T-805110] DB2 FOR I: ADDED SUPPORT FOR BINARY DECIMAL PHYSICAL FILE DATA TYPE To use this feature, upgrade HVR on all machine(s). HVR now supports the BINARY DECIMAL (B, BINDEC) data type in Db2 for i. PROBLEMS FIXED IN HVR 6.2.0/3 (2024-11-05) ---------------------------------------- [T-778090] FIX 'TRUNCATE' SUPPORT FOR POSTGRES TIMEKEY TABLES To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where error F_JD2313 was thrown on refresh after a truncate on a timekey channel for Postgres. T-597752 - Fixed a similar issue for Redshift [T-791280] FIXED F_JR0A0E WHEN ACCESSING ENCRYPTED SQL SERVER LOCATIONS To fix this bug, upgrade HVR on the hub machine(s). Fixed F_JR0A0E errors that occurred when accessing encrypted SQL Server locations after upgrading to OpenSSL 3. The issue was caused by missing ciphers that were moved to a legacy module in OpenSSL. This fix now packages the legacy module with HVR, eliminating the dependency on the hub machine having a separate OpenSSL installation. [T-810635] FIX INTEGRATEEXPRESSION NOT POPULATED FOR BEFORE-UPDATE RECORDS FOR SOFTDELETE FILE TARGETS To fix this bug, upgrade HVR on the hub machine(s). Fix IntegrateExpression not populated for before-update records for SoftDelete file targets [T-802234] ORACLE: FIXED PREFIX FOR TEMPORARY FILES TO ALLOW CORRECT AGENTLESS USAGE To fix this bug, upgrade HVR on the capture machine(s). Fixed prefix for temporary files to allow correct agentless usage [T-812112] POSTGRESQL: FIXED F_JZ6227 TEST_DECODING MESSAGE TYPE To fix this bug, upgrade HVR on the capture machine(s). Fixed F_JZ6227 error when it failed to detect the "message" type emitted by `test_decoding` plugin of PostgreSQL logical replication. The hardcoded "message" keyword has been fixed to allow proper detection and handling. [T-819323] SAP HANA: FIXED F_JZ0C0D DURING CAPTURE FROM SAP HANA To fix this bug, upgrade HVR on the capture machine(s). Fxied incorrect calculation expected LOB size. [T-691448] SAP NETWEAVER: FIXED DATATYPE MAPPING FOR THE HANA'S DECIMAL_FLOAT WHEN CONNECTING OVER NETWEAVER To fix this bug, upgrade HVR on the capture machine(s). When connecting to a HANA database over the NetWeaver, all HANA datatypes based on the DECIMAL_FLOAT internal datatype were incorrectly mapped to the HVR's internal datatype 19 (decimal), whereas it should be mapped to the HVR's internal datatype 8 (number). This may later lead to the capture job failing with the F_JZ0A33 error. This fix addresses this issue. [T-690218] SYBASE ASE: ADDED MORE CHECKS TO HELP PREVENT READS OF PARTIALLY WRITTEN LOG PAGES WITH ASE LOG BASED CAPTURE To fix this bug, upgrade HVR on the capture machine(s). Since there is no coordination between Sybase ASE and HVR in the writing and reading of transaction log pages, HVR must perform various checks after reading a page to ensure it is self-consistent and that contents are as expected. Otherwise, HVR risks reading pages which are only partially written. This change introduces more page consistency checking while allowing a configurable number of inconsistencies when re-reading the same page before reporting a fault. This allows an opportunity for a partially written page to become completely written before a fault is reported. The number of re-reads is configurable using environment variable HVR_SY_READ_CORRUPT_PAGE_MAX. [T-710526] SYBASE ASE: FIXED F_JD0AD0 BY NOT MOVING THE TRUNCATION POINT IF THE START_ADDR IS "UNKNOWN" IN ASE To fix this bug, upgrade HVR on the capture machine(s). The truncation point is no longer moved if the start_addr is "unknown" in ASE. This avoids a F_JD0AD0 error being raised in this scenario. [T-717979] SYBASE ASE: ASE DIRECT CAPTURE - SCANNER ENCOUNTERED AFTER BEFORE BEFORE To fix this bug, upgrade HVR on the capture machine(s). NOOP/INOOP/DNOOP transaction log records were mishandled in some instances, causing the following error: `text F_JT0406: Scanner encountered 'after update' before the 'before update' change is ready` A combination of log records being mishandled is illustrated by this example of a single "deferred" UPDATE operation. ```text DNOOP 5373308, 1 (0x0051FD7C, 0x01) 01 01 0c 00 7b fd 51 00 0c 00 00 00 30 00 88 00 00 00 00 00 00 00 00 00 00 00 00 00 b6 e1 d4 5e 00 00 00 00 00 00 00 00 2b 50 39 00 07 00 00 dc NOOP 5373308, 2 (0x0051FD7C, 0x02) 01 02 0a 05 7b fd 51 00 0c 00 00 00 08 01 88 00 00 00 00 00 00 00 00 00 00 00 00 00 b6 e1 d4 5e 00 00 00 00 00 00 00 00 2f 07 4e 4e 58 36 37 30 37 37 20 23 db c3 ff 05 a2 b1 00 00 fa e4 bd 00 41 da c3 ff 05 db 00 4c 4f 41 4e 00 00 00 00 00 00 0c 40 4a 50 4d 34 32 32 30 30 37 45 53 46 53 45 43 9f a5 00 00 00 00 00 00 54 fe fb 05 b5 87 de 5e a9 99 8b 3f 82 b1 00 00 00 00 00 00 a6 b3 00 00 00 00 00 00 00 00 00 94 81 4a 98 41 4d 44 50 46 58 30 58 36 37 30 37 37 ba 49 0c 02 2b 07 10 40 45 53 46 53 45 43 6f 00 82 b1 00 00 00 00 00 00 82 b1 00 00 00 00 00 00 19 fc 08 00 78 00 7b 7c 01 00 4e 23 30 00 ce 02 a7 d2 46 00 63 f1 01 00 30 aa a6 a2 a0 9e 9d 9c 9c 9c 98 96 94 92 8a 82 82 80 7a 72 72 72 72 6c 6a 66 5e 56 56 56 56 56 56 4e 46 46 46 46 46 46 42 42 42 3a 34 2b 2b 23 1f 00 17 42 5f 2a DNOOP 5373308, 3 (0x0051FD7C, 0x03) Same content as DNOOP (5373308,5) 01 03 0c 00 7b fd 51 00 0c 00 00 00 30 00 88 00 00 00 00 00 00 00 00 00 00 00 00 00 b6 e1 d4 5e 00 00 00 00 00 00 00 00 92 ee 38 00 22 00 00 c6 INOOP 5373308, 4 (0x0051FD7C, 0x04) Same content as NOOP (5373308,6), References both DNOOP (5373308,3) and DNOOP (5373308,5) 01 04 0b 05 7b fd 51 00 0c 00 00 00 08 01 88 00 00 00 00 00 00 00 00 00 00 00 00 00 b6 e1 d4 5e 00 00 00 00 00 00 00 00 2f 22 4e 4e 58 36 34 45 30 42 20 23 c5 c1 ff 05 a2 b1 00 00 fa e4 bd 00 41 c4 c1 ff 05 db 00 4c 4f 41 4e 00 00 00 00 00 00 0c 40 4a 50 4d 34 31 33 31 39 35 45 53 46 53 45 43 dd a0 00 00 00 00 00 00 54 fe fb 05 62 23 bd 66 c1 dd b3 3f 82 b1 00 00 00 00 00 00 4e cb 00 00 00 00 00 00 00 00 00 a8 f8 f1 9d 41 4d 44 50 46 58 30 58 36 34 45 30 42 a8 c6 4b 37 89 41 10 40 45 53 46 53 45 43 5c 01 82 b1 00 00 00 00 00 00 82 b1 00 00 00 00 00 00 19 fc 03 00 68 01 63 06 08 00 4e 23 42 00 f7 02 a7 d2 46 00 6c 20 08 00 30 aa a6 a2 a0 9e 9d 9c 9c 9c 98 96 94 92 8a 82 82 80 7a 72 72 72 72 6c 6a 66 5e 56 56 56 56 56 56 4e 46 46 46 46 46 46 42 42 42 3a 34 2b 2b 23 1f 04 4f 06 10 00 DNOOP 5373308, 5 (0x0051FD7C, 0x05) Called out in error message. Same content as DNOOP (5373308,3) 01 05 0c 00 7b fd 51 00 0c 00 00 00 30 00 88 00 00 00 00 00 00 00 00 00 00 00 00 00 b6 e1 d4 5e 00 00 00 00 00 00 00 00 92 ee 38 00 22 00 00 c6 NOOP 5373308, 6 (0x0051FD7C, 0x06) Same content as INOOP (5373308,4) 01 06 0a 05 7b fd 51 00 0c 00 00 00 08 01 88 00 00 00 00 00 00 00 00 00 00 00 00 00 b6 e1 d4 5e 00 00 00 00 00 00 00 00 2f 22 4e 4e 58 36 34 45 30 42 20 23 c5 c1 ff 05 a2 b1 00 00 fa e4 bd 00 41 c4 c1 ff 05 db 00 4c 4f 41 4e 00 00 00 00 00 00 0c 40 4a 50 4d 34 31 33 31 39 35 45 53 46 53 45 43 dd a0 00 00 00 00 00 00 54 fe fb 05 62 23 bd 66 c1 dd b3 3f 82 b1 00 00 00 00 00 00 4e cb 00 00 00 00 00 00 00 00 00 a8 f8 f1 9d 41 4d 44 50 46 58 30 58 36 34 45 30 42 a8 c6 4b 37 89 41 10 40 45 53 46 53 45 43 5c 01 82 b1 00 00 00 00 00 00 82 b1 00 00 00 00 00 00 19 fc 03 00 68 01 63 06 08 00 4e 23 42 00 f7 02 a7 d2 46 00 6c 20 08 00 30 aa a6 a2 a0 9e 9d 9c 9c 9c 98 96 94 92 8a 82 82 80 7a 72 72 72 72 6c 6a 66 5e 56 56 56 56 56 56 4e 46 46 46 46 46 46 42 42 42 3a 34 2b 2b 23 1f 00 00 00 00 00 ``` DNOOPs are to be paired with INOOPs in forming the Before and After images of an UPDATE operation. Prior to this correction, the list of DNOOPs encountered was searched forwards to find a match for a given INOOP. In fact, the matching DNOOP for an INOOP seems always to be the immediately preceding operation so that this list should be searched backwards. In addition, after analysis, it seems that the NOOP records are being used to "cancel" the immediately preceding DNOOP records. Also, not illustrated, the INSIND record has been observed to be used to trigger the output of the Before and After images of a "deferred" UPDATE. Recently it has been shown that an INSERT record may be used instead of the INSIND for that same purpose. HVR now takes these insights into account in its log-scan activities. [T-717979] SYBASE ASE: FIXED FAILING UPDATE TO A PARTITIONED TABLE IN SYBASE ASE To fix this bug, upgrade HVR on the capture machine(s). Fixed failing UPDATE to a partitioned table in Sybase ASE whereby an UPDATE to a row moves it from one partition of the table to another. [T-720493] SYBASE ASE: ASE ARCHIVE LOG CAPTURE - BETTER HANDLING OF UNEXPECTED END-OF-FILE To fix this bug, upgrade HVR on the capture machine(s). When configured to read archived transaction logs, the ASE Capture job is unable to distinguish an archive that has been completely written from one that is in the process of being written. In the later case, the file may appear to be corrupted resulting in a failure message similar to the following: `F_JZ0C16: An unexpected end-of-file is encountered while trying to read 2048 bytes of data at an offset of 16384 bytes from the backup transaction log file 'my_tran_log_archive_1.trn'.` Eventually the job will restart and likely successfully read the archive upon a subsequent try. In an effort to more appropriately report the situation, with this change the capture job will now report a warning message similar to the following: `W_JZ2702: An unexpected end-of-file is encountered while trying to read 2048 bytes of data at an offset of 16384 bytes from the backup transaction log file 'my_tran_log_archive_1.trn'. Assuming a partially written file and will re-read shortly.` The capture job will report this warning for up to 5 times before reporting the failure, at which point the administrator may wish to stop the job and determine whether in fact, the archive file contains some corruption. [T-763583] SYBASE ASE: ASE DIRECT CAPTURE - DELETE RECORD FOR DNOOP RECORD IS NOT FOUND To fix this bug, upgrade HVR on the capture machine(s). INSIND records are used to "tie together" the Before and After images of some kinds of UPDATE operations. INSIND record processing makes adjustments for After images of UPDATEs but fails to account for Before images that may have been earlier produced, particularly when LOBs (and so ROWIMAGE records) are involved. With this change proper adjustments are made when processing INSIND records to account for the Before images of UPDATE operations and the user will no longer experience the error: `text F_JZ270B: The DNOOP record at (,) was expected to be matched to a DELETE record with data page and rowid (,), but that data row was not found.` [T-780679] SYBASE ASE: RESOLVED FAULT IN CAPTURING 'TRUNCATE TABLE PARTITION' OPERATIONS FOR SYBASE ASE To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where Sybase ASE Capture jobs would ignore executions of `truncate table partition` commands. Execution of these commands now correctly force a refresh of the table. It is recommended to check the consistency of any partitioned tables that may have had these commands executed against them. [T-814303] SYBASE ASE: ASE DIRECT CAPTURE - DELETE RECORD FOR DNOOP RECORD IS NOT FOUND To fix this bug, upgrade HVR on the capture machine(s). A further correction on top of T-763583 which better supports deferred UPDATEs when LOB columns are involved. With this change proper adjustments are made when processing DNOOP records to account for the Before images of UPDATE operations when LOBs are involved and the user will no longer experience the error: `text F_JZ270B: The DNOOP record at (,) was expected to be matched to a DELETE record with data page and rowid (,), but that data row was not found.` NEW FEATURES IN HVR 6.2.0/2 (2024-10-22) ---------------------------------------- [T-306320] EXPOSE RESILIENT OPERATIONS IN ONLINE REFRESH. To use this feature, upgrade HVR on the integrate and hub machine(s). Currently we expose only a subset of hvr_ops in the {hvr_op} integrate expression. For tables with ColumnProperties /TimeKey, this can result in apparent duplicate rows. For example, if a row was inserted while an online refresh was executing. By returning the resilient hvr_op codes, the results in the target table can be more easily interpreted. Additionally, the compare function will work correctly with these codes, instead of throwing a 1+1 compare/coalesce error when this situation occurred. To turn on this new behavior, the HVR_EXPR_SUBST_HVR_OP_RESIL environment variable must be set to zero. The default behavior is to return the subset of hvr_ops as before, the user must opt-in to the new behavior with the environment variable. [T-763648] DB2 FOR I: ADDED SUPPORT FOR XML DATA TYPE To use this feature, upgrade HVR on all machine(s). HVR now supports the XML data type in Db2 for i. [T-763650] DB2 FOR I: ADDED SUPPORT FOR ROWID DATA TYPE To use this feature, upgrade HVR on all machine(s). HVR now supports the ROWID data type in Db2 for i. [T-763651] DB2 FOR I: ADDED SUPPORT FOR DATALINK DATA TYPE To use this feature, upgrade HVR on all machine(s). HVR now supports the DATALINK data type in Db2 for i. Note that only the URL is replicated. Any embedded comment is ignored. [T-784052] ORACLE: OPTIMIZED ONE OF THE QUERY USED IN HVRADAPT FOR ORACLE To use this feature, upgrade HVR on the capture machine(s). This improvement optimizes one of the Oracle query used in hvradapt for getting the supplemental logging setting of a list of tables using the HVR_SYS_TAB that could take a considerable amount of time to complete, resulting in a huge delay in adding tables to the channel. PROBLEMS FIXED IN HVR 6.2.0/2 (2024-10-22) ---------------------------------------- [T-784898] FIXED F_JR4328 WHEN IMPORTING CHANNEL WITH ENCRYPTED TDE CERTIFICATES To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where channel import would fail with error F_JR4328 if the channel contained a location with a TDE certificate and was exported using encryption with a transport key. The error was caused by a premature validation of the certificate's private key and is now eliminated by skipping the certificate validation if the private key is encrypted. [T-801179] FIX UNEXPECTED TIMESTAMP FORMAT WRITTEN BY CAPTURE JOB To fix this bug, upgrade HVR on the hub machine(s). Fixed capture writing timestamp in output file without timezone and in unexpected format (missing T). T-602157 [T-805282] FIXED INTEGRATEEXPRESSION PERFORMANCE OF CAST(CURRENT_TIMESTAMP() AS DATETIME) FOR BIGQUERY To fix this bug, upgrade HVR on the hub machine(s). Add `cast(current_timestamp() as datetime)` to the constsqlexpr.pat so whenever `cast(current_timestamp() as datetime)` is used in IntegrateExpression, there will be no performance overhead [T-615210] DB2 FOR I: FIX F_JT0451 PIPE TXGROUP ENCOUNTERED A COMMIT WITH SEQUENCE <= EARLIER SEQUENCE ERROR WITH DST CHANGE ON DB2 FOR I SOURCE WITH DB2I_LOG_JOURNAL_SYSSEQ=TRUE To fix this bug, upgrade HVR on the capture machine(s). When capturing changes from Db2 for i with DB2i_Log_Journal_SysSeq=true, HVR used Db2 for i system sequence numbers to sort changes. Those system sequence numbers are, however, time based which causes problems when switching from summer time to winter time. HVR, therefore, will no longer use system sequence numbers to sort captured changes. Another way to sort captured changes will be used instead. That also allows handling of sequence number resets. [T-793972] DB2 FOR I: DB2 FOR I BY DEFAULT CAPTURES ALL MEMBERS BUT SETTING HVR_DB2I_MULTI_MEMBER_ALL=0 CAPTURES ONLY FIRST MEMBER To fix this bug, upgrade HVR on the capture machine(s). By default all members from DB2 for i multi-member files are captured. But setting environment variable HVR_DB2I_MULTI_MEMBER_ALL to 0 will lead to only first member being captured. Note that if HVR_DB2I_MULTI_MEMBER_ALL is set to 0 and tables which are in the channel are removed from the source database, then those tables should also be removed from the channel, otherwise the capture job will fail. [T-785500] KAFKA: FIXED REGRESSION "TARGET UNKNOWN (0X80090303)" WHILE USING KERBEROS AUTHENTICATION ON WINDOWS PLATFORM To fix this bug, upgrade HVR on the integrate machine(s). Fixed "Target unknown (0x80090303)" while using Kerberos Authentication on Windows platform: - librdkafka used for communication with Kafka broker is rebuilt to correctly use UNICODE versions of SSPI WinAPI [T-790201] ORACLE: FIXED REGRESSION IN HANDLING REMOVED FILES WHEN SCANNING ARCHIVES To fix this bug, upgrade HVR on the capture machine(s). Fixed regression in handling removed files when scanning archives [T-597752] REDSHIFT: FIXED TRUNCATE SUPPORT FOR TIMEKEY TABLES To fix this bug, upgrade HVR on the integrate machine(s). Redshift ODBC driver incorrectly reports not-null columns to be nullable. Then, HVR tries to insert nulls into these columns which results in error. In particular, this happens while replicating a 'truncate' statement on source table to target TimeKey table. [T-802201] SAP HANA: FIXED PROVIDING EMPTY CONFIGURATION PARAMETER VALUE FOR SAP HANA HDBBACKINT UTULITY To fix this bug, upgrade HVR on the capture machine(s). In case of using Microsoft backint implementataion (MSAWB) 'log_backup_parameter_file' value is not set in SAP Hana configuration. HVR ignores to use '-p' option for hdbbackint application if value is not provided neither in SAP Hana database nor in location configuration. [T-739543] SQL SERVER: FIXED SQL SERVER CAPTURE REWIND TO THE OLDEST TX WHEN SOME TABLES ARE NOT IN THE DEFAULT SCHEMA To fix this bug, upgrade HVR on the capture and hub machine(s). When looking for the beginning of the oldest running transaction on SQL Server, HVR only considers transactions that hold a lock on one of the tables in the channel. Due to a bug, owever, only tables in the source database's default schema were considered. This fix addresses the issue. The issue affects Activate with the "Rewind to Start of Source Databases' Oldest Transaction" option and Online Refresh with "Changes before refresh are skipped by both capture or integrate jobs" option. [T-798206] SNOWFLAKE: FIXED LEAKING OF EXPIRED CREDENTIALS TO LOG FILE To fix this bug, upgrade HVR on the integrate machine(s). Fixed an issue where expired credentials are leaked into the logs. All credentials are now redacted when logging erroneous SQL queries. [T-743384] SYBASE ASE: MORE THOROUGHLY CHECK FOR CONSISTENCY OF PAGES IN SYBASE TO AVOID READING PARTIALLY WRITTEN PAGES To fix this bug, upgrade HVR on the capture machine(s). In this change, Sybase transaction log pages are more thoroughly checked for consistency to avoid reading partially written pages. Two additional checks have been introduced while reading pages: 1. Page Number Consistency Check When the page number inside the `BEGIN` operation is not consistent with the page number in the header, a warning `W_JZ1D02: The indicated page number ...` will be logged. The system will retry reading pages up to a maximum number defined by the environment variable `HVR_SY_READ_CORRUPT_PAGE_MAX` (default value is 10, maximum value is 255). If the number of retries reaches the maximum, an error `F_JZ1D02: The indicated page number ...` will be thrown, and the capture job will exit. 1. Timestamp Regression Check Consistency of timestamps read from the logs is checked. If a timestamp regression is encountered (i.e., a new timestamp is older than a previously seen timestamp), it is assumed to be a partially written page. Upon the first occurrence, a warning `W_JZ1D00: Encountered a timestamp regression at address ...` will be printed. The capture job will retry reading the page up to the maximum number specified by the environment variable `HVR_SY_READ_TSTAMP_REGRESSION_MAX` (default value is 10, maximum value is 255). If the timestamp regression is resolved during the retries, a message `Earlier, a timestamp regression was encountered at address (%u,%hu), but it has been resolved ...` will be printed. If the maximum number of retries is reached without resolution, a warning `W_JZ1D01: Earlier, a timestamp regression was encountered at address (%u,%hu). It was not resolved after ...` will be logged, and the capture will assume it is a correct record and continue processing. [T-782731] SYBASE ASE: FIXED INFINITE LOOP ON W_JZ1D00/W_JZ1D01 WARNINGS To fix this bug, upgrade HVR on the capture machine(s). Fixed infinite loop on W_JZ1D00/W_JZ1D01 warnings, which occurred during a sanity check of a page in Sybase ASE when multiple records on the page had timestamps earlier than the current timestamp. [T-799532] SYBASE ASE: FIXED CAPTURE LOG FLOODING CAUSED BY W_JZ1D00, W_JZ1D01, AND W_JZ1D02 WARNINGS To fix this bug, upgrade HVR on the capture machine(s). Fixed capture log flooding caused by W_JZ1D00, W_JZ1D01, and W_JZ1D02 warnings. NEW FEATURES IN HVR 6.2.0/1 (2024-10-08) ---------------------------------------- [T-801413] UPGRADED BUNDLED FIVETRAN PROXY TO 1.0.20 To use this feature, upgrade HVR on the agent machine(s). Upgraded bundled Fivetran Proxy to 1.0.20 [T-732012] MARIADB: ADDED SUPPORT FOR MARIADB VERSIONS 10.5, 10.6 AND 10.11 To use this feature, upgrade HVR on the integrate, capture and hub machine(s). Added support for MariaDB versions 10.5, 10.6 and 10.11. Dropped support for MariaDB versions 10.0, 10.1 and 10.2. PROBLEMS FIXED IN HVR 6.2.0/1 (2024-10-08) ---------------------------------------- [T-766320] REMOVED REDUNDANT LOG MESSAGES FROM MERGE REFRESH To fix this bug, upgrade HVR on the integrate machine(s). Fixed some confusing log messages in merge refresh jobs. One redundant message was removed, and in another message a section was removed in case we don't have data to show there. [T-778063] FIXED RESILIENT INTEGRATE OF NON-KEY COLUMNS WHEN A ROW WAS DELETED AND THEN INSERTED WITH THE SAME KEY To fix this bug, upgrade HVR on the integrate machine(s). Fixed resilient integrate of non-key columns when a row was deleted and then inserted with the same key. See also T-679974, which resolved this case only for key columns. [T-791278] FIXED ERROR F_JG2142 WHEN REPLICATING FROM SAP HANA To fix this bug, upgrade HVR on the integrate machine(s). Fixed error F_JG2142 when performing a DELETE operation during replication from SAP HANA. [T-794592] FIXED F_JR032D DURING HVRDEFINITIONIMPORT FOR CASE-INSENSITIVE ACTION NAMES To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue where error F_JR032D could be triggered during hvrdefinitionimport if the action name was correct but the case did not match. This could only occur when users manually created definition JSON data or migrated manually edited HVR 5 hub database. It is recommended to use canonical ActionName capitalization when creating a definition JSON or to sanitize JSON data migrated from a manually edited HVR 5 hub. [T-777038] DB2 FOR LINUX, UNIX AND WINDOWS: FIXED F_JD21B5 SQL0206N "TYPE" IS NOT VALID FOR TIME AND DATE COLUMNS WITH A DEFAULT DEFAULT To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue appearing during HVR activate with error code F_JD21B5 SQL0206N "TYPE" is not valid. This can happen for TIME and DATE columns with a default value of DEFAULT. [T-793790] DB2 FOR Z/OS: FIXED MEMORY LEAK DURING HVR ADAPT To fix this bug, upgrade HVR on the integrate and capture machine(s). This fix addresses a memory leak during HVR Adapt with Db2 for z/OS [T-597336] GREENPLUM: FIXED NOT CHECKING FOR DATATYPE CHANGES IN BURST AND STAGING TABLES To fix this bug, upgrade HVR on the integrate machine(s). Watch for datatype changes in burst and staging table columns for Greenplum. Before the fix, only the column names were checked. Update the corresponding trace message. [T-752812] ORACLE: IMPROVED HANDLING OF REMOVED FILES WHEN SEARCHING ARCHIVES To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue when removed files present in v$archived_log view. This fix ensures that removed and not archived files will be filtered out and will not cause an error during capture. [T-761689] ORACLE: FIX FAILURE IN CONNECTING TO A NON-ACTIVE ORACLE DATA GUARD INSTANCE To fix this bug, upgrade HVR on the hub machine(s). This fix addressed a failure in capturing from a non-active Oracle Data Guard physical standby instance, which requires a sysdba privilege. The issue was introduced by T-632414 [T-690300] SAP HANA: FIXED F_JD2288 WHILE PROCESSING OF HANA NATIVE DATATYPES DATE/TIME/TIMESTAMP To fix this bug, upgrade HVR on the integrate, capture and hub machine(s). Fixed getting trucated data from SAP Hana database like '0001-01-0'. Occured only if there are any LOB column in table definition. Correctly recognize SAP Time format 'HHMMSS' as a time. Correctly recognize SAP UTC Timstamp format 'YYYYMMDDHHMMSSsssssssss" as a timestamp [T-775324] SAP HANA: FIXED F_JZ0A4D AND F_JZ0A4E WHILE SEARCHING FOR HANA LOG BACKUPS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where the capture from HANA may fail with F_JZ0A4D or F_JZ0A4E. When searching for a HANA log backup, capture job checks backup catalog, primary location and alternate location in order. When a suitable log backup is not found but a newer than needed backup is found instead, capture job may have failed with either F_JZ0A4D or F_JZ0A4E error code prematurely before checking the other locations. [T-793953] SQL SERVER: FIX CONNECTING TO AZURE SQL SERVER VIA OAUTH2 To fix this bug, upgrade HVR on the integrate and hub machine(s). Fixed an issue where HVR could fail with error F_JD21AE when attempting to connect to an Azure SQL Server using access tokens provided by OAuth2 authentication, due to incorrectly passing those credentials. Users facing either 'Login failed for user `` or `SPI Provider: No Kerberos credentials available` errors when connecting to an Azure SQL Server using OAuth2 authentication should upgrade to this version to resolve the issue. NEW FEATURES IN HVR 6.2.0/0 (2024-09-25) ---------------------------------------- [T-763647] DB2 FOR I: ADDED SUPPORT FOR BOOLEAN DATA TYPE IN DB2 FOR I To use this feature, upgrade HVR on all machine(s). HVR now supports the BOOLEAN data type in Db2 for i. Note that some older Db2 for i ODBC drivers have limitations in describing BOOLEAN columns. As a result, HVR will coerce source data to CHAR(1) instead of BOOLEAN. Integrate will still work properly when the source data contains only valid BOOLEAN values, but it may result in: - integer values other than 0 or 1 get silently converted to 1. - a Db2 for i error "SQL0402" for non-integer values. Defining action TableProperties with CoerceErrorPolicy cannot prevent this behavior. [T-777706] POSTGRESQL: DROP SUPPORT FOR POSTGRESQL 9.4 To use this feature, upgrade HVR on all machine(s). This change removes support for PostgreSQL 9.4. PROBLEMS FIXED IN HVR 6.2.0/0 (2024-09-25) ---------------------------------------- [T-752851] FIXED CHANNEL ACTIVATION FAILING WITH F_JR0923 To fix this bug, upgrade HVR on the hub machine(s). Fixed channel activation failing with F_JR0923 even though ColumnProperties with parameter ExpressionScope has parameter Context set, since the Context should only affect refresh/compare, activation shouldn't have been impacted. This fix ensure that context is always considered during the activation checks for ExpressionScope. [T-755955] FIXED F_JX0021 IN SLACK ALERTS CAUSED BY IMPROPER ESCAPING To fix this bug, upgrade HVR on the hub machine(s). Fixed a bug in HVR Slack alerts. In a rare edge case, if the alert was truncated in such a way that left it ending with a backslash, it caused an F_JX0021 error. In addition, the system would fail in creating an event for the alert error because of bad escaping for backslashes and double quotes. This fixes both those problems. [T-761882] FIXED F_JT0D2C WHEN USING OPT-IN BEFORE IMAGE FOR SAP UNPACK To fix this bug, upgrade HVR on the integrate machine(s). Fixed `F_JT0D2C` when using opt-in before image for SAP unpack. Only applies for opt-in cases where `$HVR_SAP_UNPACK_USE_BEFORE` is set. Fixed the sorting of update pairs such that they are kept together when double sorting in some SAP unpack scenarios. [T-762287] IMPROVED DATA COMPARE WITH BOUNDARY SLICING FOR NON-NULLABLE DATATYPE To fix this bug, upgrade HVR on the hub machine(s). Fixed an issue the query of the last slice for data compare with range slicing did try to match for NULL values in its where clause for columns that where non-nullable. For some databases this lead to a full table scan. Now we do not match for NULL values for columns that are not nullable according to the channel definition. If the source database has a nullable key column, and the column is not nullable in the channel definition, the NULL key will now no longer be in any slice when using boundary slicing. [T-776910] FIXED THE DATA TYPE OF HVR_CAP_LOC COLUMN IN HISTORY TABLE To fix this bug, upgrade HVR on the hub machine(s). Fixed history table having hvr_cap_loc column as varchar(5) while it should have it as varchar(12) [T-784478] FIXED BURST TABLES IN CUSTOM SCHEMA ON ORACLE TARGET NOT DROPPING ON DEACTIVATE To fix this bug, upgrade HVR on the integrate machine(s). Fixed burst tables in custom schema on Oracle target not dropping on deactivate [T-784570] FIXED FAILING INTEGRATE ON MYSQL TARGET WITH CUSTOM BURST TABLE SCHEMA DEFINED To fix this bug, upgrade HVR on the integrate machine(s). Fixed failing integrate on MySQL target with Burst integrate and custom burst table schema defined. [T-778939] INGRES: FIXED F_JZ220A IN CASE OF UNEXPECTED TIMESTAMP To fix this bug, upgrade HVR on the capture machine(s). Implemented ZIZ_INGRES_Y2K38_USE_32BIT_TIMESTAMP to fix Ingres F_JZ220A in case of unexpected timestamp. This environment variable is used to choose either to ignore or not ignore the higher 4 bytes in the 8-byte timestamp value captured from Ingres log file. In case of ignore the date is limited by 2038 year. [T-597251] ORACLE: FIXED INVALID DATE WHILE TRYING TO CONVERT DATE TO NUMBER To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where HVR exception `F_JD20D7: Invalid date encountered while trying to convert date to number of seconds since 01.01.1970 for column` was thrown from an automated test. Issue is fixed now. Issue was introduced by: T-564881 [T-738837] ORACLE: IMPROVED ORACLE CHANGE CAPTURE FOR UNDO CHAINING To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where Oracle log parsing encountered the error - "F_JZ1122: Chained undo change vector does not have enough structures." This fix allows multiple undo segments to be collated, split blocks to be merged between segments, and ensures proper handling of straddling undo segments. Additionally, the `hvrlogdump` output is now consistent with Oracle's native dumping format. [T-767763] POSTGRESQL: ENHANCED ERROR REPORTING FOR DATABASE SUB-TRANSACTIONS To fix this bug, upgrade HVR on all machine(s). HVR could previously report an F_JD22D4 error without any accompanying details when it occurred within a database sub-transaction. This fix ensures that relevant error details are now included. [T-774367] POSTGRESQL: FIXED ENDING CYCLES IN THE BEGINNING OF CAPTURE To fix this bug, upgrade HVR on the capture machine(s). HVR PostgreSQL capture could fail to end the capture cycles when `HVR_PQ_STREAMING_REPLICATION_RESTART_AT_END_OF_WAL` is `1` which is currently the default for PostgreSQL versions below 16. This change fixes the problem. [T-779065] POSTGRESQL: FIXED ERROR F_JT0921 WHEN ADDING VIEWS TO CHANNEL To fix this bug, upgrade HVR on the hub machine(s). Fixed error F_JT0921 when adding views or materialized views to channel from PostgreSQL. This could be reproduced both on UI and CLI. [T-735358] SQL SERVER: FIXED MSSQL F_JD0A0E ERROR WHEN CAPTURING UPDATE TRANSACTIONS To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue where HVR could fail with error F_JD0A0E when capturing updates for LOB columns, even though those updates had been correctly integrated on the target during a prior capture cycle. [T-717979] SYBASE ASE: FIXED ERROR F_JT0406 WITH TRANSACTION LOG RECORD HANDLING To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue with the handling and pairing of NOOP, INOOP, and DNOOP transaction log records, which are used to form the before and after images of an UPDATE operation. Previously, mishandling these records in some instances caused the following error - "Error Code: F_JT0406 - Scanner encountered 'after update' before the 'before update' change is ready". The fix ensures that DNOOP records are correctly matched by searching backward for their corresponding INOOP records. Additionally, NOOP records are handled properly, canceling the preceding DNOOP records as expected. [T-763583] SYBASE ASE: FIXED ERROR F_JZ270B WHERE THE DELETE RECORD FOR DNOOP WAS NOT FOUND To fix this bug, upgrade HVR on the capture machine(s). Fixed an issue with INSIND record processing during Direct capture, which made adjustments only for After images of UPDATEs and failed to account for Before images that might have been produced earlier, particularly with LOBs and ROWIMAGE records. This issue caused the following error - "F_JZ270B: The DNOOP record at (,) was expected to be matched to a DELETE record with data page and rowid (,), but that data row was not found." This fix ensures that proper adjustments are now made for Before images of UPDATE operations. [T-775721] SYBASE ASE: FIXED REFRESH JOB FOR SYBASE TARGETS WITHOUT CASE-SENSITIVE NAMES. To fix this bug, upgrade HVR on the integrate machine(s). The `Refresh` job was failing for sources with Case-Sensitive Names enabled, and Sybase targets without Case-Sensitive Names. [T-757389] UI: FIXED MANAGED SECRETS OPERATION ON WINDOWS To fix this bug, upgrade HVR on the hub machine(s). Fixed Managed Secrets to use hvrmanagedpassword.bat script name on Windows. [T-775030] UI: FIXED UNEXPECTED ENVIRONMENT ACTIONS APPLIED IN TABLE SELECTION UI To fix this bug, upgrade HVR on the hub machine(s). Fixed unexpected Environment actions being applied when browsing DB schemas on table selection in UI, by passing channel name to the REST API. [T-777475] UI: FIXED REFRESH/COMPARE DIFFERENCE VIEWING PERMISSION REQUIREMENTS To fix this bug, upgrade HVR on the hub machine(s). Changed permission requirements from ReadExecRefresh to ReadExec for querying refresh/compare differences, as compare can be performed by a ReadExec user. [T-779939] UI: FIXED ALERTS NOT SAVING SMTP "SPECIFIC PORT" To fix this bug, upgrade HVR on the hub machine(s). An alert option "Specific Port" under "Advanced SMTP Configuration" section in UI could be cleared (removed, which also means resetting to the default value), if "Advanced SMTP Configuration" section is collapsed. This has been fixed.