any ideas on how good the "Notify on extract failure" is working in the new Tableau Version?
Well, I would say that it's a very welcome feature addition. Folks have been asking for it for a long time, so it's great that we now have it. We currently have this feature turned on for two out of three of our Tableau Server instances. The emails look nice, they're sent promptly, and they make it clear to the owner of the content that failed to refresh that it has N more failures to go before extract refreshes are suspended (requiring manual intervention to start back up again). So just having that visibility for our users is fantastic. And having the ability to auto-suspend constantly failing extracts is really wonderful, because it takes a lot of the onus off the Admin to fix everyone's problems for them, when they're the only ones who can fix it!
However, our setup is somewhat more extreme than most enterprises. We run a lot of extracts very frequently--many run hourly, and one particular set of content runs as frequently as every fifteen minutes. The extracts that run every fifteen minutes or ever hour fail every once in awhile, usually due to SQL Server problems, but the next iteration succeeds again. The result is that you would get a decent amount of noise generated by the emails that doesn't really warrant any action, as the data isn't unacceptably stale just yet, and the problem is self-correcting.
Another unique situation for us is that we're constantly adding new users to the mix who all have access to Tableau Desktop when they're onboarded. When you do that, they all start publishing to Server and trying to refresh files still stored on their laptop. The emails sent by Tableau Server in that case don't know the particulars of our environment, and therefore can't instruct users to "always use UNC paths for your files, and make sure they're shared with the [RunAsUser] account having Read access".
So, we have our own custom alerts that go out that look very much like the standard ones, but we added some custom features where it suggests specific actions to take to resolve the problem that came up. It also allows the recipient to open a viz that shows them the history of all their extract refreshes. For very frequently-running extracts, it doesn't email the owner until the extract fails twice in a row or more. It's helped cut down on the over-notification problem we'd otherwise have.
But again, we're a pretty extreme example. For the vast majority of Server customers, I'd say this is a great feature.
Thank you man
Matt's being humble here...the "custom alerts" he mentions towards the bottom are coming from VizAlerts http://github.com/tableau/VizAlerts, which he is one of the developers of (I'm another). Matt will be demonstrating those custom alerts in our VizAlerts presentation next week at the 2016 Tableau Conference http://tc16.tableau.com/learn/sessions/3377.
Is there a way you can share with me an example of an email that was automatically sent about Extract Failures. I just want to see a sample of it and how it looks like and how much details in it.
In my work i use Tableau server and like a lot a people, i need to know if my extract refresh fail or not.
So i begin to study your helpfull creation, Viz alert. But we will install tableau server 10 and i saw that version offers :
"Notify on extract failure
Catch extract refresh issues before they become a problem. Tableau can alert you to possible extract refresh issues via email, so you can quickly resolve them."
So what the difference between your creation, Viz alert, and these new options in tableau 10 ?
I'm a little bit lost because my english is not perfect and there are a lot of information.
Thank you very much,
1 of 1 people found this helpful
Hi Poret! If all you are after is people being emailed when their extracts fail to refresh, then I would simply stick with Tableau Server v10.0. VizAlerts can handle a wide variety of conditional email and SMS notifications / reports from Tableau Server, with any of your Publisher users able to build their own notifications based on whatever data conditions they want. The advantages can be numerous, but I wouldn't necessarily recommend installing it just to solve the extract failure notification problem, if the product has already done so. Here's a link describing the advantages and disadvantages to both methods for the extract failure use case.
I just need to have a email when extracts fail so i'll take the option Tableau server 10. But all of VizAlerts possibility look really interesting.
Thank you very much for your explanation and the link. I'll read this.
Have a nice day,