Azure SQL Server error message - Query failed: The file exists

Question

Azure SQL Server error message - Query failed: The file exists

Dan Falcone 35

I have a SQL database resource in Azure that I've been using for a few months. Using Azure Data Studio I can log in to my Azure SQL Server database with my user ID using Authentication Type "Azure AD - Universal with MFA Support", see all of the tables, views, etc. However when I attempt to perform a select query I get the following message:

Started executing query at Line 17

(1 row affected)

Query failed: The file exists.

Total execution time: 00:00:17.418

The query did find the correct amount of rows, however it shows the error "Query failed: the file exists" and does not show the results of the query.

There is also another user id that is querying the same database successfully using Azure Data Factory. Is there a problem with my user ID?

Thanks for your help!

Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Amira Bedhiafi 43,046 MVP Volunteer Moderator

The error you are getting is more common with filesystem operations. To confirm if the issue is specific to Azure Data Studio, you can try to execute the query using a different tool such as SQL Server Management Studio (SSMS). This way, you can ascertain if the issue is with Azure Data Studio or the Azure SQL Database.

Azure Data Studio might be logging more detailed error information. Check the logs or the output pane for any additional details regarding the error.

Ensure that your Azure Data Studio is up to date. An outdated version might have bugs that have been resolved in later versions.

Although you can see the tables and views, make sure your user has the correct permissions to perform the SELECT query on the specific table you are querying. Though it's not typical for a permissions issue to result in a "file exists" error, it's worth checking.

As you mentioned another user is querying the database successfully, try using that user's credentials in Azure Data Studio to check if the problem is specific to your user ID.

If Azure Data Studio is trying to write a temporary file somewhere (like for caching purposes) and encountering this error, you might want to inspect any associated storage accounts or configurations in Azure related to your SQL Database setup.

Dan Falcone 35

Thank you Amira. Unfortunately this also fails for me in SSMS, so it seems it is not just Azure Data Studio. Here is the details to the error from SSMS:

===================================

The file exists.
 (mscorlib)

------------------------------
Program Location:

   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.__Error.WinIOError()
   at System.IO.Path.InternalGetTempFileName(Boolean checkHost)
   at Microsoft.SqlServer.Management.XEventUI.TraceToolWindowControl..ctor(IServiceProvider serviceProvider)
   at Microsoft.SqlServer.Management.XEventUI.TraceToolWindowPane..ctor()

For some reason I'm unable to connect to the query editor in the Azure Portal, so I can't test this directly in the cloud.

Dan Falcone 35 Reputation points

2023-09-08T15:04:17.3033333+00:00

OK I believe I found the problem. As you mentioned Amira, this was a file system problem, on my local machine. There were thousands of temporary files generated by Azure Data Studio in my Users/{Username}/AppData/local/temp folder that were never cleared. After deleting many of these files I am able to query the data in Azure Data Studio again. Thank you for your help!
Amira Bedhiafi 43,046 Reputation points MVP Volunteer Moderator

2023-09-09T15:21:11.05+00:00

I am glad to help ! You a re always welcome.

1 additional answer

Dan Falcone 35 Reputation points

2023-09-07T15:41:08.5333333+00:00

Thank you Amira. Unfortunately this also fails for me in SSMS, so it seems it is not just Azure Data Studio. Here is the details to the error from SSMS:

=================================== The file exists. (mscorlib) ------------------------------ Program Location: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.__Error.WinIOError() at System.IO.Path.InternalGetTempFileName(Boolean checkHost) at Microsoft.SqlServer.Management.XEventUI.TraceToolWindowControl..ctor(IServiceProvider serviceProvider) at Microsoft.SqlServer.Management.XEventUI.TraceToolWindowPane..ctor()

For some reason I'm unable to connect to the query editor in the Azure Portal, so I can't test this directly in the cloud.
Dan Falcone 35 Reputation points

2023-09-08T15:04:17.3033333+00:00

OK I believe I found the problem. As you mentioned Amira, this was a file system problem, on my local machine. There were thousands of temporary files generated by Azure Data Studio in my Users/{Username}/AppData/local/temp folder that were never cleared. After deleting many of these files I am able to query the data in Azure Data Studio again. Thank you for your help!
Amira Bedhiafi 43,046 Reputation points MVP Volunteer Moderator

2023-09-09T15:21:11.05+00:00

I am glad to help ! You a re always welcome.

Answer 1

Niclas Vikström 0

Hi! I got this error using Microsoft Management studio 19. Tried to reinstall and installed version 20 (since database is 16).
Did not help. But then, based on this post and luck, i found some files Users/{Username}/AppData/local/temp that started with name ssm.... (had 5 files). After removing them, it worked.

0 comments