CAST Universal Analyser Framework - Information - How to check if UA extension metamodel is correctly loaded in central and local database

Purpose
 This page provides a way to check if the custom UA profile has been loaded correctly in Central or Local Database.
Applicable in CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
7.2.x(tick)
7.0.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
CSS2(tick)
Microsoft SQL Server

(tick)

CSS1

(tick)

Details

If UA extension is correctly loaded in central & local database can be checked by running below query:

select * from <Local_DataBase>.TYP WHERE IDTYP > <ID_assigned_to_custom_language>  
select * from <Central_DataBase>.TYP WHERE IDTYP > <ID_assigned_to_custom_language> 

Here Replace <Local> and <Central> with your Local and Central Database names and ID_assigned_to_custom_language depending on the table below taken from official documentation -

For Version 7.3 - CAST AIP 7.3.x Documentation > CAST AIP 7.3.x Documentation > Cookbooks > Platform Administration > Universal Analyzer framework > xxxMetaModel.xml file

For Version 8.0 - CAST AIP 8.0.x Documentation > CAST AIP 8.0.x Documentation > Cookbooks > Working with CAST AIP Extensions > Managing ID ranges for custom extensions

 

Example
select * from sample_database_local.TYP WHERE IDTYP > 1000000  
Result -

If it returns no rows then UA extension is not correctly loaded in central & local database.