CMS Snapshot Analysis - Generate Modules - Fatal Error - The following modules are empty

When trying to perform a snapshot on an application which contains a database analysis, the snapshot fails and the following message can be seen in the CAST-MS log (see the page CAST Management Studio - Information - How to find logs for information on how to find the CAST-MS log)

ERR: 2016-10-24 10:00:07: The following modules are empty

Figure 1

Below is the step-by-step scenario leading to the problem:

• Deliver code.
• Perform analysis and snapshot.
• Snapshot fails at the Generate Module step with error. 

1. Check that all the Analysis Units have been successfully analyzed as shown in the below screenshot :
   Figure 2
   If the Execution Status is not successful, you must run the analysis again to make the status set to Success. If you are facing issues during analysis, visit the page : CMS Snapshot Analysis - Run Analyzer
   
   
   
2. Check the Analysis Unit content overview, they must not be empty, as shown in the below screenshot :
   
   Figure 3
   
   If the View Analysis Unit content is empty and failing with a fatal error message, navigate to the page CMS Analysis Unit - Execute Tab - View Analysis Unit content - Fatal error
   
   

3. In the Module tab, select the Module seen as empty by the Generate Module Step, and click on the filter rule and check if it is showing details like below screenshot :
   Figure 4
   If it is empty, it means that the module filter configuration is configured to prevent all the objects to be in the module.

   
   

4. In the Module tab, select the Module seen as empty by the Generate Module Step, and click Module Content Overview.
   Figure 5
   
   
   1. If the Module Content Overview is empty, visit the page CMS Application - Modules - Module content overview - User Defined Modules - Fatal Error - Empty Modules
      
      

   2. If the Module Content Overview is not empty, run the below SQL query. If it returns no row, then no objects have been attached to the module, this is a corruption.

      For an UPDATED workaround To achieve the above please contact CAST Technical Support

5. If the Generate module step still failing with the same error, drop the project(s) involved in the empty module:

   1. Refer to the page SQL Queries - CAST Knowledge Base - Queries on Module - How to cross check the results of Module Filters to retrieve the list of objects that must be in the Module

   2. Run the following query in your local database to get the project id that contains the object id you have just retrieved:

      select distinct idpro from <Local Db>.Objpro
      where idobj = <Object ID> 

       The query will return the list of projects involved in the missing object.

   3. Run the following query to drop the project:

      select PROJECT_DELETE(<ID_PROJECT you have found>)

   4. Run the analysis again

   5. Run the snapshot by skipping analysis.

6. If the issue still persists, contact CAST Technical Support with the 479166508 in order to reproduce the issue
   To reproduce the issue, support agent needs to restore the Mangement Database, the local database and the central database, to synchronize the three databases. The LISA folder corresponding to the application must bu placed in the same path than the customer. In the CAST Installation folder, add the file CAST-MS.l4j, and add in the firs line the following : -Dsourceserver.offline=true . Then, close CMS and open it again.

Ticket # 6950

Ticket # 9088