Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
timsaddler
Contributor II

PDF Reduction

Hello

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.

   at QDSMain.DistributeHelper.GetDocumentPackage(ILogBucket logBucket, IDictionary`2 duplicateList, Document document, eDocumentType documentType, String url, Boolean showToolBar, String reportID, Int32 maxRetries, Int32 currentRetry)

 

I suspect this is caused by the qvw not closing properly on a larger data set before it tries to re-open ?

I can produce a file if i make the report "physically" smaller - ie in this case i reduced the font size.

However he downside is that the file text is very small.

Has anyone else had this problem.

Any advice gratefully received.

Tags (2)
5 Replies
Employee
Employee

Re: PDF Reduction

Hi,

You can try increasing  the PDF Printer timeout, do the following

  • Locate the file settings.ini found in

Windows 2008 - C:\Windows\System32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch
           Windows 2003 - C:\Documents and Settings\Default User\Application Data\QlikTech\QlikViewBatch

  • Add the setting PDFPrintTimeoutInSeconds in the [Settings 7] section

[Settings 7]
PDFPrintTimeoutInSeconds= 120

  • Save settings.ini and restart QlikView Distribution Service

You might have to adjust this value to fine the correct value for you.

Bill

philipp_kunz
Contributor

Re: PDF Reduction

Hi TIm,

it seems that i have the same issue on my Server. My PDF Reoprt tasks sporadically fail without any visible reason.

Could you fix your Problem?

timsaddler
Contributor II

Re: PDF Reduction

Hello

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

philipp_kunz
Contributor

Re: PDF Reduction

Hi Tim,

thanks for your Suggestion. It is worth a try, since it does not fix the Problem on its basis.

timsaddler
Contributor II

Re: PDF Reduction

Hello

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

Community Browser