help me get out of this error msg

[acpmys]

hello all
we are using mfgpro and while doing mrn we are getting error msg "lock table overflow. increase -L in server" for one vendor, could any one pls tell me how to correct this.
my e-mail id is acp@ktmsmys.com
thankyou all
ACP

 

[cecsno]

You didn't say what kind of system your server was on, but on the script, parameter file, combination or what ever you start the database server with, increase the -L startup parameter. Most MFG/PRO sites set it to 100000.

hello all
we are using mfgpro and while doing mrn we are getting error msg "lock table overflow. increase -L in server" for one vendor, could any one pls tell me how to correct this.
my e-mail id is acp@ktmsmys.com
thankyou all
ACP

 

[cjh]

in your .pf file set -L to a higher number or create a <dbname>.pf file and add -L <some number> to it.

remember to start the db referencinfg the .pf file not the .db file.