<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif">Hello,</div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" style="font-family:verdana,sans-serif">Tricky one this time, it's on a Live server.</div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" 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.</div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" 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.</div><div class="gmail_default" style="font-family:verdana,sans-serif"><div class="gmail_default"><font face="monospace"><br></font></div><div class="gmail_default">By the way, I tried to restart everything, the database, Tomcat, the server... this does not change anything.</div></div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" 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:</div><div class="gmail_default" style=""><font face="monospace"><br></font></div><div class="gmail_default" style=""><font face="monospace">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: net.sourceforge.jtds.jdbc.JtdsPreparedStatement@71882d8d. <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="background-color:rgb(255,0,0)"><font color="#ffffff">Invalid column name : 'user_id'.</font></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)<br></font></div><div class="gmail_default" style="font-family:verdana,sans-serif"><br></div><div class="gmail_default" style=""><span style="font-family:verdana,sans-serif">Indeed, I am using the JDBC Driver </span><font face="monospace">net.sourceforge.jtds.jdbc.Driver</font><span style="font-family:verdana,sans-serif"> and I think </span><font face="monospace">user_id</font><font face="verdana, sans-serif"> is a reserved word in MSSQL Server </font></div><div class="gmail_default" style=""><font face="verdana, sans-serif">Also I am using all the </font><font face="monospace">org.opencms.db.mssql</font><font face="verdana, sans-serif"> classes for VfsDriver, ProjectDriver, SqlManager etc... that should handle such specificity for OpenCms ?</font></div><div class="gmail_default" style=""><font face="verdana, sans-serif"><br></font></div><div class="gmail_default" style=""><font face="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...) ?</font></div><div class="gmail_default" style=""><font face="verdana, sans-serif"><br></font></div><div class="gmail_default" style=""><font face="verdana, sans-serif">Thank you community, for the time you would use to read this request and help me :)</font></div><div><br></div><div><div class="gmail_default" style="font-family:verdana,sans-serif">Kind regards</div><br></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div>
<div dir="ltr" style="vertical-align:middle;background-color:rgb(255,255,255);color:rgb(0,64,94);font-family:"Trebuchet MS";font-size:13px;max-width:666px">
<table cellpadding="0" cellspacing="0" style="width:100%">
<tbody><tr>
<td width="22.5%">
<div>
<img width="90%" src="https://email-cdn.eurelis.com/profils/api.png" style="max-width:150px">
</div>
</td>
<td style="font-size:1.1em;color:rgb(0,64,94)">
<h3 style="margin:5px;font-size:1.3em">Antoine Pineau</h3>
<p style="margin:5px">CTO</p>
<p style="margin:5px">Eurelis</p>
</td>
<td width="1%"></td>
<td width="1" style="border-left:1px solid rgb(204,5,123)"></td>
<td width="2%"></td>
<td>
<table cellpadding="0" cellspacing="0" style="font-size:0.9em">
<tbody><tr height="25">
<td width="30">
<table cellpadding="0" cellspacing="0">
<tbody><tr>
<td style="vertical-align:bottom">
<img width="15" src="https://email-cdn.eurelis.com/pictos/phone.png" style="display:block;background-color:rgb(204,5,123)">
</td>
</tr>
</tbody></table>
</td>
<td style="padding:0px">
<a href="tel:+33149972022" style="color:rgb(0,64,94);text-decoration:none" target="_blank">+33(0)1 4997 2022</a>
</td>
</tr>
<tr height="25">
<td width="30">
<table cellpadding="0" cellspacing="0">
<tbody><tr>
<td style="vertical-align:bottom">
<img width="15" src="https://email-cdn.eurelis.com/pictos/mail.png" style="display:block;background-color:rgb(204,5,123)">
</td>
</tr>
</tbody></table>
</td>
<td style="padding:0px">
<a href="mailto:a.pineau@eurelis.com" style="color:rgb(0,64,94);text-decoration:none" target="_blank">a.pineau@eurelis.com</a>
</td>
</tr>
<tr height="25">
<td width="30">
<table cellpadding="0" cellspacing="0">
<tbody><tr>
<td style="vertical-align:bottom">
<img width="15" src="https://email-cdn.eurelis.com/pictos/url.png" style="display:block;background-color:rgb(204,5,123)">
</td>
</tr>
</tbody></table>
</td>
<td style="padding:0px">
<a href="https://www.eurelis.com/" style="color:rgb(0,64,94);text-decoration:none" target="_blank">https://www.eurelis.com</a>
</td>
</tr>
<tr height="25">
<td width="30">
<table cellpadding="0" cellspacing="0">
<tbody><tr>
<td style="vertical-align:bottom">
<img width="15" src="https://email-cdn.eurelis.com/pictos/location.png" style="display:block;background-color:rgb(204,5,123)">
</td>
</tr>
</tbody></table>
</td>
<td style="padding:0px">
<span>
<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" style="color:rgb(0,64,94);text-decoration:none" target="_blank">24 rue Kervégan, 44000 Nantes</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" style="color:rgb(0,64,94);text-decoration:none" target="_blank">14 rue du Sergent Bobillot, 92400 Courbevoie</a>
</span>
</td>
</tr>
</tbody></table>
</td>
</tr>
</tbody></table>
<table cellpadding="0" cellspacing="0" style="width:100%">
<tbody><tr>
<td height="24"><br>
</td>
</tr>
<tr>
<td height="1" style="width:100%;border-bottom:1px solid rgb(204,5,123);display:block"></td>
</tr>
<tr>
<td height="24">
<br>
</td>
</tr>
</tbody></table>
<table cellpadding="0" cellspacing="0" style="width:100%">
<tbody><tr style="vertical-align:top">
<td>
<img width="130" src="https://email-cdn.eurelis.com/eurelis.png" style="max-width:130px;display:inline-block">
</td>
<td style="text-align:right">
<table cellpadding="0" cellspacing="0" style="vertical-align:middle;display:inline-block">
<tbody><tr>
<td>
<a href="https://www.facebook.com/Agence.Eurelis" target="_blank">
<img height="24" src="https://email-cdn.eurelis.com/socials/facebook.png" alt="facebook" style="max-width:130px;display:block;background-color:rgb(0,64,94)">
</a>
</td>
<td width="5">
<div></div>
</td>
<td>
<a href="https://twitter.com/Agence_Eurelis" target="_blank">
<img height="24" src="https://email-cdn.eurelis.com/socials/twitter.png" alt="twitter" style="max-width:130px;display:block;background-color:rgb(0,64,94)">
</a>
</td>
<td width="5">
<div></div>
</td>
<td>
<a href="https://www.linkedin.com/company/eurelis" target="_blank">
<img height="24" src="https://email-cdn.eurelis.com/socials/linkedin.png" alt="linkedin" style="max-width:130px;display:block;background-color:rgb(0,64,94)">
</a>
</td>
<td width="5">
<div></div>
</td>
</tr>
</tbody></table>
</td>
</tr>
</tbody></table>
</div>
</div></div></div></div></div></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br> <table style="border-top:1px solid #d3d4de">
<tr>
<td style="width:55px;padding-top:18px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
<td style="width:470px;padding-top:17px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">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" style="color:#4453ea">www.avast.com</a> </td>
</tr>
</table>
<a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>