-
1. Re: Need Help in configuring VizAlerts
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 ColesFeb 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 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 ColesFeb 28, 2017 11:00 AM (in response to Madhusudhan Khambham)
1 of 1 people found this helpfulThat'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.
-
5. Re: Need Help in configuring VizAlerts
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 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 ColesFeb 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.:
-
8. Re: Need Help in configuring VizAlerts
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 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: AAAAAAAAGot 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 ColesMar 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:
and
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 .