Article

Error "Table/View/Synonym not found (7519)" using ODBC

Information

 
Article Number000002110
EnvironmentProduct: OpenEdge
Version: 10.x, 11.x
OS: All Supported Operative Systems
Other: SQL
Question/Problem Description
Error 7519 running SQL when using Progress SQL -92 ODBC driver
Steps to Reproduce
Clarifying Information
Error MessageTable/View/Synonym not found (7519)
Defect/Enhancement Number
Cause
The error message Table/View/Synonym not found (7519) indicates that an object used in a SQL statement is not available in the current schema or in the database.
 
Resolution

Table, view, or synonym need to be checked is exist  in the current schema or in the database.

Commonly this error is gotten when trying to access a table from the PUB schema without prefixing the table with PUB.

Note: Schema names are capitalized for emphasis only.

Possible causes - Error 7519:

a) The PUB schema prefix was not specified for a 4GL table.
  Solution: Prefix the name of the table, view or synonym with PUB.

Example:
  - select * from customer
  change to:
  - select * from PUB.customer

b) The specified name has hyphens.
  Solution: Enclose the name in double quotes.

Example:
  - select * from PUB.Ref-Call
  change to:
  - select * from PUB."Ref-Call"

c) The SYSPROGRESS prefix was not specified for a SQL92 system table or view.

  Solution: Prefix the name of the table or view with SYSPROGRESS.

Example:
  - select * from systables
  change to:
  - select * from SYSPROGRESS.systables

d) The specified table, view or synonym is not available in the current schema.

Solution: Prefix the object with the correct schema name or use the SET SCHEMA statement to change the current one.

Example:
  - set schema 'pub'

e) The specified table, view or synonym is not available in the  database.

  Solution: Use the correct object name, found in the database.
  Query the systables view for the object name.

Example:
  - select * from SYSPROGRESS.systables
  or
  - select * from SYSPROGRESS.systables where tbl = 'customer'

NOTE: if the view does not show up in this list, most likely the view was created via a SQL client tool and the SQL statement was not followed by a COMMIT statement.

Workaround
Notes
Attachment 
Last Modified Date12/19/2018 2:17 AM


Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025