Wrong data is being generated by NPrinting

[rafalcqlik]

Hi,

We are facing very weird issue. We have a dedicated Qlik Sense app just for NPrinting reports. There is that table with many columns but to simplify it's something like this:

Date	Amount	Territory	Sales Rep
6/19/2020	267	Atlanta	John
6/20/2020	14	Atlanta	John
6/19/2020	45	Atlanta	John
6/20/2020	123	Atlanta	John
6/19/2020	53	Atlanta	John
6/20/2020	123	Atlanta	John
6/19/2020	543	Atlanta	John
6/20/2020	123	Atlanta	John
6/19/2020	543	Atlanta	John
6/20/2020	123	Atlanta	John
6/19/2020	543	Atlanta	John
6/20/2020	123	Atlanta	John
6/19/2020	543	Atlanta	John
6/19/2020	45	New York	Mike
6/20/2020	123	New York	Mike
6/19/2020	54	New York	Mike
6/20/2020	123	New York	Mike
6/19/2020	65	New York	Mike
6/20/2020	123	New York	Mike
6/19/2020	76	New York	Mike
6/20/2020	12	New York	Mike
6/19/2020	123	New York	Mike
6/20/2020	65	New York	Mike
6/19/2020	65	New York	Mike
6/20/2020	123	New York	Mike
6/19/2020	654	New York	Mike

So I have some territory and only one sales rep for each territory and that's how I see it in Qlik Sense. Now what NPrinting generated was something like this:

Date	Amount	Territory	Sales Rep
6/19/2020	267	Atlanta	John
6/20/2020	14	Atlanta	John
6/19/2020	45	Atlanta	John
6/20/2020	123	Atlanta	John
6/19/2020	53	Atlanta	John
6/20/2020	123	Atlanta	Mike
6/19/2020	543	Atlanta	John
6/20/2020	123	Atlanta	John
6/19/2020	543	Atlanta	John
6/20/2020	123	Atlanta	John
6/19/2020	543	Atlanta	John
6/20/2020	123	Atlanta	John
6/19/2020	543	Atlanta	John
6/19/2020	45	New York	Mike
6/20/2020	123	New York	Mike
6/19/2020	54	New York	Mike
6/20/2020	123	New York	Mike
6/19/2020	65	New York	Mike
6/20/2020	123	New York	Mike
6/19/2020	76	New York	Mike
6/20/2020	12	New York	Mike
6/19/2020	123	New York	Mike
6/20/2020	65	New York	Mike
6/19/2020	65	New York	Mike
6/20/2020	123	New York	Mike
6/19/2020	654	New York	Mike

So it's like NPrinting mixed up some data. I checked that in that exact table in Qlik Sense and the data is ok. John is always assigned to Atlanta and MIke is always assigned to New York. I'm not using additional filters in NPrinting - everything is calculated in set analysis. And the best part is that when I refresh that report again (without refreshing or changing anything on Qlik side) the data is generated correctly. 

We are using NPrinting February 2020 (I'm 99% sure that we had the same situation on November 2018 version once). During first report generation also other tasks in NPrinting were running (using the same QS app) so instead of ~8 minutes it took like 25 but I don't thing that's an issue. 

Any ideas what's causing that?

[Lech_Miszkiewicz]

Cool sample - great for Qlik support to investigate. What do you think @Ruggero_Piccoli ?

[Ruggero_Piccoli]

Hi,

The behaviour is very strange. I think there is an error somewhere in the development of the Qlik NPrinting solution. We need more information to investigate, for example the template (what kind of, how it is build, etc).

If you cannot share screenshots or other details here please open a support ticket as suggested by @Lech_Miszkiewicz 

Best Regards,

Ruggero

[rafalcqlik]

Sorry for delay in response...

The report is quite simple. Straight table with one measure (variable used), some static texts, some calculated fields and standard fields. Here it is in the Designer:

I'm also attaching excel template (some field names were changed). There is not much room to make a mistake in development. I'm hoping it is my error so I can quickly fix it but I just can't find it... And I think, even with some error, report should still be wrong in the same way after refreshing it again from the same app which hasn't been refreshed in the meantime.

[Ruggero_Piccoli]

Hi,

Tha table in the screenshot has 24 columns. The attached template has 28 columns. So I suppose you added some columns from different tables side-by-side in the template. That is not supported, so if you need all 28 columns side-by-side in the report add all of them in the original table. Remember to refresh the connection cache, close and reopen the template and update the object to reflect the changes.

Best Regards,

Ruggero

[rafalcqlik]

Hi,

those are not additional columns from other objects. The requirement was to have for example 3 columns with static text saying 'N/A' or '(blank)'. Adding such columns in Qlik Sense is possible but NPrinting will not see them as 3 columns, just 1 because the content is exactly the same. So in the report, I'm just using the same column more than once, just with different header. I'm also doing that with measure - I have one measure in Qlik but the requirement was to have the same numbers in 2 columns in excel file, with different header. That's why you see more columns in template than in table definition but I think it's not something wrong. There is nothing joined, merged from other objects. Whole report is pulling data from one Qlik Sense object.

Example:

[rafalcqlik]

Hi all,

just a follow up because issue happens from time to time. I've set NPrinting task to run twice a day with 2 hours interval (without refreshing Qlik app). First run gives mixed up data while the second one is ok. There are other tasks that run at the same time (as the first run) and those other tasks read data from the same app. Is that a problem?

We will create support ticket for that. Just wanted to let you know as this is very disturbing.

[eucastillo1]

Hello everybody, did you manage to solve the problem you reported? Can you share the solution with me? I have exactly the same problem

[Lech_Miszkiewicz]

Hi @eucastillo1 - Old topic to discuss this, but... 

I would assume the issue was caused due to overlapping reloads. It seems like source app was not fully reloaded when nprinting kicked in causing part of data to come from old app and another part from freshly reloaded app.

Otherwise Open new conversation, provide all required and correct information regarding versions of NPrinting and Qlik you are using and describe your template and model as much as possible so we can replicate all your steps without seeing your setup..

cheers