topic Re: NPrinting stuck on email variables resolution in Qlik NPrinting

NPrinting stuck on email variables resolution

stevejoyce — Fri, 22 Oct 2021 17:39:32 GMT

NPrinting Feb 2021 / QSense Feb 2021 sr1

I have a scheduled publish task that now for second day stays stuck on "Starting email variables resolution" (for >11hours). It appears once another publish task gets triggered, it resolves whatever issue was going on with the original task and it completes quickly after.

Any idea what would cause this or correct log file to review? Below screenshot you can see duration between 1st and 2nd items is 11hours.

It doesn't happen every time.

The email configuration has:

To: "User_Email_Adress"

Subject: uses ap variables with %%Variable_User_....varname%%

Body: uses html

I'm guessing it's evaluating the variable used in the subject? Its just a max(date) formula in the app.

Any help on what could cause this or relevant logs this would show in. Thank you.

Re: NPrinting stuck on email variables resolution

Frank_S — Fri, 22 Oct 2021 19:07:27 GMT

Check that you are using QVP connections in all your NP connections.

Perhaps the one in question is a local and the other is QVP.

QVP connections will keep your data up to date where as local connections run the risk of stale data.

This 'could' be one reason. See reload data information in the link directly below:

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/DeployingQVNprinting/NPrinting-with-QlikView.htm#anchor-3

Another might be that the QVW is locked by another process and released by the subsequent task.

ie: perhaps you have QMC task reload dependencies.

Check the NP service account is dedicated: https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/DeployingQVNprinting/NPrinting-with-QlikView.htm#anchor-2

Another possibility is the inclusion of an unsupported item such an on open trigger (document), sheet trigger, alt state or an always one selected list/multibox property in use. In this case it could be an on open triggered in your stalled QVW.

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/GettingStarted/HowCreateConnections/Connect-to-QlikView-docs.htm#anchor-1

Kind regards...

Re: NPrinting stuck on email variables resolution

stevejoyce — Fri, 22 Oct 2021 19:18:11 GMT

Thanks @Frank_S . This is actually qlik sense, but i imagine possible causes are similar.

Do you know if this is traceable in logs, engine log may show? i.e. what steps nprinting is working on once it "starts email variables resolution". I didn't see anything in logs with current verbosity, but i can increase verbosity if i knew which one.

Re: NPrinting stuck on email variables resolution

Frank_S — Fri, 22 Oct 2021 19:46:15 GMT

@stevejoyce

I did a bit more digging.

You 'might' be encountering a defect.

I will attach the release notes for May 2021 SR 1 in a subsequent comment.

Check the defect ID OP-9920 within the release notes as the fix may pertain to your situation.

Have a good weekend...

Re: NPrinting stuck on email variables resolution

Frank_S — Fri, 22 Oct 2021 19:47:00 GMT

Release notes attached.

Re: NPrinting stuck on email variables resolution

stevejoyce — Fri, 22 Oct 2021 19:57:08 GMT

Interesting. We are saving a folder destination as well as email. Although a colleague said he saw same/similar behavior when previewing, which he aborted. Tried running the task which stuck at this point. And once he ran a random unrelated app metadata refresh, the task then completed.

I'll see if this can be related or plan upgrade to newer nprinting.

Thanks again.

Re: NPrinting stuck on email variables resolution

Emmanuelle__Bustos — Wed, 01 Dec 2021 18:26:26 GMT

Hello Guys,

We have the exact same issue with a NP May 2021 SR2, we opened a support case but I see this could actually be a bug or defect.

Re: NPrinting stuck on email variables resolution

stevejoyce — Wed, 01 Dec 2021 20:59:50 GMT

@Emmanuelle__Bustos , i restarted the nprinting services (i dont remeber if just scheduler or all, probably all) and it hasn't happened since. So it was happening every day for about a week, and hasn't happened since restarting the services, ~5weeks?

Re: NPrinting stuck on email variables resolution

Emmanuelle__Bustos — Wed, 01 Dec 2021 21:24:13 GMT

Ty for advice, we have restarted services and all the machine server but issue persists

Re: NPrinting stuck on email variables resolution

Ruggero_Piccoli — Thu, 02 Dec 2021 08:42:23 GMT

Hi @Emmanuelle__Bustos

It is planned to fix this issue in next May 2021 SR3 release.

Best Regards,

Ruggero

Re: NPrinting stuck on email variables resolution

Emmanuelle__Bustos — Thu, 02 Dec 2021 15:43:04 GMT

Thats great! Dou you have a ETA for this SR3?

Re: NPrinting stuck on email variables resolution

Ruggero_Piccoli — Thu, 02 Dec 2021 15:57:43 GMT

Hi,

No, I'm sorry but I don't have an ETA for May 2021 SR3. Please also consider this information very likely but not certain at 100%. It will be sure only after the official release.

Best Regards,

Ruggero

Re: NPrinting stuck on email variables resolution

Emmanuelle__Bustos — Thu, 02 Dec 2021 16:01:22 GMT

Ok, ill keep following up with our support case.

Thank you for the info.

Regards 🙂

Re: NPrinting stuck on email variables resolution

Emmanuelle__Bustos — Tue, 07 Dec 2021 16:13:34 GMT

Unfortunately Qlik Support told me this SR3 will be released until the end of the month. 😣

Re: NPrinting stuck on email variables resolution

Arlind — Fri, 23 Sep 2022 10:00:32 GMT

Hello,

Did the issue get resolved with the upgrade to May SR3?
Also I assume the upgrade to May SR3 is for NPrinting, can anyone confirm this? Just want to be certain.

Best regards

Re: NPrinting stuck on email variables resolution

Frank_S — Fri, 23 Sep 2022 14:40:56 GMT

The Release Notes are now available online.
https://community.qlik.com/t5/Release-Notes/tkb-p/ReleaseNotes

In the case of this issue, check the release notes for May 2021 SR 3.

https://community.qlik.com/t5/Release-Notes/Qlik-NPrinting-May-2021-SR3/ta-p/1872634#toc-hId--1646366854

The fix for the reported issue in this community thread is identified therein.

Kind regards...