Report and query messages

Saving and publishing

Report name is required.

Fix: Select Untitled report at the top and type a name.

SQL query is required.

Also: SQL query is required to publish, sql is required.

Fix: Write a query or load a template.

Run your query successfully before publishing.

Also: Run the query to enable Publish (or Update).

Cause: The query has not run successfully since your last change. Fix: Select Run query, then Publish or Update.

Default value required for: …

Also: parameter “…”: default value is required, and Required in an empty Default field.

Fix: In the Parameters panel, fill in Default for each named parameter.

Report limit reached (N/N). Upgrade to publish more.

Cause: Your Organization has reached the Evaluation limit on published reports. Fix: Delete a published report you no longer need, keep this one as a draft, or see Billing.

Failed to create report. / Failed to update report. / Save failed

Fix: Try again. If auto-save shows Save failed, select Save draft. Copy your SQL somewhere safe if it keeps failing.

Unsaved changes

Full message: You have unsaved changes to this draft. Save them before leaving?

Fix: Select Save draft, Discard or Keep editing.

System reports cannot be edited

Also: System report. Read-only., system reports cannot be deleted.

Fix: Open the report and select Copy, then edit the copy.

Replace the current SQL with this template?

Cause: Loading a template replaces your query and parameters. Fix: Select Replace or Cancel.

Missing datasets: …

Cause: The template reads datasets you have not synced. Fix: Select Manage datasets, enable them and sync, or ask for help with those steps.

If you don’t see this menu or button, your role doesn’t include it. Ask someone who can edit roles (Owners and Admins by default).

This report’s columns changed. N insight widget metrics may need updating

Cause: Your update removed or renamed columns that widget metrics use. Fix: Open each named metric in Insight widgets and choose a column that still exists.

This report is used by insight widget metrics

Full message ends: Deleting this report will also remove these metrics.

Fix: Cancel if those metrics are still needed. Otherwise delete; the listed metrics are removed too.

Failed to delete report.

Fix: Try again. If deletion is unavailable, check the role’s current grants on Roles and permissions.

Running queries

The query could not run because of its SQL or values

The message may point to LINE N: and mark the spot with a caret. Check the issue it describes:

What to check	Example
SQL punctuation	A missing comma or bracket
Column or table name	A misspelling or a column that is unavailable
Dataset name	A dataset that does not exist or has not been synced
Value type	Text compared with a number
Function input	A value the function cannot use

Fix: Select Go to line, correct the SQL, and run again. Use the Datasets list to insert exact names.

Query execution failed / Unknown error

Fix: Run the query again. If it keeps failing, simplify it to find the part that fails.

SQL failed validation: unsafe SQL: …

Also: Query failed: invalid syntax or unsupported operation, report SQL failed validation. The reason can be report SQL must start with SELECT or WITH, multiple SQL statements not allowed, forbidden SQL pattern, forbidden SQL function or file path or URL used as table source.

Cause: Reports may contain one SELECT or WITH statement that reads only your synced datasets. Fix: Remove extra statements, file paths, web addresses and system functions.

A referenced dataset is not available. Check that it is enabled and synced

Fix: Enable the dataset on Data > Datasets and run a sync.

Query timed out

Cause: The query ran longer than 2 minutes. Fix: Add filters (for example a date range or a course), or aggregate before joining large datasets.

Query queue full, try again later

Also: query worker failed to start, try again, query service temporarily unavailable, try again, Query did not start. The server may be under load or the request was interrupted., Query was interrupted. Try again or refine your filter., Connection lost while streaming results, Failed to load cached results.

Fix: Wait a moment and run again.

Report not found.

Also: report not found, access denied.

Cause: The report was deleted, or you do not have access to it. Fix: Go back to Reports. If you expected access, contact the person who manages the report.

No results found.

Cause: The query returned no rows, or your search filter hides them all. Fix: Clear Search…, or change the parameters.

No reports found

Also: Starter reports appear here after your first data sync. or No reports match your filters.

Fix: Clear the search and filters, or run your first sync.

… must be a number. / must be from N to N.

Also: must be at least N, must be at most N, must use increments of N from N, must be one of the allowed options.

Fix: Enter a value that fits the rule shown.

This launch is limited to its Brightspace course

Cause: You opened Rowseta from a Brightspace course and the query could not be limited to that course. Fix: Open Rowseta from the course again, or sign in to Rowseta directly.

Export failed / export service temporarily unavailable

Fix: Try again in a moment.