topic Re: Qlikview WebTicket Issue in QlikView

Qlikview WebTicket Issue

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I am having some issues when implementing Web Ticket. I am using membership database to authenticate user in My Web application. Then I am generating tickets and creating URL to redirect to my qlikview document. I need to know if need to change directory service connector to configurable ODBC to make it work.

Thanks.

Re: Qlikview WebTicket Issue

Fredrik_Lautrup — Thu, 09 Oct 2014 11:32:10 GMT

Authentication and authorisation are independent of each other in QlikView. This means that ticketing will work without a directory service connector but if you like to use any of the data in the membership database for authorisation then you need to connect to the database using a directory service connector to ODBC.

Regards

Fredrik

Re: Qlikview WebTicket Issue

Thu, 09 Oct 2014 15:09:58 GMT

I am connecting to Database using directory service connector to ODBC. Is there any other settings I need to take care?

Re: Qlikview WebTicket Issue

Tue, 04 Nov 2014 19:04:00 GMT

Webticket and Configurable ODBC must be configured independently.

The only relevant thing is that the format of the full username should be consistent.

In other words, if you create an Configurable ODBC, full username will "Directory label value" \ "Entity name row value."

Example:

DSC Configuration

Label Directory "DirectoryTest"

Entity name: "Name"

Entity table: "entity"

Groups table "groups"

entity Table

entityId Name descr email

1 User1 John John@test.com

2 User2 Amy amy@test.com

The Qlikview usernames will: DirectoryTest\User1, DirectoryTest\User2.

Therefore tickets must be ordered for those usernames.

Pablo.

Re: Qlikview WebTicket Issue

Tue, 04 Nov 2014 19:23:32 GMT

I tried it. It does not work.

Cheers,

Rakhi Agrawal

Senior Tax Consultant| TMC

Deloitte Tax LLP

Tel/Direct: +1 (214) 840 7253 | Mobile: Tel/Direct: +1 469 502 0554

rakhiagrawal@deloitte.com<mailto:rakhiagrawal@deloitte.com> | www.deloitte.com

Please consider the environment before printing.

Re: Qlikview WebTicket Issue

Tue, 04 Nov 2014 19:54:05 GMT

You can test manually, in the browser, with the following URLs.

http://server/QvAjaxZfc/GetWebTicket.aspx?cmd=<Global method='GetWebTicket'><UserId>Test\User1</UserId></Global>

The server will return a ticket

<_retval_>pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/UdC</_retval_>

</Global>

Then you must create a URL with a webticket and access to Qlikview Access Point or .qvw

(Access Point)

http://server/QvAJAXZfc/Authenticate.aspx?type=html&webticket=pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/UdC&try=/Qlikview&back=

(Qvw )

http://server/QvAJAXZfc/Authenticate.aspx?type=html&webticket=pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/UdC&try=/QvAJAXZfc/opendoc.htm?document=Application.qvw&back=

Pablo.

Re: Qlikview WebTicket Issue

brindlogcool — Wed, 05 Nov 2014 03:52:23 GMT

Hi Rakhi,

What is the error you are getting?. Are the tickets getting generated or getting invalid error.

Re: Qlikview WebTicket Issue

brindlogcool — Wed, 05 Nov 2014 07:56:17 GMT

Hi Pablo,

I have an issue with the web ticket

1. I am getting the ticket generated for the user.

2.. when i tried to validate the ticket i am getting message as login failed . I have used the same URL

https://server/QvAJAXZfc/Authenticate.aspx?type=html&webticket=pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/UdC&try=/QvAJAXZfc/opendoc.htm?document=Application.qvw&back=

3. Also i am trying to pass values for list box. But the values are not getting selected . The url looks like

https://server/QvAJAXZfc/Authenticate.aspx?type=html&webticket=pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/UdC&try=/QvAJAXZfc/opendoc.htm?document=Application.qvw&select=LB123,222323&select=lb1,1

Any idea why the parameters are not getting selected in iFrame it would be really helpful if someone could share the information

Re: Qlikview WebTicket Issue

Wed, 05 Nov 2014 15:42:04 GMT

Brindlogcool,

is the user authorized to access the .qvw application?

Can you access to user Access Point? (http://server/QvAJAXZfc/Authenticate.aspx?type=html&webticket=pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/UdC&try=/Qlikview&back=)

You can encode the TryURL. with http://meyerweb.com/eric/tools/dencoder/.

For example

TryUrl : /QvAJAXZfc/opendoc.htm?document=Application.qvw&select=LB1,1

TryEncodedUrl : %2FQvAJAXZfc%2Fopendoc.htm%3Fdocument%3DApplication.qvw%26select%3DLB1%2C1

General URL: http://server/QvAJAXZfc/Authenticate.aspx?type=html&webticket=pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/UdC&try=%2FQvAJAXZfc%2Fopendoc.htm%3Fdocument%3DApplication.qvw%26select%3DLB1%2C1

Pablo

Re: Qlikview WebTicket Issue

brindlogcool — Wed, 05 Nov 2014 17:43:49 GMT

Hi Pablo,

Thanks for the quick response. Really appreciate it

I have access to all the documents.

Little bit improvement in it. When i try below url in browser it is redirecting to the Access point home page and not getting failed. But the same is getting redirecting correctly to the document in iframe. it is kind of confusing.

server/QvAJAXZfc/authenticate.aspx?typehtml&webticket=prsadasfdfdsf=/QvAJAXZfc/opendoc.htm?document=a.qvw&select

How to validate the ticket which is generated.

I will check the encoder and confirm it.

Re: Qlikview WebTicket Issue

brindlogcool — Wed, 05 Nov 2014 18:06:31 GMT

Hi Pablo,

Web ticket is working now. But not able to query string parameters is not working. I tried URL encode but not working.

Re: Qlikview WebTicket Issue

brindlogcool — Wed, 05 Nov 2014 18:33:22 GMT

Missed the point to mention that the redirect url will be used in iFrame.

Re: Qlikview WebTicket Issue

Wed, 05 Nov 2014 19:25:19 GMT

could you specify the exact url in iframe??

Re: Qlikview WebTicket Issue

brindlogcool — Wed, 05 Nov 2014 20:15:39 GMT

this is the url in the iframe. The values 212121 and 1 are not getting selected in the dashboard.

https://testserver/QvAJAXZfc/Authenticate.aspx?type=html&webticket=0NCdO8uBOhH5bgULRj&try=https://testserver/qvajaxzfc/opendoc.htm?document=TestApp.qvw &select=LB1,212121&select=LB2,1

Re: Qlikview WebTicket Issue

brindlogcool — Wed, 05 Nov 2014 20:16:53 GMT

Removed the https since it is going for moderator approval. not sure how much time it takes to get the approval

testserver/QvAJAXZfc/Authenticate.aspx?type=html&webticket=0NCdO8uBOhH5bgULRj&try=https://testserver/qvajaxzfc/opendoc.htm?document=TestApp.qvw &select=LB1,212121&select=LB2,1

Re: Qlikview WebTicket Issue

Bill_Britt — Thu, 06 Nov 2014 01:01:16 GMT

Hi,

Take a look at this.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/07/11/ajax-and-url-parameters

Bill

Re: Qlikview WebTicket Issue

brindlogcool — Thu, 06 Nov 2014 13:31:31 GMT

Hi Bill

Thanks for your response. I followed extactly the same steps but still the selection is not happening in the dashboard.

I am using this along with webticket . Any suggestions would be really helpful.

Re: Qlikview WebTicket Issue

Thu, 06 Nov 2014 13:39:52 GMT

You could test the following URLs:

https://testserver/QvAJAXZfc/Authenticate.aspx?type=html&webticket=0NCdO8uBOhH5bgULRj&try=/QvAJAXZfc/opendoc.htm?document=TestApp.qvw&select=LB1,212121&select=LB2,1&back=

https://testserver/QvAJAXZfc/Authenticate.aspx?type=html&webticket=0NCdO8uBOhH5bgULRj&try=%2FQvAJAXZfc%2Fopendoc.htm%3Fdocument%3DTestApp.qvw%26select%3DLB1%2C212121%26select%3DLB2%2C1&back=

Pablo

Re: Qlikview WebTicket Issue

Bill_Britt — Thu, 06 Nov 2014 14:03:11 GMT

Hi,

If you use webticketing and not add the selection does the document open? If you look at the listbox for the login user does he has rights to the data you are trying to select?

Bill

Re: Qlikview WebTicket Issue

Bill_Britt — Thu, 06 Nov 2014 14:24:19 GMT

This might be a limitation of webticketing. I am not able to get it to pass the selection either.

Bill