Informix Error -26560: Cannot find synonym for table.
Cause and resolution
Cannot find synonym for table.
This query was not probed successfully because it contains a table that does not reside in the current database and no synonym is defined on this table.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26560 fires when a query isn't probed successfully because it references a table outside the current database with no synonym defined — per the official guidance.
- The table doesn't reside in the current database, and no synonym is defined for it, per the official guidance — the direct, only cause.
Solutions / Resolution
- Define a synonym for the table, per the official guidance's implication, if acceleration/probing for this query is desired.
Examples
N/A
No specific triggering statement is documented beyond a remote table with no synonym.
Diagnostic Checks
- Check whether the referenced table has a synonym defined in the current database, and add one if acceleration/probing is desired.
Related Errors / Related Topics
- -26509 — "Query contains a table in remote database" A related restriction on cross-database tables generally, of which a missing synonym is a specific probing failure mode.
A remote table with no defined synonym couldn't be resolved for probing — define a synonym if needed.