File: C:\AssetWorks\FASuite\QA-Mario-MS\Logs\202607\20260714\AppServer\50001\sqlerr.log

• 07/14/26 12:50:36 Port 50001: SQLDELAY -7- [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 = 50001 AND app_status = 'ACTIVE'

• 07/14/26 12:50:36 Port 50001: SQLDELAYTOTAL -7- [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 = 50001 AND app_status = 'ACTIVE'

• 07/14/26 12:51:35 Port 50001: SQLDELAY -50- [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 = 50001 AND app_status = 'ACTIVE'

• 07/14/26 12:51:35 Port 50001: SQLDELAYTOTAL -50- [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 = 50001 AND app_status = 'ACTIVE'

• 07/14/26 12:51:35 Port 50001: SQLDELAY -27- [thread_id=0000020FF4E8E8F0]: 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:50001' group by LOC_loc_code, loc_year, loc_month order by LOC_loc_code, loc_year desc, loc_month desc

• 07/14/26 12:51:35 Port 50001: SQLDELAYTOTAL -27- [thread_id=0000020FF4E8E8F0]: 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:50001' group by LOC_loc_code, loc_year, loc_month order by LOC_loc_code, loc_year desc, loc_month desc