Home Topics HVR Realtime Replicator Community Discussions HVR Integration Stuck
HVR Integration Stuck
 This topic is empty.

AuthorPosts

October 9, 2017 at 1:57 am #11334AnonymousInactive
Hi All,
I am facing problem with my Integration. It is in running state but seems that it is not integrating any changes in the target. Log is also not generating and latency is increasing. Can some one please let me know the insights of the reasons that may be causing the situation.
Thanks,
Ayush
October 9, 2017 at 2:48 am #11335Erik van VeenKeymasterHello Ayush,
can you tell me what is going on at the capture side ? Is the capture job running ? If at all possible, can you login to the hub and copy/paste the last 100 lines from the file $HVR_CONFIG/log/<hub>/<channel>.out in a reply ?
Regards, Erik
October 10, 2017 at 4:13 am #11339AnonymousInactiveHi Erik,
The capture job is running fine. Some background info : Source is Oracle, target is greenplum and compression was run on Target DB. Because of compression we lost primary keys on Target side. However, keys are present on Source side and in HVR catalogue.
I am copying more than 100 lines from the out file but they contain only capture data. Please let me know if I can send you out file.
20171010 09:45:12: gcars_dlakecapgcrsr: Capture cycle 7554.
20171010 04:45:12: gcars_dlakecapgcrsr: Scanned 4 transactions (72752 bytes) from between 1 second and 0 seconds ago containing 20 rows (10 upd) for 2 tables in 0.51 seconds.
20171010 09:45:12: gcars_dlakecapgcrsr: Routed 4728 bytes (compression=95.5%) from ‘gcrsr’ into 1 location.
20171010 09:45:12: gcars_dlakecapgcrsr: Capture cycle 7555.
20171010 04:45:12: gcars_dlakecapgcrsr: Scanned 3 transactions (42896 bytes) from 0 seconds ago containing 12 rows (6 upd) for 2 tables in 0.51 seconds.
20171010 09:45:13: gcars_dlakecapgcrsr: Routed 4169 bytes (compression=93.7%) from ‘gcrsr’ into 1 location.
20171010 09:45:13: gcars_dlakecapgcrsr: Capture cycle 7556.
20171010 04:45:13: gcars_dlakecapgcrsr: Scanned 5 transactions (97520 bytes) from between 1 second and 0 seconds ago containing 20 rows (10 upd) for 2 tables in 1.01 seconds.
20171010 09:45:14: gcars_dlakecapgcrsr: Routed 4934 bytes (compression=95.2%) from ‘gcrsr’ into 1 location.
20171010 09:45:14: gcars_dlakecapgcrsr: Capture cycle 7557.
20171010 04:45:14: gcars_dlakecapgcrsr: Scanned 5 transactions (85232 bytes) from 0 seconds ago containing 20 rows (10 upd) for 2 tables in 1.01 seconds.
20171010 09:45:15: gcars_dlakecapgcrsr: Routed 4895 bytes (compression=95.4%) from ‘gcrsr’ into 1 location.
20171010 09:45:15: gcars_dlakecapgcrsr: Capture cycle 7558.
20171010 04:45:16: gcars_dlakecapgcrsr: Scanned 5 transactions (130960 bytes) from between 1 second and 0 seconds ago containing 20 rows (10 upd) for 2 tables in 1.01 seconds.
20171010 09:45:16: gcars_dlakecapgcrsr: Routed 4829 bytes (compression=95.3%) from ‘gcrsr’ into 1 location.
20171010 09:45:16: gcars_dlakecapgcrsr: Capture cycle 7559.
20171010 04:45:17: gcars_dlakecapgcrsr: Scanned 4 transactions (85232 bytes) from 1 second ago containing 16 rows (8 upd) for 2 tables in 1.01 seconds.
20171010 09:45:17: gcars_dlakecapgcrsr: Routed 4571 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.
20171010 09:45:17: gcars_dlakecapgcrsr: Capture cycle 7560.
20171010 04:45:18: gcars_dlakecapgcrsr: Scanned 6 transactions (105328 bytes) from between 2 seconds and 1 second ago containing 24 rows (12 upd) for 2 tables in 1.01 seconds.
20171010 09:45:18: gcars_dlakecapgcrsr: Routed 5165 bytes (compression=95.8%) from ‘gcrsr’ into 1 location.
20171010 09:45:18: gcars_dlakecapgcrsr: Capture cycle 7561.
20171010 04:45:19: gcars_dlakecapgcrsr: Scanned 7 transactions (106848 bytes) from between 1 second and 0 seconds ago containing 28 rows (14 upd) for 2 tables in 1.01 seconds.
20171010 09:45:19: gcars_dlakecapgcrsr: Routed 5416 bytes (compression=96.2%) from ‘gcrsr’ into 1 location.
20171010 09:45:19: gcars_dlakecapgcrsr: Capture cycle 7562.
20171010 04:45:19: gcars_dlakecapgcrsr: Scanned 6 transactions (80576 bytes) from 0 seconds ago containing 30 rows (15 upd) for 4 tables in 0.51 seconds.
20171010 09:45:19: gcars_dlakecapgcrsr: Routed 9251 bytes (compression=92.6%) from ‘gcrsr’ into 1 location.
20171010 09:45:19: gcars_dlakecapgcrsr: Capture cycle 7563.
20171010 04:45:20: gcars_dlakecapgcrsr: Scanned 5 transactions (108848 bytes) from between 1 second and 0 seconds ago containing 20 rows (10 upd) for 2 tables in 1.01 seconds.
20171010 09:45:20: gcars_dlakecapgcrsr: Routed 5025 bytes (compression=95.1%) from ‘gcrsr’ into 1 location.
20171010 09:45:20: gcars_dlakecapgcrsr: Capture cycle 7564.
20171010 04:45:21: gcars_dlakecapgcrsr: Scanned 4 transactions (104896 bytes) from between 1 second and 0 seconds ago containing 16 rows (8 upd) for 2 tables in 1.01 seconds.
20171010 09:45:21: gcars_dlakecapgcrsr: Routed 4538 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.
20171010 09:45:21: gcars_dlakecapgcrsr: Capture cycle 7565.
20171010 04:45:22: gcars_dlakecapgcrsr: Scanned 6 transactions (102112 bytes) from between 1 second and 0 seconds ago containing 32 rows (16 upd) for 2 tables in 1.01 seconds.
20171010 09:45:22: gcars_dlakecapgcrsr: Routed 5490 bytes (compression=96.7%) from ‘gcrsr’ into 1 location.
20171010 09:45:22: gcars_dlakecapgcrsr: Capture cycle 7566.
20171010 04:45:23: gcars_dlakecapgcrsr: Scanned 5 transactions (82656 bytes) from between 1 second and 0 seconds ago containing 20 rows (10 upd) for 2 tables in 1.01 seconds.
20171010 09:45:23: gcars_dlakecapgcrsr: Routed 4745 bytes (compression=95.5%) from ‘gcrsr’ into 1 location.
20171010 09:45:23: gcars_dlakecapgcrsr: Capture cycle 7567.
20171010 04:45:24: gcars_dlakecapgcrsr: Scanned 3 transactions (793728 bytes) from between 1 second and 0 seconds ago containing 8 rows (4 upd) for 3 tables in 1.01 seconds.
20171010 09:45:25: gcars_dlakecapgcrsr: Routed 6394 bytes (compression=82.6%) from ‘gcrsr’ into 1 location.
20171010 09:45:25: gcars_dlakecapgcrsr: Capture cycle 7568.
20171010 04:45:25: gcars_dlakecapgcrsr: Scanned 5 transactions (105312 bytes) from 0 seconds ago containing 22 rows (11 upd) for 5 tables in 1.01 seconds.
20171010 09:45:26: gcars_dlakecapgcrsr: Routed 9671 bytes (compression=93.5%) from ‘gcrsr’ into 1 location.
20171010 09:45:26: gcars_dlakecapgcrsr: Capture cycle 7569.
20171010 04:45:26: gcars_dlakecapgcrsr: Scanned 4 transactions (76896 bytes) from 0 seconds ago containing 15 rows (1 ins, 7 upd) for 4 tables in 1.01 seconds.
20171010 09:45:27: gcars_dlakecapgcrsr: Routed 5960 bytes (compression=91.7%) from ‘gcrsr’ into 1 location.
20171010 09:45:27: gcars_dlakecapgcrsr: Capture cycle 7570.
20171010 04:45:27: gcars_dlakecapgcrsr: Scanned 3 transactions (105008 bytes) from between 1 second and 0 seconds ago containing 12 rows (6 upd) for 2 tables in 1.01 seconds.
20171010 09:45:28: gcars_dlakecapgcrsr: Routed 4236 bytes (compression=93.4%) from ‘gcrsr’ into 1 location.
20171010 09:45:28: gcars_dlakecapgcrsr: Capture cycle 7571.
20171010 04:45:28: gcars_dlakecapgcrsr: Scanned 3 transactions (54608 bytes) from between 1 second and 0 seconds ago containing 12 rows (6 upd) for 2 tables in 0.51 seconds.
20171010 09:45:28: gcars_dlakecapgcrsr: Routed 4107 bytes (compression=93.8%) from ‘gcrsr’ into 1 location.
20171010 09:45:28: gcars_dlakecapgcrsr: Capture cycle 7572.
20171010 04:45:29: gcars_dlakecapgcrsr: Scanned 6 transactions (99664 bytes) from between 1 second and 0 seconds ago containing 32 rows (16 upd) for 2 tables in 1.01 seconds.
20171010 09:45:29: gcars_dlakecapgcrsr: Routed 5408 bytes (compression=96.7%) from ‘gcrsr’ into 1 location.
20171010 09:45:29: gcars_dlakecapgcrsr: Capture cycle 7573.
20171010 04:45:30: gcars_dlakecapgcrsr: Scanned 5 transactions (133328 bytes) from between 1 second and 0 seconds ago containing 20 rows (10 upd) for 2 tables in 1.01 seconds.
20171010 09:45:30: gcars_dlakecapgcrsr: Routed 5009 bytes (compression=95.1%) from ‘gcrsr’ into 1 location.
20171010 09:45:30: gcars_dlakecapgcrsr: Capture cycle 7574.
20171010 04:45:31: gcars_dlakecapgcrsr: Scanned 12 transactions (205680 bytes) from between 1 second and 0 seconds ago containing 49 rows (1 ins, 24 upd) for 6 tables in 1.01 seconds.
20171010 09:45:31: gcars_dlakecapgcrsr: Routed 11891 bytes (compression=94.2%) from ‘gcrsr’ into 1 location.
20171010 09:45:31: gcars_dlakecapgcrsr: Capture cycle 7575.
20171010 04:45:32: gcars_dlakecapgcrsr: Scanned 6 transactions (136656 bytes) from between 1 second and 0 seconds ago containing 28 rows (14 upd) for 4 tables in 1.01 seconds.
20171010 09:45:32: gcars_dlakecapgcrsr: Routed 8943 bytes (compression=92.5%) from ‘gcrsr’ into 1 location.
20171010 09:45:32: gcars_dlakecapgcrsr: Capture cycle 7576.
20171010 04:45:33: gcars_dlakecapgcrsr: Scanned 2 transactions (88352 bytes) from 1 second ago containing 8 rows (4 upd) for 2 tables in 0.51 seconds.
20171010 09:45:33: gcars_dlakecapgcrsr: Routed 3879 bytes (compression=91.5%) from ‘gcrsr’ into 1 location.
20171010 09:45:33: gcars_dlakecapgcrsr: Capture cycle 7577.
20171010 04:45:33: gcars_dlakecapgcrsr: Scanned 4 transactions (54160 bytes) from between 1 second and 0 seconds ago containing 16 rows (8 upd) for 2 tables in 0.51 seconds.
20171010 09:45:33: gcars_dlakecapgcrsr: Routed 4676 bytes (compression=94.5%) from ‘gcrsr’ into 1 location.
20171010 09:45:33: gcars_dlakecapgcrsr: Capture cycle 7578.
20171010 04:45:34: gcars_dlakecapgcrsr: Scanned 5 transactions (137680 bytes) from between 1 second and 0 seconds ago containing 26 rows (13 upd) for 6 tables in 1.01 seconds.
20171010 09:45:34: gcars_dlakecapgcrsr: Routed 9730 bytes (compression=91.1%) from ‘gcrsr’ into 1 location.
20171010 09:45:34: gcars_dlakecapgcrsr: Capture cycle 7579.
20171010 04:45:35: gcars_dlakecapgcrsr: Scanned 6 transactions (115568 bytes) from between 1 second and 0 seconds ago containing 32 rows (16 upd) for 4 tables in 1.01 seconds.
20171010 09:45:35: gcars_dlakecapgcrsr: Routed 9251 bytes (compression=93.4%) from ‘gcrsr’ into 1 location.
20171010 09:45:35: gcars_dlakecapgcrsr: Capture cycle 7580.
20171010 04:45:36: gcars_dlakecapgcrsr: Scanned 7 transactions (88832 bytes) from between 1 second and 0 seconds ago containing 26 rows (13 upd) for 3 tables in 1.01 seconds.
20171010 09:45:36: gcars_dlakecapgcrsr: Routed 7500 bytes (compression=94.3%) from ‘gcrsr’ into 1 location.
20171010 09:45:36: gcars_dlakecapgcrsr: Capture cycle 7581.
20171010 04:45:37: gcars_dlakecapgcrsr: Scanned 5 transactions (248512 bytes) from between 1 second and 0 seconds ago containing 20 rows (10 upd) for 2 tables in 1.01 seconds.
20171010 09:45:37: gcars_dlakecapgcrsr: Routed 4749 bytes (compression=95.5%) from ‘gcrsr’ into 1 location.
20171010 09:45:37: gcars_dlakecapgcrsr: Capture cycle 7582.
20171010 04:45:38: gcars_dlakecapgcrsr: Scanned 7 transactions (198128 bytes) from between 1 second and 0 seconds ago containing 104 rows (52 upd) for 4 tables in 1.01 seconds.
20171010 09:45:38: gcars_dlakecapgcrsr: Routed 16384 bytes (compression=94.8%) from ‘gcrsr’ into 1 location.
20171010 09:45:39: gcars_dlakecapgcrsr: Capture cycle 7583.
20171010 04:45:39: gcars_dlakecapgcrsr: Scanned 6 transactions (122960 bytes) from between 1 second and 0 seconds ago containing 38 rows (19 upd) for 4 tables in 1.01 seconds.
20171010 09:45:40: gcars_dlakecapgcrsr: Routed 9540 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.
20171010 09:45:40: gcars_dlakecapgcrsr: Capture cycle 7584.
20171010 04:45:40: gcars_dlakecapgcrsr: Scanned 8 transactions (117760 bytes) from between 1 second and 0 seconds ago containing 35 rows (1 ins, 17 upd) for 5 tables in 1.01 seconds.
20171010 09:45:41: gcars_dlakecapgcrsr: Routed 9265 bytes (compression=93.7%) from ‘gcrsr’ into 1 location.
20171010 09:45:41: gcars_dlakecapgcrsr: Capture cycle 7585.
20171010 04:45:41: gcars_dlakecapgcrsr: Scanned 5 transactions (77616 bytes) from between 1 second and 0 seconds ago containing 20 rows (10 upd) for 3 tables in 1.01 seconds.
20171010 09:45:42: gcars_dlakecapgcrsr: Routed 6062 bytes (compression=93.8%) from ‘gcrsr’ into 1 location.
20171010 09:45:42: gcars_dlakecapgcrsr: Capture cycle 7586.
20171010 04:45:42: gcars_dlakecapgcrsr: Scanned 6 transactions (124736 bytes) from 0 seconds ago containing 26 rows (13 upd) for 2 tables in 1.01 seconds.
20171010 09:45:43: gcars_dlakecapgcrsr: Routed 6150 bytes (compression=95.4%) from ‘gcrsr’ into 1 location.
20171010 09:45:43: gcars_dlakecapgcrsr: Capture cycle 7587.
20171010 04:45:43: gcars_dlakecapgcrsr: Scanned 5 transactions (82512 bytes) from between 1 second and 0 seconds ago containing 29 rows (1 ins, 14 upd) for 7 tables in 0.51 seconds.
20171010 09:45:43: gcars_dlakecapgcrsr: Routed 13048 bytes (compression=89.6%) from ‘gcrsr’ into 1 location.
20171010 09:45:43: gcars_dlakecapgcrsr: Capture cycle 7588.
20171010 04:45:44: gcars_dlakecapgcrsr: Scanned 4 transactions (106288 bytes) from between 1 second and 0 seconds ago containing 16 rows (8 upd) for 2 tables in 1.01 seconds.
20171010 09:45:44: gcars_dlakecapgcrsr: Routed 4520 bytes (compression=94.7%) from ‘gcrsr’ into 1 location.
20171010 09:45:44: gcars_dlakecapgcrsr: Capture cycle 7589.
20171010 04:45:45: gcars_dlakecapgcrsr: Scanned 6 transactions (139104 bytes) from between 1 second and 0 seconds ago containing 28 rows (14 upd) for 2 tables in 1.01 seconds.
20171010 09:45:45: gcars_dlakecapgcrsr: Routed 5252 bytes (compression=96.4%) from ‘gcrsr’ into 1 location.
20171010 09:45:45: gcars_dlakecapgcrsr: Capture cycle 7590.
20171010 04:45:46: gcars_dlakecapgcrsr: Scanned 4 transactions (115920 bytes) from between 1 second and 0 seconds ago containing 16 rows (8 upd) for 2 tables in 1.01 seconds.
20171010 09:45:46: gcars_dlakecapgcrsr: Routed 4490 bytes (compression=94.7%) from ‘gcrsr’ into 1 location.
20171010 09:45:46: gcars_dlakecapgcrsr: Capture cycle 7591.
20171010 04:45:47: gcars_dlakecapgcrsr: Scanned 5 transactions (998000 bytes) from between 1 second and 0 seconds ago containing 26 rows (13 upd) for 4 tables in 1.01 seconds.
20171010 09:45:47: gcars_dlakecapgcrsr: Routed 9038 bytes (compression=91.6%) from ‘gcrsr’ into 1 location.
20171010 09:45:47: gcars_dlakecapgcrsr: Capture cycle 7592.
20171010 04:45:48: gcars_dlakecapgcrsr: Scanned 1 transaction (8410128 bytes) from between 1 second and 0 seconds ago containing 4 rows (2 upd) for 1 table in 1.19 seconds.
20171010 09:45:49: gcars_dlakecapgcrsr: Routed 2808 bytes (compression=87.9%) from ‘gcrsr’ into 1 location.
20171010 09:45:49: gcars_dlakecapgcrsr: Capture cycle 7593.
20171010 04:45:50: gcars_dlakecapgcrsr: Scanned 1 transaction (4143440 bytes) from 1 second ago containing 23919 rows (1 ins, 11959 upd) for 2 tables in 1.31 seconds.
20171010 09:45:50: gcars_dlakecapgcrsr: Routed 322373 bytes (compression=98.3%) from ‘gcrsr’ into 1 location.
20171010 09:45:50: gcars_dlakecapgcrsr: Capture cycle 7594.
20171010 04:45:51: gcars_dlakecapgcrsr: Scanned 1 transaction (885936 bytes) from between 2 seconds and 1 second ago containing 2 rows (1 upd) for 1 table in 1.02 seconds.
20171010 09:45:51: gcars_dlakecapgcrsr: Routed 1191 bytes (compression=68.2%) from ‘gcrsr’ into 1 location.
20171010 09:45:51: gcars_dlakecapgcrsr: Capture cycle 7595.
20171010 04:45:52: gcars_dlakecapgcrsr: Scanned 4 transactions (1926672 bytes) from between 1 second and 0 seconds ago containing 16 rows (8 upd) for 2 tables in 1.02 seconds.
20171010 09:45:52: gcars_dlakecapgcrsr: Routed 4592 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.
20171010 09:45:52: gcars_dlakecapgcrsr: Capture cycle 7596.
20171010 04:45:53: gcars_dlakecapgcrsr: Scanned 3 transactions (795136 bytes) from between 1 second and 0 seconds ago containing 23 rows (1 ins, 11 upd) for 8 tables in 1.01 seconds.
20171010 09:45:53: gcars_dlakecapgcrsr: Routed 12576 bytes (compression=85.6%) from ‘gcrsr’ into 1 location.
20171010 09:45:53: gcars_dlakecapgcrsr: Capture cycle 7597.
20171010 04:45:54: gcars_dlakecapgcrsr: Scanned 6 transactions (563200 bytes) from between 1 second and 0 seconds ago containing 24 rows (12 upd) for 2 tables in 1.02 seconds.
20171010 09:45:54: gcars_dlakecapgcrsr: Routed 5288 bytes (compression=95.7%) from ‘gcrsr’ into 1 location.
20171010 09:45:54: gcars_dlakecapgcrsr: Capture cycle 7598.
20171010 04:45:55: gcars_dlakecapgcrsr: Scanned 7 transactions (237056 bytes) from between 1 second and 0 seconds ago containing 32 rows (16 upd) for 5 tables in 1.01 seconds.
20171010 09:45:55: gcars_dlakecapgcrsr: Routed 10819 bytes (compression=91.9%) from ‘gcrsr’ into 1 location.
20171010 09:45:55: gcars_dlakecapgcrsr: Capture cycle 7599.
20171010 04:45:56: gcars_dlakecapgcrsr: Scanned 5 transactions (143856 bytes) from between 1 second and 0 seconds ago containing 20 rows (10 upd) for 2 tables in 1.01 seconds.
20171010 09:45:56: gcars_dlakecapgcrsr: Routed 4923 bytes (compression=95.3%) from ‘gcrsr’ into 1 location.
20171010 09:45:56: gcars_dlakecapgcrsr: Capture cycle 7600.
20171010 04:45:56: gcars_dlakecapgcrsr: Scanned 3 transactions (101568 bytes) from 0 seconds ago containing 12 rows (6 upd) for 2 tables in 0.51 seconds.
20171010 09:45:57: gcars_dlakecapgcrsr: Routed 4208 bytes (compression=93.4%) from ‘gcrsr’ into 1 location.
20171010 09:45:57: gcars_dlakecapgcrsr: Capture cycle 7601.
20171010 04:45:57: gcars_dlakecapgcrsr: Scanned 6 transactions (542912 bytes) from 0 seconds ago containing 25 rows (1 ins, 12 upd) for 4 tables in 1.01 seconds.
20171010 09:45:58: gcars_dlakecapgcrsr: Routed 6438 bytes (compression=94.3%) from ‘gcrsr’ into 1 location.
20171010 09:45:58: gcars_dlakecapgcrsr: Capture cycle 7602.
20171010 04:45:58: gcars_dlakecapgcrsr: Scanned 9 transactions (234240 bytes) from between 1 second and 0 seconds ago containing 46 rows (23 upd) for 4 tables in 1.01 seconds.
20171010 09:45:59: gcars_dlakecapgcrsr: Routed 12672 bytes (compression=92.6%) from ‘gcrsr’ into 1 location.
20171010 09:45:59: gcars_dlakecapgcrsr: Capture cycle 7603.
20171010 04:46:00: gcars_dlakecapgcrsr: Scanned 15 transactions (239536 bytes) from between 2 seconds and 1 second ago containing 72 rows (36 upd) for 8 tables in 1.02 seconds.
20171010 09:46:00: gcars_dlakecapgcrsr: Routed 19164 bytes (compression=92.1%) from ‘gcrsr’ into 1 location.
20171010 09:46:00: gcars_dlakecapgcrsr: Capture cycle 7604.
20171010 04:46:00: gcars_dlakecapgcrsr: Scanned 8 transactions (147536 bytes) from 0 seconds ago containing 36 rows (18 upd) for 4 tables in 0.51 seconds.
20171010 09:46:00: gcars_dlakecapgcrsr: Routed 10949 bytes (compression=91.0%) from ‘gcrsr’ into 1 location.
20171010 09:46:00: gcars_dlakecapgcrsr: Capture cycle 7605.
20171010 04:46:01: gcars_dlakecapgcrsr: Scanned 6 transactions (446448 bytes) from between 1 second and 0 seconds ago containing 28 rows (14 upd) for 5 tables in 1.01 seconds.
20171010 09:46:01: gcars_dlakecapgcrsr: Routed 10304 bytes (compression=90.8%) from ‘gcrsr’ into 1 location.
20171010 09:46:01: gcars_dlakecapgcrsr: Capture cycle 7606.
20171010 04:46:02: gcars_dlakecapgcrsr: Scanned 6 transactions (95632 bytes) from between 1 second and 0 seconds ago containing 24 rows (12 upd) for 2 tables in 1.01 seconds.
20171010 09:46:02: gcars_dlakecapgcrsr: Routed 5253 bytes (compression=95.7%) from ‘gcrsr’ into 1 location.
20171010 09:46:02: gcars_dlakecapgcrsr: Capture cycle 7607.
20171010 04:46:03: gcars_dlakecapgcrsr: Scanned 8 transactions (96752 bytes) from between 1 second and 0 seconds ago containing 32 rows (16 upd) for 2 tables in 1.01 seconds.
20171010 09:46:03: gcars_dlakecapgcrsr: Routed 5679 bytes (compression=96.5%) from ‘gcrsr’ into 1 location.
20171010 09:46:03: gcars_dlakecapgcrsr: Capture cycle 7608.
20171010 04:46:04: gcars_dlakecapgcrsr: Scanned 6 transactions (270544 bytes) from between 1 second and 0 seconds ago containing 30 rows (15 upd) for 4 tables in 1.01 seconds.
20171010 09:46:04: gcars_dlakecapgcrsr: Routed 9291 bytes (compression=92.6%) from ‘gcrsr’ into 1 location.
20171010 09:46:04: gcars_dlakecapgcrsr: Capture cycle 7609.
20171010 04:46:05: gcars_dlakecapgcrsr: Scanned 6 transactions (559984 bytes) from between 1 second and 0 seconds ago containing 220 rows (110 upd) for 4 tables in 1.02 seconds.
20171010 09:46:05: gcars_dlakecapgcrsr: Routed 20396 bytes (compression=96.6%) from ‘gcrsr’ into 1 location.
20171010 09:46:05: gcars_dlakecapgcrsr: Capture cycle 7610.
20171010 04:46:06: gcars_dlakecapgcrsr: Scanned 6 transactions (89568 bytes) from between 1 second and 0 seconds ago containing 24 rows (12 upd) for 2 tables in 1.01 seconds.
20171010 09:46:06: gcars_dlakecapgcrsr: Routed 5195 bytes (compression=95.8%) from ‘gcrsr’ into 1 location.
20171010 09:46:06: gcars_dlakecapgcrsr: Capture cycle 7611.
20171010 04:46:07: gcars_dlakecapgcrsr: Scanned 4 transactions (62576 bytes) from between 1 second and 0 seconds ago containing 16 rows (8 upd) for 2 tables in 1.01 seconds.
20171010 09:46:07: gcars_dlakecapgcrsr: Routed 4493 bytes (compression=94.7%) from ‘gcrsr’ into 1 location.
20171010 09:46:07: gcars_dlakecapgcrsr: Capture cycle 7612.
20171010 04:46:08: gcars_dlakecapgcrsr: Scanned 7 transactions (308928 bytes) from between 1 second and 0 seconds ago containing 28 rows (14 upd) for 3 tables in 1.01 seconds.
20171010 09:46:09: gcars_dlakecapgcrsr: Routed 6901 bytes (compression=94.9%) from ‘gcrsr’ into 1 location.
20171010 09:46:09: gcars_dlakecapgcrsr: Capture cycle 7613.
20171010 04:46:09: gcars_dlakecapgcrsr: Scanned 6 transactions (90000 bytes) from between 1 second and 0 seconds ago containing 24 rows (12 upd) for 2 tables in 1.01 seconds.
20171010 09:46:10: gcars_dlakecapgcrsr: Routed 5123 bytes (compression=95.9%) from ‘gcrsr’ into 1 location.
20171010 09:46:10: gcars_dlakecapgcrsr: Capture cycle 7614.
20171010 04:46:10: gcars_dlakecapgcrsr: Scanned 6 transactions (164960 bytes) from between 1 second and 0 seconds ago containing 24 rows (12 upd) for 2 tables in 1.01 seconds.
20171010 09:46:11: gcars_dlakecapgcrsr: Routed 5304 bytes (compression=95.7%) from ‘gcrsr’ into 1 location.
20171010 09:46:11: gcars_dlakecapgcrsr: Capture cycle 7615.
20171010 04:46:11: gcars_dlakecapgcrsr: Scanned 8 transactions (183056 bytes) from between 1 second and 0 seconds ago containing 38 rows (19 upd) for 4 tables in 1.01 seconds.
20171010 09:46:12: gcars_dlakecapgcrsr: Routed 10204 bytes (compression=93.8%) from ‘gcrsr’ into 1 location.
20171010 09:46:12: gcars_dlakecapgcrsr: Capture cycle 7616.
20171010 04:46:12: gcars_dlakecapgcrsr: Scanned 4 transactions (2476560 bytes) from between 1 second and 0 seconds ago containing 16 rows (8 upd) for 2 tables in 1.03 seconds.
20171010 09:46:13: gcars_dlakecapgcrsr: Routed 4607 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.
20171010 09:46:13: gcars_dlakecapgcrsr: Capture cycle 7617.
20171010 04:46:15: gcars_dlakecapgcrsr: Scanned 3 transactions (9090064 bytes) from 1 second ago containing 10 rows (5 upd) for 3 tables in 2.05 seconds.
20171010 09:46:15: gcars_dlakecapgcrsr: Routed 5929 bytes (compression=88.8%) from ‘gcrsr’ into 1 location.
20171010 09:46:15: gcars_dlakecapgcrsr: Capture cycle 7618.
20171010 04:46:16: gcars_dlakecapgcrsr: Scanned 4 transactions (258832 bytes) from between 1 second and 0 seconds ago containing 16 rows (8 upd) for 2 tables in 1.01 seconds.
20171010 09:46:16: gcars_dlakecapgcrsr: Routed 4607 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.
20171010 09:46:16: gcars_dlakecapgcrsr: Capture cycle 7619.
20171010 04:46:17: gcars_dlakecapgcrsr: Scanned 4 transactions (86784 bytes) from between 1 second and 0 seconds ago containing 20 rows (10 upd) for 2 tables in 1.01 seconds.
20171010 09:46:17: gcars_dlakecapgcrsr: Routed 4752 bytes (compression=95.5%) from ‘gcrsr’ into 1 location.
20171010 09:46:17: gcars_dlakecapgcrsr: Capture cycle 7620.
20171010 04:46:17: gcars_dlakecapgcrsr: Scanned 2 transactions (64928 bytes) from 0 seconds ago containing 8 rows (4 upd) for 2 tables in 0.51 seconds.
20171010 09:46:17: gcars_dlakecapgcrsr: Routed 3848 bytes (compression=91.5%) from ‘gcrsr’ into 1 location.
20171010 09:46:17: gcars_dlakecapgcrsr: Capture cycle 7621.
20171010 04:46:18: gcars_dlakecapgcrsr: Scanned 5 transactions (150976 bytes) from between 1 second and 0 seconds ago containing 28 rows (14 upd) for 2 tables in 1.01 seconds.
20171010 09:46:18: gcars_dlakecapgcrsr: Routed 5090 bytes (compression=96.5%) from ‘gcrsr’ into 1 location.
20171010 09:46:18: gcars_dlakecapgcrsr: Capture cycle 7622.
20171010 04:46:19: gcars_dlakecapgcrsr: Scanned 5 transactions (144432 bytes) from between 1 second and 0 seconds ago containing 20 rows (10 upd) for 2 tables in 1.01 seconds.
20171010 09:46:19: gcars_dlakecapgcrsr: Routed 5022 bytes (compression=95.1%) from ‘gcrsr’ into 1 location.
20171010 09:46:19: gcars_dlakecapgcrsr: Capture cycle 7623.
20171010 04:46:20: gcars_dlakecapgcrsr: Scanned 7 transactions (129328 bytes) from between 1 second and 0 seconds ago containing 28 rows (14 upd) for 2 tables in 1.01 seconds.
20171010 09:46:20: gcars_dlakecapgcrsr: Routed 5531 bytes (compression=96.2%) from ‘gcrsr’ into 1 location.
20171010 09:46:20: gcars_dlakecapgcrsr: Capture cycle 7624.
20171010 04:46:21: gcars_dlakecapgcrsr: Scanned 7 transactions (146576 bytes) from between 1 second and 0 seconds ago containing 25 rows (1 ins, 12 upd) for 4 tables in 1.01 seconds.
20171010 09:46:21: gcars_dlakecapgcrsr: Routed 6727 bytes (compression=93.9%) from ‘gcrsr’ into 1 location.
20171010 09:46:22: gcars_dlakecapgcrsr: Capture cycle 7625.
20171010 04:46:22: gcars_dlakecapgcrsr: Scanned 6 transactions (108064 bytes) from between 1 second and 0 seconds ago containing 24 rows (12 upd) for 2 tables in 1.01 seconds.
20171010 09:46:23: gcars_dlakecapgcrsr: Routed 5472 bytes (compression=95.6%) from ‘gcrsr’ into 1 location.
20171010 09:46:23: gcars_dlakecapgcrsr: Capture cycle 7626.
20171010 04:46:23: gcars_dlakecapgcrsr: Scanned 7 transactions (105680 bytes) from between 1 second and 0 seconds ago containing 42 rows (2 ins, 20 upd) for 2 tables in 1.01 seconds.
20171010 09:46:24: gcars_dlakecapgcrsr: Routed 6958 bytes (compression=96.8%) from ‘gcrsr’ into 1 location.
20171010 09:46:24: gcars_dlakecapgcrsr: Capture cycle 7627.
20171010 04:46:24: gcars_dlakecapgcrsr: Scanned 5 transactions (84240 bytes) from 0 seconds ago containing 20 rows (10 upd) for 2 tables in 1.01 seconds.
20171010 09:46:25: gcars_dlakecapgcrsr: Routed 4869 bytes (compression=95.3%) from ‘gcrsr’ into 1 location.
20171010 09:46:25: gcars_dlakecapgcrsr: Capture cycle 7628.
20171010 04:46:25: gcars_dlakecapgcrsr: Scanned 3 transactions (42368 bytes) from between 1 second and 0 seconds ago containing 18 rows (9 upd) for 6 tables in 0.51 seconds.
20171010 09:46:25: gcars_dlakecapgcrsr: Routed 8995 bytes (compression=87.2%) from ‘gcrsr’ into 1 location.
20171010 09:46:25: gcars_dlakecapgcrsr: Capture cycle 7629.
20171010 04:46:26: gcars_dlakecapgcrsr: Scanned 10 transactions (902816 bytes) from between 1 second and 0 seconds ago containing 40 rows (20 upd) for 5 tables in 1.02 seconds.
20171010 09:46:26: gcars_dlakecapgcrsr: Routed 11231 bytes (compression=93.3%) from ‘gcrsr’ into 1 location.
20171010 09:46:26: gcars_dlakecapgcrsr: Capture cycle 7630.
20171010 04:46:27: gcars_dlakecapgcrsr: Scanned 6 transactions (690336 bytes) from 0 seconds ago containing 28 rows (14 upd) for 2 tables in 1.51 seconds.
20171010 09:46:28: gcars_dlakecapgcrsr: Routed 5291 bytes (compression=96.3%) from ‘gcrsr’ into 1 location.
20171010 09:46:28: gcars_dlakecapgcrsr: Capture cycle 7631.
20171010 04:46:29: gcars_dlakecapgcrsr: Scanned 4 transactions (67184 bytes) from 1 second ago containing 16 rows (8 upd) for 2 tables in 1.01 seconds.
20171010 09:46:29: gcars_dlakecapgcrsr: Routed 4640 bytes (compression=94.5%) from ‘gcrsr’ into 1 location.
20171010 09:46:29: gcars_dlakecapgcrsr: Capture cycle 7632.
20171010 04:46:30: gcars_dlakecapgcrsr: Scanned 8 transactions (221920 bytes) from between 2 seconds and 1 second ago containing 84 rows (42 upd) for 4 tables in 1.01 seconds.
20171010 09:46:30: gcars_dlakecapgcrsr: Routed 14138 bytes (compression=94.9%) from ‘gcrsr’ into 1 location.
20171010 09:46:30: gcars_dlakecapgcrsr: Capture cycle 7633.
20171010 04:46:31: gcars_dlakecapgcrsr: Scanned 4 transactions (246496 bytes) from 1 second ago containing 16 rows (8 upd) for 2 tables in 1.01 seconds.
20171010 09:46:31: gcars_dlakecapgcrsr: Routed 4685 bytes (compression=94.5%) from ‘gcrsr’ into 1 location.
20171010 09:46:31: gcars_dlakecapgcrsr: Capture cycle 7634.
20171010 04:46:32: gcars_dlakecapgcrsr: Scanned 7 transactions (128400 bytes) from between 2 seconds and 0 seconds ago containing 33 rows (1 ins, 16 upd) for 4 tables in 1.01 seconds.
20171010 09:46:32: gcars_dlakecapgcrsr: Routed 8547 bytes (compression=94.1%) from ‘gcrsr’ into 1 location.
20171010 09:46:32: gcars_dlakecapgcrsr: Capture cycle 7635.
20171010 04:46:33: gcars_dlakecapgcrsr: Scanned 6 transactions (117520 bytes) from between 1 second and 0 seconds ago containing 28 rows (14 upd) for 4 tables in 1.01 seconds.
20171010 09:46:33: gcars_dlakecapgcrsr: Routed 8963 bytes (compression=92.5%) from ‘gcrsr’ into 1 location.
20171010 09:46:33: gcars_dlakecapgcrsr: Capture cycle 7636.
20171010 04:46:34: gcars_dlakecapgcrsr: Scanned 5 transactions (116208 bytes) from between 1 second and 0 seconds ago containing 20 rows (10 upd) for 2 tables in 1.01 seconds.
20171010 09:46:34: gcars_dlakecapgcrsr: Routed 4935 bytes (compression=95.2%) from ‘gcrsr’ into 1 location.
20171010 09:46:34: gcars_dlakecapgcrsr: Capture cycle 7637.
20171010 04:46:35: gcars_dlakecapgcrsr: Scanned 10 transactions (407472 bytes) from between 1 second and 0 seconds ago containing 56 rows (6 ins, 25 upd) for 12 tables in 1.01 seconds.
20171010 09:46:35: gcars_dlakecapgcrsr: Routed 19819 bytes (compression=91.0%) from ‘gcrsr’ into 1 location.
20171010 09:46:35: gcars_dlakecapgcrsr: Capture cycle 7638.
20171010 04:46:36: gcars_dlakecapgcrsr: Scanned 4 transactions (71376 bytes) from between 1 second and 0 seconds ago containing 16 rows (8 upd) for 2 tables in 1.01 seconds.
20171010 09:46:36: gcars_dlakecapgcrsr: Routed 4530 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.
20171010 09:46:36: gcars_dlakecapgcrsr: Capture cycle 7639.
20171010 04:46:37: gcars_dlakecapgcrsr: Scanned 5 transactions (73952 bytes) from between 1 second and 0 seconds ago containing 18 rows (9 upd) for 2 tables in 1.01 seconds.
20171010 09:46:37: gcars_dlakecapgcrsr: Routed 5054 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.
20171010 09:46:37: gcars_dlakecapgcrsr: Capture cycle 7640.
20171010 04:46:38: gcars_dlakecapgcrsr: Scanned 7 transactions (112976 bytes) from between 1 second and 0 seconds ago containing 36 rows (18 upd) for 4 tables in 1.01 seconds.
20171010 09:46:38: gcars_dlakecapgcrsr: Routed 9775 bytes (compression=93.5%) from ‘gcrsr’ into 1 location.
20171010 09:46:38: gcars_dlakecapgcrsr: Capture cycle 7641.
20171010 04:46:39: gcars_dlakecapgcrsr: Scanned 6 transactions (137472 bytes) from between 1 second and 0 seconds ago containing 24 rows (12 upd) for 2 tables in 1.01 seconds.
20171010 09:46:39: gcars_dlakecapgcrsr: Routed 5163 bytes (compression=95.8%) from ‘gcrsr’ into 1 location.
20171010 09:46:39: gcars_dlakecapgcrsr: Capture cycle 7642.
20171010 04:46:40: gcars_dlakecapgcrsr: Scanned 5 transactions (88336 bytes) from between 1 second and 0 seconds ago containing 20 rows (10 upd) for 3 tables in 1.01 seconds.
20171010 09:46:40: gcars_dlakecapgcrsr: Routed 6092 bytes (compression=93.7%) from ‘gcrsr’ into 1 location.
20171010 09:46:40: gcars_dlakecapgcrsr: Capture cycle 7643.
20171010 04:46:41: gcars_dlakecapgcrsr: Scanned 7 transactions (193664 bytes) from between 1 second and 0 seconds ago containing 48 rows (24 upd) for 4 tables in 1.01 seconds.
20171010 09:46:41: gcars_dlakecapgcrsr: Routed 10698 bytes (compression=94.4%) from ‘gcrsr’ into 1 location.
20171010 09:46:41: gcars_dlakecapgcrsr: Capture cycle 7644.
20171010 04:46:42: gcars_dlakecapgcrsr: Scanned 6 transactions (152624 bytes) from between 1 second and 0 seconds ago containing 24 rows (12 upd) for 2 tables in 1.01 seconds.
20171010 09:46:42: gcars_dlakecapgcrsr: Routed 5354 bytes (compression=95.7%) from ‘gcrsr’ into 1 location.
20171010 09:46:42: gcars_dlakecapgcrsr: Capture cycle 7645.
20171010 04:46:43: gcars_dlakecapgcrsr: Scanned 6 transactions (136336 bytes) from between 1 second and 0 seconds ago containing 28 rows (14 upd) for 2 tables in 1.01 seconds.
20171010 09:46:43: gcars_dlakecapgcrsr: Routed 5280 bytes (compression=96.3%) from ‘gcrsr’ into 1 location.
20171010 09:46:43: gcars_dlakecapgcrsr: Capture cycle 7646.
20171010 04:46:43: gcars_dlakecapgcrsr: Scanned 4 transactions (75936 bytes) from 0 seconds ago containing 16 rows (8 upd) for 2 tables in 0.51 seconds.
20171010 09:46:44: gcars_dlakecapgcrsr: Routed 4569 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.
20171010 09:46:44: gcars_dlakecapgcrsr: Capture cycle 7647.
20171010 04:46:44: gcars_dlakecapgcrsr: Scanned 7 transactions (123216 bytes) from 0 seconds ago containing 32 rows (16 upd) for 4 tables in 1.01 seconds.
20171010 09:46:45: gcars_dlakecapgcrsr: Routed 9351 bytes (compression=93.2%) from ‘gcrsr’ into 1 location.
20171010 09:46:45: gcars_dlakecapgcrsr: Capture cycle 7648.
20171010 04:46:46: gcars_dlakecapgcrsr: Scanned 6 transactions (120432 bytes) from 1 second ago containing 28 rows (14 upd) for 2 tables in 1.01 seconds.
20171010 09:46:46: gcars_dlakecapgcrsr: Routed 5521 bytes (compression=96.2%) from ‘gcrsr’ into 1 location.
20171010 09:46:46: gcars_dlakecapgcrsr: Capture cycle 7649.
20171010 04:46:47: gcars_dlakecapgcrsr: Scanned 6 transactions (166720 bytes) from between 2 seconds and 1 second ago containing 24 rows (12 upd) for 2 tables in 1.01 seconds.
20171010 09:46:47: gcars_dlakecapgcrsr: Routed 5157 bytes (compression=95.8%) from ‘gcrsr’ into 1 location.
20171010 09:46:47: gcars_dlakecapgcrsr: Capture cycle 7650.
20171010 04:46:48: gcars_dlakecapgcrsr: Scanned 2 transactions (129168 bytes) from 1 second ago containing 12 rows (6 upd) for 2 tables in 1.01 seconds.
20171010 09:46:48: gcars_dlakecapgcrsr: Routed 3902 bytes (compression=94.1%) from ‘gcrsr’ into 1 location.
20171010 09:46:48: gcars_dlakecapgcrsr: Capture cycle 7651.
20171010 04:46:48: gcars_dlakecapgcrsr: Scanned 2 transactions (62816 bytes) from between 1 second and 0 seconds ago containing 8 rows (4 upd) for 2 tables in 0.51 seconds.
20171010 09:46:48: gcars_dlakecapgcrsr: Routed 3791 bytes (compression=91.7%) from ‘gcrsr’ into 1 location.
20171010 09:46:48: gcars_dlakecapgcrsr: Capture cycle 7652.
20171010 04:46:49: gcars_dlakecapgcrsr: Scanned 6 transactions (97616 bytes) from between 1 second and 0 seconds ago containing 28 rows (14 upd) for 2 tables in 1.01 seconds.
20171010 09:46:49: gcars_dlakecapgcrsr: Routed 5256 bytes (compression=96.4%) from ‘gcrsr’ into 1 location.
20171010 09:46:49: gcars_dlakecapgcrsr: Capture cycle 7653.
20171010 04:46:50: gcars_dlakecapgcrsr: Scanned 6 transactions (84752 bytes) from between 1 second and 0 seconds ago containing 28 rows (14 upd) for 2 tables in 1.01 seconds.
20171010 09:46:50: gcars_dlakecapgcrsr: Routed 5382 bytes (compression=96.3%) from ‘gcrsr’ into 1 location.
20171010 09:46:50: gcars_dlakecapgcrsr: Capture cycle 7654.
20171010 04:46:51: gcars_dlakecapgcrsr: Scanned 4 transactions (3149440 bytes) from between 1 second and 0 seconds ago containing 16 rows (8 upd) for 2 tables in 1.09 seconds.
20171010 09:46:51: gcars_dlakecapgcrsr: Routed 4428 bytes (compression=94.8%) from ‘gcrsr’ into 1 location.
20171010 09:46:51: gcars_dlakecapgcrsr: Capture cycle 7655.
20171010 04:46:55: gcars_dlakecapgcrsr: Scanned 3 transactions (10850736 bytes) from between 1 second and 0 seconds ago containing 23925 rows (1 ins, 11962 upd) for 4 tables in 3.46 seconds.
20171010 09:46:55: gcars_dlakecapgcrsr: Routed 326672 bytes (compression=98.3%) from ‘gcrsr’ into 1 location.
20171010 09:46:55: gcars_dlakecapgcrsr: Capture cycle 7656.
20171010 04:46:56: gcars_dlakecapgcrsr: Scanned 4 transactions (125344 bytes) from between 1 second and 0 seconds ago containing 16 rows (8 upd) for 2 tables in 1.51 seconds.
20171010 09:46:56: gcars_dlakecapgcrsr: Routed 4730 bytes (compression=94.4%) from ‘gcrsr’ into 1 location.
20171010 09:46:56: gcars_dlakecapgcrsr: Capture cycle 7657.
20171010 04:46:57: gcars_dlakecapgcrsr: Scanned 8 transactions (117392 bytes) from between 1 second and 0 seconds ago containing 40 rows (20 upd) for 2 tables in 1.01 seconds.
20171010 09:46:57: gcars_dlakecapgcrsr: Routed 6074 bytes (compression=97.0%) from ‘gcrsr’ into 1 location.
20171010 09:46:58: gcars_dlakecapgcrsr: Capture cycle 7658.
20171010 04:46:58: gcars_dlakecapgcrsr: Scanned 7 transactions (128512 bytes) from between 1 second and 0 seconds ago containing 40 rows (2 ins, 19 upd) for 9 tables in 1.01 seconds.
20171010 09:46:59: gcars_dlakecapgcrsr: Routed 14466 bytes (compression=90.5%) from ‘gcrsr’ into 1 location.
20171010 09:46:59: gcars_dlakecapgcrsr: Capture cycle 7659.
20171010 04:46:59: gcars_dlakecapgcrsr: Scanned 4 transactions (55280 bytes) from between 1 second and 0 seconds ago containing 16 rows (8 upd) for 2 tables in 0.51 seconds.
20171010 09:46:59: gcars_dlakecapgcrsr: Routed 4586 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.
20171010 09:46:59: gcars_dlakecapgcrsr: Capture cycle 7660.
20171010 04:47:00: gcars_dlakecapgcrsr: Scanned 9 transactions (122416 bytes) from between 1 second and 0 seconds ago containing 42 rows (21 upd) for 6 tables in 1.01 seconds.
20171010 09:47:00: gcars_dlakecapgcrsr: Routed 11238 bytes (compression=94.0%) from ‘gcrsr’ into 1 location.
20171010 09:47:00: gcars_dlakecapgcrsr: Capture cycle 7661.
20171010 04:47:01: gcars_dlakecapgcrsr: Scanned 10 transactions (193424 bytes) from between 1 second and 0 seconds ago containing 48 rows (24 upd) for 4 tables in 1.01 seconds.
20171010 09:47:01: gcars_dlakecapgcrsr: Routed 10367 bytes (compression=95.3%) from ‘gcrsr’ into 1 location.
20171010 09:47:01: gcars_dlakecapgcrsr: Capture cycle 7662.
20171010 04:47:01: gcars_dlakecapgcrsr: Scanned 4 transactions (65680 bytes) from 0 seconds ago containing 24 rows (12 upd) for 2 tables in 0.51 seconds.
20171010 09:47:02: gcars_dlakecapgcrsr: Routed 4760 bytes (compression=96.2%) from ‘gcrsr’ into 1 location.
20171010 09:47:02: gcars_dlakecapgcrsr: Capture cycle 7663.
20171010 04:47:03: gcars_dlakecapgcrsr: Scanned 12 transactions (157776 bytes) from between 2 seconds and 1 second ago containing 62 rows (31 upd) for 7 tables in 1.01 seconds.
20171010 09:47:03: gcars_dlakecapgcrsr: Routed 15041 bytes (compression=94.9%) from ‘gcrsr’ into 1 location.
20171010 09:47:03: gcars_dlakecapgcrsr: Capture cycle 7664.
20171010 04:47:04: gcars_dlakecapgcrsr: Scanned 9 transactions (149280 bytes) from between 2 seconds and 1 second ago containing 36 rows (18 upd) for 2 tables in 1.01 seconds.
20171010 09:47:04: gcars_dlakecapgcrsr: Routed 5910 bytes (compression=96.8%) from ‘gcrsr’ into 1 location.
20171010 09:47:04: gcars_dlakecapgcrsr: Capture cycle 7665.
20171010 04:47:05: gcars_dlakecapgcrsr: Scanned 6 transactions (215280 bytes) from between 1 second and 0 seconds ago containing 24 rows (12 upd) for 2 tables in 1.01 seconds.
20171010 09:47:05: gcars_dlakecapgcrsr: Routed 5075 bytes (compression=95.9%) from ‘gcrsr’ into 1 location.
20171010 09:47:05: gcars_dlakecapgcrsr: Capture cycle 7666.
20171010 04:47:06: gcars_dlakecapgcrsr: Scanned 6 transactions (159840 bytes) from 1 second ago containing 24 rows (12 upd) for 3 tables in 1.01 seconds.
20171010 09:47:06: gcars_dlakecapgcrsr: Routed 6535 bytes (compression=94.4%) from ‘gcrsr’ into 1 location.
20171010 09:47:06: gcars_dlakecapgcrsr: Capture cycle 7667.
20171010 04:47:07: gcars_dlakecapgcrsr: Scanned 6 transactions (105728 bytes) from between 2 seconds and 0 seconds ago containing 24 rows (12 upd) for 2 tables in 1.01 seconds.
20171010 09:47:07: gcars_dlakecapgcrsr: Routed 5357 bytes (compression=95.7%) from ‘gcrsr’ into 1 location.
20171010 09:47:07: gcars_dlakecapgcrsr: Capture cycle 7668.
20171010 04:47:07: gcars_dlakecapgcrsr: Scanned 3 transactions (93168 bytes) from 0 seconds ago containing 12 rows (6 upd) for 2 tables in 0.51 seconds.
20171010 09:47:07: gcars_dlakecapgcrsr: Routed 4203 bytes (compression=93.7%) from ‘gcrsr’ into 1 location.
20171010 09:47:07: gcars_dlakecapgcrsr: Capture cycle 7669.
20171010 04:47:08: gcars_dlakecapgcrsr: Scanned 3 transactions (36736 bytes) from between 1 second and 0 seconds ago containing 12 rows (6 upd) for 2 tables in 0.51 seconds.
20171010 09:47:08: gcars_dlakecapgcrsr: Routed 4322 bytes (compression=93.2%) from ‘gcrsr’ into 1 location.
20171010 09:47:08: gcars_dlakecapgcrsr: Capture cycle 7670.
20171010 04:47:09: gcars_dlakecapgcrsr: Scanned 7 transactions (103824 bytes) from between 1 second and 0 seconds ago containing 28 rows (14 upd) for 2 tables in 1.01 seconds.
20171010 09:47:09: gcars_dlakecapgcrsr: Routed 5442 bytes (compression=96.2%) from ‘gcrsr’ into 1 location.
20171010 09:47:09: gcars_dlakecapgcrsr: Capture cycle 7671.
20171010 04:47:10: gcars_dlakecapgcrsr: Scanned 5 transactions (119648 bytes) from between 1 second and 0 seconds ago containing 28 rows (14 upd) for 2 tables in 1.01 seconds.
20171010 09:47:10: gcars_dlakecapgcrsr: Routed 4946 bytes (compression=96.6%) from ‘gcrsr’ into 1 location.
20171010 09:47:10: gcars_dlakecapgcrsr: Capture cycle 7672.
20171010 04:47:11: gcars_dlakecapgcrsr: Scanned 7 transactions (117024 bytes) from between 1 second and 0 seconds ago containing 43 rows (1 ins, 21 upd) for 6 tables in 1.01 seconds.
20171010 09:47:11: gcars_dlakecapgcrsr: Routed 10874 bytes (compression=95.8%) from ‘gcrsr’ into 1 location.
20171010 09:47:11: gcars_dlakecapgcrsr: Capture cycle 7673.
20171010 04:47:12: gcars_dlakecapgcrsr: Scanned 6 transactions (85744 bytes) from between 1 second and 0 seconds ago containing 36 rows (18 upd) for 3 tables in 1.01 seconds.
20171010 09:47:12: gcars_dlakecapgcrsr: Routed 6722 bytes (compression=96.3%) from ‘gcrsr’ into 1 location.
20171010 09:47:12: gcars_dlakecapgcrsr: Capture cycle 7674.
20171010 04:47:13: gcars_dlakecapgcrsr: Scanned 5 transactions (81648 bytes) from between 1 second and 0 seconds ago containing 28 rows (14 upd) for 2 tables in 1.01 seconds.
20171010 09:47:13: gcars_dlakecapgcrsr: Routed 4916 bytes (compression=96.6%) from ‘gcrsr’ into 1 location.
20171010 09:47:13: gcars_dlakecapgcrsr: Capture cycle 7675.
20171010 04:47:14: gcars_dlakecapgcrsr: Scanned 4 transactions (105616 bytes) from between 1 second and 0 seconds ago containing 24 rows (12 upd) for 2 tables in 1.01 seconds.
20171010 09:47:14: gcars_dlakecapgcrsr: Routed 4656 bytes (compression=96.3%) from ‘gcrsr’ into 1 location.
20171010 09:47:14: gcars_dlakecapgcrsr: Capture cycle 7676.
20171010 04:47:15: gcars_dlakecapgcrsr: Scanned 9 transactions (382640 bytes) from between 1 second and 0 seconds ago containing 168 rows (84 upd) for 6 tables in 1.02 seconds.
20171010 09:47:15: gcars_dlakecapgcrsr: Routed 23132 bytes (compression=95.1%) from ‘gcrsr’ into 1 location.
20171010 09:47:15: gcars_dlakecapgcrsr: Capture cycle 7677.
October 10, 2017 at 4:37 am #11340Erik van VeenKeymasterHello Ayush,
this issue is probably more effectively dealt with through a support ticket. Can you (or one of your colleagues) open a ticket (under ‘Support and Services’ > ‘Customer Services’ > ‘Support Portal’) ?
Regards, Erik
October 11, 2017 at 9:34 pm #11460AnonymousInactiveHi Erik,
Thanks for your help on the above problem. My team will be raising a ticket. Meanwhile, I had other query. I see that Integration is trying to write from a file of 1 GB. How come we get a file so big while others files are just ~10 MB.
Thanks,Ayush
October 11, 2017 at 10:20 pm #11461MarkKeymasterAyush,
Do you mean integrate is writing a 1 GB file that will be consumed through gpfdist into Greenplum?
Or do you refer to a transaction file even though it is capture writing this file and not integrate?
Let’s start with the last scenario first: HVR writes transaction files containing one or more transactions. Transactions do not span transaction files. So if you see a large transaction file then generally that means a very large transaction was processed on the source system and lots of changes were relevant to your channel definition.
On the integrate side, when Greenplum is the target, HVR will write coalesced delimited files for Greenplum to consume. The size of the files is determined by the number of row changes per table. By default HVR will process up to 10 MB of (densely compressed) transaction files per cycle, but for for a target like Greenplum it generally makes sense to set /CycleByteLimit to either a high value, or 0, to take most if not all of the outstanding transaction files in a single cycle (to increase the efficiency of the apply i.e. increase the average number of rows per second processed). So when there are many outstanding transaction files and/or the bulk of the row changes are hitting a single table then you may temporarily see large files. HVR will automatically clean up the files again though.
Hope this helps.
Mark.
October 12, 2017 at 3:12 am #11462AnonymousInactiveHi Mark,
Thanks for your input. This is the Integration log line
20171012 00:38:48: gecars_allinteggcrtr: Integrate cycle 1.121 for 1 transaction file (1082884736 bytes).
Also, this if Integrating into Oracle.
ThanksOctober 12, 2017 at 7:59 am #11463MarkKeymasterThis is most likely the result of a very large transaction in a single file.
Mark.

AuthorPosts
 You must be logged in to reply to this topic.