Performance issue in cleaning the lifecycle reportDescriptionA performance issue in the 'SAM - Generate Data For Software Lifecycle Report' exists due to clearing the 'lifecycle' column reference on the 'cmdb_sam_sw_install' table twice.At the beginning of the job, the code deletes the old lifecycle report records. Then, a second query is executed to clear the 'lifecycle' column on 'cmdb_sam_sw_install' table. This second query is unnecessary, however, because deleting the lifecycle report records triggers a cascade delete on the install table reference. This double clearing results in extra slowdown.Steps to Reproduce (This issue no longer exists in Xanadu)Customer had 55M installs, 5M associated to lifecyclesLifecycle job took 2.5 hours in the initial clean upAfter testing the fix (removing the second clearing query), the clean up time is down to 30 minutesWorkaroundIn the SamRepopulateSoftwareLifecycleReport script include, please comment out the highlighted line below "this.resetInstallLifecycleColumn();" in the code. Once removed, customer should see performance improvements. Support may also create an update set.Related Problem: PRB1733734