File: C:\AssetWorks\FASuite\main-ms\Logs\202607\20260731\AppServer\50420\sqlerr.log
07/31/26 04:18:02 Port 50420: SQLDELAY -32- [thread_id=0000000000000000]: SELECT app_id, app_ip, app_port, app_process_id, started_datetime, cmd_restart, cmd_restart_time, cmd_logging, max_conn_allow, cur_conn_count, max_conn_count, cur_db_conn, verbose_log_level, datetime_expire_verbose_log, clear_caches FROM appmon_apps WHERE app_ip = UPPER('fa-eam-rls01') AND app_port = 50420 AND app_status = 'ACTIVE'07/31/26 04:18:02 Port 50420: SQLDELAYTOTAL -32- [thread_id=0000000000000000]: SELECT app_id, app_ip, app_port, app_process_id, started_datetime, cmd_restart, cmd_restart_time, cmd_logging, max_conn_allow, cur_conn_count, max_conn_count, cur_db_conn, verbose_log_level, datetime_expire_verbose_log, clear_caches FROM appmon_apps WHERE app_ip = UPPER('fa-eam-rls01') AND app_port = 50420 AND app_status = 'ACTIVE'07/31/26 04:18:02 Port 50420: SQLDELAY -21- [thread_id=0000021F1FDA3A60]: SELECT LOC_loc_code, loc_year, loc_month, max(row_id) as maxRowID, max(x_datetime_insert) as maxDateTimeInsert,sum(pm_ords_opened) as pmOrdersOpened, sum(pm_ords_closed) as pmOrdersClosed, sum(qty_pm_labor_hrs) as XXFLT1202_qtyPmLaborHours, sum(value_pm_labor) as XXFLT1202_valuePmLabor, sum(value_pm_parts) as XXFLT1202_valuePmParts, sum(value_pm_coml_labor) as XXFLT1202_valuePmCmlLabor, sum(value_pm_coml_parts) as XXFLT1202_valuePmCmlParts, sum(repr_ords_opened) as repairOrdersOpened, sum(repr_ords_closed) as repairOrdersClosed, sum(qty_repair_labor_hrs) as XXFLT1202_repairLaborHours, sum(value_repair_labor) as XXFLT1202_valueRepairLabor, sum(value_repair_parts) as XXFLT1202_valueRepairParts, sum(value_repr_cml_labor) as XXFLT1202_valueRepairCmlLabor, sum(value_repr_cml_parts) as XXFLT1202_valueRepairCmlParts, sum(repr_tasks_done) as repairTasksDone, sum(down_hours_closed) as XXFLT1202_downHoursClosed, sum(qty_comeback_tasks) as qtyComebackTasks, sum(qty_indir_labor_hrs) as XXFLT1202_qtyIndirectLaborHours, sum(value_indirect_labor) as XXFLT1202_valueIndirectLabor, sum(value_indirect_parts) as XXFLT1202_valueIndirectParts, sum(value_parts_received) as XXFLT1202_valuePartsReceived, sum(value_parts_trans_in) as XXFLT1202_valuePartsTransferIn, sum(value_parts_trf_out) as XXFLT1202_valuePartsTransferOut, sum(value_parts_adj_dol) as XXFLT1202_valuePartsAdjustment, sum(qty_parts_recvd_late) as XXFLT1402_qtyPartsReceivedLate, sum(parts_tot_days_late) as partsTotalDaysLate, sum(value_parts_issued) as XXFLT1202_valuePartsIssued, sum(inv_rb_ords_opened) as invRebuildOrdersOpened, sum(inv_rb_ords_closed) as invRebuildOrdersClosed, sum(qty_inv_rb_labor_hrs) as XXFLT1202_invRebuildLaborHours, sum(value_inv_rb_labor) as XXFLT1202_valueRebuildLabor, sum(value_inv_rb_parts) as XXFLT1202_valueRebuildParts, sum(value_inv_rb_cml_labor) as XXFLT1202_valueRebuildCmlLabor, sum(value_inv_rb_cml_parts) as XXFLT1202_valueRebuildCmlParts FROM FAC_MAIN_EVENT WHERE APP_id = 'fa-eam-rls01:50420' group by LOC_loc_code, loc_year, loc_month order by LOC_loc_code, loc_year desc, loc_month desc
07/31/26 04:18:02 Port 50420: SQLDELAYTOTAL -21- [thread_id=0000021F1FDA3A60]: SELECT LOC_loc_code, loc_year, loc_month, max(row_id) as maxRowID, max(x_datetime_insert) as maxDateTimeInsert,sum(pm_ords_opened) as pmOrdersOpened, sum(pm_ords_closed) as pmOrdersClosed, sum(qty_pm_labor_hrs) as XXFLT1202_qtyPmLaborHours, sum(value_pm_labor) as XXFLT1202_valuePmLabor, sum(value_pm_parts) as XXFLT1202_valuePmParts, sum(value_pm_coml_labor) as XXFLT1202_valuePmCmlLabor, sum(value_pm_coml_parts) as XXFLT1202_valuePmCmlParts, sum(repr_ords_opened) as repairOrdersOpened, sum(repr_ords_closed) as repairOrdersClosed, sum(qty_repair_labor_hrs) as XXFLT1202_repairLaborHours, sum(value_repair_labor) as XXFLT1202_valueRepairLabor, sum(value_repair_parts) as XXFLT1202_valueRepairParts, sum(value_repr_cml_labor) as XXFLT1202_valueRepairCmlLabor, sum(value_repr_cml_parts) as XXFLT1202_valueRepairCmlParts, sum(repr_tasks_done) as repairTasksDone, sum(down_hours_closed) as XXFLT1202_downHoursClosed, sum(qty_comeback_tasks) as qtyComebackTasks, sum(qty_indir_labor_hrs) as XXFLT1202_qtyIndirectLaborHours, sum(value_indirect_labor) as XXFLT1202_valueIndirectLabor, sum(value_indirect_parts) as XXFLT1202_valueIndirectParts, sum(value_parts_received) as XXFLT1202_valuePartsReceived, sum(value_parts_trans_in) as XXFLT1202_valuePartsTransferIn, sum(value_parts_trf_out) as XXFLT1202_valuePartsTransferOut, sum(value_parts_adj_dol) as XXFLT1202_valuePartsAdjustment, sum(qty_parts_recvd_late) as XXFLT1402_qtyPartsReceivedLate, sum(parts_tot_days_late) as partsTotalDaysLate, sum(value_parts_issued) as XXFLT1202_valuePartsIssued, sum(inv_rb_ords_opened) as invRebuildOrdersOpened, sum(inv_rb_ords_closed) as invRebuildOrdersClosed, sum(qty_inv_rb_labor_hrs) as XXFLT1202_invRebuildLaborHours, sum(value_inv_rb_labor) as XXFLT1202_valueRebuildLabor, sum(value_inv_rb_parts) as XXFLT1202_valueRebuildParts, sum(value_inv_rb_cml_labor) as XXFLT1202_valueRebuildCmlLabor, sum(value_inv_rb_cml_parts) as XXFLT1202_valueRebuildCmlParts FROM FAC_MAIN_EVENT WHERE APP_id = 'fa-eam-rls01:50420' group by LOC_loc_code, loc_year, loc_month order by LOC_loc_code, loc_year desc, loc_month desc
07/31/26 05:17:29 Port 50420: SQLDELAY -14- [thread_id=0000021F1FDA3A60]: SELECT LOC_loc_code, loc_year, loc_month, max(row_id) as maxRowID, max(x_datetime_insert) as maxDateTimeInsert,sum(pm_ords_opened) as pmOrdersOpened, sum(pm_ords_closed) as pmOrdersClosed, sum(qty_pm_labor_hrs) as XXFLT1202_qtyPmLaborHours, sum(value_pm_labor) as XXFLT1202_valuePmLabor, sum(value_pm_parts) as XXFLT1202_valuePmParts, sum(value_pm_coml_labor) as XXFLT1202_valuePmCmlLabor, sum(value_pm_coml_parts) as XXFLT1202_valuePmCmlParts, sum(repr_ords_opened) as repairOrdersOpened, sum(repr_ords_closed) as repairOrdersClosed, sum(qty_repair_labor_hrs) as XXFLT1202_repairLaborHours, sum(value_repair_labor) as XXFLT1202_valueRepairLabor, sum(value_repair_parts) as XXFLT1202_valueRepairParts, sum(value_repr_cml_labor) as XXFLT1202_valueRepairCmlLabor, sum(value_repr_cml_parts) as XXFLT1202_valueRepairCmlParts, sum(repr_tasks_done) as repairTasksDone, sum(down_hours_closed) as XXFLT1202_downHoursClosed, sum(qty_comeback_tasks) as qtyComebackTasks, sum(qty_indir_labor_hrs) as XXFLT1202_qtyIndirectLaborHours, sum(value_indirect_labor) as XXFLT1202_valueIndirectLabor, sum(value_indirect_parts) as XXFLT1202_valueIndirectParts, sum(value_parts_received) as XXFLT1202_valuePartsReceived, sum(value_parts_trans_in) as XXFLT1202_valuePartsTransferIn, sum(value_parts_trf_out) as XXFLT1202_valuePartsTransferOut, sum(value_parts_adj_dol) as XXFLT1202_valuePartsAdjustment, sum(qty_parts_recvd_late) as XXFLT1402_qtyPartsReceivedLate, sum(parts_tot_days_late) as partsTotalDaysLate, sum(value_parts_issued) as XXFLT1202_valuePartsIssued, sum(inv_rb_ords_opened) as invRebuildOrdersOpened, sum(inv_rb_ords_closed) as invRebuildOrdersClosed, sum(qty_inv_rb_labor_hrs) as XXFLT1202_invRebuildLaborHours, sum(value_inv_rb_labor) as XXFLT1202_valueRebuildLabor, sum(value_inv_rb_parts) as XXFLT1202_valueRebuildParts, sum(value_inv_rb_cml_labor) as XXFLT1202_valueRebuildCmlLabor, sum(value_inv_rb_cml_parts) as XXFLT1202_valueRebuildCmlParts FROM FAC_MAIN_EVENT WHERE APP_id = 'fa-eam-rls01:50420' group by LOC_loc_code, loc_year, loc_month order by LOC_loc_code, loc_year desc, loc_month desc
07/31/26 05:17:29 Port 50420: SQLDELAY -31- [thread_id=0000000000000000]: SELECT app_id, app_ip, app_port, app_process_id, started_datetime, cmd_restart, cmd_restart_time, cmd_logging, max_conn_allow, cur_conn_count, max_conn_count, cur_db_conn, verbose_log_level, datetime_expire_verbose_log, clear_caches FROM appmon_apps WHERE app_ip = UPPER('fa-eam-rls01') AND app_port = 50420 AND app_status = 'ACTIVE'07/31/26 05:17:29 Port 50420: SQLDELAYTOTAL -14- [thread_id=0000021F1FDA3A60]: SELECT LOC_loc_code, loc_year, loc_month, max(row_id) as maxRowID, max(x_datetime_insert) as maxDateTimeInsert,sum(pm_ords_opened) as pmOrdersOpened, sum(pm_ords_closed) as pmOrdersClosed, sum(qty_pm_labor_hrs) as XXFLT1202_qtyPmLaborHours, sum(value_pm_labor) as XXFLT1202_valuePmLabor, sum(value_pm_parts) as XXFLT1202_valuePmParts, sum(value_pm_coml_labor) as XXFLT1202_valuePmCmlLabor, sum(value_pm_coml_parts) as XXFLT1202_valuePmCmlParts, sum(repr_ords_opened) as repairOrdersOpened, sum(repr_ords_closed) as repairOrdersClosed, sum(qty_repair_labor_hrs) as XXFLT1202_repairLaborHours, sum(value_repair_labor) as XXFLT1202_valueRepairLabor, sum(value_repair_parts) as XXFLT1202_valueRepairParts, sum(value_repr_cml_labor) as XXFLT1202_valueRepairCmlLabor, sum(value_repr_cml_parts) as XXFLT1202_valueRepairCmlParts, sum(repr_tasks_done) as repairTasksDone, sum(down_hours_closed) as XXFLT1202_downHoursClosed, sum(qty_comeback_tasks) as qtyComebackTasks, sum(qty_indir_labor_hrs) as XXFLT1202_qtyIndirectLaborHours, sum(value_indirect_labor) as XXFLT1202_valueIndirectLabor, sum(value_indirect_parts) as XXFLT1202_valueIndirectParts, sum(value_parts_received) as XXFLT1202_valuePartsReceived, sum(value_parts_trans_in) as XXFLT1202_valuePartsTransferIn, sum(value_parts_trf_out) as XXFLT1202_valuePartsTransferOut, sum(value_parts_adj_dol) as XXFLT1202_valuePartsAdjustment, sum(qty_parts_recvd_late) as XXFLT1402_qtyPartsReceivedLate, sum(parts_tot_days_late) as partsTotalDaysLate, sum(value_parts_issued) as XXFLT1202_valuePartsIssued, sum(inv_rb_ords_opened) as invRebuildOrdersOpened, sum(inv_rb_ords_closed) as invRebuildOrdersClosed, sum(qty_inv_rb_labor_hrs) as XXFLT1202_invRebuildLaborHours, sum(value_inv_rb_labor) as XXFLT1202_valueRebuildLabor, sum(value_inv_rb_parts) as XXFLT1202_valueRebuildParts, sum(value_inv_rb_cml_labor) as XXFLT1202_valueRebuildCmlLabor, sum(value_inv_rb_cml_parts) as XXFLT1202_valueRebuildCmlParts FROM FAC_MAIN_EVENT WHERE APP_id = 'fa-eam-rls01:50420' group by LOC_loc_code, loc_year, loc_month order by LOC_loc_code, loc_year desc, loc_month desc
07/31/26 05:17:29 Port 50420: SQLDELAYTOTAL -31- [thread_id=0000000000000000]: SELECT app_id, app_ip, app_port, app_process_id, started_datetime, cmd_restart, cmd_restart_time, cmd_logging, max_conn_allow, cur_conn_count, max_conn_count, cur_db_conn, verbose_log_level, datetime_expire_verbose_log, clear_caches FROM appmon_apps WHERE app_ip = UPPER('fa-eam-rls01') AND app_port = 50420 AND app_status = 'ACTIVE'07/31/26 09:50:06 Port 50420: [Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denied on the object 'UI_CTRL_VIEW', database 'QADEPLOY', schema 'emsdba'.
07/31/26 09:50:06 Port 50420: [thread_id=0000021F1FDA3A60] sql_select: CTRLSEL26392
SELECT (SELECT SR.str_text FROM STR_RESOURCE SR WHERE SR.str_id = UI_CTRL_VIEW.v_str_id AND SR.lang_id = 'en' AND SR.product_type = 'APP' AND SR.resource_type = 'UICONTROLTITLE') as v_title_default, v_win_window_id, v_ctrl_order, v_ctrl_group, v_ctrl_type, v_help_id, v_char_cpy, v_mask, v_tab_order, v_grid_order, v_pos_v, v_pos_h, v_siz_h, v_siz_w, v_flags, v_validation, v_validation_struct_id, v_filter, v_table_name, v_column_name, v_column_type, v_total_width, v_decimal_places, v_lookup_descr_ctrlid, v_forkey_lookup_table, v_forkey_lookup_column, v_descr_column_name, v_clist_table_name, v_clist_column_list, v_clist_where, v_value_choices, v_join_col, v_sort_col, v_key_col, v_log_val, v_clist_mssql, v_clist_mssql2 FROM UI_CTRL_VIEW WHERE v_screen_screen_id = 7364 ORDER BY v_window_order ASC, v_ctrl_order ASC
-------Bind SQL-------
SELECT (SELECT SR.str_text FROM STR_RESOURCE SR WHERE SR.str_id = UI_CTRL_VIEW.v_str_id AND SR.lang_id = :s_0 AND SR.product_type = :s_1 AND SR.resource_type = :s_2) as v_title_default, v_win_window_id, v_ctrl_order, v_ctrl_group, v_ctrl_type, v_help_id, v_char_cpy, v_mask, v_tab_order, v_grid_order, v_pos_v, v_pos_h, v_siz_h, v_siz_w, v_flags, v_validation, v_validation_struct_id, v_filter, v_table_name, v_column_name, v_column_type, v_total_width, v_decimal_places, v_lookup_descr_ctrlid, v_forkey_lookup_table, v_forkey_lookup_column, v_descr_column_name, v_clist_table_name, v_clist_column_list, v_clist_where, v_value_choices, v_join_col, v_sort_col, v_key_col, v_log_val, v_clist_mssql, v_clist_mssql2 FROM UI_CTRL_VIEW WHERE v_screen_screen_id = :n_3 ORDER BY v_window_order ASC, v_ctrl_order ASC
---Bind Var : Value---
Bind Var: :s_0 Value: en
Bind Var: :s_1 Value: APP
Bind Var: :s_2 Value: UICONTROLTITLE
Bind Var: :n_3 Value: 7364
-------------------------
07/31/26 09:50:06 Port 50420: [Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denied on the object 'UI_CTRL_USER_VIEW', database 'QADEPLOY', schema 'emsdba'.
07/31/26 09:50:06 Port 50420: [thread_id=0000021F1FDA3A60] sql_select: get_scrn_curs26394
SELECT v_win_window_id, v_ctrl_order, v_title_user, v_flags, v_filter, v_clist_list_type, v_validate_in_list, v_custom_scriptname FROM UI_CTRL_USER_VIEW WHERE v_screen_screen_id = 7364 ORDER BY v_window_order ASC, v_ctrl_order ASC
-------Bind SQL-------
SELECT v_win_window_id, v_ctrl_order, v_title_user, v_flags, v_filter, v_clist_list_type, v_validate_in_list, v_custom_scriptname FROM UI_CTRL_USER_VIEW WHERE v_screen_screen_id = :n_0 ORDER BY v_window_order ASC, v_ctrl_order ASC
---Bind Var : Value---
Bind Var: :n_0 Value: 7364
-------------------------
07/31/26 09:51:37 Port 50420: SQLDELAY -20- [thread_id=0000021F1FDA3A60]: SELECT LOC_loc_code, loc_year, loc_month, max(row_id) as maxRowID, max(x_datetime_insert) as maxDateTimeInsert,sum(pm_ords_opened) as pmOrdersOpened, sum(pm_ords_closed) as pmOrdersClosed, sum(qty_pm_labor_hrs) as XXFLT1202_qtyPmLaborHours, sum(value_pm_labor) as XXFLT1202_valuePmLabor, sum(value_pm_parts) as XXFLT1202_valuePmParts, sum(value_pm_coml_labor) as XXFLT1202_valuePmCmlLabor, sum(value_pm_coml_parts) as XXFLT1202_valuePmCmlParts, sum(repr_ords_opened) as repairOrdersOpened, sum(repr_ords_closed) as repairOrdersClosed, sum(qty_repair_labor_hrs) as XXFLT1202_repairLaborHours, sum(value_repair_labor) as XXFLT1202_valueRepairLabor, sum(value_repair_parts) as XXFLT1202_valueRepairParts, sum(value_repr_cml_labor) as XXFLT1202_valueRepairCmlLabor, sum(value_repr_cml_parts) as XXFLT1202_valueRepairCmlParts, sum(repr_tasks_done) as repairTasksDone, sum(down_hours_closed) as XXFLT1202_downHoursClosed, sum(qty_comeback_tasks) as qtyComebackTasks, sum(qty_indir_labor_hrs) as XXFLT1202_qtyIndirectLaborHours, sum(value_indirect_labor) as XXFLT1202_valueIndirectLabor, sum(value_indirect_parts) as XXFLT1202_valueIndirectParts, sum(value_parts_received) as XXFLT1202_valuePartsReceived, sum(value_parts_trans_in) as XXFLT1202_valuePartsTransferIn, sum(value_parts_trf_out) as XXFLT1202_valuePartsTransferOut, sum(value_parts_adj_dol) as XXFLT1202_valuePartsAdjustment, sum(qty_parts_recvd_late) as XXFLT1402_qtyPartsReceivedLate, sum(parts_tot_days_late) as partsTotalDaysLate, sum(value_parts_issued) as XXFLT1202_valuePartsIssued, sum(inv_rb_ords_opened) as invRebuildOrdersOpened, sum(inv_rb_ords_closed) as invRebuildOrdersClosed, sum(qty_inv_rb_labor_hrs) as XXFLT1202_invRebuildLaborHours, sum(value_inv_rb_labor) as XXFLT1202_valueRebuildLabor, sum(value_inv_rb_parts) as XXFLT1202_valueRebuildParts, sum(value_inv_rb_cml_labor) as XXFLT1202_valueRebuildCmlLabor, sum(value_inv_rb_cml_parts) as XXFLT1202_valueRebuildCmlParts FROM FAC_MAIN_EVENT WHERE APP_id = 'fa-eam-rls01:50420' group by LOC_loc_code, loc_year, loc_month order by LOC_loc_code, loc_year desc, loc_month desc
07/31/26 09:51:37 Port 50420: SQLDELAYTOTAL -20- [thread_id=0000021F1FDA3A60]: SELECT LOC_loc_code, loc_year, loc_month, max(row_id) as maxRowID, max(x_datetime_insert) as maxDateTimeInsert,sum(pm_ords_opened) as pmOrdersOpened, sum(pm_ords_closed) as pmOrdersClosed, sum(qty_pm_labor_hrs) as XXFLT1202_qtyPmLaborHours, sum(value_pm_labor) as XXFLT1202_valuePmLabor, sum(value_pm_parts) as XXFLT1202_valuePmParts, sum(value_pm_coml_labor) as XXFLT1202_valuePmCmlLabor, sum(value_pm_coml_parts) as XXFLT1202_valuePmCmlParts, sum(repr_ords_opened) as repairOrdersOpened, sum(repr_ords_closed) as repairOrdersClosed, sum(qty_repair_labor_hrs) as XXFLT1202_repairLaborHours, sum(value_repair_labor) as XXFLT1202_valueRepairLabor, sum(value_repair_parts) as XXFLT1202_valueRepairParts, sum(value_repr_cml_labor) as XXFLT1202_valueRepairCmlLabor, sum(value_repr_cml_parts) as XXFLT1202_valueRepairCmlParts, sum(repr_tasks_done) as repairTasksDone, sum(down_hours_closed) as XXFLT1202_downHoursClosed, sum(qty_comeback_tasks) as qtyComebackTasks, sum(qty_indir_labor_hrs) as XXFLT1202_qtyIndirectLaborHours, sum(value_indirect_labor) as XXFLT1202_valueIndirectLabor, sum(value_indirect_parts) as XXFLT1202_valueIndirectParts, sum(value_parts_received) as XXFLT1202_valuePartsReceived, sum(value_parts_trans_in) as XXFLT1202_valuePartsTransferIn, sum(value_parts_trf_out) as XXFLT1202_valuePartsTransferOut, sum(value_parts_adj_dol) as XXFLT1202_valuePartsAdjustment, sum(qty_parts_recvd_late) as XXFLT1402_qtyPartsReceivedLate, sum(parts_tot_days_late) as partsTotalDaysLate, sum(value_parts_issued) as XXFLT1202_valuePartsIssued, sum(inv_rb_ords_opened) as invRebuildOrdersOpened, sum(inv_rb_ords_closed) as invRebuildOrdersClosed, sum(qty_inv_rb_labor_hrs) as XXFLT1202_invRebuildLaborHours, sum(value_inv_rb_labor) as XXFLT1202_valueRebuildLabor, sum(value_inv_rb_parts) as XXFLT1202_valueRebuildParts, sum(value_inv_rb_cml_labor) as XXFLT1202_valueRebuildCmlLabor, sum(value_inv_rb_cml_parts) as XXFLT1202_valueRebuildCmlParts FROM FAC_MAIN_EVENT WHERE APP_id = 'fa-eam-rls01:50420' group by LOC_loc_code, loc_year, loc_month order by LOC_loc_code, loc_year desc, loc_month desc
07/31/26 09:51:37 Port 50420: SQLDELAY -48- [thread_id=0000000000000000]: SELECT app_id, app_ip, app_port, app_process_id, started_datetime, cmd_restart, cmd_restart_time, cmd_logging, max_conn_allow, cur_conn_count, max_conn_count, cur_db_conn, verbose_log_level, datetime_expire_verbose_log, clear_caches FROM appmon_apps WHERE app_ip = UPPER('fa-eam-rls01') AND app_port = 50420 AND app_status = 'ACTIVE'07/31/26 09:51:37 Port 50420: SQLDELAYTOTAL -48- [thread_id=0000000000000000]: SELECT app_id, app_ip, app_port, app_process_id, started_datetime, cmd_restart, cmd_restart_time, cmd_logging, max_conn_allow, cur_conn_count, max_conn_count, cur_db_conn, verbose_log_level, datetime_expire_verbose_log, clear_caches FROM appmon_apps WHERE app_ip = UPPER('fa-eam-rls01') AND app_port = 50420 AND app_status = 'ACTIVE'07/31/26 14:08:30 Port 50420: SQLDELAY -164- [thread_id=0000021F2156C330]: UPDATE EQUIP_DUE_PM_TEMP SET pm_meter_1_override = (SELECT meter_override FROM CLA_METERS WHERE CLA_METERS.CLASS_class_code = EQUIP_DUE_PM_TEMP.CLASS_class_code AND CLA_METERS.meter_type = EQUIP_DUE_PM_TEMP.meter_1_type) WHERE unique_num = 64964 AND (pm_prog_type = 'CLASS' OR (pm_prog_type = 'BOTH' AND pm_service IN (SELECT TASK_task_code FROM CLA_PMSERV WHERE CLA_PMSERV.class_class_code = EQUIP_DUE_PM_TEMP.CLASS_class_code))) AND pm_meter_1_override = 0
07/31/26 14:08:30 Port 50420: SQLDELAYTOTAL -164- [thread_id=0000021F2156C330]: UPDATE EQUIP_DUE_PM_TEMP SET pm_meter_1_override = (SELECT meter_override FROM CLA_METERS WHERE CLA_METERS.CLASS_class_code = EQUIP_DUE_PM_TEMP.CLASS_class_code AND CLA_METERS.meter_type = EQUIP_DUE_PM_TEMP.meter_1_type) WHERE unique_num = 64964 AND (pm_prog_type = 'CLASS' OR (pm_prog_type = 'BOTH' AND pm_service IN (SELECT TASK_task_code FROM CLA_PMSERV WHERE CLA_PMSERV.class_class_code = EQUIP_DUE_PM_TEMP.CLASS_class_code))) AND pm_meter_1_override = 0
07/31/26 15:21:40 Port 50420: SQLDELAY -134- [thread_id=0000021F2224D020]: DELETE FROM EQUIP_DUE_PM WHERE unique_num = 64965
07/31/26 15:21:40 Port 50420: SQLDELAYTOTAL -134- [thread_id=0000021F2224D020]: DELETE FROM EQUIP_DUE_PM WHERE unique_num = 64965
07/31/26 15:21:40 Port 50420: SQLDELAY -24- [thread_id=0000000000000000]: DELETE FROM EQUIP_DUE_PM WHERE x_datetime_insert <= '07/01/2026'
07/31/26 15:21:40 Port 50420: SQLDELAYTOTAL -24- [thread_id=0000000000000000]: DELETE FROM EQUIP_DUE_PM WHERE x_datetime_insert <= '07/01/2026'