Troubleshooting Overview

Use this section to diagnose common Casabase Cube issues and identify the appropriate next step.

Casabase Cube runs as a Snowflake Native App, so troubleshooting generally falls into one of two areas:

Snowflake-level access and environment issues, such as application-role grants, customer-owned object access, or required Native App privileges.
Casabase Cube application issues, such as dimension validation, hierarchy builds, formulas, security rules, queries, or application configuration.

Start with the symptom rather than making broad configuration changes.

Recommended Troubleshooting Workflow

For most issues, use the following sequence:

Identify the Symptom
        │
        ▼
Capture the Exact Error
        │
        ▼
Check Access and Configuration
        │
        ▼
Run Health Check
        │
        ▼
Use Feature-Specific Diagnostics
        │
        ▼
Review Recent Changes
        │
        ▼
Generate Support Information
        │
        ▼
Contact Support if Needed

Avoid changing several unrelated settings at once. Isolating one variable at a time makes it easier to identify the cause and verify the resolution.

Start with the Exact Error

When an operation fails, capture the complete error message before retrying or changing configuration.

Useful context includes:

Cube name
Dimension name, when applicable
Snowflake user
Procedure or query being executed
Query POV
Formula text
Approximate time of the failure
Recent configuration changes
Whether the issue affects one user or multiple users

For SQL-based operations, preserve the complete procedure call whenever possible.

Run Health Check

For a configured cube, Health Check is the primary general-purpose diagnostic.

For example:

CALL CUBE.HEALTH_CHECK('FINANCE');

Health Check can identify problems involving cube configuration and application state.

Address reported errors first, then investigate warnings that are relevant to the problem you are troubleshooting.

See Using Health Check and Health and Diagnostics.

Choose the Symptom

I cannot access Casabase Cube or perform an operation

Start with Access & Permission Issues.

Check whether the problem involves:

Access to the Native App
CUBE_PUBLIC or CUBE_ADMIN
Customer-owned databases, schemas, tables, or stages
Required Snowflake privileges
The current Snowflake user or role

Application access and Casabase Cube row-level security are separate controls.

A dimension will not validate or rebuild

Start with Dimension Validation & Build Errors.

Common causes include:

Invalid dimension definition data
Missing or invalid parent relationships
Duplicate or conflicting member definitions
Invalid formulas or member properties
Source-object access problems
A stale build lock following an interrupted rebuild

Validate the dimension before repeatedly attempting a rebuild.

See Dimension Validation and Rebuilding Dimensions.

A query returns no rows or unexpected empty results

Start with Query Returns No Data.

Check:

Cube name
POV member names
Member selection operators
Whether matching fact data exists
Dimension rebuild state
User security scope
Whether the query was actually refused rather than returning an empty result

A user with no active Casabase Cube security rules is not restricted by Casabase Cube row-level security. If security is suspected, verify the user’s actual active rules rather than assuming that the absence of a rule causes an empty result.

A formula fails validation or returns an unexpected value

Start with Formula Errors.

Separate formula problems into:

Syntax / Reference Error
          │
          ▼
Formula Validation


Valid Formula, Wrong Result
          │
          ▼
Query Context / Dependencies /
Solve Order / Security Scope


Valid Formula, Slow Query
          │
          ▼
Formula Cost / Query Scale

See Formula Validation.

A query is slow

Start with Performance Issues.

Performance investigation can include:

CALL CUBE.PERFORMANCE_REPORT('FINANCE', '30');

CALL CUBE.SLOW_QUERY_INSPECTOR(
    'FINANCE',
    NULL,
    '7',
    NULL
);

CALL CUBE.FORMULA_COST_ESTIMATOR('FINANCE');

Do not assume that increasing the Snowflake warehouse size is always the correct first response. Query grain, calculated-member complexity, physical data organization, and repeated workload patterns can also affect performance.

See Health and Diagnostics.

Empty Result vs. Refused Query

These are different conditions.

An empty result means the query executed but did not find data for the requested context.

A refused query means Casabase Cube determined that the request could not be executed within supported calculation semantics or scale.

Examples of refusal conditions can include:

Calculated members on more than two dimensions in one query
Excessively broad calculated-member expansion
Unsupported formula semantics
Missing context required by a calculation

When a query is refused, use the returned error to change the request. Repeatedly executing the identical query will not resolve a deterministic refusal.

Review Recent Changes

If a cube previously worked, determine what changed immediately before the problem appeared.

Examples include:

Dimension definition changes
Dimension rebuild
Formula changes
Security-rule changes
Source-object changes
Fact-data refresh
Application upgrade
Snowflake role or privilege changes

The Casabase Cube audit log can help investigate administrative and application activity.

See Audit Log.

After an Application Upgrade

If unexpected behavior begins after an application upgrade:

Verify the installed application version.
Run the appropriate health checks.
Validate important cube configuration.
Execute a representative query.
Review the exact error or unexpected result.
Generate support information if the issue remains.

See Application Upgrades.

Generate Support Information

If the issue remains unresolved, generate diagnostic information before escalating it.

For a specific cube:

CALL CUBE.GENERATE_SUPPORT_INFO('FINANCE');

For system-level information:

CALL CUBE.GENERATE_SUPPORT_INFO(NULL);

Generating support information does not automatically transmit it to Casabase Software. Review the output and provide relevant information through the appropriate support process.

See Getting Additional Help and Health and Diagnostics.

Before Contacting Support

Collect the minimum information required to reproduce the issue:

Casabase Cube version
Cube name
Exact error message
Operation being performed
Relevant SQL or procedure call
Query POV or formula, when applicable
Health-check or diagnostic output
Approximate time of the issue
Expected behavior
Actual behavior

Do not include passwords, private keys, authentication tokens, or other credentials.

Troubleshooting Topics

Continue with the page that best matches the problem: