1 Reply Latest reply on Aug 12, 2013 1:02 PM by Paul Lorsbach

    ExceptionControllerMonitoringData - Got exception of type:com.tableausoftware.model.vizql.FailedAuthorizationException

    Bernd Ries

      not sure if this is the right place, but I just ask anyway.

       

      We have trusted authentication enabled, but users still get prompted for username and password.

      Below is an extract from vizql log, the 2nd last entry is a FailedAuthorizationException.

       

      The question I have is: Is this exception related to the trusted authentication or is it to do with data sources?

      The workbook contains a Oracle data source with embedded credentials. The wgserver.unrestricted_ticket setting has been enabled, as the workbook has multiple views.

       

      Tableau server is version 8.0.3.

       

      Are there any other logs i could check to get more details? 

       

       

      2013-08-02 06:26:28.390 +1000 (Test DM7,,-,UfrEdBsyWcYAAA8oQqQAAAC9) catalina-exec-4 : DEBUG wgsessionId= com.tableausoftware.model.workgroup.service.TrustedTicketServiceImpl - Attempting standard ticket creation using the following paramters:  username: testdm7user ,requestor IP: 27.50.89.7 ,client IP:  ,client IP matching flag: false

      2013-08-02 06:26:28.390 +1000 (Test DM7,,-,UfrEdBsyWcYAAA8oQqQAAAC9) catalina-exec-4 : DEBUG wgsessionId= com.tableausoftware.model.workgroup.service.TrustedTicketServiceImpl - Trusted host list: [27.xxx.xxx.7, 27.xxx.xxx.6, 127.0.0.1]

      2013-08-02 06:26:28.390 +1000 (Test DM7,,-,UfrEdBsyWcYAAA8oQqQAAAC9) catalina-exec-4 : DEBUG wgsessionId= com.tableausoftware.model.workgroup.service.TrustedTicketServiceImpl -  The requestor IP: 27.xxx.xxx.7

      2013-08-02 06:26:28.406 +1000 (Test DM7,,-,UfrEdBsyWcYAAA8oQqQAAAC9) catalina-exec-4 : DEBUG wgsessionId= com.tableausoftware.model.workgroup.jpa.TrustedTicketDaoJpa - Ticket creation query is: INSERT INTO trusted_tickets (ticket, user_id, username, client_ip, created_at, expires_at, site_id) VALUES (770934995,28,testdm7user,,now(),now()+cast('180 seconds' as interval),6);

      2013-08-02 06:26:28.437 +1000 (Test DM7,,-,UfrEdBsyWcYAAA8oQqQAAAC9) catalina-exec-4 : DEBUG wgsessionId= com.tableausoftware.model.workgroup.service.TrustedTicketServiceImpl - Ticket was created with the following parameters:  ticket number: 770934995 ,user ID: 28 ,username: testdm7user ,created at: 2013-08-01 20:26:28.421 ,expires at: 2013-08-01 20:29:28.421 ,client IP:  ,site ID: 6

      2013-08-02 06:26:29.312 +1000 (Test DM7,,-,UfrEdRsyWcYAAA8oQqcAAACx) catalina-exec-4 : INFO  wgsessionId= com.tableausoftware.controller.vizql.ExceptionControllerMonitoringData - Got exception of type:com.tableausoftware.model.vizql.FailedAuthorizationException

      2013-08-02 06:26:29.312 +1000 (Test DM7,,-,UfrEdRsyWcYAAA8oQqcAAACx) catalina-exec-4 : INFO  wgsessionId= com.tableausoftware.controller.vizql.ExceptionControllerMonitoringData - Sent notification