The QlikView Server Event log shows:
Warning BlobDbTx: Failed to start session: failed to lock file \\SHARE\DOCUMENT.QVW.TShared (Insufficient system resources exist to complete the requested service.)
Warning BlobDbTx: Failed to end session: not all operations in the session finished successfully.
Warning BlobDbTx: Failed to start session: failed to flush file \\SHARE\DOCUMENT.QVW.TShared (Insufficient system resources exist to complete the requested service.).
Environment:
- QlikView Server all versions
This error is passed on by the Microsoft APIs, in particular, the function LockFileEx, which in this case returns with status ERROR_LOCK_VIOLATION and the error "Insufficient system resources exist to complete the requested service".
According to Microsoft's documentation, the function should not return until a lock is granted. Failures in the function is out of control of the Qlik software.
The file share used to store the .TSHARED files (or in some cases .META files and .pgo files) does not have sufficient resources to handle the demand.
Review the following on the file share system:
- CPU usage
- Read Write (I/O) queues
- Network utilization
In most cases, allowing for the allocation of additional CPU cores to the server hosting the fileshare is sufficient. Further resource monitoring will be required if CPU was not the bottleneck.