topic Re: NPrinting Long User Import Time in Qlik NPrinting

NPrinting Long User Import Time

justindallasverizon — Wed, 10 Sep 2025 07:35:07 GMT

Hello Folks,

I have an NPrinting system that takes a while (~12 hours) to import all the users. What should my next move be to shorten this process? I know I can get a larger servers, but are there transaction settings on the DB that I might be able to look into?

Any help is greatly appreciated.

The import will also fail, complaining about a deadlock if that helps.

Re: NPrinting Long User Import Time

Lech_Miszkiewicz — Wed, 10 Sep 2025 08:49:02 GMT

Hi @justindallasverizon

That is just crazy - something is either wrong or you really are loading such large number of users that it crashes whole thing!

What is the number of users you are trying to load?
What process are you using?
- native excel?
- native LDAP?
  - are you using LDAP filters so that only required users are loaded.
- other: API load?
Are there other task running in parallel when you try to do that?
Are there any unfinished tasks running in background which should be killed?
Are you using NewsStand for your distribution causing your repository to grow largely
- if yes - have you checked its size?
Do you have enough disk space on C drive - I saw very unstable environments due to lack of space on harddrive

It would also be important to understand number of filters you are potentially loading and overall architecture of your server.

I am assuming you are meeting the bare minimum requirements

(2 cores for server + 2 cores for engine = 4 CPU cores
minimum 8 GB of RAM which I assume you would have 16GB anyway given that we live in year 2025 and half of it is consumed by OS

Share your specs if you can and also workload of the server: number of tasks running + number of recipients. Just rough estimate) and we will take it from there.

cheers

Lech

Re: NPrinting Long User Import Time

justindallasverizon — Wed, 10 Sep 2025 13:48:37 GMT

1. What is the number of users you are trying to load?

120,000 users, 17,000 filters

2. What process are you using?

Excel Import

3. Are there other task running in parallel when you try to do that?

4. Are there any unfinished tasks running in background which should be killed?

5. Are you using NewsStand for your distribution causing your repository to grow largely

6. Do you have enough disk space on C drive - I saw very unstable environments due to lack of space on harddrive

We have 166GB of free space on the server

Thank you for your quick response. Let me know if you need more information. Also, do you think another engine would help?

Re: NPrinting Long User Import Time

hugo_andrade — Wed, 10 Sep 2025 14:17:59 GMT

Hi @justindallasverizon ,

Thanks for bringing all information @Lech_Miszkiewicz requested. That's a huge help.

Would you be able to also share a screenshot of the task configuration?

Due to the large amount of users, I would recommend you splitting the task into multiple ones until you reach a successful run.

We can help you with that.

Re: NPrinting Long User Import Time

Lech_Miszkiewicz — Wed, 10 Sep 2025 14:28:02 GMT

What are the hardware specs of the server?

having this large number of users requires large server and frankly i am jot even sure if single server will handle that number of recipients.

@Ruggero_Piccoli - can you comment on that?

Re: NPrinting Long User Import Time

justindallasverizon — Wed, 10 Sep 2025 19:11:58 GMT

Here is a pic of the task config. Do you think getting another engine would help?

Re: NPrinting Long User Import Time

hugo_andrade — Wed, 10 Sep 2025 20:17:23 GMT

That's a smart question. But another engine wouldn't help on this case. The import task is executed by the NPrinting Scheduler, not the NPrinting Engine.

So, I assume this is an LDAP Import task.

Are you able to reduce the scope of the task by breaking it into different groups?

On the Advanced section, you can add LDAP filter for users. I'm giving you an example to load all users that are member of the group "GroupName". You will need to use the group Distinguished name for it.

(&(objectCategory=Person)(sAMAccountName=*)(memberOf:1.2.840.113556.1.4.1941:=cn=GroupName,cn=Users,dc=Company,dc=local))

Then, you create another task for another group. The caution is that all users should be covered by the join of all the groups you list.

Re: NPrinting Long User Import Time

hugo_andrade — Wed, 10 Sep 2025 20:18:52 GMT

@justindallasverizon ,

It might be valuable to monitor the disk usage, CPU and RAM usage on the server during the 12h window.

Re: NPrinting Long User Import Time

Lech_Miszkiewicz — Wed, 10 Sep 2025 23:09:40 GMT

HI @hugo_andrade

as you can see from previous answers it is not LDAP, it is excel import. You can also see from documentation that large deployments are considered when you are loading say 700 users. https://help.qlik.com/en-US/nprinting/February2025/Content/NPrinting/DeployingQVNprinting/Multi-engine-example.htm .

In this case we have 170x larger volume so it is rather a question to Qlik ( @Ruggero_Piccoli @Frank_S ) if they have designed it to support such large number of users at all?

@justindallasverizon - I have asked about your server hardware details. What can you tell about that? I am sure you realized that loading such large number of users creates quite a complex relationship in repository so it may be rather important to have this information.

cheers

Lech

Re: NPrinting Long User Import Time

Frank_S — Thu, 11 Sep 2025 17:27:02 GMT

checking...

cc @Ruggero_Piccoli

Re: NPrinting Long User Import Time

justindallasverizon — Thu, 11 Sep 2025 19:51:10 GMT

Here are the specs

16GB of RAM

Processor Below (It's running the import right now which is why it's pegged out)

Re: NPrinting Long User Import Time

Lech_Miszkiewicz — Thu, 11 Sep 2025 23:04:25 GMT

Hi @justindallasverizon

This tells you the story. If it stays maxed out like this for whole import time you know you can easily add another 4 or even lot more CPU cores on top of what you have.

In your case you are running extreme minimum resources and loading extreme large volume of users so one of 2 things needs to happen:

add more resources (you definitely can and should do it in this case)
or load much less users (you probably can't do it)

cheers

Re: NPrinting Long User Import Time

Frank_S — Fri, 12 Sep 2025 15:54:27 GMT

@Lech_Miszkiewicz You are completely on point with your responses.

Further R&D suggests to consider breaking up recipient imports into smaller, separate recipient imports.

Re: NPrinting Long User Import Time

hugo_andrade — Thu, 18 Sep 2025 21:08:19 GMT

Wow.

How is RAM consumption?

Is it possible to add more resources to this server? Even though you can split the tasks, the server is pretty small and increasing it might resolve the symptom you are facing.

Good luck

Re: NPrinting Long User Import Time

justindallasverizon — Fri, 19 Sep 2025 01:00:47 GMT

I was able to convince the hardware folks that we needed more horsepower. When the change is made, I will note the performance and update this post to help others.

Re: NPrinting Long User Import Time

Lech_Miszkiewicz — Fri, 19 Sep 2025 02:03:38 GMT

Hey @justindallasverizon

do you know what you are going to get?