On Premise: Queries to find out if there are events (sysevent) pending to be processed - Support and Troubleshooting

On Premise: Queries to find out if there are events (sysevent) pending to be processed Issue .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } On Premise: These SQL queries can be used by your Database Administrators to find out if there are events pending to be processed

Release .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Xanadu or higher

Resolution .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } 1. Run the following query to verify if the event process 0, AIS Index Event Processor or text index events process job is running.

select count(*),name,state,system_id,claimed_by,trigger_type from sys_trigger where name like '%Index%' group by name,state,system_id,claimed_by,trigger_type

2. The following query shows sysevent shards:

select table_name,valid_from,valid_to from sys_table_rotation_schedule where table_name like 'sysevent00%%' order by valid_from desc

This query shows which shard is the active one:

select table_name, valid_from, valid_to FROM sys_table_rotation_schedule WHERE valid_from now() and table_name like 'sysevent0%'

3. These queries returns the events pending to be processed in each shard:

select queue,state,name,count(1) as ready_queued_cnt from sysevent0000 where state not in ('processed','error','transferred') group by queue,state,name order by ready_queued_cnt desc limit 10

select queue,state,name,count(1) as ready_queued_cnt from sysevent0001 where state not in ('processed','error','transferred') group by queue,state,name order by ready_queued_cnt desc limit 10

select queue,state,name,count(1) as ready_queued_cnt from sysevent0002 where state not in ('processed','error','transferred') group by queue,state,name order by ready_queued_cnt desc limit 10

select queue,state,name,count(1) as ready_queued_cnt from sysevent0003 where state not in ('processed','error','transferred') group by queue,state,name order by ready_queued_cnt desc limit 10

select queue,state,name,count(1) as ready_queued_cnt from sysevent0004 where state not in ('processed','error','transferred') group by queue,state,name order by ready_queued_cnt desc limit 10

select queue,state,name,count(1) as ready_queued_cnt from sysevent0005 where state not in ('processed','error','transferred') group by queue,state,name order by ready_queued_cnt desc limit 10

select queue,state,name,count(1) as ready_queued_cnt from sysevent0006 where state not in ('processed','error','transferred') group by queue,state,name order by ready_queued_cnt desc limit 10