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
Release | Yes/No |
---|---|
8.3.x |
RDBMS | Yes/No |
---|---|
CSS |
- Compute snapshot.
- Launch CED.
- Go to Investigation - Quality Model Drilldown view.
- Select a violated object.
- Observe the source code of the violated object.
- 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
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 sample243154
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.
If the object is part of ghost objects then perform the following:
- 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
- Take a snapshot without skipping analysis
Else If the object is not part of the ghost objects:
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 sample2341
- 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.
- If the object is part of the ghost objects then perform the following:
- 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
- Take a snapshot without skipping analysis
- 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