Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

joaquinlr
Valued Contributor II

Publisher PDF & SR6

Hi;

We'vw QlikView SR6 11.20.12354.0 with Publisher PDF.

Since we've upgraded to SR6 some tasks that previously completed succesfully, now fails with this message;

ErrorFailed to generate files. Filename=D:\ProgramData\QlikTech\DistributionService\1\temp\0ad4931f-2fec-405b-94ff-f78e943075c5\41d428cac19c482a95653ab70d650cd3.pdf. Exception=System.IO.IOException: El proceso no puede obtener acceso al archivo 'D:\ProgramData\QlikTech\DistributionService\1\temp\0ad4931f-2fec-405b-94ff-f78e943075c5\41d428cac19c482a95653ab70d650cd3.pdf' porque está siendo utilizado en otro proceso.

   en System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)

   en System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath)

   en System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)

   en System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)

   en QVBWrapper.Document.GeneratePdfFile(ILogBucket logBucket, String reportId)

This is a sample of one task that email a PDF report to one email address, this task has been working without problems since Januray,

If I stop and start again QlikView Distribution Service and run the task again, it has completed succesfully.

Where is the problem? Is it a bug?

Thank you:
Joaquín

12 Replies

Re: Publisher PDF & SR6

Hi

For me it look like a permission issue and same processes used more then once at the same time.

For Example:

If you have two task schedule parallel.

Reload and distribute try to split them into two. Always use depend tasks for schedule.

Make sure that the account you use have full access on the QlikView folder.

Hope it helped.

Regards

ASHFAQ

joaquinlr
Valued Contributor II

Re: Publisher PDF & SR6

Hi:

The user has the same permissions before and after restart QlikView Distribution Service ... if were a permission problem the task failed all the time.

Joaquín

Re: Publisher PDF & SR6

Hi,

In that case try by splitting tasks.

Make sure you don't have preload option selected in any of your application.

Regards

ASHFAQ

joaquinlr
Valued Contributor II

Re: Publisher PDF & SR6

Hi:

There are some tasks that create qvd, all night long; one main task (with charts and KPI) that reload from qvd and distribute ... some minutes later a triggered task sends the PDF by mail.

Since we upgraded to SR6 some PDF distribution, like this, fails some times and other times they work fine.

This is the reason that I don't understand the problem

Joaquín

joaquinlr
Valued Contributor II

Re: Publisher PDF & SR6

Hi:

Where is this preload option?

Thanks again,

Joaquín

Re: Re: Publisher PDF & SR6

For that you have to go to user document.

Look at the image attached.

Regards

ASHFAQ

joaquinlr
Valued Contributor II

Re: Publisher PDF & SR6

Hi

All our documents have unchecked this option.

This task is splitted for emailing a report PDF with a trigger where main.qvw has successfully finished

Regards

Joaquín

Re: Publisher PDF & SR6

Hi,

When this tasks run do some other tasks run simultaneously?

if yes schedule in such a way that it does not have any dependency.

may be Bill Britt can bring more light onto this.

Regards

ASHFAQ

joaquinlr
Valued Contributor II

Re: Publisher PDF & SR6

Yes but not related with the same source qvw

Community Browser