Data field not updated Occasionally on one machine
Hi everybody, I am having a rather peculiar problem and hope you can shed some light on it. This is an in-house developed solution and has been running for more than 10 years. Recently I found that there is one user (or maybe one machine) having the problem of updating a particular column every now and then. I've done some investigation and following is my finds: 1) when the problem occurred (ie, the change to this particular field was not saved) the changes to other fields of the record were saved. 2) the subsequent tries normally work. 3) the error ratio is about 1/5. This is a frequently used table accessed by multiple users at any given time. There has never been such problem reported in other data columns of the table. The fact that the same code works fine on other computers (and, it happens on this computer occasionally) indicates the data saving logic is correct. It looks like a machine related issue, but, other aspects of the WS (other applications, and other functions of the same application) works fine...I have run out of ideas on how to troubleshoot this problem! Thank you all in advance for your help!