Re: PDF Distribution Finished with Error - Qlik Community

Anonymous · ‎2018-07-12

Hello guys!

I'm doing this PDF distribution using QlikView Publisher and I'm getting this error (sorry for the long log,I also attached it to the post).

It's like another task is opening some kind of shared service and the script isn't available to use it. Any clue how can I solvde this? Do I need to attach some other configuration?

Best regards!

7/9/2018 17:23:15.8556863 Error Failed to generate files. Filename=C:\ProgramData\QlikTech\DistributionService\1\temp\8691f05c-bb12-4e55-bbaf-e591d355f900\5af4066b0d6f496aa7eee91e12a229a7.pdf. Exception=System.IO.IOException: The process cannot access the file 'C:\ProgramData\QlikTech\DistributionService\1\temp\8691f05c-bb12-4e55-bbaf-e591d355f900\5af4066b0d6f496aa7eee91e12a229a7.pdf' because it is being used by another process. || at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) || at 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, Boolean checkHost) || at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy) || at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options) || at QVBWrapper.Document.GeneratePdfFile(ILogBucket logBucket, String reportId)

7/9/2018 17:23:15.8556863 Warning Generating Pdf file was unsuccessful.

7/9/2018 17:23:15.8868864 Information Closing the document.

7/9/2018 17:23:16.5264875 Information Closed the QlikView Engine successfully. ProcessID=53824

7/9/2018 17:23:21.5496963 Information Retry <1> of <5> to get document package.

7/9/2018 17:23:21.5496963 Error 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) || at QDSMain.DistributeHelper.GrabPDFFile(ILogBucket i_LogBucket, FilePackageContainer i_ParentFilePackageContainer, String i_FileName, Dictionary`2 i_DuplicateList, Document i_Document)

7/9/2018 17:23:21.5496963 Information Deleting temporary files.

7/9/2018 17:23:21.6120964 Information Closing the document.

7/9/2018 17:23:22.2516976 Information Closed the QlikView Engine successfully. ProcessID=61052

7/9/2018 17:24:46.7102459 Error The task "Reload and Distribute of Ventas\Qvw\NMS\NMS_Resumen_Ruta_Tra_PDF.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution 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) || at QDSMain.DistributeHelper.GrabPDFFile(ILogBucket i_LogBucket, FilePackageContainer i_ParentFilePackageContainer, String i_FileName, Dictionary`2 i_DuplicateList, Document i_Document) || at QDSMain.DistributeTask.RevertOneAndAlwaysOne(Document qvbDocument) || at QDSMain.DistributeTask.ReleaseQvb(Document qvbDocument) || at QDSMain.DistributeTask.Distribution(String fileName, DistributionRequest distributionRequest, TaskResult taskResult, String repeatVariableName, String currentRepeatVariableValue) || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

7/9/2018 17:24:46.7102459 Information Task Execute Duration=01:34:44.4124046

7/9/2018 17:24:46.7102459 Information Sending Alert mail

7/9/2018 17:24:51.5150543 Information TaskResult.status=Finished

7/9/2018 17:24:51.5150543 Information Notifying all triggers of new state:FinishedWithErrors

7/9/2018 17:24:51.7802548 Information Notifying all triggers of new state:FinishedWithErrors - completed

7/9/2018 17:24:51.7958548 Information Saving Task Result

Miguel_Angel_Baeyens · ‎2018-07-12

I'd take a look at this:

The process cannot access the file 'C:\ProgramData\QlikTech\DistributionService\1\temp\8691f05c-bb12-4e55-bbaf-e591d355f900\5af4066b0d6f496aa7eee91e12a229a7.pdf' because it is being used by another process.

If the PDF is open, it cannot be written. It could be the antivirus software or another process reading it.

Anonymous · ‎2018-07-12

Hi Miguel! any clue how can I check if there's any program using it?

Miguel_Angel_Baeyens · ‎2018-07-12

I have been using OpenedFilesView - View opened/locked files in your system (sharing violation issues) for years, and if my memory serves me well, I got to it because it was mentioned in the MSDN forums as a trusted software.

I'm sure there are similar tools you can find from Windows Sysinternals which will also work.