Vantage 8.03.408B - Printing a Crystal Report from a BAQ

Yahoo Archive
1
At this point it appears as though we have solved this problem. Thank
you all for your suggestions!!



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Saturday, December 12, 2009 10:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Vantage 8.03.408B - Printing a Crystal Report
from a BAQ





Alex, this is a great suggestion. Blake, did you do this yet?

I found this by accident earlier in the year; and you're right, it can
shave multiple seconds off the preview/print of a report or form.

I've went through EVERY report and form in Crystal Reports we have and
changed this setting. Very noticeable difference. Custom Crystal
Reports BAQs, PackSlips, PO Forms, etc... all of them are more snappy
when doing this.

Just like when you open a report in Crystal Reports Developer and it
hangs that initial "X" seconds when it searches for the default printer
stored for the report.... now that doesn't occur.

Warning: It may alter the formatting ever so slightly of some reports.
Backup before you blindly change all reports/forms.

Everyone should do this to all of your reports and forms.

Vic

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Alex Fiedler
Sent: Saturday, December 12, 2009 4:30 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Try this: Open the .rpt file with Crystal, and set the report to No
Printer. i.e. go to File -> Page Setup -> No printer (optimize for
screen display) and check that flag. Save the report.

We found this improved the print performance from around 35 seconds, to
around 7 seconds for e.g. the Sales order acknowledgement.

I used ProcMon to analyze what was happening in that 35s period. The
system was doing over 500,000 I/O operations mostly to do with the
spooler subsystem, accessing spoolsv.exe and many of the files in
c:\windows\inf\

When we changed it to No Printer, the I/O operations went to around
22,000 I/O operations, similar to a system which had full Crystal
developer installed.

Why this began to happen around 3 weeks ago, is anyone's guess.
Something made the Crystal runtime suddenly assemble rendering
information for the report, by making hundreds of thousands of file
lookups to spooler and driver files.

Note in order to make the change permanent, you will have to make this
change also to the BAQReport.rpt file which is the template for any new
BAQ-Reports you write...

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"pklein256" <pklein@...> wrote:
>
> We're on 405a and have problems with the pack slip printing. The XML
will be out there instantly, and I can manually run the Crystal -
pointing it to that XML and get it within a couple of minutes. I have
noticed that when this occurs, there are a lot of other reports (pick
tickets, order print outs etc) that are also being generated at the same
time - it's almost like it's not getting enough resources to get the
printout completed (because the XML is already completed). That same
Pack slip# could be printed later and be finished in seconds compared
to waiting 20 minutes. We have a separate apps server for printing .
Tech Support had suggested creating yet another apps server for
printing, but I haven't had time to check into that.
>

------------------------------------

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/.
<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/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
2
I'm in the process of setting this up for one of our reports that we
currently run through ODBC and some SQL tables. Needless to say the
report is very slow to print out. In hopes in approving this
performance we created a BAQ that returns everything we need to for the
report. The BAQ returns the results in under 5 seconds. We've set up
the Crystal Report and tied it to the BAQ. Followed all of the
instructions that was supplied to me by Vantage support and even had a
webex session yesterday with a support analyst to verify everything was
correct. When trying to print preview the "new" report from Vantage it
takes a good 15-20 minutes to materialize. What kind of
behavior/performance has anyone else seen when setting up reports to run
off of a BAQ?



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132



[Non-text portions of this message have been removed]
3
Blake, with no surprise to you, you may have something wrong with your
Process App Servers. Were you also not having issues with the Pack
Slip?

When you are in the BAQ Query Designer and you Analyze the results of
the query; are the results displayed fast?

When you run the BAQ Report, how quickly are the XML results dumped into
your user folder under \mfgsysdata.......... ?

If the above 2 are relatively fast then I don't *believe* it's your
Process App Servers. Your Process servers are the services that monitor
query requests and dump the results.

If I recall correctly, even with the std out of the box Pack Slip, you
still had speed issues.

How's your network?

I'm on .408B and {knock-on-wood} have no printing performance problems.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.03.408B - Printing a Crystal Report from a
BAQ

I'm in the process of setting this up for one of our reports that we
currently run through ODBC and some SQL tables. Needless to say the
report is very slow to print out. In hopes in approving this
performance we created a BAQ that returns everything we need to for the
report. The BAQ returns the results in under 5 seconds. We've set up
the Crystal Report and tied it to the BAQ. Followed all of the
instructions that was supplied to me by Vantage support and even had a
webex session yesterday with a support analyst to verify everything was
correct. When trying to print preview the "new" report from Vantage it
takes a good 15-20 minutes to materialize. What kind of
behavior/performance has anyone else seen when setting up reports to run
off of a BAQ?



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132



[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/linksYahoo! Groups Links
4
It depends on the report, but I would say the maximum time for any of my reports is about 5 minutes. Normal time is about 10 to 20 seconds. What is your System Agent Processing Delay set at? This will affect the speed of reports in Vantage.

I'm working on one right now in Access using ODBC to the Progress database that calculates current material costs for all manufactured items. It is a massive SQL statement that accesses about 8 different Progress tables and it only takes about 1.5 minutes to report on 4,631 manufactured parts.



________________________________
From: Blake Clemens <blake.clemens@...>
To: vantage@yahoogroups.com
Sent: Thu, December 10, 2009 9:19:58 AM
Subject: [Vantage] Vantage 8.03.408B - Printing a Crystal Report from a BAQ

Â
I'm in the process of setting this up for one of our reports that we
currently run through ODBC and some SQL tables. Needless to say the
report is very slow to print out. In hopes in approving this
performance we created a BAQ that returns everything we need to for the
report. The BAQ returns the results in under 5 seconds. We've set up
the Crystal Report and tied it to the BAQ. Followed all of the
instructions that was supplied to me by Vantage support and even had a
webex session yesterday with a support analyst to verify everything was
correct. When trying to print preview the "new" report from Vantage it
takes a good 15-20 minutes to materialize. What kind of
behavior/performanc e has anyone else seen when setting up reports to run
off of a BAQ?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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







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

We are having problems with Pack Slips but I think its more of a "system
wide" issue.



The results are displayed fairly quickly in the BAQ Query Designer, 2-3
seconds tops. The XML gets written in the same amount of time. The
files are only 19kb.



Our network is good. I've installed sniffers. We even had Ben Nixon
webex into our network and check things out for a few hours. He said it
looked good but believes there might be a rogue BAQ somewhere tying up
everything. I have yet to locate this BAQ.



Funny thing is we didn't have these issues before we upgrade to 408.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Thursday, December 10, 2009 9:47 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ





Blake, with no surprise to you, you may have something wrong with your
Process App Servers. Were you also not having issues with the Pack
Slip?

When you are in the BAQ Query Designer and you Analyze the results of
the query; are the results displayed fast?

When you run the BAQ Report, how quickly are the XML results dumped into
your user folder under \mfgsysdata.......... ?

If the above 2 are relatively fast then I don't *believe* it's your
Process App Servers. Your Process servers are the services that monitor
query requests and dump the results.

If I recall correctly, even with the std out of the box Pack Slip, you
still had speed issues.

How's your network?

I'm on .408B and {knock-on-wood} have no printing performance problems.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:20 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage 8.03.408B - Printing a Crystal Report from a
BAQ

I'm in the process of setting this up for one of our reports that we
currently run through ODBC and some SQL tables. Needless to say the
report is very slow to print out. In hopes in approving this
performance we created a BAQ that returns everything we need to for the
report. The BAQ returns the results in under 5 seconds. We've set up
the Crystal Report and tied it to the BAQ. Followed all of the
instructions that was supplied to me by Vantage support and even had a
webex session yesterday with a support analyst to verify everything was
correct. When trying to print preview the "new" report from Vantage it
takes a good 15-20 minutes to materialize. What kind of
behavior/performance has anyone else seen when setting up reports to run
off of a BAQ?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

[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/.
<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/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
6
Processing delay is set to 5.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Thursday, December 10, 2009 9:48 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Vantage 8.03.408B - Printing a Crystal Report from a BAQ





It depends on the report, but I would say the maximum time for any of my reports is about 5 minutes. Normal time is about 10 to 20 seconds. What is your System Agent Processing Delay set at? This will affect the speed of reports in Vantage.

I'm working on one right now in Access using ODBC to the Progress database that calculates current material costs for all manufactured items. It is a massive SQL statement that accesses about 8 different Progress tables and it only takes about 1.5 minutes to report on 4,631 manufactured parts.

________________________________
From: Blake Clemens <blake.clemens@... <mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thu, December 10, 2009 9:19:58 AM
Subject: [Vantage] Vantage 8.03.408B - Printing a Crystal Report from a BAQ


I'm in the process of setting this up for one of our reports that we
currently run through ODBC and some SQL tables. Needless to say the
report is very slow to print out. In hopes in approving this
performance we created a BAQ that returns everything we need to for the
report. The BAQ returns the results in under 5 seconds. We've set up
the Crystal Report and tied it to the BAQ. Followed all of the
instructions that was supplied to me by Vantage support and even had a
webex session yesterday with a support analyst to verify everything was
correct. When trying to print preview the "new" report from Vantage it
takes a good 15-20 minutes to materialize. What kind of
behavior/performanc e has anyone else seen when setting up reports to run
off of a BAQ?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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





[Non-text portions of this message have been removed]
7
Try this after hours (or have you already?):

Restart all Appservers (Stop Process, Task and DB..... then start DB,
Task and Process)

Try printing. Does it work OK on the very first attempt?

Is this issue replicated in all environments? (TEST, PILOT)?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Vic,

We are having problems with Pack Slips but I think its more of a "system
wide" issue.



The results are displayed fairly quickly in the BAQ Query Designer, 2-3
seconds tops. The XML gets written in the same amount of time. The
files are only 19kb.



Our network is good. I've installed sniffers. We even had Ben Nixon
webex into our network and check things out for a few hours. He said it
looked good but believes there might be a rogue BAQ somewhere tying up
everything. I have yet to locate this BAQ.



Funny thing is we didn't have these issues before we upgrade to 408.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Thursday, December 10, 2009 9:47 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ





Blake, with no surprise to you, you may have something wrong with your
Process App Servers. Were you also not having issues with the Pack
Slip?

When you are in the BAQ Query Designer and you Analyze the results of
the query; are the results displayed fast?

When you run the BAQ Report, how quickly are the XML results dumped into
your user folder under \mfgsysdata.......... ?

If the above 2 are relatively fast then I don't *believe* it's your
Process App Servers. Your Process servers are the services that monitor
query requests and dump the results.

If I recall correctly, even with the std out of the box Pack Slip, you
still had speed issues.

How's your network?

I'm on .408B and {knock-on-wood} have no printing performance problems.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:20 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage 8.03.408B - Printing a Crystal Report from a
BAQ

I'm in the process of setting this up for one of our reports that we
currently run through ODBC and some SQL tables. Needless to say the
report is very slow to print out. In hopes in approving this
performance we created a BAQ that returns everything we need to for the
report. The BAQ returns the results in under 5 seconds. We've set up
the Crystal Report and tied it to the BAQ. Followed all of the
instructions that was supplied to me by Vantage support and even had a
webex session yesterday with a support analyst to verify everything was
correct. When trying to print preview the "new" report from Vantage it
takes a good 15-20 minutes to materialize. What kind of
behavior/performance has anyone else seen when setting up reports to run
off of a BAQ?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

[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/.
<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/linksYahoo! Groups Links





[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/linksYahoo! Groups Links
8
I'll try this over the weekend. If it does print on the very first
attempt what does it mean? If it doesn't print on the very first
attempt what does it mean?



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Thursday, December 10, 2009 10:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ





Try this after hours (or have you already?):

Restart all Appservers (Stop Process, Task and DB..... then start DB,
Task and Process)

Try printing. Does it work OK on the very first attempt?

Is this issue replicated in all environments? (TEST, PILOT)?

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:53 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Vic,

We are having problems with Pack Slips but I think its more of a "system
wide" issue.

The results are displayed fairly quickly in the BAQ Query Designer, 2-3
seconds tops. The XML gets written in the same amount of time. The
files are only 19kb.

Our network is good. I've installed sniffers. We even had Ben Nixon
webex into our network and check things out for a few hours. He said it
looked good but believes there might be a rogue BAQ somewhere tying up
everything. I have yet to locate this BAQ.

Funny thing is we didn't have these issues before we upgrade to 408.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Vic Drecchio
Sent: Thursday, December 10, 2009 9:47 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Blake, with no surprise to you, you may have something wrong with your
Process App Servers. Were you also not having issues with the Pack
Slip?

When you are in the BAQ Query Designer and you Analyze the results of
the query; are the results displayed fast?

When you run the BAQ Report, how quickly are the XML results dumped into
your user folder under \mfgsysdata.......... ?

If the above 2 are relatively fast then I don't *believe* it's your
Process App Servers. Your Process servers are the services that monitor
query requests and dump the results.

If I recall correctly, even with the std out of the box Pack Slip, you
still had speed issues.

How's your network?

I'm on .408B and {knock-on-wood} have no printing performance problems.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:20 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage 8.03.408B - Printing a Crystal Report from a
BAQ

I'm in the process of setting this up for one of our reports that we
currently run through ODBC and some SQL tables. Needless to say the
report is very slow to print out. In hopes in approving this
performance we created a BAQ that returns everything we need to for the
report. The BAQ returns the results in under 5 seconds. We've set up
the Crystal Report and tied it to the BAQ. Followed all of the
instructions that was supplied to me by Vantage support and even had a
webex session yesterday with a support analyst to verify everything was
correct. When trying to print preview the "new" report from Vantage it
takes a good 15-20 minutes to materialize. What kind of
behavior/performance has anyone else seen when setting up reports to run
off of a BAQ?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

[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/.
<http://groups.yahoo.com/group/vantage/files/>
<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/linksYahoo! Groups Links

[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/.
<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/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
9
Regardless of the results, you should think about restarting your app services every night and the servers themselves once a month. You can set up a script to run on a schedule to restart the services every night. I don't recommend automating the server restart, I like to monitor this in real time myselft. I find that the services start having issues after a few days to a week of running constantly.




________________________________
From: Blake Clemens <blake.clemens@...>
To: vantage@yahoogroups.com
Sent: Thu, December 10, 2009 10:57:55 AM
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report from a BAQ

Â
I'll try this over the weekend. If it does print on the very first
attempt what does it mean? If it doesn't print on the very first
attempt what does it mean?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Vic Drecchio
Sent: Thursday, December 10, 2009 10:56 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Try this after hours (or have you already?):

Restart all Appservers (Stop Process, Task and DB..... then start DB,
Task and Process)

Try printing. Does it work OK on the very first attempt?

Is this issue replicated in all environments? (TEST, PILOT)?

-----Original Message-----
From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:53 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Vic,

We are having problems with Pack Slips but I think its more of a "system
wide" issue.

The results are displayed fairly quickly in the BAQ Query Designer, 2-3
seconds tops. The XML gets written in the same amount of time. The
files are only 19kb.

Our network is good. I've installed sniffers. We even had Ben Nixon
webex into our network and check things out for a few hours. He said it
looked good but believes there might be a rogue BAQ somewhere tying up
everything. I have yet to locate this BAQ.

Funny thing is we didn't have these issues before we upgrade to 408.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of Vic Drecchio
Sent: Thursday, December 10, 2009 9:47 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Blake, with no surprise to you, you may have something wrong with your
Process App Servers. Were you also not having issues with the Pack
Slip?

When you are in the BAQ Query Designer and you Analyze the results of
the query; are the results displayed fast?

When you run the BAQ Report, how quickly are the XML results dumped into
your user folder under \mfgsysdata. ......... ?

If the above 2 are relatively fast then I don't *believe* it's your
Process App Servers. Your Process servers are the services that monitor
query requests and dump the results.

If I recall correctly, even with the std out of the box Pack Slip, you
still had speed issues.

How's your network?

I'm on .408B and {knock-on-wood} have no printing performance problems.

-----Original Message-----
From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:20 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
Subject: [Vantage] Vantage 8.03.408B - Printing a Crystal Report from a
BAQ

I'm in the process of setting this up for one of our reports that we
currently run through ODBC and some SQL tables. Needless to say the
report is very slow to print out. In hopes in approving this
performance we created a BAQ that returns everything we need to for the
report. The BAQ returns the results in under 5 seconds. We've set up
the Crystal Report and tied it to the BAQ. Followed all of the
instructions that was supplied to me by Vantage support and even had a
webex session yesterday with a support analyst to verify everything was
correct. When trying to print preview the "new" report from Vantage it
takes a good 15-20 minutes to materialize. What kind of
behavior/performanc e has anyone else seen when setting up reports to run
off of a BAQ?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

[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/.
<http://groups. yahoo.com/ group/vantage/ files/>
<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/ linksYahoo! Groups Links

[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/.
<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/ linksYahoo! Groups Links

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







[Non-text portions of this message have been removed]
10
Typically, in order to get things working I'll restart the appservers and database throughout the day. I obviously have to kick everyone out of the system which they don't mind if it makes things run better.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Thursday, December 10, 2009 11:07 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Vantage 8.03.408B - Printing a Crystal Report from a BAQ





Regardless of the results, you should think about restarting your app services every night and the servers themselves once a month. You can set up a script to run on a schedule to restart the services every night. I don't recommend automating the server restart, I like to monitor this in real time myselft. I find that the services start having issues after a few days to a week of running constantly.

________________________________
From: Blake Clemens <blake.clemens@... <mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thu, December 10, 2009 10:57:55 AM
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report from a BAQ


I'll try this over the weekend. If it does print on the very first
attempt what does it mean? If it doesn't print on the very first
attempt what does it mean?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Vic Drecchio
Sent: Thursday, December 10, 2009 10:56 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Try this after hours (or have you already?):

Restart all Appservers (Stop Process, Task and DB..... then start DB,
Task and Process)

Try printing. Does it work OK on the very first attempt?

Is this issue replicated in all environments? (TEST, PILOT)?

-----Original Message-----
From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:53 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Vic,

We are having problems with Pack Slips but I think its more of a "system
wide" issue.

The results are displayed fairly quickly in the BAQ Query Designer, 2-3
seconds tops. The XML gets written in the same amount of time. The
files are only 19kb.

Our network is good. I've installed sniffers. We even had Ben Nixon
webex into our network and check things out for a few hours. He said it
looked good but believes there might be a rogue BAQ somewhere tying up
everything. I have yet to locate this BAQ.

Funny thing is we didn't have these issues before we upgrade to 408.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of Vic Drecchio
Sent: Thursday, December 10, 2009 9:47 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Blake, with no surprise to you, you may have something wrong with your
Process App Servers. Were you also not having issues with the Pack
Slip?

When you are in the BAQ Query Designer and you Analyze the results of
the query; are the results displayed fast?

When you run the BAQ Report, how quickly are the XML results dumped into
your user folder under \mfgsysdata. ......... ?

If the above 2 are relatively fast then I don't *believe* it's your
Process App Servers. Your Process servers are the services that monitor
query requests and dump the results.

If I recall correctly, even with the std out of the box Pack Slip, you
still had speed issues.

How's your network?

I'm on .408B and {knock-on-wood} have no printing performance problems.

-----Original Message-----
From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:20 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
Subject: [Vantage] Vantage 8.03.408B - Printing a Crystal Report from a
BAQ

I'm in the process of setting this up for one of our reports that we
currently run through ODBC and some SQL tables. Needless to say the
report is very slow to print out. In hopes in approving this
performance we created a BAQ that returns everything we need to for the
report. The BAQ returns the results in under 5 seconds. We've set up
the Crystal Report and tied it to the BAQ. Followed all of the
instructions that was supplied to me by Vantage support and even had a
webex session yesterday with a support analyst to verify everything was
correct. When trying to print preview the "new" report from Vantage it
takes a good 15-20 minutes to materialize. What kind of
behavior/performanc e has anyone else seen when setting up reports to run
off of a BAQ?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

[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/.
<http://groups. yahoo.com/ group/vantage/ files/>
<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/ linksYahoo! Groups Links

[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/.
<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/ linksYahoo! Groups Links

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

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





[Non-text portions of this message have been removed]
11
My theory/logic is that if you get "acceptable" printing on your first
attempt post restart of the Appservers then perhaps Ben's diagnosis is
right on. I know Ben very well and for many years and he's damn good.

What else is running on your Vantage server? Service Connect? APM?
What is your normal CPU utilization? NIC utilization? 100MB
network-wide?

My thoughts are that if the server is dumping the XML fast then it's
something client related. I really don't think it's anything related to
your server given the fact that the XML is there and waiting for you.

My Processing Delay in System Agent is set to 3 but again I don't think
any of this is the problem. It *seems* the server is doing her job and
dumping the BAQ results timely.

So the next things in the printing process are:

1) Client loads Crystal Reports .RPT file from the server ..\Reports
folder

Do you have virus scanning on this folder?

2) Once the Crystal Reports file is loaded into the viewer it grabs the
XML file dumped by the server.

Is virus scanning enabled here?



Finally, when you submit for PREVIEW one of these reports, how quickly
does the *initial empty* window appear? Meaning, When you preview any
report you'll get the initial "RETRIEVING DATA" window. Do you get
*that* window immediate and *then* it takes 5-10 minutes to load the
data? Or you just don't get anything until 5-10 minutes?


Last thing I would check is this: in your Crystal Reports document,
open it and go to FILE --> PAGE SETUP and look at the bottom of that
window in Printer Options. *CHECK* the box where it says NO PRINTER.
Save and retry printing. Sometimes I've seen Crystal Reports hang while
it's searching for a default printer that isn't available on that
client.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 10:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

I'll try this over the weekend. If it does print on the very first
attempt what does it mean? If it doesn't print on the very first
attempt what does it mean?



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Thursday, December 10, 2009 10:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ





Try this after hours (or have you already?):

Restart all Appservers (Stop Process, Task and DB..... then start DB,
Task and Process)

Try printing. Does it work OK on the very first attempt?

Is this issue replicated in all environments? (TEST, PILOT)?

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:53 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Vic,

We are having problems with Pack Slips but I think its more of a "system
wide" issue.

The results are displayed fairly quickly in the BAQ Query Designer, 2-3
seconds tops. The XML gets written in the same amount of time. The
files are only 19kb.

Our network is good. I've installed sniffers. We even had Ben Nixon
webex into our network and check things out for a few hours. He said it
looked good but believes there might be a rogue BAQ somewhere tying up
everything. I have yet to locate this BAQ.

Funny thing is we didn't have these issues before we upgrade to 408.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Vic Drecchio
Sent: Thursday, December 10, 2009 9:47 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Blake, with no surprise to you, you may have something wrong with your
Process App Servers. Were you also not having issues with the Pack
Slip?

When you are in the BAQ Query Designer and you Analyze the results of
the query; are the results displayed fast?

When you run the BAQ Report, how quickly are the XML results dumped into
your user folder under \mfgsysdata.......... ?

If the above 2 are relatively fast then I don't *believe* it's your
Process App Servers. Your Process servers are the services that monitor
query requests and dump the results.

If I recall correctly, even with the std out of the box Pack Slip, you
still had speed issues.

How's your network?

I'm on .408B and {knock-on-wood} have no printing performance problems.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:20 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage 8.03.408B - Printing a Crystal Report from a
BAQ

I'm in the process of setting this up for one of our reports that we
currently run through ODBC and some SQL tables. Needless to say the
report is very slow to print out. In hopes in approving this
performance we created a BAQ that returns everything we need to for the
report. The BAQ returns the results in under 5 seconds. We've set up
the Crystal Report and tied it to the BAQ. Followed all of the
instructions that was supplied to me by Vantage support and even had a
webex session yesterday with a support analyst to verify everything was
correct. When trying to print preview the "new" report from Vantage it
takes a good 15-20 minutes to materialize. What kind of
behavior/performance has anyone else seen when setting up reports to run
off of a BAQ?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

[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/.
<http://groups.yahoo.com/group/vantage/files/>
<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/linksYahoo! Groups Links

[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/.
<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/linksYahoo! Groups Links





[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/linksYahoo! Groups Links
12
Blake, wow... I know I'm telling you the obvious, but you shouldn't be
doing that throughout the day. What else runs slow to deem a mid-day
restart?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 11:11 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Typically, in order to get things working I'll restart the appservers
and database throughout the day. I obviously have to kick everyone out
of the system which they don't mind if it makes things run better.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Steven Gotschall
Sent: Thursday, December 10, 2009 11:07 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ





Regardless of the results, you should think about restarting your app
services every night and the servers themselves once a month. You can
set up a script to run on a schedule to restart the services every
night. I don't recommend automating the server restart, I like to
monitor this in real time myselft. I find that the services start
having issues after a few days to a week of running constantly.

________________________________
From: Blake Clemens <blake.clemens@...
<mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thu, December 10, 2009 10:57:55 AM
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ


I'll try this over the weekend. If it does print on the very first
attempt what does it mean? If it doesn't print on the very first
attempt what does it mean?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
Of Vic Drecchio
Sent: Thursday, December 10, 2009 10:56 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Try this after hours (or have you already?):

Restart all Appservers (Stop Process, Task and DB..... then start DB,
Task and Process)

Try printing. Does it work OK on the very first attempt?

Is this issue replicated in all environments? (TEST, PILOT)?

-----Original Message-----
From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ]
On
Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:53 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Vic,

We are having problems with Pack Slips but I think its more of a "system
wide" issue.

The results are displayed fairly quickly in the BAQ Query Designer, 2-3
seconds tops. The XML gets written in the same amount of time. The
files are only 19kb.

Our network is good. I've installed sniffers. We even had Ben Nixon
webex into our network and check things out for a few hours. He said it
looked good but believes there might be a rogue BAQ somewhere tying up
everything. I have yet to locate this BAQ.

Funny thing is we didn't have these issues before we upgrade to 408.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ]
On
Behalf
Of Vic Drecchio
Sent: Thursday, December 10, 2009 9:47 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Blake, with no surprise to you, you may have something wrong with your
Process App Servers. Were you also not having issues with the Pack
Slip?

When you are in the BAQ Query Designer and you Analyze the results of
the query; are the results displayed fast?

When you run the BAQ Report, how quickly are the XML results dumped into
your user folder under \mfgsysdata. ......... ?

If the above 2 are relatively fast then I don't *believe* it's your
Process App Servers. Your Process servers are the services that monitor
query requests and dump the results.

If I recall correctly, even with the std out of the box Pack Slip, you
still had speed issues.

How's your network?

I'm on .408B and {knock-on-wood} have no printing performance problems.

-----Original Message-----
From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:20 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
Subject: [Vantage] Vantage 8.03.408B - Printing a Crystal Report from a
BAQ

I'm in the process of setting this up for one of our reports that we
currently run through ODBC and some SQL tables. Needless to say the
report is very slow to print out. In hopes in approving this
performance we created a BAQ that returns everything we need to for the
report. The BAQ returns the results in under 5 seconds. We've set up
the Crystal Report and tied it to the BAQ. Followed all of the
instructions that was supplied to me by Vantage support and even had a
webex session yesterday with a support analyst to verify everything was
correct. When trying to print preview the "new" report from Vantage it
takes a good 15-20 minutes to materialize. What kind of
behavior/performanc e has anyone else seen when setting up reports to
run
off of a BAQ?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

[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/.
<http://groups. yahoo.com/ group/vantage/ files/>
<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/ linksYahoo! Groups Links

[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/.
<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/ linksYahoo! Groups Links

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

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





[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/linksYahoo! Groups Links
13
I would love to not have restart throughout the day but when printing
bogs down and the system runs poorly I don't have any other options.
Like right now as we speak according to the PF Usage on the Vantage
server we are using more then what we have. At this point I would
typically here complaining from everyone about poor printing and poor
Vantage performance... but nobody has complained yet. So now I'll walk
around and let myself be seen and then I'll hear comments about the
system's performance.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Thursday, December 10, 2009 11:18 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ





Blake, wow... I know I'm telling you the obvious, but you shouldn't be
doing that throughout the day. What else runs slow to deem a mid-day
restart?

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 11:11 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Typically, in order to get things working I'll restart the appservers
and database throughout the day. I obviously have to kick everyone out
of the system which they don't mind if it makes things run better.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Steven Gotschall
Sent: Thursday, December 10, 2009 11:07 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Regardless of the results, you should think about restarting your app
services every night and the servers themselves once a month. You can
set up a script to run on a schedule to restart the services every
night. I don't recommend automating the server restart, I like to
monitor this in real time myselft. I find that the services start
having issues after a few days to a week of running constantly.

________________________________
From: Blake Clemens <blake.clemens@...
<mailto:blake.clemens%40d-m-c.com>
<mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Thu, December 10, 2009 10:57:55 AM
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

I'll try this over the weekend. If it does print on the very first
attempt what does it mean? If it doesn't print on the very first
attempt what does it mean?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On
Behalf
Of Vic Drecchio
Sent: Thursday, December 10, 2009 10:56 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Try this after hours (or have you already?):

Restart all Appservers (Stop Process, Task and DB..... then start DB,
Task and Process)

Try printing. Does it work OK on the very first attempt?

Is this issue replicated in all environments? (TEST, PILOT)?

-----Original Message-----
From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ]
On
Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:53 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Vic,

We are having problems with Pack Slips but I think its more of a "system
wide" issue.

The results are displayed fairly quickly in the BAQ Query Designer, 2-3
seconds tops. The XML gets written in the same amount of time. The
files are only 19kb.

Our network is good. I've installed sniffers. We even had Ben Nixon
webex into our network and check things out for a few hours. He said it
looked good but believes there might be a rogue BAQ somewhere tying up
everything. I have yet to locate this BAQ.

Funny thing is we didn't have these issues before we upgrade to 408.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ]
On
Behalf
Of Vic Drecchio
Sent: Thursday, December 10, 2009 9:47 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: RE: [Vantage] Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Blake, with no surprise to you, you may have something wrong with your
Process App Servers. Were you also not having issues with the Pack
Slip?

When you are in the BAQ Query Designer and you Analyze the results of
the query; are the results displayed fast?

When you run the BAQ Report, how quickly are the XML results dumped into
your user folder under \mfgsysdata. ......... ?

If the above 2 are relatively fast then I don't *believe* it's your
Process App Servers. Your Process servers are the services that monitor
query requests and dump the results.

If I recall correctly, even with the std out of the box Pack Slip, you
still had speed issues.

How's your network?

I'm on .408B and {knock-on-wood} have no printing performance problems.

-----Original Message-----
From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com> ] On
Behalf
Of Blake Clemens
Sent: Thursday, December 10, 2009 9:20 AM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
<mailto:vantage% 40yahoogroups. com>
Subject: [Vantage] Vantage 8.03.408B - Printing a Crystal Report from a
BAQ

I'm in the process of setting this up for one of our reports that we
currently run through ODBC and some SQL tables. Needless to say the
report is very slow to print out. In hopes in approving this
performance we created a BAQ that returns everything we need to for the
report. The BAQ returns the results in under 5 seconds. We've set up
the Crystal Report and tied it to the BAQ. Followed all of the
instructions that was supplied to me by Vantage support and even had a
webex session yesterday with a support analyst to verify everything was
correct. When trying to print preview the "new" report from Vantage it
takes a good 15-20 minutes to materialize. What kind of
behavior/performanc e has anyone else seen when setting up reports to
run
off of a BAQ?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

[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/.
<http://groups. yahoo.com/ group/vantage/ files/>
<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/ linksYahoo! Groups Links

[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/.
<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/ linksYahoo! Groups Links

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

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

[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/.
<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/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
14
We're on 405a and have problems with the pack slip printing. The XML will be out there instantly, and I can manually run the Crystal – pointing it to that XML and get it within a couple of minutes. I have noticed that when this occurs, there are a lot of other reports (pick tickets, order print outs etc) that are also being generated at the same time – it's almost like it's not getting enough resources to get the printout completed (because the XML is already completed). That same Pack slip# could be printed later and be finished in seconds compared to waiting 20 minutes. We have a separate apps server for printing . Tech Support had suggested creating yet another apps server for printing, but I haven't had time to check into that.
15
Try this: Open the .rpt file with Crystal, and set the report to No Printer. i.e. go to File -> Page Setup -> No printer (optimize for screen display) and check that flag. Save the report.

We found this improved the print performance from around 35 seconds, to around 7 seconds for e.g. the Sales order acknowledgement.

I used ProcMon to analyze what was happening in that 35s period. The system was doing over 500,000 I/O operations mostly to do with the spooler subsystem, accessing spoolsv.exe and many of the files in c:\windows\inf\

When we changed it to No Printer, the I/O operations went to around 22,000 I/O operations, similar to a system which had full Crystal developer installed.

Why this began to happen around 3 weeks ago, is anyone's guess. Something made the Crystal runtime suddenly assemble rendering information for the report, by making hundreds of thousands of file lookups to spooler and driver files.

Note in order to make the change permanent, you will have to make this change also to the BAQReport.rpt file which is the template for any new BAQ-Reports you write...


--- In vantage@yahoogroups.com, "pklein256" <pklein@...> wrote:
>
> We're on 405a and have problems with the pack slip printing. The XML will be out there instantly, and I can manually run the Crystal – pointing it to that XML and get it within a couple of minutes. I have noticed that when this occurs, there are a lot of other reports (pick tickets, order print outs etc) that are also being generated at the same time – it's almost like it's not getting enough resources to get the printout completed (because the XML is already completed). That same Pack slip# could be printed later and be finished in seconds compared to waiting 20 minutes. We have a separate apps server for printing . Tech Support had suggested creating yet another apps server for printing, but I haven't had time to check into that.
>
16
Alex, this is a great suggestion. Blake, did you do this yet?

I found this by accident earlier in the year; and you're right, it can
shave multiple seconds off the preview/print of a report or form.

I've went through EVERY report and form in Crystal Reports we have and
changed this setting. Very noticeable difference. Custom Crystal
Reports BAQs, PackSlips, PO Forms, etc... all of them are more snappy
when doing this.

Just like when you open a report in Crystal Reports Developer and it
hangs that initial "X" seconds when it searches for the default printer
stored for the report.... now that doesn't occur.

Warning: It may alter the formatting ever so slightly of some reports.
Backup before you blindly change all reports/forms.

Everyone should do this to all of your reports and forms.



Vic


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Alex Fiedler
Sent: Saturday, December 12, 2009 4:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 8.03.408B - Printing a Crystal Report
from a BAQ

Try this: Open the .rpt file with Crystal, and set the report to No
Printer. i.e. go to File -> Page Setup -> No printer (optimize for
screen display) and check that flag. Save the report.

We found this improved the print performance from around 35 seconds, to
around 7 seconds for e.g. the Sales order acknowledgement.

I used ProcMon to analyze what was happening in that 35s period. The
system was doing over 500,000 I/O operations mostly to do with the
spooler subsystem, accessing spoolsv.exe and many of the files in
c:\windows\inf\

When we changed it to No Printer, the I/O operations went to around
22,000 I/O operations, similar to a system which had full Crystal
developer installed.

Why this began to happen around 3 weeks ago, is anyone's guess.
Something made the Crystal runtime suddenly assemble rendering
information for the report, by making hundreds of thousands of file
lookups to spooler and driver files.

Note in order to make the change permanent, you will have to make this
change also to the BAQReport.rpt file which is the template for any new
BAQ-Reports you write...


--- In vantage@yahoogroups.com, "pklein256" <pklein@...> wrote:
>
> We're on 405a and have problems with the pack slip printing. The XML
will be out there instantly, and I can manually run the Crystal -
pointing it to that XML and get it within a couple of minutes. I have
noticed that when this occurs, there are a lot of other reports (pick
tickets, order print outs etc) that are also being generated at the same
time - it's almost like it's not getting enough resources to get the
printout completed (because the XML is already completed). That same
Pack slip# could be printed later and be finished in seconds compared
to waiting 20 minutes. We have a separate apps server for printing .
Tech Support had suggested creating yet another apps server for
printing, but I haven't had time to check into that.
>




------------------------------------

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/linksYahoo! Groups Links