Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview WebTicket Issue

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.

48 Replies
Fredrik_Lautrup
Employee
Employee

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

Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

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

<Global>

     <_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/U...

(Qvw )

http://server/QvAJAXZfc/Authenticate.aspx?type=html&webticket=pi9W5RTq7mGH7ByffuCBqhJ83OMCpRccs/sL/U...

Pablo.

brindlogcool
Creator III
Creator III

Hi Rakhi,

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

brindlogcool
Creator III
Creator III

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/...

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/...

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

Not applicable
Author

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/U...)

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/U...

Pablo

brindlogcool
Creator III
Creator III

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.