Skip to main content

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
dmarti15
Partner - Contributor II
Partner - Contributor II

Error: Exception in save source file: Could not find file TMP

Hello,

We have a QlikView Server 12.5 where the reloads succeed but less than 5% or so fail when trying to save the document.

There is no specific pattern, we have recharges from 4 hours to 10 seconds, in parallel or individually, distributed to users or not, the error can occur in any of them.

 

Some example logs:

 

Information: Reload finished successfully

Information: Start saving document

Error: Exception in save source file: Could not find file 'D:\PROD\Source_Documents\CONECTA\QVW\7b893c66-6390-4745-8260-7174d282d74f_CONECTA EEFF.qvw.tmp'.

Error: File is not ok. Target file was not saved.

Information: Closing the document.
Information: Reload finished successfully

Information: Start saving document

Error: Exception in save source file: Could not find file 'D:\PROD\Source_Documents\PIC_BI\QVW\c61fc62e-34ed-43b0-abff-de8cbf8cc6f6_PIC_BI.qvw.tmp'.

Error: File is not ok. Target file was not saved.

Information: Closing the document.

 

 

We have updated to version 12.60 and the error is still reproduced, although the log has changed:

 

Information: Reload finished successfully

Information: Start saving document

Error: Exception in save source file: Could not find file 'D:\PROD\Source_Documents\PIC_BI\QVW\tmp.OMEGA.qvw'.

Error: File is not ok. Target file was not saved.

 

 

 

Information: Closing the document.

Information: Reload finished successfully

Information: Start saving document

Error: Exception in save source file: Could not find file 'D:\PROD\Source_Documents\CONECTA\QVW\tmp.CONECTA FACTURAS DUPLICADAS.qvw'.

Error: File is not ok. Target file was not saved.

Information: Closing the document.

 

 

We have ruled out disabling the parameter EnableParallelReloads=0 because we need to launch reloads in parallel and we have seen that the error occurs mainly in single reloads.

 

any help to fix it?

 

Thanks you.

 

Labels (1)
5 Replies
Albert_Candelario

Hello @dmarti15,

Thanks for posting.

Given the randomness of the issue, it would make me think is environmental related, hence there are some specific moments that the CPU or the disk is too slow and might not be able to process this action properly.

- Have you enabled a Performance Monitor and Process monitor? 

  • That would be useful to match the times and see the performance of the server like CPU, Disk queues,... and also if the antivirus  or another software is interacting with the files (although would expect in this case another error like files is bee used by another process or similar)

I would start with this actions in order to investigate the issue. Let us know how it goes!

Cheers,

Albert

Please, remember to mark the thread as solved once getting the correct answer
Chip_Matejowsky
Support
Support

Hi @dmarti15,

Can you describe your environment a bit more?

  • Single node environment, with all QlikView services running on a single server
  • Distributed environment, with QlikView Server Service running on one server and Distribution Service running on another server
  • Cluster environment, with multiple QlikView Server Services and Distribution Services running on multiple servers

Ensure that there is enough storage available for the .tmp file to generate

Review the article Maria provided and the Scaling QlikView Publisher whitepaper it references.

Best Regards

Sr. Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!
dmarti15
Partner - Contributor II
Partner - Contributor II
Author

Hello,

Thanks for your reply.

 

We have not detected any performance issues.

On this day an error ocurred at 06:04 1.png2.png3.png

 

- On the server we have these exclusions:

Folder paths

    • C:\ProgramData\QlikTech
    • C:\Program Files (x86)\QlikView
    • C:\Program Files\QlikView

File extensions

  • .QVW
  • .QVD
  • .LOG
  • .META
  • .PGO
  • .SHARED
  • .TSHARED
  • .XML

 

Maria_Halley
Support
Support

@dmarti15 

5 minutes interwall is not enough granularity to troubleshoot this. I also think you should set up monitoring on the folder to see if there is anything else that lock the file. 

File Access and Process Monitoring - How to find locked files and the processes locking them

For more granular logging  you can use Windows performance monitoring

How to log CPU, Disk, and memory usage with Microsoft Performance Monitor on a windows 2012 Server (...