First Invoice of the day takes 5-12 mins to print. How can speed

Yahoo Archive
1
Other employees have seen even the first kanban of the day takes a while to work but after that it is faster and I don't even know if that uses crystal reports. But I don't really understand what he does with the kanban or how that works.

--- In vantage@yahoogroups.com, "Dale Dalton" <daled@...> wrote:
>
> Jtannehill07 - We're on 8.03.407A and see similar behavior here and have a
> second appserver just for reports. At first I though the issue isolated to
> just one particular report but after further testing I found that to not be
> the case; what I have found is that if it is a crystal report and the user
> has been logged out over night, the first crystal report of the day on any
> given PC will take a very long time to produce results to screen or to
> printer.
>
>
>
> I'm confident our server is doing its job and pretty sure it's an issue
> associated with crystal. I can reproduce this "first report of the day"
> with any crystal report on any PC in our plant. It can take some crystal
> reports up to 10 minutes before the results actually shows up on a printer
> or screen but the next report processed will complete to screen or printer
> in a matter of seconds and it doesn't matter whether it's the same report or
> a different report.
>
>
>
> Looking at the system monitor I typically see that the report completes in
> a few seconds but never more than couple of minutes. During one test I
> watched the BAQ temp file come and go in a matter of a few seconds (7 to be
> exact), the System Monitor confirmed that the BAQ had completed in about
> that same time frame but it took 1 min for the xml data to appear in the
> reports container and a over 4 minutes for the report to come to view
>
>
>
> The steps I've taken to try and resolve this are:
>
> * Set on demand virus scanning to skip all vantage folders both on the
> server and client.
> * Tweaked System Monitor configuration settings. Found than changing
> this configuration one way or the other had little or no affect on the first
> report of the day.
> * Just to eliminate the possibility I removed all (for lack of a
> better term) dirty temp files from mfgwkr803.
> * Unchecked the "Verify on First Refresh" option on crystal reports.
>
>
>
> None of which has made a noticeable difference.
>
>
>
> If anyone has any suggestions please weigh in.
>
>
>
>
>
>
>
> Dale Dalton
>
> Complete Home Concepts
>
> Riverside MO
>
>
>
>
>
>
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> jtannehill07
> Sent: Wednesday, April 11, 2012 9:39 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] First Invoice of the day takes 5-12 mins to print. How
> can speed this up?
>
>
>
>
>
> Our first invoice of the day counter sale or regular invoice takes forever
> to print. I have set up a data Collector Set within Performance monitor that
> logs: Memory Pages Input/sec, System Processor Queue Length , and Network
> Interface Output Queue Length. This morning my data collector was started
> and I camped out at the front counter waiting on the first invoice when the
> sales man clicked process counter sale I started time with a stop watch.
> When the sales man click counter sale a question came up like continue with
> counter sale and he clicked yes it then left the hour glass up for about 4
> min and 30 sec then brought up the print prompt after he clicked print in
> about another 30 sec it had finally printed. I then stopped my data
> collector and noticed at 8:12 am(the time the process counter sale button
> was clicked) to 8:17 am there was a spike on the Pages Input/sec counter. If
> I under stand right Memory Pages Input/sec show when the server has to read
> from Hard disk information it should of have had available in ram. It only
> takes this long on the first invoice after that the salesman says it pretty
> fast. So it seems like the server is moving that info required to print a
> invoice from hard disk to ram the first time and then it stays in ram and is
> read from ram on the rest of the invoices. Does this make sense and is there
> a way to speed up that first invoice of the day?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
Our first invoice of the day counter sale or regular invoice takes forever to print. I have set up a data Collector Set within Performance monitor that logs: Memory Pages Input/sec, System Processor Queue Length , and Network Interface Output Queue Length. This morning my data collector was started and I camped out at the front counter waiting on the first invoice when the sales man clicked process counter sale I started time with a stop watch. When the sales man click counter sale a question came up like continue with counter sale and he clicked yes it then left the hour glass up for about 4 min and 30 sec then brought up the print prompt after he clicked print in about another 30 sec it had finally printed. I then stopped my data collector and noticed at 8:12 am(the time the process counter sale button was clicked) to 8:17 am there was a spike on the Pages Input/sec counter. If I under stand right Memory Pages Input/sec show when the server has to read from Hard disk information it should of have had available in ram. It only takes this long on the first invoice after that the salesman says it pretty fast. So it seems like the server is moving that info required to print a invoice from hard disk to ram the first time and then it stays in ram and is read from ram on the rest of the invoices. Does this make sense and is there a way to speed up that first invoice of the day?
3
I think I would only be speculating without knowing more about your environment. Maybe you can provide more details about your version, software/hardware setup.

Just off the top of my head there is one fairly common practice that might help you.
Set up a separate appserver for printing.
I'm only assuming you haven't done this yet.

Epicor can provide a tech tip or they might even be available in the files section of this group.


--- In vantage@yahoogroups.com, "jtannehill07" <jtannehill07@...> wrote:
>
> Our first invoice of the day counter sale or regular invoice takes forever to print. I have set up a data Collector Set within Performance monitor that logs: Memory Pages Input/sec, System Processor Queue Length , and Network Interface Output Queue Length. This morning my data collector was started and I camped out at the front counter waiting on the first invoice when the sales man clicked process counter sale I started time with a stop watch. When the sales man click counter sale a question came up like continue with counter sale and he clicked yes it then left the hour glass up for about 4 min and 30 sec then brought up the print prompt after he clicked print in about another 30 sec it had finally printed. I then stopped my data collector and noticed at 8:12 am(the time the process counter sale button was clicked) to 8:17 am there was a spike on the Pages Input/sec counter. If I under stand right Memory Pages Input/sec show when the server has to read from Hard disk information it should of have had available in ram. It only takes this long on the first invoice after that the salesman says it pretty fast. So it seems like the server is moving that info required to print a invoice from hard disk to ram the first time and then it stays in ram and is read from ram on the rest of the invoices. Does this make sense and is there a way to speed up that first invoice of the day?
>
4
Jtannehill07 - We're on 8.03.407A and see similar behavior here and have a
second appserver just for reports. At first I though the issue isolated to
just one particular report but after further testing I found that to not be
the case; what I have found is that if it is a crystal report and the user
has been logged out over night, the first crystal report of the day on any
given PC will take a very long time to produce results to screen or to
printer.



I'm confident our server is doing its job and pretty sure it's an issue
associated with crystal. I can reproduce this "first report of the day"
with any crystal report on any PC in our plant. It can take some crystal
reports up to 10 minutes before the results actually shows up on a printer
or screen but the next report processed will complete to screen or printer
in a matter of seconds and it doesn't matter whether it's the same report or
a different report.



Looking at the system monitor I typically see that the report completes in
a few seconds but never more than couple of minutes. During one test I
watched the BAQ temp file come and go in a matter of a few seconds (7 to be
exact), the System Monitor confirmed that the BAQ had completed in about
that same time frame but it took 1 min for the xml data to appear in the
reports container and a over 4 minutes for the report to come to view



The steps I've taken to try and resolve this are:

* Set on demand virus scanning to skip all vantage folders both on the
server and client.
* Tweaked System Monitor configuration settings. Found than changing
this configuration one way or the other had little or no affect on the first
report of the day.
* Just to eliminate the possibility I removed all (for lack of a
better term) dirty temp files from mfgwkr803.
* Unchecked the "Verify on First Refresh" option on crystal reports.



None of which has made a noticeable difference.



If anyone has any suggestions please weigh in.







Dale Dalton

Complete Home Concepts

Riverside MO









_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jtannehill07
Sent: Wednesday, April 11, 2012 9:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] First Invoice of the day takes 5-12 mins to print. How
can speed this up?





Our first invoice of the day counter sale or regular invoice takes forever
to print. I have set up a data Collector Set within Performance monitor that
logs: Memory Pages Input/sec, System Processor Queue Length , and Network
Interface Output Queue Length. This morning my data collector was started
and I camped out at the front counter waiting on the first invoice when the
sales man clicked process counter sale I started time with a stop watch.
When the sales man click counter sale a question came up like continue with
counter sale and he clicked yes it then left the hour glass up for about 4
min and 30 sec then brought up the print prompt after he clicked print in
about another 30 sec it had finally printed. I then stopped my data
collector and noticed at 8:12 am(the time the process counter sale button
was clicked) to 8:17 am there was a spike on the Pages Input/sec counter. If
I under stand right Memory Pages Input/sec show when the server has to read
from Hard disk information it should of have had available in ram. It only
takes this long on the first invoice after that the salesman says it pretty
fast. So it seems like the server is moving that info required to print a
invoice from hard disk to ram the first time and then it stays in ram and is
read from ram on the rest of the invoices. Does this make sense and is there
a way to speed up that first invoice of the day?





[Non-text portions of this message have been removed]
5
Hi Dale,

Just curious if you ever tried printing the first report of the day on the server?

I wonder because first thing in the morning I know I have some devices that come out of standby and paths that need to be refreshed.






--- In vantage@yahoogroups.com, "Dale Dalton" <daled@...> wrote:
>
> Jtannehill07 - We're on 8.03.407A and see similar behavior here and have a
> second appserver just for reports. At first I though the issue isolated to
> just one particular report but after further testing I found that to not be
> the case; what I have found is that if it is a crystal report and the user
> has been logged out over night, the first crystal report of the day on any
> given PC will take a very long time to produce results to screen or to
> printer.
>
>
>
> I'm confident our server is doing its job and pretty sure it's an issue
> associated with crystal. I can reproduce this "first report of the day"
> with any crystal report on any PC in our plant. It can take some crystal
> reports up to 10 minutes before the results actually shows up on a printer
> or screen but the next report processed will complete to screen or printer
> in a matter of seconds and it doesn't matter whether it's the same report or
> a different report.
>
>
>
> Looking at the system monitor I typically see that the report completes in
> a few seconds but never more than couple of minutes. During one test I
> watched the BAQ temp file come and go in a matter of a few seconds (7 to be
> exact), the System Monitor confirmed that the BAQ had completed in about
> that same time frame but it took 1 min for the xml data to appear in the
> reports container and a over 4 minutes for the report to come to view
>
>
>
> The steps I've taken to try and resolve this are:
>
> * Set on demand virus scanning to skip all vantage folders both on the
> server and client.
> * Tweaked System Monitor configuration settings. Found than changing
> this configuration one way or the other had little or no affect on the first
> report of the day.
> * Just to eliminate the possibility I removed all (for lack of a
> better term) dirty temp files from mfgwkr803.
> * Unchecked the "Verify on First Refresh" option on crystal reports.
>
>
>
> None of which has made a noticeable difference.
>
>
>
> If anyone has any suggestions please weigh in.
>
>
>
>
>
>
>
> Dale Dalton
>
> Complete Home Concepts
>
> Riverside MO
>
>
>
>
>
>
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> jtannehill07
> Sent: Wednesday, April 11, 2012 9:39 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] First Invoice of the day takes 5-12 mins to print. How
> can speed this up?
>
>
>
>
>
> Our first invoice of the day counter sale or regular invoice takes forever
> to print. I have set up a data Collector Set within Performance monitor that
> logs: Memory Pages Input/sec, System Processor Queue Length , and Network
> Interface Output Queue Length. This morning my data collector was started
> and I camped out at the front counter waiting on the first invoice when the
> sales man clicked process counter sale I started time with a stop watch.
> When the sales man click counter sale a question came up like continue with
> counter sale and he clicked yes it then left the hour glass up for about 4
> min and 30 sec then brought up the print prompt after he clicked print in
> about another 30 sec it had finally printed. I then stopped my data
> collector and noticed at 8:12 am(the time the process counter sale button
> was clicked) to 8:17 am there was a spike on the Pages Input/sec counter. If
> I under stand right Memory Pages Input/sec show when the server has to read
> from Hard disk information it should of have had available in ram. It only
> takes this long on the first invoice after that the salesman says it pretty
> fast. So it seems like the server is moving that info required to print a
> invoice from hard disk to ram the first time and then it stays in ram and is
> read from ram on the rest of the invoices. Does this make sense and is there
> a way to speed up that first invoice of the day?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
I am on vantage 8.03.404a and it is on a windows 2003 server the hardware is a dell poweredge 2850 with 4 gb of ram and two dual core 3.80 ghz processors and we do not have a seperate appserver for printing. Our company has about 16 vantage users.

--- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@...> wrote:
>
> I think I would only be speculating without knowing more about your environment. Maybe you can provide more details about your version, software/hardware setup.
>
> Just off the top of my head there is one fairly common practice that might help you.
> Set up a separate appserver for printing.
> I'm only assuming you haven't done this yet.
>
> Epicor can provide a tech tip or they might even be available in the files section of this group.
>
>
> --- In vantage@yahoogroups.com, "jtannehill07" <jtannehill07@> wrote:
> >
> > Our first invoice of the day counter sale or regular invoice takes forever to print. I have set up a data Collector Set within Performance monitor that logs: Memory Pages Input/sec, System Processor Queue Length , and Network Interface Output Queue Length. This morning my data collector was started and I camped out at the front counter waiting on the first invoice when the sales man clicked process counter sale I started time with a stop watch. When the sales man click counter sale a question came up like continue with counter sale and he clicked yes it then left the hour glass up for about 4 min and 30 sec then brought up the print prompt after he clicked print in about another 30 sec it had finally printed. I then stopped my data collector and noticed at 8:12 am(the time the process counter sale button was clicked) to 8:17 am there was a spike on the Pages Input/sec counter. If I under stand right Memory Pages Input/sec show when the server has to read from Hard disk information it should of have had available in ram. It only takes this long on the first invoice after that the salesman says it pretty fast. So it seems like the server is moving that info required to print a invoice from hard disk to ram the first time and then it stays in ram and is read from ram on the rest of the invoices. Does this make sense and is there a way to speed up that first invoice of the day?
> >
>