Purpose (problem description)

When using 'Drop Analysis Results' from the Execute tab in CAST Management Studio (CMS) the analysis results are not dropped.

See the screenshot below for the location of this functionality in CMS. It is also documented here: CMS - Drop Analysis Results


Observed in CAST AIP
Release
Yes/No
8.3.x(tick)
Observed on RDBMS
RDBMS
Yes/No
CSS(tick)

Step by Step scenario

  1. Run the 'Drop Analysis Results' action in the Execute tab of CMS
  2. Verify in Enlighten that the analysis results are not dropped
Action Plan

Perform the below actions when the 'Drop Analysis Results' action in the Execute tab of CMS is not working properly:

  1. Ensure that you have a backup of your CAST databases
  2. Identify the project id of the user project which is trying to be removed by using this page: SQL Queries - CAST Knowledge Base - Queries on User Project - How to get User Project ID
  3. Run the following query on the local database to drop the analysis results (this query does not return any useful information):

    SELECT project_delete(<project_id IDENTIFIED above>);
  4. Open Enlighten to verify that the objects associated with the project are no longer present
  5. If the above steps do not solve your issue contact CAST Technical Support. with the following Relevant input

 

Relevant input

  • CAST Support Tool (CST) - alias Sherlock export with the following options CAST Bases Checker, Export Logs, Export Configuration files, Export Computer Environment, Export CAST Bases with Management Base, Knowledge Base.
  • Detailed explanation of the problem
  • Screenshots from Enlighten showing the specific objects which are not being deleted after following the steps above. Also please provide the project_id associated with this object which was attempted to be deleted with the steps in the action plan (used in the proejct_delete query above).

Notes/comments

Ticket #11096

Related Pages