[opencms-dev] Issue with SQL Server on Windows

[Schliemann, Kai]

Hi Antoine,

did you check, if there is enough disc space on the server?
I would check that, if you did not already.
When the export does not work, I would always check that.

Best regards
Kai

Von: opencms-dev-bounces at opencms.org <opencms-dev-bounces at opencms.org> Im Auftrag von Antoine Pineau
Gesendet: Dienstag, 21. April 2020 23:43
An: opencms-dev at opencms.org
Betreff: [opencms-dev] Issue with SQL Server on Windows

Hello,

Tricky one this time, it's on a Live server.

We have for a customer an old Windows Server 2008 R2 in which we have a Microsoft SQL Server 2008 database.

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.

By the way, I tried to restart everything, the database, Tomcat, the server... this does not change anything.

=> My issue is that the files are not exported on the File System anymore ; I get the following error:

21 avr. 2020 16:50:33,755 ERROR [rg.opencms.main.CmsThreadStore: 248] Failed to write locks to database.
org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: net.sourceforge.jtds.jdbc.JtdsPreparedStatement at 71882d8d<mailto:net.sourceforge.jtds.jdbc.JtdsPreparedStatement at 71882d8d>.
at org.opencms.db.generic.CmsProjectDriver.writeUserPublishListEntries(CmsProjectDriver.java:2875)
at org.opencms.db.CmsDriverManager.updateLog(CmsDriverManager.java:9198)
at org.opencms.db.CmsSecurityManager.updateLog(CmsSecurityManager.java:6260)
at org.opencms.main.CmsThreadStore.persistData(CmsThreadStore.java:245)
at org.opencms.main.CmsThreadStore.run(CmsThreadStore.java:151)
Caused by: java.sql.BatchUpdateException: Invalid column name : 'user_id'.
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.opencms.db.generic.CmsProjectDriver.writeUserPublishListEntries(CmsProjectDriver.java:2873)

Indeed, I am using the JDBC Driver net.sourceforge.jtds.jdbc.Driver and I think user_id is a reserved word in MSSQL Server
Also I am using all the org.opencms.db.mssql classes for VfsDriver, ProjectDriver, SqlManager etc... that should handle such specificity for OpenCms ?

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...) ?

Thank you community, for the time you would use to read this request and help me :)

Kind regards

--
[https://email-cdn.eurelis.com/profils/api.png]
Antoine Pineau

CTO

Eurelis
[https://email-cdn.eurelis.com/pictos/phone.png]
+33(0)1 4997 2022<tel:+33149972022>
[https://email-cdn.eurelis.com/pictos/mail.png]
a.pineau at eurelis.com<mailto:a.pineau at eurelis.com>
[https://email-cdn.eurelis.com/pictos/url.png]
https://www.eurelis.com<https://www.eurelis.com/>
[https://email-cdn.eurelis.com/pictos/location.png]
24 rue Kervégan, 44000 Nantes<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>
14 rue du Sergent Bobillot, 92400 Courbevoie<https://www.google.com/maps/place/Eurelis/@48.8954005,2.2435295,17z/data=!3m1!4b1!4m5!3m4!1s0x47e665063aed13ff:0xe8f9697a486f03c7!8m2!3d48.895397!4d2.2457182>


[https://email-cdn.eurelis.com/eurelis.png]
[facebook]<https://www.facebook.com/Agence.Eurelis>
[twitter]<https://twitter.com/Agence_Eurelis>
[linkedin]<https://www.linkedin.com/company/eurelis>

[https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif]<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Garanti sans virus. www.avast.com<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20200422/974bbe45/attachment.htm>