Kbase P127300: SQL-92: Error (7520) loading views in the .dfsql file generated by the SQLSCHEMA Utility.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/30/2007 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
SQL-92: Error (7520) loading views in the .dfsql file generated by the SQLSCHEMA Utility.
[JDBC Progress Driver]:Column not found/specified (7520)
=== SQL Exception 1 ===
SQLState=42S22
ErrorCode=-20006
[JDBC Progress Driver]:Column not found/specified (7520)
CAUSE:
The Schema has been changed after the dumped views have been created by removing some fields that are referenced by the view but are no longer in the database.
FIX:
Identify the offending table(s) and the offending fields and manually edit the views causing the error to conform to the new table(s) field definitions.