Description

This page handles the issue when the source code displayed for an object does not correspond to the object. For example in the below screenshot we can see that the object in violation is FDR_CNF_PKG but the code viewer displays the code for object FDR_CNF_GHP

Observed in CAST AIP

 

Release
Yes/No
8.3.x(tick)
Observed on RDBMS

 

RDBMS
Yes/No
CSS(tick)
Step by Step Scenario
  1. Compute snapshot.
  2. Launch CED.
  3. Go to Investigation - Quality Model Drilldown view.
  4. Select a violated object.
  5. Observe the source code of the violated object.
Action Plan
  1. Get the id of the object from the central schema SQL Queries - CAST Central Base - Queries on Objects - How to get the ID of an object
  2. Get the corresponding id from the local schema by running the following on the central schema

    SELECT site_object_id FROM dss_translation_table 
    WHERE object_id = <id of the object under central schema>

    replace <id of the object under central schema> by the id of the object from the local schema

    Result sample
    243154
  3. Check if the object is part of the ghost objects, for this refer to SQL Queries - CAST Knowledge Base - Queries on objects - Identify and clean up all the ghost objects and ghost projects in your knowledge base.

  4. If the object is part of ghost objects then perform the following:

    1. Cleanup the ghost objects, for this refer to SQL Queries - CAST Knowledge Base - Queries on objects - Identify and clean up all the ghost objects and ghost projects in your knowledge base
    2. Take a snapshot without skipping analysis
    For investigating the root cause refer to CMS Snapshot Analysis - Run Analyzer
  5. Else If the object is not part of the ghost objects:

    1. Get the project containing the object by running the following on the local schema:

      select idpro
       from objpro 
       where idobj = <local_object_id>

      replace <local_object_id> by the id of the object from the local schema.

      Result sample
      2341
  6. Check if the project containing the object is part of the Ghost projects, for this refer to SQL Queries - CAST Knowledge Base - Queries on objects - Identify and clean up all the ghost objects and ghost projects in your knowledge base.
  7. If the object is part of the ghost objects then perform the following:
    1. Cleanup the ghost projects, for this refer to SQL Queries - CAST Knowledge Base - Queries on objects - Identify and clean up all the ghost objects and ghost projects in your knowledge base
    2. Take a snapshot without skipping analysis
    For investigating the root cause refer to CMS Snapshot Analysis - Run Analyzer 
  8. Else If the object is not part of the ghost objects then contact  CAST Technical Support with  Relevant input. Support will try to reproduce the issue by following the page CAST Engineering Dashboard - Information - Source code - Missing Sources - How to reproduce user issues
Notes/comments
 Ticket # 3430
Related Pages