Open jtsai01-bsc opened 1 year ago
jorwoods
commented
1 year ago According to the REST API Reference, the error of 400130 is "The view ID in the URI doesn't correspond to a view available on the specified site."
Are you sure you passed in the correct ID or that ID exists on that site?
jtsai01-bsc
commented
1 year ago Jorwoods,
Connected
Item found: MAPD Autopay Refund Report
Traceback (most recent call last):
File "D:\Tableau\server-client-python\samples\export.py", line 127, in
400130: Bad Request
There was a problem querying the crosstab for view 'e4b22ed2-1ddd-43ad-b836-423f843ff4dd'.Connected Item found: MAPD Autopay Refund Report saved to \bsc\cq\Care1st\FISERV\AUTOPAYfile://bsc/cq/Care1st/FISERV/AUTOPAY ENROLLMENT OOS\Refund.csv
Regards, JinChong
jtsai01-bsc
commented
1 year ago When the export view has no data,
It'd be a crosstab query fix to avoid checking if there is no data and simply output to an Excel file with size zero.
jacalata
commented
1 year ago Thanks for reporting this - it looks like it will need to be a server-side fix to avoid sending back the Bad Request error, so it won't be immediate but we'll get it fixed.
wlodi83
commented
1 year ago This is not always the case unfortunately. I have found out, that this error occurs also if CSV export returns data, but crosstab does not work at all.
When the export view has no data,
- the CSV output file is generated and it has size zero.
- the Excel (xlsx) output file is not generated due to this There was a problem querying the crosstab for view 'e4b22ed2-1ddd-43ad-b836-423f843ff4dd' error.
It'd be a crosstab query fix to avoid checking if there is no data and simply output to an Excel file with size zero.
sarikatla-rga
commented
1 month ago This is not always the case unfortunately. I have found out, that this error occurs also if CSV export returns data, but crosstab does not work at all.
When the export view has no data,
- the CSV output file is generated and it has size zero.
- the Excel (xlsx) output file is not generated due to this There was a problem querying the crosstab for view 'e4b22ed2-1ddd-43ad-b836-423f843ff4dd' error.
It'd be a crosstab query fix to avoid checking if there is no data and simply output to an Excel file with size zero.
What is the solution for this issue? We now have the same error.
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:
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:
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.