every month i have to produce 500 approx sales reports by Business Unit and product.
These are emailed out usually successfully , but pdf file sizes over 150k can fail .
for instance this month , i produced 59 reports successfully before a site with a 26page 150k pdf failed.
does anyone else have a successfull example of mutiple reduced pdf's over 150k?
The error message is :-
04/11/2013 11:35:40.7875995 Error The task "Reduction to PDF and EMAIL BAS Production Margin\AI - ICS Reporting v2.qvw" failed. Exception:
QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.LogBucketErrorException: Failed to generate QVW File package.. Exception=QDSMain.Exceptions.NoDocumentPackageFoundException: No Document Package found.
I found that reducing the pdf file size seems to help.
I changed the font size of the Report from 7 to 5 and this reduced the number of pages from say 20 to 10.
This resulted in less failures, though i still have sporadic ones.
My personal view is that each time a pdf is created , the qvw is opened and closed.
When it fails with large pdf's i think it is something to do with the qvw not closing before opening the next one.
Hope this helps
Another thing to try is to run pdf creaton over a "reduced" data set as the smaller the source qvw is the better the pdf generator seems to work - i've generated nearly 2000 pdf's today - one app generated 1384 pdfs