File: C:\AssetWorks\FASuite\main-ms\Logs\202606\20260617\AppServer\50420\sqlerr.log
06/17/26 04:18:50 Port 50420: SQLDELAY -30- [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'06/17/26 04:18:50 Port 50420: SQLDELAYTOTAL -30- [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'06/17/26 09:59:31 Port 50420: SQLDELAY -146- [thread_id=0000023BC6F80800]: 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 = 64612 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
06/17/26 09:59:31 Port 50420: SQLDELAYTOTAL -146- [thread_id=0000023BC6F80800]: 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 = 64612 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
06/17/26 11:24:39 Port 50420: SQLDELAY -11- [thread_id=0000023BC62BDF20]: DELETE FROM EQUIP_DUE_PM WHERE unique_num = 64611
06/17/26 11:24:39 Port 50420: SQLDELAYTOTAL -11- [thread_id=0000023BC62BDF20]: DELETE FROM EQUIP_DUE_PM WHERE unique_num = 64611