CMS Snapshot Analysis - Update Sources - Performance issues - Unexpected runtime

Purpose

This page will help you to solve problems when the Update Sources step is running for a long time.

To get information about different log files, their locations and to understand and explore log files as per the feature, please refer to CAST Management Studio - Information - How to find logs

For more information, refer to:

Official 8.3 Documentation - Run and validate the analysis
CAST- MS help->How to -> Regular Audience ->Run Analysis only, Generate Snapshot
Information Guides > Information Guides by CAST AIP Component > CMS Snapshot Analysis

Observed in CAST AIP

Release	Yes/No
8.3.x	✅

Observed on RDBMS

RDBMS	Yes/No
CSS4	✅
CSS3	✅

Step by Step Scenario

CAST-MS

Package and deliver source code.
Accept Delivery and set as current version.
Run analysis snapshot
Observe that Update Sources step is stuck.

AIP Console

Add a new version.
Observe that Prepare Analysis Data Step is stuck

Action Plan

Run the below queries to check for duplicates in the ObJFilRef table -

select k.idkey, count(ofr.idobj) from vermeg_local.keys k join vermeg_local.objfilref ofr on ofr.idobj = k.idkey where k.objtyp in (1020127, 1020030) group by k.idkey having count(ofr.idobj)>1 order by 2 desc


   If the query returns rows, then the issue occurs because there are duplicates in the Objfil ref table.   
   1. To solve the issue you need to patch the function, [fix\_AMT\_processLinks.sql](https://doc-data.castsoftware.com/TG/attachments/566534198/566534197.sql), in the file - <CAST Installation>\InstallScripts\CastStorageService\APPW\AMT\_Saving.sql file.
   2. The Create function also needs to be run on the local schema directly.
   3. After which you can trigger snapshot.
   4. Analysis can be skipped.
   5. From AIP Versions <=8.3.38, we need to manually clean up the ObJFilRef table using the below queries -

      ```sql
update ObjFilRef
  set IdObj = -IdObj;

insert into ObjFilRef (IdObj, IdFilRef, IdFil)
select distinct -IdObj, IdFilRef, IdFil
  from ObjFilRef;

delete from ObjFilRef
where IdObj < 0;

If you do not find the information you are looking for or solution for your problem, in this page, contact CAST Technical Support with the Relevant input listed below to help CAST Support team to investigate your problem or procure the required information.

Relevant Input

Sherlock (CAST Support Tool (CST) - alias Sherlock) : Option to select are Export Logs and Export Database (MB only). Since issue occurs during the snapshot computation, source code is not requested because analysis is already done.

Notes/comments

Ticket # 31412

Related Pages