Home Dashboard Directory Help
Search

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


Status: 

Closed


1
0
Sign in
to vote
Type: Bug
ID: 773904
Opened: 12/9/2012 3:03:30 PM
Access Restriction: Public
1
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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)

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

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.

Thanks,
Daniel,
CEO,
Zet Universe
http://www.zetuniverse.com/
Posted by Microsoft on 8/1/2013 at 11:24 PM
Daniel,
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,
Arkadi.
Posted by Daniel Kornev on 1/17/2013 at 12:45 PM
That's great, Vijendra,

Looking forward for your reply!

-Daniel
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.

Thanks,
Vijendra.
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?

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

SQL Server
Sign in to post a workaround.
Posted by Daniel Kornev on 1/17/2013 at 4:21 AM
Saving file as VSDX (Office Visio 2013 Drawing) helps to store Visio files in File Tables in SQL Server.
File Name Submitted By Submitted On File Size  
Visio_Files_Not_Opening_In_SQL_Server_Filestream.PNG 1/17/2013 6 KB