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