Microsoft Visio 2013 fails to open files stored in the local SQL Server FileTable share - by Daniel Kornev

Status : 


Sign in
to vote
ID 773904 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 12/9/2012 3:03:30 PM
Access Restriction Public


I've checked, Visio 2013 works great with remote file shares, with local normal file share (I've checked the file stored in local Documents by accessing it via its UNC path at \\MACHINENAME\Users\MYUSERNAME\Documents\FILENAME.VSD), but fails to open files stored in the local SQL Server FileTable (\\MACHINENAME\SQLSERVERSHARENAME\FILESTREAMNAME\FILETABLENAME\FILENAME.VSD)

Sign in to post a comment.
Posted by Daniel Kornev on 8/1/2013 at 11:30 PM

thanks a lot for the detailed explanations. We've actually moved away from using SQL Server on the client side, and we'll be evaluating opportunity to use on the server side later on.

Zet Universe
Posted by Microsoft on 8/1/2013 at 11:24 PM
Visio uses LockFile API to acquire a byte range lock on the file. This API is not supported by FileTable.
Apparently for .vsdx files Visio creates a local copy of the file under "C:\Users\<user name>\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.MSO" directory so LockFile succeeds in this case.
We are not planning to support LockFile in FileTable for the time being. Please use the new format of Visio files as a workaround.

Thanks you,
Posted by Daniel Kornev on 1/17/2013 at 12:45 PM
That's great, Vijendra,

Looking forward for your reply!

Posted by Microsoft on 1/17/2013 at 12:03 PM
Thanks Daniel for your response. I am able to repro this on my side now. We'll investigate this further and have a fix ready as soon as possible.

Posted by Daniel Kornev on 1/17/2013 at 4:17 AM
Hi Vijendra,

Thanks for reply. I'm using Windows 8 64-bit; this behaviour is consistent across these SKUs: Windows 8 Single Language, Windows 8, Windows 8 Pro, Windows 8 Pro with Media Center Edition.

I'm using SQL Server 2012 Express Edition with Advanced Services 64-bit, version 11.0.2100.60, English.

I'm using Microsoft Office Visio Professional 2013. The file kind that doesn't work is "vsd" (old Visio file), vsdx files work just fine.
Posted by Microsoft on 1/16/2013 at 4:36 PM
Hi Daniel,

Thanks for reporting the issue. However, I am unable to repro this on my side. Can you share more info about your setup? Which OS are you using? Also, can you share the SQL server version that you are using?

Posted by Microsoft on 1/4/2013 at 4:24 PM
Thanks for reporting this issue with FileTable. We will investigate this further and make appropriate fix in an upcoming release.

SQL Server