36
« เมื่อ: ธันวาคม 14, 2010, 11:41:38 AM »
สวัสดี ผมเพิ่งจะได้ลองเอาออกไปใช้ดู เมื่อก่อน 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 = 857