Desmond., Has someone turned on disk caching on the main server drive? Either that or is sounds like you may well have a rogue network card which is flooding the network with requests. We had this happen a while ago and looked at everything BUT the network cards, believing it was a software problem.
Dave Crozier -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Desmond Lloyd Sent: 12 October 2009 15:59 To: [email protected] Subject: VFP6.0 Legacy Application: Record-Not-Available Good Morning All, Has anybody seen this before?: Modified version of SBT Accounting, been running for years with support for Work Orers, Sales Orders etc. Been running fine, approximately 100 users (+/- a few). Running on old Windows 2K Server, plenty of drive space/resources. Have been getting an intermittent "RECORD-NOT-AVAILABLE" message that scrolls in gray window afters users have updated a record. (primarily in the work order section). It gets the names of the field names and then compares the original values to memory variables, if they have changed they write a new record to an audit file that contains the key (wo in this case), new value, date, time and user ID. Besides this update and the update to main data file (work order once again), there is no direct activity accessing any tables. Have reduced the size of the audit file to about 3 million records. Record wise it's big but size wise (bytes) it isn't the biggest. A Google search and a reference to an old MSDN article suggests that I either turn off Novell Transaction tracking (lol), possibly modify the locking scheme. One thing I did do was to create a temporary file for each individual write to that file and then append the main. This seemed to work for awhile but has come back... HELP! Anyone ever seen this before? Regards, Desmond --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/a7c40a7244834b8e8d7aa607e3db1...@develop ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
