We have a program which has been running for years.

It selects a group of records and writes them under a different key (3 part key). 100 records are read but only 20 are created with the program crashing back to the main menu.

 select customer with ....

 loop

    readnext @id else stop

    read @record from customer.file, @id then

       Lock table overflow' often appears.

There are no Btree or Quickdex indexes on the file.

Any suggestions?

Chris,

Are you using any sort of locking logic in your loop? If you are, make sure you explicitly unlock any records you lock. For instance:

LOCKED=0

LOOP

 LOCK MY.FILE,THIS.ID THEN LOCKED=1

UNTIL LOCKED

REPEAT

UNLOCK MY.FILE,THIS.ID

If you're not using locking logic, then I don't have a clue, except for maybe how you've defined locking for the entire application.

Matt

Chris,

Are you using any sort of locking logic in your loop? If you are, make sure you explicitly unlock any records you lock. For instance:

LOCKED=0

LOOP

 LOCK MY.FILE,THIS.ID THEN LOCKED=1

UNTIL LOCKED

REPEAT

UNLOCK MY.FILE,THIS.ID

If you're not using locking logic, then I don't have a clue, except for maybe how you've defined locking for the entire application.

Matt

No, the program is basically as shown.

We have since found that the ARev copy commands RECORDCOPY/COPYROW produce the same error.

My feelings are moving towards the network causing the problem, but no one knows how.

I'm not sure how to set it, but Netware provides the ability to set the size of the lock table (semaphores). I think the maximum setting is 10,000, which should be more than ample for Arev.

View this thread on the forum...