topic Re: When should you Reload Metadata? in Qlik NPrinting

When should you Reload Metadata?

jblomqvist — Wed, 25 Sep 2019 18:40:54 GMT

Hi,

I am a bit confused about circumstances in which metadata should be reloaded.

I know metadata should be reloaded when you have new objects in a QlikView document that you want to use in NPrinting.

But what about when you have made changes to expressions of existing objects?

Or if you have added new variables?

If a connection is based on a QVP connection, should metadata be reloaded when you want to reflect new data? The QlikView Server automatically performs a reload and the NPrinting report is supposed to run after so not sure in this.

What other circumstances should you reload metadata? And does is differ for Qlik Sense and QlikView (please go into detail what those differences are)?

Re: When should you Reload Metadata?

Chanty4u — Wed, 28 Mar 2018 10:11:01 GMT

https://help.qlik.com/en-US/nprinting/February2018/Content/GettingStarted/HowCreateConnections/Reloading-connection-meta…

Connection metadata contains information about the data and structures of linked QlikView documents or Qlik Sense apps.

Qlik NPrinting automatically uploads metadata when a new connection is created. Metadata must also be updated whenever you change the data structure or content of QlikView documents or Qlik Sense apps connected to Qlik NPrinting. This ensures that Qlik NPrinting is aware of these changes.

After the metadata is reloaded, all instances of QV.exe that are running on Qlik NPrinting Engines associated with the connection will automatically stop and restart to update them. Existing reports are not automatically re-run, so they may contain old data. Reports executed after a metadata reload will show the updated data.

Re: When should you Reload Metadata?

Chanty4u — Wed, 28 Mar 2018 10:11:22 GMT

yes

the data that is getting refreshed in Qlikview document from Qlikview server is also getting fetched continuously by the NPrinting Server through qvp connection and so there is no need of reloading the metadata.

Re: When should you Reload Metadata?

Lech_Miszkiewicz — Sat, 31 Mar 2018 09:29:48 GMT

Hi John,

There is no clear answer to your question. It really all depends on how you have setup your environment. In my environments i ALWAYS have separate application only for NPrinting reports. Therefore any change to this application in my opinion should also require metadata reload. This makes it quite simple and straightforward for me.

So:

any new object (expression, dimension, variable)
any new chart
any change to existing objects
any change in existing sheets
added or removed fields tables from data model

I always reload metadata after doing one from the above. I know that in some cases this is maybe not necessary (for example if change a expression which calculates a value in a table) , but i do it just to have everything always up to date.

Re: When should you Reload Metadata?

Ruggero_Piccoli — Tue, 03 Apr 2018 10:16:12 GMT

Hi,

I would to add that you need to reload metadata also every time you update a QlikView document if you created a local connection to it. Of course, we suggest to use server connections instead of local.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: When should you Reload Metadata?

Digvijay_Singh — Wed, 20 Jun 2018 22:35:29 GMT

Hi Ruggero,

Just wanted to confirm that Metadata reload is only needed if Front-end is changed(Chart objects used in the NPrinting report), Data refresh in QS App doesn't require meta data reload, right?

Re: When should you Reload Metadata?

Lech_Miszkiewicz — Thu, 21 Jun 2018 02:21:50 GMT

In general YES - you are correct.

1 exception though; just to clarify:

on the back-end you might have some variables defined like:

Let vToday = Date(today(),'YYYY-MM-DD');

lets assume you change this to

Let vToday = Date(today(),'DD-MMM-YY');

Although it is a back-end change i would still reload metadata.

New data coming to Qlik Sense fields/tables does not require metadata reload!

Re: When should you Reload Metadata?

cpalbrecht — Fri, 06 Jul 2018 16:06:12 GMT

I have a problem. I trigger a NPrinting publish task from inside a Qlik Sense app data load script. And in the report, I use a variable. This variable changes with every Qlik Sense data reload. This reload runs every minute.

So every minute the Qlik Sense app reload sets a new value to the Qlik Sense variable and triggers the NPrinting publish task. The task is rendering a report with that variable inside.

The problem is, every new report displays the variable value of the previous reload. But normally NPrinting should fetch the new variable value. Or do I need to reload every time the meta data of the connection?

When does NPrinting look for the new variable values?

Re: When should you Reload Metadata?

Lech_Miszkiewicz — Sun, 08 Jul 2018 05:44:26 GMT

Hi Christoph

I think your problem is different than this topic subject so maybe create your own one.

you are saying that:

So every minute the Qlik Sense app reload sets a new value to the Qlik Sense variable and triggers the NPrinting publish task. The task is rendering a report with that variable inside.

so if you are triggering NPrinting task from the same script of the application you use for NPrinting you are making big mistake. Your app will not get saved and NPrinitng runs of previously saved app.

You should have 2 Qlik sense apps reloading one after another.

1 st reloading Qlik Sense app
2 nd triggering NPrinting task

We can discuss more in dedicated topic.

Re: When should you Reload Metadata?

Ruggero_Piccoli — Mon, 09 Jul 2018 14:44:20 GMT

Hi,

I think you should schedule a metadata reload to force connections to be closed and reopened. In this way the updated value of variables will be used.

Do a test, please.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: When should you Reload Metadata?

Lech_Miszkiewicz — Tue, 10 Jul 2018 00:35:10 GMT

This would be ideal, but since it is QlikSense i thought it would push new data right after reload....

"I did a test: I opened a session in a hub, reloaded data via QMC and numbers updated right after reload without having to restart the session"

Metadata reload will possibly take too much time, right?

cheers

Lech

Re: When should you Reload Metadata?

Ruggero_Piccoli — Tue, 10 Jul 2018 08:51:19 GMT

Hi,

The reload metadata force the connection to be closed and reopened. So it should read the updated data from Qlik Sense. Data should come from the server without the need of this operation but I would to test it in this case where a variable is involved.

Best Regards,

Ruggero

---------------------------------------------

Re: When should you Reload Metadata?

cpalbrecht — Tue, 10 Jul 2018 08:59:10 GMT

I tested it a lot. Also with a separate app for task triggering, variables were not updated after a reload. For me it is not clear when a varible gets updated in NPrinting. After each reload I was getting the variable value from the reload before.

So I removed all variables. I am using only Qlik Sense objects. They get updated directly after each reload.

Re: When should you Reload Metadata?

Ruggero_Piccoli — Tue, 10 Jul 2018 10:31:05 GMT

Hi,

Please open also a support ticket. We need to deeper investigate this issue and in case create a bug.

When you reload a Qlik Sense app normally you don't need to run also a metadata refresh in Qlik NPrinting. Qlik Sense data are pushed and all reports produced in Qlik NPrinting should be updated. The Qlik NPrinting metadata reload is necessary only if you change the structure of the Qlik Sense app. For example if you add a chart and you want to use it in a report.

If in some cases, for example with variables, this is not working it means that it must be better investigated.

Best Regards,

Ruggero

---------------------------------------------

Re: When should you Reload Metadata?

brooksc57 — Mon, 21 Jan 2019 18:04:40 GMT

I very recently updated to the Feb 2018 NPrinting -- based on one of your posts that said an update is needed if the reload just is always 'regenerating'...that worked and everything is crazy faster...so all that is good.

I have a report/tast Server connected... so using qvp:// etc...

I can connect to a report, run what I need to and that is great and now even faster as mentioned.

But,

when I go to rerun it the next day, if fails unless I refresh the data.

I'm not understanding why if I am connected via server and havent' changed any structures.

I have a QVW on a Private Folder, Run QV Publisher to publish that QVW to a Public folder (and the Public one is what I am connected too).

if feels like it should just run and not make me refresh since it is server connected.

Hopefully I've explained that you can explain what is going wrong.

Thanks, Brooks