1. This issue has puzzled me for a while. I have searched "Subscription Button" on the web to no avail. Today's I searched "Subscription Icon" and I found the solution provided by John Liptak. The reason is that the server needs "at least one valid schedule for Subscription" for the button to show up. This helped me solving the problem! Later I found that Matt Coles gave a troubleshooting checklist which included the above as the last point. Most other suggested solutions or Tableau online help didn't mention the solution.

    Just to document it here. The steps are (for server admins):

    1.Create a schedule for Subscription on the Tableau Server

    2.Make sure the above schedule is enabled. When a schedule is enabled, it has a Next Run Time. The Enable button in the menu is shaded.
    If you disable the schedule, the next run time will not show. It's replaced by "Disabled".

    Voila your subscription button will show up!
    Just thought of an alternative design:
    1.Always show the subscription button
    2.When clicking on it, it shows "no schedule available, contact admin." if no schedule exist.
    1

    View comments

  2. One of frequent tasks of managing a Tableau server is watching the failed data extracts and then fixing them. In a recent Tableau webinar, I presented a server admin view that helps monitor the data extract failure.
    https://www.tableau.com/learn/webinars/tableau-administrators-virtual-user-group-6

    In the server admin views, the admin can view a dashboard of similar functions. However, the publishers have no access to it. In order to provide self-service dashboard monitoring to the publishers, we have created our own monitor and offer it to whoever is concerned.
    For a variety of reasons, the data extract refresh may fail to work as scheduled.

    I summarized all the failures as 5 types.
    - Bad data file path
    When the data is in a flat file, such as Excel, Access, CSV etc, the server can't find the data file. One of the most likely cases is the file path is in local format, such as C:\folder\data.csv. The server actually expects an UNC path such as \\machine\folder\data.csv

    - DB connect fail
    The connection to the database failed. Need to fix the connection settings or the network etc.

    - DB query fail
    The query worked when being published. However the database tables may have changed. The query can fail in this case. The solution is to revise the query.

    - Data engine fail
    The service may be down. Need a reboot.

    - Suspended
    There are too many failures. Need to download the workbook or data source and republish it. The failure will resurface and the error message will tell you what the failure is.

    The extract failure monitor workbook is available in the Tableau community forum. Feel free to download it and play with it. Let me know if there is issue. 

    I am very grateful to Mark Wu, the moderator of the webinar who invited me to present, and Matt Coles, whose PostgreSQL query is being used in the monitor workbook.
    3

    View comments

Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.