Error (915)

Yahoo Archive
1
Have you tried disconnecting these users with proshut? One of the options is to
disconnect a user, and will give you a list of connected users.

Proshut is a "low-Level" utility that you run from the command prompt. It should
be in $DLC/bin, where $DLC is where you installed Progress.

HTH.

jason.gippner@... wrote:

> Late last week we experienced a power loss during a snow storm and our battery
> back up did not keep the Vantage server running. As a result we have two
> employees that I cannot remove from Vantage. When I try to clock them out
> through data collection, I receive the following error:
> Lock table overflow, increase -L on server (915). Does anyone know what this
> error message means?
>
> Thank you,
>
> Jason Gippner
> APW/Wright Line
> Grass Valley, CA
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com

--
/* ============================================================== */

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada PEG Member 1998051404

Specialists in Progress Software development since 1985
2
Late last week we experienced a power loss during a snow storm and our battery
back up did not keep the Vantage server running. As a result we have two
employees that I cannot remove from Vantage. When I try to clock them out
through data collection, I receive the following error:
Lock table overflow, increase -L on server (915). Does anyone know what this
error message means?

Thank you,

Jason Gippner
APW/Wright Line
Grass Valley, CA
3
the -L parameter specifies how many record locks you may have in Progress.
You need to increase the parameter to a larger number. I think the default
is 5000. I am not sure how much overhead there is in increasing this
value, but I when I was getting that message, I increased it to 10,000 and
have not gotten a message since.

BTW, the parameter is set in the startup.pf file
<servername>//epicor/progress/bin
directory.
4
There is a program called endact.r. I will e-mail it to you offline. For future reference, support also has the fix.

Alex Neutgens
Controller
Circuit Check, Inc.
763-694-4110

-----Original Message-----
From: jason.gippner@... [SMTP:jason.gippner@...]
Sent: Monday, January 29, 2001 10:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Error (915)

Late last week we experienced a power loss during a snow storm and our battery
back up did not keep the Vantage server running. As a result we have two
employees that I cannot remove from Vantage. When I try to clock them out
through data collection, I receive the following error:
Lock table overflow, increase -L on server (915). Does anyone know what this
error message means?

Thank you,

Jason Gippner
APW/Wright Line
Grass Valley, CA




To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com
5
Thank you Alex!






Alex Neutgens <alex.neutgens@...> on 01/29/2001 09:15:41 AM

Please respond to vantage@yahoogroups.com

To: "'vantage@yahoogroups.com'" <vantage@yahoogroups.com>
cc: (bcc: Jason Gippner/Wright Line)

Subject: RE: [Vantage] Error (915)



There is a program called endact.r. I will e-mail it to you offline. For
future reference, support also has the fix.

Alex Neutgens
Controller
Circuit Check, Inc.
763-694-4110

-----Original Message-----
From: jason.gippner@... [SMTP:jason.gippner@...]
Sent: Monday, January 29, 2001 10:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Error (915)

Late last week we experienced a power loss during a snow storm and our battery
back up did not keep the Vantage server running. As a result we have two
employees that I cannot remove from Vantage. When I try to clock them out
through data collection, I receive the following error:
Lock table overflow, increase -L on server (915). Does anyone know what this
error message means?

Thank you,

Jason Gippner
APW/Wright Line
Grass Valley, CA




To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com



To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com
6
Just for the record.

Each lock table entry requires 18 bytes on shared memory machines, and should
be defined in increments of 32. If the number requested is not a multiple of
32, progress will increment the number of slots to the nearest multiple. There
is no performance penalty in making the table large. I have successfully run
systems with lock tables in the 50,000 range. However, if you receive this
error unexpectedly, you should investigate the cause, as it usually indicates a
badly scoped transaction.

Plaman Dick wrote:

> the -L parameter specifies how many record locks you may have in Progress.
> You need to increase the parameter to a larger number. I think the default
> is 5000. I am not sure how much overhead there is in increasing this
> value, but I when I was getting that message, I increased it to 10,000 and
> have not gotten a message since.
>
> BTW, the parameter is set in the startup.pf file
> <servername>//epicor/progress/bin
> directory.
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com

--
/* ============================================================== */

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada PEG Member 1998051404

Specialists in Progress Software development since 1985
7
A couple of weeks ago we experienced problems with Lock table overflow errors
after a power outage took our Vantage server down (yes, we are in California but
this was related to a snow storm, not our deregulated power industry!). I
received some good advice from several members of the group and have tried all
suggestions to no avail. We have 2 employees who are trapped in Vantage. They
have no open transactions but cannot clock out of data collection. When they
try they receive the error message "Lock table overflow, increase -L on server
(915)". I have run ENDACT.R (thanks Alex!) and I have increased the -L
parameter (thanks Dick and William!) gradually to 50,000 but still receive the
same message when attempting to clock out the two individuals. Does anyone have
any other suggestions that I might try?

Thank you,

Jason Gippner
IT Administrator
APW/Wright Line
Grass Valley, California
8
Are you running vantage version 3?

jason.gippner@... wrote:
>
> A couple of weeks ago we experienced problems with Lock table overflow errors
> after a power outage took our Vantage server down (yes, we are in California but
> this was related to a snow storm, not our deregulated power industry!). I
> received some good advice from several members of the group and have tried all
> suggestions to no avail. We have 2 employees who are trapped in Vantage. They
> have no open transactions but cannot clock out of data collection. When they
> try they receive the error message "Lock table overflow, increase -L on server
> (915)". I have run ENDACT.R (thanks Alex!) and I have increased the -L
> parameter (thanks Dick and William!) gradually to 50,000 but still receive the
> same message when attempting to clock out the two individuals. Does anyone have
> any other suggestions that I might try?
>
> Thank you,
>
> Jason Gippner
> IT Administrator
> APW/Wright Line
> Grass Valley, California
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com
9
No Joe,

We are running Vantage 4.00.904 and Progress 9.0B.






Joe Konecny <jkonecn@...> on 02/07/2001 09:16:06 AM

Please respond to vantage@yahoogroups.com

To: vantage@yahoogroups.com
cc: (bcc: Jason Gippner/Wright Line)

Subject: Re: [Vantage] Error (915)



Are you running vantage version 3?

jason.gippner@... wrote:
>
> A couple of weeks ago we experienced problems with Lock table overflow errors
> after a power outage took our Vantage server down (yes, we are in California
but
> this was related to a snow storm, not our deregulated power industry!). I
> received some good advice from several members of the group and have tried all
> suggestions to no avail. We have 2 employees who are trapped in Vantage.
They
> have no open transactions but cannot clock out of data collection. When they
> try they receive the error message "Lock table overflow, increase -L on server
> (915)". I have run ENDACT.R (thanks Alex!) and I have increased the -L
> parameter (thanks Dick and William!) gradually to 50,000 but still receive the
> same message when attempting to clock out the two individuals. Does anyone
have
> any other suggestions that I might try?
>
> Thank you,
>
> Jason Gippner
> IT Administrator
> APW/Wright Line
> Grass Valley, California
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com


To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com