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: 

*Observed in CAST AIP
8.3.x (tick) 
8.2.x (tick) 
8.1.x (tick) 
*Observed on RDBMS
Oracle Server(tick)
Microsoft SQL Server(tick)
Action Plan
  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.

Related Pages