Order Entry, Line, Add hang up's

Thanks for that information Paul. We hope to be moving to 5.2 within the
next few months so hopefully that will solve it - assuming we can stand to
wait that long.

Tim Goertz

Date: Wed, 7 Aug 2002 15:50:27 -0500
From: "Paul Lipham" <pml@...>
Subject: RE: Order Entry, Line, Add hang up's

We had the same problem here with 4.00.904. A dump and load did not fix it
either. We noticed that after restarting the server it would be OK for a
while, but still could take a minute or two when adding a line to a sales
order.

We recently upgraded to version 5.00.349 of Vantage and the speed is back.
You can add a sales order line in a matter of seconds. We have lots of
users on a PIII Xeon 550Mzh. 512mb of Ram running RAID. The deal is we saw
a speed increase running the same hardware and the same amount of data
(2.5GB), but version 5.00 instead of 4.00

FYI
Paul L.


-----Original Message-----
From: tim.goertz@... [mailto:tim.goertz@...]
Sent: Wednesday, August 07, 2002 3:37 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Order Entry, Line, Add hang up's

We have an intermittent problem with the Line, Add, function in Order Entry
hanging up for an increasing longer period of time over the last few years
in Vantage (4.00.904). The strange part is that sometimes the program comes
up fairly quickly but many times it hangs for several minutes, sometimes
even as long as 5-10 minutes before it will go into it. We do have multiple
people entering orders. Our server is a an older IBM quad Pentium 133
processor with about 130 users on it and about 1000 mb ram and 10 gb hd with
our database probably now about 5 GB with about 4 years of Order information
in it. Although I'm sure an upgrade to our server would be helpful, this
seems to be some type of problem related directly to this particular
program, however, because we rarely have any performance issues with any
other Vantage program. I have even gone so far as to do the dump and load
all order management related tables without seeing any difference in
performance. The settings in our startup.pf file are as follows: -n 150
-spin 2000 -L 10000 -B 20000 -Mn 30 -Ma 5 -Mi 5 -Mm 4096. Has anyone else
seen this problem with this particular program or have any ideas that might
help?


Tim Goertz
IS Manager
Bermo Inc.



Tim Goertz



[Non-text portions of this message have been removed]
We have an intermittent problem with the Line, Add, function in Order Entry
hanging up for an increasing longer period of time over the last few years
in Vantage (4.00.904). The strange part is that sometimes the program comes
up fairly quickly but many times it hangs for several minutes, sometimes
even as long as 5-10 minutes before it will go into it. We do have multiple
people entering orders. Our server is a an older IBM quad Pentium 133
processor with about 130 users on it and about 1000 mb ram and 10 gb hd with
our database probably now about 5 GB with about 4 years of Order information
in it. Although I'm sure an upgrade to our server would be helpful, this
seems to be some type of problem related directly to this particular
program, however, because we rarely have any performance issues with any
other Vantage program. I have even gone so far as to do the dump and load
all order management related tables without seeing any difference in
performance. The settings in our startup.pf file are as follows: -n 150
-spin 2000 -L 10000 -B 20000 -Mn 30 -Ma 5 -Mi 5 -Mm 4096. Has anyone else
seen this problem with this particular program or have any ideas that might
help?


Tim Goertz
IS Manager
Bermo Inc.



[Non-text portions of this message have been removed]
We had the same problem here with 4.00.904. A dump and load did not fix it
either. We noticed that after restarting the server it would be OK for a
while, but still could take a minute or two when adding a line to a sales
order.

We recently upgraded to version 5.00.349 of Vantage and the speed is back.
You can add a sales order line in a matter of seconds. We have lots of
users on a PIII Xeon 550Mzh. 512mb of Ram running RAID. The deal is we saw
a speed increase running the same hardware and the same amount of data
(2.5GB), but version 5.00 instead of 4.00

FYI
Paul L.


-----Original Message-----
From: tim.goertz@... [mailto:tim.goertz@...]
Sent: Wednesday, August 07, 2002 3:37 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Order Entry, Line, Add hang up's

We have an intermittent problem with the Line, Add, function in Order Entry
hanging up for an increasing longer period of time over the last few years
in Vantage (4.00.904). The strange part is that sometimes the program comes
up fairly quickly but many times it hangs for several minutes, sometimes
even as long as 5-10 minutes before it will go into it. We do have multiple
people entering orders. Our server is a an older IBM quad Pentium 133
processor with about 130 users on it and about 1000 mb ram and 10 gb hd with
our database probably now about 5 GB with about 4 years of Order information
in it. Although I'm sure an upgrade to our server would be helpful, this
seems to be some type of problem related directly to this particular
program, however, because we rarely have any performance issues with any
other Vantage program. I have even gone so far as to do the dump and load
all order management related tables without seeing any difference in
performance. The settings in our startup.pf file are as follows: -n 150
-spin 2000 -L 10000 -B 20000 -Mn 30 -Ma 5 -Mi 5 -Mm 4096. Has anyone else
seen this problem with this particular program or have any ideas that might
help?


Tim Goertz
IS Manager
Bermo Inc.



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




Yahoo! Groups Sponsor
ADVERTISEMENT

<http://rd.yahoo.com/M=228862.2128520.3581629.1829184/D=egroupweb/S=17050071
83:HM/A=1182688/R=0/*http://adfarm.mediaplex.com/ad/ck/990-1736-1039-334%0D%
0A>

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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]
I had the same problem and with instructions from Epicor did a Dump and
reindex of the data base to fix the problem

quote line from email from epicor person about the subject " After
controlling a numerous of transactions in the Jaws database I come to think
of a known bug in the version 4 environment. Whenever a sales order line is
to be created an non indexed search on one of the selection fields will
increase the response time. This issue have been corrected in later versions
of the software. "



Mark Howard
Financial Controller
------------------------------------------------------
This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential information.
No information within this email can be forwarded via email or verbally
without the consent of the sender.

If not an intended recipient of this email, you must not copy, distribute or
rely upon it and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the sender
and not the views of Jaws Buckets & Attachments.



-----Original Message-----
From: tim.goertz@... [mailto:tim.goertz@...]
Sent: Thursday, August 08, 2002 6:37 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Order Entry, Line, Add hang up's


We have an intermittent problem with the Line, Add, function in Order Entry
hanging up for an increasing longer period of time over the last few years
in Vantage (4.00.904). The strange part is that sometimes the program comes
up fairly quickly but many times it hangs for several minutes, sometimes
even as long as 5-10 minutes before it will go into it. We do have multiple
people entering orders. Our server is a an older IBM quad Pentium 133
processor with about 130 users on it and about 1000 mb ram and 10 gb hd with
our database probably now about 5 GB with about 4 years of Order information
in it. Although I'm sure an upgrade to our server would be helpful, this
seems to be some type of problem related directly to this particular
program, however, because we rarely have any performance issues with any
other Vantage program. I have even gone so far as to do the dump and load
all order management related tables without seeing any difference in
performance. The settings in our startup.pf file are as follows: -n 150
-spin 2000 -L 10000 -B 20000 -Mn 30 -Ma 5 -Mi 5 -Mm 4096. Has anyone else
seen this problem with this particular program or have any ideas that might
help?


Tim Goertz
IS Manager
Bermo Inc.



[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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/