Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW

QlikView tasks fail with cannot open file in log and files on disk are 0 KB in size

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Alexis_Touet
Former Employee
Former Employee

QlikView tasks fail with cannot open file in log and files on disk are 0 KB in size

Last Update:

Mar 24, 2023 5:06:47 AM

Updated By:

Sonja_Bauernfeind

Created date:

Mar 18, 2022 9:28:39 AM

You are seeing a large number of tasks failing. 

When checking your QlikView Distribution Service logs you can see issues to open files.

Example: 

Error: Cannot open file: '\\qlikview.domain.local\Qlikview\QlikViewStorage\Reporting\QVD\2021\xyz.qvd' (System error: Failed to open file in write mode for file: \\qlikview.domain.local\Qlikview\QlikViewStorage\Reporting\QVD\2021\xyz.qvd)

 

 

When checking for the QVD on its network location you can observe a size at 0 KB

Alexis_Touet_0-1647608732481.png

 

 

Environment

QlikView April 2020 SR3 (12.50)

 

Resolution

To troubleshoot this issue please follow these steps: 

  1. Make sure you do not have any security software scanning the QlikView folders or processes 

    See QlikView Folder And Files To Exclude From Anti-Virus Scanning

    To be sure no other software is locking the QlikView files you can also monitor the file access following the steps from this article:  File Access and Process Monitoring - How to find locked files and the processes locking them

    If you find any other 3rd party tool locking QlikView files, please contact your Internal IT team in charge of fixing this. 

  2. Check your file server Disk performance

    To save a data collection of  your storage performance you could use Performance Monitor for this: How to log CPU, Disk, and memory usage with Microsoft Performance Monitor on a windows 2012 Server (...

    You can also review the actual performance live in the Resource Monitor:

    Alexis_Touet_1-1647609446466.png

    A good indicator to check is the Disk Queue Length. A good-performing disk should show a value as close to 0 as possible.

    In this example here we can see a very high Queue Length, demonstrating a general bad performance of the disk, which ended up preventing Qlikview to open files in a timely manner.

    See QlikView and its backend File Share System.

    If you are facing this problem, please contact your Internal IT team in charge of Storage performance.

    Also, make sure you are following best practices documented in Scaling QlikView Publisher 

 

Cause 

  • 3rd party tool locking QlikView files
  • Degraded disk performance

 

Related Content

Scaling QlikView Publisher

 

 

Labels (1)
Comments
chthomas
Partner - Contributor II
Partner - Contributor II

Hello,

Thank you for your article.

But I cannot download the withepaer Scaling QlikView Publisher.

Could help me please?

 

BR

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @chthomas 

I'll look into locating the file and updating the articles referencing it.

All the best,
Sonja 

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @chthomas 

I have uploaded the .pdf to this article: Scaling the QlikView Publisher.

All the best,
Sonja 

chthomas
Partner - Contributor II
Partner - Contributor II

Hi @Sonja_Bauernfeind 

thank a lot !!!

Best

Version history
Last update:
‎2023-03-24 05:06 AM
Updated by: