HVR Forum

Simon
HVR
Simon
Offline
HVR 4.7.3/25 has been released as GA on Jan 27th 2016.

Below is an extract from the release notes containing a list of new features and problems fixed since the last GA release (4.7.3/7)

ROBLEMS FIXED IN HVR 4.7.3/25 (2016-01-22)
-------------------------------------------

[HVR-1163] F_JD0A1F DURING CAPTURE FROM COMPRESSED TABLES ON SQL SERVER:
To fix this bug, upgrade HVR on the capture machine(s).

[HVR-1156] FIXED F_JD21AD IN VERBOSE COMPARE WITH SOFTDELETE:
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-1155] FIXED F_JT1477 WITH /BURST AND /DUPLICATEROWS:
To fix this bug, upgrade HVR on the 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-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-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).


NEW FEATURES IN HVR 4.7.3/24 (2016-01-11)
-----------------------------------------

[HVR-1139] CLIENT-SIDE SSL CERTIFICATES FOR FTPS AND WEBDAV:
To use this feature, upgrade HVR on the capture and integrate machine(s).


PROBLEMS FIXED IN HVR 4.7.3/24 (2016-01-11)
-------------------------------------------

[HVR-1126] FIXED F_JD2146 DURING VERBOSE COMPARE WITH EXPRESSIONS:
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).


PROBLEMS FIXED IN HVR 4.7.3/23 (2016-01-07)
-------------------------------------------

[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).


NEW FEATURES IN HVR 4.7.3/22 (2015-12-31)
-----------------------------------------

[HVR-1109] ADD HVR_TABLE_CREATE_CHAR_MULTIPLIER TO OVERRIDE LENGTH IN TABLE CLONE:
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-1098] IMPROVED DB2 FOR I CAPTURE SPEED:
To use this feature, upgrade HVR on the capture machine(s).


PROBLEMS FIXED IN HVR 4.7.3/22 (2015-12-31)
-------------------------------------------

[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-1114] FIXED F_JT148B: PIPE ROWAUGMENT ENCOUNTERED ILLEGALLY LONG VALUE FOR 'HVR_TX_SEQ':
To fix this bug, upgrade HVR on the capture 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-1108] FIXED F_JT0527 WITH DB2 FOR I LOG-BASED CAPTURE:
To fix this bug, upgrade HVR on the capture machine(s).

[HVR-1103] FIXED INCORRECTLY IRREGULAR OUTPUT IN HVRSTATISTICS:
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-1090] FIXED HVRREFRESH FAILS WITH F_JG200A IN SELECT ON HVR CATALOGS:
To fix this bug, upgrade HVR on the hub 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-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).



PROBLEMS FIXED IN HVR 4.7.3/21 (2015-12-17)
-------------------------------------------

[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).


NEW FEATURES IN HVR 4.7.3/20 (2015-12-14)
-----------------------------------------

[HVR-967] ADD OPTION -DISABLE AND -CLEAR_PAST_ERRORS TO HVRMAINT:
To use this feature, upgrade HVR on the hub machine(s).

[HVR-1074] FILE INTEGRATE XML SERIALIZATION WITH COMPACT XML:
To use this feature, upgrade HVR on the hub and gui machine(s).


PROBLEMS FIXED IN HVR 4.7.3/20 (2015-12-14)
-------------------------------------------

[HVR-1073] FIXED HVRMAINT REPORTING 0 INTEGRATE CHANGES IF THERE WERE CHANGES:
To fix this bug, upgrade HVR on the hub 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-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).


NEW FEATURES IN HVR 4.7.3/19 (2015-12-02)
-----------------------------------------

[HVR-1062] ALLOW MULTIPLE DBSEQUENCE /SCHEMA ACTIONS:
To use this feature, upgrade HVR on the hub 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-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-1057] HVR_ISOLATION_LEVEL TO OVERRIDE DEFAULT ISOLATION LEVEL:
To use this feature, upgrade HVR on all machine(s).


PROBLEMS FIXED IN HVR 4.7.3/19 (2015-12-02)
-------------------------------------------

[HVR-1059] FIXED TABLE SELECT DISPLAYS GREENPLUM EXTERNAL TABLES:
To fix this bug, upgrade HVR on the hub 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-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).



NEW FEATURES IN HVR 4.7.3/18 (2015-11-26)
-----------------------------------------

[HVR-1040] VARIOUS SFTP COMPATIBILITY ENHANCEMENTS:
To use this feature, upgrade HVR on the capture and integrate machine(s).


PROBLEMS FIXED IN HVR 4.7.3/18 (2015-11-26)
-------------------------------------------

[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-1045] FIXED HVRLOAD -OC (CHANGE TABLE) OPTION DISABLED IN HVRGUI FOR /BURST:
To fix this bug, upgrade HVR on the gui 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).



NEW FEATURES IN HVR 4.7.3/17 (2015-11-19)
-----------------------------------------

[HVR-643] ORACLE ADD HVR_ENROLL_VLOGFILE_RESTRICT TO SPECIFY REDO DISKGROUP:
To use this feature, upgrade HVR on the capture 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).


PROBLEMS FIXED IN HVR 4.7.3/17 (2015-11-19)
-------------------------------------------

[HVR-1022] /AGENT INVOCATION GIVES F_JG2142 PROTOTYPE ERROR:
To fix this bug, upgrade HVR on the capture, hub and 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-1026] FIXED JT152D WITH FILEINTEGRATE /BURST:
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-1027] ORACLE LBC F_JZ196A - NULL BITMAP LENGTH ERROR IN UPDATE:
To fix this bug, upgrade HVR on the capture machine(s).


PROBLEMS FIXED IN HVR 4.7.3/16 (2015-11-12)
-------------------------------------------

[HVR-1019] FIXED BURST INTEGRATE INTO GREENPLUM ALWAYS RECREATE THE EXTERNAL TABLE:
To fix this bug, upgrade HVR on the integrate machine(s).


NEW FEATURES IN HVR 4.7.3/15 (2015-11-10)
-----------------------------------------

[HVR-1009] IMPROVED ORACLE RAC CLUSTER REDIRECTS:
To use this feature, upgrade HVR on the hub machine(s).


PROBLEMS FIXED IN HVR 4.7.3/15 (2015-11-10)
-------------------------------------------

[HVR-995] HVR LOADS INTO BURST TABLES IN REDSHIFT DISABLES AUTOMATIC COMPRESSION:
To fix this bug, upgrade HVR on the integrate machine(s).


PROBLEMS FIXED IN HVR 4.7.3/14 (2015-11-03)
-------------------------------------------

[HVR-993] FIXED GREENPLUM SQLPREPARE HANGS AFTER DATABASE RESTART:
To fix this bug, upgrade HVR on the integrate machine(s).


NEW FEATURES IN HVR 4.7.3/13 (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).


PROBLEMS FIXED IN HVR 4.7.3/13 (2015-10-30)
-------------------------------------------

[HVR-974] FIXED UNBOUNDED HEAP GROWTH ON SOLARIS:
To fix this bug, upgrade HVR on all machine(s).

[HVR-985] ORACLE CAPTURE FAILED WITH F_JZ1547: READ OVERFLOW IN EXTRACTING COLUMN DATA IN CHANGE TYPE 11.11 REDO QMI (UNPACKED CASE):
To fix this bug, upgrade HVR on the capture 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-929] ORACLE F_JZ1919 CHAINER INSERT AND ROW BOTH IN START STATE:
To fix this bug, upgrade HVR on the capture machine(s).

[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).


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-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).
Responses (0)
  • There are no replies here yet.
Your Reply