[xwiki-users] Error number 4001 while using blogs
Hello, we've started using XWiki in our company. For evaluation we've used XWiki on Tomcat with a MYSQL DB and everything worked fine. But after we've set up our future environment also on Tomcat but using MS SQL Server as DB we've getting the following error messages in the blog space: Error number 4001 in 4: Error while parsing velocity page Blog.WebHome Wrapped Exception: Failed to evaluate content with id Web Home<http://adewki00.de.festo.net/xwiki/bin/view/Blog/> com.xpn.xwiki.XWikiException: Error number 4001 in 4: Error while parsing velocity page Blog.WebHome ... Doing further examinations we've found that the embedded SQL is causing the exception. In the conditional part there test to inequality (<>) is replaced by entities (<>). The exception is thrown in Xwiki 1.9.3 as also in Xwiki 2.0 and can't be reproduced on local installation so that our assumption is that the issue has something to do with the usage of MS SQL Server. For this case our questions are: 1.) Is there anybody using also MS SQL Server with Xwiki? If yes are there the same exceptions thrown? 2.) Is there a possibility to fix the error by ourselves in modifying the respective template? Where or how do we find the template? Thanks in advance and best regards Lars Festo AG & Co. KG Lars Hermes Abteilung IS-PB Manager BSP Development + User Services Plieninger Straße 50 73760 Ostfildern-Scharnhausen Deutschland Telefon ++49 (0) 711-347-4510 Telefax ++49 (0) 711-34754-4510 http://www.festo.com Der Inhalt dieses E-Mails ist ausschliesslich fuer den bezeichneten Adressaten bestimmt. Jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder Weitergabe des Inhalts dieses E-Mails durch unberechtigte Dritte ist unzulaessig. Wir bitten Sie, sich mit dem Absender des E-Mails in Verbindung zu setzen, falls Sie nicht der Adressat dieses E-Mails sind und das Material von Ihrem Computer zu loeschen. This e-mail and any attachments are confidential and intended solely for the addressee. The perusal, publication, copying or dissemination of the contents of this e-mail by unauthorised third parties is prohibited. If you are not the intended recipient of this e-mail, please delete it and immediately notify the sender. Rechtsform: Kommanditgesellschaft Sitz: Esslingen a.N., Registergericht Stuttgart HRA 211583, Umsatzsteuerident-Nummer: DE 145339206 Persoenlich haftende Gesellschafterin: Festo Management Aktiengesellschaft Sitz: Wien/Oesterreich, Firmenbuchgericht: Handelsgericht Wien, Firmenbuch Nr. FN 303027 d Vorstand: Dr. Ekkehard Gericke Dipl.-Kfm. Alfred Goll Dr. Ansgar Kriwet Dr. Thomas Rubbe Dr. Eberhard Veit (Vorsitzender) Dr. Ulrich Walker Aufsichtsratsvorsitzender: Dr. Wilfried Stoll
Hi Lars, On Mon, Oct 12, 2009 at 12:02 PM, Hermes, Lars <[email protected]> wrote:
Hello,
we've started using XWiki in our company. For evaluation we've used XWiki on Tomcat with a MYSQL DB and everything worked fine. But after we've set up our future environment also on Tomcat but using MS SQL Server as DB we've getting the following error messages in the blog space:
Error number 4001 in 4: Error while parsing velocity page Blog.WebHome
Wrapped Exception: Failed to evaluate content with id Web Home< http://adewki00.de.festo.net/xwiki/bin/view/Blog/>
com.xpn.xwiki.XWikiException: Error number 4001 in 4: Error while parsing velocity page Blog.WebHome ...
Doing further examinations we've found that the embedded SQL is causing the exception. In the conditional part there test to inequality (<>) is replaced by entities (<>). The exception is thrown in Xwiki 1.9.3 as also in Xwiki 2.0 and can't be reproduced on local installation so that our assumption is that the issue has something to do with the usage of MS SQL Server.
For this case our questions are:
1.) Is there anybody using also MS SQL Server with Xwiki? If yes are there the same exceptions thrown?
I'm not aware of that many people using XWiki with MS SQL. If you have a choice, I'd strongly recommend that you go with MySQL since it's the most widely tested production database with XWiki. I'll let others answer whether the issue could be fixed easily or not. Guillaume 2.) Is there a possibility to fix the error by ourselves in modifying the
respective template? Where or how do we find the template?
Thanks in advance and best regards
Lars
Festo AG & Co. KG Lars Hermes Abteilung IS-PB Manager BSP Development + User Services Plieninger Straße 50 73760 Ostfildern-Scharnhausen Deutschland Telefon ++49 (0) 711-347-4510 Telefax ++49 (0) 711-34754-4510 http://www.festo.com
Der Inhalt dieses E-Mails ist ausschliesslich fuer den bezeichneten Adressaten bestimmt. Jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder Weitergabe des Inhalts dieses E-Mails durch unberechtigte Dritte ist unzulaessig. Wir bitten Sie, sich mit dem Absender des E-Mails in Verbindung zu setzen, falls Sie nicht der Adressat dieses E-Mails sind und das Material von Ihrem Computer zu loeschen. This e-mail and any attachments are confidential and intended solely for the addressee. The perusal, publication, copying or dissemination of the contents of this e-mail by unauthorised third parties is prohibited. If you are not the intended recipient of this e-mail, please delete it and immediately notify the sender.
Rechtsform: Kommanditgesellschaft Sitz: Esslingen a.N., Registergericht Stuttgart HRA 211583, Umsatzsteuerident-Nummer: DE 145339206 Persoenlich haftende Gesellschafterin: Festo Management Aktiengesellschaft Sitz: Wien/Oesterreich, Firmenbuchgericht: Handelsgericht Wien, Firmenbuch Nr. FN 303027 d Vorstand: Dr. Ekkehard Gericke Dipl.-Kfm. Alfred Goll Dr. Ansgar Kriwet Dr. Thomas Rubbe Dr. Eberhard Veit (Vorsitzender) Dr. Ulrich Walker Aufsichtsratsvorsitzender: Dr. Wilfried Stoll _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Guillaume Lerouge Product Manager - XWiki SAS Skype: wikibc Twitter: glerouge http://guillaumelerouge.com/
Hi Guillaume, thanks for your answer, but unfortunately using another DB than MS SQL Server is no option as for some reasons (centralized administration, backup strategy and maybe others?!). Personally I've also decided to use Mysql but no one asked me ;-) Maybe let us be the first power users using XWiki with SQL Server. We are definitely willing to give some input to the community but we initially need some helping hands to get started. Cheers, Lars
Hi Lars,
On Mon, Oct 12, 2009 at 12:02 PM, Hermes, Lars <[email protected]> wrote:
Hello,
we've started using XWiki in our company. For evaluation we've used XWiki on Tomcat with a MYSQL DB and everything worked fine. But after we've set up our future environment also on Tomcat but using MS SQL Server as DB we've getting the following error messages in the blog space:
Error number 4001 in 4: Error while parsing velocity page Blog.WebHome
Wrapped Exception: Failed to evaluate content with id Web Home< http://adewki00.de.festo.net/xwiki/bin/view/Blog/>
com.xpn.xwiki.XWikiException: Error number 4001 in 4: Error while parsing velocity page Blog.WebHome ...
Doing further examinations we've found that the embedded SQL is causing the exception. In the conditional part there test to inequality (<>) is replaced by entities (<>). The exception is thrown in Xwiki 1.9.3 as also in Xwiki 2.0 and can't be reproduced on local installation so that our assumption is that the issue has something to do with the usage of MS SQL Server.
For this case our questions are:
1.) Is there anybody using also MS SQL Server with Xwiki? If yes are there the same exceptions thrown?
I'm not aware of that many people using XWiki with MS SQL. If you have a choice, I'd strongly recommend that you go with MySQL since it's the most widely tested production database with XWiki.
I'll let others answer whether the issue could be fixed easily or not.
Guillaume
2.) Is there a possibility to fix the error by ourselves in modifying the
respective template? Where or how do we find the template?
Thanks in advance and best regards
Lars
Disclaimer removed Festo AG & Co. KG Lars Hermes Abteilung IS-PB Manager BSP Development + User Services Plieninger Straße 50 73760 Ostfildern-Scharnhausen Deutschland Telefon ++49 (0) 711-347-4510 Telefax ++49 (0) 711-34754-4510 http://www.festo.com Der Inhalt dieses E-Mails ist ausschliesslich fuer den bezeichneten Adressaten bestimmt. Jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder Weitergabe des Inhalts dieses E-Mails durch unberechtigte Dritte ist unzulaessig. Wir bitten Sie, sich mit dem Absender des E-Mails in Verbindung zu setzen, falls Sie nicht der Adressat dieses E-Mails sind und das Material von Ihrem Computer zu loeschen. This e-mail and any attachments are confidential and intended solely for the addressee. The perusal, publication, copying or dissemination of the contents of this e-mail by unauthorised third parties is prohibited. If you are not the intended recipient of this e-mail, please delete it and immediately notify the sender. Rechtsform: Kommanditgesellschaft Sitz: Esslingen a.N., Registergericht Stuttgart HRA 211583, Umsatzsteuerident-Nummer: DE 145339206 Persoenlich haftende Gesellschafterin: Festo Management Aktiengesellschaft Sitz: Wien/Oesterreich, Firmenbuchgericht: Handelsgericht Wien, Firmenbuch Nr. FN 303027 d Vorstand: Dr. Ekkehard Gericke Dipl.-Kfm. Alfred Goll Dr. Ansgar Kriwet Dr. Thomas Rubbe Dr. Eberhard Veit (Vorsitzender) Dr. Ulrich Walker Aufsichtsratsvorsitzender: Dr. Wilfried Stoll
Hi! I have already posted this question a long time ago. We have the same problem with mssql 2005 and Xwiki. Until today we did not find any solution, but perhaps this time someone can tell us what´s the problem and how can it be fixed. Greetings, Florian ________________________________________ Von: [email protected] [[email protected]]" im Auftrag von "Hermes, Lars [[email protected]] Gesendet: Montag, 12. Oktober 2009 12:02 An: '[email protected]' Betreff: [xwiki-users] Error number 4001 while using blogs Hello, we've started using XWiki in our company. For evaluation we've used XWiki on Tomcat with a MYSQL DB and everything worked fine. But after we've set up our future environment also on Tomcat but using MS SQL Server as DB we've getting the following error messages in the blog space: Error number 4001 in 4: Error while parsing velocity page Blog.WebHome Wrapped Exception: Failed to evaluate content with id Web Home<http://adewki00.de.festo.net/xwiki/bin/view/Blog/> com.xpn.xwiki.XWikiException: Error number 4001 in 4: Error while parsing velocity page Blog.WebHome ... Doing further examinations we've found that the embedded SQL is causing the exception. In the conditional part there test to inequality (<>) is replaced by entities (<>). The exception is thrown in Xwiki 1.9.3 as also in Xwiki 2.0 and can't be reproduced on local installation so that our assumption is that the issue has something to do with the usage of MS SQL Server. For this case our questions are: 1.) Is there anybody using also MS SQL Server with Xwiki? If yes are there the same exceptions thrown? 2.) Is there a possibility to fix the error by ourselves in modifying the respective template? Where or how do we find the template? Thanks in advance and best regards Lars Festo AG & Co. KG Lars Hermes Abteilung IS-PB Manager BSP Development + User Services Plieninger Straße 50 73760 Ostfildern-Scharnhausen Deutschland Telefon ++49 (0) 711-347-4510 Telefax ++49 (0) 711-34754-4510 http://www.festo.com Der Inhalt dieses E-Mails ist ausschliesslich fuer den bezeichneten Adressaten bestimmt. Jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder Weitergabe des Inhalts dieses E-Mails durch unberechtigte Dritte ist unzulaessig. Wir bitten Sie, sich mit dem Absender des E-Mails in Verbindung zu setzen, falls Sie nicht der Adressat dieses E-Mails sind und das Material von Ihrem Computer zu loeschen. This e-mail and any attachments are confidential and intended solely for the addressee. The perusal, publication, copying or dissemination of the contents of this e-mail by unauthorised third parties is prohibited. If you are not the intended recipient of this e-mail, please delete it and immediately notify the sender. Rechtsform: Kommanditgesellschaft Sitz: Esslingen a.N., Registergericht Stuttgart HRA 211583, Umsatzsteuerident-Nummer: DE 145339206 Persoenlich haftende Gesellschafterin: Festo Management Aktiengesellschaft Sitz: Wien/Oesterreich, Firmenbuchgericht: Handelsgericht Wien, Firmenbuch Nr. FN 303027 d Vorstand: Dr. Ekkehard Gericke Dipl.-Kfm. Alfred Goll Dr. Ansgar Kriwet Dr. Thomas Rubbe Dr. Eberhard Veit (Vorsitzender) Dr. Ulrich Walker Aufsichtsratsvorsitzender: Dr. Wilfried Stoll _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hi Lars, On Mon, Oct 12, 2009 at 3:19 PM, Hermes, Lars <[email protected]> wrote:
Hi Guillaume,
thanks for your answer, but unfortunately using another DB than MS SQL Server is no option as for some reasons (centralized administration, backup strategy and maybe others?!). Personally I've also decided to use Mysql but no one asked me ;-)
:-)
Maybe let us be the first power users using XWiki with SQL Server. We are definitely willing to give some input to the community but we initially need some helping hands to get started.
Great. Cheers, Lars
Hi Lars,
On Mon, Oct 12, 2009 at 12:02 PM, Hermes, Lars <[email protected]> wrote:
Hello,
we've started using XWiki in our company. For evaluation we've used XWiki on Tomcat with a MYSQL DB and everything worked fine. But after we've set up our future environment also on Tomcat but using MS SQL Server as DB we've getting the following error messages in the blog space:
Error number 4001 in 4: Error while parsing velocity page Blog.WebHome
Wrapped Exception: Failed to evaluate content with id Web Home< http://adewki00.de.festo.net/xwiki/bin/view/Blog/>
com.xpn.xwiki.XWikiException: Error number 4001 in 4: Error while parsing velocity page Blog.WebHome ...
Doing further examinations we've found that the embedded SQL is causing the exception. In the conditional part there test to inequality (<>) is replaced by entities (<>). The exception is thrown in Xwiki 1.9.3 as also in Xwiki 2.0 and can't be reproduced on local installation so that our assumption is that the issue has something to do with the usage of MS SQL Server.
For this case our questions are:
1.) Is there anybody using also MS SQL Server with Xwiki? If yes are there the same exceptions thrown?
I'm not aware of that many people using XWiki with MS SQL. If you have a choice, I'd strongly recommend that you go with MySQL since it's the most widely tested production database with XWiki.
I'll let others answer whether the issue could be fixed easily or not.
Guillaume
2.) Is there a possibility to fix the error by ourselves in modifying the
respective template? Where or how do we find the template?
The blog's code is located on the following page: http://localhost:8080/xwiki/bin/edit/Blog/BlogCode?editor=wiki You can look at the queries located on this page and try escaping them in various ways... Hope this helps, Guillaume
Thanks in advance and best regards
Lars
Disclaimer removed
Festo AG & Co. KG Lars Hermes Abteilung IS-PB Manager BSP Development + User Services Plieninger Straße 50 73760 Ostfildern-Scharnhausen Deutschland Telefon ++49 (0) 711-347-4510 Telefax ++49 (0) 711-34754-4510 http://www.festo.com
Der Inhalt dieses E-Mails ist ausschliesslich fuer den bezeichneten Adressaten bestimmt. Jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder Weitergabe des Inhalts dieses E-Mails durch unberechtigte Dritte ist unzulaessig. Wir bitten Sie, sich mit dem Absender des E-Mails in Verbindung zu setzen, falls Sie nicht der Adressat dieses E-Mails sind und das Material von Ihrem Computer zu loeschen. This e-mail and any attachments are confidential and intended solely for the addressee. The perusal, publication, copying or dissemination of the contents of this e-mail by unauthorised third parties is prohibited. If you are not the intended recipient of this e-mail, please delete it and immediately notify the sender.
Rechtsform: Kommanditgesellschaft Sitz: Esslingen a.N., Registergericht Stuttgart HRA 211583, Umsatzsteuerident-Nummer: DE 145339206 Persoenlich haftende Gesellschafterin: Festo Management Aktiengesellschaft Sitz: Wien/Oesterreich, Firmenbuchgericht: Handelsgericht Wien, Firmenbuch Nr. FN 303027 d Vorstand: Dr. Ekkehard Gericke Dipl.-Kfm. Alfred Goll Dr. Ansgar Kriwet Dr. Thomas Rubbe Dr. Eberhard Veit (Vorsitzender) Dr. Ulrich Walker Aufsichtsratsvorsitzender: Dr. Wilfried Stoll _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Guillaume Lerouge Product Manager - XWiki SAS Skype: wikibc Twitter: glerouge http://guillaumelerouge.com/
participants (3)
-
Florian Rhomberg -
Guillaume Lerouge -
Hermes, Lars