<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=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><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:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
h3
{mso-style-priority:9;
mso-style-link:"Überschrift 3 Zchn";
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:13.5pt;
font-family:"Calibri",sans-serif;
font-weight:bold;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.berschrift3Zchn
{mso-style-name:"Überschrift 3 Zchn";
mso-style-priority:9;
mso-style-link:"Überschrift 3";
font-family:"Calibri Light",sans-serif;
color:#1F3763;
mso-fareast-language:DE;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
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="DE" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Hi Antoine,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">did you check, if there is enough disc space on the server?
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">I would check that, if you did not already.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">When the export does not work, I would always check that.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Best regards<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Kai<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Von:</b> opencms-dev-bounces@opencms.org <opencms-dev-bounces@opencms.org>
<b>Im Auftrag von </b>Antoine Pineau<br>
<b>Gesendet:</b> Dienstag, 21. April 2020 23:43<br>
<b>An:</b> opencms-dev@opencms.org<br>
<b>Betreff:</b> [opencms-dev] Issue with SQL Server on Windows<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif">Hello,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif">Tricky one this time, it's on a Live server.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif">We have for a customer an old Windows Server 2008 R2 in which we have a Microsoft SQL Server 2008 database.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif">This server was built years ago and was working not that bad, but I have currently an issue that seems very new and odd, which I don't get.<o:p></o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif">By the way, I tried to restart everything, the database, Tomcat, the server... this does not change anything.<o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif">=> My issue is that the files are not exported on the File System anymore ; I get the following error:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Courier New"">21 avr. 2020 16:50:33,755 ERROR [rg.opencms.main.CmsThreadStore: 248] Failed to write locks to database.
<br>
org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query:
<a href="mailto:net.sourceforge.jtds.jdbc.JtdsPreparedStatement@71882d8d">net.sourceforge.jtds.jdbc.JtdsPreparedStatement@71882d8d</a>.
<br>
at org.opencms.db.generic.CmsProjectDriver.writeUserPublishListEntries(CmsProjectDriver.java:2875)<br>
at org.opencms.db.CmsDriverManager.updateLog(CmsDriverManager.java:9198)<br>
at org.opencms.db.CmsSecurityManager.updateLog(CmsSecurityManager.java:6260)<br>
at org.opencms.main.CmsThreadStore.persistData(CmsThreadStore.java:245)<br>
at org.opencms.main.CmsThreadStore.run(CmsThreadStore.java:151)<br>
Caused by: java.sql.BatchUpdateException: <span style="color:white;background:red">
Invalid column name : 'user_id'.</span><br>
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)<br>
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)<br>
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)<br>
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)<br>
at org.opencms.db.generic.CmsProjectDriver.writeUserPublishListEntries(CmsProjectDriver.java:2873)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif">Indeed, I am using the JDBC Driver </span><span style="font-family:"Courier New"">net.sourceforge.jtds.jdbc.Driver</span><span style="font-family:"Verdana",sans-serif"> and I think
</span><span style="font-family:"Courier New"">user_id</span><span style="font-family:"Verdana",sans-serif"> is a reserved word in MSSQL Server </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif">Also I am using all the </span><span style="font-family:"Courier New"">org.opencms.db.mssql</span><span style="font-family:"Verdana",sans-serif"> classes for VfsDriver, ProjectDriver, SqlManager
etc... that should handle such specificity for OpenCms ?</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif">But then, why it seems to work for all those years and is there a way to fix this urgently (the need to deploy a news about covid-19 that cannot be achieved because of this...) ?</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif">Thank you community, for the time you would use to read this request and help me :)</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana",sans-serif">Kind regards<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="22%" style="width:22.0%;padding:0cm 0cm 0cm 0cm">
<div>
<p class="MsoNormal"><img border="0" width="90%" id="_x0000_i1034" src="https://email-cdn.eurelis.com/profils/api.png"><o:p></o:p></p>
</div>
</td>
<td style="padding:0cm 0cm 0cm 0cm">
<h3 style="margin:3.75pt"><span style="font-size:15.5pt;color:#00405E">Antoine Pineau<o:p></o:p></span></h3>
<p style="margin:3.75pt"><span style="font-size:12.0pt;color:#00405E">CTO<o:p></o:p></span></p>
<p style="margin:3.75pt"><span style="font-size:12.0pt;color:#00405E">Eurelis<o:p></o:p></span></p>
</td>
<td width="1%" style="width:1.0%;padding:0cm 0cm 0cm 0cm"></td>
<td width="1" style="width:.75pt;border:none;border-left:solid #CC057B 1.0pt;padding:0cm 0cm 0cm 0cm">
</td>
<td width="2%" style="width:2.0%;padding:0cm 0cm 0cm 0cm"></td>
<td style="padding:0cm 0cm 0cm 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr style="height:18.75pt">
<td width="30" style="width:22.5pt;padding:0cm 0cm 0cm 0cm;height:18.75pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td valign="bottom" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><img border="0" width="15" height="15" style="width:.1562in;height:.1562in" id="_x0000_i1033" src="https://email-cdn.eurelis.com/pictos/phone.png"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<td style="padding:0cm 0cm 0cm 0cm;height:18.75pt">
<p class="MsoNormal"><span style="font-size:10.0pt"><a href="tel:+33149972022" target="_blank"><span style="color:#00405E;text-decoration:none">+33(0)1 4997 2022</span></a>
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:18.75pt">
<td width="30" style="width:22.5pt;padding:0cm 0cm 0cm 0cm;height:18.75pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td valign="bottom" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><img border="0" width="15" height="15" style="width:.1562in;height:.1562in" id="_x0000_i1032" src="https://email-cdn.eurelis.com/pictos/mail.png"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<td style="padding:0cm 0cm 0cm 0cm;height:18.75pt">
<p class="MsoNormal"><span style="font-size:10.0pt"><a href="mailto:a.pineau@eurelis.com" target="_blank"><span style="color:#00405E;text-decoration:none">a.pineau@eurelis.com</span></a>
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:18.75pt">
<td width="30" style="width:22.5pt;padding:0cm 0cm 0cm 0cm;height:18.75pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td valign="bottom" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><img border="0" width="15" height="15" style="width:.1562in;height:.1562in" id="_x0000_i1031" src="https://email-cdn.eurelis.com/pictos/url.png"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<td style="padding:0cm 0cm 0cm 0cm;height:18.75pt">
<p class="MsoNormal"><span style="font-size:10.0pt"><a href="https://www.eurelis.com/" target="_blank"><span style="color:#00405E;text-decoration:none">https://www.eurelis.com</span></a>
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:18.75pt">
<td width="30" style="width:22.5pt;padding:0cm 0cm 0cm 0cm;height:18.75pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td valign="bottom" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><img border="0" width="15" height="15" style="width:.1562in;height:.1562in" id="_x0000_i1030" src="https://email-cdn.eurelis.com/pictos/location.png"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<td style="padding:0cm 0cm 0cm 0cm;height:18.75pt">
<p class="MsoNormal"><span style="font-size:10.0pt"><a href="https://www.google.com/maps/place/24+Rue+Kerv%C3%A9gan,+44000+Nantes/@47.2127119,-1.5584183,17z/data=!3m1!4b1!4m5!3m4!1s0x4805eea897ad3fbb:0xadb32e71e983a75c!8m2!3d47.2127083!4d-1.5562296" target="_blank"><span style="color:#00405E;text-decoration:none">24
rue Kervégan, 44000 Nantes</span></a> <br>
<a href="https://www.google.com/maps/place/Eurelis/@48.8954005,2.2435295,17z/data=!3m1!4b1!4m5!3m4!1s0x47e665063aed13ff:0xe8f9697a486f03c7!8m2!3d48.895397!4d2.2457182" target="_blank"><span style="color:#00405E;text-decoration:none">14 rue du Sergent Bobillot,
92400 Courbevoie</span></a> <o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="background:white;vertical-align:middle"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif;color:#00405E;display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:18.0pt">
<td style="padding:0cm 0cm 0cm 0cm;height:18.0pt"></td>
</tr>
<tr style="height:.75pt">
<td width="100%" style="width:100.0%;border:none;border-bottom:solid #CC057B 1.0pt;padding:0cm 0cm 0cm 0cm;height:.75pt">
</td>
</tr>
<tr style="height:18.0pt">
<td style="padding:0cm 0cm 0cm 0cm;height:18.0pt"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="background:white;vertical-align:middle"><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif;color:#00405E;display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><img border="0" width="130" height="34" style="width:1.3541in;height:.3541in" id="_x0000_i1029" src="https://email-cdn.eurelis.com/eurelis.png"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<div align="right">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="display:inline-block">
<tbody>
<tr>
<td style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><a href="https://www.facebook.com/Agence.Eurelis" target="_blank"><span style="text-decoration:none"><img border="0" width="24" height="24" style="width:.25in;height:.25in" id="_x0000_i1028" src="https://email-cdn.eurelis.com/socials/facebook.png" alt="facebook"></span></a><o:p></o:p></p>
</td>
<td width="5" style="width:3.75pt;padding:0cm 0cm 0cm 0cm"></td>
<td style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><a href="https://twitter.com/Agence_Eurelis" target="_blank"><span style="text-decoration:none"><img border="0" width="24" height="24" style="width:.25in;height:.25in" id="_x0000_i1027" src="https://email-cdn.eurelis.com/socials/twitter.png" alt="twitter"></span></a><o:p></o:p></p>
</td>
<td width="5" style="width:3.75pt;padding:0cm 0cm 0cm 0cm"></td>
<td style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><a href="https://www.linkedin.com/company/eurelis" target="_blank"><span style="text-decoration:none"><img border="0" width="24" height="24" style="width:.25in;height:.25in" id="_x0000_i1026" src="https://email-cdn.eurelis.com/socials/linkedin.png" alt="linkedin"></span></a><o:p></o:p></p>
</td>
<td width="5" style="width:3.75pt;padding:0cm 0cm 0cm 0cm"></td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2">
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="1" cellpadding="0" style="border:none;border-top:solid #D3D4DE 1.0pt">
<tbody>
<tr>
<td width="55" style="width:41.25pt;border:none;padding:13.5pt .75pt .75pt .75pt">
<p class="MsoNormal"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><span style="text-decoration:none"><img border="0" width="46" height="29" style="width:.4791in;height:.302in" id="_x0000_i1025" src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif"></span></a><o:p></o:p></p>
</td>
<td width="470" style="width:352.5pt;border:none;padding:12.75pt .75pt .75pt .75pt">
<p class="MsoNormal" style="line-height:13.5pt"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#41424E">Garanti sans virus.
<a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank">
<span style="color:#4453EA">www.avast.com</span></a> <o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>