Progress Error Message: Table/View/Synonym not found (7519)
The Table/View/Synonym not found (7519) error generally indicates a need to change how you identify the target TABLE/VIEW/SYNONYM.
- If your table name contains special characters (most commonly hyphens or underscores), you will need to enclose the table names with double quotes.
For example:
likely to succeed SELECT * FROM "cust-account"
likely to error SELECT * FROM cust-account
- If you are now connecting to the Progress SQL-92 engine, you may need to ensure that all TABLE/VIEW/SYNONYM idnetifiers are more fully qualified.
One of the following options will usually bring success.
- Explicitly set the connection to target the PUB schema.
This can be done through Single-Tier DSN and/or Multi-Tier Rulebook setup.
- Prepend "
PUB.
" to each object name, as --
likely to succeed SELECT * FROM PUB.Customer
likely to error SELECT * FROM Customer
- Explicitly set the connection to target the PUB schema.
This can be done through Single-Tier DSN and/or Multi-Tier Rulebook setup.
Referenced by...