Feedback

Feedback

Did this article resolve your question/issue?

   

Article

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

Printable View

Information

 
TitleError "Table/View/Synonym not found (7519)" using ODBC
URL Name2981
Article Number000127680
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 Number
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 to be sure it exists in the current schema or in the database.

Commonly, this error occurs 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
Last Modified Date4/27/2022 3:43 PM
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.


Copyright © 2022 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, Ipswitch, Chef, Kemp, Flowmon and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.

Terms of Use Privacy Center Security Center Trademarks License Agreements Code of Conduct Careers Offices
Do Not Sell My Personal Information