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
Observed in CAST AIP
Observed on RDBMS
Microsoft SQL Server
Step by Step Scenario
Below is the step-by-step scenario leading to the problem:
Perform analysis and snapshot.
Snapshot fails at the Generate Module step with error.
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
Check the Analysis Unit content overview, they must not be empty, as shown in the below screenshot :
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.
In the Module tab, select the Module seen as empty by the Generate Module Step, and click Module Content Overview. Figure 5
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.
Run the following query to drop the project:
select PROJECT_DELETE(<ID_PROJECT you have found>)
Run the analysis again
Run the snapshot by skipping analysis.
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.