Repository navigation
Update datasource script corrupted hyper file with SQLSTATE:08001 error #1295
Description
Bug description
I've used https://github.com/tableau/server-client-python/blob/master/samples/update_datasource_data.py script to delete some rows from a hyper file. I was testing condition arguments and deleting 1k-10k rows worked fine. Then I tried to delete random 20k rows from this hyper and it failed, connection was closed by the server with the following message:
INFO:tableau.endpoint.jobs:Job eb23d972-5a9a-41ef-be67-2a38c1136e0a Completed: Finish Code: 1 - Notes:['com.tableausoftware.nativeapi.exceptions.ConnectivityException: [SQLSTATE:08006] The Hyper server closed the connection unexpectedly: pqsecure_raw_read\r\nThe server process may have been shut down or terminated before or while processing the request.\nUnable to connect to the Tableau Data Extract server "". Check that the server is running and that you have access privileges to the requested database.']
INFO:tableau.endpoint.auth:Signed out
Traceback (most recent call last):
File "E:\dev\server-client-python\samples\update_datasource_data.py", line 107, in <module>
main()
File "E:\dev\server-client-python\samples\update_datasource_data.py", line 82, in main
job = server.jobs.wait_for_job(job)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\***\Python\Python311\site-packages\tableauserverclient\server\endpoint\jobs_endpoint.py", line 72, in wait_for_job
raise JobFailedException(job)
tableauserverclient.server.endpoint.exceptions.JobFailedException: Job eb23d972-5a9a-41ef-be67-2a38c1136e0a failed with notes ['com.tableausoftware.nativeapi.exceptions.ConnectivityException: [SQLSTATE:08006] The Hyper server closed the connection unexpectedly: pqsecure_raw_read\r\nThe server process may have been shut down or terminated before or while processing the request.\nUnable to connect to the Tableau Data Extract server "". Check that the server is running and that you have access privileges to the requested database.']
After this, the hyper file becomes unusable - cannot trigger incremental or full refresh - each job finishes with the following message:
An internal error occurred. Contact your administrator. com.tableausoftware.server.status.reporting.TableauRuntimeException: System error: TableauException: [SQLSTATE:08001] Could not connect to the Hyper server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 8711? An internal error occurred. Contact your administrator.
Versions
- Tableau Server version: 2022.3.8 (20223.23.0710.1931) 64-bit Windows
- Python version: 3.11.4
- TSC library version: 3.17,
To Reproduce
Try to delete random 20k rows from the hyper file by including 20k "OR" conditions in the args action and passing it to server.datasources.update_hyper_data method of TSC
Results
Hyper file becomes corrupted
Activity
jacalata commentedon Jan 13, 2024
@vogelsgesang have you seen errors like this before?
github-actions commentedon Aug 1, 2026
This issue has been automatically marked as stale because it has not had recent activity. It will be closed in 14 days if no further activity occurs. If this is still relevant, please comment to keep it open.
github-actions commentedon Aug 16, 2026
Closing due to inactivity. If this is still relevant, please reopen or file a new issue.