Schedules cannot handle valid monthly schedules #1358

Activity

1. jacalata

   added

   bug

   on Feb 15, 2024
2. bcantoni commented on May 4, 2024

   

   bcantoni

   on May 4, 2024

   Contributor

   More actions

   Another example of this is reported in #1369 which I closed as a duplicate.
3. bcantoni commented on Sep 10, 2024

   

   bcantoni

   on Sep 10, 2024

   Contributor

   More actions

   We're investigating a fix here (internal issue 16715720).
4. bcantoni

   added a commit that references this issue on Sep 13, 2024

   Add support for all monthly schedule variations

   ...

   This issue will close once commit 9c6cc8f is merged into the 'development' branch.

   9c6cc8f
5. bcantoni commented on Sep 13, 2024

   

   bcantoni

   on Sep 13, 2024

   Last edited by bcantoni

   Contributor

   More actions

   Here are steps to reproduce the issue on Tableau Server.

   1. Login to Tableau Server and head to the Schedules settings page. (You'll need to be a server admin to edit these.)
   2. Create a new schedule, type Extract Refresh, under Frequency select Monthly, then under On change it to any value other than the default Day, then save the schedule

   

   3. Run the script below (substituting your own values for the PAT, site and server) which will loop over all schedules and call get_by_id() on each one. This should trigger the ValueError exception.

   import tableauserverclient as TSC
   
   
   tableau_auth = TSC.PersonalAccessTokenAuth(
       'PAT-NAME',
       'PAT-VALUE',
       'SITE-NAME-OR-BLANK'
       )
   server = TSC.Server('SERVER-URL', use_server_version=True)
   server.auth.sign_in(tableau_auth)
   
   all_sch, pagination = server.schedules.get()
   for sch in all_sch:
       sc = server.schedules.get_by_id(sch.id)
       print(sc.id)

   You should get the error with exceptions like the following:

   Traceback (most recent call last):
     File "/Users/brian/.pyenv/versions/tools-3.12/lib/python3.12/site-packages/tableauserverclient/models/interval_item.py", line 259, in interval
       if not (1 <= int(interval_value) <= 31):
                    ^^^^^^^^^^^^^^^^^^^
   ValueError: invalid literal for int() with base 10: 'Monday'
   
   ValueError: Invalid interval value for a monthly frequency: Monday.
   
6. bcantoni

   added a commit that references this issue on Sep 17, 2024

   Add support for all types of monthly repeating schedules (#1462)

   ...

   This issue will close once commit 52c1541 is merged into the 'development' branch.

   52c1541
7. jacalata

   added a commit that references this issue on Sep 17, 2024

   Add support for all types of monthly repeating schedules (#1462)

   ...

   This issue will close once commit 28c2487 is merged into the 'development' branch.

   28c2487
8. bcantoni commented on Sep 17, 2024

   

   bcantoni

   on Sep 17, 2024

   Contributor

   More actions

   This is fixed in the development branch now and will be available in the next release (0.33). If anyone would like to test it before release, they can follow the steps here: https://tableau.github.io/server-client-python/docs/#install-from-the-development-branch
9. jacalata

   closed this as completedin 28c2487on Sep 17, 2024
10. vchavatapalli

    added a commit that references this issue on May 5, 2026

    Add support for all types of monthly repeating schedules (tableau#1462)

    ...

    This issue will close once commit d02d0c8 is merged into the 'master' branch.

    d02d0c8