1 2 Previous Next 16 Replies Latest reply on Jul 12, 2016 8:48 AM by Matt Coles

    VizAlerts failed to execute properly

    jegan.sivaraj

      We are running Vizalerts for extract refresh alerts. I get
      this error quite often. Sometimes three or four in succession. Does this indicate an
      issue with the server? Vizalerts is run from a remote machine.

       

      URLError generating trusted ticket: Request details: Server:

       

      Thank you,

      Jegan

        • 1. Re: VizAlerts failed to execute properly
          Matt Coles

          Hey Jegan. We get trusted tickets errors as well every once in awhile. On the occasions where we've gotten lots of them, it's been an issue with Tableau Server. Most times it's that we had a VizQL process go down or become unresponsive. You can check the Tableau Server logs for the errors to see if Tableau Server is receiving the request (if not, perhaps it is a networking issue), and what the problem may be.

           

          If these don't happen often, VizAlerts should recover okay. If it fails on the hour, such as at 13:00, the next iteration at 13:01 will pick up alerts that should have run at 13:00. Four in a row might put you around 13:04, which could start impacting alert timeliness (and possibly accuracy depending on how you've set your relative date filter!), so it's definitely worth looking into.

          1 of 1 people found this helpful
          • 2. Re: VizAlerts failed to execute properly
            jegan.sivaraj

            Thanks Matt. I reviewed the logs and did not find an entry for the time the error message was sent. I'm assuming that means a network issue. Is there a way to confirm network errors? Is the network issue between the remote vizalerts host and the prod tableau server?

            • 3. Re: VizAlerts failed to execute properly
              Matt Coles

              In the past, at times I've set up a simple script to ping the remote host and log results in a text file, to confirm that network connectivity was lost. You could try that. I would also review the httpd logs, however, now that I think about it--that should be the entry point for any requests sent to Tableau Server from VizAlerts. You can actually look at these in the http_requests table in the PostgreSQL repository as well, which might be more convenient. Look for records where the http_user_agent has "python" in it.

              • 4. Re: VizAlerts failed to execute properly
                Toby Erkson

                Jegan Sivaraj, are you still having this issue or did you figure out what is causing it?

                • 5. Re: VizAlerts failed to execute properly
                  jegan.sivaraj

                  Hey Toby, I have not figured it out yet. I'm still receiving the errors everyday.

                  • 6. Re: VizAlerts failed to execute properly
                    Matt Coles

                    Could you share a snippet of your log file, Jegan? Sometimes there's more info in there.

                    • 7. Re: VizAlerts failed to execute properly
                      jegan.sivaraj

                      Matt, are you looking for the logs from Vizalert?

                      • 8. Re: VizAlerts failed to execute properly
                        Matt Coles

                        Yep, unless you found some records in the Tableau Server logs that would help. If so, I'll take those too.

                        • 9. Re: VizAlerts failed to execute properly
                          jegan.sivaraj

                          2016-06-07 11:14:19 - [INFO] - LoggerQuickSetup - Logging initialized, writing to .\logs\vizalerts.log_2016-06-07.log

                          2016-06-07 11:14:19 - [DEBUG] - get_password_from_file - Opening password file VizAlertsReadonly.txt for reading

                          2016-06-07 11:14:19 - [DEBUG] - trusted_ticket_test - testing trusted ticket: ServerName, UserName, None

                          2016-06-07 11:14:19 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: ServerName, Site: , Username: UserName, Url:ServerName/trusted, Postdata: username=ServerName%5CUserName.

                          2016-06-07 11:14:40 - [ERROR] - get_trusted_ticket - URLError generating trusted ticket:   Request details: Server: ServerName, Site: , Username: UserName, Url:ServerName/trusted, Postdata: username=ServerName%5CUserName.

                          2016-06-07 11:14:40 - [ERROR] - trusted_ticket_test - URLError generating trusted ticket:   Request details: Server: ServerName, Site: , Username: UserName, Url:ServerName/trusted, Postdata: username=ServerName%5CUserName.

                          2016-06-07 11:14:40 - [INFO] - send_email - sending email: mail.ServerName,<>,None,None,ALERT: VizAlerts failed to execute properly,None

                          2016-06-07 11:14:40 - [DEBUG] - send_email - email body: URLError generating trusted ticket:   Request details: Server: ServerName, Site: , Username: UserName, Url:ServerName/trusted, Postdata: username=ServerName%5CUserName.

                          2016-06-07 11:14:40 - [ERROR] - <module> - An unhandled exception occurred: Traceback (most recent call last):

                            File "C:\VizAlerts-1.0.8\vizalerts.py", line 1249, in <module>

                              main()

                            File "C:\VizAlerts-1.0.8\vizalerts.py", line 171, in main

                              trusted_ticket_test()

                            File "C:\VizAlerts-1.0.8\vizalerts.py", line 326, in trusted_ticket_test

                              quit_script(errormessage)

                            File "C:\VizAlerts-1.0.8\vizalerts.py", line 868, in quit_script

                              sys.exit(1)

                          SystemExit: 1

                          Traceback (most recent call last):

                            File "C:\VizAlerts-1.0.8\vizalerts.py", line 1249, in <module>

                              main()

                            File "C:\VizAlerts-1.0.8\vizalerts.py", line 171, in main

                              trusted_ticket_test()

                            File "C:\VizAlerts-1.0.8\vizalerts.py", line 326, in trusted_ticket_test

                              quit_script(errormessage)

                            File "C:\VizAlerts-1.0.8\vizalerts.py", line 868, in quit_script

                              sys.exit(1)

                          SystemExit: 1

                          2016-06-07 11:15:19 - [INFO] - LoggerQuickSetup - Logging initialized, writing to .\logs\vizalerts.log_2016-06-07.log

                          2016-06-07 11:15:19 - [DEBUG] - get_password_from_file - Opening password file VizAlertsReadonly.txt for reading

                          2016-06-07 11:15:19 - [DEBUG] - trusted_ticket_test - testing trusted ticket: ServerName, UserName, None

                          2016-06-07 11:15:19 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: ServerName, Site: , Username: UserName, Url:ServerName/trusted, Postdata: username=ServerName%5CUserName.

                          • 10. Re: VizAlerts failed to execute properly
                            Matt Coles

                            Well, upgrading to v1.1.0 would be a start. It won't solve the trusted ticket issues, but our error handling improved a bit, so we may get a little more info back such as the reason for the failure. Plus...killer Drummey features!

                            • 11. Re: VizAlerts failed to execute properly
                              jegan.sivaraj

                              Yep. Did it this morning. I have not seen the error so far today.

                              • 12. Re: VizAlerts failed to execute properly
                                jegan.sivaraj

                                Got one today -

                                 

                                2016-06-09 08:22:40 - [ERROR] - get_trusted_ticket - URLError generating trusted ticket: [Errno 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond  Request details: Server: ServerName, Site: , Username: ServerName\UserName, Url: ServerName/trusted, Postdata: username=ServerName%5CUserName.

                                2016-06-09 08:22:40 - [ERROR] - trusted_ticket_test - URLError generating trusted ticket: [Errno 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond  Request details: Server: ServerName, Site: , Username: ServerName\UserName, Url: ServerName/trusted, Postdata: username=ServerName%5CUserName.

                                2016-06-09 08:22:40 - [INFO] - send_email - sending email: <>,None,None,ALERT: VizAlerts failed to execute properly,None

                                2016-06-09 08:22:40 - [DEBUG] - send_email - email body: URLError generating trusted ticket: [Errno 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond  Request details: Server: ServerName, Site: , Username: ServerName\UserName, Url: ServerName/trusted, Postdata: username=ServerName%5CUserName.

                                2016-06-09 08:22:40 - [ERROR] - <module> - An unhandled exception occurred: Traceback (most recent call last):

                                  File "C:\VizAlerts-1.1.0\vizalerts.py", line 1654, in <module>

                                    main()

                                  File "C:\VizAlerts-1.1.0\vizalerts.py", line 203, in main

                                    trusted_ticket_test()

                                  File "C:\VizAlerts-1.1.0\vizalerts.py", line 365, in trusted_ticket_test

                                    quit_script(errormessage)

                                  File "C:\VizAlerts-1.1.0\vizalerts.py", line 895, in quit_script

                                    sys.exit(1)

                                SystemExit: 1

                                Traceback (most recent call last):

                                  File "C:\VizAlerts-1.1.0\vizalerts.py", line 1654, in <module>

                                    main()

                                  File "C:\VizAlerts-1.1.0\vizalerts.py", line 203, in main

                                    trusted_ticket_test()

                                  File "C:\VizAlerts-1.1.0\vizalerts.py", line 365, in trusted_ticket_test

                                    quit_script(errormessage)

                                  File "C:\VizAlerts-1.1.0\vizalerts.py", line 895, in quit_script

                                    sys.exit(1)

                                SystemExit: 1

                                • 13. Re: VizAlerts failed to execute properly
                                  Matt Coles

                                  Yep, now that's better. That error is consistent with what you said you've seen, and the lack of logs internally in Tableau Server would make me think this is network connectivity problems. Again, I'd suggest a ping script running from your VizAlerts host in Powershell or somesuch that just runs in a loop for 12 hours or so that just goes:

                                   

                                  while ((Get-Date) -lt '2016-06-10 00:00:00' ){

                                      (Get-Date).ToString('yyyy-MM-dd HH:mm:ss') >> c:\mylogfile

                                      ping myserver >> c:\mylogfile

                                      Start-Sleep -S 10

                                  }

                                   

                                  If you see failures at the same time that VizAlerts starts failing, you could then take those to your networking team and ask them to take a look.

                                  1 of 1 people found this helpful
                                  • 14. Re: VizAlerts failed to execute properly
                                    Matt Coles

                                    Were you able to get this figured out, Jegan?

                                    1 2 Previous Next