2024-06-27 15:13:32
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10073
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'wko_det_rating2'.

2024-06-27 15:13:32
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10074
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Unclosed quotation mark after the character string ')'.

2024-06-27 15:15:51
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10075
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'wko_det_rating2'.

2024-06-27 15:15:51
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10076
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Unclosed quotation mark after the character string ')'.

2024-06-27 15:16:49
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10077
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'wko_det_rating2'.

2024-06-27 15:16:49
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10078
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Unclosed quotation mark after the character string ')'.

2024-06-27 15:17:14
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10079
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'wko_det_rating2'.

2024-06-27 15:17:14
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10080
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Unclosed quotation mark after the character string ')'.

2024-06-27 15:18:03
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10081
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'wko_det_rating2'.

2024-06-27 15:18:03
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10082
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Unclosed quotation mark after the character string ')'.

2024-06-27 15:18:17
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10083
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'wko_det_rating2'.

2024-06-27 15:18:17
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10084
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Unclosed quotation mark after the character string ')'.

2024-06-27 15:18:21
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10085
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'wko_det_rating2'.

2024-06-27 15:18:21
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10086
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Unclosed quotation mark after the character string ')'.

2024-06-27 15:18:24
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10087
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'wko_det_rating2'.

2024-06-27 15:18:24
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10088
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Unclosed quotation mark after the character string ')'.

2024-06-27 15:19:32
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10089
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'wko_det_rating2'.

2024-06-27 15:19:32
Logging ID: sekhar_log
PHP file name: get_dropdown.php
Update table (log_err) RowID: 10090
SQLSTATE: "select column_name = CASE WHEN column_name =  'wko_det_rating1' Then '1'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating2' Then '2'\r\n\t\t\t\t\t\tWHEN column_name =  'wko_det_rating3' Then '3' End\r\n\t\t\t\t\t\t, * from cf_label(NOLOCK) where table_name = 'wko_det' and language_cd = 'DEFAULT' and column_name IN ('wko_det_rating1,'wko_det_rating2','wko_det_rating3')"
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Unclosed quotation mark after the character string ')'.

2024-06-27 16:20:14
Logging ID: sekhar_log
PHP file name: get_report_dashboard.php
Update table (log_err) RowID: 10091
SQLSTATE: "SELECT Opens = COALESCE(SUM(Opens),'' ),Due_in = COALESCE(SUM(Due_in),'' ),Past = COALESCE(SUM(Past),'' )\r\n\t\r\n\t\tFrom \t( SELECT \tOpens = SUM(CASE wrk_sts.wrk_sts_typ_cd WHEN 'OPEN' THEN 1 WHEN 'READY-TO-BE-DONE' THEN 1 ELSE 0 END),\r\n\t\t\t\t\t\t\tDue_in = SUM(CASE WHEN Datediff(day, getdate(), wko_mst_due_date) <= 3 AND Datediff(day, getdate(), wko_mst_due_date) >= 0 AND wrk_sts.wrk_sts_typ_cd = 'OPEN' Then 1 ELSE 0 END),\r\n\t\t\t\t\t\t\tPast = SUM(CASE WHEN Datediff(day, getdate(), wko_mst_due_date) < 0 AND wrk_sts.wrk_sts_typ_cd = 'OPEN' Then 1 ELSE 0 END)\t\t\r\n\t\t\t\t\t\t\t\r\n\t\t\t\tFROM \t\twko_ms (NOLOCK)  \r\n\t\t\t\r\n\t\t\t\t\t\t\tINNER JOIN wko_det (NOLOCK)\r\n\t\t\t\t\t\t\tON\t\twko_mst.site_cd = wko_det.site_cd\r\n\t\t\t\t\t\t\tAND\t\twko_mst.rowid = wko_det.mst_rowid\r\n\t\t\t\t\t\t\tAND \twko_mst_type  IN ('C') \r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\tINNER JOIN\twrk_sts (NOLOCK)\r\n\t\t\t\t\t\t\tON\t\t\twko_mst.site_cd = wrk_sts.site_cd\r\n\t\t\t\t\t\t\tAND\t\t\twko_mst.wko_mst_status = wrk_sts.wrk_sts_status\t\r\n\r\n\t\t\t\t\t\t\tLEFT \r\n\t\t\t\t\t\t\tOUTER \r\n\t\t\t\t\t\t\tJOIN\t\tprm_grp (NOLOCK)\r\n\t\t\t\t\t\t\tON\t\t\twko_mst.site_cd = prm_grp.site_cd\r\n\t\t\t\t\t\t\tAND\t\t\twko_mst.wko_mst_pm_grp = prm_grp.prm_grp_grp_cd\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\tWHERE\t\t( wko_mst.site_cd = 'CPI' ) \r\n\t\t\t\tAND wko_det.wko_det_assign_to LIKE '%sekhar_emp%'  \r\n\t\t\t\tAND CONVERT(DATETIME, CONVERT(VARCHAR, '1900-01-01', 101)) < Getdate() ) as X "
JSONDATA: 
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'wko_ms'.