This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 80%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEW%3C/text%3E%3C/svg%3E)
Hi,
We have exact the same problem (location West Europe) as described in
synapse-sql-serverless-error-39waitiocompletion-ca.html
but the solution mentioned there does not work in our case.
Only difference between the erorr messages is we got HRESULT = 0x80070005 instead of the original post 0x8007000C,
We get the following error when running a query to our Synapse SQL Serverless database:
Error handling external file: 'WaitIOCompletion call failed. HRESULT = 0x80070005'. File/External table name: '<redacted: path to file on storage account>'.
This error occurs when executing a select which uses OPENROWSET.
Each time the same WaitIOCompletion error is generated for days now.
The same Synapse Serverless environment which executes the same procedure every day suddenly stopped working.
Friday morning November 12th (CET) was the last time it was ok, since then always a WaitIOCompletion error is raised.
Even the parquet files it processed the days before without problem now generate the same error.
I can open the parquet files from the ADLSv2 without problem using Storage Explorer.
Recreating the database, masterkey and data source does not help.
Any help is welcome :)
Renarkable:
On the WaitIOCompletion error, the column names are always returned as result but no data rows.
So it seems it can reach the file.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 39%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Hi,
we have the same issue in the same region as well. Dropping the database and recreating did not work. The views worked for a moment in between but then stopped working again.
Update:
It seems to be a problem related to the private endpoints.
We did not change anything but if we change de storage account to allow all networks it all works again within 1-2 minutes.
This is even the case with an newly created Synapse Workspace with newly created and approved private endpoints.
We enabled the firewall again because this is not a solution but maybe this info helps with finding a good solution.
We don't use private endpoints but we do use the firewall.
I have noticed that after waiting for some random period time (for example 20 minutes, but it seems to keep changing) I can make some OPENROWSET selects again. However, when calling one particular OPENROWSET it breaks again and nothing works. I don't believe that there should be anything special about this one openrowset. It is in the same datalake and container as the ones that work.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 81%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEW%3C/text%3E%3C/svg%3E)
The fix by Microsoft solved the problem, see comment of RienVanLeeuwen in synapse-sql-serverless-error-39waitiocompletion-ca.html
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 57.00000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
Same issue here, since Friday morning.
See related issue mentioned above, seems Microsoft fixed something and now the problems seems to be gone without any changes needed. Seems to be solved now.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hello @Ernst Wolf : Apologizes for the inconvenience caused and happy to know that you are unblocked now . @Sheed, Wayne : Can you please check and confirm if you are also unblocked ?
Thanks
Himanshu