topic Re: Nprinting Task Fail by entering variables on Email in Qlik NPrinting

Nprinting Task Fail by entering variables on Email

ekurt — Wed, 31 Aug 2022 15:58:55 GMT

Hello all,
due to security regulations at the customer, we want to change the current reports from cyclus to normal. In this way, we want to ensure that the attachment is not sent as a zip but as one of the office files.

Currently we have over 180 user who gets a dynamic monthly report, based on the Supplier ID with the variables of the applikation. Everything worked fine wiht the cyclus . We are aware of the differences between cyclus and non-cyclus and have already made adjustments.

After the changeover, we have the following problem:
The tasks fail when we integrate variables from the application into the email.

Short example:

User Email Group Filter
A XY Sales Supplier_123
B ZX Sales Supplier_234

Based on the filtering, certain values are also determined or displayed in the dashboard (Text and/or Num) which we would like to include in the email.

The variables in the application are defined as follows:
vTarget = Targetvalue
vTarget_NP = $(vTarget)

Qlik Sense returns a unique result when a supplier is selected. However, it will cause a taskfail if we add X arbitrary variable to the mail. Otherwise, the report is generated and sent with the appropriate filtering for the user.
What are we missing here? Do the variables have to be defined differently?

Nprinting Version: Qlik NPrinting May 2021 SR4 Version: 21.14.8.0

Would appreciate any advice.

Best Regards
Engin

Re: Nprinting Task Fail by entering variables on Email

Lech_Miszkiewicz — Thu, 01 Sep 2022 01:22:37 GMT

Hi, To me it looks like you have no users in your publish task. Even if you use variables you still need to have user with assigned role and filters.

Hard to say more at the moment.

We would need to see tabs from your task to see how they are configured to tell you more.

cheers

Lech

Re: Nprinting Task Fail by entering variables on Email

ekurt — Thu, 01 Sep 2022 10:18:20 GMT

Enclosed the taps confuguration from the task:

(As i mentioned, task works fine with no variables in Email and all Users in the Group receives the report based on the filter)

Normal Excel Report with on Filter (date)

A Group with >100 User each with one Filter (Supplier)no Filter on Task LevelEmail with Variable

Re: Nprinting Task Fail by entering variables on Email

Lech_Miszkiewicz — Thu, 01 Sep 2022 12:18:44 GMT

ok, so I misunderstood you.

What you are saying is that when you try to insert some variable into email body in Email section of publish task then it does not work - right?

first thing is to make sure that your variable is defined properly in Qlik Sense. It must start with "=" sign and use some sort of function for example: "=Only(Supplier)".

now I understand when you mentioned this:

The variables in the application are defined as follows:
vTarget = Targetvalue
vTarget_NP = $(vTarget)

and in my opinion this will not work as your variable will not expand! This is well documented here:

https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/Troubleshooting/Variables-dont-expand-before-calculating.htm

so - go through that and make sure you have your variables properly created and try again

cheers

Re: Nprinting Task Fail by entering variables on Email

ekurt — Thu, 01 Sep 2022 20:29:35 GMT

i tried that also but unfortunately it diddn't work:

Re: Nprinting Task Fail by entering variables on Email

ekurt — Fri, 02 Sep 2022 06:27:04 GMT

i treid that also but unfortunaly it didn't work: (same Error => Invalid Parameter)

Re: Nprinting Task Fail by entering variables on Email

Lech_Miszkiewicz — Fri, 02 Sep 2022 11:16:31 GMT

Interesting. Are there any special characters returned in those variables?

I have never come across issue like this so I am not sure what else I can suggest.

@Ruggero_Piccoli & @Frank_S - maybe you guys have a suggestion?

thanks

Re: Nprinting Task Fail by entering variables on Email

Ruggero_Piccoli — Tue, 06 Sep 2022 13:59:12 GMT

Hi,

I did some tests with the variables in the email body but I'm not able to reproduce your error, I have others.

Did you set the domain account for the recipients? The issue seems more related to something missing in identity than variables. Check also the scheduler logs to see if there is a more detailed error message.

Best Regards,

Ruggero