File: C:\AssetWorks\FASuite\main-ms\Logs\202607\20260717\AppServer\50420\sqlerr.log
07/17/26 04:36:14 Port 50420: SQLDELAY -7- [thread_id=000002EF537B9690]: 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/17/26 04:36:14 Port 50420: SQLDELAY -23- [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/17/26 04:36:14 Port 50420: SQLDELAYTOTAL -23- [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/17/26 04:36:14 Port 50420: SQLDELAYTOTAL -7- [thread_id=000002EF537B9690]: 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/17/26 08:17:03 Port 50420: SQLDELAY -214- [thread_id=000002EF549B5600]: INSERT INTO EQUIP_DUE_PM (X_USERID_INSERT, unique_num, EQ_equip_no, CLASS_class_code, CLASS_class_stds, LOC_assign_pm_loc, DEPT_dept_code, DEPT_pm_notify_dept, manufacturer, model, year, description, pm_prog_type, pm_service, JOBSTD_std_job_code, TASK_task_code, pm_shift, due_type, next_pm_sched_date, pm_meter_1_override, pm_meter_2_override, last_pm_meter_1, last_pm_meter_2, last_pm_start_date, last_meter_1_date, last_meter_2_date, last_meter_1_read, last_meter_2_read, std_hours, prev_meter_1, prev_meter_2, current_meter_1, current_meter_2, meter_1_due_at, meter_2_due_at, days_late, meter_1_late, meter_2_late, exceptions, pm_fuel_override, pm_fuel_since_last, last_fuel_date, last_yardck_datetime, yardck_avail_repair, meter_1_type, meter_2_type, meter1_over_datediff, meter2_over_datediff, fuel_over_datediff) SELECT 'AMACK', unique_num, EQ_equip_no, CLASS_class_code, CLASS_class_stds, LOC_assign_pm_loc, DEPT_dept_code, ISNULL(DEPT_pm_notify_dept, DEPT_dept_code), manufacturer, model, year, description, pm_prog_type, pm_service, JOBSTD_std_job_code, TASK_task_code, pm_shift, 'DATE', next_pm_sched_date, pm_meter_1_override, pm_meter_2_override, last_pm_meter_1, last_pm_meter_2, last_pm_start_date, last_meter_1_date, last_meter_2_date, last_meter_1_read, last_meter_2_read, 0.0, prev_meter_1, prev_meter_2, last_meter_1_read - prev_meter_1, last_meter_2_read - prev_meter_2, (last_pm_meter_1 + pm_meter_1_override - prev_meter_1), (last_pm_meter_2 + pm_meter_2_override - prev_meter_2), DATEDIFF(day, next_pm_sched_date, getdate()), (last_meter_1_read - (last_pm_meter_1 + pm_meter_1_override)), (last_meter_2_read - (last_pm_meter_2 + pm_meter_2_override)), exceptions, isnull(pm_fuel_override,0), pm_fuel_since_last, last_fuel_date, last_yardck_datetime, yardck_avail_repair, meter_1_type, meter_2_type, meter1_over_datediff, meter2_over_datediff, fuel_over_datediff FROM EQUIP_DUE_PM_TEMP WHERE EQUIP_DUE_PM_TEMP.unique_num = 64781 AND next_pm_sched_date IS NOT NULL AND next_pm_sched_date <= '07/17/2026' AND PM_PROG_TYPE <> 'SCHEDULED JOB'
07/17/26 08:17:03 Port 50420: SQLDELAYTOTAL -214- [thread_id=000002EF549B5600]: INSERT INTO EQUIP_DUE_PM (X_USERID_INSERT, unique_num, EQ_equip_no, CLASS_class_code, CLASS_class_stds, LOC_assign_pm_loc, DEPT_dept_code, DEPT_pm_notify_dept, manufacturer, model, year, description, pm_prog_type, pm_service, JOBSTD_std_job_code, TASK_task_code, pm_shift, due_type, next_pm_sched_date, pm_meter_1_override, pm_meter_2_override, last_pm_meter_1, last_pm_meter_2, last_pm_start_date, last_meter_1_date, last_meter_2_date, last_meter_1_read, last_meter_2_read, std_hours, prev_meter_1, prev_meter_2, current_meter_1, current_meter_2, meter_1_due_at, meter_2_due_at, days_late, meter_1_late, meter_2_late, exceptions, pm_fuel_override, pm_fuel_since_last, last_fuel_date, last_yardck_datetime, yardck_avail_repair, meter_1_type, meter_2_type, meter1_over_datediff, meter2_over_datediff, fuel_over_datediff) SELECT 'AMACK', unique_num, EQ_equip_no, CLASS_class_code, CLASS_class_stds, LOC_assign_pm_loc, DEPT_dept_code, ISNULL(DEPT_pm_notify_dept, DEPT_dept_code), manufacturer, model, year, description, pm_prog_type, pm_service, JOBSTD_std_job_code, TASK_task_code, pm_shift, 'DATE', next_pm_sched_date, pm_meter_1_override, pm_meter_2_override, last_pm_meter_1, last_pm_meter_2, last_pm_start_date, last_meter_1_date, last_meter_2_date, last_meter_1_read, last_meter_2_read, 0.0, prev_meter_1, prev_meter_2, last_meter_1_read - prev_meter_1, last_meter_2_read - prev_meter_2, (last_pm_meter_1 + pm_meter_1_override - prev_meter_1), (last_pm_meter_2 + pm_meter_2_override - prev_meter_2), DATEDIFF(day, next_pm_sched_date, getdate()), (last_meter_1_read - (last_pm_meter_1 + pm_meter_1_override)), (last_meter_2_read - (last_pm_meter_2 + pm_meter_2_override)), exceptions, isnull(pm_fuel_override,0), pm_fuel_since_last, last_fuel_date, last_yardck_datetime, yardck_avail_repair, meter_1_type, meter_2_type, meter1_over_datediff, meter2_over_datediff, fuel_over_datediff FROM EQUIP_DUE_PM_TEMP WHERE EQUIP_DUE_PM_TEMP.unique_num = 64781 AND next_pm_sched_date IS NOT NULL AND next_pm_sched_date <= '07/17/2026' AND PM_PROG_TYPE <> 'SCHEDULED JOB'
07/17/26 08:17:03 Port 50420: SQLDELAY -34- [thread_id=000002EF546618A0]: INSERT INTO EQUIP_DUE_PM (X_USERID_INSERT, unique_num, EQ_equip_no, CLASS_class_code, CLASS_class_stds, LOC_assign_pm_loc, DEPT_dept_code, DEPT_pm_notify_dept, manufacturer, model, year, description, pm_prog_type, pm_service, JOBSTD_std_job_code, TASK_task_code, pm_shift, due_type, next_pm_sched_date, pm_meter_1_override, pm_meter_2_override, last_pm_meter_1, last_pm_meter_2, last_pm_start_date, last_meter_1_date, last_meter_2_date, last_meter_1_read, last_meter_2_read, std_hours, prev_meter_1, prev_meter_2, current_meter_1, current_meter_2, meter_1_due_at, meter_2_due_at, days_late, meter_1_late, meter_2_late, exceptions, pm_fuel_override, pm_fuel_since_last, last_fuel_date, last_yardck_datetime, yardck_avail_repair, meter_1_type, meter_2_type, meter1_over_datediff, meter2_over_datediff, fuel_over_datediff) SELECT 'AMACK', unique_num, EQ_equip_no, CLASS_class_code, CLASS_class_stds, LOC_assign_pm_loc, DEPT_dept_code, ISNULL(DEPT_pm_notify_dept, DEPT_dept_code), manufacturer, model, year, description, pm_prog_type, pm_service, JOBSTD_std_job_code, TASK_task_code, pm_shift, 'DATE', next_pm_sched_date, pm_meter_1_override, pm_meter_2_override, last_pm_meter_1, last_pm_meter_2, last_pm_start_date, last_meter_1_date, last_meter_2_date, last_meter_1_read, last_meter_2_read, 0.0, prev_meter_1, prev_meter_2, last_meter_1_read - prev_meter_1, last_meter_2_read - prev_meter_2, (last_pm_meter_1 + pm_meter_1_override - prev_meter_1), (last_pm_meter_2 + pm_meter_2_override - prev_meter_2), DATEDIFF(day, next_pm_sched_date, getdate()), (last_meter_1_read - (last_pm_meter_1 + pm_meter_1_override)), (last_meter_2_read - (last_pm_meter_2 + pm_meter_2_override)), exceptions, isnull(pm_fuel_override,0), pm_fuel_since_last, last_fuel_date, last_yardck_datetime, yardck_avail_repair, meter_1_type, meter_2_type, meter1_over_datediff, meter2_over_datediff, fuel_over_datediff FROM EQUIP_DUE_PM_TEMP WHERE EQUIP_DUE_PM_TEMP.unique_num = 64782 AND next_pm_sched_date IS NOT NULL AND next_pm_sched_date <= '07/17/2026' AND PM_PROG_TYPE <> 'SCHEDULED JOB'
07/17/26 08:17:03 Port 50420: SQLDELAYTOTAL -34- [thread_id=000002EF546618A0]: INSERT INTO EQUIP_DUE_PM (X_USERID_INSERT, unique_num, EQ_equip_no, CLASS_class_code, CLASS_class_stds, LOC_assign_pm_loc, DEPT_dept_code, DEPT_pm_notify_dept, manufacturer, model, year, description, pm_prog_type, pm_service, JOBSTD_std_job_code, TASK_task_code, pm_shift, due_type, next_pm_sched_date, pm_meter_1_override, pm_meter_2_override, last_pm_meter_1, last_pm_meter_2, last_pm_start_date, last_meter_1_date, last_meter_2_date, last_meter_1_read, last_meter_2_read, std_hours, prev_meter_1, prev_meter_2, current_meter_1, current_meter_2, meter_1_due_at, meter_2_due_at, days_late, meter_1_late, meter_2_late, exceptions, pm_fuel_override, pm_fuel_since_last, last_fuel_date, last_yardck_datetime, yardck_avail_repair, meter_1_type, meter_2_type, meter1_over_datediff, meter2_over_datediff, fuel_over_datediff) SELECT 'AMACK', unique_num, EQ_equip_no, CLASS_class_code, CLASS_class_stds, LOC_assign_pm_loc, DEPT_dept_code, ISNULL(DEPT_pm_notify_dept, DEPT_dept_code), manufacturer, model, year, description, pm_prog_type, pm_service, JOBSTD_std_job_code, TASK_task_code, pm_shift, 'DATE', next_pm_sched_date, pm_meter_1_override, pm_meter_2_override, last_pm_meter_1, last_pm_meter_2, last_pm_start_date, last_meter_1_date, last_meter_2_date, last_meter_1_read, last_meter_2_read, 0.0, prev_meter_1, prev_meter_2, last_meter_1_read - prev_meter_1, last_meter_2_read - prev_meter_2, (last_pm_meter_1 + pm_meter_1_override - prev_meter_1), (last_pm_meter_2 + pm_meter_2_override - prev_meter_2), DATEDIFF(day, next_pm_sched_date, getdate()), (last_meter_1_read - (last_pm_meter_1 + pm_meter_1_override)), (last_meter_2_read - (last_pm_meter_2 + pm_meter_2_override)), exceptions, isnull(pm_fuel_override,0), pm_fuel_since_last, last_fuel_date, last_yardck_datetime, yardck_avail_repair, meter_1_type, meter_2_type, meter1_over_datediff, meter2_over_datediff, fuel_over_datediff FROM EQUIP_DUE_PM_TEMP WHERE EQUIP_DUE_PM_TEMP.unique_num = 64782 AND next_pm_sched_date IS NOT NULL AND next_pm_sched_date <= '07/17/2026' AND PM_PROG_TYPE <> 'SCHEDULED JOB'
07/17/26 08:17:14 Port 50420: SQLDELAY -6- [thread_id=000002EF546618A0]: UPDATE EQUIP_DUE_PM SET std_hours = (SELECT qty_labor_hours FROM CLASS_TASK WHERE CLASS_TASK.CLASS_class_code = EQUIP_DUE_PM.CLASS_class_stds AND CLASS_TASK.TASK_task_code = EQUIP_DUE_PM.pm_service) WHERE unique_num = 64782
07/17/26 08:17:14 Port 50420: SQLDELAYTOTAL -6- [thread_id=000002EF546618A0]: UPDATE EQUIP_DUE_PM SET std_hours = (SELECT qty_labor_hours FROM CLASS_TASK WHERE CLASS_TASK.CLASS_class_code = EQUIP_DUE_PM.CLASS_class_stds AND CLASS_TASK.TASK_task_code = EQUIP_DUE_PM.pm_service) WHERE unique_num = 64782
07/17/26 08:17:14 Port 50420: SQLDELAY -9- [thread_id=000002EF549B5600]: UPDATE EQUIP_DUE_PM SET std_hours = (SELECT qty_labor_hours FROM CLASS_TASK WHERE CLASS_TASK.CLASS_class_code = EQUIP_DUE_PM.CLASS_class_stds AND CLASS_TASK.TASK_task_code = EQUIP_DUE_PM.pm_service) WHERE unique_num = 64781
07/17/26 08:17:14 Port 50420: SQLDELAYTOTAL -9- [thread_id=000002EF549B5600]: UPDATE EQUIP_DUE_PM SET std_hours = (SELECT qty_labor_hours FROM CLASS_TASK WHERE CLASS_TASK.CLASS_class_code = EQUIP_DUE_PM.CLASS_class_stds AND CLASS_TASK.TASK_task_code = EQUIP_DUE_PM.pm_service) WHERE unique_num = 64781