[opencms-dev] Issue with SQL Server on Windows

Wed Apr 22 14:32:06 CEST 2020

Hi Antoine,

ok, I assumed, you already did.
Nevertheless, I am not sure if 2,5 GB free disc space on a Windows server is really sufficient. Is this free space on a separate drive (like D:) or on the system partition?
I don’t know MS SQL Server very well, so I can give just some hints. Don’t know if they are helpful.
I wonder, if there is a tool to check the database or the tables (maybe something like this: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver15.

You could also check if some autmatic updates where installed which make your system not working anymore.
If possible, make a dump of your database an import that to a new one and let OpenCms point to the new database.

HTH

Best regards
Kai

Von: opencms-dev-bounces at opencms.org <opencms-dev-bounces at opencms.org> Im Auftrag von Antoine Pineau
Gesendet: Mittwoch, 22. April 2020 11:24
An: The OpenCms mailing list <opencms-dev at opencms.org>
Betreff: Re: [opencms-dev] Issue with SQL Server on Windows

Thank you Kai for your answer,

Yes I check this in a first place also, I forgot to mention it.
We have more than 2,5 GB free so this is OK.

The issue seems more like a bad SQL query from the MS SQL Driver which prevents the export from working correctly (it cannot find the user_id column in the SQL Query).
But this bad syntax should not be there and is apparently due to the external mssql library : does this library should be updated or a configuration can be changed at some place ?
I don't know exactly what to do...

On Wed, Apr 22, 2020 at 9:55 AM Schliemann, Kai <K.Schliemann at comundus.com<mailto:K.Schliemann at comundus.com>> wrote:
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<mailto:opencms-dev-bounces at opencms.org> <opencms-dev-bounces at opencms.org<mailto:opencms-dev-bounces at opencms.org>> Im Auftrag von Antoine Pineau
Gesendet: Dienstag, 21. April 2020 23:43
An: opencms-dev at opencms.org<mailto: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>

_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev

--
[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>

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