I have a solution with 20 odd users most of the time. They are mainly on Win XP with 2 on Mac OS 10.3 and 2 on Win 2000. All PC clients are using Java version 1.4.2_04-b05. The server is Win 2000 Server SP4 with MS SQL 2000 SP3. It has 512Mb ram and is a dual P3/800Mhz. It only runs servoy and MS SQL.
It’s quite a complex billing system and has just recently started to grind to a halt.
Everything was working OK ish with Servoy R2 2.0 - but there were a few glitches which were supposedly fixed by 2.0.4 - so I upgraded.
At first this seemed fine, but over a week or so, the solution started to grind to a halt.
The main problem seems to be with the estimating bit of my solution which has 2 tables (estimates and estimate_lines). There are about 600 estimates, each with about 10 line items - so not lots of data.
Performing any of the following actions seems to start the slow down - adding new estimate line items, deleting an estimate with associated line items, duplicating an estimate (I use a method which loops through and dupes the line items). After 5 minutes or so of performing such actions, Servoy client grinds to a halt and is using 100% of the CPU. The server seems relatively unaffected - just that the client has crashed out.
I’ve tried re-coding calculation fields, relationships, methods and forms, but nothing seems to help. The problem could be something like a calulation field and/or relationship which is somehow getting into a loop?
Unfortunately it is a real pain to roll back Servoy server with clients who are using Roaming Profiles, since their PCs and the server seems to keep a cache of the latest build and won’t delete it. I had to roll back a servoy version 6 months ago and it took about a day of wiping everyone’s profiles. I am not sure this is the problem though?
My question is 2 fold:
a) where on the server are the relavant log files
b) what should I be looking for to help me de-bug this
Please let me know asap.
Ta