The error was most likely "Lock table overflow, increase -L on server
(915)"
To find advice for increasing -L, search the Epicor Answerbook for
article 3186MPS. Short answer - you have to find the parameter "# Lock
table entries" in the Progress Explorer Tool, and increase it from the
default of 8192 up to say 20,000 or 25,000. If you still have problems
then try even higher.
The other approach is to break the WIP capture into smaller chunks,
which is what you did - so don't be alarmed that the error message
disappeared!
David Le Mesurier
COGITA
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of carl.heeder@...
Sent: Friday, 2 September 2005 6:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Error while posting WIP/INV transactions
We had an error (something about needing to expand a table?) while
posting
WIP/INV transactions yesterday. Unfortunately we did not get the exact
message and we were able to post by breaking the batch into smaller date
segments.
Has anybody seen anything like this and have a clue how to fix it?
Carl Heeder
ST Inverter America
281-506-3146
Mobile: 281-221-3421
FAX 978-725-3057
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
(915)"
To find advice for increasing -L, search the Epicor Answerbook for
article 3186MPS. Short answer - you have to find the parameter "# Lock
table entries" in the Progress Explorer Tool, and increase it from the
default of 8192 up to say 20,000 or 25,000. If you still have problems
then try even higher.
The other approach is to break the WIP capture into smaller chunks,
which is what you did - so don't be alarmed that the error message
disappeared!
David Le Mesurier
COGITA
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of carl.heeder@...
Sent: Friday, 2 September 2005 6:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Error while posting WIP/INV transactions
We had an error (something about needing to expand a table?) while
posting
WIP/INV transactions yesterday. Unfortunately we did not get the exact
message and we were able to post by breaking the batch into smaller date
segments.
Has anybody seen anything like this and have a clue how to fix it?
Carl Heeder
ST Inverter America
281-506-3146
Mobile: 281-221-3421
FAX 978-725-3057
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links