CMS Snapshot Analysis - Compute Snapshot - Performance Issue - Stuck at Compute Metrics - LOCAL_INIT_IFPUG

This page outlines a performance issue where your snapshot is stuck at the Compute metrics step.
If you query in the DSS_History table fr local base, you will find the the below procedure has started execution but never ended and leads to the performance issue.
Start {LOCAL_INIT_IFPUG} (-3 60001 60002 69004)

The LOCAL_INIT_IFPUG SP is calling another SP, DSSAPP_SCOPE_INIT_IFPUG which is stuck.

1. Run Snapshot
2. Snapshot stuck at Compute Snapshot step for infinite time

1. Run the below scripts on KB

   delete
     from SYS_SITE_OPTIONS 
    where OPTION_NAME = 'TCC Consider Only Tables for Transaction IsInput and DataFunction IsInternal';
    
   insert into SYS_SITE_OPTIONS
              (OPTION_NAME, OPTION_VALUE)
       values ('TCC Consider Only Tables for Transaction IsInput and DataFunction IsInternal', 1);

2. Run the snapshot again.

Ticket # 4045