Performance issue when importing NPrinting recipients.

[Anonymous]

Hello everyone,

I'm having a pretty stalling problem when I try to import recipients into NPrinting.

I'm trying to import a hundred or so recipients into NPrinting from an array of a QlikView application, and the execution time of this Recipient Import task takes, on average, more than 10 minutes to run. For a hundred lines, this average time seems to me completely aberrant.

Worse, when I define a column as "Filter x", the execution of this import task does not finish at all.

Has anyone come across this problem before ? And if so how to solve it?

Regards,

Edit : NPrinting version is 16.5.0.0 (SR5). It tries to terminate the import recipient task but never manages to do it. I'm forced to stop it through the task manager.

No QlikView errors, no NPrinting errors, NPrinting just hangs.

Logs are as follow :

"

Application    09/10/2018    18:21:28    Informations    QlikView NPrinting

Application    09/10/2018    18:21:28    Informations    Version de QlikView NPrinting: 16.5.0.0

Application    09/10/2018    18:21:28    Informations    Log File: D:\NPrinting\Axereal\4_log\20181009_nprinting.log

Application    09/10/2018    18:21:28    Message    Exécuter Tâche: IMPORT RECIPIENTS

Application    09/10/2018    18:21:28    Message    Création du dossier de sortie: C:\Users\NPrinting\AppData\Local\Temp\2\NPrinting_Temporary_B6FFA93E41FD423996383FD3AA9840B2\

Application    09/10/2018    18:21:28    Message    Dossier de sortie créé: C:\Users\NPrinting\AppData\Local\Temp\2\NPrinting_Temporary_B6FFA93E41FD423996383FD3AA9840B2\

Application    09/10/2018    18:21:28    Message    Création du dossier de sortie: C:\Users\NPrinting\AppData\Local\Temp\2\NPrinting_Temporary_Distribution_2E5D99EFCEB24BD39F4EC155EE96136F\

Application    09/10/2018    18:21:28    Message    Dossier de sortie créé: C:\Users\NPrinting\AppData\Local\Temp\2\NPrinting_Temporary_Distribution_2E5D99EFCEB24BD39F4EC155EE96136F\

Application    09/10/2018    18:21:28    Message    Lancer la tâche d'exécution

Application    09/10/2018    18:21:28    Message    Lancer Import de destinataires

Application    09/10/2018    18:21:29    Message    Exécuter l'importation du destinataire "Import Mail Preleveurs"

Application    09/10/2018    18:21:33    Message    Destinataires chargés: 30

Application    09/10/2018    18:21:33    Message    Terminer l'importation du destinataire "Import Mail Preleveurs"

Application    09/10/2018    18:25:08    Message    Arrêt du planificateur

"

[Ruggero_Piccoli]

Hi,

Please always specify the version of Qlik NPrinting you are using. Post also all other useful information to help us to help you, like screenshots, logs, etc.

Thanks.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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.

[Ruggero_Piccoli]

Hi,

So two things:

- 16.5 is very old, please evaluate to update to 16.8 to benefit of all solved bugs. This will no impact on your issue

- Qlik NPrinting 16.* is file based. All information about users are written in an .nsq file that in fact is a xml file. Writing and reading a big text file can be very long and this doesn't depend on Qlik NPrinting.

So you could:

- wait the import time. In fact wait that the .nsq file is written. Be prepared that when that file is opened, for example by the Qlik NPrinting server, you have to wait too that it is read

- in the past when only the 16.* series existed the solution was to split the .nsq into different files. For example create a copy of the original an import some users in the first and some in the second. You will have smaller files but not synchronized automatically.

- move to the 17+ series. It has a repository that is a database that can better manages bigger amount of users. It is a version rewrited completely and suitable for an enterprise use.

I don't understand the problem with the Filter X column. Maybe there is an error in the imported Excel file.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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.