400130: Bad Request There was a problem querying the crosstab for view
還沒有人認領這個 Issue。
評估
研究方向
Start with samples/export.py and the views_endpoint.py traceback, then reproduce the Excel export against a view containing no data. Trace how the 400130 response is handled and define the expected behavior for this empty-view case; the issue is done when that export path has a verified outcome instead of the reported failure.
由索引模型根據 Issue 內容生成。
描述
Describe the bug
When a workbook's view contains no data, the export to excel would throw the following error.
400130: Bad Request
There was a problem querying the crosstab for view
Versions
Details of your environment, including:
- Tableau Server version (or note if using Tableau Online) v.2022.1.6
- Python version Python 3.7.4
- TSC library version 0.23
To Reproduce
python D:\Tableau\server-client-python\samples\export.py -s http://txxxxx.mybsc.com --site "" -u svcUser --xlsx -f "\bsc\cq\Care1st\FISERV\AUTOPAY ENROLLMENT OOS\Refund.xlsx" exxxxxxx-1xxx-xxxx-xxxx-xxxxxxxxxxx
Signing in...
Server: http://txxxxxx.mybsc.com
Site:
Username: svcUser
Connected
Item found: MAPD Autopay Refund Report
Traceback (most recent call last):
File "D:\Tableau\server-client-python\samples\export.py", line 127, in
main()
File "D:\Tableau\server-client-python\samples\export.py", line 120, in main
f.writelines(getattr(item, member_name))
File "D:\Program Files\Python37\lib\site-packages\tableauserverclient\server\endpoint\views_endpoint.py", line 149, in _get_view_excel
with closing(self.get_request(url, request_object=req_options, parameters={"stream": True})) as server_response:
File "D:\Program Files\Python37\lib\site-packages\tableauserverclient\server\endpoint\endpoint.py", line 129, in get_request
parameters=parameters,
File "D:\Program Files\Python37\lib\site-packages\tableauserverclient\server\endpoint\endpoint.py", line 72, in _make_request
self._check_status(server_response, url)
File "D:\Program Files\Python37\lib\site-packages\tableauserverclient\server\endpoint\endpoint.py", line 87, in _check_status
raise ServerResponseError.from_response(server_response.content, self.parent_srv.namespace, url)
tableauserverclient.server.endpoint.exceptions.ServerResponseError:
400130: Bad Request
There was a problem querying the crosstab for view 'exxxxxxx-1xxx-xxxx-xxxx-xxxxxxxxxxx'.
Results
400130: Bad Request
There was a problem querying the crosstab for view 'exxxxxxx-1xxx-xxxx-xxxx-xxxxxxxxxxx'.
NOTE: Be careful not to post user names, passwords, auth tokens or any other private or sensitive information.
- 主要語言
- Python
- 星號
- 716
- 分支
- 446
- 平均合併
- 1 天 2 小時
- 30 天內合併 PR
- 1
環境準備
從這裡開始
- 先讀完整個 Issue，再讀專案的貢獻指南。
- 在 Issue 下留言說明你要接手 —— 這能避免兩個人做同樣的事。
- Fork 儲存庫，在一個分支上完成修改。
- 送出 Pull Request，並在描述裡引用這個 Issue 編號。
tableau/server-client-python 的其他 Issue
-
in-progress
難度 2/5 1-3 小時 新手友好度 78/100
tableau/server-client-python#1884 ·
-
難度 2/5 1-3 小時 新手友好度 70/100
tableau/server-client-python#1865 ·
-
in-progress
難度 2/5 1-3 小時 新手友好度 78/100
tableau/server-client-python#1829 · 1 則留言 ·
-
enhancement gap needs investigation
難度 2/5 1-3 小時 新手友好度 68/100
tableau/server-client-python#1322 · 1 則留言 ·
-
[Type2] Allow Incremental Refresh type schedules to be added via `server.schedules.add_to_schedule`未關閉help wanted Server-Side Enhancement ui-exists
難度 2/5 1-3 小時 新手友好度 68/100
tableau/server-client-python#1101 · 3 則留言 ·
查看 tableau/server-client-python 的全部 Issue
相似的 Issue
-
難度 2/5 1-3 小時 新手友好度 76/100
PedestrianDynamics/pyFDS-Evac#199 ·
維護者通常 1 天內回覆
-
難度 2/5 1-3 小時 新手友好度 65/100
521xueweihan/HelloGitHub#3790 ·
-
難度 2/5 1-3 小時 新手友好度 78/100
sandialabs/atlas-ui-3#978 ·
維護者通常 1 天內回覆
-
area: tests perceived difficulty: 2
難度 2/5 1-3 小時 新手友好度 72/100
Nitjsefnie-Harness-Commons/daedalus#1255 ·
維護者通常 1 天內回覆
-
難度 2/5 1-3 小時 新手友好度 86/100
EleutherAI/lm-evaluation-harness#4256 ·
維護者通常 1 天內回覆