CMS Snapshot Analysis - Compute Snapshot - Performance issue - Snapshot stuck while IFPUG graph computation in DssEngine

If your snapshot is stuck at the compute step and the DssEngine log is also stuck at the following then this page will help you troubleshoot the issue if one of the index is missing.
Example given is for 7.0.x

2014-07-18 14:03:27.025 Run snapshot...
2014-07-18 14:16:26.052 Run D:\Program Files (x86)\CAST\7.0.10 - SIEBEL_V4.0.5/DssRun.exe -LOCAL_IFPUG_GRAPH

The performance issue is encountered due to one of the missing primary key index on table ObjDsc on your local base.

1. Run Snapshot
2. The snapshot is stuck at "Compute snapshot in 'XXXX_Central' "
3. Check the DssEngine log file to see it is stuck at the step as mentioned in the Description

1. Check your local base and see if this primary key, 'pk_objdsc' is missing. If yes, the solution is to create the missing primary key by running the following query on your local base:

   alter table objdsc add CONSTRAINT pk_objdsc PRIMARY KEY (idobj, inftyp, infsubtyp, blkno, ordnum);

2. After the PK is created you can run the snapshot once again.

NA

This issue is seen in 7.0.10 version and the WA has been tested successfully at support.