Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Buffering, Transaction and NOVELL 4.11
Message
From
10/03/2000 09:20:36
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00343885
Message ID:
00344144
Views:
23
>>I have and old Fox 2.5 DOS program to update quantities in three tables using another table with the new quantities using SCAN and REPLACE.
>>
>>Recently I added to it Transactions, Buffering and normally it work very well.
>>
>>Today I had to update 501 records. The first 500 were ok, but with the record 501 I had a error message "that somebody was the table". I change the record order and always the problem was in the last register.
>>
>>I run the program with a database copy on a local drive and it runs correctly
>>Also I erase buffering and Transaction and the program works perfectly on the netware
>>
>>I think there is a Novell parameter. but I have no idea what it is.
>>
>>TIA
>
>
>You could try to change the AUTOEXEC.NCF on the Novell server
>
>
>add the following line or type it from system console screen
>
>SET MAXIMUM RECORD LOCKS PER CONNECTION=10000
>
>I think that default is 500 and maximum 10000
>
>Hope this will help
>zoran@dunavel.com


Thanks, I changed the parameter to 400,000 (It's old value was 20,000) and the problem is the same

I looked at server console and saw the next message:
Se excedió el umbral de bloqueo de registros 17. Total de violaciones 1027.

The threshold exceeded the lock records 17. Total violation number 1027
Previous
Reply
Map
View

Click here to load this message in the networking platform