RCA for change requests - memory issues on busy instances


Description

"Service Analytics RCA for Change Requests" job may run slow and take up node's memory

Steps to Reproduce

We suspect 2 main issues in the RcaITSMDataHook script include:


1. The taskSysIDArr array was keeping duplicate values for no reason that were accumulated until the explosion
2. When the getData function of this script include was called with empty arguments it queried all software with no CIs (installed_on = '')

Workaround

Commit the attached update set to the impacted instance


Related Problem: PRB1433266