disappearing records

[aimskee]

We just upgraded our network to Novell 4.9 client version and the server version is 5.1
When entering records in a multi-user environment, some records entered and saved just disappeared on us.
We just tried to change settings on 2 client machines to File Caching off and File Commit On (they were on and off, respectively before).
Would this help our problem?
We are using VFP 6.0 which we just reinstalled so we have no service packs installed either.
Help!
Amy/Dave
dave@cicatelli.org

 

[DSummZZZ]

Start with updating the service pack (in your other thread).


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[aimskee]

thanks,
I realized that wasn't done and we're doing that now.
aimskee

 

[DSummZZZ]

I didn't mean to be sounding short there, but after rereading this thread that's the way I would have taken it.

What I meant to say was, there was an issue with VFP which the service packs should clear up. I forget which SP it was, but if you install SP5, it should help things.

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[aimskee]

thanks Dave. the app seems to be finally working again after I installed SP 5.
Also I changed some Novell property settings to turn caching Off and turn True Commit On. There were a number of errors popping up all at once in the VFP app, and I think some of them had to do with no Service Packs and some w/the Novell network upgrade. It's weird the way all these errors happened at once though. Nobody was able to do their work because of the problems. Things had been going smoothly for months and then poof. I will know for sure on Monday when all the users are inputting at once.
TY again
Aimskee

 

[dbMark]

I used to administer, troubleshoot and develop on Novell 5.0, 110 users, a couple years ago. Then we started getting weird data corruption which never made sense. Two main issues were (1) table appends getting lost, currupting the table and (2) print jobs at random would end up overwriting records in the middle of open tables.

No clear single cause, but I suspect several possibilities, such as server getting old, too much disk compression on the server, use of Windows Millennium as workstations. Novell now seems to say not to use WinMe as clients.

When we upgraded the hardware, we switched to Windows Server, since we were using Novell just as a file server. We thought about Linux, but we weren't quite ready to do that...

 

[aimskee]

You made some good points. There may be too much disk compression. I think everyone is using XP now, but I'll check on that.
Anyway the problems seem to have cleared up (for now?) due to:
1) installing Service pack 5
2) changing File Commit to True and Caching to False.

We did before and after tests and both of the above were needed if our VFP 6.0 app was going to run in a multi-user environment at all.

I will keep note of your server info before things possibly degrade again.

Thanks.
Aimskee