Troubleshooting and Best Practices

Troubleshooting

Common issues and how to resolve them

🔴 "Processing Failed" Error

Possible Causes

• Invalid data types in uploaded file
• DAX formula syntax errors
• Circular references in calculations
• Missing required relationships

Solutions

1. Check the error message details for specific column/table names
2. Validate data types match column configurations
3. Review recent DAX formula changes for syntax errors
4. Try processing individual tables to isolate the issue

🔴 Processing Takes Too Long

Possible Causes

• Large data volumes
• Complex calculated columns
• Many relationships to process
• Inefficient DAX formulas

Solutions

1. Consider partitioning large fact tables by date
2. Convert complex calculated columns to measures where possible
3. Review and optimize DAX formulas (avoid nested iterations)
4. Process during off-peak hours for large refreshes

🔴 File Upload Rejected

Possible Causes

• Column headers don't match existing table structure
• File format not supported (must be CSV or Excel)
• File exceeds size limits
• Special characters in headers or data

Solutions

1. Ensure column headers exactly match the target table
2. Save Excel files as .xlsx (not .xls)
3. For large files, consider splitting into smaller batches
4. Remove or encode special characters (quotes, commas in CSV)

🔴 Data Type Mismatch

Possible Causes

• Text values in numeric columns
• Date formats that don't match expected pattern
• Blank cells interpreted incorrectly

Solutions

1. Clean data in Excel before uploading
2. Use consistent date formats (YYYY-MM-DD recommended)
3. Replace blanks with appropriate null values or zeros
4. Verify column type settings in Smartload match your data

🔴 "Duplicate Values" or "Many-to-Many" Warning

Cause

The primary key column in your attribute table contains duplicate values. Each key must appear exactly once.

Solutions

1. Download the attribute table data
2. Use Excel's Remove Duplicates feature on the key column
3. Verify which row should be kept for each duplicate
4. Re-upload with Replace Data

🔴 Blank/Missing Values in Reports

Cause

Fact table contains foreign key values that don't exist in the related attribute table (orphaned records).

Solutions

1. Identify which keys are missing using a cross-reference query
2. Add missing records to the attribute table, OR
3. Clean up orphaned records from the fact table

🔴 "Syntax Error" in DAX Formula

Common Issues

• Missing or mismatched parentheses
• Incorrect column references (wrong table name)
• Using single quotes instead of double quotes for text
• Missing commas between function arguments

Solutions

🔴 "Circular Dependency" Error

Cause

A calculated column or measure references itself, either directly or through a chain of references.

Solutions

1. Map out all references in your formula
2. Identify where the loop occurs
3. Restructure calculations to break the circular reference

🔴 Cannot Connect from Excel

Possible Causes

• Cube not processed after recent changes
• Network/firewall blocking connection
• Authentication issues
• Outdated connection string

Solutions

1. Verify the cube has been processed successfully
2. Check Smartload System Status for any service issues
3. Try refreshing your Catalyst session
4. Contact support if the issue persists