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

[dmarti15]

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.

[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

[Maria_Halley]

@dmarti15

This article discusses this issue.

https://community.qlik.com/t5/Knowledge/Task-fail-with-Error-Exception-in-save-source-file-Could-not...

[Chip_Matejowsky]

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

[dmarti15]

Hello,

Thanks for your reply.

We have not detected any performance issues.

On this day an error ocurred at 06:04 

- 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]

@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 (...

[Mats_E]

Hi

Was this issue resolved? If so how. I have the same issue (job fails with the error intermittently).

Thx in advance

Regards Mats

[dmarti15 · Accepted solution]

Hello Mat,

We have not been able to solve it, as workaround we have increased the number of retries.
So, if it fails, the next attempt usually goes well.

Regards.

[Mats_E]

Hi

Ok many thx for the quick update. I will consider upping retries. I have a long running case with vendor about this aswell

regards Mats

[Mats_E · Accepted solution]

Hi

Thought id give an update on this from our side. After upgrading to May 2023 (12.80 SR1) this issue have dissapeared for us.

Regards Mats