Message Reference

ENUK

How to use this document

Search (Ctrl+F) for the exact message text you see on screen. Each entry answers:

• Where it appears
• What triggered it
• What it means
• What to do

---

Toast notifications

Toast notifications appear in the bottom-right corner of the screen. They disappear automatically after a few seconds. SQL Cor uses its own toast system — separate from Creatio’s native notifications.

---

✅ Success toasts (green background)

---

"Settings saved"

Property	Value
Where	Bottom-right toast
Color	🟢 Green
Triggered by	Changing any slider value or toggle in System Settings tab
Means	The new setting value was saved to the database successfully
What to do	Nothing — change applied immediately, no restart needed

---

"Rule added"

Property	Value
Where	Bottom-right toast
Color	🟢 Green
Triggered by	Saving a new rule in Grant Access dialog OR Add Rule (blacklist) dialog
Means	The new access rule or blacklist rule was created successfully
What to do	Nothing — rule is active immediately

---

"Rule updated"

Property	Value
Where	Bottom-right toast
Color	🟢 Green
Triggered by	Saving changes in the Edit rule dialog
Means	The existing rule was modified successfully
What to do	Nothing — changes applied immediately

---

"Database connection established (X ms)"

Property	Value
Where	Bottom-right toast
Color	🟢 Green
Triggered by	Clicking Check Connection in Service Actions
Means	SQL Cor successfully reached the database. X ms = round-trip latency.
What to do	Nothing — connection is working normally

Latency interpretation:

Value	Meaning
< 50ms	Excellent
50–200ms	Normal
200–500ms	Acceptable
> 500ms	Slow — investigate server load or network

---

"Deleted: X records"

Property	Value
Where	Bottom-right toast
Color	🟢 Green
Triggered by	Confirming Clear Logs action in Service Actions
Means	X audit log records were permanently deleted
What to do	Nothing — audit log is now empty. Cannot be undone.

×

Danger Irreversible This toast confirms permanent deletion. The audit history is gone. There is no undo.

---

❌ Error toasts (red background)

---

"Network error"

Property	Value
Where	Bottom-right toast
Color	🔴 Red
Triggered by	Any action that requires a backend request when the network is unavailable
Means	SQL Cor could not reach the backend server — network issue between browser and Creatio server
What to do	Check your internet connection. Try refreshing the page. If problem persists, contact your IT administrator.

---

"No database connection"

Property	Value
Where	Bottom-right toast
Color	🔴 Red
Triggered by	Check Connection action OR any query execution when DB is down
Means	The Creatio backend can be reached, but it cannot connect to the database
What to do	Contact your database administrator. This is a server-side issue, not a browser issue.

---

"403 access denied" (or equivalent 403 error message)

Property	Value
Where	Bottom-right toast
Color	🔴 Red
Triggered by	Any action when your Creatio session has expired or your admin privileges were revoked mid-session
Means	The server rejected the request because your current session doesn’t have permission
What to do	Log out and log back in. If problem persists, contact your administrator — your admin role may have been removed.

---

Results panel messages

These appear inside the Results panel (below the editor), not as toasts.

---

Execution success messages

---

"X rows returned in Y ms"

Property	Value
Where	Results panel — meta info below table
Triggered by	Successful SELECT query
Means	Query completed. X = row count returned. Y = execution time in milliseconds.
Note	If X is capped by Max Rows setting, you’ll also see the limit notice below.

---

"X rows changed in Y ms"

Property	Value
Where	Results panel — meta info
Triggered by	Successful DML query (INSERT / UPDATE / DELETE)
Means	Query completed. X = number of rows affected. Y = execution time.

---

"Statement executed successfully. (Y ms)"

Property	Value
Where	Results panel
Triggered by	Successful DDL query (CREATE / ALTER / DROP)
Means	DDL statement completed without errors

---

Row limit notices

---

"Results limited to X rows. Use LIMIT in your query for precise control."

Property	Value
Where	Results panel — below the data table
Triggered by	SELECT returned more rows than the configured Max Rows limit
Means	You’re seeing only the first X rows. More exist in the database but were not returned.
What to do	Add LIMIT n to your query to get exactly the rows you need. Or ask your administrator to raise the Max Rows setting.

---

Execution error messages

These appear in red in the Results panel when a query fails.

---

"Access denied. Your access level is Read-only. This operation requires DML access."

Property	Value
Where	Results panel
Triggered by	ReadOnly user attempting INSERT, UPDATE, or DELETE
Means	Your current access level (ReadOnly) does not permit data modification
What to do	Contact your administrator to request DML access if your work requires it

---

"Access denied. Your access level is DML. This operation requires DDL access."

Property	Value
Where	Results panel
Triggered by	DML user attempting CREATE, ALTER, or DROP
Means	Your current access level does not permit schema changes
What to do	Contact your administrator to request DDL access if your work requires it

---

"This query is blocked by the system. Reason: [description]"

Property	Value
Where	Results panel
Triggered by	Query matches a blacklist rule (system or manual)
Means	The query was rejected before reaching the database. [description] = the reason text your administrator wrote when creating the rule.
What to do	Read the reason. If you believe the block is incorrect, contact your administrator. If it’s a system rule (hardcoded), it cannot be overridden.

Examples of blocked reasons you might see:

• "Direct access to SysUser is restricted. Use User Management in Creatio instead."
• "Schema changes require a change request. Contact DBA team."
• "SQL Server shell execution is never allowed."

---

"Query execution timeout exceeded."

Property	Value
Where	Results panel
Triggered by	Query ran longer than the configured Query Timeout setting
Means	The database forcibly stopped the query because it exceeded the time limit
What to do	Optimize your query (add WHERE clause, use indexes). Or ask admin to increase timeout in System Settings.

---

"Multi-statement queries are not allowed for Read-only access."

Property	Value
Where	Results panel
Triggered by	ReadOnly user submitting a query with multiple statements separated by ;
Means	For security, ReadOnly users must submit one SQL statement at a time
What to do	Split your query — run each statement separately

---

Database engine errors (PostgreSQL / MSSQL)

These are error messages that come directly from the database — not from SQL Cor. They appear in red in the Results panel.

Error text	Common cause	Fix
relation "X" does not exist	Table name wrong case or missing quotes	Use double quotes: "TableName". Check Smart Hints.
column "Y" does not exist	Column name typo or wrong case	Check column names with information_schema.columns
syntax error at or near "..."	SQL syntax mistake at the indicated position	Review your SQL near the quoted text
column reference "X" is ambiguous	Same column name in multiple joined tables	Add table alias: t."ColumnName"
permission denied for table X	DB-level permission issue	Contact administrator — this is below SQL Cor’s access control
value too long for type character varying(N)	Inserting text longer than the column allows	Shorten the value or check the correct column
duplicate key value violates unique constraint	Inserting a value that already exists in a unique/primary key column	Check existing values before inserting
null value in column "X" violates not-null constraint	Inserting NULL into a required field	Provide a value for the required column
foreign key constraint violation	Referencing a row that doesn’t exist in the parent table	Ensure the referenced record exists first

✓

Tip Smart Hints For common errors like

relation does not exist and column is ambiguous, SQL Cor automatically shows a Smart Hints yellow bar with a suggested fix. Look for it above the results table.

---

Maintenance Mode message

---

"[Administrator's custom message]"

Property	Value
Where	Results panel (replaces normal results)
Triggered by	Any query execution attempt when Maintenance Mode is ACTIVE
Means	An administrator has temporarily disabled query execution for maintenance. The message text is customized by your admin.
Example messages	"Database update in progress until 14:00. Please try again later." · "Monthly backup running. Available in ~30 minutes."
What to do	Wait and try again later. Contact your administrator for updates.

i

Note SysAdmins Not Affected System Administrators can still execute queries during Maintenance Mode. Only regular users see this message.

---

Dialogs — confirmation messages

These appear as popup dialogs that require you to click a button before proceeding. They are shown before any irreversible action.

---

User-facing dialogs (Terminal page)

---

Destructive Operation dialog

Property	Value
Where	Modal popup over the Terminal page
Triggered by	Submitting a query containing DELETE when Dry Run is OFF
Text	Warning about destructive operation + preview of query
Purpose	Force conscious decision before permanent data deletion

Button	Action
Confirm	Proceeds with DELETE execution
Cancel	Closes dialog — nothing happens, query stays in editor

---

Admin dialogs (Administration page)

---

"Revoke this access? The user will lose access immediately."

Property	Value
Where	Confirmation popup
Triggered by	Clicking Revoke 🚫 on an active access rule
Means	You are about to deactivate this rule. The user/role loses SQL Cor access immediately. The rule record stays in the table as Revoked.

Button	Action
Revoke	Deactivates the rule immediately
Cancel	Closes dialog — rule unchanged

---

"Delete this access rule permanently? This cannot be undone."

Property	Value
Where	Confirmation popup
Triggered by	Clicking Delete 🗑️ on any access rule
Means	You are about to permanently remove this record from the database

Button	Action
Delete	Permanently removes the rule
Cancel	Closes dialog — rule unchanged

---

"Delete this blacklist rule? Queries matching this pattern will no longer be blocked."

Property	Value
Where	Confirmation popup
Triggered by	Clicking Delete 🗑️ on a manual blacklist entry
Means	Removing this rule means the previously blocked pattern will now be allowed

Button	Action
Delete	Removes the blacklist rule permanently
Cancel	Closes dialog — rule unchanged

!

Warning Cannot Delete System Rules System rules (🔒) have no Delete button. They are permanent and cannot be removed by any administrator.

---

"Clear all logs? This action cannot be undone."

Property	Value
Where	Confirmation popup
Triggered by	Clicking Clear Logs in Service Actions
Means	All audit log records will be permanently deleted. There is no way to recover them.

Button	Action
Clear	Deletes all audit log records immediately
Cancel	Closes dialog — logs unchanged

---

Smart Hints messages

These appear in the yellow bar above the Results panel automatically after certain errors.

---

Case-sensitive hint

Message: "PostgreSQL is case-sensitive. Try wrapping the table name in double quotes: "Account""

Property	Value
Triggered by	Error: relation "X" does not exist
Means	Your table name was not in double quotes, so PostgreSQL lowercased it
INSERT INTO EDITOR	✅ Available — rewrites query with quoted table name

---

TOP vs LIMIT hint

Message: "On PostgreSQL, use LIMIT instead of TOP. Example: SELECT * FROM "Table" LIMIT 10"

Property	Value
Triggered by	Query contains SELECT TOP N syntax
Means	MSSQL-style syntax detected — PostgreSQL uses LIMIT instead
INSERT INTO EDITOR	✅ Available — converts query automatically

---

Permission hint

Message: "Permission error. Check your access level in Administration → Access Control."

Property	Value
Triggered by	Database-level permission denied error
Means	The database rejected the query at the DB level (different from SQL Cor’s access control)
INSERT INTO EDITOR	❌ Not available — informational only
What to do	Contact your SQL Cor administrator

---

Ambiguous column hint

Message: "Column is ambiguous. Add the table alias prefix: t."ColumnName""

Property	Value
Triggered by	Error: column reference "X" is ambiguous
Means	Multiple joined tables have a column with the same name — PostgreSQL doesn’t know which one
INSERT INTO EDITOR	✅ Available — provides corrected query template with aliases

---

Status indicator states

These appear in the footer status indicator (bottom-left of page).

Icon	Text	Meaning	Action
🟢	Connected	Database is reachable and responding	None needed
🔴	Disconnected	Database cannot be reached	Use Check Connection in Admin · Contact DBA
🟡	Checking	Connection test in progress	Wait a moment

---

Cross-references

Topic	See
What causes each error	Troubleshooting
Where each UI element is	Feature Reference
How access levels work	User Guide
Admin toast notifications list	Admin Guide
How to manage access rules	Admin Guide

---

SQL Cor — Secure SQL Workbench for Creatio. Free and open source. License: MIT.

Document v1.0 · Applies to SQL Cor v1.0 · Last updated 1 June 2026