Hello cavagnaro,
I see the following requests with the same request id = “11702”
Note: Queue name in my case named = “Facebook Outbound Queue”
2022-02-02T05:01:26.587 Dbg 25030 Database request sent: DAP:‘IXN_DAP_ODBC’(4), request id: ‘11702’, dbchannel stack id: ‘0’, interaction id:‘(null)’, sql statement: [select top 200 id,server_id,parent_id,tenant_id,is_online,is_locked,snapshot_place_id,state,queue,media_type,type,subtype,agent_id,agent_group_id,place_id,place_group_id,submitted_by,received_at,submitted_at,delivered_at,placed_in_queue_at,moved_to_queue_at,workbin,destinations,abandoned_at,scheduled_at,cache,submit_seq,place_in_queue_seq,held_at,assigned_at,completed_at,assigned_to,external_id,priority,service_objective,facebookcommentid,facebookinbufferbeforetarget,facebookinqueueattarget,facebookpostid,twitterinbufferbeforetarget,twitterinqueueattarget,twittergroupid,dms_app_name,flexible_properties from interactions with (updlock) where state = 0 and is_locked = 0 and queue = ‘Facebook Outbound Queue’ and tenant_id = 1 order by received_at, id ]
2022-02-02T05:01:26.587 Dbg 25032 Database request executed: DAP:‘IXN_DAP_ODBC’(4), request id: ‘11702’, dbchannel stack id: ‘0’, interaction id:‘(null)’, sql statement: [select top 200 id,server_id,parent_id,tenant_id,is_online,is_locked,snapshot_place_id,state,queue,media_type,type,subtype,agent_id,agent_group_id,place_id,place_group_id,submitted_by,received_at,submitted_at,delivered_at,placed_in_queue_at,moved_to_queue_at,workbin,destinations,abandoned_at,scheduled_at,cache,submit_seq,place_in_queue_seq,held_at,assigned_at,completed_at,assigned_to,external_id,priority,service_objective,facebookcommentid,facebookinbufferbeforetarget,facebookinqueueattarget,facebookpostid,twitterinbufferbeforetarget,twitterinqueueattarget,twittergroupid,dms_app_name,flexible_properties from interactions with (updlock) where state = 0 and is_locked = 0 and queue = ‘Facebook Outbound Queue’ and tenant_id = 1 order by received_at, id ]
2022-02-02T05:01:26.587 Dbg 27124 No interactions selected (connection ID: 4, prototype: 4, request ID: 11702, interaction ID: ‘NULL’)
Thanks in advance