Kbase P74623: Newly committed records do not appear in Report Builder report
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/3/2009 |
|
Status: Verified
SYMPTOM(s):
Applications creates new records and commits them to the database
The Report Builder engine is invoked to generate a report which will contain the records that were just committed to the database
Report Builder does not see record after it was created
FACT(s) (Environment):
Windows
Progress 8.x
Progress 9.x
CAUSE:
When the report engine is invoked it is connecting to the database using the -RO startup parameter. This startup parameter causes us to ignore any existing database server for the database (and its corresponding buffer pool) and read records directly from disk. The newly committed records do not appear because they are still in the database buffer pool and have not yet been written to disk.
FIX:
Modify the code that invokes the report engine so that is connects to the database server and does not use the -RO startup parameter