Hi,
Our software is a handheld ordering system for restaurants, that needs to send orders to a third-part point-of-sale system.
The waiters can send orders by the handheld (Java) or directly on the point-of-sale (Clipper) and both of them can also
generate the customer's account.
In some circunstancies (less than 5% of the operations), the POS aplication didn't show all (or any) itens of some customers.
We made a test executing a "reindex all on PEDATIVO" when this happen and the missing itens now appears.
We also made copies of the tables before and after the "reindex all" runs. I tried to open the incorrect DBF
using cdbf for linux (http://www.whitetown.com/cdbflinux/) and the following error was showed:
"CDBF detected a few errors in a header of the database.
Do you wish to write down the corrected header?"
We connect to the database using only the option "lockType=CLIPPER"
What we are doing wrong to get this error ?
If helps, I can send a copy of the Database after and before the reindex.
Thanks (and sorry for my english...)
|
>If helps, I can send a copy of the Database after and before the reindex.
You can send it to support or webmaster mailbox of HXTT. Thanks.
|
Hi,
I already send the requested files to webmaster in Jan, 11 .
Did you receive them? Is there any news about my problem ?
|
>In some circunstancies (less than 5% of the operations)
Sorry for missing that thread. Clipper's using buffer concurrency check for NTX, and that flag is using one byte, I guess that maybe sometimes that flag returns the old value after 255 modification, then Clipper thought that NTX hasn't reload the modified index page so that there's invalid index information in that file.
>We also made copies of the tables before and after the "reindex all" runs. I >tried to open the incorrect DBF using cdbf for linux >(http://www.whitetown.com/cdbflinux/) and the following error was showed:
>"CDBF detected a few errors in a header of the database.
>Do you wish to write down the corrected header?"
Whether that error was reported after run "reindex all"?
|