11 Replies Latest reply on Jun 4, 2016 8:19 AM by Jawad Zubairi Branched from an earlier discussion.

    Unable to run Put VizAlerts Through Its Paces Test

    Jawad Zubairi

      I installed VizAlerts and successfully ran the first simple test however not able to test "Put VizAlerts Through Its Paces Test". Even after following the instructions again and again, I have not received the 30+ emails as yet. any guidance would be appreciated.

        • 1. Re: Unable to run Put VizAlerts Through Its Paces Test
          Matt Coles

          Hi Jawad. Do you receive any email whatsoever? If so, what does it say? If not, check the log and let us know what it says.

          • 2. Re: Unable to run Put VizAlerts Through Its Paces Test
            Matt Coles

            Also, I've branched this into a new discussion since it is a separate issue.

            • 3. Re: Unable to run Put VizAlerts Through Its Paces Test
              Jawad Zubairi

              Thanks for the quick response.

               

              After I post the comment on report..and run vizalerts.py, it doesnt do anything. Following the below quoted instrunctions from user_guide still doesn't help after recurring tries.

               

              "If the script the first time without processing anything, run it again. (Tableau can take a moment to update the data with the “test_alert” comment that acts as a trigger)"

               

              here is the log.  I have masked the credentials. It never finds the rows in viz database... 

               

              2016-06-03 10:53:52 - [INFO] - LoggerQuickSetup - Logging initialized, writing to .\logs\vizalerts.log_2016-06-03.log

              2016-06-03 10:53:52 - [DEBUG] - trusted_ticket_test - testing trusted ticket: ***servername****, ***username****, None

              2016-06-03 10:53:52 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: ***servername****, Site: , Username: ***username****, Url: https://***servername****/trusted, Postdata: username=***username****.

              2016-06-03 10:53:55 - [DEBUG] - get_trusted_ticket - Got ticket: -dq7sjeAvpUiItgzxlppyRFv

              2016-06-03 10:53:55 - [DEBUG] - trusted_ticket_test - Generated test trusted ticket. Value is: -dq7sjeAvpUiItgzxlppyRFv

              2016-06-03 10:53:55 - [DEBUG] - get_views - PostgreSQL repository returned 0 rows

              2016-06-03 10:53:55 - [INFO] - main - Processing a total of 0 views

              • 4. Re: Unable to run Put VizAlerts Through Its Paces Test
                Matt Coles

                Okay, so VizAlerts sees no work to do, and just quits. That would be what I'd expect to see if you skipped step 7 of the doc:

                 

                 

                7. Scroll down in the worksheet and enter a comment with the text “test_alert”.

                 

                ...or if you mis-typed the "test_alert" comment (leading/trailing spaces, no underscore, etc..). The reason we have you do that in the install_guide is so that you don't have to wait for a long time to see results, as you would if you subscribed to it on one of the VizAlerts schedules.

                 

                Can you confirm that you added the comment in step 7, then ran vizalerts.py twice?

                • 5. Re: Unable to run Put VizAlerts Through Its Paces Test
                  Jawad Zubairi

                  Hey Matt,

                   

                  Thanks alot for the spot on direction. So the problem was I did post comment as "test_alert" for the first time and it failed sending email. After resolving it i kept increasing the test_alert1..2.3.4.... etc and never got error message and hence did not find any direction.

                   

                  Now that I have posted test_alert it did something and threw an error and I am gonna look at the details of error.

                   

                  Thanks,

                  Jawad

                  • 6. Re: Unable to run Put VizAlerts Through Its Paces Test
                    Jawad Zubairi

                    Now I am receiving SMTP AUTH extension not supported by server. error log is pasted below

                     

                    2016-06-03 16:13:59 - [INFO] - export_view - Attempting to write to: .\temp\20160603161359816000_VizAlertsDemo-Overview.pdf

                    2016-06-03 16:13:59 - [DEBUG] - find_viz_refs - Returning content references

                    2016-06-03 16:13:59 - [DEBUG] - process_csv - Starting iteration 0, consolidate_email_ctr is 0

                    2016-06-03 16:13:59 - [DEBUG] - process_csv - Starting email action

                    2016-06-03 16:13:59 - [DEBUG] - process_csv - has_email_header is True and consolidate_email_ctr is 0, so appending body header

                    2016-06-03 16:13:59 - [DEBUG] - process_csv - Consolidate value is true, row index is 0, rowcount is 1

                    2016-06-03 16:13:59 - [DEBUG] - process_csv - Last email in set reached, sending consolidated email

                    2016-06-03 16:13:59 - [INFO] - process_csv - Sending email to ***username****, CC None, BCC None, subject Test 24: Advanced Alert Demo

                    2016-06-03 16:13:59 - [DEBUG] - append_body_and_inlineattachments - Replacing body text with exact content references for inline attachments and hyperlinks

                    2016-06-03 16:13:59 - [DEBUG] - append_attachments - Adding appended attachments to list

                    2016-06-03 16:13:59 - [INFO] - send_email - sending email: ***mailserver****,***senderAccount****,***username****,None,None,Test 24: Advanced Alert Demo,[{'view_url_suffix': u'VizAlertsDemo/Forecast?:size=600,400', u'vizlink': 'y', 'imagepath': u'.\\temp\\20160603161357472000_VizAlertsDemo-Forecast.png', 'vizref': u'VIZ_IMAGE(VizAlertsDemo/Forecast?:size=600,400|vizlink)', 'formatstring': 'PNG'}]

                    2016-06-03 16:13:59 - [DEBUG] - send_email - email body: <h2>Welcome to VizAlerts</h2><p>Attached to this email are the Overview and Product drilldown dashboards filtered for East in one merged PDF, the Overview and Product drilldown dashboards filtered for West in another merged PDF, a CSV of the overview data is attached, and a custom-sized Forecast dashboard appears below:</p><a href="http://***serverlink****/views/VizAlertsDemo/Forecast?:size=600,400"><img src="cid:20160603161357472000_VizAlertsDemo-Forecast.png"></a><br/>This email courtesy of VizAlerts, click to view the <a href="http://***serverlink****/views/VizAlertsDemo/Overview">Overview dashboard</a>.

                    2016-06-03 16:13:59 - [DEBUG] - merge_pdf_attachments - Merging PDFs for EastSales.pdf

                    2016-06-03 16:13:59 - [DEBUG] - merge_pdf_attachments - Merging PDFs for WestSales.pdf

                    2016-06-03 16:14:00 - [ERROR] - send_email - Email failed to send; there was an issue sending mail via SMTP server: SMTP AUTH extension not supported by server.

                    2016-06-03 16:14:00 - [ERROR] - process_csv - Failed to send the email. Exception:<br> SMTP AUTH extension not supported by server.

                    2016-06-03 16:14:00 - [ERROR] - process_views - Unable to process data from viewname Advanced Alerts Demo, error:<br> Failed to send the email. Exception:<br> SMTP AUTH extension not supported by server.

                    2016-06-03 16:14:00 - [INFO] - send_email - sending email: ***mailserver****,***senderAccount****,***username****,***username****,None,VizAlerts was unable to process view Advanced Alerts Demo,None

                    2016-06-03 16:14:00 - [DEBUG] - send_email - email body: VizAlerts was unable to process this view due to the following error:<br>Failed to send the email. Exception:<br> SMTP AUTH extension not supported by server.<br><br><b>Details:</b><br><br><b>View URL:</b> <a href="http://***serverlink****/views/VizAlertsDemo/AdvancedAlertsDemo">http://***serverlink****/views/VizAlertsDemo/AdvancedAlertsDemo<a><br><b>Subscriber:</b> <a href="mailto:***username****">***username****</a><br><b>View Owner:</b> <a href="mailto:***username****">***username****</a><br><b>Site Id:</b> Default<br><b>Project:</b> TestVisAlert

                    2016-06-03 16:14:00 - [ERROR] - send_email - Email failed to send; there was an issue sending mail via SMTP server: SMTP AUTH extension not supported by server.

                    2016-06-03 16:14:00 - [ERROR] - view_failure - Unknown error sending exception alert email: SMTP AUTH extension not supported by server.

                    • 7. Re: Unable to run Put VizAlerts Through Its Paces Test
                      Jawad Zubairi

                      I figured the SMTP AUTH Extension not supported by server.

                       

                      In vizalerts configuration file vizalerts.yaml, I had specified the server user that sends the email whereas I did not provide the user. As i reviewed the SMTP settings I realized I don't have to provide the user name as no authentication required.

                       

                      As soon as I did ... its yayyyyyyyyyy......... I did pass the first test

                      • 8. Re: Unable to run Put VizAlerts Through Its Paces Test
                        Jawad Zubairi

                        Thanks for your timely response.

                        • 9. Re: Unable to run Put VizAlerts Through Its Paces Test
                          Jawad Zubairi

                          Now that I receive the email but I get only 1 email contrary to 30 emails.  Could you guide what I might need to looking into?

                          • 11. Re: Unable to run Put VizAlerts Through Its Paces Test
                            Matt Coles

                            Looks like I "NOOICE"d too soon.

                             

                            Make sure you're looking at the Advanced Alerts Tests view (the documentation is missing the word "Tests" at the end) instead of Advanced Alerts Demo.

                             

                            So basically:

                             

                            WRONG:

                             

                             

                            RIGHT :