I'm sure this is probably something I'm overlooking that is pretty simple, or a something in the manual that I've missed, but I can't figure this out. I've tried my best though! Sorry if I end up with a, "oh...duh..." moment
I'm running vizalerts.py from our Dev box against our QA primary box and have also tried QA worker1. I've subscribed a few views to the Alerts subscription, which is named Аlerts – hourly. I have not edited the SQL at the bottom of the .py.
I've tried running vizalerts.py with that subscription disabled, enabled, 15 minutes, 60 minutes. But it never seems that the postgres repository is seeing that I've subscribed any views. When I was trying to run the python script on our QA primary against the QA primary, I ran into issues. I was initially seeing issues with the -1 trusted ticket error.
Here's the entirety of the messaging when the .py is run, any ideas?
2015-12-09 11:18:58 - [INFO] - LoggerQuickSetup - Logging initialized, writing to .\logs\vizalerts.log_2015-12-09.log
2015-12-09 11:18:58 - [DEBUG] - trusted_ticket_test - testing trusted ticket: <QA cluster primary>, <userid>, None
2015-12-09 11:18:58 - [DEBUG] - get_trusted_ticket - Generating trusted ticket. Request details: Server: <QA cluster primary>, Site: , Username: <userid>, Url: http://<QA cluster primary>/trusted, Postdata: username=<userid>.
2015-12-09 11:18:59 - [DEBUG] - get_trusted_ticket - Got ticket: 1moeuDpRcHHrLEYAH5LyQx6C
2015-12-09 11:18:59 - [DEBUG] - trusted_ticket_test - Generated test trusted ticket. Value is: 1moeuDpRcHHrLEYAH5LyQx6C
2015-12-09 11:18:59 - [DEBUG] - get_views - PostgreSQL repository returned 0 rows
2015-12-09 11:18:59 - [INFO] - main - Processing a total of 0 views
This is the step in the help documentation that I'm stumped with:
Now, for a more extensive test. Subscribe to any Tableau Server View on an Alerts schedule that you set up (pick a view that renders in less than 10 seconds or so). I recommend subscribing on an Alerts schedule that runs every 15 minutes for this test, even if you just remove it afterward. After you subscribe, run the command again:
Now, wait 15 minutes, then run the same command again. If data is present in the viz, you should receive an email! If not, you shouldn’t. Simple as that!