Kbase P158167: Errors encountered when attempting to use existing relationships in Query/Results after migration to
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/2/2010 |
|
Status: Unverified
SYMPTOM(s):
Errors encountered when attempting to use existing relationships in Query/Results after migration to a later version
Warning message generated when launching Query/Results
Warning: The database structure has changed. An application rebuild may be needed. Choose YES to regenerate table relationships; Choose NO to use existing relationships; Choose EXIT to cancel.
Multiple errors occur when selecting NO
** FIND FIRST/LAST failed for table . (565)
** FIND FIRST/LAST failed for table _File. (565)
** <file-name> already exists with <field/value...>. (132)
** qbf-rel-tt already exists with 0. (132)
** <file-name> record not on file. (138)
** qbf-rel-buf2 record not on file. (138)
** No <file-name> record is available. (91)
** No qbf-rel-buf2 record is available. (91)
Monitoring Query/Results startup using client-logging shows that the errors originate from a fastload system r-code file, e.g.
sports2000001.r
FACT(s) (Environment):
Database structure has changed as part of the migration
Table(s) has been added/removed
The fastload system is the set of r-code files that optimizes the configuration of Results at startup. Results automatically generates and updates the fastload system associated with the current QC7 file.
A fastload system for a Results application should not exist in the user environment prior to the initial startup of the application
OpenEdge 10.x
Windows
CAUSE:
The database structure has changed since the Query/Results application was originally generated. Current fast load files are out of sync with the database.
FIX:
Choose YES to regenerate table relationships