CMS Application - Modules - Module content overview - User Defined Modules - Fatal Error - Module content overview failed - No Object Found

When running Prepare analysis Data from AIP Console, we see the below error in the log - 

Error: Child task on exception The following modules are empty : 'xxx' Return value: 1000 ERR: 2021-09-22 09:11:21: Prepare analysis data failed. Most of the time, this is due to empty module. ERR: 2021-09-22 09:11:21: For prepare analysis data, empty modules cannot be ignored. Either run a snapshot directly, either update your modules configuration.

Doing a Module content overview from CAST-MS, we might get the following error:

User Defined Module - Module content overview failed
No Object Found - 

For AIP Console - 

1. Add a new version from AIP Console.
2. Configure an explicit filter content module. 
3. Run analysis/snapshot
4. Prepare analysis data step fails with error. 

CAST-MS

1. Package and Delivery source code.
2. Accept Delivery and set as current version.
3. Configure an explicit filter content module.
4. Run analysis/snapshot.
5. Perform a module content overview.

The issue occurs because the format of the explicit filter added to the module is not correct. 

When creating an explicit filter, you need to make sure the INSERT statements are present as expected - 

If you do not find the information you are looking for or solution for your problem, in this page, contact CAST Technical Support with the below relevant input to help CAST Support team to reproduce the issue.

Relevant Input

1. Sherlock (CAST Support Tool (CST) - alias Sherlock). Options to select are Export Log file, Export Database backup, Export configuration files, Export source code.
2. Relevant screenshots of the issue: missing objects, empty module, module generation aborting, etc...)

# 31412