NPrinting stuck on email variables resolution

[stevejoyce]

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.

[Frank_S]

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-...

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-...

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/...

Kind regards...

[stevejoyce]

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.

[Frank_S]

@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...

[Frank_S]

Release notes attached.

[stevejoyce]

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.

[Emmanuelle__Bustos]

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.

[stevejoyce]

@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?

[Emmanuelle__Bustos]

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

[Ruggero_Piccoli · Accepted solution]

Hi @Emmanuelle__Bustos 

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

Best Regards,

Ruggero