Kbase P139657: FOR EACH with WHERE clause returns no records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/01/2009 |
|
Status: Unverified
SYMPTOM(s):
FOR EACH with WHERE clause returns no records
WHERE clause refers to field recently added using an incremental .df loaded online
No records are returned in Windows Procedure Editor with client-server connection to database
FACT(s) (Environment):
Records are returned in Unix Procedure Editor with shared memory or client server connection to database
Records are returned when WHERE clause is removed, and same selection is done with an IF inside the loop
Records satisfying the WHERE clause exist in the database
Database is maintained on Unix system
Field was added to a test database, and incremental .df was created and loaded into production database, all in same data dictionary session
Windows clients remain connected throughout online schema change
Windows clients are using database both before and after incremental .df loaded
UNIX
Windows
OpenEdge 10.1C
CAUSE:
Bug# OE00180474
FIX:
To correct the problem that prevents records from being found with a WHERE clause using the new field, remove the newly added field and reapply the change in a new data dictionary session using the already created incremental .df file. The key point is to avoid doing any work in the data dictionary between connecting to the database and applying the incremental .df. Once the .df has been reloaded, the data can then be loaded, and the records will be able to be retrieved normally.