Release Notes HVR Version 5.3.0/25 (linux_glibc2.5-x64-64bit) 2019-02-25 COMPATIBILITY FOR PLATFORM LINUX_GLIBC2.5-X64-64BIT --------------------------------------------------- - Operating System: Linux (x86 64 bit) based on GLIBC 2.5 and higher. - Operating System: Red Hat Enterprise Server version 5 and higher - Operating System: SuSE Enterprise Server version 10.0 and higher This release contains 64-bit executables which will not run on a 32-bit Linux machine. - Ingres: 64-bit (a64.lnx) version 9.1, 9.2, 9.3, 10.0, 10.1, 10.2 and 11.0 X100 tables are not supported - Vector: version 2.x and 3.0 as hub and target, not capture - Vector Hadoop Edition: version 4.x as hub and target, not capture - Oracle: version 11.1, 11.2, 12,1 and 12.2, Exadata - DB2 on Linux, Unix, Windows: version 9.7 and 10.5. - DB2 for i: version 7.1 and 7.2 Requires ODBC driver manager UnixODBC 2.3.1 Requires IBM i Access Client Solutions ODBC Driver 64-bit - PostgreSQL: version 9.4, 9.5, 9.6 and 10 PostgreSQL: version 8.x, 9.0 - 9.3 as target and hub, not capture XtremeData dbX 1.x as target and hub, not capture Requires PostgreSQL 9 or 10 client (libpq.so.5 and its dependencies) - MySQL: version 5.6 and 5.7 as target and hub, not capture MariaDB: version 10.0, 10.1 and 10.2 as target and hub, not capture Requires MariaDB Connector/C 3.0.2 client (libmariadb.so.3 and dependencies) - Snowflake: version 2.x as target, but not hub or capture Requires ODBC driver manager UnixODBC 2.3.1 or 2.3.2 Requires Snowflake ODBC driver 2.13.20 or higher - HANA: version 1.0 SPS 11 and 12, and version 2.0 SPS 0, SPS 1 and SPS 2 as capture and target, but not hub Requires ODBC driver manager UnixODBC 2.3.2 Requires HANA ODBC driver 1.00.110 or 1.00.120 - Teradata: version 14.x, 15.x and 16.x, as target and hub, not capture Requires Teradata ODBC driver 16.10 or 15.00 Requires TTU 16.10 or 15.00 libraries - Greenplum: version 4.0, 4.2, 4.3, 5.5 and 5.10 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. - Redshift: version 1.0.x, as target, not as capture or hub. Requires ODBC driver manager UnixODBC 2.3.0. Requires Amazon Redshift driver 1.2.6.1006-1 - File replication: local, FTP/FTPS and SFTP - Apache Hadoop HDFS: version 2.2.0 and above HVR needs Hadoop 2.4+ libraries and Java 7 on its local machine to access HDFS (Java 8 if Hadoop 3.0.0alpha1 or later). 'hadoop' command must be in $PATH or Hadoop home must have been configured via one of the following environment variables: $HADOOP_COMMON_HOME, $HADOOP_HOME, $HADOOP_PREFIX. - Apache Hive: version 1.2.*, 2.1.*, 2.2.* and 2.3.*. HVR can create Hive external tables above its S3 or HDFS files, so it can compare their contents with source tables' contents. HVR can also deliver changes into Hive ACID tables as a target location for its refresh and integration. Capture from Hive and hub database in Hive are not supported. External tables only supports deserialization of the following file formats CSV, AVRO, JSON (from Hive 2.2) and Parquet. Delivery of changes into Hive ACID tables for Hive versions before 2.3 is only supported with action ColumnProperties/TimeKey. By default HVR connects to Hive using Amazon ODBC driver 1.1.1. Other ODBC drivers namely HortonWorks ODBC driver 2.1.7 (and above) or Cloudera ODBC driver 2.5.12 (and above) can also be configured but environment variable HVR_ODBC_CONNECT_STRING_DRIVER must be configured. Example: HVR_ODBC_CONNECT_STRING_DRIVER="HortonWorks Hive ODBC Driver 64-bit" - Apache Kafka: version 0.8 and above (including 0.11) - Apache HBase: version 1.1, 1.2 and 1.3 - WebDAV/Sharepoint: version 2010 and Online - S3: supported - Salesforce: supported - HVR user interface: native GUI (X client), remote GUI or command-line Native GUI requires X11 client libraries (libX11, libXext, libXrender), font rendering libraries libfontconfig and libfreetype. - Perl 5.6 or higher (only needed for hub machine and hvrlogrelease). INSTALLING AN HVR UPGRADE ------------------------- Previously HVR had a concept of 'upgrade type', which is no longer used. Often all machine are upgraded at the same time. All supported HVR versions are fully compatible with each other; 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, GUI machine, remote capture or target). 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 GUI and/or 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. - SQL Server Log based capture is supported for SQL Server 2005, 2008, 2012, 2014, 2016 and 2017. Data Compression is supported. Capture from compressed backup transaction log files is supported. Encryption is not supported. Capture from memory optimized tables is not supported. - DB2 on Linux, Unix, Windows (LUW) Log based capture is supported for DB2 on Linux, Unix, Windows (LUW) DDL replication (using action AdaptDDL) is not supported. 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 DDL replication (using action AdaptDDL) is not supported. - PostgreSQL Log based capture is supported for PostgreSQL 9.4, 9.5, 9.6 and 10. Capture of TRUNCATE is not supported. When capturing via the SQL interface (/LogMethod=SQL) bi-directional replication is not supported because replicated changes will re-captured and replicated back. When capturing via the SQL interface (/LogMethod=SQL) versions before 9.4.12 should be avoided due to a PostgreSQL bug (detected in 9.4.6) which affected this HVR feature. DDL replication (using action AdaptDDL) is not supported. - HANA Log based capture is supported on Linux (not Windows) for HANA: version 1.0 SPS 11 and 12, and version 2.0 SPS 0, SPS 1 and SPS 2 Only column-store tables are supported (no row-store tables). Capture of TRUNCATE is not supported. Capture of LOB datatypes is not supported. DDL replication (using action AdaptDDL) is not supported. 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 1.0.2o On UNIX, HVR's encryption will attempt to exploit the entropy (randomness) generation capability supplied by the '/dev/urandom' device. For optimal security, it is recommended that this Operating System option is installed, especially on the machine used to generate public/private key pairs CREDITS ------- - HVR uses icons from the "Silk Icon" set by Mark James (www.famfamfam.com). - HVR uses libcurl (curl.haxx.se). Copyright (c) 1996 - 2011, Daniel Stenberg, . - HVR uses code from Unicode Inc. Copyright (c) 1991-2013 Unicode, Inc. - HVR has support for Hadoop: This product includes software developed by The Apache Software Foundation (http://www.apache.org/). - HVR uses code from PostgreSQL. Copyright (c) 1998-2014, PostgreSQL Global Development Group In no event shall PostgreSQL Global Development Group be liable to any party for direct, indirect, special, incidental, or consequential damages, including lost profits, arising out of the use of this software and its documentation, even if $organisation has been advised of the possibility of such damage. PostgreSQL Global Development Group specifically disclaims any warranties, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. the software provided hereunder is on an "as is" basis, and PostgreSQL Global Development Group has no obligations to provide maintenance, support, updates, enhancements, or modifications. PROBLEMS FIXED IN HVR 5.3.0/25 (2019-02-25) ------------------------------------------- [HVR-6417] FIXED ORPHANED TEMP FILES IN HVR_TMP/ OR HVR_CONFIG/TMP// ARE NOT REMOVED BY FUTURE PROCESSES: To fix this bug, upgrade HVR on the capture and integrate machine(s). PROBLEMS FIXED IN HVR 5.3.0/24 (2019-01-24) ------------------------------------------- [HVR-6609] FIXED LOB CORRUPTION WHEN CAPTURE /COALESCE IS CONFIGURED: To fix this bug, upgrade HVR on the capture machine(s). [HVR-6625] FIXED LISTEN(2) BACKLOG PARAMETER IS SET TO 5 AND SHOULD BE INCREASED: To fix this bug, upgrade HVR on all machine(s). [HVR-6603] FIXED MISSING UPDATES WITH INTEGRATE /BURST WHEN A KEY IS DELETED AND RE-INSERTED IN THE SAME CYCLE: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.3.0/23 (2018-11-26) ----------------------------------------- [HVR-6108] ORACLE LBC: FORBID GENERATING ENROLL IF RAC WORKS IN NOARCHIVELOG MODE: To use this feature, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 5.3.0/23 (2018-11-26) ------------------------------------------- [HVR-6547] FIXED F_JD0A6A DURING CAPTURE FROM COMPRESSED SQL SERVER TRANSACTION LOG BACKUP FILES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-6290] FIXED F_JT0527 RACE CONDITION DURING BURST INTEGRATE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5666] FIXED NUMBER OF RETRIES BEING ALWAYS RESET TO 0 FOR FILE CAPTURE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-6149] HVR STOPPED EMITTING TRANSACTIONS WITH EMPTY CAPTURE CYCLES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5577] ORACLE LBC FAILS WITH F_JZ1137 WHEN REDO THREAD IS RE-ENABLED: To fix this bug, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 5.3.0/22 (2018-09-10) ------------------------------------------- [HVR-5987] FIXED HVRSCHEDULER MIGHT FAIL TO PROTECT ITSELF FROM STARTING TWICE: To fix this bug, upgrade HVR on the hub machine(s). PROBLEMS FIXED IN HVR 5.3.0/21 (2018-08-31) ------------------------------------------- [HVR-5914] F_JD0A3B: UNEXPECTED VALUE IN THE COLUMN LENGTH ARRAY WHILE SCANNING COLUMN IN A COMPRESSED RECORD: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5880] FIXED F_JT0527 WHEN REUSING A KEY WITH A KEY-UPDATE DURING BURST: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5625] FIXED HUB FINGERPRINT ON AMAZON EC2 MIGHT BE REPORTED INCORRECT ON C5/M5 INSTANCES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-5947] FIXED SOME EC2 INSTANCES CANNOT RESOLVE DNS 'INSTANCE-DATA' FOR IAM/EC2 ROLES: F_JG2912, F_JG290F: To fix this bug, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.3.0/20 (2018-08-10) ------------------------------------------- [HVR-5809] F_JZ1500. UNEXPECTED END OF FILE ENCOUNTERED WHILE READING ORACLE REDO LOGFILE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5430] FIXED HANGING HVR INITIALIZE WHILE EXECUTING SUPPLEMENTAL LOGGING FOR DB2 *LUW) BY ONLY RUNNING REORG AFTER ALTER TABLE WHEN DB2 SUGGEST IT AND ENVIRONMENT VARIABLE HVR_DB2_ALTER_TABLE_REORG_ENABLE IS SET TO 1: To fix this bug, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 5.3.0/19 (2018-08-06) ------------------------------------------- [HVR-5658] FIXED F_JD022F UNEXPECTED DATATYPE '6' WITH LENGTH '0' ENCOUNTERED WHEN USING HVR COMPARE/REFRESH IN COMBINATION WITH COLUMNPROPERTIES /ABSENT WITH MYSQL/MARIADB: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-5679] FIXED F_JD22A1: COLUMN 'BUR_.HVR_OP' DOES NOT EXIST FOR TERADATA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4827] FIXED F_JZ1126: ORACLE RAC: ALL THREADS ARE DEAD: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5722] IMPROVED PERFORMANCE OF RESILIENT INTEGRATE INTO POSTGRESQL TABLES WHICH DO NOT HAVE A PRIMARY OR UNIQUE KEY: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5620] ORACLE LBC F_JD2420: DATA VALUE IN LOG RECORD COLUMN X (ORACLE ID X AND DATATYPE VARCHAR2) IS TOO LARGE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5324] UPGRADED ZLIB, LIBXML2, OPENSSL, LIBSSH2 AND CURL ON ALL PLATFORMS: To fix this bug, upgrade HVR on all machine(s). PROBLEMS FIXED IN HVR 5.3.0/18 (2018-07-04) ------------------------------------------- [HVR-5524] FIXED INTEGRATE /DBPROC SWAPPING BYTE ORDER OF INGRES AND ORACLE NCHAR/NVARCHAR DATA TYPES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5517] FIXED INTEGRATE /DBPROC SWAPPING BYTE ORDER OF SQL SERVER NCHAR/NVARCHAR DATA TYPES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5525] FIXED ORACLE LBC F_JZ1125: UNKNOWN THREAD X WITH SEQUENCE Y HAS BEEN ENABLED ON BIGENDIAN PLATFORMS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5497] FIXED SIGSEGV DURING LOADING DATA WITH BOTH TEXT/BLOB AND MEDIUMINT COLUMNS: To fix this bug, upgrade HVR on all machine(s). [HVR-2651] FIXED TABLE EXPLORE RETURNING INCORRECT LENGTH FOR LARGE REDSHIFT VARCHARS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5571] FIXED BURST INTEGRATE F_JD292C MULTIPLE UPDATES ERROR: To fix this bug, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.3.0/17 (2018-06-14) ------------------------------------------- [HVR-5523] FIXED MISSING COLUMNS DURING BURST INTEGRATE OF RESILIENT UPDATE CONVERTED INTO AN INSERT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5495] FIXED REMOTE ERROR MESSAGES MIGHT BE LOST WITH F_JG2199: SSL_WRITE FAILED: To fix this bug, upgrade HVR on the remote machine(s). PROBLEMS FIXED IN HVR 5.3.0/16 (2018-06-08) ------------------------------------------- [HVR-5298] FIXED ORACLE LBC F_JD2424: MISSING VALUE FOUND WHILE COMPARING COLUMN '' OF TABLE '' WITH ANOTHER VALUE FOR THE SAME COLUMN/TABLE: To fix this bug, upgrade HVR on the capture machine(s). NEW FEATURES IN HVR 5.3.0/15 (2018-06-07) ----------------------------------------- [HVR-5493] ALLOW USE OF 'LOCALHOST' AS MYSQL NODE NAME: To use this feature, upgrade HVR on all machine(s). PROBLEMS FIXED IN HVR 5.3.0/15 (2018-06-07) ------------------------------------------- [HVR-5499] CAPTURE FROM SQL SERVER USING DIRECT LOG READ METHOD HANGS OCCASIONALLY WHEN VLF SIZE EXCEEDS 4GB: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5475] FIXED ERROR MESSAGES MIGHT BE LOST ON WINDOWS F_JT04A5: COPROCESS HAS EXITED ABRUPTLY: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.3.0/14 (2018-06-04) ----------------------------------------- [HVR-5414] TERADATA TPT PARAMETER PACK CAN BE CONTROLLED WITH ENVIRONMENT VARIABLE: To use this feature, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.3.0/14 (2018-06-04) ------------------------------------------- [HVR-5467] FIXED ORACLE LBC F_JZ113A: DATA BLOCK HAS BEEN DECLARED SHRINKABLE TWICE AFTER ALTER TABLE SHRINK SPACE CASCADE To fix this bug, upgrade HVR on the capture machine(s). [HVR-5397] F_JD2420: DATA VALUE IN LOG RECORD COLUMN X (ORACLE ID X AND DATATYPE VARCHAR2) IS TOO LARGE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4466] FIXED F_JD0234 UNSUPPORTED DATETIME VALUE ENCOUNTERED FOR MYSQL DATE OR DATETIME: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5479] FIXED F_JD024D WHILE TESTING CONNECTION TO SNOWFLAKE WITH A NON-EXISTING SCHEMA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5415] FIXED F_JD22F1 FOR DB2 FOR I CAPTURE WITH MINIMIZED_ON_FIELD_BOUNDARY VALUE ZERO: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5458] FIXED MYSQL TIMESTAMP DATATYPE GETTING A TIMEZONE OFFSET WHILE BURST-INTEGRATING OR BULK-REFRESHING INTO MYSQL OR MARIADB: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5378] FIXED ORACLE LBC F_JD2421: DATA VALUE IN LOG RECORD COLUMN IS NOT CORRECT FOR XML COLUMNS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5387] FIXED BULK COMPARE BACKWARD COMPATIBILITY ISSUE WITH POSTGRESQL: To fix this bug, upgrade HVR on the hub machine(s). [HVR-5451] FIXED COMPARE DIFFERENCE BETWEEN POSTGRES AND TERADATA TIME WITH TZ COLUMNS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5339] GENERATE VALID JSON FILE WITH /JSONMODE=ROW_ARRAY ACCORDING TO RFC4627: To fix this bug, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.3.0/13 (2018-05-17) ------------------------------------------- [HVR-5365] FIXED F_JD2272 TABLE ALREADY EXISTS WHILE BURST INTEGRATING INTO TERADATA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5359] FIXED F_JR0126, BUSY SCHEDULER LOSING ERROR MESSAGE DUE TO RACE CONDITION: To fix this bug, upgrade HVR on the hub machine(s). [HVR-5327] FIXED ORACLE LBC F_JZ1201: SUPPLEMENTAL LOGGING INFORMATION IS MISSING AFTER ALTER TABLE SHRINK SPACE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5205] FIXED INCORRECT CAPTURE OF HANA TIME DATA TYPE: To fix this bug, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 5.3.0/12 (2018-05-04) ------------------------------------------- [HVR-5258] FIXED CAPTURE COLUMNPROPERTIES /ABSENT COLUMN ORDERING FOR FILE/KAFKA INTEGRATE: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-5283] FIXED F_JD20FF DURING TABLE EXPLORE FROM DB2I SAP SYSTEM: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5286] FIXED INGRES LBC FAILS WITH F_JD2220 OR F_JD2216 FOR COMPRESSED TABLES WITH TIME WITH LOCAL TIME ZONE, TIME WITHOUT TIME ZONE, TIMESTAMP WITH LOCAL TIMEZONE OR TIMESTAMP WITHOUT TIME ZONE DATATYPES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5249] FIXED INCORRECT CAPTURE OF INGRES LONG NVARCHAR ON BIG-ENDIAN PLATFORMS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5269] FIXED LATENCY REPORTING FOR VECTOR TARGET OFF BY TZ: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5218] PROPERLY DECLARE SUPPORTED TIMESTAMP FORMATS WHEN CREATING TABLES IN HIVE: To fix this bug, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.3.0/11 (2018-04-19) ------------------------------------------- [HVR-5161] FIXED F_JG20CD WHEN ATTEMPTING TO OPEN THE LOGSEGMENT_000_DIRECTORY.DAT FILE DURING ARCHIVE LOG ONLY CAPTURE FROM HANA: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5210] FIXED MAPBINARY NOT SUPPORTED FOR KAFKA LOCATIONS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-5162] FIXED CAPTURING OF DEFAULT VALUED DB2 (LUW) LOBS IN COMPRESSED TABLES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5209] FIXED IGNORING OF FILEFORMAT CSV PARAMETERS FOR KAFKA LOCATIONS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-5166] FIXED SOME INCONSISTENT TABLEPROPERTIES USE DURING PARTIAL REFRESH: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5196] JSON REQUIRES THE DATE/TIME VALUES TO BE FORMATTED AS SPECIFIED IN THE ISO-8601: To fix this bug, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.3.0/10 (2018-04-10) ------------------------------------------- [HVR-5084] FIXED F_JD21D0 WHILE CAPTURING DB2 (LUW) LOBS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5012] FIXED F_JG2463 DURING INTEGRATION INTO KAFKA WITH HVR_CAP_TSTAMP EXPRESSION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5107] FIXED KAFKA BROKER VERSION BACKWARD COMPATIBILITY: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4994] FIXED ORACLE LBC F_JZ1201: SUPPLEMENTAL LOGGING INFORMATION IS MISSING AFTER ALTER TABLE SHRINK SPACE CASCADE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-5110] FIXED PER-TABLE ONLINE REFRESH CONTROLS ARE EXPIRED EARLY IF NOT-REFRESHED TABLES UNDERGO INTEGRATE RECOVERY FOR S3 LOCATIONS: To fix this bug, upgrade HVR on the hub machine(s). NEW FEATURES IN HVR 5.3.0/9 (2018-03-30) ---------------------------------------- [HVR-4300] ADD SUPPORT FOR GREENPLUM 5.5: To use this feature, upgrade HVR on the integrate machine(s). [HVR-4909] CAPTURE DATA FROM ORACLE IOT TABLES WITH KEY COMPRESSION: To use this feature, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 5.3.0/9 (2018-03-30) ------------------------------------------ [HVR-4996] DB2 (LUW): FIXED UPDATE OF LOBS TO EMPTY STRING IS IGNORED IN SOME CASES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4958] FIXED BURST INTEGRATE FAILING WITH F_JG2901: INVALID UTF8 STRING: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4975] FIXED FILEFORMAT /CSV /FILETERMINATOR ON REFRESH AND INTEGRATE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4910] FIXED ORACLE LBC F_JD2420: DATA VALUE IN LOG RECORD COLUMN IS TOO LARGE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4844] FIXED ORACLE LBC F_JT1456: LOG PARSING ERROR F_JZ195F. PASTE ENCOUNTERS 11.17:2 WITH ONE LENGTH BUT ITS CORRESPONDING DATA STORE LENGTH IS DIFFERENT: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4082] FIXED ORACLE LBC F_JZ1960: PASTE ENCOUNTERS KEY ZOP DATA UPDATE_BEFORE BUT IT FAILED TO FIND THE CORRESPONDING CHANGE AT TX: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4924] FIXED ORACLE RAC - THREAD POSITION BROKEN ON SOLARIS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4976] FIXED SIGSEGV IN CAPTURE JOB WHEN ADAPTDDL IS DEFINED ONLY ON CAPTURE LOCATION: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4834] FIXED CONNECTING TO LOCATIONS ENCRYPTED SSL CERTIFICATES FROM NEWER ROOT AUTHORITIES: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-4963] FIXED FILE REPLICATION INTO AVRO MAY ENTERED IN ENDLESS LOOP: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5015] FIXED GENERATION OF PARQUET FILE WITH INTERVAL DATATYPE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4946] FIXED HVRINIT FAILS ON MYSQL WHEN DB SQL-MODE CONTAINS NO_ZERO_DATE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5000] FIXED INTEGRATE FAILS WITH F_JD20DB: DBMS ERROR [ORA_01008: NOT ALL VARIABLES BOUND] WHEN INTEGRATING INTO ORACLE TABLE WITH INTEGRATEEXPRESSION FOR LOB COLUMN: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-5064] FIXED INTEGRATE RECOVERY MIGHT THROW F_JT0426: UNEXPECTED END-OF-FILE ENCOUNTERED FOR 'INTEG.XXX' STATE FILES AFTER HARDWARE FAILURE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-5066] FIXED INVALID LENGTH CHECK FOR ORACLE TNS IN THE LOCATION DIALOG: To fix this bug, upgrade HVR on the gui machine(s). [HVR-4970] FIXED REFRESH INTO KAFKA TOPIC WITH {HVR_CAP_LOC} FAILING WITH F_JD21DD: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4813] FIXED SCHEDULED REFRESH AND COMPARE JOBS NOT BEING DISPLAYED IMMEDIATELY IN GUI: To fix this bug, upgrade HVR on the gui and hub machine(s). [HVR-1854] HVR CREATES MULTIPLE EMPTY _P.TX FILES DURING CAPTURE FROM SQL SERVER USING LOG READ METHOD SQL: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4874] ORACLE CAPTURE REWIND TO "START OF OLDEST OPEN TRANSACTION" BROKEN FOR TABLES OWNED BY DIFFERENT USER: To fix this bug, upgrade HVR on the hub machine(s). PROBLEMS FIXED IN HVR 5.3.0/8 (2018-03-09) ------------------------------------------ [HVR-4687] FIXED BULK COMPARE OF NULL NCHAR COLUMNS FOR TERADATA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4881] FIXED F_JG2142: FPROC MISMATCH DURING CAPTURE WITH /NOTRUNCATE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4845] FIXED F_JR0337 AFTER DEFINING COLUMNPROPERTIES /DISTRKEY ON KAFKA LOCATION: To fix this bug, upgrade HVR on the hub and gui machine(s). [HVR-4736] FIXED W_JD0A10 DURING HVR INITIALIZE IF SOURCE TABLE CONTAINS COLUMNS OF CLR DATA TYPES (LIKE GEOMETRY) ON SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4926] FIXED COERCION TO SQL SERVER DATETIME LOOSING MILLISECOND PRECISION: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-4866] FIXED DELETION OF SOME NECESSARY INSTALLATION FILES AFTER HVR UPGRADE: To fix this bug, upgrade HVR on all machine(s). [HVR-4858] FIXED ENVIRONMENT VARIABLE CAUSING UNDEFINED BEHAVIOR: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4771] FIXED HVRSTATISTICS LOGGING DATA FOR INCORRECT TIMESTAMP: To fix this bug, upgrade HVR on the gui machine(s). [HVR-4804] FIXED REFRESH FROM TERADATA FAILING WITH JR0344: UNSUPPORTED CLASS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4161] FIXED STRING TO DATE COERCION NOT CAPTURING TIME PART OF ISO8601 TIMESTAMPS: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-695] FIXED UNRESOLVABLE HOST CAUSING REJECTION FOR ALL HOSTS: To fix this bug, upgrade HVR on the proxy and remote machine(s). [HVR-4683] SNOWFLAKE: FIXED F_JG2228 UNABLE TO ALLOCATE MEMORY: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.3.0/7 (2018-02-23) ---------------------------------------- [HVR-4734] ADDED DBOBJECTGENERATION /REFRESHTABLEGRANT TO SPECIFY GRANT AFTER HVR REFRESH WITH TABLE CREATION: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-4849] ADDED ENVIRONMENT VARIABLE TO PREVENT CAPTURE JOB FROM REACTING TO DDL RECORDS: To use this feature, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 5.3.0/7 (2018-02-23) ------------------------------------------ [HVR-4672] FIXED CAPTURE OF OLD ROWID VALUES FOR UPDATE OPERATIONS FROM HANA 2 SPS 02 To fix this bug, upgrade HVR on the capture machine(s). [HVR-4781] FIXED 'F_JD22CA' AND 'F_JD2916' DURING REDSHIFT STAGING BULK LOAD: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4790] FIXED KAFKA TOPICS BROWSE FAILING WITH SIGSEGV: To fix this bug, upgrade HVR on the gui machine(s). [HVR-4557] FIXED INTEGRATE FILEFORMAT /CSV LINE SEPARATORS FOR INTEGRATE /BURST: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.3.0/6 (2018-02-09) ---------------------------------------- [HVR-3906] SUPPORT LOG-BASED CAPTURE FROM HANA 2 SPS 02 (COLUMNSTORE TABLES ONLY): To use this feature, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 5.3.0/6 (2018-02-09) ------------------------------------------ [HVR-4306] F_JT14A8 DURING CAPTURE FROM HANA IF HUB IS NOT ON LINUX: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4728] FIXED 'F_JG2142' WHEN RUNNING CAPTURE AFTER HUB UPGRADE TO HVR 5.3.0 AND HIGHER: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4720] FIXED COLUMNPROPERTIES /BASENAME FOR KEY-UPDATES DURING INTEGRATE /BURST: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4722] FIXED F_JC0509 DURING RAC CONNECT WITH LONG HOSTNAMES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4757] FIXED F_JD2236: DBMS ERROR UNIQUE CONSTRAINT VIOLATED DURING HVRCATALOGIMPORT: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4740] FIXED F_JG2901: INVALID CHARACTER DURING REPLICATION FROM GBK SOURCE WHEN CLOB VALUE IS GREATER THAN 64K: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4681] FIXED F_JT0263: SORT RECEIVED ROWS FROM UNKNOWN TABLE WHEN SAPXFORM CHANNEL CONTAINS POOL AND CLUSTER TABLES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4701] FIXED F_JT0549 WITH '$* NOT LONGER SUPPORTED' ON SOLARIS: To fix this bug, upgrade HVR on the hub and remote machine(s). [HVR-4711] FIXED TABLE EXPLORE FROM SAP CATALOG REPORTING WRONG ENCODING FOR NCHAR COLUMNS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4688] FIXED COMPARE OF NCHAR COLUMNS SHOWING DIFFERENCES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4769] FIXED DATA CORRUPTION DURING REPLICATION OF NVARCHAR COLUMNS FROM HANA TO TERADATA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4684] FIXED FAILURE DURING TERADATA CONNECT IF THE DRIVER NAME IS DIFFERENT THAN 16.10 DEFAULT: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-4387] FIXED HVRADAPT DELETING TABLES FROM CHANNEL WHEN '+' PATTERN IS GIVEN: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4758] FIXED INCORRECT TRACING IN HVR MAINT OUTPUT: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4685] FIXED INVISIBLE LOCATIONPROPERTIES /STAGINGDIRECTORYDB AND /STAGINGDIRECTORYHVR IN THE GUI FOR SNOWFLAKE LOCATIONS: To fix this bug, upgrade HVR on the gui machine(s). [HVR-3846] FIXED REMOVING ALL ENTRIES FROM CATALOGS DURING IMPORT INSTEAD OF KEEPING IT(LIKE HVR4): To fix this bug, upgrade HVR on the hub machine(s). [HVR-4495] FIXED RESILIENT INSERT FOR INTEGRATE /BURST WITH /SURROGATEKEY AND /SOFTDELETE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4211] FIXED SCHEDULER SHUTTING DOWN NETWORK ISSUES FOR NON-ESSENTIAL SOCKETS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1285] FIXED SELECT OF NVARCHAR COLUMN FROM TERADATA MAY RETURN EXTRA ZERO CHARACTER: To fix this bug, upgrade HVR on all machine(s). [HVR-4659] IMPROVED INTEG SIDE SORTING OF CHANNELS WITH TRANSFORM /SAPXFORM: To fix this bug, upgrade HVR on the hub machine(s). NEW FEATURES IN HVR 5.3.0/5 (2018-01-25) ---------------------------------------- [HVR-4616] PERFORMANCE TUNING OF KAFKA LIBRARY TO AVOID MELTDOWN PERFORMANCE PENALTY: To use this feature, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.3.0/5 (2018-01-25) ------------------------------------------ [HVR-4613] F_JD0AAC AND F_JD0A62 DURING CAPTURE FROM SQL SERVER USING DIRECT LOG READ METHOD WHEN VLF SIZE EXCEEDS 4GB: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4596] F_JG2228: UNABLE TO ALLOCATE X BYTES OF MEMORY [POOLALLOC FROM JDORACHK.C:473]: To fix this bug, upgrade HVR on all machine(s). [HVR-4562] FIXED F_JD070F COLUMN NOT FOUND IN DBMS CATALOGS CACHE OF ORACLE SID WITH USER: To fix this bug, upgrade HVR on all machine(s). [HVR-4623] FIXED F_JG200F WRITING TO CLOSED DATASTREAM DUE KAFKA BROKER CONNECTIONS TIMEOUT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1252] FIXED F_JG2901 DURING ENCODING WINDOWS-1252 CHARACTERS: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-4540] FIXED TERADATA CONTINUOUS INTEGRATE AND COMPARE DO NOT HANDLE PROPERLY INVALID CHARACTERS FOR COLUMNS WITH UNICODE CHARACTER SET: To fix this bug, upgrade HVR on the hub, integrate and gui machine(s). [HVR-4618] FIXED CAPTURE FAILING WITH 'F_JG2142: FPROC INVOCATION DID NOT MATCH THE EXPECTED PROTOTYPE: $(ORAWALLET...': To fix this bug, upgrade HVR on the hub and capture machine(s). [HVR-4622] FIXED CAPTURE FROM ORACLE TDE FAILING WITH 'F_JD0707: COULD NOT RETRIEVE MASTER KEY FROM WALLET': To fix this bug, upgrade HVR on the capture machine(s). [HVR-4620] FIXED CAPTURE FROM COMPRESSED TABLE ON SQL SERVER IF SOME COLUMNS ARE MISSING AFTER DDL CHANGES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4541] FIXED CONNECTION TO S3 IN AWS CHINA CLOUD: To fix this bug, upgrade HVR on the hub, capture and integrate machine(s). [HVR-4608] FIXED POTENTIAL HANG DURING PROCESS TERMINATION VIA GUARDIAN: To fix this bug, upgrade HVR on the hub and remote machine(s). [HVR-4026] HVR QUERIES ALL_OBJECTS TO RETRIEVE INDEX INFORMATION WHICH MAKES SELECT ANY TABLE PRIVILEGE A PRE-REQUISITE: To fix this bug, upgrade HVR on the capture machine(s). NEW FEATURES IN HVR 5.3.0/4 (2018-01-15) ---------------------------------------- [HVR-3999] ADD SUPPORT FOR POSTGRESQL 10: To use this feature, upgrade HVR on all machine(s). [HVR-4499] IMPROVED NUMBER(*) -> AVRO,JSON,PARQUET PERFORMANCE: To use this feature, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.3.0/4 (2018-01-15) ------------------------------------------ [HVR-4564] F_JD0A1C DURING CAPTURE FROM COMPRESSED TABLES ON SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4543] FIXED 'F_JD2184: INVALID OBJECT NAME HVR_STATUS_STAGING' DURING CATALOG UPGRADE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4514] FIXED /EXPRESSIONSCOPE ISSUES WITH KEY UPDATES WITH /BURST: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-4463] FIXED F_JD21AE UNABLE TO CONNECT TO MYSQL DATABASE PLUGIN PVIO_SOCKET COULD NOT BE LOADED: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4583] FIXED HTTP RESPONSE CODE 500 WITH MESSAGE "NON-NUMERIC DEFAULT VALUE FOR INT" IN AVRO WITH SCHEMA REGISTRY INTEGRATION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4561] FIXED HVR DOES NOT AUTOMATICALLY PICK UP TTU16.10 LIBRARIES FROM ODBCINST.INI: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-4554] FIXED SIGSEGV WHEN USING HVRLIVEWALLET ON HVRREMOTELISTENER PORT: To fix this bug, upgrade HVR on the remote machine(s). [HVR-4558] FIXED TERADATA COMPARE SHOWS DIFFERENCE ON COLUMN WITH LATIN1 CHARACTER SET AND CONTAINING '0X1A' CHARACTER: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4395] FIXED CAPTURE OF DATE, TIMESTAMP AND SECONDDATE COLUMN VALUES FROM HANA FOR DATES BEFORE THE GREGORIAN REFORM: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4174] FIXED COMPARING 64BIT FLOAT POINT COLUMNS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4500] GUI DOES NOT SHOW HANA IN NEW LOCATION DIALOG: To fix this bug, upgrade HVR on the gui machine(s). PROBLEMS FIXED IN HVR 5.3.0/3 (2018-01-05) ------------------------------------------ [HVR-4506] FIXED F_JD024D DURING HVRGUI'S TABLE SELECT FOR SNOWFLAKE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4423] FIXED F_JD024D WHEN LOADING LARGE CLOBS INTO SNOWFLAKE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4486] FIXED F_JD20DB: DBMS ERROR [ORA-01284: FILE OCI:///... CANNOT BE OPENED] DURING ORACLE LOG-BASED CAPTURE VIA LOGMINER: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4508] FIXED F_JG20CD WITH 'TOO MANY OPEN FILES' DURING ROW-WISE REFRESH: To fix this bug, upgrade HVR on all machine(s). [HVR-4493] FIXED F_JG2142 WHEN FILEFORMAT /PARQUET IS SET FOR KAFKA LOCATION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4451] FIXED F_JG2421 DURING ORACLE LOG-BASED CAPTURE FROM REMOTE DB VIA LOGMINER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2946] FIXED TABLEPROPERTIES /SCHEMA ON GROUP * IS CREATED TWICE FOR EVERY TABLE NOT IN THE DEFAULT SCHEMA: To fix this bug, upgrade HVR on the gui machine(s). [HVR-4461] FIXED COMPARE DIFFERENCE BETWEEN ORACLE AND HIVE ACID FOR RAW COLUMNS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4509] FIXED INTEGRATE INTO HIVE ACID LOSES ROWS DURING KEY UPDATES FOR TABLES WITH LOBS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4462] FIXED MEMORY LEAK DURING ORACLE LOG-BASED CAPTURE VIA LOGMINER: To fix this bug, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 5.3.0/2 (2018-01-02) ------------------------------------------ [HVR-4225] FIXED HANA NON-KEY UPDATES BEING INTEGRATED AS DELETE-INSERTS: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-4407] FIXED HANA: HVRADAPT ALWAYS FIND DIFFERENCE FOR DB2_TIME DATATYPE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4471] FIXED PARQUET PIPE CREATING BROKEN FILES IF INTEGRATING MULTIPLE TABLES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4456] FIXED PARQUET/HIVE WITH CHAR COLS: JAVA:ILLEGALSTATEEXCEPTION: UTF8 CAN ONLY ANNOTATE BINARY FIELDS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4235] FIXED TERADATA TMODE=TERA CREATES CASE INSENSITIVE TABLES OR ORDER BY ISSUES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4041] FIXED MISSING ESCAPING DURING WRITING OF BLOB COLUMNS INTO CSV: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4384] FIXED WRONG COALESCE ROW COUNT DURING BURST INTEGRATE: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.3.0/1 (2017-12-22) ---------------------------------------- [HVR-2951] ADDED SNOWFLAKE SUPPORT AS TARGET: To use this feature, upgrade HVR on the hub, gui and integrate machine(s). [HVR-3316] ADDED SUPPORT FOR HIVE MANAGED TABLES (HIVE ACID): To use this feature, upgrade HVR on the hub, gui and integrate machine(s). [HVR-4001] CHANGE DEFAULTS FOR 'SENSITIVITY' CHECK-BOXES IN TABLE EXPLORE DIALOG: To use this feature, upgrade HVR on the gui machine(s). PROBLEMS FIXED IN HVR 5.3.0/1 (2017-12-22) ------------------------------------------ [HVR-3471] FIXED F_JD0103: DBMS ERROR [ORA-00604: ORA-16000: DATABASE OPEN FOR READ-ONLY ACCESS] WHEN TRYING TO ADD SUPPLEMENTAL LOGGING ON AN ACTIVE STANDBY DATABASE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4147] FIXED F_JD212D INVALID DECIMAL SEPARATOR DURING TERADATA COMPARE ON WINDOWS PLATFORMS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4428] FIXED HVR DOES NOT USE TABLE NAME WITH MIXED CASE WHEN RESTRICT IS DEFINED: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.3.0/0 (2017-12-21) ---------------------------------------- [HVR-3492] ADDED NEW FILEFORMAT /PARQUET AS A TARGET FORMAT: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-3343] ORACLE CAPTURE VIA LOGMINER SQL INTERFACE: To use this feature, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 5.3.0/0 (2017-12-21) ------------------------------------------ [HVR-4397] ENCODING OF DECIMAL VALUES INTO AVRO/JSON TAKES TOO MUCH TIME FOR COLUMNS WITH BIG PRECISION VALUES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4386] F_JD0A11 DURING CAPTURE FROM SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4401] FIXED HVR INIT ENROLLMENT FAILING WITH F_JG2142 AFTER HVR UPGRADE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4421] FIXED INTEGRATE FAILING WITH 'F_JD20DB: DBMS ERROR [ORA-01410: INVALID ROWID]' FOR ORACLE UROWID: To fix this bug, upgrade HVR on the capture, hub and integrate machine(s). [HVR-4151] FIXED M_JB0595_QT WARNING ON BOOTUP ON MACOS GUI: To fix this bug, upgrade HVR on the gui machine(s). [HVR-4418] FIXED {HVR_INTEG_SEQ} OVERFLOW AT 250M ROW TRANSACTIONS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3862] SYNCHRONIZE HIVE TABLE DESCRIPTION WITH AVRO/JSON SCHEMA FOR BOOLEAN/INTEGER DATATYPES: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.2.3/16 (2017-12-15) ----------------------------------------- [HVR-4332] ADD SUPPORT FOR POSTGRESQL JSON DATATYPES: To use this feature, upgrade HVR on all machine(s). [HVR-2951] ADDED SNOWFLAKE SUPPORT AS TARGET: To use this feature, upgrade HVR on the hub, gui and integrate machine(s). [HVR-1436] ALLOW LOB DATA TYPES (E.G. POSTGRESQL TEXT) AS PART OF THE REPLICATION KEY: To use this feature, upgrade HVR on the hub machine(s). [HVR-4379] USE TERADATA UNIQUE PRIMARY INDEX COLUMNS AS REPLICATION KEY CANDIDATE: To use this feature, upgrade HVR on all machine(s). PROBLEMS FIXED IN HVR 5.2.3/16 (2017-12-15) ------------------------------------------- [HVR-4356] FIXED 'F_JB0900' WHEN DOING HVRSTATISTICS WITH OLD HVR GUI: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4326] FIXED 'F_JT14A3: SCAN DESCRIBE CANNOT BE CONVERTED TO TABLE-INFO' DURING HVR INIT: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-4361] FIXED F_JD0D16: INTERNAL HIVE ERROR DURING COMPARE OF DATE COLUMNS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4369] FIXED F_JG20F0 DURING LONG-RUNNING SQL QUERIES FROM HIVE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4055] FIXED F_JT0400 LOG SCANNING ERROR F_JZ2514 WITH INGRES 11.0: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4372] FIXED ORACLE LBC F_JZ1920: TRANSACTION ENCOUNTERED COMMIT, BUT A ROW FOR A TABLE IS STILL OPEN WITH INCOMPLETE ROW CHAINING COLUMN(S): To fix this bug, upgrade HVR on the capture machine(s). [HVR-4388] FIXED TERADATA LOCATING OBJECTS WHEN DEFAULT DATABASE IS DIFFERENT FROM CURRENT USER: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4366] FIXED MALFORMED SCHEMA IN AVRO FOR WIDE TABLES: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.2.3/15 (2017-12-11) ----------------------------------------- [HVR-3904] MAXIMUM LENGTH FOR HVR TABLE NAME IS RAISED TO 4 BYTES LESS THAN MAXIMUM SUPPORTED LENGTH IN DATABASE AT INTEGRATE LOCATION: To use this feature, upgrade HVR on the gui and hub machine(s). [HVR-3886] ADDED PARAMETER RESTRICT /SELECTDISTINCT TO FILTER DUPLICATES DURING COMPARE OR REFRESH: To use this feature, upgrade HVR on the hub and remote machine(s). [HVR-4222] ADDED SUPPORT FOR INTEGRATION OF KEY UPDATES IN INTEGRATE /BURST FOR MULTI-DELETES: To use this feature, upgrade HVR on the integrate machine(s). [HVR-2308] ADDED SUPPORT FOR MYSQL IN TARGET AND HUB: To use this feature, upgrade HVR on the hub, gui and integrate machine(s). [HVR-2655] ADDED SUPPORT FOR TERADATA TTU 16.10: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-4266] ADDED SUPPORT FOR MERGING CHANNELS WITHOUT INTERRUPTING REPLICATION JOBS: To use this feature, upgrade HVR on the hub, capture and integrate machine(s). [HVR-3212] BURST INTEGRATE VARY BETWEEN TPT STREAM AND BATCH DEPENDING ON NUMBER OF ROWS: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-3324] ADDED SUPPORT FOR CAPTURING LOB COLUMNS FROM SAP HANA SOURCE: To use this feature, upgrade HVR on the capture machine(s). [HVR-3788] ENABLE/DISABLE ORACLE RAC THREADS USING REDO RECORDS, INSTEAD OF TIMERS AND DICTIONARY QUERIES: To use this feature, upgrade HVR on the capture machine(s). [HVR-4008] ENROLL FOR HVRINIT IS NOW INCREMENTAL (REVISIONS ARE APPENDED TO SAME ENROLL FILE RATHER THAN CREATING NEW FILE) AND DETECTED BY RUNNING CAPTURE JOB: To use this feature, upgrade HVR on the gui, hub and capture machine(s). [HVR-4232] INTEGRATE /BURST NO LONGER REQUIRES SUPPLEMENTAL LOGGING ALL: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-4205] ISSUE A WARNING DURING ARCHIVE LOG ONLY CAPTURE FROM SQL SERVER WHEN HVR CANNOT FIND A LOG BACKUP TO READ FROM BUT NEWER LOG BACKUP EXISTS: To use this feature, upgrade HVR on the capture machine(s). [HVR-1548] LOWERED THE NUMBER OF COMMITS FOR BURST CYCLES: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-3835] ADDED SUPPORT FOR AUTOMATIC DETECTION OF ORACLE DATA GUARD CASCADE, SO CAPTURE DOES NOT NEED ACTION CHANGES: To use this feature, upgrade HVR on the capture machine(s). [HVR-487] ADDED SUPPORT FOR QUICK CAPTURE RECOVERY USING CHECKPOINTS OF LONG-RUNNING TRANSACTIONS: To use this feature, upgrade HVR on the hub, capture and gui machine(s). [HVR-4313] REVERTED TERADATA CONNECTION SESSIONMODE DEFAULT BACK TO ANSI DONE WITH HVR-4126: To use this feature, upgrade HVR on the integrate machine(s). [HVR-4284] SUPPORT HANA TO GREENPLUM WITH /BURST: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-4114] SUPPORT IDENTIFIERS UP TO 128 BYTES AND HVR TABLE NAMES UP TO 124 BYTES FOR ORACLE 12.2: To use this feature, upgrade HVR on the gui, hub and capture machine(s). PROBLEMS FIXED IN HVR 5.2.3/15 (2017-12-11) ------------------------------------------- [HVR-4230] DBOBJECTGENERATION /STATETABLECREATECLAUSE IS IGNORED FOR INTEGRATE STATE TABLES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4031] ENVIRONMENT VARIABLES ARE CORRECTLY PASSED INTO AGENT PLUGIN IN REFRESH MODE IF FILEFORMAT /JSON: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4216] FIXED 'F_JD20DB: DBMS ERROR ORA-01843' WHEN CREATING HVR_STATUS_STAGING: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4226] FIXED /INTEGRATEEXPRESSION WITHOUT /EXTRA FOR KEY UPDATES WITH /BURST: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4184] FIXED BURST INTEGRATE INTO GREENPLUM ALWAYS RECREATES EXTERNAL BURST TABLES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4290] FIXED F_JG200A AT THE END OF REFRESH/INTEGRATE PROCESS TO KAFKA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4163] FIXED ORACLE DATE IS MAPPED TO VARCHAR(100) IN HIVE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4197] FIXED W_JD2902: GREENPLUM EXTERNAL TABLE NEEDS TO BE RECREATED DURING BURST INTEGRATE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4275] FIXED CREATION OF NULLABLE MYSQL TIMESTAMP COLUMNS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4244] FIXED HIVE TABLE DEFINITION IS INCORRECT WITHOUT EXPLICITLY DEFINED SCHEMA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4329] FIXED EXTRA HVR_CHAIN_ID COLUMN APPEARING WITH FILEINTEGRATE /BURST: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4262] FIXED HVRCATALOGCREATE FAILING WITH F_JD230F ON SQL SERVER: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4273] FIXED HVRMANIFESTAGENT.PY USING LOCAL TIME INSTEAD OF UTC FOR ITS FILENAMES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4261] FIXED INCORRECT BASE TABLE NAME DISPLAYED IN TABLE EXPLORE DETAIL VIEW: To fix this bug, upgrade HVR on the gui machine(s). [HVR-4177] FIXED INCORRECT ESCAPING OF SPECIAL CHARS IN /FILEFORMAT JSON: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4180] FIXED INDEX CREATION FOR NEW TABLES WITH SURROGATE KEY: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-4245] FIXED INVALID HIVE TABLE EXTERNAL LOCATION IF /RENAMEEXPRESSION CONTAINS {HVR_CAP_TSTAMP}: To fix this bug, upgrade HVR on the hub machine(s). [HVR-3864] FIXED LOCALIZATION OF CHAR-LENGTHS AND BYTE-LENGTHS FOR CHARACTER DATATYPES: To fix this bug, upgrade HVR on all machine(s). [HVR-4264] FIXED POTENTIAL DATA LOSS WITH HVRINIT -OE AND INDEX REBUILD ON MS SQL SERVER: To fix this bug, upgrade HVR on the gui, hub and capture machine(s). [HVR-4140] HVR SCHEDULER RUNS JOB TWICE WHEN TRIG_CRONO ATTRIBUTE IS SET; SINCE HVR-1610: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4152] IMPROVED COLUMN ID DISCOVERY DURING HVR INITIALIZE FOR HANA WHICH SHOULD SIGNIFICANTLY IMPROVE PERFORMANCE AND FIX SPORADIC F_JD0215 ERRORS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4116] ENABLED CREATION OF LOG MESSAGES FOR NODES GOING UP AND DOWN IN ORACLE LOG-BASED CAPTURE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-3944] ORACLE LBC: F_JZ1119, F_JZ1120, W_JZ1113 AND W_JZ1114 DO NOT MENTION THREAD NUMBER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4347] ORACLE LBC: LOG START POSITIONING ERROR F_JZ1100. CAPTURE JOB UNABLE TO FIND FILE SEQUENCE X FOR THREAD Y IN ARCHIVE LOG ONLY MODE: To fix this bug, upgrade HVR on the capture machine(s). NEW FEATURES IN HVR 5.2.3/14 (2017-11-09) ----------------------------------------- [HVR-3213] ALLOW TRACING VARIABLES TO BE PASSED TO TPT: To use this feature, upgrade HVR on the integrate machine(s). [HVR-4126] CHANGED TERADATA CONNECTION SESSIONMODE DEFAULT TO TERA: To use this feature, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.2.3/14 (2017-11-09) ------------------------------------------- [HVR-4142] FIXED ADAPTDDL /REFRESHOPTIONS NOT BEING ALLOWED ON SOME TARGET LOCATIONS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4165] FIXED F_JD0F01 DURING HVR COMPARE OF TABLE WITH COLPROPS /DATATYPEMATCH ON HIVE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4150] FIXED F_JG2142 DURING TEST CONNECTION OF KAFKA LOCATION: To fix this bug, upgrade HVR on the gui machine(s). [HVR-3977] FIXED HVR GUI RAISING 'F_JG352A' WHEN REQUESTING THE START PAGE: To fix this bug, upgrade HVR on the gui machine(s). [HVR-4172] FIXED HIVE LOCATIONS ARE NOT DISPLAYED IN THE HVR COMPARE DIALOG: To fix this bug, upgrade HVR on the gui machine(s). [HVR-4124] FIXED HVRINIT FAILING WITH F_JD0006 WHEN LOCATIONPROPERTIES /CASESENSITIVENAMES AND DBSEQUENCE IS DEFINED FOR ORACLE LOCATIONS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4061] FIXED ORACLE LBC CAPTURES INCORRECT COLUMN VALUE FOR UPDATE, DUPLICATE STRING IN COL VALUE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4042] FIXED COERCION PRODUCING '-0' FOR NUMERIC DATA TYPE: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-4120] FIXED CONVERSION OF CLOB FIELD INTO UTF8 CHARSET FOR FILEFORMAT /AVRO: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.2.3/13 (2017-11-03) ----------------------------------------- [HVR-3114] ADDED {HVR_INTEG_SEQ}, {HVR_TX_SCN}, {HVR_CHN_NAME} SUBSTITUTION FOR /INTEGRATEEXPRESSION, /RENAMEEXPRESSION: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-4052] CHANGED DEFAULT FOR TIMESTAMPS TO INCLUDE TIMEZONE OFFSET: To use this feature, upgrade HVR on all machine(s). [HVR-4014] ENHANCED TIMESTAMP WIDGETS IN GUI TO ACCEPT LOCAL TIME OR UTC: To use this feature, upgrade HVR on the gui machine(s). [HVR-2382] MADE IT CONFIGURABLE WHETHER TIMESTAMPS CONTAIN TIMEZONE OFFSET OR ARE IN UTC: To use this feature, upgrade HVR on all machine(s). [HVR-4058] PERFORMANCE IMPROVEMENTS ON FILEFORMAT /JSON /JSONMODE=SCHEMA_PAYLOAD: To use this feature, upgrade HVR on the integrate machine(s). [HVR-4092] SEND KAFKA DISTRIBUTION KEYS IN ROW/CHANGE BUNDLING WITH FILEFORMAT /JSON AND /AVRO: To use this feature, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.2.3/13 (2017-11-03) ------------------------------------------- [HVR-4137] FIXED HUB FINGERPRINTS ON EC2-WINDOWS INSTANCES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4090] ENCODE DISTRIBUTION KEY WITH FILEFORMAT /JSON ACCORDING TO KAFKA CONNECT REQUIREMENTS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4031] ENVIRONMENT VARIBALES ARE CORRECTLY PASSED INTO AGENT PLUGIN IF FILEFORMAT /JSON: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3960] FIXED F_JD2248: TIME-ONLY DATE ENCOUNTERED WHEN RUN FROM INGRES TO HIVE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-3763] FIXED F_JG200A: INTERNAL ERROR SIGSEGV DURING UPDATE OF CLOB COLUMNS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3953] FIXED F_JG2902: INVALID UNICODE DURING ORACLE CAPTURE DESPITE TABLEPROPERTIES /IGNORECOERCEERROR BEING SET: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4075] FIXED FILEFORMAT /JSON WITH CLOB COLUMNS MIGHT PRODUCE BROKEN OUTPUT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4067] FIXED GUI CRASH WHEN COMPARING WITH UNSUPPORTED READ LOCATION: To fix this bug, upgrade HVR on the gui machine(s). [HVR-4088] FIXED KAFKA DIAGNOSTIC MESSAGE DUMPS FOR AVRO DO NOT INCLUDE KAFKA DISTRIBUTION KEYS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4057] FIXED KAFKA REACHING OUTPUT QUEUE LIMITS THROWS F_JT0D0B (LOCAL: QUEUE FULL) IN MIDDLE OR F_JT04C2 (DELIVERY TIMEOUT) AT END: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4112] FIXED KAFKA RECEIVES MISLEADING BUNDLING PARAMETERS: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-3948] FIXED ORACLE CAPTURE WITH /CAPTUREFROMROWID FAILING WITH F_JD0720: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-4005] FIXED TABLE EXPLORE ALWAYS REPORTING 'EXTRA UNIQUE INDEX' FOR TABLES WITH MORE THAN 1 UNIQUE INDEX: To fix this bug, upgrade HVR on the gui and hub machine(s). [HVR-4068] FIXED TEST LOCATION FOR KAFKA SUCCEEDING DESPITE BROKEN SCHEMA REGISTRY: To fix this bug, upgrade HVR on the gui and integrate machine(s). [HVR-4125] FIXED DISTRIBUTION KEY UPDATES FOR GREENPLUM/SQLSERVER DW: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4089] FIXED FUZZINESS WITH KAFKA MESSAGE SIZE LIMITS WHEN GENERATED MESSAGES ARE TOO CLOSE TO HARD LIMITS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4094] FIXED PURING OLD /SOFTDELETE-ED ROWS USING /BURST FOR SQLSERVER, POSTGRESQL AND REDSHIFT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4093] FIXED SEGFAULT ON FILEFORMAT /AVRO ON KAFKA LOCATION WITHOUT SCHEMA REGISTRY AND NO INTEGRATE /MESSAGEBUNDLING DEFINED: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4091] KAFKA LOCATION WITH EXPLICIT FILEFORMAT /JSONMODE=SCHEMA_PAYLOAD ACTS DIFFERENTLY THAN NO FILEFORMAT REGARDING KAFKA DISTRIBUTION KEYS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-4060] PERFORMANCE IMPROVEMENTS ON FILEFORMAT /AVRO IN KAFKA CONNECT MODE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-4002] SAPDESCRIBE MAY RETURN INCORRECT INFORMATION LEADING TO ERRORS DURING TABLE EXPLORE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-4111] STOPPED SHOWING KAFKA LOCATIONS IN TABLE EXPLORE DIALOG: To fix this bug, upgrade HVR on the gui machine(s). NEW FEATURES IN HVR 5.2.3/12 (2017-10-26) ----------------------------------------- [HVR-1422] ADD SUPPORT FOR INTEGRATION OF KEY UPDATES FOR INTEGRATE /BURST WHERE NOT ALL COLUMNS ARE SUPPLEMENTAL LOGGED: To use this feature, upgrade HVR on the hub and integrate machine(s). PROBLEMS FIXED IN HVR 5.2.3/12 (2017-10-26) ------------------------------------------- [HVR-4035] FIXED HIVE CONNECT FAILS WITH ODBC ERROR: STRING DATA RIGHT TRUNCATION IF THE ODBC CONNECT STRING IS OVER 256 CHARS: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.2.3/11 (2017-10-24) ----------------------------------------- [HVR-4021] ADD HVR_TABLEEXPLORE_HINT TO ADD (ORACLE ONLY) OPTIMIZER HINT FOR TABLE ENROLLMENT QUERIES: To use this feature, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 5.2.3/11 (2017-10-24) ------------------------------------------- [HVR-3980] F_JD20F2 DURING CAPTURE FROM SQL SERVER WITH /LOGTRUNCATE SET TO CAP_JOB_RETAIN: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-3025] FIXED CHANGING HVR TABLE NAME RESETS SCHEMA TO "/SCHEMA" IN ACTION TABLEPROPERTIES: To fix this bug, upgrade HVR on the gui machine(s). PROBLEMS FIXED IN HVR 5.2.3/10 (2017-10-20) ------------------------------------------- [HVR-3898] F_JD0A42 ON CAPTURE JOB START WHEN DOING CAPTURE FROM SQL SERVER DATABASE IN SIMPLE RECOVERY MODEL: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-3925] FIXED F_JD0215 INCORRECT SYNTAX WHEN TRYING TO CREATE A TABLE WITH A TINYINT COLUMN FOR HANA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3820] FIXED F_JR0E29 DURING LICENSE CHECKING IF LICENSE HAS INTEGRATE RESTRICTIONS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-3973] FIXED BROWSE BUTTON IS DISABLED WHEN CREATE NEW HIVE LOCATION: To fix this bug, upgrade HVR on the gui machine(s). [HVR-3956] FIXED CONNECTION TO HIVE WITH USERNAME AND PASSWORD FAILS WITH F_JG2024: UNABLE TO DECODE TEXT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3945] FIXED HVRREFRESH TO RECREATE MISMATCHED TABLES REPORT 'PERFORMING ALTER TABLE' WHEN RUN A SECOND TIME FOR A MISSING TABLE CONTAINING A NON-NULLABLE INGRESDATE FROM INGRES TO NON-INGRES DBMS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-3955] FIXED INCORRECT USE OF TINYINT INSTEAD OF SMALLINT WHILE CREATING TABLES FOR HIVE BASED ON INTEGER1: To fix this bug, upgrade HVR on all machine(s). [HVR-3902] FIXED UNEXPECTED DATATYPE 'ANSIDATE' DURING GENERATION FILE IN JSON FORMAT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3954] INTEGRATE /MAXFILESIZE ON XML FILES ACTS FUZZILY INSTEAD OF AS A THRESHOLD (UNLIKE OTHER FILE FORMATS): To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.2.3/9 (2017-10-09) ---------------------------------------- [HVR-3875] ADD SUPPORT FOR AGENTPLUGIN /DBPROC ON TERADATA TARGET: To use this feature, upgrade HVR on the integrate machine(s). [HVR-2765] ADDED SUPPORT FOR ORACLE ROWID AND UROWID DATATYPES: To use this feature, upgrade HVR on all machine(s). [HVR-2121] HVR ON AZURE CLOUD USES AZURE VM ID AS HUB FINGERPRINT TO SURVIVE STOP-START OF VMS: To use this feature, upgrade HVR on the hub machine(s). [HVR-3009] NATIVE SUPPORT FOR WRITING TO KAFKA (AND KAFKA-CONNECT): To use this feature, upgrade HVR on the hub, integrate and gui machine(s). PROBLEMS FIXED IN HVR 5.2.3/9 (2017-10-09) ------------------------------------------ [HVR-3748] /SCHEMA IS ADDED UPPER-CASED WITH /CASESENSITIVENAMES AND ADAPTDDL: To fix this bug, upgrade HVR on the capture machine(s). [HVR-3812] ADDED TIMESTAMP_MICROS AND TIME_MICROS SUPPORT WITH /JSONMODE=SCHEMA_PAYLOAD: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3320] FIXED "QT: UNTESTED WINDOWS VERSION 6.2 DETECTED!" MESSAGE APPEARING IN GUI: To fix this bug, upgrade HVR on the gui machine(s). [HVR-3816] FIXED F_JD0A29 DURING CAPTURE FROM SQL SERVER DATABASE ENABLED FOR CHANGE TRACKING: To fix this bug, upgrade HVR on the capture machine(s). [HVR-3686] FIXED F_JD2424 MISSING VALUE FOUND FOR KEY COLUMN DURING ORACLE LBC: To fix this bug, upgrade HVR on the capture machine(s). [HVR-3490] FIXED INCORRECLTY RELIANCE ON IDENTITY COLUMN IN SQL SERVER FOR RESILIENCE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3888] FIXED TABLE CREATE FOR XTREMEDATA BYTEA COLUMNS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3682] FIXED WRONG ERROR MESSAGE OUT OF HVRADAPT WITH -D OPTION AND NON-EXISTING CHANNEL: To fix this bug, upgrade HVR on the hub machine(s). [HVR-3852] ORACLE 9 ARCHIVE READING HANGS ON UNREADABLE ARCHIVE LOGFILES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-3824] ORACLE 9.2: ONLINE REFRESH FAIL WITH [ORA-00904]: To fix this bug, upgrade HVR on the hub and capture machine(s). [HVR-3689] SEGMENTATION VIOLATION AND F_JZ1518 DURING CAPTURE WHEN LOGFILE BLOCK SIZE IS CHANGED: To fix this bug, upgrade HVR on the capture machine(s). [HVR-3815] UNEXPECTED EOF READING ORACLE 9 ARCHIVE LOG: To fix this bug, upgrade HVR on the capture machine(s). NEW FEATURES IN HVR 5.2.3/8 (2017-09-22) ---------------------------------------- [HVR-2885] ADDED A START PAGE TO THE HVR GUI: To use this feature, upgrade HVR on the gui machine(s). PROBLEMS FIXED IN HVR 5.2.3/8 (2017-09-22) ------------------------------------------ [HVR-3778] ALLOW USE OF /SUPPLEMENTALLOGGING=CDCTAB WITH SQL SERVER 2016 SP1 STANDARD EDITION: To fix this bug, upgrade HVR on the capture machine(s). [HVR-3795] F_JD20F2 DURING CAPTURE FROM SQL SERVER WITH /LOGTRUNCATE=CAP_JOB_RETAIN IN MINIMAL PERMISSION MODEL: To fix this bug, upgrade HVR on the capture machine(s). [HVR-3798] FIXED /AGENTPLUGIN ON S3 LOCATIONS (INTEG_END,REFR_WRITE_END) NOT RECEIVING HVR_FILE_NROWS,HVR_FILE_TX_SEQ AND NOT RECEIVING RELATIVE PATHS FOR HVR_FILE_NAMES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3678] FIXED GUI TO RECOGNIZE OLD HVRMAINT OPTION -EMAIL_ONLY_ERRORS: To fix this bug, upgrade HVR on the gui machine(s). [HVR-3786] FIXED DEFLATE CODEC IN AVRO FILE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3787] FIXED GENERATION BSON FORMAT ON BIG ENDIAN PLATFORM: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3797] FIXED HANGS UP IF CLOB COLUMNS ARE PRESENT WITHIN AVRO PIPE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3770] FIXED MISSED ZERO-LENGTH LOB DATA IN AVRO FILE: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.2.3/7 (2017-09-19) ---------------------------------------- [HVR-3189] ADDED /FILEFORMAT /JSON: To use this feature, upgrade HVR on the hub, gui and integrate machine(s). [HVR-3730] ALLOW MULTIPLE COLUMNPROPERTIES /TRIMDATATYPE TO MATCH SAME COLUMN. /NAME PRECEDES OVER /DATATYPEMATCH: To use this feature, upgrade HVR on the hub and capture machine(s). [HVR-3723] ENABLED HIVE ODBC SUPPORT ON WINDOWS PLATFORM: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-3772] INTEGRATE DIRECTLY TO FINAL FILENAMES FOR S3 LOCATIONS PRESERVING RECOVERY REPEATABILITY: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-3571] INTRODUCED ENV VARIABLE WHICH OVERWRITES DATE RANGES: To use this feature, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.2.3/7 (2017-09-19) ------------------------------------------ [HVR-2128] FIXED COMBINING /MAXFILESIZE AND /RENAMEEXPRESSION WITHOUT {HVR_TBL_NAME} TO OVERWRITE PREVIOUS FILES FOR CSV,AVRO: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3737] FIXED COMBINING /MAXFILESIZE AND /RENAMEEXPRESSION WITHOUT {HVR_TBL_NAME} TO REPORT INCORRECT HVR_FILE_NROWS FOR XML: To fix this bug, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.2.3/6 (2017-09-06) ------------------------------------------ [HVR-3697] CAPTURE FOR SQL SERVER 2000 GIVES: F_JD20F2 ON 'IS_ROLEMEMBER': To fix this bug, upgrade HVR on the capture, hub and integrate machine(s). [HVR-3715] ONLINE REFRESH FAILS WITH F_JD21B9: ON 'MSDB..SP_HVR_DBCC' FOR SQL SERVER 2000: To fix this bug, upgrade HVR on the hub machine(s). PROBLEMS FIXED IN HVR 5.2.3/5 (2017-09-05) ------------------------------------------ [HVR-3713] F_JD20DB: DBMS ERROR [ORA-01405: FETCHED COLUMN VALUE IS NULL] ON NOT NULL COLUMN: To fix this bug, upgrade HVR on the capture machine(s). [HVR-3707] FIXED F_JG0E07: UNHANDLED ICU ERROR WHEN GBK CHARACTER IS TRUNCATED: To fix this bug, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.2.3/4 (2017-09-01) ------------------------------------------ [HVR-3450] FIXED F_JD2164 ERROR FOR FILE-TO-DATABASE CHANNEL WITH HVR5 HUB, CAPTURE AND HVR4 INTEGRATE LOCATIONS: To fix this bug, upgrade HVR on the hub and capture machine(s). [HVR-3688] FIXED PER-COLUMN INTEGRATE /RENAMEEXPRESSION NOT SWITCHING FILES ON SOME CASES DURING INTEGRATION: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.2.3/3 (2017-08-30) ---------------------------------------- [HVR-3639] ADDED PREV,NEXT KEYS TO MANIFESTS TO IDENTIFY OTHER MANIFESTS IN SAME CYCLE: To use this feature, upgrade HVR on the integrate machine(s). [HVR-3583] BULK REFRESH TO FILE LOCS PASS $HVR_FILE_NROWS,$HVR_TBL_NROWS TO AGENTPLUGINS: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-3633] MODIFY HVR_CAP_TSTAMP SO IT IS ALWAYS (MONOTONICALLY) INCREASING: To use this feature, upgrade HVR on the capture machine(s). [HVR-3642] NEW INTEGRATE AGENT ENV VAR $HVR_CAP_REWIND_TSTAMP FOR LBC: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-3644] POSTGRESQL REDUCE USAGE OF SAVEPOINTS DURING SQL-BASED LOG-BASED CAPTURE: To use this feature, upgrade HVR on the capture machine(s). [HVR-3618] POSTGRESQL REDUCE USAGE OF SAVEPOINTS DURING PLAIN INTEGRATE: To use this feature, upgrade HVR on the integrate machine(s). [HVR-3393] TRIM WIDE ORACLE VARCHARS AND LOBS WITH COLUMNPROPERTIES /TRIMDATATYPE: To use this feature, upgrade HVR on the hub and capture machine(s). PROBLEMS FIXED IN HVR 5.2.3/3 (2017-08-30) ------------------------------------------ [HVR-3476] FIXED 'F_JD2155' FRACTIONAL NUMBER FOR INT COLUMN IN HVR_STATS CHANNEL: To fix this bug, upgrade HVR on the hub machine(s). [HVR-3631] FIXED 'F_JG2700' INCORRECT SIZE CHECK OF TRUSTED HVR EXECUTABLES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2838] FIXED BROKEN FILEFORMAT /XML IF /MAXFILESIZE IS DEFINED: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3655] FIXED CAPTURE FAILING WITH 'F_JG2142' WHEN ADAPTDDL /INTEGRATESCHEMA IS DEFINED: To fix this bug, upgrade HVR on the hub machine(s). [HVR-3648] FIXED CORRUPTED FILEFORMAT /AVRO FILES WITH INTEGRATE /MAXFILESIZE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3584] FIXED HVRHIVEAGENT.PY, HVRKAFKAAGENT.PY, HVRMANIFESTAGENT.PY TO USE #!PYTHON (LET HVR CHOOSE) INSTEAD OF /USR/BIN/PYTHON: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3576] FIXED HVRSCHEDULER FAILS TO START ON TERADATA HUBDB WITH DEFAULT ENCODING UNICODE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-3549] FIXED INCORRECT COMMAND LINE SHOWN IN HVRGUI DIALOGS FOR TERADATA HUB: To fix this bug, upgrade HVR on the hub and gui machine(s). PROBLEMS FIXED IN HVR 5.2.3/2 (2017-08-24) ------------------------------------------ [HVR-3628] FIXED AMAZON S3 SERVER SIDE ENCRYPTION FOR INTEGRATE: To fix this bug, upgrade HVR on the integrate and hub machine(s). [HVR-3603] FIXED HVR USES 1970-01-01 INSTEAD OF NULL AS DEFAULT VALUE FOR NULLABLE HVR INTERNAL COLUMNS ON TERADATA: To fix this bug, upgrade HVR on the hub machine(s). [HVR-3593] FIXED HVR_STATS CHANNEL FAILING WITH SPACES IN LOG DIRECTORY: To fix this bug, upgrade HVR on the hub machine(s). [HVR-3340] FIXED HVRCATALOGCREATE DOES NOT COMMIT THE CREATION OF THE STATUS TABLES ON DB2 (LUW): To fix this bug, upgrade HVR on the hub machine(s). NEW FEATURES IN HVR 5.2.3/1 (2017-08-16) ---------------------------------------- [HVR-3485] $HVR_AGENT_BEGIN_TSTAMP $HVR_AGENT_END_TSTAMP FOR AGENTPLUGIN, IMPROVED AGENTS ON FILE LOCS DURING RECOVERY: To use this feature, upgrade HVR on the capture, hub and integrate machine(s). [HVR-2137] ADD SUPPORT FOR INGRES 11.0: To use this feature, upgrade HVR on all machine(s). [HVR-3580] PASS $HVR_FILE_TX_SEQ (HVR_TX_SEQ PER FILE) TO INTEG AGENTS, FIXES FOR $HVR_FILE_NROWS: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-3497] PERFORMANCE IMPROVEMENT FOR LNV,MNV,XML,DNV TYPE COERCIONS: To use this feature, upgrade HVR on the integrate machine(s). [HVR-3486] HVRMANIFESTAGENT.PY RECOVERY IMPROVEMENTS (VIA HVR-3485): To use this feature, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.2.3/1 (2017-08-16) ------------------------------------------ [HVR-3581] FILEFORMAT /AVRO, INTEGRATE /MAXFILESIZE MIGHT NOT BE RESPECTED FOR FIRST FILE OF CYCLE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3511] FIXED F_JD0A73 DURING CAPTURE OF AN ABORTED LOB OPERATION FROM SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-3499] FIXED FILEFORMAT /CSV /ENCODING FOR NON-UTF8 ENCODINGS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3564] FIXED HVR REFRESH FAILED TO CONVERT TIMESTAMP IN HVR_JOB TABLE DUE TO TIMEZONE CONVERSION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3558] FIXED INTEGRATE /TIMEKEY /BURST FOR UPDATES ON INGRES AND MYSQL: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3579] FIXED SIGSEGV DURING CONNECT TO HIVE LOCATION IF INTERNAL ERROR OCCURS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3529] FIXED SOFTDELETE COLUMN IS MENTIONED TWICE DURING INTEGRATE IF THE COLPROPS CONTAINS DATATYPE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-3572] FIXED FOOTER OF CSV(/FILETERMINATOR) AND AVRO FILES IN CERTAIN CASES WITH MULTIPLE TABLES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3555] NORMALIZED HUB-NAMES ARE NOT LOWER-CASE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-3513] W_JT002D (UNEXPECTED ROW ORDERING) WHEN USING /BASENAME ON KEY COLUMNS: To fix this bug, upgrade HVR on the hub machine(s). NEW FEATURES IN HVR 5.2.3/0 (2017-08-01) ---------------------------------------- [HVR-3060] ADD SUPPORT FOR POSTGRESQL CAPTURE VIA SQL INTERFACE: To use this feature, upgrade HVR on the capture machine(s). [HVR-2138] ADD SUPPORT FOR POSTGRESQL VERSION 9.6: To use this feature, upgrade HVR on the capture machine(s). [HVR-3347] ADDED GUI SUPPORT FOR HVRCOMPARE -M SELMOMENT: To use this feature, upgrade HVR on the gui machine(s). [HVR-3333] ADDED GUI SUPPORT FOR HVRREFRESH -MSERIALIZABLE AND -MSNAPSHOT: To use this feature, upgrade HVR on the gui machine(s). [HVR-2396] ADDED KAFKA PIPE INTEGRATED WITH KAFKA CONNECT AND SCHEMA REGISTRY: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-3409] ADDED SUPPORT FOR ADAPTDDL ACTION FOR SQL SERVER LOCATIONS WITH /LOGREADMETHOD=SQL: To use this feature, upgrade HVR on the hub machine(s). [HVR-2409] ADDED SUPPORT FOR AMAZON S3 SERVER SIDE ENCRYPTION: To use this feature, upgrade HVR on the gui and integrate machine(s). [HVR-3168] INTEGRATE /REORDERROWS=GROUP_BY_TABLE,BATCH_BY_TABLE PERFORMANCE IMPROVEMENTS: To use this feature, upgrade HVR on the integrate machine(s). [HVR-3440] PERFORMANCE IMPROVEMENTS FOR FILEFORMAT /CSV: To use this feature, upgrade HVR on the integrate machine(s). [HVR-3431] PERFORMANCE IMPROVEMENTS FOR FILEFORMAT /CSV /ESCAPECHARACTER: To use this feature, upgrade HVR on the integrate machine(s). [HVR-3436] PERFORMANCE IMPROVEMENTS FOR FILEFORMAT /CSV, /XML, /AVRO: To use this feature, upgrade HVR on the integrate machine(s). [HVR-3111] ROUND DECIMAL VALUES WITH PRECISION GREATER THAN 34 DURING CAPTURE FROM HANA: To use this feature, upgrade HVR on the capture machine(s). [HVR-3428] TABLEPROPERTIES /CHARACTERMAPPING PERFORMANCE IMPROVEMENTS: To use this feature, upgrade HVR on the capture and integrate machine(s). [HVR-3437] UNCOMPRESION PERFORMANCE IMPROVEMENTS FOR ZREL (DEFAULT) COMPRESSION: To use this feature, upgrade HVR on the integrate machine(s). [HVR-2868] HVRREFRESH -MSERIALIZABLE FOR ORACLE/SQLSERVER/POSTGRESQL, HVRCOMPARE -MNOW, HVRREFRESH -M -Q IMPROVEMENTS: To use this feature, upgrade HVR on the capture and hub machine(s). PROBLEMS FIXED IN HVR 5.2.3/0 (2017-08-01) ------------------------------------------ [HVR-2967] /INTEGRATEEXPRESSION IS NOT ALWAYS EVALUATED ON UPDATE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-900] DB2 (LUW): FIXED SOMETIMES INCORRECTLY CAPTURED UPDATES TO EMPTY STRING OF LOBS IN VALUE COMPRESSED TABLES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-3458] FIXED CHARACTER MAPPING SILENTLY COPYING THE MAPPING VALUE WHEN IT'S INVALID: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2767] FIXED F_JD0A46: SQL SERVER SYSTEM DATA TYPE 0 [UNKNOWN] DOES NOT MATCH THE ENROLLED DATATYPE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2235] FIXED F_JD20F2 DURING CAPTURE REWIND FROM SQL SERVER 2012 IN DIRECT LOG READ MODE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-3412] FIXED F_JD21DD: COLUMN WITH NON-ASCII CHARACTERS NOT FOUND DURING ROW-WISE COMPARE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2665] FIXED F_JD2209 UPDATE AFFECTED TOO MANY ROWS DURING INTEGRATE TO HANA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1282] FIXED F_JD22FC ERROR MESSAGE HAS INVALID PARAMETERS ORDER: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3452] FIXED F_JG200A WHEN REFRESHING LARGE CLOBS INTO AVRO: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2980] FIXED F_JG2468: DELETE OF CAP JOB SCRIPT FAILS BECAUSE FILE IS BUSY: To fix this bug, upgrade HVR on the hub machine(s). [HVR-3435] FIXED F_JZ0A3C DURING CAPTURE OF NEGATIVE DECIMAL VALUES FROM HANA: To fix this bug, upgrade HVR on the capture machine(s). [HVR-3052] FIXED ORA-01408: SUCH COLUMN LIST ALREADY INDEXED DURING STATE TABLE CREATION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-3448] FIXED PDF ITEMS WITH UNDERSCORE NOT BEING SEARCHABLE IN HVR MANUAL: To fix this bug, upgrade HVR on the gui machine(s). [HVR-3405] FIXED SQL SERVER LOG-BASE CAPTURE RETURNS VALID XML DOCUMENTS THAT ARE NOT CHARACTER-BY-CHARACTER IDENTICAL TO XML DOCUMENTS THAT SELECT STATEMENT WOULD RETURN: To fix this bug, upgrade HVR on the capture machine(s). [HVR-743] FIXED CHECKING HVR_HUB_CHARSET DURING ECHO -C: To fix this bug, upgrade HVR on the hub machine(s). [HVR-3445] FIXED INTERNAL COLUMN GETTING FROM N[VAR]CHAR COLUMNS: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-2836] FIXED REPORTING OF KAFKA BROKER ERRORS IN AGENT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2719] FIXED SLOW ORACLE LBC FOR TABLES WITH MANY COLUMNS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2742] MISMATCH IN COLUMN NUMBERS FOR LOP_REPL_COMMAND CHANGE WHEN PROCESSING DDL DROP COLUMN WITH CONSTRAINT: To fix this bug, upgrade HVR on the capture machine(s). [HVR-956] TASK NAME CONTROL ALLOWS CHARACTERS ACCORDING TO IDENTIFIER NAMING: To fix this bug, upgrade HVR on the gui machine(s). NEW FEATURES IN HVR 5.1.4/0 (2017-01-20) ---------------------------------------- [HVR-2272] ADAPT DETECTION OF INDEX AND KEY CHANGE DDL IN ORACLE: To use this feature, upgrade HVR on the capture machine(s). [HVR-2503] ADAPTDDL SUPPORT FOR ALTER TABLE WITH COLUMN ENCRYPTION CHANGES ON ORACLE: To use this feature, upgrade HVR on the capture and hub machine(s). [HVR-2317] ADD SUPPORT FOR AZURE SQL DATA WAREHOUSE AS A TARGET: To use this feature, upgrade HVR on the integrate machine(s). [HVR-2288] ADD SUPPORT FOR POSTGRESQL TIME AND TIME WITH TIME ZONE DATATYPES: To use this feature, upgrade HVR on all machine(s). [HVR-2304] ADD SUPPORT FOR BI-DIRECTIONAL REPLICATION FOR POSTGRESQL: To use this feature, upgrade HVR on the capture machine(s). [HVR-2366] ADDED TRANSFORM ACTION PLUGIN HVRMASKSHUFFLE.PY FOR COLUMN MASKING: To use this feature, upgrade HVR on the capture, hub and integrate machine(s). [HVR-2267] ADDED SUPPORT FOR NON AUTO-LOGIN ORACLE WALLETS: To use this feature, upgrade HVR on the capture and hub machine(s). [HVR-2456] AUTO-NEGOTIATE COMPRESSION OPTIONS ON REPLICATION IF CAP/INTEG ARE NEWER THAN HVR 5.0.4 (HVR-1580): To use this feature, upgrade HVR on the hub machine(s). [HVR-2513] AZURE SQL DATA WAREHOUSE / USE HASH DISTRIBUTION WHEN CREATING TABLES: To use this feature, upgrade HVR on the integrate machine(s). [HVR-2410] CAPTURE DATA FROM ORACLE ARCHIVE-ONLY SOURCE: To use this feature, upgrade HVR on the capture and hub machine(s). [HVR-1896] COLUMNPROPERTIES /TIMEKEY NOW IMPLIES /KEY: To use this feature, upgrade HVR on the hub machine(s). [HVR-2159] DB2 FOR I / ADD SUPPORT FOR RCVSIZOPT(*MAXOPT2) USING FIXLENDTA(*SYSSEQ): To use this feature, upgrade HVR on the capture machine(s). [HVR-1573] DETECTION OF KEY AND INDEX CHANGES FOR ADAPTDDL IN SQL SERVER: To use this feature, upgrade HVR on the capture machine(s). [HVR-1576] HDFS SUPPORT FOR WINDOWS: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-98] INCREASED NETWORK PERFORMANCE ON LINUX AND WINDOWS BY ENABLING NETFLOOD: To use this feature, upgrade HVR on the hub and remote machine(s). [HVR-2505] INCREASED NETWORK PERFORMANCE ON NON-LINUX/WINDOWS BY DISABLING GUARDIANS ON SOURCE LOCATIONS: To use this feature, upgrade HVR on the hub and remote machine(s). [HVR-2079] LOCAL FILE LOCATION SUPPORTS AVRO FILE FORMAT: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-2079] NEW AVRO DATA TYPE CONVERTOR: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-2425] SHOW CONFIRMATION POP-UP BEFORE STARTING HVR REFRESH FROM GUI: To use this feature, upgrade HVR on the gui machine(s). [HVR-2394] SUPPORT LOG-BASED CAPTURE FROM HANA (COLUMNSTORE TABLES ONLY): To use this feature, upgrade HVR on the capture and hub machine(s). [HVR-2351] TABLE EXPLORE SENSITIVITY CAN BE CHANGED: To use this feature, upgrade HVR on the hub and gui machine(s). [HVR-2413] WORKAROUND FOR SAPXFORM CHANNEL WITHOUT SAPAUGMENT: To use this feature, upgrade HVR on the hub machine(s). [HVR-2358] BUILD HVR GUI ON MACOS: To use this feature, upgrade HVR on the gui machine(s). [HVR-2511] HVRREFRESH -M NOW, -M SCN=, -M HVR_TX_SEQ=, -M FOR ORACLE FLASHBACK: To use this feature, upgrade HVR on the capture and hub machine(s). [HVR-2490] HVRROUTERVIEW AUTO DETECTS COMPRESSION OF TX FILES: To use this feature, upgrade HVR on the hub machine(s). PROBLEMS FIXED IN HVR 5.1.4/0 (2017-01-20) ------------------------------------------ [HVR-2434] ADAPTDDL FOR SQL SERVER DOES NOT WORK FOR TABLES WITH AN UPPER CASE CHARACTER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2321] COLUMNPROPERTIES /EXTRA /KEY NOW ALWAYS EXTENDS THE KEY, NEVER REPLACES IT: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2142] DATA TYPE DROP DOWN MENU IN GUI DOES NOT SHOW 'INTEGER' ANYMORE: To fix this bug, upgrade HVR on the gui machine(s). [HVR-2439] DO NOT SHOW CONFIRMATION POP-UP FOR COMPARE: To fix this bug, upgrade HVR on the gui machine(s). [HVR-2314] ENHANCED REPORTING OF TABLE DIFFERENCES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2495] F_JD0F03: UNABLE TO CREATE SQL SINCE [GREENPLUM] DOES NOT SUPPORT 'NUMBER': To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-2480] F_JG2142: FPROC INVOCATION DID NOT MATCH THE EXPECTED PROTOTYPE $AVRO: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-2277] F_JT080A: UNEXPECTED NUMBER OF REMAPPED PARTITION IDS IN ZOP ALTER_TABLE IN DEMO84: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1965] FIX SOFTDELETE WITH /DUPLICATEROWS AND /BURST: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2423] FIX SOFTDELETE WITH TABLEPROPERTIES /DUPLICATEROWS FOR TRICKLE INTEGRATE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2464] FIXED AZUREDW GETTING F_JD21B7 WHEREAS OTHER ERROR CODE IS EXPECTED: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2344] FIXED CAPTURE /NOTRUNCATE IS AVAILABLE FOR SQL SERVER: To fix this bug, upgrade HVR on the hub and gui machine(s). [HVR-2348] FIXED CREATE TABLE FOR DATATYPES WITH PRECISION 0: To fix this bug, upgrade HVR on all machine(s). [HVR-2283] FIXED CURRENT TRANSACTION IS ABORTED, COMMANDS IGNORED UNTIL END OF TRANSACTION BLOCK DURING REFRESH TO GP: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2375] FIXED F_JC0524 ON INCOMING SSL CONNECTIONS TO HVRPROXY: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2466] FIXED F_JD20F2 (NO PERMISSIONS TO RUN DBCC LOGINFO) DURING HVRINIT WHEN CAPTURING FROM SQL SERVER IN REDUCED PERMISSION MODEL: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2449] FIXED F_JD20F2 DURING BULK REFRESH INTO AZURE SQL DW: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2539] FIXED F_JD20F2 HVRADAPT OF A AZURE SQL DW DISTRIBUTION COLUMN FAILS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1903] FIXED F_JD2149 DATE CONTAINING NANOSECONDS ENCOUNTERED WHEN REPLICATING FROM SQL SERVER TO ORACLE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1614] FIXED F_JD2149 WITH GREENPLUM TARGET WITH TIMESTAMP WITH TIME ZONE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2270] FIXED F_JD21AE WHEN CONNECTING TO A NAMED DB2 FOR I DATABASE: To fix this bug, upgrade HVR on all machine(s). [HVR-2515] FIXED F_JD22B9: UNSUPP. TSTAMP VALUE '0000-12-30 23:59:59' DURING POSTGRES COMPARE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2279] FIXED F_JD22C0 UNEXPECTED DATATYPE WHILE HANDLING GREENPLUM TIME: To fix this bug, upgrade HVR on all machine(s). [HVR-2316] FIXED F_JD22D4 FOR POSTGRESQL VERSIONS <= 9.3 AS TARGET: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2207] FIXED F_JD2424 DURING ORACLE LBC WITH DBCAPTURE /COALESCE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2368] FIXED F_JG0533: INVALID COMBINATION OF AWS CREDENTIALS WHEN USING ROLE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2450] FIXED F_JG200A SEGMENTATION VIOLATION DURING HVRINIT FOR SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2453] FIXED F_JG2142: ADAPTDIFF DID NOT MATCH THE EXPECTED PROTOTYPE: To fix this bug, upgrade HVR on the gui machine(s). [HVR-2269] FIXED F_JG2169 INVALID MONTH 0 ENCOUNTERED WHILE SELECTING FROM GREENPLUM TIMESTAMP WITH TIME ZONE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2455] FIXED F_JG2228 (OUT OF MEMORY) DURING REFRESH INTO RS AND GP ON LOW MEMORY SYSTEMS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2268] FIXED F_JG242A WHEN DISPLAYING "ROUTER ROWS" COLUMN IN GUI: To fix this bug, upgrade HVR on the gui machine(s). [HVR-2427] FIXED F_JG245E INVALID HEX STRING WITH ORACLE COLUMN ENCRYPTION: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2303] FIXED F_JG2901: INVALID UTF-8 DURING DB2 FOR I CLOB REPLICATION: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2260] FIXED F_JG2902 FOR ORACLE BY ALLOWING TABLEPROPERTIES /IGNORECOERCEERRORS AFFECT CAPTURING DATA: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2362] FIXED F_JG290D: MISSING FILE DURING REPLICATION INTO S3 LOCATION ROOT DIRECTORY: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2227] FIXED F_JR0148 DURING TABLE EXPLORE FOR POSTGRESQL VARCHAR WITHOUT EXPLICIT LENGTH: To fix this bug, upgrade HVR on all machine(s). [HVR-2507] FIXED F_JT0D03: PIPE 'AVRO' ENCOUNTERED UNEXPECTED FIELD TYPE '3' FOR COLUMN WITH INTEG EXPRESSION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2404] FIXED HANA F_JG2142: FPROC INVOCATION DID NOT MATCH THE EXPECTED PROTOTYPE: LICATTACH: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2352] FIXED HVR USES POSTGRES INSTEAD OF AMAZON ODBC DRIVER FOR REDSHIFT ON WINDOWS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2373] FIXED HVRADAPT DOES NOT UPDATE ENCODING FOR DB2I CHAR, BINARY AND CLOB DATATYPES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2313] FIXED HVRADAPT FAILS WITH UNIQUE CONSTRAINT VIOLATION IF COLUMNPROPERTIES /ABSENT IS DEFINED: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2264] FIXED ORACLE LBC F_JT0450 PIPE TXGGROUP FOR ORPHANED TX: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2445] FIXED POSTGRESQL F_JD0205 UNEXPECTED NUMBER OF COLUMNS ENCOUNTERED WHILE SCANNING LOG RECORD WHEN UNSUPPORTED DATA TYPE IN TABLE: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-2370] FIXED S3 KEYID AND ROLE CHANGES DO NOT UPDATE THE TEST CONNECTION BUTTON: To fix this bug, upgrade HVR on the gui machine(s). [HVR-2337] FIXED SAP KEY UPDATE IS AUGUMENTED TO MULTI DELETE AND UPDATE INSTEAD OF INSERT: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2252] FIXED SEGVIOL WHILE INTEGRATION TIMESTAMP WITH TIME ZONE VALUE INTO GREENPLUM AND TERADATA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2291] FIXED SIGSEGV WHEN TRYING TO ADD COLUMNPROPERTIES ACTION: To fix this bug, upgrade HVR on the gui machine(s). [HVR-2253] FIXED TIMESTAMP WITH TIME ZONE COMPARE DIFFERENCES REPORTED FOR VALUES AT THE SAME TIME: To fix this bug, upgrade HVR on all machine(s). [HVR-2246] FIXED TABLE EXPLORE 'ONLY CURRENT SCHEMA' DOESN'T WORK WITH FILTERS: To fix this bug, upgrade HVR on the gui machine(s). [HVR-2528] FIXED TABLE EXPLORE ALWAYS SHOWS DIFFERENT FOR ORACLE FLOAT COLUMNS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2349] FIXED TABLE EXPLORE FAILING TO REPORT DIFFERENCES WHEN PRECISION IS ZERO ON ONE SIDE AND NON-ZERO ON THE OTHER SIDE: To fix this bug, upgrade HVR on all machine(s). [HVR-1620] FIXED TABLE EXPLORE HANDLING OF ORACLE NUMBER(*,N): To fix this bug, upgrade HVR on all machine(s). [HVR-2395] FIXED TABLE EXPLORE REPORTS CHAR ENCODING CHANGED FOR CLOB COLUMNS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2392] FIXED TABLE EXPLORE SHOWS "DATATYPE CHANGED" FOR DECIMAL COLUMNS IN SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2406] FIXED TABLE EXPLORE WITH 'IGNORE COMPATIBLE DTYPES' ALWAYS SHOWS DIFFERENT FOR DB2I DATE COLUMNS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2431] FIXED TABLE EXPLORE WITH 'IGNORE COMPATIBLE DTYPES' ALWAYS SHOWS DIFFERENT FOR ORACLE CHAR COLUMNS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2440] FIXED TABLE EXPLORE WITH 'IGNORE COMPATIBLE DTYPES' ALWAYS SHOWS DIFFERENT FOR SQL SERVER MONEY COLUMNS: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-2406] FIXED TABLE EXPLORE WITH 'IGNORE COMPATIBLE DTYPES' ALWAYS SHOWS DIFFERENT FOR DATE COLUMNS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2357] FIXED TABLEEXPLORE ALWAYS REPORTS 'ONLY IN CHANNEL' FOR DB2 (LUW) TABLES THAT EXIST IN DB: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2367] FIXED UNICODE TO ASCII CONVERSION FOR MAXIMAL ODD SOURCE LENGTH: To fix this bug, upgrade HVR on the hub machine(s). [HVR-777] FIXED BINARY AND CHARACTER STRINGS TRUNCATION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2327] FIXED BULK LOAD INTO TERADATA 14.10 TABLES WITH SECONDARY INDEX: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2326] FIXED BULK LOAD INTO NON-EMPTY TABLES WITH TERADATA 14.10: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2074] FIXED COMPARE DIFFERENCES FOR DB2 FOR I (VAR)CHAR DATATYPE WITH /BURST: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2204] FIXED DIFFERENCE IN BULK AND ROWWISE COMPARE FOR TABLE WITH SPACES IN THE NAME: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-2488] FIXED EMPTY COLUMN NAMES WHEN HIVE PLUGIN CREATES HBASE TABLES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2265] FIXED FILE SYNCING ON WINDOWS (F_JT0422): To fix this bug, upgrade HVR on the hub machine(s). [HVR-2287] FIXED FLOODING BY WARNINGS: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-2266] FIXED HVRADAPT ISSUE FOR TABLES WITH COLUMNS HAVING COLUMNPROPERTY /ABSENT DEFINED: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2376] FIXED HVRPROXY REJECTING RULES WITH AND : To fix this bug, upgrade HVR on the proxy machine(s). [HVR-2411] FIXED HVRSTRIP -P DELETES SAPXFORM AND ADDITIONAL LICENSE FILES: To fix this bug, upgrade HVR on all machine(s). [HVR-2355] FIXED INCORRECT 'COL RANGE BECAME BIGGER' FOR DB2 FOR I AND REDSHIFT TIMESTAMP COLUMNS: To fix this bug, upgrade HVR on all machine(s). [HVR-2292] FIXED INCORRECT BULK COMPARE DIFFERENCES FOR ANSIDATE: To fix this bug, upgrade HVR on all machine(s). [HVR-2397] FIXED IRREGULAR OUTPUT "UNABLE TO LOAD NATIVE-HADOOP LIBRABY" IN HVRSTATISTICS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2369] FIXED LOCATION DIALOG DOESN'T RESTORE PROPERLY INCOMPLETED URLS: To fix this bug, upgrade HVR on the gui machine(s). [HVR-2306] FIXED MISSING BSEG ROWS DURING REPLICATION: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2504] FIXED OCCASIONAL F_JD0A68 DURING LOG-BASED CAPTURE FROM SQL SERVER 2016 USING DIRECT LOG-READ METHOD: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2205] FIXED PARSING NEGATIVE TIMESTAMPS IN HVRSTATISTICS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2402] FIXED PATTERN TABLE FILTERS IN ACTION DIALOG DON'T FILTER INTO ACTION PANE: To fix this bug, upgrade HVR on the gui machine(s). [HVR-2372] FIXED SENSE OF S3 BUCKET RETURNS ALWAYS TRUE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2209] FIXED SYNTAX ERROR WHEN HVR REFRESHES TABLE WITH SPACES INTO INGRES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2527] FIXED UNPREDICTED BEHAVIOR FOR COMBINATION OF CAPTURE EXPRESSION AND COLUMNPROPERTIES /ABSENT: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2429] FIXED WRONG BEHAVIOR OF TABLE EXPLORE CHECK BOX "IGNORE DIFFERENT BUT COMPATIBLE DATATYPES": To fix this bug, upgrade HVR on the gui machine(s). [HVR-2172] FIXED WRONG REFRESH ON DROP COLUMN: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1150] FIXED: HVR NOT COMPATIBLE WITH HDFS 2.6 CLIENT AND ABOVE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2378] HVR DOES NOT SUPPORT SPACES AND SPECIAL CHARACTERS IN THE PATH: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-2496] HVR SKIPS RENAME EXPRESSION WITH COLUMN NAME FOR AVRO FORMAT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2315] HVRGUI TBL EXPLORE DETAILS CONTINUOUSLY SHOWS AN HOUR GLASS: To fix this bug, upgrade HVR on the gui machine(s). [HVR-2457] SALESFORCE INTEGRATION CSV FILE NAMES DON'T START WITH SF-: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2412] TABLE EXPLORE (HVRADAPT) WORKS TOO LONG FOR BIG CHANNELS: To fix this bug, upgrade HVR on the hub and capture machine(s). NEW FEATURES IN HVR 5.1.1/5 (2016-11-17) ---------------------------------------- [HVR-2217] ADDED HELP BUTTON IN TABLE EXPLORE FILTER DIALOG: To use this feature, upgrade HVR on the gui machine(s). [HVR-2058] ADDED SUPPORT FOR TDE UNDER ORACLE 11, HARDWARE WALLETS AND HVRLOGENCAP: To use this feature, upgrade HVR on the hub and capture machine(s). [HVR-2058] ADDED SUPPORT FOR COLUMN ENCRYPTION: To use this feature, upgrade HVR on the capture and hub machine(s). [HVR-2219] ADDED SUPPORT OF WRITING DATA PER TOPIC IN HVRKAFKAAGENT: To use this feature, upgrade HVR on the integrate machine(s). [HVR-2181] HVR SUPPORTS S3 AS FILE LOCATIONS: To use this feature, upgrade HVR on the gui and hub machine(s). [HVR-2179] IMPROVED PERFORMANCE ON UNIX DURING CERTAIN DATATYPE CONVERSIONS: To use this feature, upgrade HVR on all machine(s). [HVR-2185] PER-COLUMN COERCION PERF IMPROVEMENTS FOR PROJECT, CSV, XML: To use this feature, upgrade HVR on the capture, hub and integrate machine(s). [HVR-2201] SAP TABLE EXPLORE FILTER WORKS FOR PACK TABLES: To use this feature, upgrade HVR on the capture and hub machine(s). [HVR-2218] TRANSFORM ACTION PREPENDS $HVR_TRANSFORM_PATH TO OS PATH IF SET: To use this feature, upgrade HVR on the capture, hub and integrate machine(s). [HVR-2163] UNXML PER-COLUMN PERFORMANCE IMPROVEMENTS FOR TRANSFORM: To use this feature, upgrade HVR on the capture, hub and integrate machine(s). PROBLEMS FIXED IN HVR 5.1.1/5 (2016-11-17) ------------------------------------------ [HVR-2135] BURST INTEGRATION INTO XTREMEDATA FAILS WITH F_JD22D4: DBMS ERROR [ERROR: DBX-85053: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2176] FIXED /ONERRORSAVEDFAILED NOT APPLYING ROWS TO FAIL TABLES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2193] FIXED CSV F_JG0E0B WITH MULTI-CHARACTER SEPARATORS AND SINGLE-BYTE ENCODING: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2130] FIXED E_QE0113_PARAM_CONVERSION ERROR CONVERTING VALUE FOR THE DBPROC BOOLEAN PARAMETER: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2194] FIXED F_JD20F2: 'TRIM' IS NOT A RECOGNIZED FUNCTION DURING SQL SERVER SAP TABLE EXPLORE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2242] FIXED F_JD2163: VARBYTE VALUE DOES'T FIX FOR SAP CLUSTER TABLES INTEGRATE INTO TERADATA: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1803] FIXED F_JD223A: UNEXPECTED DTYPE '6' [ING_DATE] ENCOUNTERED FOR COL5 [HVR_CAP_TSTAMP] OF TABLE WHILE CREATING DB2I DA: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-2170] FIXED F_JG2142: FPROC PROTOTYPE MISMATCH: SELECT DURING IN SAP CHANNEL: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2199] FIXED F_JG2302 DURING ROW-WISE REFRESH OF A TABLE NAME CONTAINING SPACES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2224] FIXED F_JG2459: GET VALUE OF 'CH_SRC' FAILED DURING SAPX HVRINT: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2171] FIXED F_JG2901: INVALID UTF8 SEQUENCE DURING INTEG INTO GREENPLUM OF SAP CLUSTER TABLES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2169] FIXED F_JT053D DURING BURST INTEGRATE OF TABLES WITH DUPLICATES TO GREENPLUM: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2208] FIXED GUI NOT SAVING ANY NEW CATALOG CHANGES AFTER SPECIFIC USER INTERACTION UNTIL RECONNECT: To fix this bug, upgrade HVR on the gui machine(s). [HVR-2223] FIXED URL LOCATION PASSWORD ERRORS: To fix this bug, upgrade HVR on the gui and hub machine(s). [HVR-2145] FIXED CAPTURE LATENCY NUMBERS: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-2164] FIXED DOUBLE CLICKING ON HUB VERSION THROWING F_JB0027: INTERNAL ERROR: To fix this bug, upgrade HVR on the gui machine(s). [HVR-2146] FIXED MISSING EMAIL SUBJECT IN SOME CASES IN HVRMAINT: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2191] FIXED PARSING PACKED/UNPACKED MESSAGES FOR HVRSTATISTICS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2184] FIXED SHOWING ADAPT DDL MESSAGES AS IRREGULAR OUTPUT: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2183] FIXED SHOWING AUGMENT INFO AS IRREGULAR OUTPUT: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2195] SQL SERVER LBC FAILS WITH F_JD20F2: CONNECTION IS BUSY: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2197] UPDATE SINGLE BIT COLUMN IN SQL SERVER RESULTS IN MULTIPLE BIT COLUMNS BEING UPDATED: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2143] HVRKAFKAAGENT.PY IS IN WINDOWS FORMAT ON LINUX: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2177] SAPXFORM.SH LOADS MONO SYSTEM CONFIGURATION $MONO_PREFIX/ENV.SH AT STARTUP: To fix this bug, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.1.1/4 (2016-11-04) ------------------------------------------ [HVR-2140] FIXED F_JD20DB DBMS ERROR [ORA-01000: MAXIMUM OPEN CURSORS EXCEEDED] DURING BULK REFRESH OF MULTIPLE TABLES: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-2167] FIXED F_JD21DD: "COL NOT FOUND IN COL LIST" DURING GREENPLUM INTEG WITH COLUMNPROPERTIES /EXTRA /KEY (INTRODUCED BY HVR-2144): To fix this bug, upgrade HVR on the hub machine(s). [HVR-2136] FIXED F_JD22D4 ERROR: DBX-83016 CANNOT ALTER SCATTER COLUMN RELATION FOR POSTGRESQL: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.1.1/3 (2016-11-03) ---------------------------------------- [HVR-2156] CIRCUMVENT PROCESS MEMORY LEAKS FOR TRANSFORM ON LINUX: To use this feature, upgrade HVR on the integrate machine(s). [HVR-2082] HIVE AGENT USES HVR_HIVE_HOST ENV VARIABLE FOR HIVE SERVICE: To use this feature, upgrade HVR on the integrate machine(s). [HVR-2144] PARAMETER /PARALLEL FOR ACTION TRANSFORM: To use this feature, upgrade HVR on the hub and integrate machine(s). PROBLEMS FIXED IN HVR 5.1.1/3 (2016-11-03) ------------------------------------------ [HVR-2155] FIXED F_JD20FF DURING BURST RECOVERY INTO TERADATA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2161] FIXED F_JD2528 DURING LOG BASED CAPTURE FROM DB2 (LUW): To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-1003] FIXED STAGING AWS CREDENTIALS ARE KEPT UNENCRYPTED IN HVR CATALOGS: To fix this bug, upgrade HVR on the hub and gui machine(s). [HVR-2151] FIXED REFRESH-LESS ALTER TABLE DOES NOT WORK WITH RESILIENT: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-2053] FIXED REPORTING HVRROUTERVIEW ERRORS IN HVRMAINT: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2154] FIXED WARNING W_JT1475 DURING DELETE INTEGRATION IN SAP CHANNELS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2150] KAFKA INTEGRATION ERROR MESSAGE IS NOT HELPFUL: To fix this bug, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.1.1/2 (2016-10-26) ------------------------------------------ [HVR-2060] FIXED WRITING UNICODE BYTE ORDER MARK UNTIL FIRST DATA WRITE AT LOGFILES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2133] FIXED F_JD22D0 DURING LOG BASED CAPTURE FROM DB2 (LUW): To fix this bug, upgrade HVR on the capture machine(s). [HVR-1826] FIXED W_JD2901 DURING PARALLEL REFRESH INTO TERADATA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2134] FIXED ARCHIVE LOGGING WARNING M_JT0500, W_JT0500 INCORRECTLY REFERS TO APPEND HINT CHANGES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2078] FIXED COLUMN NAME SUBSTITUTION ERROR IN /RESTRICT ACTION FOR DB2I: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-2131] FIXED NEGATIVE PATTERN IN TABLE FIELD OF HVR ACTION CAN NOT BE RENAMED: To fix this bug, upgrade HVR on the hub and gui machine(s). NEW FEATURES IN HVR 5.1.1/1 (2016-10-20) ---------------------------------------- [HVR-2122] ENHANCED COMPRESSION SPEED AND RATIO OF LARGE SETS OF SORTING DATA: To use this feature, upgrade HVR on the integrate machine(s). [HVR-2120] ENHANCED COMPRESSION SPEED AND RATIO OF VERY LARGE BUFFERED TRANSACTIONS: To use this feature, upgrade HVR on the capture machine(s). [HVR-2106] ORACLE 12 SUPPORT FOR SOLARIS SPARC: To use this feature, upgrade HVR on the capture machine(s). [HVR-1561] SORTING WARNS IF IT USES TEMP FILES AND RECOMMENDS $HVR_SORT_BYTE_LIMIT VALUE TO AVOID IT: To use this feature, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.1.1/1 (2016-10-20) ------------------------------------------ [HVR-2127] FIXED F_JD20FF DURING TABLE EXPLORE FROM ORACLE SAP SYSTEM: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2124] FIXED HVR LOOKS IN WRONG SCHEMA FOR SAP DICTS IF TABLEPROPERTIES /SCHEMA IS DEFINED ON THE TARGET: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2125] FIXED UNKNOWN COLUMN AS4LOCAL ERROR DURING CREATION OF SAPENROLL FILE: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-2094] FIXED 'F_JX_OPEN_FILE: CAN NOT OPEN FILE '/HOME/JIGSAW/DEV/JHVOM/HVR_CONFIG/TMP/HVR.OUT.HVRMAINT_TMP' IN HVRMAINT: To fix this bug, upgrade HVR on the hub machine(s). NEW FEATURES IN HVR 5.1.1/0 (2016-10-18) ---------------------------------------- [HVR-1998] ADD CAPABILITY TO WORK WITHOUT HVR_SYS_TABLE FOR ORACLE CAPTURE LOCATIONS: To use this feature, upgrade HVR on the capture and integrate machine(s). [HVR-2044] ADDED SUPPORT FOR DB2 FOR I CCSID 500 INTL EBCDIC: To use this feature, upgrade HVR on the capture machine(s). [HVR-2058] ADDED SUPPORT FOR ORACLE TDE WITH AUTO-LOGIN WALLETS: To use this feature, upgrade HVR on the capture machine(s). [HVR-2043] ADDED {HVR_TBL_NAME} TO ALLOWED COLUMNPROPERIES /INTEGRATEEXPRESSION: To use this feature, upgrade HVR on the hub machine(s). [HVR-1580] AUTO-NEGOTIATE COMPRESSION OPTIONS ON COMPARE AND REFRESH TO UTILIZE ZREL+ AND LZ4: To use this feature, upgrade HVR on the capture, hub and integrate machine(s). [HVR-2065] CAPTURE DATA FROM ORACLE ACTIVE DATA GUARD STANDBY DATABASE: To use this feature, upgrade HVR on the capture machine(s). [HVR-2018] SAPXFORM PIPELINE AND PACK/UNPACK TABLE KNOWLEDGE: To use this feature, upgrade HVR on all machine(s). PROBLEMS FIXED IN HVR 5.1.1/0 (2016-10-18) ------------------------------------------ [HVR-2006] COERCE OVER-COUNTS NUMBER OF CESU-8 CHARACTERS FOR NON-ORACLE DBMS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2056] COLUMNPROPERTIES /DATATYPE=VARCHAR /LENGTH IS MULTIPLIED TO OFTEN ON DBMS THAT USE CHARACTER LENGTH IN THE SQL FRAGMENT: To fix this bug, upgrade HVR on all machine(s). [HVR-2112] F_JD21B4: DBMS ERROR FOR V$PARAMETER DOES NOT EXIST ON CONNECTION TO HUB DATABASE: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-2052] F_JG200A DURING CAPTURE FROM SQL SERVER WHEN REPEATEDLY PROCESSING THE SAME LOB AFTER A PARTIAL ROLLBACK: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1563] F_JG2142: TABLE EXPLORE CRASHES ON WRONGLY FORMATTED DESCRIBE OUTPUT: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2047] F_JT1550 SEGMENTATION VIOLATION DURING INIT OF IOT TABLE WITH OVERFLOW: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2033] FIX ISSUE WITH DOUBLE CLICK ON DETAILS IN TABLE EXPLORE: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1924] FIXED 'GUI_HUB' COPROCESS CRASHING DURING PARALLEL REFRESH/COMPARE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2055] FIXED COLUMNPROPERTIES /EXTRA IS ALWAYS GREYED OUT: To fix this bug, upgrade HVR on the gui machine(s). [HVR-2097] FIXED COPY CHANNEL FAILS WITH F_JR0F03 FOR (VAR)CHAR DATA TYPES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1803] FIXED F_JD223A: UNEXPECTED DTYPE '6' [ING_DATE] ENCOUNTERED FOR COL5 [HVR_CAP_TSTAMP] OF TABLE WHILE CREATING DB2I DA: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-2104] FIXED F_JG221C WITH !UNMASK TAG WITH HVR 5 HUB AND HVR 4 CAPTURE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1309] FIXED GUI HANGING AFTER CATALOG EXPORT TO DIR WITHOUT PERMISSION: To fix this bug, upgrade HVR on the gui machine(s). [HVR-2077] FIXED HVR DOES NOT UPDATE MICROSECONDS FOR TIMESTAMP DTYPE WITH /BURST ON DB2 FOR I: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1831] FIXED HVRADAPT ON DB2 FOR I ALWAYS UPDATE CHANNEL CATALOGS WITH TABLES WITH CHARACTER DATATYPES: To fix this bug, upgrade HVR on all machine(s). [HVR-2036] FIXED JNLCHK THROWS F_JD0006 DURING INGRES BULK REFRESH: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2098] FIXED ORA-01439 DURING ALTER OR RECREATE TABLES IN REFRESH: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-933] FIXED SQL SERVER REFRESH BOOMERANG: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-2085] FIXED ON REDSHIFT HVRREFRESH ALLOCATES ONLY 2 BYTES PER CHARACTER INSTEAD OF 3 FOR HVR CATALOG NVARCHAR: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2086] FIXED TABLE CLEANUP DURING BULK REFRESH: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2102] FIXED UPDATE OF SAP CLUSTER TABLE DELETES VARDATA COLUMN DURING ORACLE CAPTURE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1067] FIXED ORACLE CAPTURE FAILED WITH F_JZ150F: DURING CAPTURE OF DELETE AGAINST ORACLE TABLE WITH ROWDEPENDENCIES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-2116] SIGSEGV IN TBLCLONE WHEN REPLICATION BETWEEN HVR 4 AND 5: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2017] SLOW PERFORMANCE DURING LOG-BASED CAPTURE ON ORACLE 12: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1595] TABLE EXPLORE'S DETAIL WINDOW DOES NOT SHOW LENGTH OF DB2 FOR I BINARY COLUMNS: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1629] TABLE SUPPLEMENTAL LOGGING IS DROPPED ON ORACLE WHEN DATABASE SUPPLEMENTAL (ALL) COLUMNS IS ENABLED: To fix this bug, upgrade HVR on the capture machine(s). NEW FEATURES IN HVR 5.0.4/0 (2016-09-20) ---------------------------------------- [HVR-1481] ADD MORE VALUES FOR TIME GROUP BY IN GUI FOR STATISTICS: To use this feature, upgrade HVR on the gui and hub machine(s). [HVR-1912] ADD SUPPORT FOR (RE)SETTING CAPTURE TIME WHEN CAPTURING FROM A READ-ONLY SQL SERVER DATABASE: To use this feature, upgrade HVR on the capture machine(s). [HVR-1756] ADD SUPPORT FOR AGENTPLUGIN /CONTEXT: To use this feature, upgrade HVR on the hub machine(s). [HVR-1575] ADDED HVR4 -> HVR5 AUTOMATIC CATALOG ACTION MIGRATION: To use this feature, upgrade HVR on the gui and hub machine(s). [HVR-1582] ADDED ZREL COMPRESSION OPTION FOR TABLES WITH LOB COLUMNS: To use this feature, upgrade HVR on all machine(s). [HVR-1574] ADDED LOCATION CLASS FILTER TO HIDE ACTION PARAMETERS: To use this feature, upgrade HVR on the gui machine(s). [HVR-1975] ADDED SUPPORT FOR SAP HANA AS TARGET: To use this feature, upgrade HVR on all machine(s). [HVR-881] ADDED SUPPORT FOR UNICODE FILENAMES ON WINDOWS: To use this feature, upgrade HVR on all machine(s). [HVR-1928] ALLOW -T TABLE-PATTERN AS ARGUMENT TO HVRCOMPAREDB: To use this feature, upgrade HVR on the hub machine(s). [HVR-1773] ALLOW HVRCONTROL TO SKIP STRINGS BASED ON LENGTH: To use this feature, upgrade HVR on the hub machine(s). [HVR-1569] ALTER TABLE PRESERVE OPTION: To use this feature, upgrade HVR on the integrate machine(s). [HVR-1932] CAPTURE ROWID FOR ORACLE TABLES: To use this feature, upgrade HVR on the hub, capture and gui machine(s). [HVR-1488] CHANGE DEFAULT DISTRIBUTION KEY RULE: To use this feature, upgrade HVR on the integrate machine(s). [HVR-1778] DATA EXTRACTION FROM SECURE FILES ORACLE LOBS: To use this feature, upgrade HVR on the capture machine(s). [HVR-1755] ENHANCED DB->FILE REFRESH SUPPORT ALL PARAMETERS ON INTEGRATE THAT DB->FILE REPLICATION DOES: To use this feature, upgrade HVR on the hub machine(s). [HVR-1540] FALLBACK TO DELETES FOR RECENTLY TRUNCATED BURST TABLES FOR GREENPLUM INTEGRATE SPEED: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-1874] FILEFORMAT /COMPRESS OPTION FOR FILE BASED LOCATION: To use this feature, upgrade HVR on the capture and hub machine(s). [HVR-1637] HVR ACTIONS CAN BE DEFINED WITH A PATTERN AS TABLE NAME: To use this feature, upgrade HVR on the gui and hub machine(s). [HVR-608] HVR SCHEDULER CAN WRITE BYTE ORDER MARKS TO LOGFILES: To use this feature, upgrade HVR on the hub machine(s). [HVR-2028] IMPLEMENT HIVE/HBASE AND KAFKA AGENTPLUGIN: To use this feature, upgrade HVR on the integrate machine(s). [HVR-1063] IMPLEMENT HVRLOGRELEASE GUI DIALOG: To use this feature, upgrade HVR on the gui and hub machine(s). [HVR-1573] IMPLEMENTED BASIC TABLE DDL CAPTURE FOR SQL SERVER: To use this feature, upgrade HVR on the capture machine(s). [HVR-1729] IMPLEMENTED REFRESH-LESS ALTER TABLE FOR SQL SERVER AND ORACLE: To use this feature, upgrade HVR on all machine(s). [HVR-1570] IMPROVE TBL ALTER MESSAGES: To use this feature, upgrade HVR on the integrate machine(s). [HVR-1668] IMPROVED DIALOG MESSAGE AFTER MAINTENANCE TASK HAS RUN: To use this feature, upgrade HVR on the gui and hub machine(s). [HVR-1579] NEW LZ4, GZIP, ZREL+ COMPRESSION ALGORITHMS (IF BUILT-IN) ARE EXPOSED THROUGH $HVR_COMPRESS_LEVEL: To use this feature, upgrade HVR on all machine(s). [HVR-1676] NEW PARAMETER /ABSENT FOR ACTION TABLEPROPERTIES: To use this feature, upgrade HVR on all machine(s). [HVR-1618] ONLINE REFRESH SKIPPING BASED ON HVR_TX_SEQ: To use this feature, upgrade HVR on the hub and capture machine(s). [HVR-1785] PERFORMANCE IMPROVEMENTS FOR TRANSFORM /COMMAND AND TRANSFORM /SAPXFORM: To use this feature, upgrade HVR on the capture, hub and integrate machine(s). [HVR-1940] RENAME HVRCOMPAREDB TO HVRCOMPAREDDL: To use this feature, upgrade HVR on the hub machine(s). [HVR-1848] SEND REFRESH SKIP CONTROLS TO ALL ALIAS INTEG LOCATIONS: To use this feature, upgrade HVR on the hub machine(s). [HVR-1735] SUPPORT INTEGRATE /VERBOSE FOR DATABASE->FILE REFRESH: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-1631] SUPPORT FOR SQL SERVER 2016: To use this feature, upgrade HVR on the capture machine(s). [HVR-1547] USE STATUPDATE OFF FOR REDSHIFT BURST TABLES BY DEFAULT: To use this feature, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.0.4/0 (2016-09-20) ------------------------------------------ [HVR-1674] "ALTER TABLE ADD COLUMN NOT NULL" CALLED WITHOUT DEFAULT VALUE SQL SERVER: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1675] /KEEPEXISTINGSTRUCTURE CAN MAKE THE INTEGRATE ACTION FALL OVER: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1237] ADAPTDDL (AND HVRADAPT) MISHANDLES INDEX CHANGES: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-1673] ADAPTDDL /KEEPOLDROWS TRIES TO USE UNIMPLEMENTED HVRREFRESH -CP: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1653] ADAPTDDL SHOULD CAUSE INTEGRATE TO SUBCYCLE WHEN INCOMPATIBLE CHANGES OCCUR: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-1876] CHANGED PUBLISHER IN PROGRAMS AND FEATURES TO HVR SOFTWARE: To fix this bug, upgrade HVR on the gui machine(s). [HVR-394] CHANNEL AND LOCATION IMPORT FROM XML MADE ADDITIVE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1499] COLUMNS ARE CREATED TOO LARGE ON DBMS USING THE CHARACTER LENGTH AS PARAMETER TO (VAR)CHAR: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1403] CONTROLS & ONLINE REFRESH DON'T AFFECT BURST INTEGRATE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1603] DB2 FOR I THROWS ERROR F_JR0148; ZERO BYTELENGTH FOR N(VAR)CHAR DATATYPES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1869] DDL CAPTURE DOES NOT WORK ON A BUSY SYSTEM: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1567] DANGLING POINTERS IN SCHEDULER METHODS FIXED: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1999] DEMO58 CAPTURE JOB HANGS ON LINUX, ORACLE 12: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1816] ENABLING PARTIAL LOB FLAG ON A LOB THAT SHOULD BE IGNORED: To fix this bug, upgrade HVR on the capture machine(s). [HVR-583] F_JD0700: DATA TYPE MISMATCH FOR _CLOB DATATYPE WHEN USE REDSHIFT AS TARGET LOCATION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1821] F_JD20DB: HVRREFRESH 'FORCE RECREATE' USES DIFFERENT DATA TYPE LENGTH THAN NORMAL HVRREFRESH: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1902] F_JD20F2 DURING BURST INTEGRATE INTO SQL SERVER CONNECTION BUSY] WHEN SORTING SPILLS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1684] F_JD223A: UNEXPECTED DATATYPE ENCOUNTERED WHILE CREATING DA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1812] F_JD22A1 DURING CREATION OF TARGET TABLES WITH XML OR NVARCHAR(MAX) COLUMNS IN HETEROGENEOUS CHANNEL: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1680] F_JG2901: ISO-8859-1 STRING '...' CONTAINING INVALID SEQUENCE ENCOUNTERED WHILE ENCODING NCLOB COLUMN: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1947] F_JT1446 UNKNOWN WHERE OPERATOR != CREATING CONTROL: To fix this bug, upgrade HVR on the hub, capture and integrate machine(s). [HVR-1868] F_JZ1802 APPEND HINT HEADER LAYOUT: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1608] F_JZ1802. CHANGE OF TYPE 'APPEND HINT' (19.1) IN RECORD WITH SCN DEFINES AN UNEXPECTED NUMBER 0 OF ROW AND TOKEN TAB SETS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1799] F_JZ1976. PARSER ENCOUNTERS EMPTY RECORD PIECE DURING RECORD CHAINING: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1609] FIXED "F_JG2459: GET VALUE OF VARIABLE 'TRUNC_TIME_CHANGED' FAILED" ON BURST INTEGRATE RECOVERY (INTRODUCED BY HVR-1540): To fix this bug, upgrade HVR on the hub machine(s). [HVR-1846] FIXED ADAPT ENGINE USES INVALID POINTERS WHEN ALTERING MULTIPLE TABLES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1572] FIXED ADAPTDDL DROPFROMCHANNELANDTARGET AND KEEP NOT BEHAVING AS INTENDED: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1651] FIXED ADAPTDDL NOT LISTENING TO /IGNORETABLEPATTERN: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1659] FIXED ADAPTDDL NOT UPDATING HVR CAT WHEN DECREASING VARCHAR COL RANGE ON SQL SERVER: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2011] FIXED ADD TABLE WITH MODIFIED HVR TABLE NAME DOESN'T UPDATE THE HVR CATALOGS: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1673] FIXED ALTER TABLE PRESERVE DATA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1558] FIXED COLUMNPROPERTIES /DATATYPE UN-CHECKING /EXTRA IN DIALOG: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1604] FIXED DB2 DBCLOBS CREATED FROM CATALOG WITH TOO LARGE BYTE LENGTH: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1813] FIXED DB2 FOR I BULK REFRESH MISHANDLING OF NULLS: To fix this bug, upgrade HVR on all machine(s). [HVR-1837] FIXED E_VW1085_ADCOL_UPD_CONFLICT CANNOT ADD OR DROP COLUMN FOR TABLES WITH IN-MEMORY UPDATES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1556] FIXED F_JD0A71 DURING CAPTURE OF OUT-OF-ROW (LOB) VALUES ON SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1836] FIXED F_JD0C07: ALTER TABLE SPECIAL COLUMN ERROR WHEN DROP COLUMN IN DB2I AND TD: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1686] FIXED F_JD0E02: ATTEMPT TO ALTER UNSUPPORTED TABLE MODIFY ON RESHIFT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1871] FIXED F_JD20DB WHEN HVR TRIES TO SHRINK COLUMN LENGTH: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-893] FIXED F_JD20F2 DURING CAPTURE FROM SQL SERVER 2016 USING SQL LOG READ METHOD: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1705] FIXED F_JD2100: UNSUPPORTED DTYPE FOR COL [RECOV_SQL] OF RECOVERY TABLE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2013] FIXED F_JD2103 E_DM01A0_INVALID_ALTCOL_DEFAULT NOT RECOGNIZED AS ALTER TABLE LIMITATION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1626] FIXED F_JD2146 DURING ROW-WISE REFRESH WITH /COLUMNPROPERTIES /BASENAME: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-2005] FIXED F_JD2164 ON HVR4 INTEGRATE LOCATION WHEN USING AN HVR5 CAPTURE LOCATION: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1568] FIXED F_JD21B4: ORA-00942: TABLE DOES NOT EXIST FOR ORACLE TABLE WITH SPECIAL CHARACTERS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1894] FIXED F_JD21DD IN /COALESCE WITH COLUMNPROPERTIES /EXTRA /KEY: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1121] FIXED F_JD2238: UNEXPECTED DTYPE '39' [TIME_NO_TZ] WHILE TERADATA INTEGRATE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2001] FIXED F_JD223A UNEXPECTED DATATYPE '51' ENCOUNTERED: To fix this bug, upgrade HVR on all machine(s). [HVR-1963] FIXED F_JD227D SQL0478N DROP, ALTER, TRANSFER OWNERSHIP OR REVOKE ON OBJECT TYPE "COLUMN" CANNOT BE PROCESSED DURING REFRESH: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2008] FIXED F_JD22A1 BEYOND SQL_ACTIVE_STATEMENTS LIMIT: To fix this bug, upgrade HVR on all machine(s). [HVR-1991] FIXED F_JD22A1 NUMBER OF LEADING DIGITS OUT OF RANGE WHILE CREATING TERADATA TABLE CONTAINING INTERVAL DAY TO SECOND DATATYPE: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-1937] FIXED F_JD22A1 UNEXPECTED DUPLICATION OF COL I2 IN A TABLE, DERIVED TABLE, VIEW, MACRO OR TRIGGER: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1286] FIXED F_JD22A1: PARAMETER 'HVR_CAP_USER' DOES NOT EXIST FOR TERADATA TARGET: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1615] FIXED F_JD22C4: UNEXPECTED DTYPE '43' DURING INTEGRATE INTO GREENPLUM: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1703] FIXED F_JD22CA: CLOB LOCALIZATION TO REDSHIFT VARCHAR HAS ZERO BYTE LENGTH: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1730] FIXED F_JD22CA: DBMS ERROR [ERROR: SYNTAX ERROR AT OR NEAR "." LINE 1:ALTER TABLE ... RENAME TO ...] ON REDSHIFT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1734] FIXED F_JD22D3 DURING ALTER TABLE WITH LOBS ON DB2I: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-2012] FIXED F_JD291D TPT ERROR TABLE EXISTS AFTER BULK LOAD HAS ENDED: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1692] FIXED F_JD291F: TPT INIT ERROR WHEN TRY TO INTEGRATE LOBS WITH /BURST WITH TERADATA 14.00: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1583] FIXED F_JG0A05: OPEN OF GZ FILE FAILED. ERROR: TOO MANY OPEN FILES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1587] FIXED F_JG200A DURING GUI SHUTDOWN: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1587] FIXED F_JG200A DURING HUB DISCONNECT: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1662] FIXED F_JG200A DURING UPDATE_AFTER OPERATION FOR RECREATED TABLE FOR ORACLE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1758] FIXED F_JG200A WHEN DE-SELECTING ONLINE REFRESH WITH DB->FILE REFRESH: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1702] FIXED F_JG2142 DURING ONLINE REFRESH WITH PARALLELISM FOR TABLES > 1: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1172] FIXED F_JG2142: $(TBLWRITE -C...) BACKWARD INCOMPATIBILITY: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1584] FIXED F_JG2228 DURING TBLCREATE WITH LARGE INDEXES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1669] FIXED F_JG243F DURING TRANSFORM /COMMAND OR FILEFORMAT /*CONVERTOR ON CHANNELS WITH MANY TABLES: To fix this bug, upgrade HVR on the capture, integrate and hub machine(s). [HVR-1772] FIXED F_JG2459 DURING ONLINE REFRESH WITH -QNO: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1908] FIXED F_JG2459 IN HVRSTART FOR REFRESH JOB: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1731] FIXED F_JG2901 DURING COPYING A LOCATION FROM THE GUI: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1680] FIXED F_JG2901: ISO-8859-1 STRING '...' CONTAINING INVALID SEQUENCE ENCOUNTERED WHILE ENCODING NCLOB COLUMN: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1542] FIXED F_JG2901: INVALID UTF8 STRING IN HVR_TX_SEQ DURING TRICKLE INTEGRATE: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-1935] FIXED F_JR0245 WHEN RUNNING HVR INITIALIZE FROM A V5 GUI AGAINST V4 HUB: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1911] FIXED F_JR0321 WHILE TRYING TO ADD TABLES IN HVRGUI TABLEEXPLORE: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1723] FIXED F_JR0333 DURING AUTOMATIC CATALOG UPGRADE OF TRIGGERBASED CHANNELS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1459] FIXED F_JR0336 PREVENTING TAB SWITCHES IN ACTION DIALOG: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1560] FIXED F_JR0428 INVALID IDENTIFIER FOR TABLEPROPERTIES /SCHEMA CONTAINING $: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1890] FIXED F_JT02A6: ALTER RECORD FOR TABLE ENCOUNTERED AT SCN: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-1630] FIXED F_JT048E DURING ROWWISE REFRESH WITH /EXTRA COLUMN: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1768] FIXED F_JT1448: CONTROL RESILIENCE INCREMENT FOR TABLE '
' DOES CORRESPOND TO A PREVIOUS FILTER MATCH: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1842] FIXED F_JT150B WHEN USING FILEFORMAT /CSV /QUOTECHARACTER FOR FILE CAPTURE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1681] FIXED F_JT150B: SAPXFORM 'DIVIDE BY ZERO' IF PAGELG NOT 3800: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1681] FIXED F_JT150B: SAPXFORM FAILS WITH 'DIVIDE BY ZERO' IF THE PAGELG COLUMN IN A ROW PART OF SAP MULTI-ROW CLUSTER IS NOT 3800: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1633] FIXED F_JT1550 DURING REFRESH FOR MULTIPLE LOCATIONS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1641] FIXED F_JZ1549 WITH $ZIZ_FILE_OFF_LIVE AND ORACLE ASM ARCHIVES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1887] FIXED FILTER ON TABLE EXPLORE NOT SUPPORTING SAME PATTERNS AS HVRADAPT: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1634] FIXED HVR REFRESH CREATING NTEXT COLUMNS IN SQL SERVER FOR ORACLE VARCHARS WITH UTF-8 ENCODING IF TABLEPROPERTIES /CREATEUNICODEDATATYPES IS DEFINED: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1867] FIXED HVR RESERVING 6 BYTES FOR CESU8 CHARACTERS, WHILE ORACLE USES 3 BYTES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1480] FIXED HVR_CONFIG WITH UNC PATH: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1704] FIXED HVRREFRESH UNEXPECTEDLY CONVERT "LONG RAW" TO VARCHAR(256) IN REDSHIFT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1080] FIXED HVRMAINT MISSING BURST INTEGRATE INFORMATION: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1931] FIXED INDEXCREATE FPROC NOT SUPPORTING TERADATA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1793] FIXED JT0918: COLUMN 'PAGENO' IS NOT ALLOWED AS KEY IN SAP TABLES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1825] FIXED ORA-22858: INVALID ALTERATION OF DATATYPE DURING LOB REFRESH FROM PQ TO ORA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1585] FIXED POSTGRESQL START ON LINUX BOOT USING HVR_BOOT: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1921] FIXED QESELECT FOR TABLES DOES NOT WORK WITH RESTRICTIONS WITH PATTERNS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-932] FIXED REFRESH FAILS WITH F_JD20F2 ON BI-DIRECTIONAL SQL SERVER LOG-BASED CHANNEL: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1898] FIXED SIGSEGV DURING TABLE EXPLORE IF LOADING FROM THE CATALOGS DETECTS AN ERROR: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1933] FIXED SQL0668N OPERATION NOT ALLOWED FOR REASON CODE 7 FOR DB2: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1578] FIXED SCHEDULER CAN NOT BEEN STARTED ON WINDOWS PLATFORM: To fix this bug, upgrade HVR on the remote and hub machine(s). [HVR-1886] FIXED TABLES IN SCHEMA FOR OWNER STARTING WITH 'Q' ON DB2 FOR I ARE INVISIBLE TO TABLE EXPLORE: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1715] FIXED TABLES WITH VARCHAR COLUMNS ARE ALWAYS RECREATED FOR REDSHIFT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1566] FIXED TERADATA TABLE WITH NVARCHAR IS ALWAYS ALTERED DURING REFRESH: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1748] FIXED UNEXPECTED ORA-00904 DURING TABLE STRUCTURE CHANGE WITH ADAPTDDL: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1711] FIXED UNEXPECTED ORA-01465: INVALID HEX NUMBER DURING REFRESH FROM MSS TO ORACLE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1679] FIXED W_JD0A10 DURING HVRINIT WHEN CAPTURING FROM A SQL SERVER TABLE WITH PERSISTED COMPUTED COLUMN: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1624] FIXED ADAPTDDL CONTEXT BEEING EXPOSED TO THE GUI: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1897] FIXED ADAPTENGINE NOT HANDLING SUPPLEMENTAL LOGGING AND REFRESH CORRECTLY: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1971] FIXED ADDING A TABLE TO A CHANNEL: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1882] FIXED BASE TABLE NAME IS NOT DISPLAYED PROPERLY IN TABLE EXPLORE: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1701] FIXED CAPTURE CREATING EMPTY TX FILES IF NO PER-TABLE ROUTING: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-1877] FIXED CAPTURE DOES NOT PICKUP CORRECT REDO LOGS WHEN USING VARIABLE HVR_ENROLL_VLOGFILE_RESTRICT: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1499] FIXED COLUMNS CREATED TOO LARGE ON DBMS USING THE CHARACTER LENGTH AS PARAMETER TO (VAR)CHAR: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1781] FIXED COLUMNS WITH /CAPTUREEXPRESSION IGNORING ENCODING FROM THE CATALOGS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1557] FIXED DEFAULT BEHAVIOR OF THE CAPTURE /SUPPLEMENTALLOGGING OPTION WHEN CAPTURING FROM THE SQL SERVER STANDARD EDITION: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1767] FIXED ENVIRONMENT VARIABLE READING FROM MAINTENANCE OPTION FILE: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1779] FIXED HVR_BOOT REPORTING/REFERING HVR_CONFIG AS HVR_HOME IN MESSAGES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-306] FIXED HVRCONTROL NOT RESOLVING F_JT0492: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-1717] FIXED HVRROUTERCONSOLIDATE BREAKING LATENCY REPORTING: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1885] FIXED HVRSAPXFORMGEN GENERATES PHANTOM TABLES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1683] FIXED HVRSTATISTICS IRREGULAR OUTPUT FOR ENROLL REVISION AND ADAPTDDL OUTPUT; ADD MEASUREMENT COLUMNS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1753] FIXED HVRSTATISTICS PARSING ERROR BY HVRREFRESH WITHOUT COMPRESSION: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1858] FIXED INVALID CCSID FOR CHARACTER DTYPE IN BURST TABLE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1148] FIXED LOCAL-TIMEZONE HVR_CAP_TSTAMP DATATYPE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1752] FIXED LOCALIZING DATA TYPES BASED ON DATABASE HANDLE IGNORES ENCODING: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1413] FIXED LOG FILE FOLDER NAME FOR HVRMAINT TASK: To fix this bug, upgrade HVR on the hub machine(s). [HVR-411] FIXED LOGGING IN WITH DOMAIN NAME: To fix this bug, upgrade HVR on the hub machine(s). [HVR-2007] FIXED MISSING INSERTS FOR FILE INTEGRATE WITH /SOFTDELTE AND /BURST: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1733] FIXED MISSING SCHEMA NAME FOR DB2I DURING BURST INTEGRATE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1102] FIXED NOT ALL ACTIONS WERE SHOWN AFTER UPDATING AN ACTION: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1757] FIXED ORDER DIFFERENCE BETWEEN INTEGRATE AND REFRESH OF /SOFTDELETE COLUMNS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1581] FIXED REMOTELISTENER CREATE UNDER SYSTEM ACCOUNT: To fix this bug, upgrade HVR on all machine(s). [HVR-1539] FIXED REPORTING OF INCORRECT ROW WIDTH AFTER REFRESH: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1694] FIXED SEGMENTATION FAULT DURING CAPTURE OF LOBS FROM SQL SERVER USING SQL LOG READ METHOD: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1565] FIXED SEGMENTATION FAULT WHEN IMPORTING CATALOGS FROM UNC PATH: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1661] FIXED SLOW CREATION OF TABLES WITHOUT REPLICATION KEY ON ORACLE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1838] FIXED SYNTAX ERROR FOR TBLALTER FOR TERADATA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1621] FIXED TABLE EXPLORE FILTER BEEING IGNORED: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1715] FIXED TABLES WITH VARCHAR COLUMNS ARE ALWAYS RECREATED FOR REDSHIFT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1672] FIXED TRUNCATE TABLE IN TBLINFO BREAKING INTEGRATE JOB: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1765] FIXED UNDEFINED SUBROUTINE M_JX_LATENCY_OVER_LIMIT IN HVRMAINT: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1774] FIXED UPGRADE OF HVR V4.6.1 CATALOGS TO V5 FAILS WITH F_JR0E01: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1861] FIXED USAGE OF UNINITIALIZED CHANNEL NAME IN HORIZLOOKUPTABLE PARAMETER: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1769] FIXED WRONG DML BEEING SKIPPED BY CONTROLS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1598] FIXED {HVR_TX_SEQ} IS NOT CHANGED WHEN A ROW IS UPDATED: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1945] FIXED: ORA-22296 INVALID ALTER TABLE OPTION FOR CONVERSION OF LONG DATATYPE TO LOB: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1670] HVR CAN NOT UPDATE GP TABLE AFTER SOME DDL ACTION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1867] HVR RESERVES 6 BYTES FOR CESU8 CHARACTERS, WHILE ORACLE USES 3 BYTES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1613] HVR TRY TO PERFORM DML ACTION ON DELETED TABLE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1693] HVRREFRESH ALWAYS RECREATES TABLES ON GREENPLUM DUE TO MISMATCH (NULLABILITY ADDED): To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1696] HVRREFRESH TRIES TO ALTER NULLABILITY OF A COLUMN, BUT SILENTLY FAILS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1523] HVR SCHEDULER -A ON LINUX KILLS OLD SCHEDULER BEFORE VALIDATING ITS ARGS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1649] INCORRECT ALTER TABLE STATEMENT SYNTAX FOR SQLSERVER: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-709] INTEGRATE TO SQL SERVER FAILS WITH F_JT00F9 BECAUSE ENCODING INFORMATION IS NOT REQUESTED UPON CONNECT: To fix this bug, upgrade HVR on all machine(s). [HVR-1605] INTERVAL ENTRIES ABSENT IN HVR MAINTENANCE DIALOG ON WINDOWS: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1752] LOCALIZING DATA TYPES BASED ON DATABASE HANDLE IGNORES ENCODING: To fix this bug, upgrade HVR on all machine(s). [HVR-1800] MISSING LOB VALUE IN THE HVRROUTERVIEW FILE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1020] ORACLE CAPTURE FAILED WITH F_JD20DB: ORA-22923: AMOUNT OF DATA SPECIFIED IN STREAMING LOB WRITE IS 0 DURING INTEG FOR NCLOB: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1834] ORACLE PASTER DOES NOT RECOGNIZE LOB HEADER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1229] POSTGRESQL (SUB-)TRANSACTION CHANGES NOT ALWAYS CAPTURED IN CORRECT ORDER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1969] PREVENT CAPTURING ROWID FOR IOT-TABLES ON ORACLE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1815] SQL SERVER RETURNS SYSTEM ENCODING INSTEAD OF DATABASE ENCODING ON CONNECT: To fix this bug, upgrade HVR on all machine(s). [HVR-1586] SYSERR NOW SHOWS CORRECT SYSTEM ERROR MESSAGES ON WINDOWS: To fix this bug, upgrade HVR on all machine(s). [HVR-1000] SUPPORT FOR ALTER TABLE PARTITON DDL ON ORACLE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1337] SUPPORT FOR ORACLE CLUSTERED KEY TABLES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1872] SYNTAX ERROR F_JG2142 IN SCAN FPROC DURING PARTITIONING TABLE SCANNING: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1688] SYNTAX ERROR DURING ALTER TABLE ON TERADATA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1710] SYNTAX ERROR DURING ALTER TABLE WITH DEFAULT VALUES IN PQ: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1678] SYNTAX ERROR DURING ALTER_MOD OPERATION FOR DB2: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1591] TABLE EXPLORE ON TERADATA SHOWS DIFFERENCES ON FLOAT COLUMNS WHILE THEY ARE EQUAL: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1922] TARGET LOCATION DOES NOT CONTAIN DATA FROM NEW INTERVAL PARTITION: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1185] TERADATA: LENGTH 0 IS NOT ALLOWED FOR A CHAR, VARCHAR, BYTE, VARBYTE COLUMN DURING REFRESH WITH TABLECREATION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1647] TERADATA INTERVAL DATATYPE IMPLIED PRECISION IS NOT HANDLED CORRECTLY: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-1566] TERADATA TABLE WITH NVARCHAR IS ALWAYS ALTERED DURING REFRESH: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-1691] UNEXPECTED E_DM00A6_ATBL_COL_INDEX_KEY FOR INGRES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1602] USE UNIQUE KEY OF DB2 FOR I PHYSICAL FILES AS REPLICATION KEY: To fix this bug, upgrade HVR on all machine(s). [HVR-1771] ALTER TABLE DROP COLUMN FAILS WITH F_JD0C07 ON SQL SERVER WHEN COLUMN HAS A DEFAULT VALUE: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-1612] BURST RECOVERY FAILS WITH F_JD20FF: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1592] HVRREFRESH ALWAYS RECREATES TARGET TABLES ON TERADATA DUE TO MISSING UNIQUE INDEX: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.0.1/2 (2016-05-18) ---------------------------------------- [HVR-1535] ADDED INTEGRATE /RESILIENT=SILENT_DELETES TO REPLACES /DBINTEGRATE /RESILIENTDELETES: To use this feature, upgrade HVR on the hub machine(s). [HVR-1505] INLINE LOBS SUPPORT FOR TERADATA BULK LOAD: To use this feature, upgrade HVR on the integrate machine(s). [HVR-838] KERBEROS KEYTAB SUPPORT FOR HDFS: To use this feature, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.0.1/2 (2016-05-18) ------------------------------------------ [HVR-1532] ADAPTDDL DOES NOT REMOVE TABLE FROM CATALOG IF /ONDROPTABLE IS SET: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1531] SQL SERVER F_JD0805 INDEX REBUILD ERROR ERRONEOUSLY GENERATED WHEN COLUMN CHANGED: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1552] FIXED F_JC007B WITH REMOTE UNIX LOCATIONS WITH ODBC-BASED DATABASES: To fix this bug, upgrade HVR on the remote machine(s). [HVR-1431] FIXED F_JD0F08: NO MEM. FOR CONVERTING 'HVR_TX_ID' FOR DB2 LUW: To fix this bug, upgrade HVR on the capture machine(s). [HVR-867] FIXED F_JD20F0: UNEXPECTED ODBC STATUS 'SQL_NO_DATA' DURING BURST INTEGRATE INTO DB2LUW: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1536] FIXED F_JD2103 WHILE SELECTING FROM INGRES 10.2 IIGET_TABLE_LOCATIONS: To fix this bug, upgrade HVR on all machine(s). [HVR-1521] FIXED F_JD2146 DURING ROW-WISE REFRESH WITH /COLUMNPROPERTIES /BASENAME: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1554] FIXED F_JD291D: TERADATA ERROR 6705 AN ILLEGALLY FORMED CHARACTER DURING REFRESH: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1510] FIXED F_JG358E REPLACING ACTUAL ERRORS: To fix this bug, upgrade HVR on the gui and hub machine(s). [HVR-1546] FIXED HVR4 ACTION USAGE IN HVRFAILOVER DEPENDENCY SCRIPTS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1514] FIXED S3 ERROR RETRY MIGHT TRIGGER 100% CPU USAGE AND HANGING DURING REDSHIFT REFRESH: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1520] FIXED SIGSEGV DURING DB2LUW LOG-BASED CAPTURE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1516] FIXED ERRORS FROM HVRVALIDPW DISAPPEARING: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1511] FIXED POSSIBLE ISSUES IN JOB PROCESS CLEANUP WHEN SCHEDULER IS FORCEFULLY TERMINATED: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1440] FORCED AUGMENT FOR ORACLE SECUREFILES - PREVENT GENERATION OF F_JT1101 FOR OLD HUBS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1011] ORACLE CAPTURE FAILED WITH F_JD2428: PARTIAL LOB OP FOR NCLOB CONTAINED 16 NOT 64 BYTES FOR LOBS: To fix this bug, upgrade HVR on the capture machine(s). NEW FEATURES IN HVR 5.0.1/1 (2016-05-04) ---------------------------------------- [HVR-1501] ADD SUPPORT FOR POSGRESQL VERSION 9.5: To use this feature, upgrade HVR on the capture machine(s). [HVR-413] ADDED -P OPTION TO HVRMAINT.PL FOR TASK HIGH PRIVILEGES: To use this feature, upgrade HVR on the gui and hub machine(s). [HVR-1493] ENDIANNESS CONVERSION PERFORMANCE IMPROVEMENTS: To use this feature, upgrade HVR on the capture and integrate machine(s). [HVR-1491] WIDE ROW CAPTURE PERFORMANCE IMPROVEMENTS: To use this feature, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 5.0.1/1 (2016-05-11) ------------------------------------------ [HVR-1513] FIXED POSTGRESQL LOG-BASED CAPTURE SLOW INITIAL START OF CAPTURE JOB: To fix this bug, upgrade HVR on the hub and capture machine(s). [HVR-1405] F_JZ1537. 'APPEND HINT' CONTAINS DATA FOR TOO MANY COLUMNS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1487] FIXED F_JT1482: PIPE BURSTPIPE ENCOUNTERED COLUMN HVR_CAP_LOC WITH ILLEGAL LEN FOR CESU8 DATABASES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1500] FIXED SQL SERVER CONSUMES CPU ON A QUIET SYSTEM WITH /NOTRIGGERFIRING OPTION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1319] FIXED CONFUSING ERROR MESSAGE AFTER F_JZ6208 FOR POSTGRESQL LOG-BASED CAPTURE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1495] FIXED INCORRECT PARAMETERS BEING DISPLAYED WHEN EDITING ACTIONS: To fix this bug, upgrade HVR on the gui and hub machine(s). [HVR-1490] HVR USER MANUAL STILL USES OLD FRONT PAGE IMAGE: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1482] ORACLE CAPTURE FAILED WITH F_JZ1952: PASTE ENCOUNTERS ENDING TYPE 0X0005 WITH LOB BUT DATA STORE IS NOT READY YET FOR UPDATE_AFTER: To fix this bug, upgrade HVR on the capture machine(s). NEW FEATURES IN HVR 5.0.1/0 (2016-04-19) GA ------------------------------------------- [HVR-1474] ADD SUPPORT FOR HVR INITIALIZE CAPTURE REWIND FOR POSTGRESQL: To use this feature, upgrade HVR on the hub and capture machine(s). [HVR-1334] FORCED AUGMENT FOR ORACLE SECUREFILES BASED LOB COLUMNS: To use this feature, upgrade HVR on the capture and hub machine(s). [HVR-1439] HVR 5 ACTION RENAMES: To use this feature, upgrade HVR on all machine(s). [HVR-1236] IMPLEMENT -TASK_GROUP PARAMETER FOR HVRMAINT TO SHARE STATE BETWEEN TASKS: To use this feature, upgrade HVR on the hub machine(s). [HVR-1445] IMPROVED SUPPORT FOR SQL SERVER GEOMETRY DATATYPE: To use this feature, upgrade HVR on the capture and integrate machine(s). [HVR-1449] PERFORMANCE IMPROVEMENTS ON FP_PROJECT: To use this feature, upgrade HVR on the integrate machine(s). [HVR-1467] TERADATA SUPPORTS BULK LOAD ON WINDOWS PLATFORMS: To use this feature, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 5.0.1/0 (2016-04-19) GA --------------------------------------------- [HVR-1455] EXPOSING REWIND OPTIONS IN HVRINIT DIALOG HAS BEEN BROKEN AFTER HVR 5 ACTION RENAMES: To fix this bug, upgrade HVR on the gui machine(s). [HVR-583] F_JD0700: DATA TYPE MISMATCH FOR _CLOB DATATYPE WHEN USE REDSHIFT AS TARGET LOCATION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1465] FIXED F_JG2142 WHEN COLUMNPROPERTIES /TIMEKEY WITHOUT NON-/EXTRA REPLICATION KEY: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1384] FIXED HVR HANG DURING INTEGRATION INTO TERADATA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1230] FIXED POSTGRESQL LOG-BASED CAPTURE: ROWS INSERTED USING "COPY" ARE NO LONGER IGNORED: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1477] FIXED CONCURRENT TERADATA BULK LOADS MAY HANG: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1458] FIXED MISSING CAPTURE OF NEW UPDATE RECORDS INTRODUCED IN INGRES 10.2 BY INGRES BUG FIX 130681: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1106] HVRGUI STATISTICS OUTPUT SOMETIMES SHOW WRONG LABELS (E.G. ERROR CODES INSTEAD OF JOBNAME): To fix this bug, upgrade HVR on the hub machine(s). [HVR-1303] MISSING COLUMN QUOTING IN FAIL TABLE INSERT WHEN INTEGRATE /BURST IS DEFINED: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1146] ORACLE CAPTURE FAILS WITH F_JG0E07: UNHANDLED ICU ERROR OCCURED (U_TRUNCATED_CHAR_FOUND): To fix this bug, upgrade HVR on the capture machine(s). [HVR-1399] CREATING FAIL TABLE ON REDSHIFT FAILS ON HVR_ERR_MSG COLUMN WITH F_JD22CA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1127] HVRSTART ON SQL SERVER: F_JR0148 COL LENGTH 0 WITH DTYPE 'ROWVERSION' IS OUT OF RANGE: To fix this bug, upgrade HVR on the hub and integrate machine(s). NEW FEATURES IN HVR 5.0.0/6 (2016-04-11) ---------------------------------------- [HVR-737] SET HVR_HUB_CHARSET DEFAULT TO UTF-8: To use this feature, upgrade HVR on the hub machine(s). PROBLEMS FIXED IN HVR 5.0.0/6 (2016-04-11) ------------------------------------------ [HVR-1437] F_JD0A6A DURING CAPTURE FROM SQL SERVER TRANSACTION LOG BACKUP FILE USING FD METHOD: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1438] F_JG2017 DURING CAPTURE FROM SQL SERVER TRANSACTION LOG BACKUP FILE USING FD METHOD: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1255] FIXED F_JD2259: NO COLUMNS IN SET-CLAUSE AFTER ONLINE REFRESH: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1430] FIXED F_JR0336 WITH DBOBJECTGENERATION WITH JUST /BURSTTABLECREATECLAUSE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1435] FIXED SETTING HVR_HUB_CHARSET TO UTF8 IS CAUSING HANG OF THE INTEGRATE JOB: To fix this bug, upgrade HVR on all machine(s). [HVR-1442] FIXED BATCH LOAD PERFORMANCE DROPS TO SINGLETON INSERT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1441] FIXED CAPTURE FROM SQL SERVER DOES NOT PROPERLY DETECT CHANGES MADE BY INTEGRATE IN BI-DIRECTIONAL CHANNEL: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1434] FIXED HVRSTATISTICS IRREGULAR OUTPUT IF COMPRESSION INFO IS MISSING BY REFRESH: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1094] FIXED INCORRECT LAYOUT IN THE 'SHOW GRAPH' BOX ON THE STATISTICS-GRAPH-ALL TAB: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1423] HVR TRIES TO CONVERT NULLABLE INGRESDATE TO NON-INGRESDATE DATA TYPE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1425] FIXED UNNECESSARY RECREATION OF BURST TABLE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1333] LOCALIZATION OF NUMBER(P) COLUMNS TO DECIMAL INCORRECTLY ADDS A SCALE: To fix this bug, upgrade HVR on all machine(s). [HVR-1444] ORACLE INTEGRATE /BURST USES BATCH LOAD INSTEAD BULK: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1419] ORACLE CAPTURE FAILED WITH F_JD2279: UNEXPECTED ERROR WHILE CONVERTING UTF-16 DATA FOR COLUMN (DATATYPE CLOB): To fix this bug, upgrade HVR on the capture machine(s). [HVR-1387] ORACLE CAPTURE FAILED WITH F_JG200C: INTERNAL ERROR TRIGGERED BUS ACCESS TRAP SIGBUS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1433] PADDING OF INSERT INTO FIXED LENGTH COLUMN IGNORES CHARACTER LENGTH ON ORACLE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1408] W_JT044C MISSING BEGIN TRANSACTIONS IN SAP SYSTEMS: To fix this bug, upgrade HVR on the capture machine(s). NEW FEATURES IN HVR 5.0.0/5 (2016-04-03) ---------------------------------------- [HVR-1101] ADDED SUPPORT FOR DBINTEGRATE /NOTRIGGERFIRING OPTION FOR MS SQLSERVER: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-1342] ADDED SUPPORT FOR FILECAPTURE COLUMNPROPERTIES /EXTRA, /ABSENT, /CAPTUREEXPRESSION: To use this feature, upgrade HVR on the capture machine(s). [HVR-1391] ADDED SUPPORT FOR POSTGRESQL LOG-BASED CAPTURE OF TOASTED VALUES: To use this feature, upgrade HVR on the capture machine(s). [HVR-1417] ALLOW ANY DATATYPE FOR /ADDRESSTO={COL}, NOT JUST INTEGER: To use this feature, upgrade HVR on the hub machine(s). [HVR-1300] HVR SWITCHES TO MULTILOAD IF FASTLOAD FAILS DURING TERADATA BULK LOAD: To use this feature, upgrade HVR on the integrate machine(s). [HVR-1197] IMPROVE E-MAIL LAYOUT OF HVRMAINT: To use this feature, upgrade HVR on the hub machine(s). [HVR-1326] IMPROVED DB2 FOR I LOGBASED CAPTURE PERFORMANCE BY FILTERING UNUSED RECORDS: To use this feature, upgrade HVR on the capture machine(s). [HVR-1424] IMPROVED LSN TO SCAN SEQUENCE NUMBER TRANSLATION RULES FOR SQL SERVER: To use this feature, upgrade HVR on the capture machine(s). [HVR-1372] PROFILE FPROC CAN RETURN MIN AND MAX VALUE OF HVR OR DBMS VERSIONS: To use this feature, upgrade HVR on the hub machine(s). [HVR-1338] RESTRUCTURE ADAPTDDL REFRESH OPTIONS, ADD CREATEUNICODEDATATYPES TABLEPROPERTY: To use this feature, upgrade HVR on the hub and gui machine(s). [HVR-1243] S3 INTERNAL SERVER ERRORS (STATUS CODE 500) ARE NOW RETRIED AS PER S3 RECOMMENDATIONS: To use this feature, upgrade HVR on the integrate machine(s). [HVR-1362] SHOW UNITS IN HVRSTATISTICS GRAPHS: To use this feature, upgrade HVR on the hub machine(s). PROBLEMS FIXED IN HVR 5.0.0/5 (2016-04-03) ------------------------------------------ [HVR-1253] ADAPTDDL DOES NOT WORK WITH DBINTEGRATE /BURST: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-1340] ADD COLUMN GIVES F_JD2119: UNSUPPORTED DATATYPE '' ENCOUNTERED: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1017] DB2 FOR I: [DELETE FROM TBL] LOGGED AS [ALTER TABLE] WITH NON-TRIVIAL TABLE SIZES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1368] DO NOT KEEP GUARD TRANSACTION OPEN WHEN READING FROM SQL SERVER TRANSACTION LOG BACKUP: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1341] F_JZ1803 FIXED COLUMN NUMBER IN ORACLE 12 APPEND HINT: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1239] FIXED "NO SUCH FILE OR DIRECTORY AT HVRALERT LINE 64" WITH POSTGRESQL HUB: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1380] FIXED $ZIZ_FILE_OFF(_LIVE) WITHOUT ZIZ_FILE_READ=READDIRECT: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1381] FIXED ACL FORCED FOR SOME S3 FILE UPLOADS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1383] FIXED DB2I CAPTURED DATA THAT IS MEANT FOR TWO INTEGRATION LOCATIONS ONLY REACHES ONE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1363] FIXED F_JC007C ERROR STARTING WINDOWS SERVICE 'HVRSCHEDULER_XXX' FOR POSTGRESQL HUB: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1171] FIXED F_JC04C3 WHEN USING GENERATED COMMAND LINE STRING FOR POSTGRESQL HUB: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1271] FIXED F_JD0205 UNEXPECTED NUMBER OF COLS ENCOUNTERED: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1222] FIXED F_JD211F: UNALLOCATED DA ENCOUNTERED FOR TABLE WHILE CONVERTING DATA FROM COPYISH TO DB NATIVE FORMAT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1332] FIXED F_JD2272: RELATION ALREADY EXISTS DURING GREENPLUM REFRESH FOR TABLE WITH MIXED CASES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1320] FIXED F_JD22A1: EXCEEDING MAXIMUM ROWHASHLOCKS INTO TERADATA: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-1323] FIXED F_JD22CA: NCLOB LOCALIZATION TO REDSHIFT VARCHAR HAS ZERO BYTE LENGTH: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1344] FIXED F_JD22CA: [CURRENT TRANSACTION IS ABORTED] ON REDSHIFT WITH AMAZON DRIVER: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-910] FIXED F_JD22E1: LOG RECORD HAS UNEXPECTED LENGTH ON DB2 FOR I: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1310] FIXED F_JD2918 SYNTAX ERROR DURING TERADATA BULKLOAD TO TABLE WITH "/" IN THE NAME: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1298] FIXED F_JD2918: CAN NOT BULK LOAD DATA IN TERADATA TABLE WITH SECONDARY INDEX: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1351] FIXED F_JG052E WITH SFTP PROTOCOL ERROR: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1291] FIXED F_JG200A DURING REFRESH OR INTEGRATE TO POSTGRESQL: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1339] FIXED F_JG221C: PIPE 'TRCOMMAND' RECEIVED TAG !TBL_NAME FOR SALESFORCE INTEGRATE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-880] FIXED F_JG2404 FROM SAPXFORM, RELAXED CHECKS F_JG2403 & F_JG2404: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-1402] FIXED F_JG2901 INVALID CHAR SEQUENCE DURING TABLESELECT OF TABLE WITH CHINESE CHARS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1124] FIXED F_JG358E DURING BURST INTEGRATE INTO POSTGRESQL: To fix this bug, upgrade HVR on the capture, hub and integrate machine(s). [HVR-1313] FIXED F_JT0527, ILLEGAL INSERT-INSERT WITH SAP CHANNEL: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1426] FIXED GUI MAY CRASH WHEN TERADATA TPT LIBRARY PATH IS LEFT EMPTY: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1406] FIXED HVR CREATES WRONG TBL-NAMES FOR TABLES WITH CHINESE NAME: To fix this bug, upgrade HVR on the gui and hub machine(s). [HVR-1207] FIXED HVR UNEXPECTED TRUNCATES FIXED-LENGTH CHARACTER STRINGS DURING REFRESH: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1315] FIXED ILLEGAL DIVISION BY ZERO IN HVRSTATISTICS.PL: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1318] FIXED INTEGRATE FAILS WITH F_JD2163 ON HVR_TX_SEQ COLUMN FOR POSTGRES TO ORACLE: To fix this bug, upgrade HVR on all machine(s). [HVR-1257] FIXED SAP CLUSTER TABLE DELETE DOESN NOT INCLUDE SCHEMA NAME: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1369] FIXED SIGSEGV WHEN FPROC RETURNS RESULT DIFFERENT THAN THE CONTEXT: To fix this bug, upgrade HVR on all machine(s). [HVR-1278] FIXED SOFTDELETE MIGHT CAUSE MEMORY CORRUPTION, SPURIOUS F_JG221D: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-1287] FIXED UNXML/SAPXFORM TRIGGERING PER ROW SPILLS RESULTING IN SLOW REFRESH: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1305] FIXED DISAPPEARING OF LATENCY INFO FOR RUNNING CAP JOBS IF TOO MANY FILES IN HVR_CONFIG/ROUTER: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1331] FIXED FAILED CAPTURE OF INITIALLY TRUNCATED POSTGRESQL TABLE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1312] FIXED GUARDIANS NOT TERMINATING CHILD PROCESSES: To fix this bug, upgrade HVR on the hub, capture and integrate machine(s). [HVR-1288] FIXED HVR_COLUMN'S INCORRECT LENGTH FOR DOUBLE BYTE CHARSETS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1306] FIXED HVRSAPXFORMGEN REQUIRING COMMENTS ABOUT CLUSTER/POOL TABLES IN INPUT TEXT FILES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1329] FIXED HVRSAPXFORMGEN TO GENERATE DBCAPTURE FOR ALL REQUIRED BASE TABLES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1358] FIXED LEFTOVER FILES IN S3 AFTER REDSHIFT INTEGRATE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1301] FIXED MISSING UPDATES WITH /BURST OR /COALESCE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1345] FIXED NOT WORKING JOB RETRY WHEN POSTGRESQL HUB: To fix this bug, upgrade HVR on all machine(s). [HVR-1294] HVR REFRESH FAILS WITH F_JD21B5: [ORA-00904: HVR_CAP_USER]: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1398] INGRES LBC FAILS WITH F_JZ2204. UNEXPECTED RECORD TYPE 179: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1138] ORACLE LBC FAILS WITH F_JT1456: LOG PARSING ERROR F_JZ1948. PASTE ENCOUNTERS LOB COLUMN AT TABLE BUT ITS LENGTH IS SMALLER THAN EXPECTED: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1355] ORACLE CAPTURE FAILED WITH F_JG2901: WIN-1252 STRING CONTAINING INVALID SEQUENCE ENCOUNTERED WHILE ENCODING TAB: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1284] POSTGRESQL LOG-BASED CAPTURE OF TIMESTAMP IGNORED SUBSECONDS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1200] SUPPORT FOR APPEND HINT INSERTS FOR COMPRESSED TABLES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1311] TABLE EXPLORE FAILS WITH F_JD20EC IF CHANNEL CONTAINS A TABLE WITH AN UNSUPPORTED DATATYPE: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1330] HVR_VAR_XXX VARIABLES IN /COMPARECONDITION ARE INVISIBLE: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1360] HVRROUTERVIEW -J CANNOT FIND JOURNAL FILES FROM DBINTEGRATE/JOURNAL: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1389] HVRVALIDPW DOES NOT WORK CORRECTLY ON SOLARIS: To fix this bug, upgrade HVR on the hub machine(s). NEW FEATURES IN HVR 5.0.0/4 (2016-02-29) ---------------------------------------- [HVR-981] POSTGRESQL LOG-BASED CAPTURE To use this feature, upgrade HVR on the hub and capture machine(s). [HVR-1238] INCREASE {HVR_CAP_USER} METACOLUMN LENGTH FROM 14 TO 24 CHARACTERS: To use this feature, upgrade HVR on the hub, capture and integrate machine(s). [HVR-1258] WORKAROUND FOR SYNCHRONY GATEWAY FTP SERVERS DROPPING UPLOADED FILES: To use this feature, upgrade HVR on the capture and integrate machine(s). [HVR-107] HVRSCHEDULER NOW USES OS ASSIGNED PORTS BY DEFAULT. FIXES F_JG210E (ADDRESS ALREADY IN USE): To use this feature, upgrade HVR on the hub and gui machine(s). PROBLEMS FIXED IN HVR 5.0.0/4 (2016-02-29) ------------------------------------------ [HVR-1223] COLUMN DATA IN MSSQL INDEX REBUILD DOES NOT MATCH ENROLL F_JT0A02, F_JD0A37: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1267] F_JD0A42 DURING CAPTURE FROM SQL SERVER IF HVR_TLOG_BACKUP_DIR POINTS TO THE ROOT FOLDER OF A NETWORK DRIVE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1180] FIX TABLE EXPLORE REPORTING FALSE DIFFERENCES DUE TO LACK OF LOCALIZATION: To fix this bug, upgrade HVR on all machine(s). [HVR-1231] FIX TABLEEXPLORE SHOWING NULLABLE COLUMNS AS NON-NULLABLE: To fix this bug, upgrade HVR on all machine(s). [HVR-1250] FIX HVRREFRESH NOT LOCALIZING DATATYPE OF /EXTRA COLUMN: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1249] FIXED F_JD2503 INVALID PATH FOR VASM CAPTURE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1209] FIXED F_JD2918: TPT ERROR (SYNTAX ERROR) BECAUSE OF UN-QUOTED COLUMN NAME: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1143] FIXED F_JT1449: 'HVR_REC_TSTAMP' WAS NOT MATCHED: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1269] FIXED F_JZ0908 GETFILESIZEEX() WHEN TRYING TO OPEN AN NON-EXISTING FILE ON WINDOWS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1115] FIXED HVR CONTROL SKIPPING FOR HVR_TX_SEQ: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1251] FIXED ZIZ_FILE_READ AND ZIZ_FILE_READ_LIVE WITH READDIRECT: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1256] FIXED FAILED JOBS GOING TO PENDING STATE ON BUSY WINDOWS HUBS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1263] FIXED FILE REPLICATION FOR SSH,FTP,WEBDAV WHEN NON-DEFAULT PORT IS USED: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-1112] FIXED HVRINIT FAILING WITH F_JT04DE ON SQL SERVER TABLE WITH COLUMN OF TYPE ROWVERSION: To fix this bug, upgrade HVR on the hub, capture and integrate machine(s). [HVR-1270] FIXED HVRSAPXFORMGEN: UNKNOWN INTERNAL DATA TYPE SYMBOL 'E' ENCOUNTERED: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1274] FIXED SUCCESSFUL JOBS GOING TO RETRYING STATE ON BUSY WINDOWS HUBS: To fix this bug, upgrade HVR on the hub machine(s). PROBLEMS FIXED IN HVR 5.0.0/3 (2016-02-19) ------------------------------------------ [HVR-1237] ADAPTDDL (AND HVRADAPT) MISHANDLES INDEX CHANGES: To fix this bug, upgrade HVR on the capture and hub machine(s). [HVR-1058] FIXED DBMS-SEQUENCES NOT BEING CAPTURED: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1233] SUPPORT FOR EC2 ROLE CREDENTIALS FOR S3 DURING REDSHIFT BULK LOAD: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 5.0.0/2 (2016-02-16) ---------------------------------------- [HVR-1219] ADD COMPARECONDITION TO RESTRICT ACTION: To use this feature, upgrade HVR on the hub machine(s). [HVR-643] ADD HVR_ENROLL_VLOGFILE_RESTRICT TO SPECIFY REDO DISKGROUP: To use this feature, upgrade HVR on the capture machine(s). [HVR-1134] ADD TERADATA DISTRIBUTION KEY SUPPORT: To use this feature, upgrade HVR on the integrate machine(s). [HVR-738] ADD DISTRIBUTION KEY, CHARACTER LENGTH AND ENCODING TO HVR CATALOG: To use this feature, upgrade HVR on the hub machine(s). [HVR-1069] ADD DURATION AND SPEED MEASUREMENTS TO HVRSTATISTICS: To use this feature, upgrade HVR on the hub machine(s). [HVR-967] ADD OPTION -DISABLE AND -CLEAR_PAST_ERRORS TO HVRMAINT: To use this feature, upgrade HVR on the hub machine(s). [HVR-1190] ADD SUPPORT FOR TERADATA BULK LOAD VIA TPT: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-1025] ADDED FILEINTEGRATE /ORDERBYTABLE TO IMPROVE {HVR_TBL_NAME} RENAME EXPRESSION FILE GENERATION: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-1079] ALLOW /REFRESHCONDITION, TABLEPROPS ETC.. FOR /SAPXFORM: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-1034] ALLOW COLUMNPROPERTIES /EXTRA ON INDIVIDUAL TABLE FOR SAPXFORM CHANNELS: To use this feature, upgrade HVR on the hub machine(s). [HVR-982] ALLOW DIFFERENT CAPTURE REWIND TIMES FOR SCAN START AND EMIT, AND ALLOW HVR SEQUENCE NUMBER OR ORACLE SCN FOR EMIT: To use this feature, upgrade HVR on all machine(s). [HVR-1062] ALLOW MULTIPLE DBSEQUENCE /SCHEMA ACTIONS: To use this feature, upgrade HVR on the hub machine(s). [HVR-550] AVOID USING ROW AUGMENT DURING SQL SERVER LBC WHEN POSSIBLE: To use this feature, upgrade HVR on the capture machine(s). [HVR-1049] CHANGE ISOLATION LEVEL FOR DB2I AND SQL SERVER TO READ COMMITTED: To use this feature, upgrade HVR on the capture and integrate machine(s). [HVR-1139] CLIENT-SIDE SSL CERTIFICATES FOR FTPS AND WEBDAV: To use this feature, upgrade HVR on the capture and integrate machine(s). [HVR-1217] CONSTANT SQL EXPRESSION MATCHING SHOULD IGNORE WHITESPACES FOR ROBUSTNESS: To use this feature, upgrade HVR on the integrate machine(s). [HVR-1218] CUSTOMIZE FTP CONTROL SOCKET TIMEOUT VALUES VIA ENV VAR: To use this feature, upgrade HVR on the capture and integrate machine(s). [HVR-1048] ELIMITATE THE NEED IN THE STATE TABLE ON CAPTURE SIDE FOR SQL SERVER: To use this feature, upgrade HVR on the capture machine(s). [HVR-1029] EXPOSE HVRMAINT OPTION -OUTPUT_VERBOSE: To use this feature, upgrade HVR on the hub machine(s). [HVR-738] EXTENDED TABLE COLUMN VIEW WITH BYTELENGTH, CHARACTER LENGTH AND ENCODING: To use this feature, upgrade HVR on the gui machine(s). [HVR-1074] FILE INTEGRATE XML SERIALIZATION WITH COMPACT XML: To use this feature, upgrade HVR on the hub and gui machine(s). [HVR-761] HVR STATISTICS SUPPORT FOR HVR WARNINGS: To use this feature, upgrade HVR on the hub machine(s). [HVR-721] HVR PURGES THE UNUSED FILES IN HVR_HOME AFTER UPGRADE: To use this feature, upgrade HVR on all machine(s). [HVR-1057] HVR_ISOLATION_LEVEL TO OVERRIDE DEFAULT ISOLATION LEVEL: To use this feature, upgrade HVR on all machine(s). [HVR-1123] HVRREFRESH: ADD (DISTRIBUTION) KEY SENSITIVITY, CHANGE OPTION -CA TO -CE: To use this feature, upgrade HVR on the integrate machine(s). [HVR-1195] IMPLEMENT CAPTURE OF ORIGINAL USER NAME FOR SQL SERVER LBC: To use this feature, upgrade HVR on the capture machine(s). [HVR-965] IMPLEMENTED FILE DIRECT ("FD") TRANSACTION LOG ACCESS METHOD FOR SQL SERVER: To use this feature, upgrade HVR on the capture machine(s). [HVR-1098] IMPROVED DB2 FOR I CAPTURE SPEED: To use this feature, upgrade HVR on the capture machine(s). [HVR-1009] IMPROVED ORACLE RAC CLUSTER REDIRECTS: To use this feature, upgrade HVR on the hub machine(s). [HVR-545] IMPROVEMENTS TO CBUFLOCALIZE, ADDED CBUF2SQL AND CBUFDIFF FUNCTIONALITY: To use this feature, upgrade HVR on all machine(s). [HVR-665] REFRESH TABLE RECREATE NOW SENSITIVE TO DATATYPE CHANGES: To use this feature, upgrade HVR on all machine(s). [HVR-1116] SAPXFORM REFRESH DOESN'T REQUIRE SORTING OF THE DATA FOR GREENPLUM AND REDSHIFT TARGETS: To use this feature, upgrade HVR on the hub machine(s). [HVR-943] STANDARDIZING WARNING MESSAGES TO NEW FORMAT THAT INCLUDES MSG-ID W_JX0000: To use this feature, upgrade HVR on all machine(s). [HVR-807] SUPPORT FOR INDEX REBUILD DDL IN SQL SERVER: To use this feature, upgrade HVR on the capture machine(s). [HVR-1040] VARIOUS SFTP COMPATIBILITY ENHANCEMENTS: To use this feature, upgrade HVR on the capture and integrate machine(s). PROBLEMS FIXED IN HVR 5.0.0/2 (2016-02-16) ------------------------------------------ [HVR-1022] /AGENT INVOCATION GIVES F_JG2142 PROTOTYPE ERROR: To fix this bug, upgrade HVR on the capture, hub and integrate machine(s). [HVR-1206] COLUMN DATA SPLIT CAUSES F_JD0804 INCOMPLETE REBUILD: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1169] DB2I SAP ROWAUGMENT EMITS CORRUPT CLUSTER (DIVIDE BY ZERO): To fix this bug, upgrade HVR on the capture machine(s). [HVR-1066] ELIMINATE UNNECESSARY AUGMENTING DURING CAPTURE FROM COMPRESSED TABLES ON SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-990] F_JG200A MMEMORY CHECK IN HVR-582 TESTING WITH HVR-5: To fix this bug, upgrade HVR on the capture machine(s). [HVR-996] F_JT028A DROP (TABLE) RECORD WARNING FROM SCANNER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1114] FIX F_JT148B: PIPE ROWAUGMENT ENCOUNTERED ILLEGALLY LONG VALUE FOR 'HVR_TX_SEQ': To fix this bug, upgrade HVR on the capture machine(s). [HVR-1214] FIX NUMERIC HANDLING IN POSTGRESQL: To fix this bug, upgrade HVR on all machine(s). [HVR-1019] FIXED BURST INTEGRATE INTO GREENPLUM ALWAYS RECREATE THE EXTERNAL TABLE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1161] FIXED DB2I F_JG2143 (SCANSTARTSEQ) WAS NOT MATCHED BY INVOCATION: To fix this bug, upgrade HVR on the hub and capture machine(s). [HVR-1129] FIXED DUPLICATE KEY VIOLATES UNIQUE CONSTRAINT FOR GREENPLUM BURST TABLES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1078] FIXED F_JD20F2 'CONNECTION BUSY' ON SQL SERVER VERBOSE COMPARE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1126] FIXED F_JD2146 DURING VERBOSE COMPARE WITH EXPRESSIONS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1156] FIXED F_JD21AD IN VERBOSE COMPARE WITH SOFTDELETE: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-1086] FIXED F_JD22AF PRIMARY KEY AND DISTRIBUTED BY DEFINITIONS INCOMPATIBLE FOR GREENPLUM: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1041] FIXED F_JD2313 REDSHIFT BULK LOAD FAILS WHEN THERE ARE OTHER TABLES PREFIXED WITH THE TBL NAME: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1162] FIXED F_JG200A IN INTEGRATE WITH SOFTDELETE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1046] FIXED F_JG21A6 ATTEMPT TO CALL UNKNOWN PROC. ADAPTENGINE: To fix this bug, upgrade HVR on all machine(s). [HVR-1159] FIXED F_JR0148 ZERO BYTELENGTH FOR N(VAR)CHAR DATATYPES ON SQL SERVER: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1154] FIXED F_JR0206 WHEN DBINTEGRATE/COALESCE IS DEFINED: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1084] FIXED F_JR0290 TIMESTAMP PRECISION 12 OUT OF RANGE WHEN ADDING TABLE TO CATALOG: To fix this bug, upgrade HVR on the hub and gui machine(s). [HVR-1083] FIXED F_JR0337: DBINTEGRATE /NOTRIGGERFIRING IS DEFINED: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1135] FIXED F_JR0349: ILLEGAL OPTIONS IN REFRESH ON AIX: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1130] FIXED F_JR1103: THE REWIND OPTIONS -I AND/OR -I HAVE BEEN USED INCORRECTLY OR NOT APPLICABLE TO THE CHOSEN LOCATION(S): To fix this bug, upgrade HVR on the hub machine(s). [HVR-1108] FIXED F_JT0527 WITH DB2 FOR I LOG-BASED CAPTURE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1155] FIXED F_JT1477 WITH /BURST AND /DUPLICATEROWS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-993] FIXED GREENPLUM SQLPREPARE HANGS AFTER DATABASE RESTART: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1016] FIXED GREENPLUM NUMERIC/DECIMAL ZERO PRECISION ERROR WHEN DATATYPEMATCH IS SET: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1004] FIXED HVR FAILS WITH F_JG290D DURING BULK LOAD OF BIG TABLES INTO REDSHIFT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1158] FIXED HVR NOT SETTING DEFAULT LENGTH FOR UNIQUEIDENTIFIER DATATYPE ON SQLSERVER: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1045] FIXED HVRLOAD -OC (CHANGE TABLE) OPTION DISABLED IN HVRGUI FOR /BURST: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1125] FIXED HVRADAPT NOT FULLY UPDATING CHANNEL INFO: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1026] FIXED JT152D WITH FILEINTEGRATE /BURST: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1179] FIXED REDSHIFT CAN'T PARSE INSTANCE PROFILE ROLE CREDENTIALS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1043] FIXED REDSHIFT STAGING FILES ARE NOT CLEANED UP WHEN STAGINGEXEC ERROR OCCURS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1059] FIXED TABLE EXPLORE DISPLAYS GREENPLUM EXTERNAL TABLES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1180] FIXED TABLE EXPLORE REPORTING FALSE DIFFERENCES DUE TO LACK OF LOCALIZATION: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1211] FIXED TERADATA BULK LOAD FOR BIGGER DECIMALS AND NUMBER: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1073] FIXED HVRMAINT REPORTING 0 INTEGRATE CHANGES IF THERE WERE CHANGES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1110] FIXED ILLEGAL INSERT-INSERT PAIR (F_JT0527) WITH BURST INTEGRATE ON HVR_STATS CHANNEL: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1103] FIXED INCORRECTLY IRREGULAR OUTPUT IN HVRSTATISTICS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-991] FIXED MISSING BEFORE UPDATES (HVR_OP=3 OR 4) FOR INTEGRATE WITH /TIMEKEY: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1068] FIXED MISSING LATENCY INFORMATION PER TABLE WITH BURST INTEGRATE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1091] FIXED MULTI-DELETE DURING COALESCE RESULTING IN DUPLICATES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1117] FIXED RENAMING OF TABLES DOES NOT WORK FOR SAPXFORM CHANNELS: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-1137] FIXED STRING-BASED INTEGRATED EXPRESSIONS BEING APPLIED TWICE DURING ROW-WISE REFRESH: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1176] GREENPLUM EXTERNAL TABLE FOR BURST IS RECREATED WHEN DTYPES ARE CHANGED: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-995] HVR LOADS INTO BURST TABLES IN REDSHIFT DISABLES AUTOMATIC COMPRESSION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1090] HVRREFRESH FAILS WITH F_JG200A IN SELECT ON HVR CATALOGS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-960] INGRES INTERVAL DAY TO SECOND COLUMNS ARE ALWAYS CREATED WITH DEFAULT PRECISION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1168] JD0A41 DURING CAPTURE OF NCHAR OR NVARCHAR DATA FROM COMPRESSED TABLE ON SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1089] OCCATIONAL F_JT0406 DURING SQL SERVER LOG-BASED CAPTURE WHEN READING FROM SEVERAL BACKUP FILES IN A ROW: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1027] ORACLE LBC F_JZ196A - NULL BITMAP LENGTH ERROR IN UPDATE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1174] ORACLE CAPTURE FAILED WITH F_JC0018: INTERNAL ERROR: UNREGISTERED EVENT: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1173] ORACLE CAPTURE FAILED WITH F_JZ1105: SHIFT VALUE EXTRACTED FROM SHIFTS ARRAY OF QUICK MULTIPLE INSERT/DELETE FOR COMPRESSED COLUMN IS INVALID: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1052] ORACLE CAPTURE FAILED WITH F_JZ1107: COLUMN HAS BEEN MAPPED TWICE INTO COLUMNS RECORDED IN ORACLE QUICK MULTIPLE INSERT/DELETE (11.11) REDO RECORD: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1044] ORACLE CAPTURE FAILED WITH F_JZ1917: PARTIAL CHAINED ROW SHARES THE SAME HRID WITH NEWLY ARRIVED CHANGE BUT THEIR ZOP TYPES ARE DIFFERENT: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1160] ORACLE CAPTURE FAILED WITH F_JZ193E: PARSER ENCOUNTERED UNKNOWN OP FLAG WHILE PARSING RECORD: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1142] ORACLE CAPTURE FAILED WITH F_JZ194F: PASTE ENCOUNTERS ZFRAG_11_17_LOB1 BUT ITS TABLE ID DIFFERS FROM EXISTING CHANGE TABLE ID: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1213] ORACLE CAPTURE FAILED WITH SEGMENTATION VIOLATION WHILE HANDLING URP RECORD: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1036] ORACLE CAPTURE INCORRECTLY CAPTURES NULL VALUE FOR CLOB COLUMN: To fix this bug, upgrade HVR on the capture machine(s). [HVR-999] ORACLE CAPTURE MISSING VALUE FOR UPDATE WHEN LAST COLUMN(S) IS NULLIFIED: To fix this bug, upgrade HVR on the capture machine(s). [HVR-710] ORACLE RAW DATATYPE COLUMNS ARE CREATED 2 BYTES TOO SMALL: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-1047] SQL SERVER CAPTURE MAY FAIL WITH F_JG200A OR F_JD0A1F IF COMPRESSED TABLE HAS LOB OR XML COLUMNS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-1170] SAPTRANSFORM CAN GIVE F_JG2142: ON TRANSFORMPIPES OPT -D: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1051] SLOW CATALOG INITIALIZE WHEN LOTS OF LOCATIONS AND CHANNELS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-1055] TABLE EXPLORE FOR DB2I COMPARES TABLE SCHEMAS WITH CASE-SENSITIVITY: To fix this bug, upgrade HVR on the gui machine(s). [HVR-1193] TABLE SELECT FILTER LIMITED TO UNDER 10 TABLE ENTRIES: To fix this bug, upgrade HVR on the gui machine(s). NEW FEATURES IN HVR 5.0.0/1 (2015-10-30) ---------------------------------------- [HVR-977] ADD HVR_ENROLL_VLOG_RESTRICT AS WORK-AROUND FOR F_JD2822 [HVR-976]: To use this feature, upgrade HVR on the capture machine(s). [HVR-263] DDL REPLICATION, USING ADAPTDDL ACTION: To use this feature, upgrade HVR on the capture and hub machine(s). NEW FEATURES IN HVR 5.0.0/1 (2015-10-30) ---------------------------------------- [HVR-977] ADD HVR_ENROLL_VLOG_RESTRICT AS WORK-AROUND FOR ORACLE F_JD2822 [HVR-976]: To use this feature, upgrade HVR on the capture machine(s). [HVR-263] DDL REPLICATION, USING ADAPTDDL ACTION: To use this feature, upgrade HVR on the capture and hub machine(s). PROBLEMS FIXED IN HVR 5.0.0/1 (2015-10-30) ------------------------------------------ [HVR-974] FIXED UNBOUNDED HEAP GROWTH ON SOLARIS: To fix this bug, upgrade HVR on all machine(s) PROBLEMS FIXED IN HVR 4.7.3/12 (2015-10-23) ------------------------------------------- [HVR-963] F_JZ1976. PARSER ENCOUNTERS EMPTY RECORD PIECE DURING RECORD CHAINING: To fix this bug, upgrade HVR on the capture machine(s). NEW FEATURES IN HVR 4.7.3/11 (2015-10-20) ----------------------------------------- [HVR-964] RE-IMPLEMENTATION OF SFTP DIRECTLY ON TOP OF LIBSSH2: To use this feature, upgrade HVR on the capture and integrate machine(s). PROBLEMS FIXED IN HVR 4.7.3/11 (2015-10-20) ------------------------------------------- [HVR-966] FIXED F_JT0472 DURING CAPTURE FROM HEAP TABLE ON SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-926] FIXED ORA-00972: IDENTIFIER IS TOO LONG DURING HVR COMPARE EVEN WHEN THE COLUMN IS RENAMED: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-961] ORACLE LOG-BASED CAPTURE FAILED WITH F_JZ1546: COLUMN DATA MAPPING ERROR IN CHANGE TYPE 11.11 REDO QMI WITHIN RECORD To fix this bug, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 4.7.3/10 (2015-10-15) ------------------------------------------- [HVR-929] ORACLE F_JZ1919 CHAINER INSERT AND ROW BOTH IN START STATE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-959] FIXED HVR DOESN'T DETECT FEW INVALID UNICODE CODEPOINTS: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 4.7.3/9 (2015-10-13) ---------------------------------------- [HVR-914] ADD OPTION -D TO HVRADAPT TO REMOVE TABLES FROM CHANNEL: To use this feature, upgrade HVR on the hub machine(s). PROBLEMS FIXED IN HVR 4.7.3/9 (2015-10-13) ------------------------------------------ [HVR-942] DB2 LBC MAY FAIL WITH F_JD0701 IF VALUE COMPRESSION IS ENABLED: To fix this bug, upgrade HVR on the capture machine(s). [HVR-945] FIXED DB2 (LUW) RECAPTURING OF TRUNCATE TABLE STATEMENTS: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-953] FIXED F_JG200A WITH SQLSERVER LOGBASED CAPTURE WITH PARTITIONED TABLES WITH COMPUTED COLUMNS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-944] FIXED F_JG2459 WITH TRANSFORM /SAPAUGMENT WITHOUT REMOTE LOCATION: To fix this bug, upgrade HVR on the hub machine(s). [HVR-931] FIXED HVR REFRESH FAILS WITH F_JT029F ERROR WHEN RESTARTING JOBS IN BI-DIRECTIONAL CHANNEL: To fix this bug, upgrade HVR on the hub machine(s). [HVR-958] FIXED S3 UPLOAD FAILS IF IT TAKE TOO LONG TIME: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-957] FIXED GUI-HUB COMPATABILITY ISSUE INTRODUCED WITH HVR-921: To fix this bug, upgrade HVR on the gui machine(s). [HVR-916] HVR CAPTURES 2 CHARACTERS WHEN THERE IS ONLY ONE CHARACTER FOR ORACLE (CHAINING): To fix this bug, upgrade HVR on the capture machine(s). [HVR-955] IMPROVED SCANNED TRANSACTION MESSAGE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-934] ORACLE LOG-BASED CAPTURE FAILED WITH F_JZ1547: READ OVERFLOW IN EXTRACTING COLUMN DATA IN CHANGE TYPE 11.11 REDO QMI: To fix this bug, upgrade HVR on the capture machine(s). NEW FEATURES IN HVR 4.7.3/8 (2015-10-01) ---------------------------------------- [HVR-912] ADDED $HVR_SF_TIMEOUT_SECS FOR SALEFORCE DATALOADER TUNING: To use this feature, upgrade HVR on the integrate machine(s). [HVR-915] ADDED /INTEGRATEEXPRESSION={HVR_INTEG_KEY} AS CHAR(16) FOR UNIQUE KEY GENERATION: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-917] ADDED FILECAPTURE /IGNORESIZECHANGES: To use this feature, upgrade HVR on the capture and hub machine(s). [HVR-923] ADDED HVR_IDENTITY_RESEED_ENABLE TO RESEED SQL SERVER IDENTITY COLUMNS: To use this feature, upgrade HVR on the integrate machine(s). [HVR-896] ORACLE REDO BACKWARD COMPATIBILE VERSION HANDLING: To use this feature, upgrade HVR on the capture machine(s). [HVR-921] SUPPORT ADVANCING OF SQL SERVER TRANSACTION LOG TRUNCATION POINT: To use this feature, upgrade HVR on the hub and capture machine(s). PROBLEMS FIXED IN HVR 4.7.3/8 (2015-10-01) ------------------------------------------ [HVR-918] CHANGED DEFAULT ISOLATION TO READ COMMITTED INSTEAD OF SERIALIZABLE FOR GREENPLUM, POSTGRES AND DB2: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-922] FIXED F_JD0A11 DURING CAPTURE FROM HEAP TABLE ON SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-924] FIXED JG352F WHEN THE REDSHIFT STAGINGDIRECTORYHVR IS A LOCAL DIRECTORY: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-920] FIXED SQL SERVER LBC UNCONDITIONALLY PRODUCING HUGE DIAGNOSTIC FILES ON ERROR: To fix this bug, upgrade HVR on the capture machine(s). [HVR-919] FIXED HANDLING OF PARTIAL ROLLBACKS IN SQL SERVER LBC: To fix this bug, upgrade HVR on the capture machine(s). [HVR-901] FIXED VARIOUS ERRORS WITH /EXTRA/INTEGRATEEXPRESSION ON POSTGRESQL: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 4.7.3/7 (2015-09-23) ---------------------------------------- [HVR-882] S3 SUPPORT AS STAGING LOCATION FOR REDSHIFT BULK LOAD: To use this feature, upgrade HVR on the hub and integrate machine(s). PROBLEMS FIXED IN HVR 4.7.3/7 (2015-09-23) ------------------------------------------ [HVR-892] DB2 LUW LOG-BASED CAPTURE FAILED WITH F_JD229B: LOG RECORD HAS OUT OF BOUND VARIABLE DATA WITH ENABLED VALUE COMPRESSION: To fix this bug, upgrade HVR on the capture machine(s). [HVR-533] ORACLE LOG-BASED CAPTURE FAILED WITH F_JD2421: THE ACTUAL COL DATA LENGTH IS NOT MATCHED WITH THE ENROLLED COLUMN LEN: To fix this bug, upgrade HVR on the capture machine(s). [HVR-911] GREENPLUM COMPARE FAILED WITH F_JG200A: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-876] ORACLE LOG-BASED CAPTURE FAILED WITH F_JZ150F STRUCTURE OF KDLI SUPLOG HAS UNEXPECTED SIZE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-823] ORACLE LOG-BASED CAPTURE FAILED F_JZ1952 PASTE ENCOUNTERS ENDING TYPE 0X0040 BUT DATA STORE IS NOT READY YET: To fix this bug, upgrade HVR on the capture machine(s). [HVR-889] FIXED F_JT0426: UNEXPECTED END-OF-FILE CAP_STATE AFTER DISK FULL To fix this bug, upgrade HVR on the hub machine(s). [HVR-824] FIXED TRANSFORM /SOFTDELETE FOR POSTGRES: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-886] FIXED COPY MENU FOR CHANNEL/LOCATION/TABLE IN TABLE VIEW: To fix this bug, upgrade HVR on the gui machine(s). [HVR-899] FIXED DEFAULT VALUES WITH /INTEGRATEEXPRESSIONS ON THE CAPTURE SIDE AND /CAPTUREEXPRESSIONS ON THE INTEGRATE SIDE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-887] HVR STATISTICS REFRESH/COMPARE SUPPORT FOR CUSTOM TASK NAME: To fix this bug, upgrade HVR on the hub machine(s). [HVR-906] ORACLE LOG-BASED CAPTURE FAILED WITH F_JZ1906: PARSER DETECTED ILLEGAL TABLE ID (0): To fix this bug, upgrade HVR on the capture machine(s). NEW FEATURES IN HVR 4.7.3/6 (2015-09-11) ---------------------------------------- [HVR-848] SUPPORT XTREMEDATA USING LIBPQ (ADAPT FOR TEXT FORMAT): To use this feature, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 4.7.3/6 (2015-09-11) ------------------------------------------ [HVR-866] F_JD20DB: DBMS ERROR [ORA-00972: IDENTIFIER IS TOO LONG] WITH ORACLE 12: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-860] FIXED "CANNOT PARALLELIZE AN UPDATE STATEMENT THAT UPDATES THE DISTRIBUTION COLUMNS" DURING HVRLOAD FOR GP: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-858] FIXED DB2 FOR I ONLY RETURNS FIRST ROW WHEN SELECTING DATA: To fix this bug, upgrade HVR on all machine(s). [HVR-859] FIXED DESCRIBE OF REDSHIFT TABLE IS FETCHING THE TABLE ROWS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-861] FIXED E_AD2004_BAD_DTID ADF ROUTINE WAS PASSED AN INVALID DATATYPE ID DURING INTEGRATE PHASE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-808] FIXED F_JD2259 DURING DATE COLUMN INTEGRATION INTO ORACLE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-813] FIXED F_JD22C2: UNEXPECTED DATATYPE '-10' ENCOUNTERED WITH DB2 (LUW) LONG VARGRAPHIC DATATYPE: To fix this bug, upgrade HVR on all machine(s). [HVR-812] FIXED F_JD22C2: UNEXPECTED DATATYPE '-8' ENCOUNTERED WITH DB2 (LUW) GRAPHIC DATATYPE: To fix this bug, upgrade HVR on all machine(s). [HVR-855] FIXED CRASH DURING COMMAND LINE COMPARE/REFRESH WITH ENCRYPTED PASSWORD AND POSTGRESQL HUB: To fix this bug, upgrade HVR on the hub machine(s). [HVR-865] FIXED UNEXPECTED DIFFERENCE IN BOOLEAN COLUMN FOR GP: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 4.7.3/5 (2015-08-26) ---------------------------------------- [HVR-799] ADD HVR_HUB_CHARSET TO ENVIRONMENT OF HVRSCHEDULER SERVICE: To use this feature, upgrade HVR on the gui and hub machine(s). [HVR-833] ADD SUPPORT FOR ORACLE 12C ON AIX 6.1: To use this feature, upgrade HVR on the capture machine(s). [HVR-805] DB2 FOR LUW: ADD SUPPORT FOR GBK AND ISO8859-5: To use this feature, upgrade HVR on all machine(s). [HVR-803] DB2 FOR LUW: ADDED SUPPORT FOR CHARACTER SET CONVERSIONS: To use this feature, upgrade HVR on all machine(s). [HVR-837] POSTGRESQL: USE LIBPQ INSTEAD OF ODBC CONNECTION: To use this feature, upgrade HVR on all machine(s). [HVR-821] SALESFORCE DATALOADER VERSION 32 SUPPORT: To use this feature, upgrade HVR on the capture and integrate machine(s). [HVR-848] SUPPORT XTREMEDATA USING LIBPQ (ADAPT FOR ROW FETCHING): To use this feature, upgrade HVR on the integrate machine(s). [HVR-333] SUPPORT FOR DB2 ON WINDOWS: To use this feature, upgrade HVR on the hub, capture and integrate machine(s). [HVR-729] UNICODE SUPPORT FOR DB2 LUW METADATA: To use this feature, upgrade HVR on the capture and integrate machine(s). PROBLEMS FIXED IN HVR 4.7.3/5 (2015-08-26) ------------------------------------------ [HVR-846] DB2 (LUW): FIXED LOG-BASED RECAPTURE BOOMERANG: To fix this bug, upgrade HVR on the capture machine(s). [HVR-798] F_JD212D ERRORS WITH DB2 LUW LOG-BASED CAPTURE AND DECIMAL DATA TYPE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-576] F_JZ1201, F_JZ150F, F_JZ150C PARSING OF MULTI-ROW (QMI/D) CHANGES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-765] F_JZ150C PACKED ROWS IN QUICK MULTIROW CHANGES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-793] F_JZ3207. LOG-BASED CAPTURE ENCOUNTERS DB2 OUTER RECORD TYPE 0X10 WHILE PROCESSING TABLE WITH ONE COLUMN: To fix this bug, upgrade HVR on the capture machine(s). [HVR-800] FIX CRASH DURING HVRSCHEDULER STARTUP WITH WRONG ENV-VARS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-835] FIXED 'FIELD MAPPING IS INVALID' ERROR WITH SALESFORCEINTEGRATE WITH HVR_TX_COUNTDOWN: To fix this bug, upgrade HVR on the hub machine(s). [HVR-796] FIXED DBMS ERROR DURING INTEGRATION WITH /BURST (FOR TABLES WHICH COLUMN(S) REQUIRE QUOTING): To fix this bug, upgrade HVR on the integrate machine(s). [HVR-778] FIXED F_JD2119 DURING TERADATA TABLE CREATION WITH VARBYTE COLUMN: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-840] FIXED F_JD21B9 DURING SQL SERVER LOG-BASED CAPTURE IN DBOWNER PERMISSION MODEL: To fix this bug, upgrade HVR on the capture machine(s). [HVR-817] FIXED F_JD2238 WHEN TBL NAME AND BASE NAME DIFFER ONLY IN CASE: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-841] FIXED F_JJ10C6 WHILE RUNNING HVRSCHEDULER WITH DB2 (LUW) HUB: To fix this bug, upgrade HVR on the hub machine(s). [HVR-529] FIXED F_JT0451 WHEN RAC THREAD INCORRECLY MARKED AS DEAD: To fix this bug, upgrade HVR on the capture machine(s). [HVR-845] FIXED F_JZ3202 ENCOUNTERED DURING DB2 (LUW) LOG-BASED CAPTURE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-811] FIXED SIGSEGV DURING HVR DROP OBJECT FOR ORACLE SOURCE WITH CAPTURE SEQUENCES DEFINED: To fix this bug, upgrade HVR on the hub machine(s). [HVR-815] FIXED TRIG_CRONO STOPS FOR AN HOUR IF THE JOB FINISHES IN LESS THAN A SECOND: To fix this bug, upgrade HVR on the hub machine(s). [HVR-842] FIXED BCOMPAT ERROR F_JG2142 WITH DBMSATTR DURING INTEGRATION: To fix this bug, upgrade HVR on the hub machine(s). [HVR-850] FIXED CAPTURE JOB PREVENTING T-LOG TRUNCATION ON SQL SERVER 2005: To fix this bug, upgrade HVR on the capture machine(s). [HVR-831] SUPPLEMENTAL LOGGING NOT FOUND IN CFA CHANGE: To fix this bug, upgrade HVR on the capture machine(s). NEW FEATURES IN HVR 4.7.3/3 (2015-07-30) ---------------------------------------- [HVR-794] ADD SUPPORT FOR DB2 10.5 FOR LINUX 64 BIT: To use this feature, upgrade HVR on all machine(s). PROBLEMS FIXED IN HVR 4.7.3/3 (2015-07-30) ------------------------------------------ [HVR-748] FIXED F_JD2421 DATA VALUE IN LOG RECORD COLUMN FOR ORACLE IS NOT CORRECT: To fix this bug, upgrade HVR on the capture machine(s). [HVR-789] FIXED F_JZ1919 ORACLE CHAIN ROW DELETE ENCOUNTERED ZOP DELETE BUT THEY ARE BOTH IN STATE 'START': To fix this bug, upgrade HVR on the capture machine(s). [HVR-786] FIXED F_JD2103 & E_US10D7_4311 DURING VECTOR BURST RECOVERY: To fix this bug, upgrade HVR on the hub machine(s). [HVR-784] FIXED F_JG222D WHICH OCCURED WITH A DB2 FOR I CAPTURE REWIND TIMESTAMP IN THE FUTURE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-773] FIXED OCI REDO TRIGGERS ORA-01031 ON ORACLE 12 DURING CAPTURE FROM REMOTE LOCATION VIA HVR PROTOCOL: To fix this bug, upgrade HVR on the capture machine(s). [HVR-774] FIXED HANGING HVR PROCESS WHILE ALLOCATING MEMORY FROM POOL: To fix this bug, upgrade HVR on all machine(s). [HVR-715] FIXED WRONG LOCATION DIALOG HELP LINK FOR SOME DATABASES: To fix this bug, upgrade HVR on the gui machine(s). [HVR-633] LOGBASED CAPTURE DOES NOT GRAB DATA FROM DB2: To fix this bug, upgrade HVR on the capture machine(s). [HVR-785] SUPPORT FOR DB2 COMPRESSION SHOULD BE ENABLED BY DEFAULT: To fix this bug, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 4.7.3/2 (2015-07-23) ------------------------------------------ [HVR-769] FIXED F_JD2311/ORA-01031 DURING CAPTURE FROM ORACLE USING OCI REDO SUBSYSTEM: To fix this bug, upgrade HVR on the capture machine(s). [HVR-768] FIXED CATALOG CREATION FOR OLD VERSIONS OF DB2 LUW: To fix this bug, upgrade HVR on the hub machine(s). [HVR-649] FIXED JOB FAIL WITH NO ERROR DOES NOT PUT HVR INTO RETRY MODE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-734] FIXED SUPPORT OF LONG COLUMN AND TABLE NAMES AND ROW-BY-ROW COMPARE ERROR FOR TERADATA: To fix this bug, upgrade HVR on the hub and integrate machine(s). NEW FEATURES IN HVR 4.7.3/1 (2015-07-17) ---------------------------------------- [HVR-752] ADDED HVR COMPARE & REFRESH MEASUREMENTS TO HVR STATISTICS: To use this feature, upgrade HVR on the hub, capture and integrate machine(s). [HVR-744] ADDED SUPPORT FOR SQL SERVER 2005 LOG-BASED CAPTURE: To use this feature, upgrade HVR on the capture machine(s). [HVR-751] DB2 FOR I - LOG BASED CAPTURE - ADD CHECK FOR SEQUENCE NUMBER RESET: To use this feature, upgrade HVR on the capture machine(s). [HVR-759] SUPPORT FOR: /TIMEKEY, /INTEGRATEEXPRESSION={HVR_OP}, /RENAMEEXPRESION/CONTEXT: To use this feature, upgrade HVR on the hub and integrate machine(s). PROBLEMS FIXED IN HVR 4.7.3/1 (2015-07-17) ------------------------------------------ [HVR-607] F_JZ151D A RECORD IN LOGFILE OVERFLOWED THE ALLOCATED SIZE OF ITS STRAND BUFFER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-747] FIXED F_JG200A IN ORACLE LOG-BASED CAPTURE JOB: To fix this bug, upgrade HVR on the capture machine(s). [HVR-535] FIXED CAPTURE REWIND IS DISABLED IN GUI FOR SQL SERVER: To fix this bug, upgrade HVR on the gui machine(s). [HVR-418] FIXED CAPTURE REWIND NOT FUNCTIONAL ON SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-756] FIXED TABLE DESCRIBE PERFORMANCE PROBLEM ON ORACLE: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-739] FIXED VERY VERY SLOW CAP JOB AFTER TX WITH MANY ROLLBACKS: To fix this bug, upgrade HVR on the capture machine(s). NEW FEATURES IN HVR 4.7.3/0 (2015-07-10) ---------------------------------------- [HVR-744] ADDED SUPPORT FOR SQL SERVER 2005 LOG-BASED CAPTURE: To use this feature, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 4.7.3/0 (2015-07-10) ------------------------------------------ [HVR-576] F_JZ1201 SUPP LOGGING INFO IS MISSING FOR CHANGE TYPE 5.1: To fix this bug, upgrade HVR on the capture machine(s). [HVR-730] FIXED F_JG20ED HVRSTRIP REMOVES FILES NECESSARY FOR LISTENER SERVICE CREATION: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-705] FIXED POSTGRES 8.1.2 DOES NOT SUPPORT BURST DELETE SQL STATEMENT: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-741] INTERGRATION FAILS DUE TO CHAINED KEYS IN CAPTURE: To fix this bug, upgrade HVR on the capture machine(s). NEW FEATURES IN HVR 4.7.2/11 (2015-07-09) ----------------------------------------- [HVR-723] DROP SUPPORT FOR POSTGRESQL ODBC DRIVER VERSION 8: To use this feature, upgrade HVR on the integrate machine(s). [HVR-721] HVR PURGES THE UNUSED FILES IN HVR_HOME AFTER UPGRADE: To use this feature, upgrade HVR on all machine(s). [HVR-663] UNICODE SUPPORT FOR MS SQL SERVER METADATA: To use this feature, upgrade HVR on the capture and integrate machine(s). PROBLEMS FIXED IN HVR 4.7.2/11 (2015-07-09) ------------------------------------------- [HVR-733] F_JG3505 WHILE F_JG3525 DURING HVRTESTLOCATION: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-735] F_JG352C WHILE AUTHENTICATING WITH OFFICE 365: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-728] F_JZ1512 UNEXPECTED UNDERFLOW SEQUENCE ON ORACLE 9: To fix this bug, upgrade HVR on the capture machine(s). [HVR-697] F_JZ1919 CHANGE ROW START STATE CONFLICT: To fix this bug, upgrade HVR on the capture machine(s). [HVR-742] FIXED F_JD2234 DURING INTEGRATE IN THE SAP TRANSFORMATION CHANNEL: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-725] FIXED F_JZ153F FOR ORACLE LBC OF FILES >= 4GB ON ORACLE >= 11.2.0.4: To fix this bug, upgrade HVR on the capture machine(s). [HVR-717] HVR_SQL_TRACE PRODUCES LOTS OF CHR(0) ON ORACLE RAW, VARCHAR AND NVARCHAR COLUMNS: To fix this bug, upgrade HVR on all machine(s). [HVR-727] POSTGRESQL 8: FIXED SUPPORT FOR DUPLICATE ROWS (F_JD22D4): To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 4.7.2/10 (2015-07-01) ----------------------------------------- [HVR-661] ADD HVR_MSG_TRACE FOR TRACING MESSAGES: To use this feature, upgrade HVR on all machine(s). [HVR-699] ADD SUPPORT DATATYPE 'UNKNOWN': To use this feature, upgrade HVR on all machine(s). [HVR-706] ADDED ENVIRONMENT VARIABLE TO FINE-TUNE MSSQL LSN TO HVR SEQUENCE NUMBER CALCULATION: To use this feature, upgrade HVR on the capture machine(s). [HVR-712] DB2 LUW: USE ADAPTED LOCKING FOR SOME STATE TABLES AND READING DATA FOR REFRESH/COMPARE: To use this feature, upgrade HVR on the integrate machine(s). [HVR-703] DB2 FOR I: USE LESS DEMANDING LOCKING WHEN READING DATA FOR REFRESH/COMPARE: To use this feature, upgrade HVR on the capture machine(s). [HVR-704] DB2 FOR I: USE MORE DEMANDING LOCKING FOR SOME STATE TABLES: To use this feature, upgrade HVR on all machine(s). [HVR-686] DB2 FOR I: LOG-BASED CAPTURE: ADDED CHECKS FOR MINENTDTA: To use this feature, upgrade HVR on the capture machine(s). [HVR-679] DETECT KERBEROS CREDENTIAL CACHE FOR UPDATES FOR HDFS: To use this feature, upgrade HVR on the capture and integrate machine(s). [HVR-327] GENERATE DISTRIBUTION KEYS BASED ON FKS AND ORACLE STATS: To use this feature, upgrade HVR on the hub, capture and integrate machine(s). [HVR-702] POSTGRESQL: USE MORE DEMANDING LOCKING FOR SOME STATE TABLES: To use this feature, upgrade HVR on all machine(s). [HVR-700] SUPPORT GREENPLUM DATADIRECT ODBC DRIVER 7.1.5: To use this feature, upgrade HVR on the integrate machine(s). [HVR-657] SUPPORT POSTGRESQL HUB: To use this feature, upgrade HVR on all machine(s). [HVR-634] UNICODE SUPPORT FOR ORACLE METADATA: To use this feature, upgrade HVR on the capture and integrate machine(s). [HVR-690] USE LESS DEMANDING LOCKING WHEN READING DATA FOR REFRESH/COMPARE (PARACCEL, REDSHIFT, TERADATA): To use this feature, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 4.7.2/10 (2015-07-01) ------------------------------------------- [HVR-718] DB2 FOR I - HANDLE LIMITED NUMBER OF SELECTED CAPTURED CHANGES TO PREVENT SQL0429: To fix this bug, upgrade HVR on the capture machine(s). [HVR-655] DB2 FOR I: UNIQUE INDEXES IGNORED WHEN DETERMINING REPLICATION KEY: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-660] DBSEQUENCE INTEGRATION FAILED TO INTEGRATE CHANGED SEQUENCES: To fix this bug, upgrade HVR on the hub and integrate machine(s). [HVR-669] F_JD22AF DURING HVRLOAD WITH GREENPLUM DB AS A TARGET: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-611] F_JD2424: MISSING VALUE FOUND ON ORACLE LOG-BASED CAPTURE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-670] F_JZ1201 SUPP LOGGING INFO IS MISSING: ALL NEW COLS ARE NULL: To fix this bug, upgrade HVR on the capture machine(s). [HVR-688] F_JZ1201 SUPP LOGGING INFO IS MISSING: DIFFERENCE IN OBJ IDS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-651] F_JZ150F SUPPLEMENTAL DATA STRUCTURE HAS UNEXPECTED SIZE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-681] F_JZ1911 DUPLICATE COLUMN IN CHAINED ROW NOT EQUAL: To fix this bug, upgrade HVR on the capture machine(s). [HVR-687] FIXED F_JG20D3 DURING STAT OF SFTP KEY FILES: To fix this bug, upgrade HVR on all machine(s). [HVR-698] FIXED F_JG358E WHILE REFRESHING POSTGRESQL TABLE WITH UNDECLARED EXTRA COLUMNS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-659] FIXED GREENPLUM STAGING BULK LOAD DOES NOT WORK FOR CLOB COLUMNS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-685] FIXED GREENPLUM STAGING BULK LOAD FAILS IF TARGET BASE TABLE HAS EXTRA COLUMNS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-683] FIXED INTEGRATE OF BOOLEAN COLUMNS TO REDSHIFT DOES NOT WORK: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-684] FIXED REDSHIFT HAS INVALID DEFAULT PRECISION FOR TIMESTAMP COLUMNS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-720] FIXED ROWAUGMENT PIPE SKIPPING UPDATES PRECEDED BY INSERTS IN THE SAME TRANSACTION: To fix this bug, upgrade HVR on the hub machine(s). [HVR-693] FIXED SIGSEGV IN CLOB SELECT FOR TERADATA IF THE LENGTH IS MORE THAN 32K: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-678] FIXED STAGING BULK LOAD DOES NOT WORK WITH REORDERED COLUMN IN THE BASE TABLE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-589] FIXED UNEXPECTED NEEDED STAGINGDIRECTORYHVR PARAMETER FOR DB2: To fix this bug, upgrade HVR on the hub machine(s). [HVR-434] FIXED DIFFERENCE WHEN COMPARE GP CHAR COLUMNS WITH LEN MORE THAN 16KB: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-701] FIXED DIFFERENCE WHEN COMPARE POSTGRESQL CHAR COLUMNS WITH LEN MORE THAN 16KB: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-666] FIXED HVRCATALOGCREATE SQL SCRIPT COLUMN SIZES: To fix this bug, upgrade HVR on the hub machine(s). [HVR-696] FIXED MISSING CHANGES DURING LOG-BASED CAPTURE OF DELETES OF MANY ROWS FROM SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-631] ORACLE CLOBS ENCODED AS UTF16 ARE NOT INTEGRATED PROPERLY: To fix this bug, upgrade HVR on the capture machine(s). [HVR-716] POSTGRES, GREENPLUM AND DB2 SELECT CHAR AND VARCHAR COLS WITH MISSING LAST CHARACTER: To fix this bug, upgrade HVR on the integrate machine(s). NEW FEATURES IN HVR 4.7.2/8 (2015-06-04) ---------------------------------------- [HVR-614] AUTOMATICALLY IMPLY ZERO PREFIX BYTES IN SAP XFORM ACTION WHEN SOURCE DB IS DB2 ON I: To use this feature, upgrade HVR on the hub machine(s). [HVR-572] DB2 (LUW): ADDED SUPPORT FOR DATATYPES LONG VARCHAR AND LONG VARGRAPHIC: To use this feature, upgrade HVR on the capture and integrate machine(s). [HVR-625] DB2 FOR I: SUPPORT FOR ENCODINGS EBCDIC 273 AND EBCDIC 1141: To use this feature, upgrade HVR on the capture machine(s). [HVR-624] DB2 FOR I: SUPPORT HVR_DB_CHARSET OVERRULING COLUMN LEVEL LOG-BASED CAPTURE ENCODING: To use this feature, upgrade HVR on the capture and integrate machine(s). [HVR-630] FASTER BURST BY BUNDLING UNCHANGED INTO SINGLE CHANGE: To use this feature, upgrade HVR on the integrate and hub machine(s). [HVR-618] REDSHIFT SUPPORTS STAGING BULK LOAD: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-647] HVR SUPPORTS INSTANCE PROFILE TEMPORARY CREDENTIALS FOR REDSHIFT BULK LOAD: To use this feature, upgrade HVR on the integrate machine(s). PROBLEMS FIXED IN HVR 4.7.2/8 (2015-06-04) ------------------------------------------ [HVR-648] DB2 FOR I: LOG-BASED CAPTURE: F_JD22DB: LOG RECORD HAS UNEXPECTED NULL INDICATOR LENGTH: To fix this bug, upgrade HVR on the capture machine(s). [HVR-551] F_JD1911 CHAIN ENCOUNTERED DUPLICATED COLUMN WITH DIFFERENT VALUES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-604] F_JD2208 UPDATE UNEXPECTEDLY AFFECTS ZERO ROWS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-560] F_JD241E LOG RECORD IMPLIES A NULL COLUMN: To fix this bug, upgrade HVR on the capture machine(s). [HVR-575] F_JZ1201 SUPPLEMENTAL LOGGING INFO IS MISSING FOR CHANGE TYPE 5.1: To fix this bug, upgrade HVR on the capture machine(s). [HVR-621] FIX INCORRECT VERBOSE SQL WHEN COMPARE TABLES WITH UNICODE IN TABLE OR COLUMNS NAMES: To fix this bug, upgrade HVR on the gui machine(s). [HVR-638] FIXED REDSHIFT BULK LOAD DOES NOT REPORT SSH ERRORS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-372] FIXED SERIALIZABLE ISOLATION VIOLATION IN HVR_STRS TABLE DURING PARALLEL ROWWISE REFRESH: To fix this bug, upgrade HVR on the hub machine(s). [HVR-622] FIXED INCORRECT DEFAULT OUTPUT ENCODING IN ROWS2CSV TRANSFORM ACTION: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-620] FIXED VERBOSE ROW-WISE COMPARE AND REFRESH WHERE THE TARGET LOCATION IS GREENPLUM WITH NUMBER COLUMNS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-635] PIPE TXGROUP DETECTED INCOMPLETE LOB COLUMN: To fix this bug, upgrade HVR on the capture machine(s). [HVR-612] HVRMAINT -SCAN_HVR_OUT AGAINST ORACLE HUB DOES NOT WORK BECAUSE OF BAD EXPANSION OF -HUB PARAMETER: To fix this bug, upgrade HVR on the hub machine(s). NEW FEATURES IN HVR 4.7.2/7 (2015-05-19) ---------------------------------------- [HVR-598] GREENPLUM STAGING FILES ARE DELETED AFTER DATA LOAD: To use this feature, upgrade HVR on the integrate machine(s). [HVR-605] ORACLE LBC SPEED IMPROVEMENTS FOR LOADED ORACLE 11.1 AND >= 11.2.0.4: To use this feature, upgrade HVR on the capture machine(s). [HVR-609] REMOVE TRAILING SPACES FROM CHAR, NCHAR AND BYTE IN CSV AND XML: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-599] SHOW EXTENDED ERROR MESSAGE WHEN SQL SERVER LOGREADER SUBSYSTEM FAILURE OCCURS: To use this feature, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 4.7.2/7 (2015-05-19) ------------------------------------------ [HVR-590] CORRUPTION OF ROWS UPDATES CONTAINING LONG COLUMNS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-537] F_JZ1906 PARSER DETECTED ILLEGAL TABLE ID (0): To fix this bug, upgrade HVR on the capture machine(s). [HVR-606] FIXED DBSENSE OF GREENPLUM TABLE REPORTS TBL EXISTS EVEN IF IT'S IN DIFFERENT SCHEMA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-588] FIXED F_JD0A0E DURING CAPTURE FROM COMPRESSED NONCLUSTERED TABLE ON SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-597] FIXED F_JG202F WITH PROGRESS DATADIRECT ODBC DRIVER FOR GREENPLUM/TERADATA: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-603] FIXED GP COMMIT FAILS AFTER UNSUCCESSFUL TABLE DROP: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-610] FIXED CORRUPT BYTE AT END OF STRINGS SELECTED FORM DB2 ON I TABLE CONTAINING LOB COLUMN(S): To fix this bug, upgrade HVR on the capture machine(s). [HVR-601] FIXED HVRMAINT SNMP ALERT MESSAGE SIZE OVERFLOW: To fix this bug, upgrade HVR on the hub machine(s). NEW FEATURES IN HVR 4.7.2/6 (2015-05-13) ---------------------------------------- [HVR-592] DB2 FOR I: SUPPORT PHYSICAL FILES (DDS): To use this feature, upgrade HVR on all machine(s). PROBLEMS FIXED IN HVR 4.7.2/6 (2015-05-13) ------------------------------------------ [HVR-563] F_JZ194F IGNORE INCOMPLETE PASTE CHANGES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-595] FIXED F_JD22D4 DURING BURST INTEGRATE INTO POSTGRESQL 8: To fix this bug, upgrade HVR on all machine(s). [HVR-591] RETRY COUNT ALWAYS 0 WHILE JOB HAS BEEN RETRIED A NUMBER OF TIMES: To fix this bug, upgrade HVR on the hub machine(s). NEW FEATURES IN HVR 4.7.2/5 (2015-05-12) ---------------------------------------- [HVR-574] GREENPLUM BULK LOAD USES GPFDIST PROTOCOL: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-587] POSTGRESQL 8 SUPPORT: To use this feature, upgrade HVR on all machine(s). [HVR-527] TERADATA LOB SUPPORT: To use this feature, upgrade HVR on all machine(s). PROBLEMS FIXED IN HVR 4.7.2/5 (2015-05-12) ------------------------------------------ [HVR-581] F_JD2279 WHEN CAPTURING LOB DATA: REMOVE ERRONEOUS TRACE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-579] F_JD2279: USE DOUBLED LOB LENGTH IN ALL CASES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-582] F_JG200A SEG.FAULT IN ORACLE LBC FOR TABLE WITH UN-ENROLLED COLUMNS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-547] F_JT0471 PARTIAL LOB FLAG SET ON LOB UPDATE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-541] F_JZ1543 COLUMN CHAINING MISMATCHES: To fix this bug, upgrade HVR on the capture machine(s). [HVR-573] FIXED WSAECONNABORTED WHILE CLOSING: To fix this bug, upgrade HVR on all machine(s). NEW FEATURES IN HVR 4.7.2/4 (2015-04-30) ---------------------------------------- [HVR-504] ADDED SUPPORT FOR BULK LOAD INTO DB2 LUW: To use this feature, upgrade HVR on all machine(s). [HVR-221] DB2 FOR LUW: LOG BASED CAPTURE OF LOBS: To use this feature, upgrade HVR on the capture machine(s). [HVR-534] DATABASE TO FILE REFRESH USES TEMPORARY FILE FOR WRITING: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-539] ENABLED ORACLE 10.2 FOR AIX 6.1 PLATFORMS: To use this feature, upgrade HVR on all machine(s). [HVR-497] IMPROVE MISSING ODBC DRIVER ERROR MESSAGE: To use this feature, upgrade HVR on all machine(s). [HVR-554] IMPROVED HADOOP INITIAL MEMORY CONSUMPTION: To use this feature, upgrade HVR on the capture machine(s). [HVR-270] MADE ALL CATALOG DATA UNICODE BASED: To use this feature, upgrade HVR on the gui and hub machine(s). [HVR-519] SUPPORT DB2 FOR I NAMED DATABASES ON OTHER AUXILIARY STORAGE POOLS: To use this feature, upgrade HVR on all machine(s). PROBLEMS FIXED IN HVR 4.7.2/4 (2015-04-30) ------------------------------------------ [HVR-542] CHANGED TERADATA TBLCREATE CLOB AND BLOB TO VARCHAR AND VARBYTE, RESPECTING LIMITS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-544] CINNECTION TO DB2 (KUW) LOCATION WITHOUT DB2INSTANCE SPECIFIED LEADS TO F_JR02AE: To fix this bug, upgrade HVR on all machine(s). [HVR-561] ELIMINATED HARMLESS F_JD20F2 REFERENCING DEADLOCK CONDITION DURING CAPTURE FROM SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-538] F_JD2131 WHILE PRINTING ORACLE TIMESTAMP WITH TIME ZONE VALUES CONTAINING REGION NAME: To fix this bug, upgrade HVR on all machine(s). [HVR-500] F_JD2279: UNEXPECTED ERROR WHILE CONVERTING UTF-16 DATA: To fix this bug, upgrade HVR on the capture machine(s). [HVR-472] F_JD2424 MISSING VALUES AFTER CHAINING: To fix this bug, upgrade HVR on the capture machine(s). [HVR-522] F_JZ1542 PARTIAL CHANGE BUT NO MATCHING ROW ON MINI DB: To fix this bug, upgrade HVR on the capture machine(s). [HVR-512] F_JZ1542 RECEIVED ROW PIECE WITH NO MATCHING PARTIAL ROW: To fix this bug, upgrade HVR on the capture machine(s). [HVR-511] F_JZ1975 UNEXPECTED SE FLAG VALUE ENCOUNTERED IN IRP: To fix this bug, upgrade HVR on the capture machine(s). [HVR-548] F_JZ3208 WHEN DB2 TABLE HAS VALUE COMPRESSION ENABLED: To fix this bug, upgrade HVR on the capture machine(s). [HVR-505] FIXED 'DEPENDENT MODULE LIBSTDC++.A(LIBSTDC++.SO.6) COULD NOT BE LOADED' ERROR ON AIX: To fix this bug, upgrade HVR on all machine(s). [HVR-518] FIXED F_JD0A0E DURING CAPTURE FROM HEAP TABLE ON SQL SERVER: To fix this bug, upgrade HVR on the capture machine(s). [HVR-559] FIXED F_JD0A33 DURING HVRLOAD ON SQL SERVER SOURCE WITH TABLES CONTAINING COMPUTED COLUMNS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-506] FIXED F_JD21B4 ERROR IF TABLE BASENAME NOT HVR NAME: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-498] FIXED F_JD2236 DURING INTEGRATE TO SQL SERVER IN BI-DIRECTIONAL CHANNEL: To fix this bug, upgrade HVR on the capture machine(s). [HVR-515] FIXED F_JD2239 WRONG DRIVER CLASS IN CAPTURE EXPRESSION IN BULK REFRESH: To fix this bug, upgrade HVR on the hub machine(s). [HVR-520] FIXED F_JG251D IN HVRSTATISTICS GUI FOR SOME LOCALES: To fix this bug, upgrade HVR on the gui machine(s). [HVR-507] FIXED HVR REFRESH INTO GP DROPS DOWN TO SINGLETON INSERT FOR TABLES WITH FLOATS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-521] FIXED TERADATA TIME AND TIMESTAMP LIMITS: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-531] FIXED SAVING CHANGES WHEN ONLY NAMED DATABASE OF DB2 FOR I LOCATION IS CHANGED: To fix this bug, upgrade HVR on the gui machine(s). [HVR-502] FIXED SELECT OF LARGE CLOB COLUMNS FROM DB2 FOR LUW AND FROM DB2 FOR I: To fix this bug, upgrade HVR on all machine(s). [HVR-492] REMOVE NON-PRINTABLE CHARS IN LAST_ERROR COL IN HVRSTATISTICS OUTPUT: To fix this bug, upgrade HVR on the hub machine(s). [HVR-536] REMOVED NON-FUNCTION HVRLOAD/COMPARE/REFRESH MENU ITEM: To fix this bug, upgrade HVR on the gui machine(s). [HVR-540] ROW-WISE REFRESH FAILS IN CAPTUREEXPRESSION SUB-SELECT WITH RENAMED COLUMNS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-478] SUPPORT FOR COMPRESSED TABLES IN DB2 LUW: To fix this bug, upgrade HVR on the capture machine(s). NEW FEATURES IN HVR 4.7.2/2 (2015-03-31) ---------------------------------------- [HVR-467] ADD SUPPORT FOR {HVR_SCHEMA} IN FILEINTEGRATE /RENAMEEXPRESSION: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-300] ADDED TRANSFORM /ROWS2CSV FOR MORE EFFICIENT DB->FILE CSV REPLICATION: To use this feature, upgrade HVR on the hub, integrate and gui machine(s). [HVR-499] ADDED SUPPORT FOR /SAPAUGMENT & /SAPXFORM: To use this feature, upgrade HVR on the capture, hub, gui and integrate machine(s). [HVR-466] SEPARATE FILEINTEGRATE /RENAMEEXPRESSION USING /CONTEXT: To use this feature, upgrade HVR on the hub machine(s). [HVR-337] SUPPORT LOG BASED CAPTURE FOR DB2 FOR I: To use this feature, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 4.7.2/2 (2015-03-31) ------------------------------------------ [HVR-471] ERROR F_JG2228 WHEN SELECTING A /DISTRIBUTIONKEY BY /NAME. WORKS FINE WITH /BASENAME: To fix this bug, upgrade HVR on the gui machine(s). [HVR-462] FIX HVR_BOOT FOR CLUSTER FAILOVER: To fix this bug, upgrade HVR on the hub machine(s). [HVR-346] FIXED F_JT0452 ON SQL SERVER DURING CAPTURE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-475] FIXED FILEINTEGRATE /BURST WITH TABLEPROPERTIES /DUPLICATEROWS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-468] FIXED HVRSTATISTICS NOT CORRECT WORKING IF MISMATCHING THE OFFSET FILE: To fix this bug, upgrade HVR on the hub machine(s). [HVR-496] HVR CHANNEL ERROR F_JZ192F LOB FRAGMENT ENCOUNTERS OPEN CHANGE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-480] MSSQL LBC(FN): F_JD20F2 ON CAPTURE JOB START IN MINIMAL PERMISSION MODEL: To fix this bug, upgrade HVR on the capture machine(s). [HVR-459] SCHEDULER PID FILE NOT DELETED: To fix this bug, upgrade HVR on the hub machine(s). [HVR-463] STRING WITH SCIENTIFIC NOTATION CAN NOT BE CONVERTED INTO A NUMBER: To fix this bug, upgrade HVR on all machine(s). NEW FEATURES IN HVR 4.7.2/1 (2015-03-05) ---------------------------------------- [HVR-422] ADD SUPPORT FOR GREENPLUM NUMERIC WITHOUT PRECISION AND SCALE: To use this feature, upgrade HVR on the integrate machine(s). [HVR-450] BETTER BURST JOIN FOR DB (LIKE GPDB) WHICH CANNOT DO NULL-JOINS: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-369] COMPACT XML OPTION FOR FP_XML: To use this feature, upgrade HVR on the integrate machine(s). [HVR-428] EXTEND SUPPORT FOR GREENPLUM NUMERIC WITHOUT PRECISION: To use this feature, upgrade HVR on the integrate machine(s). [HVR-447] INTEGRATION WITH LOCAL HADOOP INSTALLATION: To use this feature, upgrade HVR on the capture and integrate machine(s). [HVR-423] MSSQL LBC: ADD SPARSE TABLE/COLUMN SUPPORT: To use this feature, upgrade HVR on the capture machine(s). [HVR-376] ORACLE POSITIONING ERROR MESSAGES: To use this feature, upgrade HVR on the capture machine(s). PROBLEMS FIXED IN HVR 4.7.2/1 (2015-03-05) ------------------------------------------ [HVR-437] CAPTURE ON DB2 LUW FAILS WITH F_JT053E: To fix this bug, upgrade HVR on the capture machine(s). [HVR-377] F_JT0900: CHANGED ASSERTION CHECK FOR DUPLICATED ROLLBACK-IDS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-436] F_JZ1919 END CHANGE MATCHES CHAIN ALREADY IN END STATE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-392] F_JZ1919 START CHANGE MATCHES CHAIN ALREADY IN START STATE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-438] FIXED DBCAPTURE /AUGMENTINCOMPLETE NOT COMMITTING SELECT: To fix this bug, upgrade HVR on the hub and capture machine(s). [HVR-435] FIXED F_JD252E: ILLEGAL VERSION/FLAVOR ARGUMENT FOR CAPABILITY: To fix this bug, upgrade HVR on the hub machine(s). [HVR-429] FIXED F_JG200A DURING HDFS ERROR HANDLING: To fix this bug, upgrade HVR on the capture and integrate machine(s). [HVR-457] FIXED F_JG20CE ON TX-FILES IN INTEGRATE CAUSED BY ONLINE REFRESH: To fix this bug, upgrade HVR on the hub machine(s). [HVR-414] FIXED F_JT0541 DURING E.G. FILEINTEGRATE /MAXFILESIZE: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-385] FIXED F_JT152D IN FOR GREENPLUM TARGETS FOR TABLES WO LOBS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-374] FIXED HVR MAINT SUPPORT FOR MULTIPLE MONITORING JOBS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-205] FIXED LEAF ROW INSERT HANDLING IN LOG CAPTURE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-458] FIXED ONLINE REFRESH INCORRECTLY DELETING TX-FILES WITH NO-SKIPPING OPTION: To fix this bug, upgrade HVR on the hub machine(s). [HVR-453] FIXED ONLINE REFRESH RESTARTING JOBS BEFORE WRITING CONTROLS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-395] FIXED PARALLEL REFRESH WITH /DBPROCDURINGREFRESH: To fix this bug, upgrade HVR on the hub machine(s). [HVR-444] IMPROVED ORACLE LOG-BASED CAPTURE PERFORMANCE ON TABLES WITH MANY COLUMNS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-430] OLBC: OCI: REDUCED OVERHEAD WHEN THERE IS NO NEW DATA IN A REDO FILE: To fix this bug, upgrade HVR on the capture machine(s). [HVR-415] RESTRICT /CAPTURECONDITION THROWS F_JR0337 ON DB2 LUW (AND POSSIBLY DB2 FOR I): To fix this bug, upgrade HVR on the hub machine(s). NEW FEATURES IN HVR 4.7.2/0 (2015-02-06) ---------------------------------------- [HVR-384] ADD SUPPORT FOR POSTGRESQL AS TARGET: To use this feature, upgrade HVR on all machine(s). [HVR-334] ADDED DB2 FOR I FOR LINUX: To use this feature, upgrade HVR on all machine(s). [HVR-303] IMPROVED WRITE SPEED FOR NON-LOCAL (E.G. FTP) FILE LOCATIONS: To use this feature, upgrade HVR on the hub and integrate machine(s). [HVR-398] INCREASED INTEGRATE PERFORMANCE WITH NOW() EXPRESSIONS: To use this feature, upgrade HVR on the hub machine(s). [HVR-391] MSSQL LBC: ALLOW USE OF CDC TABLE TO ENABLE SUPPLEMENTAL LOGGING: To use this feature, upgrade HVR on the hub and capture machine(s). [HVR-359] RENAME ENVIRONMENT VARIABLE HVR_CATALOG_CHARSET TO HVR_HUB_CHARSET: To use this feature, upgrade HVR on the hub machine(s). PROBLEMS FIXED IN HVR 4.7.2/0 (2015-02-06) ------------------------------------------ [HVR-368] BURST TABLE CREATION MAY FAIL ON GREENPLUM DEPENDING ON SEARCH_PATH SETTING: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-404] CAPTURE FAILS WITH F_JD21F1 ON TABLE WITH COLUMNPROPERTIES /ABSENT: To fix this bug, upgrade HVR on the hub machine(s). [HVR-136] F_JD2279: ERROR WHILE CONVERTING UTF-16 DATA: To fix this bug, upgrade HVR on the capture machine(s). [HVR-390] F_JT044C CHANGE WITH TX_ID DID NOT MATCH AN EXISTING TX: To fix this bug, upgrade HVR on the capture machine(s). [HVR-403] FIXED FP_PROJECT FAILS WITH F_JG2301 FOR TABLES WITH TABLEPROPERTIES /SCHEMA: To fix this bug, upgrade HVR on the capture machine(s). [HVR-354] FIXED F_JD0006 IN HVRADAPT FOR TABLES THAT DON'T EXIST IN DB: To fix this bug, upgrade HVR on the hub machine(s). [HVR-397] FIXED F_JG200A DURING BULK REFRESH WITH TRANSFORM /ARGUMENTVALUE WITHOUT /BUILTIN: To fix this bug, upgrade HVR on the hub machine(s). [HVR-363] FIXED F_JG200A: SIGSEGV DURING TRUNCATE ON TABLE WITH IGNORED COLUMNS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-389] FIXED F_JG2459 FOR DB->FILE REFRESH WITH AGENT ACTIONS: To fix this bug, upgrade HVR on the hub machine(s). [HVR-352] FIXED HVR REFRESH WITH DBSEQUENCE FAILING WITH F_JG21A6: To fix this bug, upgrade HVR on the hub machine(s). [HVR-360] FIXED HVRSTATISTICS NOT PRODUCING OUTPUT AFTER HVRMAINT ARCHIVING: To fix this bug, upgrade HVR on the hub machine(s). [HVR-233] FIXED MEMORY LEAK WHEN CAPTURING NO-OP CHANGES VIA /LOGBASED: To fix this bug, upgrade HVR on the capture machine(s). [HVR-313] FIXED NOT DECIMAL DATATYPE FOR MINIMUM LATENCY COLS IN HVRSTATISTICS CHANNEL: To fix this bug, upgrade HVR on the hub machine(s). [HVR-358] FIXED POTENTIAL CORRUPTION ON COLUMN EXPRESSION ON GREENPLUM TIMESTAMP WITH TIME ZONE: To fix this bug, upgrade HVR on all machine(s). [HVR-337] FIXED POTENTIAL MISORDERING DURING ROW-WISE REFRESH/COMPARE WITH DB2 FOR I: To fix this bug, upgrade HVR on the hub machine(s). [HVR-388] FIXED REMOTE FILE LOCATION (FTP) PASSWORDS FOR DB->FILE REFRESH: To fix this bug, upgrade HVR on the hub machine(s). [HVR-129] HVR REFRESH FAILS TO CREATE TABLES WITH SMALLMONEY TYPE COLUMNS ON SQL SERVER: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-341] IMPROVED CHECKS BEFORE STARTING REFRESH: To fix this bug, upgrade HVR on the hub machine(s). [HVR-350] INCORRECT QUOTES ON SCHEMA.TABLE NAME IN HVR_BULK_LOAD: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-386] LBC MISSES CHANGES IN TABLES WITH LARGE COLUMN COUNTS: To fix this bug, upgrade HVR on the capture machine(s). [HVR-259] LOG SCANNING ERROR F_JZ1017. ORACLE REDO FILE HAS TYPE 00: To fix this bug, upgrade HVR on the capture machine(s). [HVR-345] REFRESH INTO A FILE-TARGET PRODUCES INVALID XML FILES: To fix this bug, upgrade HVR on the integrate machine(s). [HVR-339] SEGMENTATION FAULT WHEN RUN DBINTEGRATE /BURST ON GREENPLUM: To fix this bug, upgrade HVR on the integrate machine(s).