CMS Snapshot Analysis - Update SQL XXL Table Size

This page provides solution to problems related to Update SQL XXL Table Size.

XXL table Quality Rules are performance related Quality Rules that help detect incorrect or poorly performing SQL queries running on XXL tables.

Figure 1 

If the analysis fails at the Update SQL XXL Table Size step as shown in the below screenshot, the issue is in processing Update SQL XXL Table Size  feature.

Sample Screenshot of error during Update SQL XXL Table Size is shown below: 

Figure 2

To get information about different log files, their locations and to understand and explore log files as per the feature,please refer to CAST Management Studio - Information - How to find logs

For more information, refer to: 

• Official 8.3 Documentation - Run and validate the analysis

• Information Guides > Information Guides by CAST AIP Component > CMS Snapshot Analysis
• Error Free Logs -     CMS Snapshot Analysis - Update SQL XXL Table Size - Error Free Logs - CAST AIP 83

1. Check if the XXL Tables were loaded
2. If they were NOT loaded and if technology is DB2/zOS, refer to : CMS Snapshot Analysis - Update SQL XXL Tablesize - DB2 zos - The SQLTABLESIZE is not loaded
3. If the tables were loaded,and the technology is ABAP, refer to : CMS Snapshot Analysis - Update SQL XXL Table Size - Warning - ABAP - Cannot find table XXXXXX in for server
4. If the required information or the solution to the problem, is not in this page,  contact CAST Technical Support with the below  relevant input to help CAST Support team investigate the problem or provide the required information.

Relevant Input

• CAST Support Tool (CST) - alias Sherlock Export Logs, Export databases dumps, Export the source code are requested options. 
• Screenshot describing the error/warning