12 Oct
2009
12 Oct
'09
12:02 p.m.
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
12 Oct
12 Oct
12:44 p.m.
Hi Lars,
On Mon, Oct 12, 2009 at 12:02 PM, Hermes, Lars <LAHR(a)de.festo.com> 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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Guillaume Lerouge
Product Manager - XWiki SAS
Skype: wikibc
Twitter: glerouge
http://guillaumelerouge.com/
3:19 p.m.
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 <LAHR(a)de.festo.com>
wrote:
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
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
>
3:34 p.m.
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: users-bounces(a)xwiki.org [users-bounces(a)xwiki.org]&quot; im Auftrag von
"Hermes, Lars [LAHR(a)DE.FESTO.COM]
Gesendet: Montag, 12. Oktober 2009 12:02
An: 'users(a)xwiki.org'
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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
3:43 p.m.
Hi Lars,
On Mon, Oct 12, 2009 at 3:19 PM, Hermes, Lars <LAHR(a)de.festo.com> wrote:
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
--
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.
Great.
Cheers, Lars
Hi Lars,
On Mon, Oct 12, 2009 at 12:02 PM, Hermes, Lars <LAHR(a)de.festo.com>
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
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
5816
days inactive
5816
days old
4 comments
3 participants
participants (3)
-
Florian Rhomberg -
Guillaume Lerouge -
Hermes, Lars