File: C:\AssetWorks\FASuite\main-ms\Logs\202607\20260723\AppServer\50420\sqlerr.log
07/23/26 04:50:17 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'07/23/26 04:50:17 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'07/23/26 04:51:05 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/23/26 04:51:05 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/23/26 12:40:23 Port 50420: SQLDELAY -41- [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/23/26 12:40:23 Port 50420: SQLDELAYTOTAL -41- [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/23/26 15:47:36 Port 50420: SQLDELAY -107- [thread_id=0000000000000000]: DELETE FROM EQUIP_DUE_PM WHERE x_datetime_insert <= '06/23/2026'
07/23/26 15:47:36 Port 50420: SQLDELAYTOTAL -107- [thread_id=0000000000000000]: DELETE FROM EQUIP_DUE_PM WHERE x_datetime_insert <= '06/23/2026'
07/23/26 15:51:04 Port 50420: SQLDELAY -208- [thread_id=0000000000000000]: DELETE FROM EQUIP_DUE_PM_TEMP WHERE x_datetime_insert <= '06/23/2026'
07/23/26 15:51:04 Port 50420: SQLDELAYTOTAL -208- [thread_id=0000000000000000]: DELETE FROM EQUIP_DUE_PM_TEMP WHERE x_datetime_insert <= '06/23/2026'
07/23/26 23:34:20 Port 50420: SQLDELAY -17- [thread_id=0000000000000000]: UPDATE appmon_apps SET updated_datetime = NOW(*), cur_conn_count = 0, max_conn_count = 0, cur_db_conn = 2, cmd_logging = 'N', clear_caches = 'N' WHERE app_ip = UPPER('fa-eam-rls01') AND app_port = 50420 AND app_status = 'ACTIVE'07/23/26 23:34:20 Port 50420: SQLDELAYTOTAL -17- [thread_id=0000000000000000]: UPDATE appmon_apps SET updated_datetime = NOW(*), cur_conn_count = 0, max_conn_count = 0, cur_db_conn = 2, cmd_logging = 'N', clear_caches = 'N' WHERE app_ip = UPPER('fa-eam-rls01') AND app_port = 50420 AND app_status = 'ACTIVE'