CMS Application - Update CAST Knowledge Base - Links are not removed from CTV_LINKS table

This page outlines the issue you may face when you try to drop the results using the 'Drop Tool results' option from the Update CAST Knowledge Base job, the results do not get dropped in ctv_links table.

1. Launch CMS
2. Select the knowledge base.
3. Add KB job and run CSV
4. The links are not getting deleted from the tool.

"Drop Tool Result" cannot work because all links created by "Update CAST Knowledge Base" have id project, the ID project of the caller.

So, we cannot distinct the link from "Update CAST Knowledge Base" and the link from analyser.

As a workaround follow the below steps to drop the links:

1. Open the pgadmin

2. Run the below query on the local base (KB).

   Query

   delete D_Acc( idAcc, 0,0,0)
   from Acc where ( idcle , idclr ) in (
   select distinct ctv.caller_id,sub1.cob_id as called_id
   from ctv_links ctv, (select distinct cdt.object_id as cob_id,sub.object_id as ss_id 
   from cdt_objects cdt ,( select distinct cdt1.object_id,cdt1.object_name
   from cdt_objects cdt1, cdt_objects cdt2
   where cdt1.object_type_str='Search String'
   and cdt2.object_type_str='Search String'
   and split_part(cdt1.object_name,':',1)=cdt2.object_name) sub
   where cdt.object_name=split_part(sub.object_name,':',2)
   and ((cdt.object_type_str='Cobol Program') or 
   (cdt.object_type_str = 'JCL External Program'))) sub1
   where ctv.called_id=sub1.ss_id )

Impact of issue: Links are not getting dropped from ctv_links table.

Impact after applying solution: Links are getting dropped from ctv_links table.