HOSxP 3.57.9.9c ฟ้อง Unknown column 'lock_dx' กับ 'pe_rtf'

[@ชายคนหนึ่ง@]

สอบถามหน่อยครับ อัพโครงสร้าง HOSxP 3.57.9.9c แล้วฟ้อง Unknown column 'lock_dx' กับ 'pe_rtf' อะครับ

เครื่องลูก 3.57.9.9c กับ 3.57.7.25d ก็เป็นทั้งสอง


#42S22Unknown column 'lock_dx' in 'field list'  SQL>INSERT INTO ovstdiag (ovst_diag_id,vn,icd10,hn,vstdate,vsttime,diagtype,icd103,hcode,doctor,episode,ext_code,hos_guid,dep_flag,ovst_oper_type,staff,dx_guid,lock_dx) VALUES (1043616,'571020132211','Z029','0059490','2014-10-20','13:22:11','1','Z02','11399','267',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)


#42S22Unknown column 'pe_rtf' in 'field list'  SQL>INSERT INTO opdscreen (hos_guid,vn,hn,vstdate,vsttime,begintime,outtime,endtime,bpd,bps,bw,cc,hr,pe,pulse,temperature,note,rr,cc_begin_date,cc_cause_of_visit,cc_sign,cc_duration,cc_position,cc_note,his_begin_date,his_frequency,his_severity,his_cause,his_expand,his_cause_increase,his_cause_decrease,his_related_sign,height,screen_dep,waiting,fbs,help1,help2,help3,help4,help1_time,help1_bps,help1_bpd,help2_time,help2_temp,help3_icode,help3_time,help3_qty,help4_note,advice1,advice2,advice3,advice4,advice5,advice6,advice7,cradle,pe_ga,pe_heent,pe_heart,pe_lung,pe_ab,pe_ext,pe_neuro,pe_ga_text,pe_heent_text,pe_heart_text,pe_lung_text,pe_ab_text,pe_neuro_text,pe_ext_text,bmi,tg,hdl,glucurine,blank1,bun,creatinine,ua,hba1c,riskdm,skin_color,found_amphetamine,pregnancy,advice7_note,checkup,er_note,found_allergy,hpi,pmh,fh,sh,ros,tc,ldl,ast,alt,symptom,walk_id,peak_flow,cholesterol,waist,advice8,breast_feeding,cradle_lie,pain_score,pefr,opdscreen_patient_type_id,creatinine_kidney_percent,sodium,chloride,potassium,tco2,smoking_type_id,drinking_type_id,pulse_regulation_type_id,spo2,urine_albumin,urine_creatinine,pefr_percent,macro_albumin,micro_albumin,egfr,hb,upcr,bicarb,phosphate,pth,pe_gy,pe_gy_text,pe_gu,pe_gu_text,pe_gi,pe_gi_text,bsa,pe_head,pe_head_text,pe_skin,pe_skin_text,g6pd,pe_rtf) VALUES ('{2819F759-38CB-44CA-A408-2F565B9408D8}','571020143108','0059323','2014-10-20','14:31:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)

[udomchok]

Up structure slave หรือ Initial import ใหม่ครับ

แล้วค่อย run replicate agent