A week ago I installed our application into a new customers premises. It has been a nightmare. Every so often, the app hangs, the only solution is to kill the process from the task manager. Yesterday I examined the Advantage error log, and found a whole stack of 10054 Socket errors followed by ADS 7020 (User logged out) errors. At one stage when the workstation had locked up, I examined the active queries in Advantage Data Architect and it showed active queries running for the locked terminal, there percent % complete status was in he range of -495000.00%. The problem seem to happen when a transaction is commited to the datebase. I put some diagnostic messages into the code as follows:-
DisplayMessage('Please Wait...., Saving Transaction');
UPDATE THE VARIOUS TABLES
TransactionSaved := False;
TransactionSaved := True;
When the code executes it displays the message, updates the database, hides the message and then sometimes hangs.
We have other customers with a similiar problem, but it only happens to their system every couple of weeks.
Can anybody help?