Troubleshooting

Fixes for the errors people run into most: signing in, connecting data sources, queries and dashboards, metrics, the agent, syncs and MCP.

The messages people run into most, what they mean, and what to do. Search this page for a word from the error (Ctrl F, or ⌘ F on a Mac).

Signing in

You seeWhat to do
“… isn’t invited to any organization — ask them to invite you first”You signed in with a Google account that has no invite. Sign in with the account the invite was sent to, open your invite link and continue with this account there, or ask an admin to invite this email.
“No organization found at …”The address has an old or wrong organization name in it. Click the Orcabase logo and pick your organization.
You were signed outOrcabase signs you out after 7 days away, and within 15 minutes of being removed from an organization. Sign in again, or ask an admin.

Data sources

You seeWhat to do
Test connection failsSee the error table on PostgreSQL or BigQuery. Most often the database doesn’t accept connections from the internet, or the login is wrong.
“No Postgres servers are assigned to this organization yet”Only admins can pick hosted Postgres servers. Ask an admin to add the data source, or message us if you don’t have a server yet.
“No DuckDB projects exist yet”DuckDB warehouses are added by the Orcabase team. Message us to set one up.
An upload fails with “permission denied”The data source’s login can’t create tables. Upload into your DuckDB warehouse instead. See Uploading into Postgres.
An upload fails with “already exists”A table with that name is already there. Pick a new table name.
An upload fails as too largeFiles can be up to 200 MB. Split the file, or save it as Parquet, which is much smaller.

Queries and dashboards

You seeWhat to do
The query times outQueries stop after 30 seconds. Filter to a shorter period, add up in SQL (GROUP BY) instead of returning raw rows, or ask whoever runs the database about indexes.
Only 5,000 rows come backThat’s the most a query returns. Add up or filter in SQL so the answer fits.
A dashboard shows old numbersDashboards show each query’s last saved result and don’t refresh on a schedule yet. Use Run all queries in the dashboard’s ⋯ menu.
“No result cached yet — run the underlying query”The query behind the chart has never run. Open it from the widget’s menu and run it.
A chart changed on a dashboard you didn’t touchChart settings belong to the query, so an edit on one dashboard shows everywhere that query’s chart appears.
A chart is wrong after Run all queriesIts query has parameters, and Run all queries runs them empty. Use a query without parameters for dashboard charts.

Metrics and data models

You seeWhat to do
“… crosses a one-to-many join and would double-count”The split you asked for would count rows more than once. Define the metric on the other model, as the message suggests. See Correct or loud.
A Broken badge on a data modelIts table changed, for example a column was renamed. Click the badge to see which dimension or measure fails, and update its expression.
“… is still used by …” when deletingSomething depends on it; the message lists what. Change those first, or deprecate instead of deleting.
A certified metric is back to DraftIts formula changed. Check it and certify it again.

Data Agent

You seeWhat to do
“Ask an organization admin to set it up in Settings → Agent”The agent isn’t set up for your organization yet. An admin can do it in a few minutes: see Set up the agent.
“This is taking a while. Keep going?”The question used its allowance of steps. Click Continue to carry on, or ask something narrower.
“This chat is still answering the last question”A chat answers one question at a time. Wait for it, or start a new chat.
“Your organization has used … Orcabase AI credit”A daily, weekly or monthly limit is used up. The message says when it resets. An admin can switch to your own key in the meantime.
Test and save failsThe key is wrong, has no credit left, or can’t use that model. Check it in your OpenRouter or Vercel account.

Syncs

You seeWhat to do
“can’t open this spreadsheet — share it with …”Share the Google Sheet with the address shown, as a Viewer.
“spreadsheet not found — check the link”Copy the link again from the sheet’s address bar.
“… is a private address”Orcabase can’t reach private network addresses. Use the database’s public address.
“… can’t contain spaces or quotes”MySQL connection details can’t include spaces or quote marks. Change the password to one without them.
Needs reconnectingOrcabase can’t sign in to the source any more. Update the connection details, or click Reconnect for a Fivetran source.
Paused: limit reachedYour organization used this month’s Fivetran allowance. See Your monthly allowance.

Claude and ChatGPT

You seeWhat to do
401 or “unauthorized”The token is wrong or revoked, or the header isn’t named X-Api-Token. Create a new token if in doubt.
Claude asks for an OAuth client IDPick No sign-in under Authentication, then add the token as a request header.
The assistant can’t find your dataMake sure the token belongs to the right organization, and that the data source exists in Orcabase.

Still stuck? Message us with what you did and the exact message you saw.

Something unclear or missing? Troubleshooting covers the common errors, or message us.

↑↓ to move↵ to openesc to close