DoSelect SOAP Web Service Calls can cause suspended queries in Service Desk
Article ID: 109906
SUPPORT AUTOMATION- SERVERCA Service Desk Manager - Unified Self ServiceKNOWLEDGE TOOLSCA Service Management - Asset Portfolio ManagementCA Service Management - Service Desk Manager
After upgrading Service Desk to 17.1, DoSelect SOAP Web Service Calls can cause suspended queries in Service Desk. As a consequence Service Desk can become unresponsive because of many database agents getting busy.
See VDBINFO output below:
Agent #17 - (SEL) prov#6628_bpvirtdb_srvr @08/07/2018 09:47:49 with 1 in work SELECT_FULL (db_id=147383) SELECT call_req.open_date, call_req.id, call_req.ref_num, call_req.id FROM call_req ORDER BY call_req.open_date DESC SUSPENDED (10 of 10 recs) PROC(domsrvr) CNT(ServiceDesk)