File: C:\AssetWorks\FASuite\main-ms\Logs\202606\20260616\AppServer\50420\sqlerr.log
06/16/26 04:43:57 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'06/16/26 04:43:57 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'06/16/26 10:36:39 Port 50420: 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 = 50420 AND app_status = 'ACTIVE'06/16/26 10:36:39 Port 50420: 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 = 50420 AND app_status = 'ACTIVE'06/16/26 10:37:31 Port 50420: SQLDELAY -27- [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/16/26 10:37:31 Port 50420: SQLDELAYTOTAL -27- [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/16/26 12:06:52 Port 50420: SQLDELAY -94- [thread_id=0000023BC6F77EC0]: 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 = 64597 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/16/26 12:06:52 Port 50420: SQLDELAYTOTAL -94- [thread_id=0000023BC6F77EC0]: 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 = 64597 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