10 Replies Latest reply on Mar 1, 2017 2:03 PM by Matt Coles

    Need Help in configuring VizAlerts

    Madhusudhan Khambham
    Madhusudhan Khambham Feb 27, 2017 5:48 PM

      Hi  VizAlerts Community,

       

      I am sorry, i initially started my conversation in a different section(Documents section VizAlerts 2.0.1 Released ). Realised it late. This thread is in continuation to that.

      Can someone please guide me in setting up the VizAlerts ?

       

      Thanks & Regards

      Madhu K

      • 620 Views
      • Tags:
        • 1. Re: Need Help in configuring VizAlerts
          Madhusudhan Khambham
          Madhusudhan Khambham Feb 28, 2017 8:28 AM (in response to Madhusudhan Khambham)

          Hi Matt Coles

           

          I progressed one more step, now i am able to get the ticket from my Tableau server. Still having issue to successfully run vizalerts.py.

           

          Here are the logs FYR.. Could you please suggest what could be the issue..

           

          MainThread - 2017-02-28 08:14:20 - [INFO] - LoggerQuickSetup - Logging initialized, writing to .\logs\vizalerts.log_2017-02-28.log

          MainThread - 2017-02-28 08:14:20 - [INFO] - main - VizAlerts v2.0.1 is starting

          MainThread - 2017-02-28 08:14:20 - [DEBUG] - trusted_ticket_test - testing trusted ticket: vtwtabwkr01, mkhambham, bbb.com, None

          MainThread - 2017-02-28 08:14:20 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: vtwtabwkr01, Site: , Username: mkhambham, Url: http://vtwtabwkr01/trusted, Postdata: username=bbb.com%5Cmkhambham.

          MainThread - 2017-02-28 08:14:20 - [DEBUG] - get_trusted_ticket - NOT using SSL and NOT verifying cert

          MainThread - 2017-02-28 08:14:20 - [DEBUG] - get_trusted_ticket - Got ticket: FnnAeA3BSjsiIwnimKII_iTq

          MainThread - 2017-02-28 08:14:20 - [DEBUG] - trusted_ticket_test - Generated test trusted ticket. Value is: FnnAeA3BSjsiIwnimKII_iTq

          MainThread - 2017-02-28 08:14:20 - [DEBUG] - get_alerts - Pulling source viz data down

          MainThread - 2017-02-28 08:14:20 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: vtwtabwkr01, Site: Athena, Username: mkhambham, Url: http://vtwtabwkr01/trusted, Postdata: username=bbb.com%5Cmkhambham&target_site=Athena.

          MainThread - 2017-02-28 08:14:20 - [DEBUG] - get_trusted_ticket - NOT using SSL and NOT verifying cert

          MainThread - 2017-02-28 08:14:20 - [DEBUG] - get_trusted_ticket - Got ticket: kJVEgab-2Tw6xPsHVGTPDj0A

          MainThread - 2017-02-28 08:14:20 - [DEBUG] - export_view - Getting vizdata from: http://vtwtabwkr01/trusted/kJVEgab-2Tw6xPsHVGTPDj0A/t/Athena/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y

          MainThread - 2017-02-28 08:14:20 - [DEBUG] - export_view - NOT Validating cert for this request

          MainThread - 2017-02-28 08:14:20 - [DEBUG] - _new_conn - Starting new HTTP connection (1): vtwtabwkr01

          MainThread - 2017-02-28 08:14:21 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /trusted/kJVEgab-2Tw6xPsHVGTPDj0A/t/Athena/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y HTTP/1.1" 302 0

          MainThread - 2017-02-28 08:14:22 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /t/Athena/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 406 0

          MainThread - 2017-02-28 08:14:22 - [ERROR] - export_view - HTTP error getting vizdata from url http://vtwtabwkr01/t/Athena/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y. Code: 406 Reason: Not Acceptable

          MainThread - 2017-02-28 08:14:22 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: vtwtabwkr01, Site: Athena, Username: mkhambham, Url: http://vtwtabwkr01/trusted, Postdata: username=bbb.com%5Cmkhambham&target_site=Athena.

          MainThread - 2017-02-28 08:14:22 - [DEBUG] - get_trusted_ticket - NOT using SSL and NOT verifying cert

          MainThread - 2017-02-28 08:14:22 - [DEBUG] - get_trusted_ticket - Got ticket: TRc2y0KDU9hH6743C4Wh90Ox

          MainThread - 2017-02-28 08:14:22 - [DEBUG] - export_view - Getting vizdata from: http://vtwtabwkr01/trusted/TRc2y0KDU9hH6743C4Wh90Ox/t/Athena/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y

          MainThread - 2017-02-28 08:14:22 - [DEBUG] - export_view - NOT Validating cert for this request

          MainThread - 2017-02-28 08:14:22 - [DEBUG] - _new_conn - Starting new HTTP connection (1): vtwtabwkr01

          MainThread - 2017-02-28 08:14:24 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /trusted/TRc2y0KDU9hH6743C4Wh90Ox/t/Anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y HTTP/1.1" 302 0

          MainThread - 2017-02-28 08:14:26 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /t/Anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 406 0

          MainThread - 2017-02-28 08:14:26 - [ERROR] - export_view - HTTP error getting vizdata from url http://vtwtabwkr01/t/Anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y. Code: 406 Reason: Not Acceptable

          MainThread - 2017-02-28 08:14:26 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: vtwtabwkr01, Site: Anthem, Username: mkhambham, Url: http://vtwtabwkr01/trusted, Postdata: username=bbb.com%5Cmkhambham&target_site=Anthem.

          MainThread - 2017-02-28 08:14:26 - [DEBUG] - get_trusted_ticket - NOT using SSL and NOT verifying cert

          MainThread - 2017-02-28 08:14:26 - [DEBUG] - get_trusted_ticket - Got ticket: mCIjKWggrWdPSztr4RCM66Ry

          MainThread - 2017-02-28 08:14:26 - [DEBUG] - export_view - Getting vizdata from: http://vtwtabwkr01/trusted/mCIjKWggrWdPSztr4RCM66Ry/t/Anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y

          MainThread - 2017-02-28 08:14:26 - [DEBUG] - export_view - NOT Validating cert for this request

          MainThread - 2017-02-28 08:14:26 - [DEBUG] - _new_conn - Starting new HTTP connection (1): vtwtabwkr01

          MainThread - 2017-02-28 08:14:26 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /trusted/mCIjKWggrWdPSztr4RCM66Ry/t/Anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y HTTP/1.1" 302 0

          MainThread - 2017-02-28 08:14:29 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /t/Anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 406 0

          MainThread - 2017-02-28 08:14:29 - [ERROR] - export_view - HTTP error getting vizdata from url http://vtwtabwkr01/t/Anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y. Code: 406 Reason: Not Acceptable

          MainThread - 2017-02-28 08:14:29 - [ERROR] - download_trigger_data - HTTP error getting vizdata from url http://vtwtabwkr01/t/Anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y. Code: 406 Reason: Not Acceptable

          MainThread - 2017-02-28 08:14:29 - [INFO] - send_email - sending email: webmail-kkk.bbb.com,tableautestserver@bbb.com,mkhambham@bbb.com,None,None,ALERT: VizAlerts failed to execute properly,None

          MainThread - 2017-02-28 08:14:29 - [DEBUG] - send_email - email body: Could not process source viz data from VizAlertsConfig/ScheduledTriggerViews for the following reasons:<br/><br/>HTTP error getting vizdata from url http://vtwtabwkr01/t/Anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y. Code: 406 Reason: Not Acceptable

          MainThread - 2017-02-28 08:14:30 - [ERROR] - <module> - An unhandled exception occurred: Traceback (most recent call last):

            File "E:\ViZAlerts\VizAlerts-master\VizAlerts-master\vizalerts.py", line 463, in <module>

              main()

            File "E:\ViZAlerts\VizAlerts-master\VizAlerts-master\vizalerts.py", line 130, in main

              alerts = get_alerts()

            File "E:\ViZAlerts\VizAlerts-master\VizAlerts-master\vizalerts.py", line 221, in get_alerts

              e.message))

            File "E:\ViZAlerts\VizAlerts-master\VizAlerts-master\vizalerts.py", line 448, in quit_script

              sys.exit(1)

          SystemExit: 1

          Traceback (most recent call last):

            File "E:\ViZAlerts\VizAlerts-master\VizAlerts-master\vizalerts.py", line 463, in <module>

              main()

            File "E:\ViZAlerts\VizAlerts-master\VizAlerts-master\vizalerts.py", line 130, in main

              alerts = get_alerts()

            File "E:\ViZAlerts\VizAlerts-master\VizAlerts-master\vizalerts.py", line 221, in get_alerts

              e.message))

            File "E:\ViZAlerts\VizAlerts-master\VizAlerts-master\vizalerts.py", line 448, in quit_script

              sys.exit(1)

          SystemExit: 1

           

           

          Thanks & Regards

          Madhu K

          • 2. Re: Need Help in configuring VizAlerts
            Matt Coles
            Matt Coles Employee Feb 28, 2017 9:24 AM (in response to Madhusudhan Khambham)

            Here's the key line. A 406 code means that something went wrong on the Tableau Server side--it couldn't provide what VizAlerts asked it to. The most common problem that causes a 406 on the VizAlertsConfig viz is not embedding credentials in your data source when you publish the workbook. Re-publish the workbook and make sure you are embedding your password in the connection to PostgreSQL when you do.

             

            MainThread - 2017-02-28 08:14:22 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /t/Athena/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 406 0

            • 3. Re: Need Help in configuring VizAlerts
              Madhusudhan Khambham
              Madhusudhan Khambham Feb 28, 2017 10:37 AM (in response to Matt Coles)

              Sorry, I did it with embedded password. Somehow its not saved. I deleted the copy and re-published it one more time.

              It did worked after i do that.

               

              now, we are even more closer  Matt Coles Thanks for your patience and helping me step by step.

               

              Is this(below logs) the expected behaviour? if not, can you please suggest the next step what i can do ?

               

              MainThread - 2017-02-28 12:20:47 - [INFO] - LoggerQuickSetup - Logging initialized, writing to .\logs\vizalerts.log_2017-02-28.log

              MainThread - 2017-02-28 12:20:47 - [INFO] - main - VizAlerts v2.0.1 is starting

              MainThread - 2017-02-28 12:20:47 - [DEBUG] - trusted_ticket_test - testing trusted ticket: vtwtabwkr01, mkhambham, bbb.com, None

              MainThread - 2017-02-28 12:20:47 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: vtwtabwkr01, Site: , Username: mkhambham, Url: http://vtwtabwkr01/trusted, Postdata: username=bbb.com%5Cmkhambham.

              MainThread - 2017-02-28 12:20:47 - [DEBUG] - get_trusted_ticket - NOT using SSL and NOT verifying cert

              MainThread - 2017-02-28 12:20:48 - [DEBUG] - get_trusted_ticket - Got ticket: dSEJ2t0m62aMlQebX9yFks9t

              MainThread - 2017-02-28 12:20:48 - [DEBUG] - trusted_ticket_test - Generated test trusted ticket. Value is: dSEJ2t0m62aMlQebX9yFks9t

              MainThread - 2017-02-28 12:20:48 - [DEBUG] - get_alerts - Pulling source viz data down

              MainThread - 2017-02-28 12:20:48 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: vtwtabwkr01, Site: anthem, Username: mkhambham, Url: http://vtwtabwkr01/trusted, Postdata: username=bbb.com%5Cmkhambham&target_site=anthem.

              MainThread - 2017-02-28 12:20:48 - [DEBUG] - get_trusted_ticket - NOT using SSL and NOT verifying cert

              MainThread - 2017-02-28 12:20:48 - [DEBUG] - get_trusted_ticket - Got ticket: bSTElhRlDBFLgFqQw0sySecT

              MainThread - 2017-02-28 12:20:48 - [DEBUG] - export_view - Getting vizdata from: http://vtwtabwkr01/trusted/bSTElhRlDBFLgFqQw0sySecT/t/anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y

              MainThread - 2017-02-28 12:20:48 - [DEBUG] - export_view - NOT Validating cert for this request

              MainThread - 2017-02-28 12:20:48 - [DEBUG] - _new_conn - Starting new HTTP connection (1): vtwtabwkr01

              MainThread - 2017-02-28 12:20:48 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /trusted/bSTElhRlDBFLgFqQw0sySecT/t/anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y HTTP/1.1" 302 0

              MainThread - 2017-02-28 12:20:49 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /t/anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 200 2

              MainThread - 2017-02-28 12:20:49 - [INFO] - export_view - Attempting to write to: .\temp\20170228122049983000_MainThread_VizAlertsConfig-ScheduledTriggerViews.csv

              MainThread - 2017-02-28 12:20:49 - [INFO] - main - Processing a total of 0 alerts

               

              Also, when i published the workbook, i changed two parameter values in it.

               

              default_allowed_recipient_address  as .*bbb.com

              default_allowed_from_address  as mkhambham@bbb.com

               

              Thanks & Regards

              Madhu K

              • 4. Re: Need Help in configuring VizAlerts
                Matt Coles
                Matt Coles Employee Feb 28, 2017 11:00 AM (in response to Madhusudhan Khambham)

                That's the expected behavior. You will want to edit your parameters slightly, these are regex patterns, not static strings, so you need to escape your periods:

                 

                default_allowed_recipient_address  as .*bbb\.com

                default_allowed_from_address  as mkhambham@bbb\.com

                 

                Once you've done that, proceed with the install guide as it walks you through the demo tests.

                1 of 1 people found this helpful
                • 5. Re: Need Help in configuring VizAlerts
                  Madhusudhan Khambham
                  Madhusudhan Khambham Feb 28, 2017 12:26 PM (in response to Matt Coles)

                  Thanks Matt Coles Simple Alert test is through now..will do the remaining tests. Appreciated your help from the bottom of my heart.

                   

                  Thanks

                  Madhu K

                  • 6. Re: Need Help in configuring VizAlerts
                    Madhusudhan Khambham
                    Madhusudhan Khambham Feb 28, 2017 5:22 PM (in response to Madhusudhan Khambham)

                    Hi Matt Coles

                     

                    Is it possible to use Outlook DL(Distribution list) here? I am doing the Extract failure alert with VizAlerts. My requirement is to send it to a group of audience when ever there is an extract  failure

                    I created a dashboard and published it , subscribed to the schedule (ViZAerts 15 mins schedule),  Its working fine and i am able to recieve the email.

                     

                    Now i need to change the 'Email To' to use a Distribution list (Outlook Group).

                     

                    Thanks & Regards

                    Madhu K

                    • 7. Re: Need Help in configuring VizAlerts
                      Matt Coles
                      Matt Coles Employee Feb 28, 2017 7:39 PM (in response to Madhusudhan Khambham)

                      See the User Guide on how to build alerts, it goes into a lot of detail on all the capabilities. The easy answer in your case is to use the address for the DL in the Email To field. Separate addresses with semicolons, as they're standard (though you can use space, comma, tabs or newline characters too).

                       

                      e.g.:

                       

                      'person1@bbb.com;team1@bbb.com'

                      • 8. Re: Need Help in configuring VizAlerts
                        Madhusudhan Khambham
                        Madhusudhan Khambham Mar 1, 2017 4:23 AM (in response to Matt Coles)

                        Thanks Matt Coles I saw the Bulk mailing section in the user guide. Will follow the steps.

                        • 9. Re: Need Help in configuring VizAlerts
                          Madhusudhan Khambham
                          Madhusudhan Khambham Mar 1, 2017 1:59 PM (in response to Madhusudhan Khambham)

                          Sorry Matt Coles I need your help again. I actually gone through the guides and i think, i am unable to grasp all the info we need to fix the below issue.

                           

                          I am trying to add two email ids in the Default_Allowed_Recipient_Addresses parameters  like mkhambham@bbb.com;uparimi@bbb.com

                          here, mkhambham is having Admin privileges and Uparimi is having an Interactor role.

                           

                          Its not recognizing  uparimi user . Am i doing anything wrong? Here, i am sharing the details, Could you please suggest me the right direction.

                           

                           

                          MainThread - 2017-03-01 15:26:03 - [INFO] - LoggerQuickSetup - Logging initialized, writing to .\logs\vizalerts.log_2017-03-01.log

                          MainThread - 2017-03-01 15:26:03 - [INFO] - main - VizAlerts v2.0.1 is starting

                          MainThread - 2017-03-01 15:26:03 - [DEBUG] - trusted_ticket_test - testing trusted ticket: vtwtabwkr01, mkhambham, bbb.com, None

                          MainThread - 2017-03-01 15:26:03 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: vtwtabwkr01, Site: , Username: mkhambham, Url: http://vtwtabwkr01/trusted, Postdata: username=bbb.com%5Cmkhambham.

                          MainThread - 2017-03-01 15:26:03 - [DEBUG] - get_trusted_ticket - NOT using SSL and NOT verifying cert

                          MainThread - 2017-03-01 15:26:03 - [DEBUG] - get_trusted_ticket - Got ticket: 8KhhbjgDmEhxmI9-7FDnTnyO

                          MainThread - 2017-03-01 15:26:03 - [DEBUG] - trusted_ticket_test - Generated test trusted ticket. Value is: 8KhhbjgDmEhxmI9-7FDnTnyO

                          MainThread - 2017-03-01 15:26:03 - [DEBUG] - get_alerts - Pulling source viz data down

                          MainThread - 2017-03-01 15:26:03 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: vtwtabwkr01, Site: anthem, Username: mkhambham, Url: http://vtwtabwkr01/trusted, Postdata: username=bbb.com%5Cmkhambham&target_site=anthem.

                          MainThread - 2017-03-01 15:26:03 - [DEBUG] - get_trusted_ticket - NOT using SSL and NOT verifying cert

                          MainThread - 2017-03-01 15:26:03 - [DEBUG] - get_trusted_ticket - Got ticket: xViJ9UWk0xt-1sxixcAodpQX

                          MainThread - 2017-03-01 15:26:03 - [DEBUG] - export_view - Getting vizdata from: http://vtwtabwkr01/trusted/xViJ9UWk0xt-1sxixcAodpQX/t/anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y

                          MainThread - 2017-03-01 15:26:03 - [DEBUG] - export_view - NOT Validating cert for this request

                          MainThread - 2017-03-01 15:26:03 - [DEBUG] - _new_conn - Starting new HTTP connection (1): vtwtabwkr01

                          MainThread - 2017-03-01 15:26:03 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /trusted/xViJ9UWk0xt-1sxixcAodpQX/t/anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y HTTP/1.1" 302 0

                          MainThread - 2017-03-01 15:26:05 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /t/anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 200 1142

                          MainThread - 2017-03-01 15:26:05 - [INFO] - export_view - Attempting to write to: .\temp\20170301152605035000_MainThread_VizAlertsConfig-ScheduledTriggerViews.csv

                          MainThread - 2017-03-01 15:26:05 - [INFO] - main - Processing a total of 1 alerts

                          MainThread - 2017-03-01 15:26:05 - [DEBUG] - main - Queueing subscription id 8 for processing

                          MainThread - 2017-03-01 15:26:05 - [DEBUG] - main - Starting thread with name: 1

                          1 - 2017-03-01 15:26:05 - [DEBUG] - run - Thread 1 is processing subscription_id 8, view_id 1471, site_name anthem, customized_view_id None, view_name Extract Failure Alert

                          MainThread - 2017-03-01 15:26:05 - [DEBUG] - main - Starting thread with name: 2

                          1 - 2017-03-01 15:26:05 - [DEBUG] - execute_alert - Starting to download trigger data

                          1 - 2017-03-01 15:26:05 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: vtwtabwkr01, Site: anthem, Username: mkhambham, Url: http://vtwtabwkr01/trusted, Postdata: username=bbb.com%5Cmkhambham&target_site=anthem.

                          1 - 2017-03-01 15:26:05 - [DEBUG] - get_trusted_ticket - NOT using SSL and NOT verifying cert

                          1 - 2017-03-01 15:26:05 - [DEBUG] - get_trusted_ticket - Got ticket: 1DrtjLkSDqMk39ERg2a5DB4z

                          1 - 2017-03-01 15:26:05 - [DEBUG] - export_view - Getting vizdata from: http://vtwtabwkr01/trusted/1DrtjLkSDqMk39ERg2a5DB4z/t/anthem/views/ExtractFailureAlert/ExtractFailureAlert?&:format=csv&:refresh=y

                          1 - 2017-03-01 15:26:05 - [DEBUG] - export_view - NOT Validating cert for this request

                          1 - 2017-03-01 15:26:05 - [DEBUG] - _new_conn - Starting new HTTP connection (1): vtwtabwkr01

                          1 - 2017-03-01 15:26:05 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /trusted/1DrtjLkSDqMk39ERg2a5DB4z/t/anthem/views/ExtractFailureAlert/ExtractFailureAlert?&:format=csv&:refresh=y HTTP/1.1" 302 0

                          1 - 2017-03-01 15:26:05 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /t/anthem/views/ExtractFailureAlert/ExtractFailureAlert?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 200 2589

                          1 - 2017-03-01 15:26:05 - [INFO] - export_view - Attempting to write to: .\temp\20170301152605925000_1_ExtractFailureAlert-ExtractFailureAlert.csv

                          1 - 2017-03-01 15:26:05 - [DEBUG] - execute_alert - Got trigger data, now parsing fields

                          1 - 2017-03-01 15:26:05 - [DEBUG] - parse_action_fields - Parsing action fields

                          1 - 2017-03-01 15:26:05 - [DEBUG] - parse_action_fields - searching for action fields

                          1 - 2017-03-01 15:26:05 - [DEBUG] - parse_action_fields - Retrieving all errors found in field parse operation

                          1 - 2017-03-01 15:26:05 - [DEBUG] - execute_alert - Validating trigger data

                          1 - 2017-03-01 15:26:05 - [DEBUG] - validate_trigger_data - Validating as a simple alert

                          1 - 2017-03-01 15:26:05 - [DEBUG] - address_is_invalid - testing address mkhambham@bbb.com against regex .*bbb\.com

                          1 - 2017-03-01 15:26:05 - [DEBUG] - address_is_invalid - Splitting Address: localpart, domainname, host, toplevel: mkhambham,bbb.com,bbb,com

                          1 - 2017-03-01 15:26:05 - [DEBUG] - address_is_invalid - Removing other characters from address: localpart, host: mkhambham,bbb

                          1 - 2017-03-01 15:26:05 - [DEBUG] - execute_alert - Performing alert actions

                          1 - 2017-03-01 15:26:05 - [DEBUG] - perform_actions - Performing alert actions now

                          1 - 2017-03-01 15:26:05 - [DEBUG] - perform_actions - Processing as a simple alert

                          1 - 2017-03-01 15:26:05 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: vtwtabwkr01, Site: anthem, Username: mkhambham, Url: http://vtwtabwkr01/trusted, Postdata: username=bbb.com%5Cmkhambham&target_site=anthem.

                          1 - 2017-03-01 15:26:05 - [DEBUG] - get_trusted_ticket - NOT using SSL and NOT verifying cert

                          1 - 2017-03-01 15:26:05 - [DEBUG] - get_trusted_ticket - Got ticket: kr9WZXJYwwTPUll9KqCeIfyr

                          1 - 2017-03-01 15:26:05 - [DEBUG] - export_view - Getting vizdata from: http://vtwtabwkr01/trusted/kr9WZXJYwwTPUll9KqCeIfyr/t/anthem/views/ExtractFailureAlert/ExtractFailureAlert?&:format=png&:size=1500,1500&:refresh=y

                          1 - 2017-03-01 15:26:06 - [DEBUG] - export_view - NOT Validating cert for this request

                          1 - 2017-03-01 15:26:06 - [DEBUG] - _new_conn - Starting new HTTP connection (1): vtwtabwkr01

                          1 - 2017-03-01 15:26:06 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /trusted/kr9WZXJYwwTPUll9KqCeIfyr/t/anthem/views/ExtractFailureAlert/ExtractFailureAlert?&:format=png&:size=1500,1500&:refresh=y HTTP/1.1" 302 0

                          1 - 2017-03-01 15:26:07 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /t/anthem/views/ExtractFailureAlert/ExtractFailureAlert?&:format=png&:size=1500,1500&:refresh=y&:embed=y HTTP/1.1" 200 52986

                          1 - 2017-03-01 15:26:07 - [INFO] - export_view - Attempting to write to: .\temp\20170301152607097000_1_ExtractFailureAlert-ExtractFailureAlert.png

                          1 - 2017-03-01 15:26:07 - [INFO] - perform_actions - Sending simple alert email to user mkhambham@bbb.com

                          1 - 2017-03-01 15:26:07 - [INFO] - send_email - sending email: webmail-knx.bbb.com,tableautestserver@bbb.com,mkhambham@bbb.com,None,None,Alert triggered for Extract Failure Alert,[{'imagepath': u'.\\temp\\20170301152607097000_1_ExtractFailureAlert-ExtractFailureAlert.png'}]

                          1 - 2017-03-01 15:26:07 - [DEBUG] - send_email - email body: <a href="http://vtwtabwkr01/t/anthem/views/ExtractFailureAlert/ExtractFailureAlert"><img src="cid:20170301152607097000_1_ExtractFailureAlert-ExtractFailureAlert.png"></a><br><br><font size="2"><i>This VizAlerts email generated on behalf of <a href="mailto:mkhambham@bbb.com">mkhambham</a>, from view <a href="http://vtwtabwkr01/t/anthem/views/ExtractFailureAlert/ExtractFailureAlert">Extract Failure Alert</a></i></font>

                          MainThread - 2017-03-01 15:26:15 - [INFO] - main - Waiting on 0 worker threads. Currently active threads:: [<_MainThread(MainThread, started 6996)>]

                          MainThread - 2017-03-01 15:26:15 - [INFO] - main - Worker threads have completed. Exiting

                           

                           

                          Attempt two : I am trying to add two email ids in the Default_Allowed_Recipient_Addresses parameters  like mkhambham@bbb\.com;uparimi@bbb\.com

                           

                           

                          The following errors were encountered trying to process your alert:


                          General errors:

                          Address must match regex pattern set by the administrator: mkhambham@bbb\.com;uparimi@bbb\.com

                          Alert Information:

                          View URL: http://vtwtabwkr01/t/Anthem/views/ExtractFailureAlert/ExtractFailureAlert
                          Subscriber: mkhambham
                          View Owner: mkhambham
                          Site Id: Anthem
                          Project: AAAAAAAA

                           

                          Got the below log information.

                          MainThread - 2017-03-01 15:51:44 - [INFO] - LoggerQuickSetup - Logging initialized, writing to .\logs\vizalerts.log_2017-03-01.log

                          MainThread - 2017-03-01 15:51:44 - [INFO] - main - VizAlerts v2.0.1 is starting

                          MainThread - 2017-03-01 15:51:44 - [DEBUG] - trusted_ticket_test - testing trusted ticket: vtwtabwkr01, mkhambham, bbb.com, None

                          MainThread - 2017-03-01 15:51:44 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: vtwtabwkr01, Site: , Username: mkhambham, Url: http://vtwtabwkr01/trusted, Postdata: username=bbb.com%5Cmkhambham.

                          MainThread - 2017-03-01 15:51:44 - [DEBUG] - get_trusted_ticket - NOT using SSL and NOT verifying cert

                          MainThread - 2017-03-01 15:51:45 - [DEBUG] - get_trusted_ticket - Got ticket: gtaiM1XInbtrbc40lOuUFwIq

                          MainThread - 2017-03-01 15:51:45 - [DEBUG] - trusted_ticket_test - Generated test trusted ticket. Value is: gtaiM1XInbtrbc40lOuUFwIq

                          MainThread - 2017-03-01 15:51:45 - [DEBUG] - get_alerts - Pulling source viz data down

                          MainThread - 2017-03-01 15:51:45 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: vtwtabwkr01, Site: anthem, Username: mkhambham, Url: http://vtwtabwkr01/trusted, Postdata: username=bbb.com%5Cmkhambham&target_site=anthem.

                          MainThread - 2017-03-01 15:51:45 - [DEBUG] - get_trusted_ticket - NOT using SSL and NOT verifying cert

                          MainThread - 2017-03-01 15:51:45 - [DEBUG] - get_trusted_ticket - Got ticket: YmOuXI8pKS1d4OvUk4FOIlDC

                          MainThread - 2017-03-01 15:51:45 - [DEBUG] - export_view - Getting vizdata from: http://vtwtabwkr01/trusted/YmOuXI8pKS1d4OvUk4FOIlDC/t/anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y

                          MainThread - 2017-03-01 15:51:45 - [DEBUG] - export_view - NOT Validating cert for this request

                          MainThread - 2017-03-01 15:51:45 - [DEBUG] - _new_conn - Starting new HTTP connection (1): vtwtabwkr01

                          MainThread - 2017-03-01 15:51:45 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /trusted/YmOuXI8pKS1d4OvUk4FOIlDC/t/anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y HTTP/1.1" 302 0

                          MainThread - 2017-03-01 15:51:47 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /t/anthem/views/VizAlertsConfig/ScheduledTriggerViews?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 200 1150

                          MainThread - 2017-03-01 15:51:47 - [INFO] - export_view - Attempting to write to: .\temp\20170301155147768000_MainThread_VizAlertsConfig-ScheduledTriggerViews.csv

                          MainThread - 2017-03-01 15:51:47 - [INFO] - main - Processing a total of 1 alerts

                          MainThread - 2017-03-01 15:51:47 - [DEBUG] - main - Queueing subscription id 8 for processing

                          MainThread - 2017-03-01 15:51:47 - [DEBUG] - main - Starting thread with name: 1

                          1 - 2017-03-01 15:51:47 - [DEBUG] - run - Thread 1 is processing subscription_id 8, view_id 1471, site_name anthem, customized_view_id None, view_name Extract Failure Alert

                          MainThread - 2017-03-01 15:51:47 - [DEBUG] - main - Starting thread with name: 2

                          1 - 2017-03-01 15:51:47 - [DEBUG] - execute_alert - Starting to download trigger data

                          1 - 2017-03-01 15:51:47 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: vtwtabwkr01, Site: anthem, Username: mkhambham, Url: http://vtwtabwkr01/trusted, Postdata: username=bbb.com%5Cmkhambham&target_site=anthem.

                          1 - 2017-03-01 15:51:47 - [DEBUG] - get_trusted_ticket - NOT using SSL and NOT verifying cert

                          1 - 2017-03-01 15:51:47 - [DEBUG] - get_trusted_ticket - Got ticket: 00oGKJ9t49-7x299mUtn33Ir

                          1 - 2017-03-01 15:51:47 - [DEBUG] - export_view - Getting vizdata from: http://vtwtabwkr01/trusted/00oGKJ9t49-7x299mUtn33Ir/t/anthem/views/ExtractFailureAlert/ExtractFailureAlert?&:format=csv&:refresh=y

                          1 - 2017-03-01 15:51:47 - [DEBUG] - export_view - NOT Validating cert for this request

                          1 - 2017-03-01 15:51:47 - [DEBUG] - _new_conn - Starting new HTTP connection (1): vtwtabwkr01

                          1 - 2017-03-01 15:51:47 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /trusted/00oGKJ9t49-7x299mUtn33Ir/t/anthem/views/ExtractFailureAlert/ExtractFailureAlert?&:format=csv&:refresh=y HTTP/1.1" 302 0

                          1 - 2017-03-01 15:51:49 - [DEBUG] - _make_request - http://vtwtabwkr01:80 "GET /t/anthem/views/ExtractFailureAlert/ExtractFailureAlert?&:format=csv&:refresh=y&:embed=y HTTP/1.1" 200 2589

                          1 - 2017-03-01 15:51:49 - [INFO] - export_view - Attempting to write to: .\temp\20170301155149076000_1_ExtractFailureAlert-ExtractFailureAlert.csv

                          1 - 2017-03-01 15:51:49 - [DEBUG] - execute_alert - Got trigger data, now parsing fields

                          1 - 2017-03-01 15:51:49 - [DEBUG] - parse_action_fields - Parsing action fields

                          1 - 2017-03-01 15:51:49 - [DEBUG] - parse_action_fields - searching for action fields

                          1 - 2017-03-01 15:51:49 - [DEBUG] - parse_action_fields - Retrieving all errors found in field parse operation

                          1 - 2017-03-01 15:51:49 - [DEBUG] - execute_alert - Validating trigger data

                          1 - 2017-03-01 15:51:49 - [DEBUG] - validate_trigger_data - Validating as a simple alert

                          1 - 2017-03-01 15:51:49 - [DEBUG] - address_is_invalid - testing address mkhambham@bbb.com against regex mkhambham@bbb\.com;uparimi@bbb\.com

                          1 - 2017-03-01 15:51:49 - [ERROR] - address_is_invalid - Address must match regex pattern set by the administrator: mkhambham@bbb\.com;uparimi@bbb\.com

                          1 - 2017-03-01 15:51:49 - [ERROR] - validate_trigger_data - VizAlerts was unable to process this alert, because it was unable to send email to address mkhambham@bbb.com: Address must match regex pattern set by the administrator: mkhambham@bbb\.com;uparimi@bbb\.com

                          1 - 2017-03-01 15:51:49 - [DEBUG] - alert_failure - All errors found:

                          1 - 2017-03-01 15:51:49 - [DEBUG] - alert_failure - Address must match regex pattern set by the administrator: mkhambham@bbb\.com;uparimi@bbb\.com

                          1 - 2017-03-01 15:51:49 - [INFO] - send_email - sending email: webmail-knx.bbb.com,tableautestserver@bbb.com,mkhambham@bbb.com,mkhambham@bbb.com,None,VizAlerts was unable to process alert Extract Failure Alert,None

                          1 - 2017-03-01 15:51:49 - [DEBUG] - send_email - email body: The following errors were encountered trying to process your alert:<br /><br /><br /><br />General errors:<br /><br />Address must match regex pattern set by the administrator: mkhambham@bbb\.com;uparimi@bbb\.com<br><br><b>Alert Information:</b><br><br><b>View URL:</b> <a href="http://vtwtabwkr01/t/anthem/views/ExtractFailureAlert/ExtractFailureAlert">http://vtwtabwkr01/t/anthem/views/ExtractFailureAlert/ExtractFailureAlert<a><br><b>Subscriber:</b> <a href="mailto:mkhambham@bbb.com">mkhambham</a><br><b>View Owner:</b> <a href="mailto:mkhambham@bbb.com">mkhambham</a><br><b>Site Id:</b> anthem<br><b>Project:</b> bbb/P1 Score Card

                          MainThread - 2017-03-01 15:51:57 - [INFO] - main - Waiting on 0 worker threads. Currently active threads:: [<_MainThread(MainThread, started 19008)>]

                          MainThread - 2017-03-01 15:51:57 - [INFO] - main - Worker threads have completed. Exiting

                           

                          Thanks & Regards

                          Madhu K

                          • 10. Re: Need Help in configuring VizAlerts
                            Matt Coles
                            Matt Coles Employee Mar 1, 2017 2:03 PM (in response to Madhusudhan Khambham)

                            Okay, so: In the workbook you are showing us, the values for allowed_recipient_addresses and the allowed_from_address are not the same format as you would use in your actual Alert workbook. These are rules for what the destination and source addresses need to match, and they are treated as regular expressions. They are patterns to be matched. When any of the intended recipients don't match the pattern defined in allowed_recipient_addresses, then the alert fails. Same thing with From and allowed_from_address.

                             

                            So, because they are regular expressions, and the Alert field are specifying the specific address list, this example results in a non-match, and therefore, a failure:

                             

                            allowed_recipient_addresses in VizAlertsConfig.twb: mkhambham@bbb.com;uparimi@bbb.com

                            Email To * in your Alert viz: mkhambham@bbb.com;uparimi@bbb.com

                             

                            The reason it is a non-match is that, first off, you should escape period characters in your regex pattern, because in regex, a period is special--it means "any single character". So allowed_recipient_addresses needs to be:

                             

                            mkhambham@bbb\.com;uparimi@bbb\.com

                             

                            But we're not done. Because this entire string is one pattern, that means every recipient address will need to match it. A comma in regex is just a comma character, it does not mean "OR". So we need to use pipe for that instead, which means "OR" in regex:

                             

                            mkhambham@bbb\.com|uparimi@bbb\.com

                             

                            Now, what you are saying is: "Every email sent by any VizAlert must only be sent to mkhambham@bbb.com OR uparimi@bbb.com. If any alert tries to send mail to any other address, it should fail."

                             

                            When VizAlerts processes an alert, it will now look at the Email To * field in the data, and compare each recipient to that pattern. Let's say you have the field set to "mkhambham@bbb.com;uparimi@bbb.com". When it runs, it grabs the data, identifies the right Email To field, then iterates through each row. For each value, it splits the list of addresses up, and matches them individually against the pattern you defined in allowed_recipient_addresses. So it says (in pseudocode):

                             

                            "mkhambham@bbb.com;uparimi@bbb.com"

                             

                            ...is two addresses:

                            mkhambham@bbb.com

                            and

                            uparimi@bbb.com

                             

                            Does mkhambham@bbb.com match regex('mkhambham@bbb\.com|uparimi@bbb\.com') ? YES

                            Does uparimi@bbb.com match regex('mkhambham@bbb\.com|uparimi@bbb\.com') ? YES

                             

                            Good to go; send the emails!

                             

                            To learn more about regular expressions, how to use them, and test whether they're doing what you want, I highly recommend RegExr: Learn, Build, & Test RegEx .