Table Locks on the No. Series Table

atankersley

I am having a problem when a user runs a process and the procees needs to lock the No. Series Table. They get an error message and it blows the the process off. Most table locks just give a message and let the user wait untill the table is unlocked and the the process finishes. I need to be able to change the error message I am getting on the No. Series Table to the wait untill unlocked message if possible. Please help.

kine

SQL or Native? The Wait dialog is used on Native DB. The error dialog is used on MS SQL server. You cannot change that. You can only change the timeout period for MS SQL...

atankersley

Its a Native DB And I am getting this error message on other table also.

kine

And can you post the error message text?

atankersley

"The Purchase Line table cannot be locked or changed because it is already locked by the user with USER ID RPATTER2. Wait until the user is finished and then try again."

The user gets this message and then the process they were working on does not finish. The problem is the Puchase Post Process COMMITS part of the work but not all.