We’re supporting BMW to build up the QV reports and NPrinting distribution reports & tasks. However we encounter some product issues regarding NPrinting. Please check the description below:
NPrinting version: NPrinting 17.3
Qlikview Desktop version: QlikView for Windows Version 11.20.13405.0 SR15 64-bit Edition(x64)
When run Publish tasks with hundreds of recipients without level or Preview reports with Levels, the NPrinting sever would stop responding and we lost connection of the server until we restart the server.
After we restart the server, the NPrinting requires license again.
The vary basic thing i noticed straight away is that you are using "LOCAL" connection to file. Understanding how NPrinting is working is crucial here. so i need to take you trough scenario when you use local connection:
nPrinting will use Local QV Client to open file
QV app will be loaded to memory on that computer and QV.exe process will hold this memory
nPrinting will start "clicking", making selection as a normal user would do (but a lot faster) in order to build reports for every user!!!
QV.exe process will try to cache all results of those calculation and you will run out of the memory very quickly. If the QV application is big (milions of records) then this will happen very quickly.
My suggestion is following:
make sure you split servers (QV on one box and NPrinting on another)
make sure you use qvp connection instead of local - then QVS would be reponsible for managing RAM load and you will not run out of the memory
To investigate further we would need more information.
QlikView server details:
QV application (No of rows, columns)
No of CPU (Cores)
NPrinting Server (This should be a separate server than QlikView!
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.