Tuesday, October 03, 2017

U-SQL Local execution error in Visual Studio

Severity Code Description Project File Line Suppression State
Error E_STORE_USER_FILENOTFOUND: File not found or access denied: C:\Users\...\AppData\Local\USQLDataRoot\SearchLog.tsv.
Description:
Unable to obtain information about this file.
Resolution:
Ensure the file with exact casing exists (paths are case-sensitive) and the account has read permission to the file. USQLApplication1 C:\Users\...\Documents\Visual Studio 2017\Projects\USQLApplication1\USQLApplication1\Script.usql 10


This is caused due to 2 reason
1- Run your visual studio as Administrator can solve it.

2- Download the  SearchLog.tsv or your data file from your Data Lake Store and place in the DataRoot directory.


Hope this helps. 

1 comment:

Unknown said...

I have placed my .tsv file in the root directory by creating a folder and accessing it by providing the path to the folder in relative url in script but that doesn't work.
Is it because of the case that my account doesn't have proper admin rights.
Is there any workaround possible in that case?
Please reply asap.

ASP.NET MVC - Sport Facility Booking system

  The project relies on some external service providers. Thus accessing them via their API requires authentication. An API Key need to be su...