Nprinting Task Fail by entering variables on Email

[ekurt]

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

[Lech_Miszkiewicz]

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 

[ekurt]

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

[Lech_Miszkiewicz]

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

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

cheers

[ekurt]

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

[ekurt]

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

[Lech_Miszkiewicz]

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

[Ruggero_Piccoli]

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