Article

How to troubleshoot error 7519 with SQL-92

« Go Back

Information

 
Article Number000001353
EnvironmentProduct: Progress
Version: 9.x
Product: OpenEdge
Version: 10.x, 11.x
OS: All Supported Operating Systems
Question/Problem Description
How to troubleshoot error 7519 with SQL-92
What could be causes for error 7519 when using SQL-92?

Steps to Reproduce
Clarifying Information
Error MessageTable/View/Synonym not found (7519)
Defect/Enhancement Number
Cause
Resolution

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.

When this error is encountered, determine whether the table, view, or synonym is in the current schema or in the database.

This error can occur when accessing a table from the PUB schema without prefixing the table with PUB.

Possible causes and solutions for Error 7519 are:

NOTE: Schema names are capitalized for emphasis only.

1) The PUB schema prefix is not specified for a 4GL table.

 Solution: Prefix the name of the table, view, or synonym with PUB.

A) select * from customer
B) change to: select * from PUB.customer

2) The specified name has hyphens and/or is a reserved word.
Solution: Enclose the name in double quotes.
A) select * from PUB.Ref-Call
B) change to: select * from PUB."Ref-Call"
C) select * from PUB.references
D) change to: select * from PUB."references"
3) The SYSPROGRESS prefix is not specified for a SQL-92 system table or view.
Solution: Prefix the name of the table or view with SYSPROGRESS.
A) select * from systables
B) change to: select * from SYSPROGRESS.systables
4) 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.
set schema 'pub'
5) 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.
select * from SYSPROGRESS.systables

or

select * from SYSPROGRESS.systables where tbl = 'customer'
Workaround
Notes
Attachment 
Last Modified Date9/13/2015 4:57 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