Kbase P28620: Data confusion after truncate bi -F
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
proutil <database> -C truncate bi -F
proserve <database> [-S <service> ...]
Users are connected again and continue modifying the data
Data is incorrect, e.g. product information does not fit product number within orderline
CAUSE:
Due to the usage of "truncate bi -F", crash recovery did not occur and some index or data blocks have not been updated with the modifications made just before the database stopped.
The case of "product information does not fit product number within orderline" would indicate a modification of product number within the orderline and, the data block with the orderline has been updated but the related index block has not.
FIX:
Run "proutil <db> -C idxbuild" is a quick fix but it will not solve the possible problem of orderlines not having their corresponding order if the data block containing the new order was not flushed to disk prior to database stopping.