topic Re: run .qvw file in Qlikview server in QlikView

run .qvw file in Qlikview server

Wed, 25 Nov 2020 16:16:04 GMT

Hello Everyone,

I have a .qvw file which was created by my colleague with Qlikview Personal Edition.

Now I have Qlikview server installed, how can I open/run that file through the server ?

What I did:

Copied that .qvw file into some folder in the server.

Open Qlikview Management Console and set the root folder (where my .qvw file is present)

I am not sure what else I have to do after these steps.

Re: run .qvw file in Qlikview server

vishsaggi — Thu, 15 Dec 2016 00:35:56 GMT

You have to create a task in the Document Tab -> source documents tab of your QMC, then schedule a trigger if you need or just apply the changes and run. Where exactly you are facing the issue, can you post some screen shots?

Re: run .qvw file in Qlikview server

hectorvega — Thu, 15 Dec 2016 00:57:31 GMT

Hi Narendra,

I will give you some tips on how to deliver your QVW and schedule the reload using QMC.

Start QMC using a browser to the address :

http://localhost:4780/qmc/SystemSetup.htm

Choose System > Setup > Setup > Management Service > QlickView Server

Using the tab named Folders, choose plus sign in order to add a Name & Path where your QVW resides and set the check box browsable, then click button Apply.

Now, to schedule the reload of the document, go to the tab Documents and you will see the new folder name, click on the name and you will read the QVW file name, pick tis name and on the right choose tab reload, do the settings and apply.

You will see now your first dashboard published.

I hope this could help you.

Re: run .qvw file in Qlikview server

Chip_Matejowsky — Thu, 15 Dec 2016 03:25:37 GMT

To expound on Hector's post, ensure that the account running the QlikView Distribution Service on the QlikView Server has the necessary permissions to the source data, as well as the necessary permissions to the User Documents directory.

Re: run .qvw file in Qlikview server

Thu, 15 Dec 2016 19:56:26 GMT

Hello Hector Vega,

I have added the source folder in Mounted folders, please find the screenshot for the same.

Should I need to reload the data for the first time ? I think the .qvw file has data. (At this time I am okay without reloading the data if it just opens with the existing data in the .qvw file)

My question is how can I run that uploaded file ?

Through URL ? or any other way ?

Re: run .qvw file in Qlikview server

MK9885 — Thu, 15 Dec 2016 20:36:53 GMT

You run a task in QMC to refresh the data in Access Point. For first time you need to run the .qvw in qmc.

And if you want the .qvw to reload at certain time/day, you should use Triggers option while distribution.

You can run a qvw automatically Daily,continuously, weekly etc...

Re: run .qvw file in Qlikview server

Thu, 15 Dec 2016 20:41:40 GMT

Hi arvind654‌

I am not sure how can I run that .qvw file in QMC ?

Re: run .qvw file in Qlikview server

MK9885 — Thu, 15 Dec 2016 20:51:56 GMT

If you've the file available in your source folder then you can just click on Documents Tab in QMC>Source Document>qvw you want to run> click + on top right> Type Task Name>Distribute Tab> Add users there>Triggers Tab if you want the qvw to run automatically on assigned periods.

Click Apply when all done and then you'll have a file below your original file in qmc, right click>run

After successful run you can see that file in your Access Point.

Re: run .qvw file in Qlikview server

MK9885 — Thu, 15 Dec 2016 20:53:28 GMT

Go through the below link, it will be more helpful.

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/QMC/Content/QMC_Introduction.htm?_ga=1.202931539.317681099.14685046…

Re: run .qvw file in Qlikview server

Thu, 15 Dec 2016 21:35:11 GMT

Hi arvind654‌

I don't find anything called source folder (like in your screenshot)

Am I done anything wrong ?

Re: run .qvw file in Qlikview server

novonieldeb — Thu, 15 Dec 2016 21:56:03 GMT

Hi Narendra,

I think you dont have to worry much about reload etc. Just :

1. Put QVW into the mount/publish folder of the QV Server.

2. Go to QMC>Documents>User Documents. You will see the file there. Click on it and on the right go to the authorization tab and set as all named users or authorized user

3. Now you should have at least one user ID with its password with you. It can be a named cal or doc cal (if you want to use a DOC cal then you will need to assign the user ID as a DOC cal for this QVW document.

4. Now access your Access Point and you should be able to access the application.

PS: Applying Section Access would depend on whether you want to give specific rights. You can set that later if you want.

Let me know.

Re: run .qvw file in Qlikview server

Thu, 15 Dec 2016 22:22:18 GMT

Hi novonieldeb‌

Everything is ok except your 3rd point

I don't have any username & password with me, there is no login for the qvw file which I have created .

Re: run .qvw file in Qlikview server

novonieldeb — Fri, 16 Dec 2016 08:17:55 GMT

Hi Narendra,

As you have mentioned that you want to access/run this document through QV Server (Access Point), you would ideally require username and password.

Moreover you wont need a separate username and password (assuming that the QVW is already not set with any userID in Section Access i.e. SA is not applied on it). You can use any userid to log into the Access Point which you might have created after installing the QVS and its license. If you have just installed it and not created any ID then if required you can add your login (the ID using which you log into the QVS machine...assuming that its a domain user and the AD/LDAP in DSC is already set) OR you can create a CUSTOM user through DSC (you will need to change the setting in the QMC>QVS as DMS for this) and then use that ID.

However you can try accessing the Access Point through Anonymous user and check but for that first you will need to go to QMC>QVS>in the tab marked as authorization/security, you will need to select Anonymous

If you dont want to access the QVW through Access Point but just want to open the application in the QVS machine, then:

1. Install QV Desktop version (obvious)

2. Create a named user in License section of QMC and lease a QV Desktop license.

3. You can then open it in the QV Desktop version easily.

Re: run .qvw file in Qlikview server

Fri, 16 Dec 2016 09:23:43 GMT

Hi Narendra,

Below link will give you more details for QMC.

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/QMC/Content/QMC_Introduction.htm?_ga=1.136970615.678949478.14760931…

Firstly, you have to create task on QMC in the document tab under the source document.in that you have different types of option like assigning the trigger, reduced the document if you want.

Then in Status tab under Task,in which you can find different types of folder where you mount you qvw application.

then you can simply run task.If everything goes successfully then task status should be waiting,in this you can run the qvw app in server.

Secondly,Save you qvw application into where you want to mount/publish folder of the QV Server.then go to QMC>Documents>User Documents. You will see the file there. Click on it and on the right go to the authorization tab and set as all named users or authorized user.

Yo can see you qvw application on the Access point.

Thanks,

Re: run .qvw file in Qlikview server

MK9885 — Fri, 16 Dec 2016 13:56:40 GMT

You've not probably entered details in QDS.

Check the above Image, create a source & user document folder on server, give that path in the below...
I'd suggest go through the https://help.qlik.com/en-US/qlikview/12.0/Subsystems/QMC/Content/QMC_Introduction.htm?_ga=1.161291647.317681099.14685046…

or watch on Youtube, how to setup QMC

Re: run .qvw file in Qlikview server

Fri, 16 Dec 2016 14:07:55 GMT

have you got the answer

Re: run .qvw file in Qlikview server

Fri, 16 Dec 2016 18:25:49 GMT

Hi yogesh_sj

I am following your second option.

I have added the source folder (where qvw files present) in the mounted folders and try to open Qlikview Access point , but I don't know why Qlikview Access Point is not running.

it is throwing 404 page not found, once it is fixed, i will let you know whether I am able to view the qvw file in access point or not.

Re: run .qvw file in Qlikview server

novonieldeb — Fri, 16 Dec 2016 18:42:50 GMT

Hi Narendra,

The said error comes when the Access Point is not accessible, ideally due to any of the following reasons:

1. QVWS service is not running

Check the services.msc. Also check the Services section in the QMC and look for any error

2. If QVWS service is running, there is possibility of port 80 being used by some other application or service

You can check that by stopping the QVWS service and running "Telnet localhost 80". If it shows the port as running then some other is using this port. This can then be checked with "netstat" command

3. URL to Access Point incorrect

Share the Access Point URL you are using

Also let me know whether all the services are installed in the same machine and which all are running.

PS: Disable accessing URLs through a proxy server so that the URL hits directly to the local machine port

Re: run .qvw file in Qlikview server

Fri, 16 Dec 2016 20:03:22 GMT

Hi novonieldeb‌

Finally I am able to access the qvw files in the access point.

I have deployed 2 files in QVS and able to see those 2 in the access point through some url (that url is opening the access point). by giving username & password I am able to login to that page.

But out of 2 qvw files, I am able to view only one, which has section access implemented in it.

When I open the qvw file which is having section access, it is asking for userid & pwd, and then after the authentication, it is working fine.

When I try to open the qvw file, which is not having section access, it is still asking username & pwd, I am giving the same username & pwd which allows me to login to the Access Point, but those are not working this time.

Can you let me know how to create users to access the qvw files in the access point ?

Re: run .qvw file in Qlikview server

Fri, 16 Dec 2016 21:25:09 GMT

Hi arvind654‌

Now I am able to view qvw files in Access Point and I can open those files from access point.

What do you mean for "For first time you need to run the .qvw in qmc." ??

I didn't understand that one.