[DUG] Application problems

[Eion McIntosh (Christchurch)]

Hi

We have an application we have been using for years, using dbase tables, running on a server with users using a terminal services session to access the application. It has been running perfectly on an old server, running about 500mhz.

The issue we are having is that we have moved the application onto a new server, 3.6ghz, so its much faster, but we are finding that some database updates are either being lost or are not completing until a user quits the session. If they make a change and then do some other things in the app and then come back to the change it still shows as being done, but if we physically look at the database, at that moment, we do not see that change has been actioned. It may then get lost or not complete the update until they quit. Some reports are not show the correct results even though all the data is correct and if I run it from a copy of the system locally, it is fine. Also if doing a search on name then it may only show A to K, and not until you choose L-Z do you get the rest when you should be seeing A-Z all the time.

We are starting to get frustrated at this and are wondering if some sort of server CPU or disk caching that could be causing the system to appear to not function correctly. I have pulled all the files twice and manually reindexed them and things appear ok for a while and then go screwy, technical term, again later on.

As far as we know the BDE is all set up correctly and the application does run nice and fast and data can be viewed ok, it just they way it returns or updates some data.

If anyone able to get any guidance or suggestions?

Regards
Eion McIntosh
PPCS Ltd

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://ns3.123.co.nz/pipermail/delphi/attachments/20060926/d27ae67b/attachment.html