429000: Too Many Requests

[yo-lvgs]

Describe the bug
I had the code working for 2 months and 11/3 I got the error 429000

Versions
Details of your environment, including:

• Tableau Server version (or note if using Tableau Online)
  • Tableau Online
• Python version
  • Python 3.7
• TSC library version
  • 3.1

To Reproduce

            # refresh
            task_pre_to_run = server.tasks.get_by_id(task_id)
            server.tasks.run(task_pre_to_run)

            # get job list 
            req_option = TSC.RequestOptions()
            req_option.filter.add(TSC.Filter('jobType', TSC.RequestOptions.Operator.Equals, 'refresh_extracts'))
            req_option.filter.add(TSC.Filter('createdAt', TSC.RequestOptions.Operator.GreaterThan, datetime_now))

            for job in TSC.Pager(server.jobs, request_opts=req_option):
                job_get_by_id = server.jobs.get_by_id(job.id)
                # wait for the job finished 
                while job_get_by_id.finish_code == -1:
                    print('in progress')
                    time.sleep(30)
                    job_get_by_id = server.jobs.get_by_id(job.id)
                    if job_get_by_id.finish_code != -1:
                        print('not in progress')
                        break

            print('finished')

Results

	429000: Too Many Requests
		Too many requests for 'api.rest.refresh_extracts'. Please retry after 29 minutes. (ServerResponseError)
	from Traceback (most recent call last):

	from   File ".digdag/tmp/digdag-py-3468120-15445337580251890801/runner.py", line 158, in <module>
    result = method(**method_args)

	from   File "/tmp/digdag-tempdir989003298967390830/workspace/27_all_manage_frequent_update_61865_3468120_3626330837559723575/refresh_tableau_datasource.py", line 49, in refresh_tableau_datasource
    server.tasks.run(task_pre_to_run)

	from   File "/usr/lib/python3.7/tableauserverclient/server/endpoint/endpoint.py", line 163, in wrapper
    return func(self, *args, **kwargs)

	from   File "/usr/lib/python3.7/tableauserverclient/server/endpoint/tasks_endpoint.py", line 65, in run
    server_response = self.post_request(url, run_req)

	from   File "/usr/lib/python3.7/tableauserverclient/server/endpoint/endpoint.py", line 136, in post_request
    content_type=content_type,

	from   File "/usr/lib/python3.7/tableauserverclient/server/endpoint/endpoint.py", line 69, in _make_request
    self._check_status(server_response)

	from   File "/usr/lib/python3.7/tableauserverclient/server/endpoint/endpoint.py", line 86, in _check_status
    raise ServerResponseError.from_response(server_response.content, self.parent_srv.namespace)

NOTE: Be careful not to post user names, passwords, auth tokens or any other private or sensitive information.

[jacalata]

I believe there were some changes to our rate limits, which could have been implemented on 11/3. Does your usage exceed the limits described here? https://help.tableau.com/current/online/en-us/to_site_capacity.htm

[yo-lvgs]

@jacalata Thanks to your reply.I think my usage didn't exceed the limits.

[jacalata]

Hm, if so that would be a server problem - tsc just passes back the error code. Any chance you have a timestamp of when this happened so I can have someone look into it? And did it work again after 29 minutes, as it said?

[yo-lvgs]

@jacalata

did it work again after 29 minutes, as it said?

I run the code after 29 minutes but got the same error again.

I think It might be better to tell you more details.
I have a code to refresh 90 tasks every 2 hours.It works well until 11/3.But from 11/3,after I ran the code for 15 min,it showed the error 42900.It only refreshed 20 tasks successfully.I tried to refresh the datasource on Tableau Online and I can only refresh 20 datasource approximately once.

[jacalata]

Sorry for dropping the thread - the only reason I can imagine for this is exceeding the throttling limits. If you have an account manager at Tableau, you can ask them to check what it the limit is supposed to be and how many calls you are making (the throttling limit will include all users, so if someone else is also using your site that could explain it?).

As I said, this is being sent from the server, so I'm afraid there's nothing we can do about it in tsc.