topic Re: NPrinting 17 not returning correct data in Qlik NPrinting

NPrinting 17 not returning correct data

Anonymous — Mon, 20 Feb 2017 11:59:15 GMT

We have an NPrinting 17.2.1.0 Excel report which used to be fine in v16. Since the migration to v17, we have been experiencing the following problems:

Most days now, the data being returned is corrupted. By this I mean that data is partially repeated on the same tab.

We have had instances of yesterday's data being returned.

Oddly enough, when it runs on Monday morning it is correct.

I have seen problems being reported to do with the cache and I just wondered if this could also be our issue.

Thanks

Chris

Re: NPrinting 17 not returning correct data

Daniel_Jenkins — Mon, 20 Feb 2017 23:50:58 GMT

Hi Chris,

What kind of connection are you using (Local, Server or Cluster)?

How are you reloading the document used in the connection?

When does the reload take place and when does it finish?

When is the report scheduled to run?

How long does the reload take?

When was the reload run (and when did it finish) before Monday's report was generated?

If no obvious possible cause pops up when answering the above I suggest you open a case with Support.

HTH - Daniel.

Re: NPrinting 17 not returning correct data

Anonymous — Tue, 21 Feb 2017 07:12:22 GMT

Thanks Daniel,

We are using a Server connection to the QlikView app which is being reloaded using the QMC. The reload occurs around 07:40 every morning. It takes approx. 18 secs to run.

The NP task was set to run at 09:30, but we changed it last week to run at 10:00, just in case there were clashes that we were not seeing.

I have looked at the logs (a task in itself) and I cannot see anything going wrong.

Looks like a support call then,

Regards

Chris

Re: NPrinting 17 not returning correct data

Stephen_Jasionowski — Tue, 21 Feb 2017 16:22:26 GMT

Chris - see the following for a workaround that should ensure that your connection has refreshed data.

Re: NPrinting 17 not returning correct data

Danijel — Wed, 22 Feb 2017 07:48:22 GMT

Alternatively, it should work with version 17.3. There were some bug fixes that help here.

Re: NPrinting 17 not returning correct data

Anonymous — Wed, 22 Feb 2017 09:59:50 GMT

Thanks Stephen,

My apologies, we are using the app itself as the source not the access point instance.

Re: NPrinting 17 not returning correct data

Anonymous — Wed, 22 Feb 2017 10:01:14 GMT

Hi Danijel,

This is the option we are going to take. I will update the post once we have the results.

Re: NPrinting 17 not returning correct data

Daniel_Jenkins — Wed, 22 Feb 2017 22:41:27 GMT

Hi Chris,

If you are using a QVW that is being reloaded by the QMC you must use a Server type connection (qvp) in NPrinting. If you instead connect as a local connection you could get stale or mixed stale & fresh data if you do not reload the metadata (version 17.3) or restart the NPrinting services (all versions). I have seen this before.

HTH - Daniel.

Re: NPrinting 17 not returning correct data

Anonymous — Mon, 06 Mar 2017 08:45:48 GMT

Hi,

17.3 is indeed the answer.

Thanks for the help with this issue,