Posts

Showing posts from 2017

U-SQL Local execution error in Visual Studio

Image
SeverityCodeDescriptionProjectFileLineSuppression State
ErrorE_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.USQLApplication1C:\Users\...\Documents\Visual Studio 2017\Projects\USQLApplication1\USQLApplication1\Script.usql10

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. 

Microsoft.EntityFrameworkCore.Database.Connection[200004]

Image
 Microsoft.EntityFrameworkCore.Database.Connection[200004]
      An error occurred using the connection to database 'DBAPIContext-4266f07e-a498-4ab6-9c86-792af5b78354' on server '(localdb)\mssqllocaldb'.
System.Data.SqlClient.SqlException (0x80131904): Cannot open database "DBAPIContext-4266f07e-a498-4ab6-9c86-792af5b78354" requested by the login. The login failed.
Login failed for user 'user.ID'.


---------------------------
Microsoft Visual Studio
---------------------------
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. 
Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. 
Specified LocalDB instance name is invalid.

)
---------------------------
OK   

---------------------------



Solution: 

The following 2 steps solved issue for …

nuget configuration is invalid.

---------------------------
Microsoft Visual Studio
---------------------------
"Project" nuget configuration is invalid.

---------------------------
OK  
---------------------------

When you try to add the reference, via Manage Nuget Packages. You may get this above error message.

The solution is simple. Close the Visual Studio and open it again. This works most of the time.