# Urgent!
**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2001-05-10 21:36 UTC
**Views:** 438
**Replies:** 7
**URL:** https://www.epiusers.help/t/urgent/2840
---
## Post #1 by @system
I just applied patch 5.00.319, and it didn't help. The -L problem happens during the Cost Set Entry when I choose all 9,323 parts in the part master. I guess it's a lot of records to chew on. We're in testing on 5.0 now, and once we're live it won't be an issue for the most part.
Troy Funte
Liberty Electronics
----- Original Message -----
From: David Sloan
To: vantage@yahoogroups.com
Sent: Thursday, May 10, 2001 9:30 PM
Subject: Re: [Vantage] URGENT!!!!!!!!!!
The 5.00.318 patch was supposed to have fixed this -L problem. Are you running this version?
Regards,
David Sloan
IT Manager
Entech Integrated Technologies
----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Friday, May 11, 2001 10:22 AM
Subject: Re: [Vantage] URGENT!!!!!!!!!!
In Vantage 5.0 I've set the -L to 100,000 temporarily. I say temporarily because if you leave it that high it will hurt performance. After you get your job through, you may want to set it back lower. 5,000 is the default, I believe.
----- Original Message -----
From: Wayne Cox
To: vantage@yahoogroups.com
Cc: tjacobs@...
Sent: Thursday, May 10, 2001 8:10 PM
Subject: Re: [Vantage] URGENT!!!!!!!!!!
At 11:55 PM 5/10/2001 +0000, you wrote:
>"Lock Table Overflow, increase -L on Server (915)"
Increase the value of the -L parameter in the startup.pf file. For Vantage
3, it should be in DWC\DLCSRV You'll need to stop & restart the database
service to take effect.
There's a blurb in EraNet on it at:
http://eranet.epicor.com/ansbook/vantage/public/4/46/46/46.1008mps.htm
-WC
Yahoo! Groups Sponsor
To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Production Control just attempted to get the details for one of our
machines that has 1500+ line items. Twice they tried, and got the
message.
This is the largest Job we've attempted to release all at once in
Vantage.
"Lock Table Overflow, increase -L on Server (915)"
We are running Vantage 3.
Epicor has closed for the night, and we'd like to have this resolved
by tomorrow morning.
Your help would be greatly appreciated.
Thank you in advance for help,
Thaddeus
---
## Post #3 by @system
At 11:55 PM 5/10/2001 +0000, you wrote:
>"Lock Table Overflow, increase -L on Server (915)"
Increase the value of the -L parameter in the startup.pf file. For Vantage
3, it should be in DWC\DLCSRV You'll need to stop & restart the database
service to take effect.
There's a blurb in EraNet on it at:
http://eranet.epicor.com/ansbook/vantage/public/4/46/46/46.1008mps.htm
-WC
Wayne is the man, everyone!!!!
-- In vantage@y..., Wayne Cox <wmc@u...> wrote:
> At 11:55 PM 5/10/2001 +0000, you wrote:
> >"Lock Table Overflow, increase -L on Server (915)"
>
> Increase the value of the -L parameter in the startup.pf file. For
Vantage
> 3, it should be in DWC\DLCSRV You'll need to stop & restart the
database
> service to take effect.
>
> There's a blurb in EraNet on it at:
>
http://eranet.epicor.com/ansbook/vantage/public/4/46/46/46.1008mps.htm
>
> -WC
In Vantage 5.0 I've set the -L to 100,000 temporarily. I say temporarily because if you leave it that high it will hurt performance. After you get your job through, you may want to set it back lower. 5,000 is the default, I believe.
----- Original Message -----
From: Wayne Cox
To: vantage@yahoogroups.com
Cc: tjacobs@...
Sent: Thursday, May 10, 2001 8:10 PM
Subject: Re: [Vantage] URGENT!!!!!!!!!!
At 11:55 PM 5/10/2001 +0000, you wrote:
>"Lock Table Overflow, increase -L on Server (915)"
Increase the value of the -L parameter in the startup.pf file. For Vantage
3, it should be in DWC\DLCSRV You'll need to stop & restart the database
service to take effect.
There's a blurb in EraNet on it at:
http://eranet.epicor.com/ansbook/vantage/public/4/46/46/46.1008mps.htm
-WC
Yahoo! Groups Sponsor
To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
I agree with that!
Troy
----- Original Message -----
From: tjacobs@...
To: vantage@yahoogroups.com
Sent: Thursday, May 10, 2001 8:20 PM
Subject: [Vantage] THANKS WAYNE!! Re: URGENT!!!!!!!!!!
Wayne is the man, everyone!!!!
-- In vantage@y..., Wayne Cox <wmc@u...> wrote:
> At 11:55 PM 5/10/2001 +0000, you wrote:
> >"Lock Table Overflow, increase -L on Server (915)"
>
> Increase the value of the -L parameter in the startup.pf file. For
Vantage
> 3, it should be in DWC\DLCSRV You'll need to stop & restart the
database
> service to take effect.
>
> There's a blurb in EraNet on it at:
>
http://eranet.epicor.com/ansbook/vantage/public/4/46/46/46.1008mps.htm
>
> -WC
To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
At 08:52 PM 5/10/2001 -0400, you wrote:
> Wayne is the man, everyone!!!!
Aww, jeesh! Thanks, but that's really an easy one. Think I bugged the
group about it a year & 1/2 ago myself.
-WC
The 5.00.318 patch was supposed to have fixed this -L problem. Are you running this version?
Regards,
David Sloan
IT Manager
Entech Integrated Technologies
----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Friday, May 11, 2001 10:22 AM
Subject: Re: [Vantage] URGENT!!!!!!!!!!
In Vantage 5.0 I've set the -L to 100,000 temporarily. I say temporarily because if you leave it that high it will hurt performance. After you get your job through, you may want to set it back lower. 5,000 is the default, I believe.
----- Original Message -----
From: Wayne Cox
To: vantage@yahoogroups.com
Cc: tjacobs@...
Sent: Thursday, May 10, 2001 8:10 PM
Subject: Re: [Vantage] URGENT!!!!!!!!!!
At 11:55 PM 5/10/2001 +0000, you wrote:
>"Lock Table Overflow, increase -L on Server (915)"
Increase the value of the -L parameter in the startup.pf file. For Vantage
3, it should be in DWC\DLCSRV You'll need to stop & restart the database
service to take effect.
There's a blurb in EraNet on it at:
http://eranet.epicor.com/ansbook/vantage/public/4/46/46/46.1008mps.htm
-WC
Yahoo! Groups Sponsor
To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
[Non-text portions of this message have been removed]