Scheduled job "Collab Chat - Notify Unread Messages" is running a full table scan to process each record multiple times .Issue <!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Collab Chat - Notify Unread Messages is running a full table scan to process each record multiple times . Symptoms<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Observed the garbage collection is high on the node where this job is running . Logs will show repeated WARNING messages "QueryWarning *** WARNING *** Large Table: Table handling an extremely large result set:" from sys_cs_collab_record table . 2026-05-18 21:12:21 (810) worker.2 worker.2 txid LocalhostTransactionLogger *** Start Background transaction - system, type: other, user: system 2026-05-18 21:12:21 (813) worker.2 worker.2 txid JobExecutor Starting: Collab Chat - Notify Unread Messages.0525d25733f272105cb8a4989d5c7b60, Trigger Type: Daily, Priority: 100, Upgrade Safe: false, Repeat: Name: Collab Chat - Notify Unread Messages Job Context: #Tue Mar 31 14:55:56 PDT 2026 fcDocumentName=Collab Chat - Notify Unread Messages fcDocumentKey=cf9916537f7012107629a6470d866529 fcDocumentClass=sysauto_script fcDocumentScope=53b1b0e79761011018b2fa98c253afcc Script: . 2026-05-18 21:12:23 (398) worker.2 worker.2 txid StopWatch [0:00:00.490] id: <Instance_name>[glide.3 (connpid=164159)] for: DBQuery#loadResultSet[sys_cs_collab_record: collab_chat.state=open^collab_chat.last_sent_messageISNOTEMPTY^ORDERBYDESCcollab_chat.sys_updated_on] 2026-05-18 21:12:23 (398) worker.2 worker.2 txid QueryWarning *** WARNING *** Large Table: Table handling an extremely large result set: 351613 Query that got us here is: TABLENAME = sys_cs_collab_record ENCODED_QUERY = collab_chat.state=open^collab_chat.last_sent_messageISNOTEMPTY^ORDERBYDESCcollab_chat.sys_updated_on . 2026-05-18 21:12:28 (936) worker.2 worker.2 txid StopWatch [0:00:00.470] id: <Instance_name>[glide.25 (connpid=164181)] for: DBQuery#loadResultSet[sys_cs_collab_record: collab_chat.state=open^collab_chat.last_sent_messageISNOTEMPTY^docume nt!=e28670c887b4cb586a5586270cbb3509^document!=1ec1b0003bf4cbd07ce33447f4e45a5b^document!=842078083bb0cb506314d337f4e45a82^document!=26d5f08887f0075809be86270cbb3552^ORDERBYDESCcollab_chat.sys_updated_on] 2026-05-18 21:12:28 (936) worker.2 worker.2 txid QueryWarning *** WARNING *** Large Table: Table handling an extremely large result set: 351609 Query that got us here is: TABLENAME = sys_cs_collab_record ENCODED_QUERY = collab_chat.state=open^collab_chat.last_sent_messageISNOTEMPTY^document!=e28670c887b4cb586a5586270cbb3509^document!=1ec1b0003bf4cbd07ce33447f4e45a5b^document!=842078083bb0cb50631 4d337f4e45a82^document!=26d5f08887f0075809be86270cbb3552^ORDERBYDESCcollab_chat.sys_updated_on . .2026-05-19 13:47:37 (047) worker.2 worker.2 txid SysLog *** WARNING *** Evaluator: com.glide.script.RhinoEcmaError: "isNil" is not defined. sys_script.c97867e71bd0a5d0be7e87bfe54bcb82.script : Line(17) column(0) 14: q = current.addEncodedQuery("u_token!="); 15: } 16: } ==> 17: if (isNil(q)) { 18: alert("Verifique com o Administrador as permissões para acessar essa classe [cmdb_ci_pc_hardware] ..."); 19: q = current.addEncodedQuery("u_token!="); 20: } Stack trace: at sys_script.c97867e71bd0a5d0be7e87bfe54bcb82.script:17 (executeRule) at sys_script.c97867e71bd0a5d0be7e87bfe54bcb82.script:21 at :4 (calculatedFieldValue) at :6 at sys_script_include.8b914851c3b13010fe394f877840dd30.script:239 (sendEmails) at :1 2026-05-19 13:47:37 (073) worker.2 worker.2 txid GlideRecord *** WARNING *** Get for non-existent record: sys_user:<UserID>, initializing 2026-05-19 13:47:43 (232) worker.2 worker.2 txid StopWatch [0:00:00.010] Compacting large row block (file.write: sys_script_include 10000 rows 2609304 saveSize) 2026-05-19 13:47:43 (233) worker.2 worker.2 txid StopWatch [0:00:00.000] Compacting large row block (file.write: sys_script_include 48 rows 981 saveSize) 2026-05-19 13:47:43 (240) worker.2 worker.2 txid StopWatch [0:00:00.007] Expanding large row block (file.read: sys_script_include, 10000 rows, 2609304 dataSize) 2026-05-19 13:47:43 (252) worker.2 worker.2 txid StopWatch [0:00:00.008] Compacting large row block (file.write: sys_script_include 10000 rows 2609304 saveSize) 2026-05-19 13:47:43 (252) worker.2 worker.2 txid StopWatch [0:00:00.000] Expanding large row block (file.read: sys_script_include, 48 rows, 981 dataSize) 2026-05-19 13:47:43 (256) worker.2 worker.2 txid CacheSessionDebug Built cache syscache_script_include with key SYS_SCRIPT_INCLUDE_CACHE_KEY in 5917 2026-05-19 13:47:43 (256) worker.2 worker.2 txid ASystemInclude Loaded the Script Includes cache in 5917 ms (loaded=true, size=10038) 2026-05-19 13:47:43 (311) worker.2 worker.2 txid Transaction *** WARNING *** Long Transaction started at 05/18/26 21:12:21.809, Memory at start was 944,238, Memory is 4,477,557, SQL count is 3,599,600, BR count is now 483,730. 2026-05-19 13:47:43 (311) worker.2 worker.2 txid Transaction *** WARNING *** Transaction cancelled: Available memory is almost depleted 2026-05-19 13:47:43 (455) worker.2 worker.2 txid JobExecutor Completed: Collab Chat - Notify Unread Messages in 16:35:21.506, next occurrence is 2026-05-20 08:00:00, id=0525d25733f272105cb8a4989d5c7b60 tr=11 pr=100 re=0 po=1775030400 la=258376.712 mp=S st=9172187 qc=3599605 2026-05-19 14:26:58 (637) Cleaner-1 LowUsageWarningAction *** WARNING *** TableUsageTracker[usage < 0.5]: table=sys_cs_collab_record, query_hash=1987481570, app_scope=sn_oe_sfs, tx_id , loaded_rows=350853, loaded_bytes=5613648, unused_rows=349341, usage_ratio=0.00, getStorage_calls=1512, getStorage_calls_usage=0.00, rowAt_calls=0, rowAt_calls_usage=0.00, hasNext_calls=1512, hasNext_calls_usage=0.00, next_calls=1512, next_calls_usage=0.00, isTransactionWithScript=true, isTransactionForBusinessRule=false, current_script_table=sysauto_script, current_script_sys_id=<sys_id>, source_script_table=sysauto_script, source_script_sys_id=<sys_id> Release<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Zurich P7a Resolution<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Verify the current version of the "SFS plugin – Omni-Experience Standard Feature Set" (sn-oe-sfs) and upgrade it to 7.3.3. For customers with a large volume of chat data (typically in the millions), recommend cleanup or deletion of old records in sys_cs_collab_record. Suggested deletion criteria: Chats linked to closed recordsChats older than 6 months to 1 yearAny chat data that is no longer required for future access. If performance is impacted, the scheduled job below can be disabled: Collab Chat – Notify Unread Messages Impact of disabling the job: Users will not receive email notifications for unread chat messages from the last 24 hours If the number of records in sys_cs_collab_record is low, upgrading the "SFS plugin – Omni-Experience Standard Feature Set" (sn-oe-sfs) to 7.3.3 should be sufficient to resolve the issue.