HVR Forum

Simon
HVR
Simon
Offline
HVR 4.7.3/41 has been released as GA on May 18th 2015.

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/25)

PROBLEMS FIXED IN HVR 4.7.3/41 (2016-05-18)
-------------------------------------------

[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-1514] FIXED S3 ERROR RETRY MIGHT TRIGGER 100% CPU USAGE AND HANGING WITH REDSHIFT:
To fix this bug, upgrade HVR on the integrate 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).

PROBLEMS FIXED IN HVR 4.7.3/40 (2016-05-12)
-------------------------------------------

[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-1512] FIXED F_JD2146 DURING ROW-WISE REFRESH WITH /COLUMNPROPERTIES /BASENAME:
To fix this bug, upgrade HVR on the integrate machine(s).

[HVR-1510] FIXED F_JG358E OVERWRITING OTHER ERRORS DURING PARALLEL REFRESH:
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).

PROBLEMS FIXED IN HVR 4.7.3/39 (2016-04-25)
-------------------------------------------

[HVR-1405] F_JZ1537. 'APPEND HINT' CONTAINS DATA FOR TOO MANY COLUMNS:
To fix this bug, upgrade HVR on the capture 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).

PROBLEMS FIXED IN HVR 4.7.3/38 (2016-04-19)
-------------------------------------------

[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-1384] FIXED HVR HANG DURING INTEGRATION INTO TERADATA:
To fix this bug, upgrade HVR on the integrate machine(s).

[HVR-1477] FIXED CONCURRENT TERADATA BULK LOADS MAY HANG:
To fix this bug, upgrade HVR on the integrate 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-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).

NEW FEATURES IN HVR 4.7.3/37 (2016-04-15)
-----------------------------------------

[HVR-1467] TERADATA SUPPORTS BULK LOAD ON WINDOWS PLATFORMS:
To use this feature, upgrade HVR on the integrate machine(s).

PROBLEMS FIXED IN HVR 4.7.3/37 (2016-04-15)
-------------------------------------------

[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-1303] MISSING COLUMN QUOTING IN FAIL TABLE INSERT WHEN INTEGRATE /BURST IS DEFINED:
To fix this bug, upgrade HVR on the integrate machine(s).

NEW FEATURES IN HVR 4.7.3/36 (2016-04-13)
-----------------------------------------

[HVR-1236] IMPLEMENT -TASK_GROUP PARAMETER FOR HVRMAINT TO SHARE STATE BETWEEN TASKS:
To use this feature, upgrade HVR on the hub machine(s).

PROBLEMS FIXED IN HVR 4.7.3/36 (2016-04-13)
-------------------------------------------

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

NEW FEATURES IN HVR 4.7.3/35 (2016-04-12)
-----------------------------------------

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

PROBLEMS FIXED IN HVR 4.7.3/35 (2016-04-12)
-------------------------------------------

[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-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-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-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-1442] FIXED BATCH LOAD PERFORMANCE DROPS TO SINGLETON INSERT:
To fix this bug, upgrade HVR on the integrate 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-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-1408] W_JT044C MISSING BEGIN TRANSACTIONS IN SAP SYSTEMS:
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).

PROBLEMS FIXED IN HVR 4.7.3/34 (2016-03-25)
-------------------------------------------

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

NEW FEATURES IN HVR 4.7.3/33 (2016-03-23)
-----------------------------------------

[HVR-1326] IMPROVED DB2 FOR I LOGBASED CAPTURE PERFORMANCE BY FILTERING UNUSED RECORDS:
To use this feature, upgrade HVR on the capture machine(s).

PROBLEMS FIXED IN HVR 4.7.3/33 (2016-03-23)
-------------------------------------------

[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-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-1257] FIXED TBLWRITE DOES NOT USE THE SCHEMA NAME DURING TABLE CREATION:
To fix this bug, upgrade HVR on the integrate machine(s).

[HVR-1389] HVRVALIDPW DOES NOT WORK CORRECTLY ON SOLARIS:
To fix this bug, upgrade HVR on the hub machine(s).

PROBLEMS FIXED IN HVR 4.7.3/32 (2016-03-18)
-------------------------------------------

[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-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-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-1351] FIXED F_JG052E WITH SFTP PROTOCOL ERROR:
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-1358] FIXED LEFTOVER FILES IN S3 AFTER REDSHIFT INTEGRATE:
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-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-1360] HVRROUTERVIEW -J CANNOT FIND JOURNAL FILES FROM DBINTEGRATE/JOURNAL:
To fix this bug, upgrade HVR on the hub machine(s).

NEW FEATURES IN HVR 4.7.3/31 (2016-03-11)
-----------------------------------------

[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-1258] WORKAROUND FOR SYNCHRONY GATEWAY FTP SERVERS DROPPING UPLOADED FILES:
To use this feature, upgrade HVR on the capture and integrate machine(s).

PROBLEMS FIXED IN HVR 4.7.3/31 (2016-03-11)
-------------------------------------------

[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-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-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-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-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-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-1291] FIXED F_JG200A DURING REFRESH OR INTEGRATE TO POSTGRESQL:
To fix this bug, upgrade HVR on the integrate 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-1143] FIXED F_JT1449: 'HVR_REC_TSTAMP' WAS NOT MATCHED:
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-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-1278] FIXED SOFTDELETE MIGHT CAUSE MEMORY CORRUPTION, SPURIOUS F_JG221D:
To fix this bug, upgrade HVR on the hub and integrate 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-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-1312] FIXED GUARDIANS NOT TERMINATING CHILD PROCESSES:
To fix this bug, upgrade HVR on the hub, capture and integrate machine(s).

[HVR-1321] FIXED LEFTOVER DEBUG MESSAGE IN DB2 FOR I LBC:
To fix this bug, upgrade HVR on the capture machine(s).

[HVR-1301] FIXED MISSING UPDATES WITH /BURST OR /COALESCE:
To fix this bug, upgrade HVR on the integrate 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-1200] SUPPORT FOR APPEND HINT INSERTS FOR COMPRESSED TABLES:
To fix this bug, upgrade HVR on the capture machine(s).

NEW FEATURES IN HVR 4.7.3/30 (2016-02-23)
-----------------------------------------

[HVR-1219] ADD COMPARECONDITION TO RESTRICT ACTION

NEW FEATURES IN HVR 4.7.3/30 (2016-02-23)
-----------------------------------------

[HVR-1219] ADD COMPARECONDITION TO RESTRICT ACTION:
To use this feature, upgrade HVR on the hub 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 4.7.3/30 (2016-02-23)
-------------------------------------------

[HVR-1249] FIXED F_JD2503 INVALID PATH FOR VASM CAPTURE:
To fix this bug, upgrade HVR on the capture 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-1174] ORACLE CAPTURE FAILED WITH F_JC0018: INTERNAL ERROR: UNREGISTERED EVENT:
To fix this bug, upgrade HVR on the capture 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 4.7.3/29 (2016-02-12)
-----------------------------------------

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

PROBLEMS FIXED IN HVR 4.7.3/29 (2016-02-12)
-------------------------------------------
[HVR-1213] ORACLE CAPTURE FAILED WITH SEGMENTATION VIOLATION WHILE HANDLING URP RECORD
To fix this bug, upgrade HVR on the capture 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-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-1051] SLOW CATALOG INITIALIZE WHEN LOTS OF LOCATIONS AND CHANNELS:
To fix this bug, upgrade HVR on the hub machine(s).

NEW FEATURES IN HVR 4.7.3/28 (2016-02-01)
-----------------------------------------

[HVR-1190] ADD SUPPORT FOR TERADATA BULK LOAD VIA TPT:
To use this feature, upgrade HVR on the hub and integrate machine(s).

PROBLEMS FIXED IN HVR 4.7.3/28 (2016-02-01)
-------------------------------------------

[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-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-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 4.7.3/26 (2016-01-26)
-----------------------------------------

[HVR-1134] ADD TERADATA DISTRIBUTION KEY SUPPORT:
To use this feature, upgrade HVR on the integrate machine(s).

PROBLEMS FIXED IN HVR 4.7.3/26 (2016-01-26)
-------------------------------------------

[HVR-1179] FIXED REDSHIFT CAN'T PARSE INSTANCE PROFILE ROLE CREDENTIALS:
To fix this bug, upgrade HVR on the integrate 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-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).
Responses (0)
  • There are no replies here yet.
Your Reply