ผู้เขียน หัวข้อ: ขอถามปัญหา การรวมข้อมูล Offline ครับ  (อ่าน 2282 ครั้ง)

0 สมาชิก และ 1 บุคคลทั่วไป กำลังดูหัวข้อนี้

ออฟไลน์ Apiruk_Jbhos

  • Sr. Member
  • ****
  • กระทู้: 386
  • Respect: +1
    • ดูรายละเอียด
    • โรงพยาบาล สมเด็จพระยุพราช จอมบึง
ขอถามปัญหา การรวมข้อมูล Offline ครับ
« เมื่อ: ธันวาคม 14, 2010, 11:41:38 AM »
0
สวัสดี ผมเพิ่งจะได้ลองเอาออกไปใช้ดู เมื่อก่อน test แค่ 1-2 รายก็ได้ แต่วันวันไปลองดู
ทำไป 23 คน แต่ เมื่อ นำข้อมูลมา รวมกับ Server หลัก ข้อมูล มา 5 ราย ที่เหลือ ก็ ไม่ครบ แต่ก้ ยัง มี
ผลความดัน ชื่อ แพทย์ แต่ ผลวินิจฉัยไม่ออก ประมาณว่า มันไม่ ครบ มากกว่า แต่พอมาดู Log ม่ก้ Not Sys บางตัว อยากทราบว่าเป็น เพราะอะไร และจะแก้ปัญหานี้ได้อย่างไร ครับ 3.53.12.8

Data not sync for table  onlineuser insert Key : ID-{CC533A13-F122-4D14-9826-A4442AF55429}
Data not sync for table  ksklog insert Key : 1930159
Data not sync for table  onlineuser insert Key : ID-{F085215F-C824-456F-BF48-8C01BA795808}
Data not sync for table  ksklog insert Key : 1961379
Data not sync for table  onlineuser insert Key : ID-{C2F80216-FFCD-49CC-AF74-C699EC40F821}
Data not sync for table  ksklog insert Key : 2031008
Data not sync for table  onlineuser insert Key : ID-{8BB3AB1C-BA30-48EA-8D79-6311727F2031}
Data not sync for table  ksklog insert Key : 2031011
Data not sync for table  ksklog insert Key : 2031012
Data not sync for table  onlineuser insert Key : ID-{166924DB-6ADA-4DE5-AD53-BB513B860385}
Data not sync for table  ksklog insert Key : 2031013
Data not sync for table  kskdepartment update Key : 019
Data not sync for table  vn_lock insert Key : 531214060029
Data not sync for table  service_time update Key : 531214060029
Sync Insert : vital_sign_data , vital_sign_data_id = 1281366 New key = 1282129
update vital_sign_data set vital_sign_data_id = 1282129 where vital_sign_data_id = 1281366
Sync Insert : vital_sign_data , vital_sign_data_id = 1282129
Sync Insert : vital_sign_data , vital_sign_data_id = 1281367 New key = 1282130
update vital_sign_data set vital_sign_data_id = 1282130 where vital_sign_data_id = 1281367
Sync Insert : vital_sign_data , vital_sign_data_id = 1282130
Sync Insert : vital_sign_data , vital_sign_data_id = 1281368 New key = 1282131
update vital_sign_data set vital_sign_data_id = 1282131 where vital_sign_data_id = 1281368
Sync Insert : vital_sign_data , vital_sign_data_id = 1282131
Sync Insert : vital_sign_data , vital_sign_data_id = 1281369 New key = 1282132
update vital_sign_data set vital_sign_data_id = 1282132 where vital_sign_data_id = 1281369
Sync Insert : vital_sign_data , vital_sign_data_id = 1282132
Sync Insert : vital_sign_data , vital_sign_data_id = 1281370 New key = 1282133
update vital_sign_data set vital_sign_data_id = 1282133 where vital_sign_data_id = 1281370
Sync Insert : vital_sign_data , vital_sign_data_id = 1282133
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8507 New key = 8571
update opdscreen_cc_history set opdscreen_cc_history_id = 8571 where opdscreen_cc_history_id = 8507
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8571
Data not sync for table  service_time update Key : 531214060029
Data not sync for table  pq_screen insert Key : 531214060029
Data not sync for table  serial insert Key : screen-doctor-queue-531214
Data not sync for table  ksklog insert Key : 2031014
Data not sync for table  opitemrece_summary update Key : {1DF6C949-3BF1-41FA-B54D-56EB2BA90C1F}
Data not sync for table  opitemrece_summary update Key : {598DB54C-B8B3-49C2-8FDC-49F4BFC48662}
Data not sync for table  opitemrece_summary update Key : {6CFFE118-0108-4163-8750-70D598EAC156}
Data not sync for table  opitemrece_summary update Key : {6E3E6B9B-CEA2-49CA-AC2D-3EE3B9B0D32D}
Data not sync for table  opitemrece_summary update Key : {7A00AAA9-CEBF-4FD6-9309-40AA5A1B9A4E}
Data not sync for table  opitemrece_summary update Key : {FD7DC511-5378-43D7-8D65-4091CDA624DF}
Data not sync for table  data_synchronize update Key : 531214060029
Data not sync for table  vn_lock insert Key : 531214060017
Data not sync for table  service_time update Key : 531214060017
Sync Insert : vital_sign_data , vital_sign_data_id = 1281371 New key = 1282134
update vital_sign_data set vital_sign_data_id = 1282134 where vital_sign_data_id = 1281371
Sync Insert : vital_sign_data , vital_sign_data_id = 1282134
Sync Insert : vital_sign_data , vital_sign_data_id = 1281372 New key = 1282135
update vital_sign_data set vital_sign_data_id = 1282135 where vital_sign_data_id = 1281372
Sync Insert : vital_sign_data , vital_sign_data_id = 1282135
Sync Insert : vital_sign_data , vital_sign_data_id = 1281373 New key = 1282136
update vital_sign_data set vital_sign_data_id = 1282136 where vital_sign_data_id = 1281373
Sync Insert : vital_sign_data , vital_sign_data_id = 1282136
Sync Insert : vital_sign_data , vital_sign_data_id = 1281374 New key = 1282137
update vital_sign_data set vital_sign_data_id = 1282137 where vital_sign_data_id = 1281374
Sync Insert : vital_sign_data , vital_sign_data_id = 1282137
Sync Insert : vital_sign_data , vital_sign_data_id = 1281375 New key = 1282138
update vital_sign_data set vital_sign_data_id = 1282138 where vital_sign_data_id = 1281375
Sync Insert : vital_sign_data , vital_sign_data_id = 1282138
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8508 New key = 8572
update opdscreen_cc_history set opdscreen_cc_history_id = 8572 where opdscreen_cc_history_id = 8508
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8572
Data not sync for table  service_time update Key : 531214060017
Data not sync for table  pq_screen insert Key : 531214060017
Data not sync for table  ksklog insert Key : 2031015
Data not sync for table  opitemrece_summary update Key : {0C0BE380-7F32-4DED-A036-FC05C99C5193}
Data not sync for table  opitemrece_summary update Key : {82DC337D-8C8E-4EA1-9552-1AC72EF45D82}
Data not sync for table  opitemrece_summary update Key : {DA61496A-0212-44A6-8D45-4F4CEF75FE43}
Data not sync for table  data_synchronize update Key : 531214060017
Data not sync for table  vn_lock insert Key : 531214060019
Data not sync for table  service_time update Key : 531214060019
Sync Insert : vital_sign_data , vital_sign_data_id = 1281376 New key = 1282139
update vital_sign_data set vital_sign_data_id = 1282139 where vital_sign_data_id = 1281376
Sync Insert : vital_sign_data , vital_sign_data_id = 1282139
Sync Insert : vital_sign_data , vital_sign_data_id = 1281377 New key = 1282140
update vital_sign_data set vital_sign_data_id = 1282140 where vital_sign_data_id = 1281377
Sync Insert : vital_sign_data , vital_sign_data_id = 1282140
Sync Insert : vital_sign_data , vital_sign_data_id = 1281378 New key = 1282141
update vital_sign_data set vital_sign_data_id = 1282141 where vital_sign_data_id = 1281378
Sync Insert : vital_sign_data , vital_sign_data_id = 1282141
Sync Insert : vital_sign_data , vital_sign_data_id = 1281379 New key = 1282142
update vital_sign_data set vital_sign_data_id = 1282142 where vital_sign_data_id = 1281379
Sync Insert : vital_sign_data , vital_sign_data_id = 1282142
Sync Insert : vital_sign_data , vital_sign_data_id = 1281380 New key = 1282143
update vital_sign_data set vital_sign_data_id = 1282143 where vital_sign_data_id = 1281380
Sync Insert : vital_sign_data , vital_sign_data_id = 1282143
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8509 New key = 8573
update opdscreen_cc_history set opdscreen_cc_history_id = 8573 where opdscreen_cc_history_id = 8509
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8573
Data not sync for table  service_time update Key : 531214060019
Data not sync for table  pq_screen insert Key : 531214060019
Data not sync for table  ksklog insert Key : 2031016
Data not sync for table  opitemrece_summary update Key : {71A300DE-6389-4F22-A113-BC87AEC823A3}
Data not sync for table  data_synchronize update Key : 531214060019
Data not sync for table  vn_lock insert Key : 531214060018
Data not sync for table  service_time update Key : 531214060018
Sync Insert : vital_sign_data , vital_sign_data_id = 1281381 New key = 1282144
update vital_sign_data set vital_sign_data_id = 1282144 where vital_sign_data_id = 1281381
Sync Insert : vital_sign_data , vital_sign_data_id = 1282144
Sync Insert : vital_sign_data , vital_sign_data_id = 1281382 New key = 1282145
update vital_sign_data set vital_sign_data_id = 1282145 where vital_sign_data_id = 1281382
Sync Insert : vital_sign_data , vital_sign_data_id = 1282145
Sync Insert : vital_sign_data , vital_sign_data_id = 1281383 New key = 1282146
update vital_sign_data set vital_sign_data_id = 1282146 where vital_sign_data_id = 1281383
Sync Insert : vital_sign_data , vital_sign_data_id = 1282146
Sync Insert : vital_sign_data , vital_sign_data_id = 1281384 New key = 1282147
update vital_sign_data set vital_sign_data_id = 1282147 where vital_sign_data_id = 1281384
Sync Insert : vital_sign_data , vital_sign_data_id = 1282147
Sync Insert : vital_sign_data , vital_sign_data_id = 1281385 New key = 1282148
update vital_sign_data set vital_sign_data_id = 1282148 where vital_sign_data_id = 1281385
Sync Insert : vital_sign_data , vital_sign_data_id = 1282148
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8510 New key = 8574
update opdscreen_cc_history set opdscreen_cc_history_id = 8574 where opdscreen_cc_history_id = 8510
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8574
Data not sync for table  service_time update Key : 531214060018
Data not sync for table  pq_screen insert Key : 531214060018
Data not sync for table  ksklog insert Key : 2031017
Data not sync for table  opitemrece_summary update Key : {4577CAE4-0C9F-49B2-8CBA-5DF3737AC8CA}
Data not sync for table  opitemrece_summary update Key : {A894D538-1E1D-44FF-BCE5-94A0DBA8F114}
Data not sync for table  opitemrece_summary update Key : {D5F1538B-E790-4C50-B167-04B1CDFF69B2}
Data not sync for table  opitemrece_summary update Key : {E0EC9614-69B3-469F-93CF-F80045358E22}
Data not sync for table  opitemrece_summary update Key : {FFB8A1B7-2E44-4F33-83C6-ACF42E214714}
Data not sync for table  data_synchronize update Key : 531214060018
Data not sync for table  vn_lock insert Key : 531214060051
Data not sync for table  service_time update Key : 531214060051
Sync Insert : vital_sign_data , vital_sign_data_id = 1281386 New key = 1282149
update vital_sign_data set vital_sign_data_id = 1282149 where vital_sign_data_id = 1281386
Sync Insert : vital_sign_data , vital_sign_data_id = 1282149
Sync Insert : vital_sign_data , vital_sign_data_id = 1281387 New key = 1282150
update vital_sign_data set vital_sign_data_id = 1282150 where vital_sign_data_id = 1281387
Sync Insert : vital_sign_data , vital_sign_data_id = 1282150
Sync Insert : vital_sign_data , vital_sign_data_id = 1281388 New key = 1282151
update vital_sign_data set vital_sign_data_id = 1282151 where vital_sign_data_id = 1281388
Sync Insert : vital_sign_data , vital_sign_data_id = 1282151
Sync Insert : vital_sign_data , vital_sign_data_id = 1281389 New key = 1282152
update vital_sign_data set vital_sign_data_id = 1282152 where vital_sign_data_id = 1281389
Sync Insert : vital_sign_data , vital_sign_data_id = 1282152
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8511 New key = 8575
update opdscreen_cc_history set opdscreen_cc_history_id = 8575 where opdscreen_cc_history_id = 8511
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8575
Data not sync for table  service_time update Key : 531214060051
Data not sync for table  pq_screen insert Key : 531214060051
Data not sync for table  ksklog insert Key : 2031018
Data not sync for table  data_synchronize update Key : 531214060051
Data not sync for table  vn_lock insert Key : 531214060041
Data not sync for table  service_time update Key : 531214060041
Sync Insert : vital_sign_data , vital_sign_data_id = 1281390 New key = 1282157
update vital_sign_data set vital_sign_data_id = 1282157 where vital_sign_data_id = 1281390
Sync Insert : vital_sign_data , vital_sign_data_id = 1282157
Sync Insert : vital_sign_data , vital_sign_data_id = 1281391 New key = 1282158
update vital_sign_data set vital_sign_data_id = 1282158 where vital_sign_data_id = 1281391
Sync Insert : vital_sign_data , vital_sign_data_id = 1282158
Sync Insert : vital_sign_data , vital_sign_data_id = 1281392 New key = 1282159
update vital_sign_data set vital_sign_data_id = 1282159 where vital_sign_data_id = 1281392
Sync Insert : vital_sign_data , vital_sign_data_id = 1282159
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8512 New key = 8576
update opdscreen_cc_history set opdscreen_cc_history_id = 8576 where opdscreen_cc_history_id = 8512
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8576
Data not sync for table  service_time update Key : 531214060041
Data not sync for table  pq_screen insert Key : 531214060041
Data not sync for table  ksklog insert Key : 2031019
Data not sync for table  opitemrece_summary update Key : {41BD0BFF-0113-49EF-9CEF-DEAA43E8F4FF}
Data not sync for table  opitemrece_summary update Key : {77A2F86B-C775-469F-8C67-2BAD15CA2D37}
Data not sync for table  data_synchronize update Key : 531214060041
Data not sync for table  patient_emr_log insert Key : 20
Data not sync for table  vn_lock insert Key : 531214060047
Data not sync for table  service_time update Key : 531214060047
Sync Insert : vital_sign_data , vital_sign_data_id = 1281393 New key = 1282160
update vital_sign_data set vital_sign_data_id = 1282160 where vital_sign_data_id = 1281393
Sync Insert : vital_sign_data , vital_sign_data_id = 1282160
Sync Insert : vital_sign_data , vital_sign_data_id = 1281394 New key = 1282161
update vital_sign_data set vital_sign_data_id = 1282161 where vital_sign_data_id = 1281394
Sync Insert : vital_sign_data , vital_sign_data_id = 1282161
Sync Insert : vital_sign_data , vital_sign_data_id = 1281395 New key = 1282162
update vital_sign_data set vital_sign_data_id = 1282162 where vital_sign_data_id = 1281395
Sync Insert : vital_sign_data , vital_sign_data_id = 1282162
Sync Insert : vital_sign_data , vital_sign_data_id = 1281396 New key = 1282163
update vital_sign_data set vital_sign_data_id = 1282163 where vital_sign_data_id = 1281396
Sync Insert : vital_sign_data , vital_sign_data_id = 1282163
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8513 New key = 8577
update opdscreen_cc_history set opdscreen_cc_history_id = 8577 where opdscreen_cc_history_id = 8513
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8577
Data not sync for table  service_time update Key : 531214060047
Data not sync for table  pq_screen insert Key : 531214060047
Data not sync for table  ksklog insert Key : 2031020
Data not sync for table  opitemrece_summary update Key : {4F14612E-C0F4-4DAD-BAC4-163FE9D13CDF}
Data not sync for table  opitemrece_summary update Key : {B19CD34C-D497-4F9A-A31B-A871B4F7ABCC}
Data not sync for table  data_synchronize update Key : 531214060047
Data not sync for table  onlineuser insert Key : ID-{E97D1B41-B442-4C88-834B-3FD6339CE4CD}
Data not sync for table  ksklog insert Key : 2031021
Data not sync for table  vn_lock insert Key : 531214060045
Data not sync for table  service_time update Key : 531214060045
Data not sync for table  vn_lock insert Key : 531214060053
Data not sync for table  service_time update Key : 531214060053
Sync Insert : vital_sign_data , vital_sign_data_id = 1281397 New key = 1282164
update vital_sign_data set vital_sign_data_id = 1282164 where vital_sign_data_id = 1281397
Sync Insert : vital_sign_data , vital_sign_data_id = 1282164
Sync Insert : vital_sign_data , vital_sign_data_id = 1281398 New key = 1282165
update vital_sign_data set vital_sign_data_id = 1282165 where vital_sign_data_id = 1281398
Sync Insert : vital_sign_data , vital_sign_data_id = 1282165
Sync Insert : vital_sign_data , vital_sign_data_id = 1281399 New key = 1282166
update vital_sign_data set vital_sign_data_id = 1282166 where vital_sign_data_id = 1281399
Sync Insert : vital_sign_data , vital_sign_data_id = 1282166
Sync Insert : vital_sign_data , vital_sign_data_id = 1281400 New key = 1282167
update vital_sign_data set vital_sign_data_id = 1282167 where vital_sign_data_id = 1281400
Sync Insert : vital_sign_data , vital_sign_data_id = 1282167
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8514 New key = 8578
update opdscreen_cc_history set opdscreen_cc_history_id = 8578 where opdscreen_cc_history_id = 8514
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8578
Data not sync for table  service_time update Key : 531214060045
Data not sync for table  pq_screen insert Key : 531214060045
Data not sync for table  ksklog insert Key : 2031022
Data not sync for table  opitemrece_summary update Key : {A22D7CDE-E55E-420E-B377-969CC9F55FE6}
Data not sync for table  opitemrece_summary update Key : {CF75F346-D9FC-4A58-9115-754612CC60E9}
Data not sync for table  data_synchronize update Key : 531214060045
Data not sync for table  vn_lock insert Key : 531214060029
Data not sync for table  service_time update Key : 531214060029
update dental_icd set ovst_diag_id = 1273483 where ovst_diag_id = 539993
update doctor_operation set ovst_diag_id = 1273483 where ovst_diag_id = 539993
update health_med_service_diagnosis set ovst_diag_id = 1273483 where ovst_diag_id = 539993
update ovstdiag set ovst_diag_id = 1273483 where ovst_diag_id = 539993
update ovstoprt set ovst_diag_id = 1273483 where ovst_diag_id = 539993
Data not sync for table  ksklog insert Key : 2031023
Data not sync for table  opitemrece_log insert Key : 420821
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248479 New key = 248634
update ovst_rx_room set ovst_rx_room_id = 248634 where ovst_rx_room_id = 248479
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248634
Data not sync for table  data_synchronize update Key : 531214060029
Data not sync for table  service_time update Key : 531214060029
Data not sync for table  doctor_order_print insert Key : 9039797
Data not sync for table  doctor_order_print insert Key : 9039798
Data not sync for table  doctor_order_print insert Key : 9039799
Data not sync for table  doctor_order_print insert Key : 9039800
Data not sync for table  doctor_order_print insert Key : 9039801
Data not sync for table  doctor_order_print insert Key : 9039802
Data not sync for table  doctor_order_print insert Key : 9039803
Sync Insert : doctor_order_print_head , doph_id = 1256474 New key = 1257168
update doctor_order_print set doph_id = 1257168 where doph_id = 1256474
update doctor_order_print_head set doph_id = 1257168 where doph_id = 1256474
update doctor_order_print_head_queue set doph_id = 1257168 where doph_id = 1256474
update doctor_order_print_queue set doph_id = 1257168 where doph_id = 1256474
Sync Insert : doctor_order_print_head , doph_id = 1257168
Data not sync for table  report_access_log insert Key : 1297927
update dental_icd set ovst_diag_id = 1273484 where ovst_diag_id = 539994
update doctor_operation set ovst_diag_id = 1273484 where ovst_diag_id = 539994
update health_med_service_diagnosis set ovst_diag_id = 1273484 where ovst_diag_id = 539994
update ovstdiag set ovst_diag_id = 1273484 where ovst_diag_id = 539994
update ovstoprt set ovst_diag_id = 1273484 where ovst_diag_id = 539994
Data not sync for table  ksklog insert Key : 2031024
Data not sync for table  opitemrece_log insert Key : 420822
Data not sync for table  data_synchronize update Key : 531214060029
Data not sync for table  service_time update Key : 531214060029
Data not sync for table  doctor_order_print insert Key : 9039804
Data not sync for table  doctor_order_print insert Key : 9039805
Data not sync for table  doctor_order_print insert Key : 9039806
Data not sync for table  doctor_order_print insert Key : 9039807
Data not sync for table  doctor_order_print insert Key : 9039808
Data not sync for table  doctor_order_print insert Key : 9039809
Data not sync for table  doctor_order_print insert Key : 9039810
Sync Insert : doctor_order_print_head , doph_id = 1256475 New key = 1257169
update doctor_order_print set doph_id = 1257169 where doph_id = 1256475
update doctor_order_print_head set doph_id = 1257169 where doph_id = 1256475
update doctor_order_print_head_queue set doph_id = 1257169 where doph_id = 1256475
update doctor_order_print_queue set doph_id = 1257169 where doph_id = 1256475
Sync Insert : doctor_order_print_head , doph_id = 1257169
Data not sync for table  report_access_log insert Key : 1297928
Sync Insert : oapp , oapp_id = 96764 New key = 96837
update lab_app_head set oapp_id = 96837 where oapp_id = 96764
update oapp set oapp_id = 96837 where oapp_id = 96764
update oapp_cancel set oapp_id = 96837 where oapp_id = 96764
update oapp_pending_log set oapp_id = 96837 where oapp_id = 96764
update oapp_temp set oapp_id = 96837 where oapp_id = 96764
update oapp_vaccine set oapp_id = 96837 where oapp_id = 96764
update oapp_xray set oapp_id = 96837 where oapp_id = 96764
Sync Insert : oapp , oapp_id = 96837
Sync Insert : vital_sign_data , vital_sign_data_id = 1281401 New key = 1282168
update vital_sign_data set vital_sign_data_id = 1282168 where vital_sign_data_id = 1281401
Sync Insert : vital_sign_data , vital_sign_data_id = 1282168
Sync Insert : vital_sign_data , vital_sign_data_id = 1281402 New key = 1282169
update vital_sign_data set vital_sign_data_id = 1282169 where vital_sign_data_id = 1281402
Sync Insert : vital_sign_data , vital_sign_data_id = 1282169
Sync Insert : vital_sign_data , vital_sign_data_id = 1281403 New key = 1282170
update vital_sign_data set vital_sign_data_id = 1282170 where vital_sign_data_id = 1281403
Sync Insert : vital_sign_data , vital_sign_data_id = 1282170
Sync Insert : vital_sign_data , vital_sign_data_id = 1281404 New key = 1282171
update vital_sign_data set vital_sign_data_id = 1282171 where vital_sign_data_id = 1281404
Sync Insert : vital_sign_data , vital_sign_data_id = 1282171
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8515 New key = 8579
update opdscreen_cc_history set opdscreen_cc_history_id = 8579 where opdscreen_cc_history_id = 8515
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8579
Data not sync for table  service_time update Key : 531214060053
Data not sync for table  pq_screen insert Key : 531214060053
Data not sync for table  ksklog insert Key : 2031025
Data not sync for table  data_synchronize update Key : 531214060053
Data not sync for table  vn_lock insert Key : 531214060029
Data not sync for table  service_time update Key : 531214060029
update dental_icd set ovst_diag_id = 1273485 where ovst_diag_id = 539995
update doctor_operation set ovst_diag_id = 1273485 where ovst_diag_id = 539995
update health_med_service_diagnosis set ovst_diag_id = 1273485 where ovst_diag_id = 539995
update ovstdiag set ovst_diag_id = 1273485 where ovst_diag_id = 539995
update ovstoprt set ovst_diag_id = 1273485 where ovst_diag_id = 539995
Data not sync for table  ksklog insert Key : 2031026
Data not sync for table  opitemrece_log insert Key : 420823
Data not sync for table  data_synchronize update Key : 531214060029
Data not sync for table  service_time update Key : 531214060029
Data not sync for table  doctor_order_print insert Key : 9039811
Data not sync for table  doctor_order_print insert Key : 9039812
Data not sync for table  doctor_order_print insert Key : 9039813
Data not sync for table  doctor_order_print insert Key : 9039814
Data not sync for table  doctor_order_print insert Key : 9039815
Data not sync for table  doctor_order_print insert Key : 9039816
Data not sync for table  doctor_order_print insert Key : 9039817
Sync Insert : doctor_order_print_head , doph_id = 1256476 New key = 1257170
update doctor_order_print set doph_id = 1257170 where doph_id = 1256476
update doctor_order_print_head set doph_id = 1257170 where doph_id = 1256476
update doctor_order_print_head_queue set doph_id = 1257170 where doph_id = 1256476
update doctor_order_print_queue set doph_id = 1257170 where doph_id = 1256476
Sync Insert : doctor_order_print_head , doph_id = 1257170
Data not sync for table  report_access_log insert Key : 1297929
Data not sync for table  vn_lock insert Key : 531214060017
Data not sync for table  service_time update Key : 531214060017
Data not sync for table  vn_lock insert Key : 531214060040
Data not sync for table  service_time update Key : 531214060040
update dental_icd set ovst_diag_id = 1273487 where ovst_diag_id = 539998
update doctor_operation set ovst_diag_id = 1273487 where ovst_diag_id = 539998
update health_med_service_diagnosis set ovst_diag_id = 1273487 where ovst_diag_id = 539998
update ovstdiag set ovst_diag_id = 1273487 where ovst_diag_id = 539998
update ovstoprt set ovst_diag_id = 1273487 where ovst_diag_id = 539998
update dental_icd set ovst_diag_id = 1273488 where ovst_diag_id = 539999
update doctor_operation set ovst_diag_id = 1273488 where ovst_diag_id = 539999
update health_med_service_diagnosis set ovst_diag_id = 1273488 where ovst_diag_id = 539999
update ovstdiag set ovst_diag_id = 1273488 where ovst_diag_id = 539999
update ovstoprt set ovst_diag_id = 1273488 where ovst_diag_id = 539999
Data not sync for table  ksklog insert Key : 2031027
Data not sync for table  opitemrece_log insert Key : 420824
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248480 New key = 248635
update ovst_rx_room set ovst_rx_room_id = 248635 where ovst_rx_room_id = 248480
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248635
Data not sync for table  data_synchronize update Key : 531214060017
Data not sync for table  service_time update Key : 531214060017
Data not sync for table  doctor_order_print insert Key : 9039818
Data not sync for table  doctor_order_print insert Key : 9039819
Data not sync for table  doctor_order_print insert Key : 9039820
Data not sync for table  doctor_order_print insert Key : 9039821
Sync Insert : doctor_order_print_head , doph_id = 1256477 New key = 1257171
update doctor_order_print set doph_id = 1257171 where doph_id = 1256477
update doctor_order_print_head set doph_id = 1257171 where doph_id = 1256477
update doctor_order_print_head_queue set doph_id = 1257171 where doph_id = 1256477
update doctor_order_print_queue set doph_id = 1257171 where doph_id = 1256477
Sync Insert : doctor_order_print_head , doph_id = 1257171
Data not sync for table  report_access_log insert Key : 1297930
Data not sync for table  vn_lock insert Key : 531214060019
Data not sync for table  service_time update Key : 531214060019
update dental_icd set ovst_diag_id = 1273490 where ovst_diag_id = 540001
update doctor_operation set ovst_diag_id = 1273490 where ovst_diag_id = 540001
update health_med_service_diagnosis set ovst_diag_id = 1273490 where ovst_diag_id = 540001
update ovstdiag set ovst_diag_id = 1273490 where ovst_diag_id = 540001
update ovstoprt set ovst_diag_id = 1273490 where ovst_diag_id = 540001
Data not sync for table  ksklog insert Key : 2031028
Data not sync for table  opitemrece_log insert Key : 420825
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248481 New key = 248636
update ovst_rx_room set ovst_rx_room_id = 248636 where ovst_rx_room_id = 248481
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248636
Data not sync for table  data_synchronize update Key : 531214060019
Data not sync for table  service_time update Key : 531214060019
Data not sync for table  doctor_order_print insert Key : 9039822
Data not sync for table  doctor_order_print insert Key : 9039823
Sync Insert : doctor_order_print_head , doph_id = 1256478 New key = 1257172
update doctor_order_print set doph_id = 1257172 where doph_id = 1256478
update doctor_order_print_head set doph_id = 1257172 where doph_id = 1256478
update doctor_order_print_head_queue set doph_id = 1257172 where doph_id = 1256478
update doctor_order_print_queue set doph_id = 1257172 where doph_id = 1256478
Sync Insert : doctor_order_print_head , doph_id = 1257172
Data not sync for table  report_access_log insert Key : 1297931
Data not sync for table  vn_lock insert Key : 531214060017
Data not sync for table  service_time update Key : 531214060017
update dental_icd set ovst_diag_id = 1273491 where ovst_diag_id = 540002
update doctor_operation set ovst_diag_id = 1273491 where ovst_diag_id = 540002
update health_med_service_diagnosis set ovst_diag_id = 1273491 where ovst_diag_id = 540002
update ovstdiag set ovst_diag_id = 1273491 where ovst_diag_id = 540002
update ovstoprt set ovst_diag_id = 1273491 where ovst_diag_id = 540002
Data not sync for table  ksklog insert Key : 2031029
Data not sync for table  opitemrece_log insert Key : 420826
Data not sync for table  data_synchronize update Key : 531214060017
Data not sync for table  service_time update Key : 531214060017
Data not sync for table  doctor_order_print insert Key : 9039824
Data not sync for table  doctor_order_print insert Key : 9039825
Data not sync for table  doctor_order_print insert Key : 9039826
Data not sync for table  doctor_order_print insert Key : 9039827
Sync Insert : doctor_order_print_head , doph_id = 1256479 New key = 1257173
update doctor_order_print set doph_id = 1257173 where doph_id = 1256479
update doctor_order_print_head set doph_id = 1257173 where doph_id = 1256479
update doctor_order_print_head_queue set doph_id = 1257173 where doph_id = 1256479
update doctor_order_print_queue set doph_id = 1257173 where doph_id = 1256479
Sync Insert : doctor_order_print_head , doph_id = 1257173
Data not sync for table  report_access_log insert Key : 1297932
Sync Insert : oapp , oapp_id = 96765 New key = 96838
update lab_app_head set oapp_id = 96838 where oapp_id = 96765
update oapp set oapp_id = 96838 where oapp_id = 96765
update oapp_cancel set oapp_id = 96838 where oapp_id = 96765
update oapp_pending_log set oapp_id = 96838 where oapp_id = 96765
update oapp_temp set oapp_id = 96838 where oapp_id = 96765
update oapp_vaccine set oapp_id = 96838 where oapp_id = 96765
update oapp_xray set oapp_id = 96838 where oapp_id = 96765
Sync Insert : oapp , oapp_id = 96838
Sync Insert : vital_sign_data , vital_sign_data_id = 1281405 New key = 1282172
update vital_sign_data set vital_sign_data_id = 1282172 where vital_sign_data_id = 1281405
Sync Insert : vital_sign_data , vital_sign_data_id = 1282172
Sync Insert : vital_sign_data , vital_sign_data_id = 1281406 New key = 1282173
update vital_sign_data set vital_sign_data_id = 1282173 where vital_sign_data_id = 1281406
Sync Insert : vital_sign_data , vital_sign_data_id = 1282173
Sync Insert : vital_sign_data , vital_sign_data_id = 1281407 New key = 1282174
update vital_sign_data set vital_sign_data_id = 1282174 where vital_sign_data_id = 1281407
Sync Insert : vital_sign_data , vital_sign_data_id = 1282174
Sync Insert : vital_sign_data , vital_sign_data_id = 1281408 New key = 1282175
update vital_sign_data set vital_sign_data_id = 1282175 where vital_sign_data_id = 1281408
Sync Insert : vital_sign_data , vital_sign_data_id = 1282175
Sync Insert : vital_sign_data , vital_sign_data_id = 1281409 New key = 1282176
update vital_sign_data set vital_sign_data_id = 1282176 where vital_sign_data_id = 1281409
Sync Insert : vital_sign_data , vital_sign_data_id = 1282176
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8516 New key = 8580
update opdscreen_cc_history set opdscreen_cc_history_id = 8580 where opdscreen_cc_history_id = 8516
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8580
Data not sync for table  service_time update Key : 531214060040
Data not sync for table  pq_screen insert Key : 531214060040
Data not sync for table  ksklog insert Key : 2031030
Data not sync for table  opitemrece_summary update Key : {9FADF6D4-F492-4A4E-8E63-CA10601304AB}
Data not sync for table  data_synchronize update Key : 531214060040
Data not sync for table  vn_lock insert Key : 531214060018
Data not sync for table  service_time update Key : 531214060018
update dental_icd set ovst_diag_id = 1273493 where ovst_diag_id = 540003
update doctor_operation set ovst_diag_id = 1273493 where ovst_diag_id = 540003
update health_med_service_diagnosis set ovst_diag_id = 1273493 where ovst_diag_id = 540003
update ovstdiag set ovst_diag_id = 1273493 where ovst_diag_id = 540003
update ovstoprt set ovst_diag_id = 1273493 where ovst_diag_id = 540003
update dental_icd set ovst_diag_id = 1273494 where ovst_diag_id = 540007
update doctor_operation set ovst_diag_id = 1273494 where ovst_diag_id = 540007
update health_med_service_diagnosis set ovst_diag_id = 1273494 where ovst_diag_id = 540007
update ovstdiag set ovst_diag_id = 1273494 where ovst_diag_id = 540007
update ovstoprt set ovst_diag_id = 1273494 where ovst_diag_id = 540007
Data not sync for table  ksklog insert Key : 2031031
Data not sync for table  opitemrece_log insert Key : 420827
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248482 New key = 248637
update ovst_rx_room set ovst_rx_room_id = 248637 where ovst_rx_room_id = 248482
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248637
Data not sync for table  data_synchronize update Key : 531214060018
Data not sync for table  service_time update Key : 531214060018
Data not sync for table  doctor_order_print insert Key : 9039828
Data not sync for table  doctor_order_print insert Key : 9039829
Data not sync for table  doctor_order_print insert Key : 9039830
Data not sync for table  doctor_order_print insert Key : 9039831
Data not sync for table  doctor_order_print insert Key : 9039832
Data not sync for table  doctor_order_print insert Key : 9039833
Sync Insert : doctor_order_print_head , doph_id = 1256480 New key = 1257175
update doctor_order_print set doph_id = 1257175 where doph_id = 1256480
update doctor_order_print_head set doph_id = 1257175 where doph_id = 1256480
update doctor_order_print_head_queue set doph_id = 1257175 where doph_id = 1256480
update doctor_order_print_queue set doph_id = 1257175 where doph_id = 1256480
Sync Insert : doctor_order_print_head , doph_id = 1257175
Data not sync for table  report_access_log insert Key : 1297933
Data not sync for table  vn_lock insert Key : 531214060051
Data not sync for table  service_time update Key : 531214060051
update dental_icd set ovst_diag_id = 1273497 where ovst_diag_id = 540009
update doctor_operation set ovst_diag_id = 1273497 where ovst_diag_id = 540009
update health_med_service_diagnosis set ovst_diag_id = 1273497 where ovst_diag_id = 540009
update ovstdiag set ovst_diag_id = 1273497 where ovst_diag_id = 540009
update ovstoprt set ovst_diag_id = 1273497 where ovst_diag_id = 540009
update dental_icd set ovst_diag_id = 1273498 where ovst_diag_id = 540011
update doctor_operation set ovst_diag_id = 1273498 where ovst_diag_id = 540011
update health_med_service_diagnosis set ovst_diag_id = 1273498 where ovst_diag_id = 540011
update ovstdiag set ovst_diag_id = 1273498 where ovst_diag_id = 540011
update ovstoprt set ovst_diag_id = 1273498 where ovst_diag_id = 540011
Data not sync for table  ksklog insert Key : 2031032
Data not sync for table  opitemrece_log insert Key : 420828
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248483 New key = 248638
update ovst_rx_room set ovst_rx_room_id = 248638 where ovst_rx_room_id = 248483
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248638
Data not sync for table  data_synchronize update Key : 531214060051
Data not sync for table  service_time update Key : 531214060051
Data not sync for table  doctor_order_print insert Key : 9039834
Data not sync for table  doctor_order_print insert Key : 9039835
Data not sync for table  doctor_order_print insert Key : 9039836
Data not sync for table  doctor_order_print insert Key : 9039837
Sync Insert : doctor_order_print_head , doph_id = 1256481 New key = 1257176
update doctor_order_print set doph_id = 1257176 where doph_id = 1256481
update doctor_order_print_head set doph_id = 1257176 where doph_id = 1256481
update doctor_order_print_head_queue set doph_id = 1257176 where doph_id = 1256481
update doctor_order_print_queue set doph_id = 1257176 where doph_id = 1256481
Sync Insert : doctor_order_print_head , doph_id = 1257176
Data not sync for table  report_access_log insert Key : 1297934
Data not sync for table  vn_lock insert Key : 531214060045
Data not sync for table  service_time update Key : 531214060045
update dental_icd set ovst_diag_id = 1273501 where ovst_diag_id = 540012
update doctor_operation set ovst_diag_id = 1273501 where ovst_diag_id = 540012
update health_med_service_diagnosis set ovst_diag_id = 1273501 where ovst_diag_id = 540012
update ovstdiag set ovst_diag_id = 1273501 where ovst_diag_id = 540012
update ovstoprt set ovst_diag_id = 1273501 where ovst_diag_id = 540012
update dental_icd set ovst_diag_id = 1273502 where ovst_diag_id = 540015
update doctor_operation set ovst_diag_id = 1273502 where ovst_diag_id = 540015
update health_med_service_diagnosis set ovst_diag_id = 1273502 where ovst_diag_id = 540015
update ovstdiag set ovst_diag_id = 1273502 where ovst_diag_id = 540015
update ovstoprt set ovst_diag_id = 1273502 where ovst_diag_id = 540015
Data not sync for table  ksklog insert Key : 2031033
Data not sync for table  opitemrece_log insert Key : 420829
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248484 New key = 248639
update ovst_rx_room set ovst_rx_room_id = 248639 where ovst_rx_room_id = 248484
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248639
Data not sync for table  data_synchronize update Key : 531214060045
Data not sync for table  service_time update Key : 531214060045
Data not sync for table  doctor_order_print insert Key : 9039838
Data not sync for table  doctor_order_print insert Key : 9039839
Data not sync for table  doctor_order_print insert Key : 9039840
Sync Insert : doctor_order_print_head , doph_id = 1256482 New key = 1257177
update doctor_order_print set doph_id = 1257177 where doph_id = 1256482
update doctor_order_print_head set doph_id = 1257177 where doph_id = 1256482
update doctor_order_print_head_queue set doph_id = 1257177 where doph_id = 1256482
update doctor_order_print_queue set doph_id = 1257177 where doph_id = 1256482
Sync Insert : doctor_order_print_head , doph_id = 1257177
Data not sync for table  report_access_log insert Key : 1297935
Data not sync for table  vn_lock insert Key : 531214060047
Data not sync for table  service_time update Key : 531214060047
update dental_icd set ovst_diag_id = 1273504 where ovst_diag_id = 540017
update doctor_operation set ovst_diag_id = 1273504 where ovst_diag_id = 540017
update health_med_service_diagnosis set ovst_diag_id = 1273504 where ovst_diag_id = 540017
update ovstdiag set ovst_diag_id = 1273504 where ovst_diag_id = 540017
update ovstoprt set ovst_diag_id = 1273504 where ovst_diag_id = 540017
Data not sync for table  ksklog insert Key : 2031034
Data not sync for table  opitemrece_log insert Key : 420830
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248485 New key = 248640
update ovst_rx_room set ovst_rx_room_id = 248640 where ovst_rx_room_id = 248485
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248640
Data not sync for table  data_synchronize update Key : 531214060047
Data not sync for table  service_time update Key : 531214060047
Data not sync for table  doctor_order_print insert Key : 9039841
Data not sync for table  doctor_order_print insert Key : 9039842
Data not sync for table  doctor_order_print insert Key : 9039843
Sync Insert : doctor_order_print_head , doph_id = 1256483 New key = 1257178
update doctor_order_print set doph_id = 1257178 where doph_id = 1256483
update doctor_order_print_head set doph_id = 1257178 where doph_id = 1256483
update doctor_order_print_head_queue set doph_id = 1257178 where doph_id = 1256483
update doctor_order_print_queue set doph_id = 1257178 where doph_id = 1256483
Sync Insert : doctor_order_print_head , doph_id = 1257178
Data not sync for table  report_access_log insert Key : 1297936
Data not sync for table  vn_lock insert Key : 531214060039
Data not sync for table  vn_lock insert Key : 531214060041
Data not sync for table  service_time update Key : 531214060039
Data not sync for table  service_time update Key : 531214060041
update dental_icd set ovst_diag_id = 1273506 where ovst_diag_id = 540019
update doctor_operation set ovst_diag_id = 1273506 where ovst_diag_id = 540019
update health_med_service_diagnosis set ovst_diag_id = 1273506 where ovst_diag_id = 540019
update ovstdiag set ovst_diag_id = 1273506 where ovst_diag_id = 540019
update ovstoprt set ovst_diag_id = 1273506 where ovst_diag_id = 540019
Data not sync for table  ksklog insert Key : 2031035
Data not sync for table  opitemrece_log insert Key : 420831
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248486 New key = 248641
update ovst_rx_room set ovst_rx_room_id = 248641 where ovst_rx_room_id = 248486
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248641
Data not sync for table  data_synchronize update Key : 531214060041
Data not sync for table  service_time update Key : 531214060041
Data not sync for table  doctor_order_print insert Key : 9039844
Data not sync for table  doctor_order_print insert Key : 9039845
Data not sync for table  doctor_order_print insert Key : 9039846
Sync Insert : doctor_order_print_head , doph_id = 1256484 New key = 1257179
update doctor_order_print set doph_id = 1257179 where doph_id = 1256484
update doctor_order_print_head set doph_id = 1257179 where doph_id = 1256484
update doctor_order_print_head_queue set doph_id = 1257179 where doph_id = 1256484
update doctor_order_print_queue set doph_id = 1257179 where doph_id = 1256484
Sync Insert : doctor_order_print_head , doph_id = 1257179
Data not sync for table  report_access_log insert Key : 1297937
Data not sync for table  vn_lock insert Key : 531214060040
Data not sync for table  service_time update Key : 531214060040
Data not sync for table  patient_emr_log insert Key : 21
Sync Insert : oapp , oapp_id = 96766 New key = 96839
update lab_app_head set oapp_id = 96839 where oapp_id = 96766
update oapp set oapp_id = 96839 where oapp_id = 96766
update oapp_cancel set oapp_id = 96839 where oapp_id = 96766
update oapp_pending_log set oapp_id = 96839 where oapp_id = 96766
update oapp_temp set oapp_id = 96839 where oapp_id = 96766
update oapp_vaccine set oapp_id = 96839 where oapp_id = 96766
update oapp_xray set oapp_id = 96839 where oapp_id = 96766
Sync Insert : oapp , oapp_id = 96839
Sync Insert : vital_sign_data , vital_sign_data_id = 1281410 New key = 1282177
update vital_sign_data set vital_sign_data_id = 1282177 where vital_sign_data_id = 1281410
Sync Insert : vital_sign_data , vital_sign_data_id = 1282177
Sync Insert : vital_sign_data , vital_sign_data_id = 1281411 New key = 1282178
update vital_sign_data set vital_sign_data_id = 1282178 where vital_sign_data_id = 1281411
Sync Insert : vital_sign_data , vital_sign_data_id = 1282178
Sync Insert : vital_sign_data , vital_sign_data_id = 1281412 New key = 1282179
update vital_sign_data set vital_sign_data_id = 1282179 where vital_sign_data_id = 1281412
Sync Insert : vital_sign_data , vital_sign_data_id = 1282179
Sync Insert : vital_sign_data , vital_sign_data_id = 1281413 New key = 1282180
update vital_sign_data set vital_sign_data_id = 1282180 where vital_sign_data_id = 1281413
Sync Insert : vital_sign_data , vital_sign_data_id = 1282180
Sync Insert : vital_sign_data , vital_sign_data_id = 1281414 New key = 1282181
update vital_sign_data set vital_sign_data_id = 1282181 where vital_sign_data_id = 1281414
Sync Insert : vital_sign_data , vital_sign_data_id = 1282181
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8517 New key = 8581
update opdscreen_cc_history set opdscreen_cc_history_id = 8581 where opdscreen_cc_history_id = 8517
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8581
Data not sync for table  service_time update Key : 531214060039
Data not sync for table  pq_screen insert Key : 531214060039
Data not sync for table  ksklog insert Key : 2031036
Data not sync for table  opitemrece_summary update Key : {28932BA2-CEAC-4E11-95AB-3CB0011FD117}
Data not sync for table  opitemrece_summary update Key : {A6CC63AD-3189-413F-8413-C234929D3E5B}
Data not sync for table  opitemrece_summary update Key : {C889CE4C-D23F-43B7-A720-2CADEA6C3EC1}
Data not sync for table  data_synchronize update Key : 531214060039
Data not sync for table  vn_lock insert Key : 531214060043
Data not sync for table  service_time update Key : 531214060043
update dental_icd set ovst_diag_id = 1273508 where ovst_diag_id = 540020
update doctor_operation set ovst_diag_id = 1273508 where ovst_diag_id = 540020
update health_med_service_diagnosis set ovst_diag_id = 1273508 where ovst_diag_id = 540020
update ovstdiag set ovst_diag_id = 1273508 where ovst_diag_id = 540020
update ovstoprt set ovst_diag_id = 1273508 where ovst_diag_id = 540020
Data not sync for table  ksklog insert Key : 2031037
Data not sync for table  opitemrece_log insert Key : 420832
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248487 New key = 248642
update ovst_rx_room set ovst_rx_room_id = 248642 where ovst_rx_room_id = 248487
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248642
Data not sync for table  data_synchronize update Key : 531214060040
Data not sync for table  service_time update Key : 531214060040
Data not sync for table  doctor_order_print insert Key : 9039847
Data not sync for table  doctor_order_print insert Key : 9039848
Sync Insert : doctor_order_print_head , doph_id = 1256485 New key = 1257180
update doctor_order_print set doph_id = 1257180 where doph_id = 1256485
update doctor_order_print_head set doph_id = 1257180 where doph_id = 1256485
update doctor_order_print_head_queue set doph_id = 1257180 where doph_id = 1256485
update doctor_order_print_queue set doph_id = 1257180 where doph_id = 1256485
Sync Insert : doctor_order_print_head , doph_id = 1257180
Data not sync for table  report_access_log insert Key : 1297938
Data not sync for table  vn_lock insert Key : 531214060053
Data not sync for table  service_time update Key : 531214060053
Sync Insert : oapp , oapp_id = 96767 New key = 96840
update lab_app_head set oapp_id = 96840 where oapp_id = 96767
update oapp set oapp_id = 96840 where oapp_id = 96767
update oapp_cancel set oapp_id = 96840 where oapp_id = 96767
update oapp_pending_log set oapp_id = 96840 where oapp_id = 96767
update oapp_temp set oapp_id = 96840 where oapp_id = 96767
update oapp_vaccine set oapp_id = 96840 where oapp_id = 96767
update oapp_xray set oapp_id = 96840 where oapp_id = 96767
Sync Insert : oapp , oapp_id = 96840
Sync Insert : vital_sign_data , vital_sign_data_id = 1281415 New key = 1282182
update vital_sign_data set vital_sign_data_id = 1282182 where vital_sign_data_id = 1281415
Sync Insert : vital_sign_data , vital_sign_data_id = 1282182
Sync Insert : vital_sign_data , vital_sign_data_id = 1281416 New key = 1282183
update vital_sign_data set vital_sign_data_id = 1282183 where vital_sign_data_id = 1281416
Sync Insert : vital_sign_data , vital_sign_data_id = 1282183
Sync Insert : vital_sign_data , vital_sign_data_id = 1281417 New key = 1282184
update vital_sign_data set vital_sign_data_id = 1282184 where vital_sign_data_id = 1281417
Sync Insert : vital_sign_data , vital_sign_data_id = 1282184
Sync Insert : vital_sign_data , vital_sign_data_id = 1281418 New key = 1282185
update vital_sign_data set vital_sign_data_id = 1282185 where vital_sign_data_id = 1281418
Sync Insert : vital_sign_data , vital_sign_data_id = 1282185
Sync Insert : vital_sign_data , vital_sign_data_id = 1281419 New key = 1282186
update vital_sign_data set vital_sign_data_id = 1282186 where vital_sign_data_id = 1281419
Sync Insert : vital_sign_data , vital_sign_data_id = 1282186
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8518 New key = 8582
update opdscreen_cc_history set opdscreen_cc_history_id = 8582 where opdscreen_cc_history_id = 8518
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8582
Data not sync for table  service_time update Key : 531214060043
Data not sync for table  pq_screen insert Key : 531214060043
Data not sync for table  ksklog insert Key : 2031038
Data not sync for table  opitemrece_summary update Key : {C62092D6-9ECF-40C2-8846-3B816FC2E75D}
Data not sync for table  data_synchronize update Key : 531214060043
update dental_icd set ovst_diag_id = 1273511 where ovst_diag_id = 540022
update doctor_operation set ovst_diag_id = 1273511 where ovst_diag_id = 540022
update health_med_service_diagnosis set ovst_diag_id = 1273511 where ovst_diag_id = 540022
update ovstdiag set ovst_diag_id = 1273511 where ovst_diag_id = 540022
update ovstoprt set ovst_diag_id = 1273511 where ovst_diag_id = 540022
update dental_icd set ovst_diag_id = 1273512 where ovst_diag_id = 540023
update doctor_operation set ovst_diag_id = 1273512 where ovst_diag_id = 540023
update health_med_service_diagnosis set ovst_diag_id = 1273512 where ovst_diag_id = 540023
update ovstdiag set ovst_diag_id = 1273512 where ovst_diag_id = 540023
update ovstoprt set ovst_diag_id = 1273512 where ovst_diag_id = 540023
Data not sync for table  ksklog insert Key : 2031039
Data not sync for table  opitemrece_log insert Key : 420833
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248488 New key = 248643
update ovst_rx_room set ovst_rx_room_id = 248643 where ovst_rx_room_id = 248488
Sync Insert : ovst_rx_room , ovst_rx_room_id = 248643
Data not sync for table  data_synchronize update Key : 531214060053
Data not sync for table  service_time update Key : 531214060053
Data not sync for table  doctor_order_print insert Key : 9039849
Data not sync for table  doctor_order_print insert Key : 9039850
Data not sync for table  doctor_order_print insert Key : 9039851
Data not sync for table  doctor_order_print insert Key : 9039852
Sync Insert : doctor_order_print_head , doph_id = 1256486 New key = 1257181
update doctor_order_print set doph_id = 1257181 where doph_id = 1256486
update doctor_order_print_head set doph_id = 1257181 where doph_id = 1256486
update doctor_order_print_head_queue set doph_id = 1257181 where doph_id = 1256486
update doctor_order_print_queue set doph_id = 1257181 where doph_id = 1256486
Sync Insert : doctor_order_print_head , doph_id = 1257181
Data not sync for table  report_access_log insert Key : 1297939
Data not sync for table  vn_lock insert Key : 531214060050
Data not sync for table  service_time update Key : 531214060050
Sync Insert : oapp , oapp_id = 96768 New key = 96841
update lab_app_head set oapp_id = 96841 where oapp_id = 96768
update oapp set oapp_id = 96841 where oapp_id = 96768
update oapp_cancel set oapp_id = 96841 where oapp_id = 96768
update oapp_pending_log set oapp_id = 96841 where oapp_id = 96768
update oapp_temp set oapp_id = 96841 where oapp_id = 96768
update oapp_vaccine set oapp_id = 96841 where oapp_id = 96768
update oapp_xray set oapp_id = 96841 where oapp_id = 96768
Sync Insert : oapp , oapp_id = 96841
Sync Insert : vital_sign_data , vital_sign_data_id = 1281420 New key = 1282187
update vital_sign_data set vital_sign_data_id = 1282187 where vital_sign_data_id = 1281420
Sync Insert : vital_sign_data , vital_sign_data_id = 1282187
Sync Insert : vital_sign_data , vital_sign_data_id = 1281421 New key = 1282188
update vital_sign_data set vital_sign_data_id = 1282188 where vital_sign_data_id = 1281421
Sync Insert : vital_sign_data , vital_sign_data_id = 1282188
Sync Insert : vital_sign_data , vital_sign_data_id = 1281422 New key = 1282189
update vital_sign_data set vital_sign_data_id = 1282189 where vital_sign_data_id = 1281422
Sync Insert : vital_sign_data , vital_sign_data_id = 1282189
Sync Insert : vital_sign_data , vital_sign_data_id = 1281423 New key = 1282190
update vital_sign_data set vital_sign_data_id = 1282190 where vital_sign_data_id = 1281423
Sync Insert : vital_sign_data , vital_sign_data_id = 1282190
Sync Insert : vital_sign_data , vital_sign_data_id = 1281424 New key = 1282191
update vital_sign_data set vital_sign_data_id = 1282191 where vital_sign_data_id = 1281424
Sync Insert : vital_sign_data , vital_sign_data_id = 1282191
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8519 New key = 8583
update opdscreen_cc_history set opdscreen_cc_history_id = 8583 where opdscreen_cc_history_id = 8519
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8583
Data not sync for table  service_time update Key : 531214060050
Data not sync for table  pq_screen insert Key : 531214060050
Data not sync for table  ksklog insert Key : 2031040
Data not sync for table  data_synchronize update Key : 531214060050
Data not sync for table  vn_lock insert Key : 531214060038
Data not sync for table  service_time update Key : 531214060038
Sync Insert : oapp , oapp_id = 96769 New key = 96842
update lab_app_head set oapp_id = 96842 where oapp_id = 96769
update oapp set oapp_id = 96842 where oapp_id = 96769
update oapp_cancel set oapp_id = 96842 where oapp_id = 96769
update oapp_pending_log set oapp_id = 96842 where oapp_id = 96769
update oapp_temp set oapp_id = 96842 where oapp_id = 96769
update oapp_vaccine set oapp_id = 96842 where oapp_id = 96769
update oapp_xray set oapp_id = 96842 where oapp_id = 96769
Sync Insert : oapp , oapp_id = 96842
Sync Insert : vital_sign_data , vital_sign_data_id = 1281425 New key = 1282192
update vital_sign_data set vital_sign_data_id = 1282192 where vital_sign_data_id = 1281425
Sync Insert : vital_sign_data , vital_sign_data_id = 1282192
Sync Insert : vital_sign_data , vital_sign_data_id = 1281426 New key = 1282193
update vital_sign_data set vital_sign_data_id = 1282193 where vital_sign_data_id = 1281426
Sync Insert : vital_sign_data , vital_sign_data_id = 1282193
Sync Insert : vital_sign_data , vital_sign_data_id = 1281427 New key = 1282194
update vital_sign_data set vital_sign_data_id = 1282194 where vital_sign_data_id = 1281427
Sync Insert : vital_sign_data , vital_sign_data_id = 1282194
Sync Insert : vital_sign_data , vital_sign_data_id = 1281428 New key = 1282195
update vital_sign_data set vital_sign_data_id = 1282195 where vital_sign_data_id = 1281428
Sync Insert : vital_sign_data , vital_sign_data_id = 1282195
Sync Insert : vital_sign_data , vital_sign_data_id = 1281429 New key = 1282196
update vital_sign_data set vital_sign_data_id = 1282196 where vital_sign_data_id = 1281429
Sync Insert : vital_sign_data , vital_sign_data_id = 1282196
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8520 New key = 8584
update opdscreen_cc_history set opdscreen_cc_history_id = 8584 where opdscreen_cc_history_id = 8520
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8584
Data not sync for table  service_time update Key : 531214060038
Data not sync for table  pq_screen insert Key : 531214060038
Data not sync for table  ksklog insert Key : 2031041
Data not sync for table  opitemrece_summary update Key : {C3D9FEDD-80D7-42F0-A767-18792D425C20}
Data not sync for table  opitemrece_summary update Key : {F2CED94D-5698-42F9-B5F9-8F7290F1D7BE}
Data not sync for table  data_synchronize update Key : 531214060038
Data not sync for table  vn_lock insert Key : 531214060052
Data not sync for table  service_time update Key : 531214060052
Sync Insert : oapp , oapp_id = 96770 New key = 96843
update lab_app_head set oapp_id = 96843 where oapp_id = 96770
update oapp set oapp_id = 96843 where oapp_id = 96770
update oapp_cancel set oapp_id = 96843 where oapp_id = 96770
update oapp_pending_log set oapp_id = 96843 where oapp_id = 96770
update oapp_temp set oapp_id = 96843 where oapp_id = 96770
update oapp_vaccine set oapp_id = 96843 where oapp_id = 96770
update oapp_xray set oapp_id = 96843 where oapp_id = 96770
Sync Insert : oapp , oapp_id = 96843
Sync Insert : vital_sign_data , vital_sign_data_id = 1281430 New key = 1282197
update vital_sign_data set vital_sign_data_id = 1282197 where vital_sign_data_id = 1281430
Sync Insert : vital_sign_data , vital_sign_data_id = 1282197
Sync Insert : vital_sign_data , vital_sign_data_id = 1281431 New key = 1282198
update vital_sign_data set vital_sign_data_id = 1282198 where vital_sign_data_id = 1281431
Sync Insert : vital_sign_data , vital_sign_data_id = 1282198
Sync Insert : vital_sign_data , vital_sign_data_id = 1281432 New key = 1282199
update vital_sign_data set vital_sign_data_id = 1282199 where vital_sign_data_id = 1281432
Sync Insert : vital_sign_data , vital_sign_data_id = 1282199
Sync Insert : vital_sign_data , vital_sign_data_id = 1281433 New key = 1282200
update vital_sign_data set vital_sign_data_id = 1282200 where vital_sign_data_id = 1281433
Sync Insert : vital_sign_data , vital_sign_data_id = 1282200
Sync Insert : vital_sign_data , vital_sign_data_id = 1281434 New key = 1282201
update vital_sign_data set vital_sign_data_id = 1282201 where vital_sign_data_id = 1281434
Sync Insert : vital_sign_data , vital_sign_data_id = 1282201
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8521 New key = 8585
update opdscreen_cc_history set opdscreen_cc_history_id = 8585 where opdscreen_cc_history_id = 8521
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8585
Data not sync for table  service_time update Key : 531214060052
Data not sync for table  pq_screen insert Key : 531214060052
Data not sync for table  ksklog insert Key : 2031042
Data not sync for table  data_synchronize update Key : 531214060052
Data not sync for table  vn_lock insert Key : 531214060049
Data not sync for table  service_time update Key : 531214060049
Sync Insert : oapp , oapp_id = 96771 New key = 96844
update lab_app_head set oapp_id = 96844 where oapp_id = 96771
update oapp set oapp_id = 96844 where oapp_id = 96771
update oapp_cancel set oapp_id = 96844 where oapp_id = 96771
update oapp_pending_log set oapp_id = 96844 where oapp_id = 96771
update oapp_temp set oapp_id = 96844 where oapp_id = 96771
update oapp_vaccine set oapp_id = 96844 where oapp_id = 96771
update oapp_xray set oapp_id = 96844 where oapp_id = 96771
Sync Insert : oapp , oapp_id = 96844
Sync Insert : vital_sign_data , vital_sign_data_id = 1281435 New key = 1282202
update vital_sign_data set vital_sign_data_id = 1282202 where vital_sign_data_id = 1281435
Sync Insert : vital_sign_data , vital_sign_data_id = 1282202
Sync Insert : vital_sign_data , vital_sign_data_id = 1281436 New key = 1282203
update vital_sign_data set vital_sign_data_id = 1282203 where vital_sign_data_id = 1281436
Sync Insert : vital_sign_data , vital_sign_data_id = 1282203
Sync Insert : vital_sign_data , vital_sign_data_id = 1281437 New key = 1282204
update vital_sign_data set vital_sign_data_id = 1282204 where vital_sign_data_id = 1281437
Sync Insert : vital_sign_data , vital_sign_data_id = 1282204
Sync Insert : vital_sign_data , vital_sign_data_id = 1281438 New key = 1282205
update vital_sign_data set vital_sign_data_id = 1282205 where vital_sign_data_id = 1281438
Sync Insert : vital_sign_data , vital_sign_data_id = 1282205
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8522 New key = 8586
update opdscreen_cc_history set opdscreen_cc_history_id = 8586 where opdscreen_cc_history_id = 8522
Sync Insert : opdscreen_cc_history , opdscreen_cc_history_id = 8586
Data not sync for table  service_time update Key : 531214060049
Data not sync for table  pq_screen insert Key : 531214060049
Data not sync for table  ksklog insert Key : 2031043
Data not sync for table  data_synchronize update Key : 531214060049
Data not sync for table  vn_lock insert Key : 531214060045
Data not sync for table  service_time update Key : 531214060045
update dental_icd set ovst_diag_id = 1273513 where ovst_diag_id = 540024
update doctor_operation set ovst_diag_id = 1273513 where ovst_diag_id = 540024
update health_med_service_diagnosis set ovst_diag_id = 1273513 where ovst_diag_id = 540024
update ovstdiag set ovst_diag_id = 1273513 where ovst_diag_id = 540024
update ovstoprt set ovst_diag_id = 1273513 where ovst_diag_id = 540024
update dental_icd set ovst_diag_id = 1273514 where ovst_diag_id = 540027
update doctor_operation set ovst_diag_id = 1273514 where ovst_diag_id = 540027
update health_med_service_diagnosis set ovst_diag_id = 1273514 where ovst_diag_id = 540027
update ovstdiag set ovst_diag_id = 1273514 where ovst_diag_id = 540027
update ovstoprt set ovst_diag_id = 1273514 where ovst_diag_id = 540027
Data not sync for table 
นาย อภิรักษ์ ชุ่มชะอุ่ม
Mail advance_pro@hotmail.com
โรงพยาบาล สมเด็จพระยุพราช จอมบึง

Server 1 : SR550 Ram 64G
OS1 : CentOS Linux 7.6
MariaDB version 10.1.19

Server 2 : IBM X3500 Ram 6G
OS2 : CentOS 7.6


ขึ้นระบบ เดือน กรกฎาคม 50
http://www.ChomBungHospital.com/

ออฟไลน์ Apiruk_Jbhos

  • Sr. Member
  • ****
  • กระทู้: 386
  • Respect: +1
    • ดูรายละเอียด
    • โรงพยาบาล สมเด็จพระยุพราช จอมบึง
Re: ขอถามปัญหา การรวมข้อมูล Offline ครับ
« ตอบกลับ #1 เมื่อ: ธันวาคม 14, 2010, 11:59:03 AM »
0
ครั้งแรก ที่ลง server หลัก เป็น ตัวที่มีการใช้งานอยู่ตลอด ข้อมูลหายไปเยอะ
แต่เมื่อ กี้ ลองกับ อีกเครื่อง ที่ได้ ยิงมาจาก Server หลัก เมื่อตอนเที่ยงคืน ไม่มีการใช้งาน
เอาข้อมูล มา Syns กับตัวหลัง ข้อมูล มาเยอะ กว่าเดิม เกือบ ครับ แต่ก้ยังไม่ 100%
เลย ไม่เข้าใจว่าเป็นเพราะ อะไร ครับ

บางรายไปดู ผลวินิฉัย หลักไม่เข้า แต่ โรคร่วม เข้า
จะเป้นกับ server หลัก ซะมากกว่า น่าจะมี ID หรือ VN ชน
มันเลยไม่นำเข้าหรือเปล่าครับ แต่ คราวหน้าจะแก้ไข้ยังไงให้เข้าได้ 100% ครับ ...
« แก้ไขครั้งสุดท้าย: ธันวาคม 14, 2010, 12:14:52 PM โดย Apiruk_Jbhos »
นาย อภิรักษ์ ชุ่มชะอุ่ม
Mail advance_pro@hotmail.com
โรงพยาบาล สมเด็จพระยุพราช จอมบึง

Server 1 : SR550 Ram 64G
OS1 : CentOS Linux 7.6
MariaDB version 10.1.19

Server 2 : IBM X3500 Ram 6G
OS2 : CentOS 7.6


ขึ้นระบบ เดือน กรกฎาคม 50
http://www.ChomBungHospital.com/

ออฟไลน์ Apiruk_Jbhos

  • Sr. Member
  • ****
  • กระทู้: 386
  • Respect: +1
    • ดูรายละเอียด
    • โรงพยาบาล สมเด็จพระยุพราช จอมบึง
Re: ขอถามปัญหา การรวมข้อมูล Offline ครับ
« ตอบกลับ #2 เมื่อ: ธันวาคม 14, 2010, 22:42:00 PM »
0
ไม่ทราบว่าที่อื่น ได้ใช้บ้างไหมครับ ระบบนี้ แล้วเจอปัญหาแบบนี้บ้างไหมครับ
นาย อภิรักษ์ ชุ่มชะอุ่ม
Mail advance_pro@hotmail.com
โรงพยาบาล สมเด็จพระยุพราช จอมบึง

Server 1 : SR550 Ram 64G
OS1 : CentOS Linux 7.6
MariaDB version 10.1.19

Server 2 : IBM X3500 Ram 6G
OS2 : CentOS 7.6


ขึ้นระบบ เดือน กรกฎาคม 50
http://www.ChomBungHospital.com/