Created by Unknown User (sbr_20169), last modified by John McMahon on Jul 26, 2023
Purpose (problem description)
 This page will help you to troubleshoot issues related to missing objects in the module content overview.
Observed in CAST AIP
Release
Yes/No
8.3.x(tick)
Observed on RDBMS
RDBMS
Yes/No
CSS(tick)
Action Plan
  1. Check if the missing objects have been analyzed by searching these objects in Enlighten. If the objects are not analyzed, it is expected to not have them in the Module Content. Check in the analysis log file that there are no errors or warnings related to these objects and visit the page CMS Snapshot Analysis - Run Analyzer.

  2. If the objects are analyzed :
    1. Modules contain only Internal Objects : check if the missing objects are external objects or generated file objects by running the queries that are described in the page : SQL Queries - CAST Knowledge Base - Queries on objects - How to check if objects are internal or external or generated from the application
    2. If the objects are SQL objects :
      1. In CAST Management Studio, in the Modules tab, check if the Database subset option is activated.
      2. If it is activated, this option must be set to Inactive.
      3. Include the content of the database Subsets related to client code from a Module using "Explicit content" tab of the "Module" editor as explained in the official documentation (Focus on Module content - About database Subsets)
      4. Run the snapshot without skipping analysis.
    3. If the object is not shown in the Module content overview, check if the object belongs to the analysis units that has analyzed it by following the page SQL Queries - CAST Knowledge Base - Queries on objects - How to list the objects belonging to an Analysis Unit.

  3. Check if there is corruptions on Metamodel, by refering to the page SQL Queries - Common SQL Queries - Corruptions - Corruptions on Metamodel, If you detect a corruption then
    1. Load Metamodel.
    2. Run the snapshot without skipping analysis.
  4. Are the objects removed from the Module content overview because of the filters configuration? To answer the question, run the set of queries described in the page SQL Queries - CAST Knowledge Base - Queries on Module - Queries based on Module Filters
  5. If the missing objects are the result of an Universal Analyzer run the below queries to check if the type of the missing objects are correctly loaded in the KB and CB :

    1. Run the below query

      Query 1
      select DISTINCT OBJECT_TYPE_ID 
from <Your Local Database>.DSS_OBJECTS 
where object_ID IN (Select distinct t.SITE_OBJECT_ID
					From <Your Central Database>.DSS_CENTRAL_SELECTION s, <Your Central Database>.DSS_TRANSLATION_TABLE t, <Your Central Database>.DSS_OBJECTS o
					where s.SNAPSHOT_ID = <snapshot id>
  						  and s.APPLICATION_ID = <application id>
						  and t.OBJECT_ID = s.MODULE_ID
  						  and o.OBJECt_ID = s.MODULE_ID )

    2. If the above Query returns OBJECT_TYPE_ID as any value greater than 2 million it means there is involvement of custom UA language.


    3. Run the query below to check if the TYPE_ID is present in TYP table (in both local as well as in Central)

      Query 1
      select * from <Your Local Database first then Your Central Database>.Typ 
where idtyp in (select DISTINCT OBJECT_TYPE_ID 
from <Your Local Database>.DSS_OBJECTS 
where object_ID IN (Select distinct t.SITE_OBJECT_ID
					From <Your Central Database>.DSS_CENTRAL_SELECTION s, <Your Central Database>.DSS_TRANSLATION_TABLE t, <Your Central Database>.DSS_OBJECTS o
					where s.SNAPSHOT_ID = <snapshot id>
  						  and s.APPLICATION_ID = <application id>
						  and t.OBJECT_ID = s.MODULE_ID
  						  and o.OBJECt_ID = s.MODULE_ID ))


    4. If it returns no rows then UA extension (objects) is not correctly loaded in central & local database. Then the Meta model is not up to date regarding the project in question. The Solution is to Reload the metamodel (command Servman->Load metamodel from disk) in Local and in Central Databases. Reanalyze the job / Analysis Unit and Generate snapshot.


  6. If the missing objects in the module content overview are SQL objects, this could well be a configuration issue due to inconsistency between the .uaxdirectory and the instance file of the database. This inconsistency is due to manual changes done in the files which is not recommended. As you can see in the page DMT - Oracle > Dealing with Oracle Schemas that move from one Server to another or from one Instance to another, you must use a tool to rename instances. 
     
  7. If the below point does not help you resolve the issue, contact CAST Technical Support with Relevant inputs in order to help Support to reproduce the issue.