DB Queries Fail on Initial Admin App Load, Resolve After Navigation

Customer reports that when viewing an app, initial loading results in database queries failing. This appears to be due to the system querying default values instead of user-specific attributes. The issue resolves itself after the user navigates within the application, at which point user attributes are correctly applied and queries execute successfully.

What is happening or what is needed

When a Sigma-backed app opens, the charts run their queries using the workbook's saved DEFAULT user attribute values instead of the values for the signed-in user. Every visual on the page fails at once with "Warehouse error: query failed" or an empty-data error, and dropdowns come up blank. After navigating away and back, or waiting a few minutes, the correct attributes apply and everything works. Insight Cloud is sending the correct values every time — the embed JWTs were decoded and verified against all four captures. The failure is inside the Sigma embed layer.

Walk us through it step by step

1. Open an app from My Apps. 2. Watch the charts render on first load. 3. Every visual errors at the same time. Filter dropdowns show no content. 4. Open the browser network tab and decode the embed-path JWT — it carries the correct user attributes for the org. 5. Navigate away from the app and come back, or wait a few minutes. 6. The charts now load correctly with the right data.

Please authenticate to join the conversation.

Upvoters

Status

Complete

Board

My Apps

Date

11 days ago

Subscribe to post

Get notified by email when there are changes.