# Big problems with crashing

**URL:** <https://forum.servoy.com/t/big-problems-with-crashing/2345>\
**Category:** Classic Servoy\
**Created:** [July 27, 2004, 8:02pm UTC](https://forum.servoy.com/t/big-problems-with-crashing/2345 "2004-07-27T20:02:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cjemichael](https://avatars.discourse-cdn.com/v4/letter/c/c89c15/32.png) [@cjemichael](https://forum.servoy.com/u/cjemichael)\
**Post date:** [July 27, 2004, 8:02pm UTC](https://forum.servoy.com/t/big-problems-with-crashing/2345/1 "2004-07-27T20:02:20Z")

</div>

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