Bad query from job "Service Analytics RCA for Change Request" causing huge results and performance degradationDescription "Service Analytics RCA for Change Request" scheduled job runs queries to retrieve affected Business Services for Change Requests. However, the queries are malformed causing larger results than expected leading to additional overhead downstream leading to instance performance degradation. Sample bad query logged to node log: ============ 2021-01-20 08:47:32 (830) worker.6 worker.6 txid=1c84b5861b75 WARNING *** WARNING *** Large Table: Table handling an extremely large result set: 104429Query that got us here is: TABLENAME = task_ci ENCODED_QUERY = ci_itemIN4b5a542bdb0dc700b3613caf9d96197b,f3286fa1db1713c41ddee3a84b96198c^sys_class_name=change_request ============ Downstream query that's affected and runs slowly:============ 2021-01-20 08:48:02 (155) worker.6 worker.6 txid=1c84b5861b75 Time: 0:00:21.649 id: *******[glide.16] (connpid=6907405) for: SELECT task0.`sys_id` FROM task task0 WHERE task0.`sys_class_name` IN ('change_request','change_request_imac') AND (task0.`sys_id` IN ('e65d140c1b1a8090c6a34267cc4bcb79' , '0affc3811b8a9c18c1b854252a4bcb44'... ============Steps to Reproduce 1. Have a Business Service that's linked to many Incidents. Ex: 100k 2. Create a Change Request and link the same Business Service to the CHG. 3. Run the "Service Analytics RCA for Change Request".WorkaroundDisable the "Service Analytics RCA for Change Request" scheduled job. Related Problem: PRB1460159