Purpose of Query
This query when ran on the CAST management base will provide the list of analysis units created more than once having different project file paths.
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
CSS4 | |
CSS3 |
Query for JAVA (CSS, Oracle, SQL Server)
How to check for overlapping analysis units (here it is JAVA case)
with DuplicateNames as ( select mau.Object_Name from CMS_PORTF_Module cpm join CMS_PORTF_ObjectFilter cpof on cpof.Module_Id = cpm.Object_Id join MAINT_AnalysisUnits mau on mau.Object_Name = cpm.Object_Name group by mau.Object_Name having count(1) > 1 ) select * from DuplicateNames dn join MAINT_AnalysisUnits mau on mau.Object_Name = dn.Object_Name;
Query result example
'DataGridFilterLibrary',95656,'DataGridFilterLibrary',69617,'.NET',74709,,1
'DataGridFilterLibrary',95729,'DataGridFilterLibrary',69617,'.NET',74709,,1
'DataGridFilterLibrary',95749,'DataGridFilterLibrary',69617,'.NET',74709,,1
'EQD',95298,'EQD',69617,'.NET',74709,,1
'EQD',95681,'EQD',69617,'.NET',74709,,1
Query result interpretation
There are 2 analysis units found that are created more than once.
Notes/comments
Ticket # 33484