2024-06-27 10:57:02
Logging ID: SEKHAR_LOG
PHP file name: get_default_values.php
Update table (log_err) RowID: 10067
SQLSTATE: "SELECT \r\n            dft_mst_wko_sts = COALESCE(dft_mst_wko_sts + ' : ' + wrk_sts_desc,''), \r\n            dft_mst_lab_act = COALESCE(dft_mst_lab_act,''), \r\n            dft_mst_mat_act = COALESCE(dft_mst_mat_act,''), \r\n            dft_mst_con_act = COALESCE(dft_mst_con_act,''), \r\n            dft_mst_wko_pri = COALESCE(dft_mst_wko_pri + ' : ' + wrk_pri_desc + ' - ' + cast(wrk_pri_due_date_count as varchar),''), \r\n            dft_mst_temp_ast , \r\n            dft_mst_wko_asset_no = COALESCE(dft_mst_wko_asset_no,''), \r\n            dft_mst_wkr_asset_no = COALESCE(dft_mst_wkr_asset_no,'') ,\r\n            dft_mst_wo_default_cc , \r\n            dft_mst_time_card_by , \r\n            dft_mst_itm_resv, \r\n            dft_mst_po_auto_close,\r\n            dft_mst_mr_approval , \r\n            dft_mst_mtr_email_approver , \r\n            dft_mst_tim_act = COALESCE(dft_mst_tim_act,''),\r\n            dft_mst_gen_inv,\r\n            dft_mst_mbl_chk_cmp,\r\n            dft_mst_mbl_chk_scan,\r\n            dft_mst_pur_email_approver,\r\n            dft_mst_pur_email_requestor,\r\n            dft_mst_generate_po,\r\n            cf_site.site_name\r\n        FROM dft_mst (NOLOCK) \r\n        LEFT OUTER JOIN wrk_pri (NOLOCK) ON dft_mst.site_cd = wrk_pri.site_cd AND dft_mst.dft_mst_wko_pri = wrk_pri.wrk_pri_pri_cd \r\n        LEFT OUTER JOIN wrk_sts (NOLOCK) ON dft_mst.site_cd = wrk_sts.site_cd AND dft_mst.dft_mst_wko_sts = wrk_sts.wrk_sts_status \r\n        LEFT OUTER JOIN cf_site (NOLOCK) ON dft_mst.site_cd = cf_site.site_cd\r\n        WHERE dft_mst.site_cd = ?"
JSONDATA: ["CPI"]
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'dft_mst_mbl_chk_cmp'.

2024-06-27 10:57:49
Logging ID: SEKHAR_LOG
PHP file name: get_default_values.php
Update table (log_err) RowID: 10068
SQLSTATE: "SELECT \r\n            dft_mst_wko_sts = COALESCE(dft_mst_wko_sts + ' : ' + wrk_sts_desc,''), \r\n            dft_mst_lab_act = COALESCE(dft_mst_lab_act,''), \r\n            dft_mst_mat_act = COALESCE(dft_mst_mat_act,''), \r\n            dft_mst_con_act = COALESCE(dft_mst_con_act,''), \r\n            dft_mst_wko_pri = COALESCE(dft_mst_wko_pri + ' : ' + wrk_pri_desc + ' - ' + cast(wrk_pri_due_date_count as varchar),''), \r\n            dft_mst_temp_ast , \r\n            dft_mst_wko_asset_no = COALESCE(dft_mst_wko_asset_no,''), \r\n            dft_mst_wkr_asset_no = COALESCE(dft_mst_wkr_asset_no,'') ,\r\n            dft_mst_wo_default_cc , \r\n            dft_mst_time_card_by , \r\n            dft_mst_itm_resv, \r\n            dft_mst_po_auto_close,\r\n            dft_mst_mr_approval , \r\n            dft_mst_mtr_email_approver , \r\n            dft_mst_tim_act = COALESCE(dft_mst_tim_act,''),\r\n            dft_mst_gen_inv,\r\n            dft_mst_mbl_chk_cmp,\r\n            dft_mst_mbl_chk_scan,\r\n            dft_mst_pur_email_approver,\r\n            dft_mst_pur_email_requestor,\r\n            dft_mst_generate_po,\r\n            cf_site.site_name\r\n        FROM dft_mst (NOLOCK) \r\n        LEFT OUTER JOIN wrk_pri (NOLOCK) ON dft_mst.site_cd = wrk_pri.site_cd AND dft_mst.dft_mst_wko_pri = wrk_pri.wrk_pri_pri_cd \r\n        LEFT OUTER JOIN wrk_sts (NOLOCK) ON dft_mst.site_cd = wrk_sts.site_cd AND dft_mst.dft_mst_wko_sts = wrk_sts.wrk_sts_status \r\n        LEFT OUTER JOIN cf_site (NOLOCK) ON dft_mst.site_cd = cf_site.site_cd\r\n        WHERE dft_mst.site_cd = ?"
JSONDATA: ["CPI"]
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'dft_mst_mbl_chk_cmp'.