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

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

Active

Type:	Bug
ID:	773904
Opened:	12/9/2012 3:03:30 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

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 (expand)

English

SQL Server 2012 - Express Edition

SQL Engine

Other

US English

1. Create Visio file and save it (to some local place).
2. Use Windows Explorer to copy it to filetable share.
3a. Try to open it by double-click (to open in Visio) - fails

or

3b. Use Visio to browse to Filetable share and open file from it - fails

Fails to open. A Dialog Box with Exclamation, path to file opens, and one button available = "OK"

Visio opens empty, without file.

Visio opens the file contents and shows it on the screen.

X64

File Name	Submitted By	Submitted On	File Size
Visio_Files_Not_Opening_In_SQL_Server_Filestream.PNG	Daniel Kornev	1/17/2013	6 KB

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

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.