<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Raleway;
panose-1:2 11 5 3 3 1 1 6 0 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Raleway;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:3.0cm 2.0cm 3.0cm 2.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=DA link="#0563C1" vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'>Hi all,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'>We are experiencing problems keeping a connection to geodata in Azure SQL Server tables alive or reconnecting after some idle time.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'>After having established a connection to a table in Azure SQL Server everything works normally. However after a varying amount of idle time (typically 30-60 minutes), the connection fails, and data can’t be read or written to the table. Closing and reopening the project reestablishes the connection, and everything works normally again, until the next longer idle time.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'>We have tried similar scenarios (lengthy connections to Azure SQL tables) from Azure Data Studio and MS Excel, which have not suffered from the same errors.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'>When monitoring TCP traffic in TCPView, one can see, when the connection closes down (which also happens for Azure Data Studio and Excel), but the latter two reestablishes the connection, when it is needed - QGIS doesn't!<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'>After the connection to Azure SQL Server has failed (ie. when I can't save my edits anymore or identify objects), if I delete or add objects through Azure Data Studio, and then refresh my QGIS canvas these edits are shown, but they can't be edited, selected or identified in QGIS!<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'>The bug has been reproduced on several clients/pcs.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'>Anyone else experiencing this – and hopefully having a solution?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway;mso-fareast-language:DA'>--<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway;mso-fareast-language:DA'>Best regards,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:Raleway;mso-fareast-language:DA'>Morten Storm<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>