Test database error

Thanks Carl!

That worked!


--- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@...> wrote:
>
> Jasper:
>
> Go to your Progress ProExplorer - select your test database under
databases,
> select configuration line, right click on the defaultconfiguration
line and
> select properties - General tab - change the # Lock Table entries
line - I
> would add 20000 to the value - Press ok to save - This will change
the -L
> value for you. Usually, the initial value is under 10000.
>
> This value needs to be increased if you are loading records.
>
> You will need to shut down your test db server and then restart the
test db
> for the change to work.
>
> Good luck.
>
> Carl Peterson
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Jasper Recto
> Sent: Tuesday, January 06, 2009 11:20 AM
> To: Vantage Groups (vantage@yahoogroups.com)
> Subject: [Vantage] Test database error
>
> I'm getting this error on my test database.
>
> Lock table overflow, increase -L on server (915)
>
> How do I fix this?
>
> Jasper
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>
I'm getting this error on my test database.

Lock table overflow, increase -L on server (915)

How do I fix this?


Jasper



[Non-text portions of this message have been removed]
Jasper:

Go to your Progress ProExplorer - select your test database under databases,
select configuration line, right click on the defaultconfiguration line and
select properties - General tab - change the # Lock Table entries line - I
would add 20000 to the value - Press ok to save - This will change the -L
value for you. Usually, the initial value is under 10000.

This value needs to be increased if you are loading records.

You will need to shut down your test db server and then restart the test db
for the change to work.

Good luck.

Carl Peterson

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Tuesday, January 06, 2009 11:20 AM
To: Vantage Groups (vantage@yahoogroups.com)
Subject: [Vantage] Test database error

I'm getting this error on my test database.

Lock table overflow, increase -L on server (915)

How do I fix this?

Jasper

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
Jasper,
Â
You need to give a little more information.
Â
Can you let us know what version you are on?
Â
Jonathan LangÂ
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699
 Â

--- On Tue, 1/6/09, Jasper Recto <jrecto@...> wrote:

From: Jasper Recto <jrecto@...>
Subject: [Vantage] Test database error
To: "Vantage Groups (vantage@yahoogroups.com)" <vantage@yahoogroups.com>
Date: Tuesday, January 6, 2009, 10:19 AM






I'm getting this error on my test database.

Lock table overflow, increase -L on server (915)

How do I fix this?

Jasper

[Non-text portions of this message have been removed]


















[Non-text portions of this message have been removed]
This is a space issue and I can understand why the techs at Epicor increase or change the settings. The problem is usually do to setup and the defaults associated with it. In order to rid your self of the problem you need to increase the table size. If you are not familiar on how to do this PLEASE call support and have them do this for you.
Â
Understand that this is a problem that occurs in many Database programs. I have incountered it in SAP, Oracle, SQL and Progress. SOmetimes the settings can be tricky and may need to be played with to find the right size.
Â
Jonathan LangÂ
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699
  Â


--- On Tue, 1/6/09, Jasper Recto <jrecto@...> wrote:

From: Jasper Recto <jrecto@...>
Subject: [Vantage] Test database error
To: "Vantage Groups (vantage@yahoogroups.com)" <vantage@yahoogroups.com>
Date: Tuesday, January 6, 2009, 10:19 AM






I'm getting this error on my test database.

Lock table overflow, increase -L on server (915)

How do I fix this?

Jasper

[Non-text portions of this message have been removed]


















[Non-text portions of this message have been removed]