09:25:20.854 Check GUID on table ovstdiag
09:25:21.562 Total ovstdiag = 94811
09:25:21.565 Waiting data ... select * from etl_table_status where table_name = "ovstdiag"
09:25:21.902 Waiting data ... select count(*) as cc from ovstdiag
09:25:22.333 Synchronize table : ovstdiag by date
09:25:22.370 Identical check table : ovstdiag
09:25:22.379 Local ovstdiag recordcount = 94,811
09:25:22.384 Waiting data ... select count(*) as cc from ovstdiag
09:25:22.709 Remote ovstdiag recordcount = 94,800
09:25:22.718 Waiting data ... select * from ovstdiag limit 0
09:25:25.407 Waiting data ... select vstdate, concat(sum(CONV(SUBSTRING(md5(concat_ws(ovst_diag_id,vn,icd10,hn,vstdate,vsttime,diagtype,icd103,hcode,doctor,episode,ext_code,dep_fl
09:25:30.145 Receive : 2597 Records
09:25:32.065 Table ovstdiag data in date 2008-10-16 not match mark as recheck Local = 58 , Remote = 54
09:25:32.071 Table ovstdiag data in date 2008-10-17 not match mark as recheck Local = 113 , Remote = 85
09:25:32.336 Table ovstdiag data in date 2009-09-07 not match mark as recheck Local = 33 , Remote = 35
09:25:32.342 Table ovstdiag data in date 2009-09-08 not match mark as recheck Local = 34 , Remote = 58
09:25:32.348 Table ovstdiag data in date 2009-09-09 not match mark as recheck Local = 32 , Remote = 27
09:25:32.366 Local ovstdiag Checksum = 592628865764579649470075559971429645575026789583
09:25:32.371 Waiting data ... select concat(sum(CONV(SUBSTRING(md5(concat_ws(ovst_diag_id,vn,icd10,hn,vstdate,vsttime,diagtype,icd103,hcode,doctor,episode,ext_code,dep_flag,ovst_o
09:25:32.587 Remote ovstdiag (ovst_diag_id,vn,icd10,hn,vstdate,vsttime,diagtype,icd103,hcode,doctor,episode,ext_code,dep_flag,ovst_oper_type,staff) Checksum = 576406398307538064915148524099432235555417321849
09:25:32.602 ovstdiag Date '2008-10-16','2008-10-17','2009-09-07','2009-09-08','2009-09-09' All records = 270
09:25:32.620 Waiting data ... select * from ovstdiag where hospcode="05135" and ovst_diag_id in (80309,80310,80311,80312,80313,80314,80315,80316,80317,80318,80319,80320,80321,80322
09:25:33.131 Waiting data ... select * from ovstdiag limit 0
09:25:33.846 Full sync ovstdiag Add delta 69 Records
09:25:35.389 Waiting data ... select * from ovstdiag limit 0
09:25:35.613 Full sync ovstdiag Edit delta 32 Records
09:25:35.629 Send table ovstdiag error : Delta is empty.
09:25:35.639 Synchronize table : ovstdiag by date
09:25:35.664 Identical check table : ovstdiag
09:25:35.671 Local ovstdiag recordcount = 94,811
09:25:35.676 Waiting data ... select count(*) as cc from ovstdiag
09:25:36.011 Remote ovstdiag recordcount = 94,869
09:25:36.021 Waiting data ... select * from ovstdiag limit 0
09:25:36.193 Waiting data ... select vstdate, concat(sum(CONV(SUBSTRING(md5(concat_ws(ovst_diag_id,vn,icd10,hn,vstdate,vsttime,diagtype,icd103,hcode,doctor,episode,ext_code,dep_fl
09:25:39.716 Receive : 2597 Records
หัวข้อ: ส่งข้อมูลเข้า DATACENTER ติดอยู่ตรงนี้ แก้ไขอย่างไร (อ่าน 5747 ครั้ง)