Home Topics HVR Real-time 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.

2017-10-10 09:45:12: gcars_dlake-cap-gcrsr: Capture cycle 7554.

2017-10-10 04:45:12: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:12: gcars_dlake-cap-gcrsr: Routed 4728 bytes (compression=95.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:12: gcars_dlake-cap-gcrsr: Capture cycle 7555.

2017-10-10 04:45:12: gcars_dlake-cap-gcrsr: Scanned 3 transactions (42896 bytes) from 0 seconds ago containing 12 rows (6 upd) for 2 tables in 0.51 seconds.

2017-10-10 09:45:13: gcars_dlake-cap-gcrsr: Routed 4169 bytes (compression=93.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:13: gcars_dlake-cap-gcrsr: Capture cycle 7556.

2017-10-10 04:45:13: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:14: gcars_dlake-cap-gcrsr: Routed 4934 bytes (compression=95.2%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:14: gcars_dlake-cap-gcrsr: Capture cycle 7557.

2017-10-10 04:45:14: gcars_dlake-cap-gcrsr: Scanned 5 transactions (85232 bytes) from 0 seconds ago containing 20 rows (10 upd) for 2 tables in 1.01 seconds.

2017-10-10 09:45:15: gcars_dlake-cap-gcrsr: Routed 4895 bytes (compression=95.4%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:15: gcars_dlake-cap-gcrsr: Capture cycle 7558.

2017-10-10 04:45:16: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:16: gcars_dlake-cap-gcrsr: Routed 4829 bytes (compression=95.3%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:16: gcars_dlake-cap-gcrsr: Capture cycle 7559.

2017-10-10 04:45:17: gcars_dlake-cap-gcrsr: Scanned 4 transactions (85232 bytes) from 1 second ago containing 16 rows (8 upd) for 2 tables in 1.01 seconds.

2017-10-10 09:45:17: gcars_dlake-cap-gcrsr: Routed 4571 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:17: gcars_dlake-cap-gcrsr: Capture cycle 7560.

2017-10-10 04:45:18: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:18: gcars_dlake-cap-gcrsr: Routed 5165 bytes (compression=95.8%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:18: gcars_dlake-cap-gcrsr: Capture cycle 7561.

2017-10-10 04:45:19: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:19: gcars_dlake-cap-gcrsr: Routed 5416 bytes (compression=96.2%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:19: gcars_dlake-cap-gcrsr: Capture cycle 7562.

2017-10-10 04:45:19: gcars_dlake-cap-gcrsr: Scanned 6 transactions (80576 bytes) from 0 seconds ago containing 30 rows (15 upd) for 4 tables in 0.51 seconds.

2017-10-10 09:45:19: gcars_dlake-cap-gcrsr: Routed 9251 bytes (compression=92.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:19: gcars_dlake-cap-gcrsr: Capture cycle 7563.

2017-10-10 04:45:20: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:20: gcars_dlake-cap-gcrsr: Routed 5025 bytes (compression=95.1%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:20: gcars_dlake-cap-gcrsr: Capture cycle 7564.

2017-10-10 04:45:21: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:21: gcars_dlake-cap-gcrsr: Routed 4538 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:21: gcars_dlake-cap-gcrsr: Capture cycle 7565.

2017-10-10 04:45:22: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:22: gcars_dlake-cap-gcrsr: Routed 5490 bytes (compression=96.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:22: gcars_dlake-cap-gcrsr: Capture cycle 7566.

2017-10-10 04:45:23: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:23: gcars_dlake-cap-gcrsr: Routed 4745 bytes (compression=95.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:23: gcars_dlake-cap-gcrsr: Capture cycle 7567.

2017-10-10 04:45:24: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:25: gcars_dlake-cap-gcrsr: Routed 6394 bytes (compression=82.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:25: gcars_dlake-cap-gcrsr: Capture cycle 7568.

2017-10-10 04:45:25: gcars_dlake-cap-gcrsr: Scanned 5 transactions (105312 bytes) from 0 seconds ago containing 22 rows (11 upd) for 5 tables in 1.01 seconds.

2017-10-10 09:45:26: gcars_dlake-cap-gcrsr: Routed 9671 bytes (compression=93.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:26: gcars_dlake-cap-gcrsr: Capture cycle 7569.

2017-10-10 04:45:26: gcars_dlake-cap-gcrsr: Scanned 4 transactions (76896 bytes) from 0 seconds ago containing 15 rows (1 ins, 7 upd) for 4 tables in 1.01 seconds.

2017-10-10 09:45:27: gcars_dlake-cap-gcrsr: Routed 5960 bytes (compression=91.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:27: gcars_dlake-cap-gcrsr: Capture cycle 7570.

2017-10-10 04:45:27: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:28: gcars_dlake-cap-gcrsr: Routed 4236 bytes (compression=93.4%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:28: gcars_dlake-cap-gcrsr: Capture cycle 7571.

2017-10-10 04:45:28: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:28: gcars_dlake-cap-gcrsr: Routed 4107 bytes (compression=93.8%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:28: gcars_dlake-cap-gcrsr: Capture cycle 7572.

2017-10-10 04:45:29: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:29: gcars_dlake-cap-gcrsr: Routed 5408 bytes (compression=96.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:29: gcars_dlake-cap-gcrsr: Capture cycle 7573.

2017-10-10 04:45:30: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:30: gcars_dlake-cap-gcrsr: Routed 5009 bytes (compression=95.1%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:30: gcars_dlake-cap-gcrsr: Capture cycle 7574.

2017-10-10 04:45:31: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:31: gcars_dlake-cap-gcrsr: Routed 11891 bytes (compression=94.2%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:31: gcars_dlake-cap-gcrsr: Capture cycle 7575.

2017-10-10 04:45:32: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:32: gcars_dlake-cap-gcrsr: Routed 8943 bytes (compression=92.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:32: gcars_dlake-cap-gcrsr: Capture cycle 7576.

2017-10-10 04:45:33: gcars_dlake-cap-gcrsr: Scanned 2 transactions (88352 bytes) from 1 second ago containing 8 rows (4 upd) for 2 tables in 0.51 seconds.

2017-10-10 09:45:33: gcars_dlake-cap-gcrsr: Routed 3879 bytes (compression=91.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:33: gcars_dlake-cap-gcrsr: Capture cycle 7577.

2017-10-10 04:45:33: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:33: gcars_dlake-cap-gcrsr: Routed 4676 bytes (compression=94.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:33: gcars_dlake-cap-gcrsr: Capture cycle 7578.

2017-10-10 04:45:34: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:34: gcars_dlake-cap-gcrsr: Routed 9730 bytes (compression=91.1%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:34: gcars_dlake-cap-gcrsr: Capture cycle 7579.

2017-10-10 04:45:35: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:35: gcars_dlake-cap-gcrsr: Routed 9251 bytes (compression=93.4%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:35: gcars_dlake-cap-gcrsr: Capture cycle 7580.

2017-10-10 04:45:36: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:36: gcars_dlake-cap-gcrsr: Routed 7500 bytes (compression=94.3%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:36: gcars_dlake-cap-gcrsr: Capture cycle 7581.

2017-10-10 04:45:37: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:37: gcars_dlake-cap-gcrsr: Routed 4749 bytes (compression=95.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:37: gcars_dlake-cap-gcrsr: Capture cycle 7582.

2017-10-10 04:45:38: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:38: gcars_dlake-cap-gcrsr: Routed 16384 bytes (compression=94.8%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:39: gcars_dlake-cap-gcrsr: Capture cycle 7583.

2017-10-10 04:45:39: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:40: gcars_dlake-cap-gcrsr: Routed 9540 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:40: gcars_dlake-cap-gcrsr: Capture cycle 7584.

2017-10-10 04:45:40: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:41: gcars_dlake-cap-gcrsr: Routed 9265 bytes (compression=93.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:41: gcars_dlake-cap-gcrsr: Capture cycle 7585.

2017-10-10 04:45:41: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:42: gcars_dlake-cap-gcrsr: Routed 6062 bytes (compression=93.8%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:42: gcars_dlake-cap-gcrsr: Capture cycle 7586.

2017-10-10 04:45:42: gcars_dlake-cap-gcrsr: Scanned 6 transactions (124736 bytes) from 0 seconds ago containing 26 rows (13 upd) for 2 tables in 1.01 seconds.

2017-10-10 09:45:43: gcars_dlake-cap-gcrsr: Routed 6150 bytes (compression=95.4%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:43: gcars_dlake-cap-gcrsr: Capture cycle 7587.

2017-10-10 04:45:43: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:43: gcars_dlake-cap-gcrsr: Routed 13048 bytes (compression=89.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:43: gcars_dlake-cap-gcrsr: Capture cycle 7588.

2017-10-10 04:45:44: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:44: gcars_dlake-cap-gcrsr: Routed 4520 bytes (compression=94.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:44: gcars_dlake-cap-gcrsr: Capture cycle 7589.

2017-10-10 04:45:45: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:45: gcars_dlake-cap-gcrsr: Routed 5252 bytes (compression=96.4%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:45: gcars_dlake-cap-gcrsr: Capture cycle 7590.

2017-10-10 04:45:46: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:46: gcars_dlake-cap-gcrsr: Routed 4490 bytes (compression=94.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:46: gcars_dlake-cap-gcrsr: Capture cycle 7591.

2017-10-10 04:45:47: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:47: gcars_dlake-cap-gcrsr: Routed 9038 bytes (compression=91.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:47: gcars_dlake-cap-gcrsr: Capture cycle 7592.

2017-10-10 04:45:48: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:49: gcars_dlake-cap-gcrsr: Routed 2808 bytes (compression=87.9%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:49: gcars_dlake-cap-gcrsr: Capture cycle 7593.

2017-10-10 04:45:50: gcars_dlake-cap-gcrsr: Scanned 1 transaction (4143440 bytes) from 1 second ago containing 23919 rows (1 ins, 11959 upd) for 2 tables in 1.31 seconds.

2017-10-10 09:45:50: gcars_dlake-cap-gcrsr: Routed 322373 bytes (compression=98.3%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:50: gcars_dlake-cap-gcrsr: Capture cycle 7594.

2017-10-10 04:45:51: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:51: gcars_dlake-cap-gcrsr: Routed 1191 bytes (compression=68.2%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:51: gcars_dlake-cap-gcrsr: Capture cycle 7595.

2017-10-10 04:45:52: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:52: gcars_dlake-cap-gcrsr: Routed 4592 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:52: gcars_dlake-cap-gcrsr: Capture cycle 7596.

2017-10-10 04:45:53: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:53: gcars_dlake-cap-gcrsr: Routed 12576 bytes (compression=85.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:53: gcars_dlake-cap-gcrsr: Capture cycle 7597.

2017-10-10 04:45:54: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:54: gcars_dlake-cap-gcrsr: Routed 5288 bytes (compression=95.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:54: gcars_dlake-cap-gcrsr: Capture cycle 7598.

2017-10-10 04:45:55: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:55: gcars_dlake-cap-gcrsr: Routed 10819 bytes (compression=91.9%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:55: gcars_dlake-cap-gcrsr: Capture cycle 7599.

2017-10-10 04:45:56: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:56: gcars_dlake-cap-gcrsr: Routed 4923 bytes (compression=95.3%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:56: gcars_dlake-cap-gcrsr: Capture cycle 7600.

2017-10-10 04:45:56: gcars_dlake-cap-gcrsr: Scanned 3 transactions (101568 bytes) from 0 seconds ago containing 12 rows (6 upd) for 2 tables in 0.51 seconds.

2017-10-10 09:45:57: gcars_dlake-cap-gcrsr: Routed 4208 bytes (compression=93.4%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:57: gcars_dlake-cap-gcrsr: Capture cycle 7601.

2017-10-10 04:45:57: gcars_dlake-cap-gcrsr: Scanned 6 transactions (542912 bytes) from 0 seconds ago containing 25 rows (1 ins, 12 upd) for 4 tables in 1.01 seconds.

2017-10-10 09:45:58: gcars_dlake-cap-gcrsr: Routed 6438 bytes (compression=94.3%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:58: gcars_dlake-cap-gcrsr: Capture cycle 7602.

2017-10-10 04:45:58: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:45:59: gcars_dlake-cap-gcrsr: Routed 12672 bytes (compression=92.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:45:59: gcars_dlake-cap-gcrsr: Capture cycle 7603.

2017-10-10 04:46:00: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:00: gcars_dlake-cap-gcrsr: Routed 19164 bytes (compression=92.1%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:00: gcars_dlake-cap-gcrsr: Capture cycle 7604.

2017-10-10 04:46:00: gcars_dlake-cap-gcrsr: Scanned 8 transactions (147536 bytes) from 0 seconds ago containing 36 rows (18 upd) for 4 tables in 0.51 seconds.

2017-10-10 09:46:00: gcars_dlake-cap-gcrsr: Routed 10949 bytes (compression=91.0%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:00: gcars_dlake-cap-gcrsr: Capture cycle 7605.

2017-10-10 04:46:01: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:01: gcars_dlake-cap-gcrsr: Routed 10304 bytes (compression=90.8%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:01: gcars_dlake-cap-gcrsr: Capture cycle 7606.

2017-10-10 04:46:02: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:02: gcars_dlake-cap-gcrsr: Routed 5253 bytes (compression=95.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:02: gcars_dlake-cap-gcrsr: Capture cycle 7607.

2017-10-10 04:46:03: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:03: gcars_dlake-cap-gcrsr: Routed 5679 bytes (compression=96.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:03: gcars_dlake-cap-gcrsr: Capture cycle 7608.

2017-10-10 04:46:04: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:04: gcars_dlake-cap-gcrsr: Routed 9291 bytes (compression=92.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:04: gcars_dlake-cap-gcrsr: Capture cycle 7609.

2017-10-10 04:46:05: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:05: gcars_dlake-cap-gcrsr: Routed 20396 bytes (compression=96.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:05: gcars_dlake-cap-gcrsr: Capture cycle 7610.

2017-10-10 04:46:06: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:06: gcars_dlake-cap-gcrsr: Routed 5195 bytes (compression=95.8%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:06: gcars_dlake-cap-gcrsr: Capture cycle 7611.

2017-10-10 04:46:07: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:07: gcars_dlake-cap-gcrsr: Routed 4493 bytes (compression=94.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:07: gcars_dlake-cap-gcrsr: Capture cycle 7612.

2017-10-10 04:46:08: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:09: gcars_dlake-cap-gcrsr: Routed 6901 bytes (compression=94.9%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:09: gcars_dlake-cap-gcrsr: Capture cycle 7613.

2017-10-10 04:46:09: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:10: gcars_dlake-cap-gcrsr: Routed 5123 bytes (compression=95.9%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:10: gcars_dlake-cap-gcrsr: Capture cycle 7614.

2017-10-10 04:46:10: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:11: gcars_dlake-cap-gcrsr: Routed 5304 bytes (compression=95.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:11: gcars_dlake-cap-gcrsr: Capture cycle 7615.

2017-10-10 04:46:11: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:12: gcars_dlake-cap-gcrsr: Routed 10204 bytes (compression=93.8%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:12: gcars_dlake-cap-gcrsr: Capture cycle 7616.

2017-10-10 04:46:12: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:13: gcars_dlake-cap-gcrsr: Routed 4607 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:13: gcars_dlake-cap-gcrsr: Capture cycle 7617.

2017-10-10 04:46:15: gcars_dlake-cap-gcrsr: Scanned 3 transactions (9090064 bytes) from 1 second ago containing 10 rows (5 upd) for 3 tables in 2.05 seconds.

2017-10-10 09:46:15: gcars_dlake-cap-gcrsr: Routed 5929 bytes (compression=88.8%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:15: gcars_dlake-cap-gcrsr: Capture cycle 7618.

2017-10-10 04:46:16: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:16: gcars_dlake-cap-gcrsr: Routed 4607 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:16: gcars_dlake-cap-gcrsr: Capture cycle 7619.

2017-10-10 04:46:17: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:17: gcars_dlake-cap-gcrsr: Routed 4752 bytes (compression=95.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:17: gcars_dlake-cap-gcrsr: Capture cycle 7620.

2017-10-10 04:46:17: gcars_dlake-cap-gcrsr: Scanned 2 transactions (64928 bytes) from 0 seconds ago containing 8 rows (4 upd) for 2 tables in 0.51 seconds.

2017-10-10 09:46:17: gcars_dlake-cap-gcrsr: Routed 3848 bytes (compression=91.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:17: gcars_dlake-cap-gcrsr: Capture cycle 7621.

2017-10-10 04:46:18: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:18: gcars_dlake-cap-gcrsr: Routed 5090 bytes (compression=96.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:18: gcars_dlake-cap-gcrsr: Capture cycle 7622.

2017-10-10 04:46:19: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:19: gcars_dlake-cap-gcrsr: Routed 5022 bytes (compression=95.1%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:19: gcars_dlake-cap-gcrsr: Capture cycle 7623.

2017-10-10 04:46:20: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:20: gcars_dlake-cap-gcrsr: Routed 5531 bytes (compression=96.2%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:20: gcars_dlake-cap-gcrsr: Capture cycle 7624.

2017-10-10 04:46:21: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:21: gcars_dlake-cap-gcrsr: Routed 6727 bytes (compression=93.9%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:22: gcars_dlake-cap-gcrsr: Capture cycle 7625.

2017-10-10 04:46:22: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:23: gcars_dlake-cap-gcrsr: Routed 5472 bytes (compression=95.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:23: gcars_dlake-cap-gcrsr: Capture cycle 7626.

2017-10-10 04:46:23: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:24: gcars_dlake-cap-gcrsr: Routed 6958 bytes (compression=96.8%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:24: gcars_dlake-cap-gcrsr: Capture cycle 7627.

2017-10-10 04:46:24: gcars_dlake-cap-gcrsr: Scanned 5 transactions (84240 bytes) from 0 seconds ago containing 20 rows (10 upd) for 2 tables in 1.01 seconds.

2017-10-10 09:46:25: gcars_dlake-cap-gcrsr: Routed 4869 bytes (compression=95.3%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:25: gcars_dlake-cap-gcrsr: Capture cycle 7628.

2017-10-10 04:46:25: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:25: gcars_dlake-cap-gcrsr: Routed 8995 bytes (compression=87.2%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:25: gcars_dlake-cap-gcrsr: Capture cycle 7629.

2017-10-10 04:46:26: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:26: gcars_dlake-cap-gcrsr: Routed 11231 bytes (compression=93.3%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:26: gcars_dlake-cap-gcrsr: Capture cycle 7630.

2017-10-10 04:46:27: gcars_dlake-cap-gcrsr: Scanned 6 transactions (690336 bytes) from 0 seconds ago containing 28 rows (14 upd) for 2 tables in 1.51 seconds.

2017-10-10 09:46:28: gcars_dlake-cap-gcrsr: Routed 5291 bytes (compression=96.3%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:28: gcars_dlake-cap-gcrsr: Capture cycle 7631.

2017-10-10 04:46:29: gcars_dlake-cap-gcrsr: Scanned 4 transactions (67184 bytes) from 1 second ago containing 16 rows (8 upd) for 2 tables in 1.01 seconds.

2017-10-10 09:46:29: gcars_dlake-cap-gcrsr: Routed 4640 bytes (compression=94.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:29: gcars_dlake-cap-gcrsr: Capture cycle 7632.

2017-10-10 04:46:30: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:30: gcars_dlake-cap-gcrsr: Routed 14138 bytes (compression=94.9%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:30: gcars_dlake-cap-gcrsr: Capture cycle 7633.

2017-10-10 04:46:31: gcars_dlake-cap-gcrsr: Scanned 4 transactions (246496 bytes) from 1 second ago containing 16 rows (8 upd) for 2 tables in 1.01 seconds.

2017-10-10 09:46:31: gcars_dlake-cap-gcrsr: Routed 4685 bytes (compression=94.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:31: gcars_dlake-cap-gcrsr: Capture cycle 7634.

2017-10-10 04:46:32: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:32: gcars_dlake-cap-gcrsr: Routed 8547 bytes (compression=94.1%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:32: gcars_dlake-cap-gcrsr: Capture cycle 7635.

2017-10-10 04:46:33: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:33: gcars_dlake-cap-gcrsr: Routed 8963 bytes (compression=92.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:33: gcars_dlake-cap-gcrsr: Capture cycle 7636.

2017-10-10 04:46:34: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:34: gcars_dlake-cap-gcrsr: Routed 4935 bytes (compression=95.2%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:34: gcars_dlake-cap-gcrsr: Capture cycle 7637.

2017-10-10 04:46:35: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:35: gcars_dlake-cap-gcrsr: Routed 19819 bytes (compression=91.0%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:35: gcars_dlake-cap-gcrsr: Capture cycle 7638.

2017-10-10 04:46:36: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:36: gcars_dlake-cap-gcrsr: Routed 4530 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:36: gcars_dlake-cap-gcrsr: Capture cycle 7639.

2017-10-10 04:46:37: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:37: gcars_dlake-cap-gcrsr: Routed 5054 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:37: gcars_dlake-cap-gcrsr: Capture cycle 7640.

2017-10-10 04:46:38: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:38: gcars_dlake-cap-gcrsr: Routed 9775 bytes (compression=93.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:38: gcars_dlake-cap-gcrsr: Capture cycle 7641.

2017-10-10 04:46:39: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:39: gcars_dlake-cap-gcrsr: Routed 5163 bytes (compression=95.8%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:39: gcars_dlake-cap-gcrsr: Capture cycle 7642.

2017-10-10 04:46:40: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:40: gcars_dlake-cap-gcrsr: Routed 6092 bytes (compression=93.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:40: gcars_dlake-cap-gcrsr: Capture cycle 7643.

2017-10-10 04:46:41: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:41: gcars_dlake-cap-gcrsr: Routed 10698 bytes (compression=94.4%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:41: gcars_dlake-cap-gcrsr: Capture cycle 7644.

2017-10-10 04:46:42: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:42: gcars_dlake-cap-gcrsr: Routed 5354 bytes (compression=95.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:42: gcars_dlake-cap-gcrsr: Capture cycle 7645.

2017-10-10 04:46:43: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:43: gcars_dlake-cap-gcrsr: Routed 5280 bytes (compression=96.3%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:43: gcars_dlake-cap-gcrsr: Capture cycle 7646.

2017-10-10 04:46:43: gcars_dlake-cap-gcrsr: Scanned 4 transactions (75936 bytes) from 0 seconds ago containing 16 rows (8 upd) for 2 tables in 0.51 seconds.

2017-10-10 09:46:44: gcars_dlake-cap-gcrsr: Routed 4569 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:44: gcars_dlake-cap-gcrsr: Capture cycle 7647.

2017-10-10 04:46:44: gcars_dlake-cap-gcrsr: Scanned 7 transactions (123216 bytes) from 0 seconds ago containing 32 rows (16 upd) for 4 tables in 1.01 seconds.

2017-10-10 09:46:45: gcars_dlake-cap-gcrsr: Routed 9351 bytes (compression=93.2%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:45: gcars_dlake-cap-gcrsr: Capture cycle 7648.

2017-10-10 04:46:46: gcars_dlake-cap-gcrsr: Scanned 6 transactions (120432 bytes) from 1 second ago containing 28 rows (14 upd) for 2 tables in 1.01 seconds.

2017-10-10 09:46:46: gcars_dlake-cap-gcrsr: Routed 5521 bytes (compression=96.2%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:46: gcars_dlake-cap-gcrsr: Capture cycle 7649.

2017-10-10 04:46:47: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:47: gcars_dlake-cap-gcrsr: Routed 5157 bytes (compression=95.8%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:47: gcars_dlake-cap-gcrsr: Capture cycle 7650.

2017-10-10 04:46:48: gcars_dlake-cap-gcrsr: Scanned 2 transactions (129168 bytes) from 1 second ago containing 12 rows (6 upd) for 2 tables in 1.01 seconds.

2017-10-10 09:46:48: gcars_dlake-cap-gcrsr: Routed 3902 bytes (compression=94.1%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:48: gcars_dlake-cap-gcrsr: Capture cycle 7651.

2017-10-10 04:46:48: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:48: gcars_dlake-cap-gcrsr: Routed 3791 bytes (compression=91.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:48: gcars_dlake-cap-gcrsr: Capture cycle 7652.

2017-10-10 04:46:49: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:49: gcars_dlake-cap-gcrsr: Routed 5256 bytes (compression=96.4%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:49: gcars_dlake-cap-gcrsr: Capture cycle 7653.

2017-10-10 04:46:50: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:50: gcars_dlake-cap-gcrsr: Routed 5382 bytes (compression=96.3%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:50: gcars_dlake-cap-gcrsr: Capture cycle 7654.

2017-10-10 04:46:51: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:51: gcars_dlake-cap-gcrsr: Routed 4428 bytes (compression=94.8%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:51: gcars_dlake-cap-gcrsr: Capture cycle 7655.

2017-10-10 04:46:55: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:55: gcars_dlake-cap-gcrsr: Routed 326672 bytes (compression=98.3%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:55: gcars_dlake-cap-gcrsr: Capture cycle 7656.

2017-10-10 04:46:56: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:56: gcars_dlake-cap-gcrsr: Routed 4730 bytes (compression=94.4%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:56: gcars_dlake-cap-gcrsr: Capture cycle 7657.

2017-10-10 04:46:57: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:57: gcars_dlake-cap-gcrsr: Routed 6074 bytes (compression=97.0%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:58: gcars_dlake-cap-gcrsr: Capture cycle 7658.

2017-10-10 04:46:58: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:59: gcars_dlake-cap-gcrsr: Routed 14466 bytes (compression=90.5%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:59: gcars_dlake-cap-gcrsr: Capture cycle 7659.

2017-10-10 04:46:59: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:46:59: gcars_dlake-cap-gcrsr: Routed 4586 bytes (compression=94.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:46:59: gcars_dlake-cap-gcrsr: Capture cycle 7660.

2017-10-10 04:47:00: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:47:00: gcars_dlake-cap-gcrsr: Routed 11238 bytes (compression=94.0%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:00: gcars_dlake-cap-gcrsr: Capture cycle 7661.

2017-10-10 04:47:01: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:47:01: gcars_dlake-cap-gcrsr: Routed 10367 bytes (compression=95.3%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:01: gcars_dlake-cap-gcrsr: Capture cycle 7662.

2017-10-10 04:47:01: gcars_dlake-cap-gcrsr: Scanned 4 transactions (65680 bytes) from 0 seconds ago containing 24 rows (12 upd) for 2 tables in 0.51 seconds.

2017-10-10 09:47:02: gcars_dlake-cap-gcrsr: Routed 4760 bytes (compression=96.2%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:02: gcars_dlake-cap-gcrsr: Capture cycle 7663.

2017-10-10 04:47:03: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:47:03: gcars_dlake-cap-gcrsr: Routed 15041 bytes (compression=94.9%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:03: gcars_dlake-cap-gcrsr: Capture cycle 7664.

2017-10-10 04:47:04: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:47:04: gcars_dlake-cap-gcrsr: Routed 5910 bytes (compression=96.8%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:04: gcars_dlake-cap-gcrsr: Capture cycle 7665.

2017-10-10 04:47:05: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:47:05: gcars_dlake-cap-gcrsr: Routed 5075 bytes (compression=95.9%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:05: gcars_dlake-cap-gcrsr: Capture cycle 7666.

2017-10-10 04:47:06: gcars_dlake-cap-gcrsr: Scanned 6 transactions (159840 bytes) from 1 second ago containing 24 rows (12 upd) for 3 tables in 1.01 seconds.

2017-10-10 09:47:06: gcars_dlake-cap-gcrsr: Routed 6535 bytes (compression=94.4%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:06: gcars_dlake-cap-gcrsr: Capture cycle 7667.

2017-10-10 04:47:07: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:47:07: gcars_dlake-cap-gcrsr: Routed 5357 bytes (compression=95.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:07: gcars_dlake-cap-gcrsr: Capture cycle 7668.

2017-10-10 04:47:07: gcars_dlake-cap-gcrsr: Scanned 3 transactions (93168 bytes) from 0 seconds ago containing 12 rows (6 upd) for 2 tables in 0.51 seconds.

2017-10-10 09:47:07: gcars_dlake-cap-gcrsr: Routed 4203 bytes (compression=93.7%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:07: gcars_dlake-cap-gcrsr: Capture cycle 7669.

2017-10-10 04:47:08: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:47:08: gcars_dlake-cap-gcrsr: Routed 4322 bytes (compression=93.2%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:08: gcars_dlake-cap-gcrsr: Capture cycle 7670.

2017-10-10 04:47:09: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:47:09: gcars_dlake-cap-gcrsr: Routed 5442 bytes (compression=96.2%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:09: gcars_dlake-cap-gcrsr: Capture cycle 7671.

2017-10-10 04:47:10: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:47:10: gcars_dlake-cap-gcrsr: Routed 4946 bytes (compression=96.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:10: gcars_dlake-cap-gcrsr: Capture cycle 7672.

2017-10-10 04:47:11: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:47:11: gcars_dlake-cap-gcrsr: Routed 10874 bytes (compression=95.8%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:11: gcars_dlake-cap-gcrsr: Capture cycle 7673.

2017-10-10 04:47:12: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:47:12: gcars_dlake-cap-gcrsr: Routed 6722 bytes (compression=96.3%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:12: gcars_dlake-cap-gcrsr: Capture cycle 7674.

2017-10-10 04:47:13: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:47:13: gcars_dlake-cap-gcrsr: Routed 4916 bytes (compression=96.6%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:13: gcars_dlake-cap-gcrsr: Capture cycle 7675.

2017-10-10 04:47:14: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:47:14: gcars_dlake-cap-gcrsr: Routed 4656 bytes (compression=96.3%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:14: gcars_dlake-cap-gcrsr: Capture cycle 7676.

2017-10-10 04:47:15: gcars_dlake-cap-gcrsr: 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.

2017-10-10 09:47:15: gcars_dlake-cap-gcrsr: Routed 23132 bytes (compression=95.1%) from ‘gcrsr’ into 1 location.

2017-10-10 09:47:15: gcars_dlake-cap-gcrsr: 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

2017-10-12 00:38:48: gecars_all-integ-gcrtr: 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.