topic Re: Replacing QVW for QV Server does not implement changes in QlikView

Replacing QVW for QV Server does not implement changes

atsushi_saijo — Thu, 11 Dec 2014 10:40:56 GMT

From time to time, we experience strange issue on QV Server, where developper replaces the QVW file on QlikView Server, however; the users using access point (over Web) do not see the change.

I would rather think it is due to the QlikView Server, loading the QVW on the memory, or possibly http session did not expire, and still accessing to the QVApp, stored on the server side, however; exact mechanism is not known.

Today it occurd again, where developer added additional selection, where it is not implemented on server (however seeing on server locally, it is implemented.)

I often get away this, by logging off, and logging in, and proceed to another tab, and return to the original tab. This somehow shake-up the QlikView, and it is implemented.

I would appreciate any input about what user/server administrators should do.

Re: Replacing QVW for QV Server does not implement changes

Anonymous — Thu, 11 Dec 2014 10:42:35 GMT

Do you use Publisher and / or Source Control ?

Re: Replacing QVW for QV Server does not implement changes

atsushi_saijo — Thu, 11 Dec 2014 10:49:06 GMT

Thank you for fast reply.

On the server, I see only QV Management Console, QV Access Point, and QV server installation.
Source control is not in place. QVW file is physically replaced.

Re: Replacing QVW for QV Server does not implement changes

Thu, 11 Dec 2014 10:59:26 GMT

1. How do you have map the server?

2. How developer have define the "Source and QVD"paths

2. Does Qlikview developers have any short of management tools to mange their project and make backups on their projects before they publish to live?

Re: Replacing QVW for QV Server does not implement changes

ashfaq_haseeb — Thu, 11 Dec 2014 11:02:17 GMT

Hi,

Make sure allow session recovery is unchecked.

have a look at attached image.

Regards

ASHFAQ

Re: Replacing QVW for QV Server does not implement changes

atsushi_saijo — Thu, 11 Dec 2014 11:10:14 GMT

The server is accessed by Remote Desktop, and place it directly on the server. QVW is replaced. As background in this project, we have a developer owing the single business process/reporting, so we do not have source control as single enterprise point. Each developer has own source control (I presume mostly on loading script.)
Source is defined in the relative path for both row source and QVD. The source folder (where various extraction is stored) is available as a drive. For OLAP purpose, the client prefers making queries on a cloned DB which becomes 1 day old, therefore we have all extractions (which can be jobbed several times per day). OLTP queries are generally prohibited with a few exception.
For the project management side, yes and all PM group does have various tools. However; I think in general in OLAP project, our delivery due date is shorter than OLTP waterfall development, and design phase is short. Users tend to be more management than operations (i.e. aggragated reports, sales, GL account etc). Data model on the final QVW has been changed often in some cases.
About backup, currently up to developer (one of them is me). However; I note that in JEE project and when I do development or PM where development takes more time and follows CMMI or particular methodology, the ample tools of source control such as SVN, CVS ... used, but for QlikView where loading script itself can be externalised, and creation of UI is rather short-period, I did not used it. But I am aware that some developer use it, notably Git. I must say source control has itself had some disaster...but maybe this is in the realm of misuse. 😉

Re: Replacing QVW for QV Server does not implement changes

rajeshvaswani77 — Thu, 11 Dec 2014 11:11:18 GMT

On access point make the user to clear last document state, before opening. Hope this helps.

thanks,

Rajesh Vaswani

Re: Replacing QVW for QV Server does not implement changes

Thu, 11 Dec 2014 11:24:19 GMT

can I know why developer replacing the QVW?

Re: Replacing QVW for QV Server does not implement changes

atsushi_saijo — Thu, 11 Dec 2014 11:26:59 GMT

Very interesting! I will propagate this to test it. Thank you!

Re: Replacing QVW for QV Server does not implement changes

atsushi_saijo — Thu, 11 Dec 2014 11:29:44 GMT

Is there any other method than replacing it? (we did replaced at certain window of time). Replacement is in the noon and early evening.

Re: Replacing QVW for QV Server does not implement changes

Thu, 11 Dec 2014 11:37:39 GMT

you don't need to replace you can schedule it in server and set a time and show the end users using below code when system have reloaded last time and when it's gonging to be reloaded next.

='Last Reload On - '& Reloadtime() & Chr(10) &

'Next Reload On - '& timestamp(Reloadtime() +10/24/60)

can I know exactly if your talking about QVD "APPLICATION" why its get updated every day two times, Once the developer(s)

developed the MAKER qvd and APPLICATION qvd you just have to schedule it all process get automated

Re: Replacing QVW for QV Server does not implement changes

vinay_hg — Thu, 11 Dec 2014 11:42:38 GMT

Hi,

once u replace the qvw, please restart the QV services if u r manually replacing with a change. or if it is scheduled for the same then uncheck allow session recovery in QMC, for Qv server

Re: Replacing QVW for QV Server does not implement changes

Colin-Albert — Thu, 11 Dec 2014 12:10:54 GMT

Is a reload in progress on the QVW when the developers overwrite the file?

The reload will load the new data into a temporary copy of the file and then when the reload is complete, replace the original file with the newly updated version.

If your developer replaces the original file after the reload starts but before the reload completes, on completion of the reload, the server will replace the developer's updated file with the newly reloaded version based on the original file.

Re: Replacing QVW for QV Server does not implement changes

atsushi_saijo — Thu, 11 Dec 2014 12:18:32 GMT

Would you possibly elaborate "you can schedule it in server and set a time"? Some job is scheduled?
The window of time is allocated window where we are able to implement change: a standard enterprise practice where we deploy production system at certain time, and users are all notified. So users are unable to access using access point during this time.

Re: Replacing QVW for QV Server does not implement changes

atsushi_saijo — Thu, 11 Dec 2014 12:24:25 GMT

Dear Colin, I am quite honored from the famed expert.

The reload is all scheduled in the mid-night, so usually no reload takes place. During the replacement, nothing is taking place. But it is quite interesting to know about it.

Re: Replacing QVW for QV Server does not implement changes

atsushi_saijo — Thu, 11 Dec 2014 12:27:16 GMT

Thank you for the fast response. The service restart requires quite approvals from infrastructure management in production environment 😉 But I will try testing it in test environment.