16 Jan
2017
16 Jan
'17
3:01 a.m.
I'm not sure if this is the correct venue for reporting an issue with a
"recommended" extension? After installing Task Manager 2.4.1, when I visit
the Task Manager page it shows an empty task list. Fine, but there is also
an error reported.
Failed to execute the [velocity] macro. Cause: [The data types text and
nvarchar are incompatible in the equal to operator.].
The error message ends with these:
Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception
while hibernate execute
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1333)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1394)
at
com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:165)
... 163 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute
query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at
com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor$1.doInHibernate(HqlQueryExecutor.java:174)
at
com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor$1.doInHibernate(HqlQueryExecutor.java:166)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1327)
... 165 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The data types
text and nvarchar are incompatible in the equal to operator.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:440)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:385)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2444)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:297)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 175 more
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Install-Task-Manager-Application-2-4-1-ve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
16 Jan
16 Jan
6:14 p.m.
Hi,
On 16 Jan 2017, at 03:01, novnovice
<novnovice(a)gmail.com> wrote:
I'm not sure if this is the correct venue for reporting an issue with a
"recommended" extension? After installing Task Manager 2.4.1, when I visit
the Task Manager page it shows an empty task list. Fine, but there is also
an error reported.
Failed to execute the [velocity] macro. Cause: [The data types text and
nvarchar are incompatible in the equal to operator.].
The error message ends with these:
[snip]
Caused by:
com.microsoft.sqlserver.jdbc.SQLServerException: The data types
text and nvarchar are incompatible in the equal to operator.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
[snip]
The error seems related to SQLServer. It’s possible that some HQL query done by the Task
Manager app is not working in SQLServer. That would need to be debugged. However note that
the xwiki project doesn’t officially support SQLServer (see
http://dev.xwiki.org/xwiki/bin/view/Community/DatabaseSupportStrategy). It’s also possible
that the sqlserver HBM file needs some update.
Some pull requests fro this would be nice since it’s supported only by contributions and
there’s no SQLServer user in the xwiki committers that I know of.
You should also raise a jira issue for the Task Manager app at
http://jira.xwiki.org/browse/TASKMAN.
Thanks
-Vincent
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Install-Task-Manager-Application-2-4-1-ve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
17 Jan
17 Jan
4:55 a.m.
New subject: [xwiki-users] Install Task Manager Application 2.4.1, velocity error
I had no idea that sql server is not officially supported, bummer. I worked
from http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWAR
which lists sql server in the rdbms section and has a link to the sql server
page. The sql server page does list older versions, but I sure didn't expect
it to be unsupported.
This is frustrating because I could have just as easily used postgresql
instead, or oracle, if I'd realized sql server was second tier to them as
far as xwiki goes.
What does "Some pull requests for this would be nice..." mean? I might post
to taskman jira as you suggest.
I was only installing task manager to have a look at the inner workings of
an application. So I don't need it to work per se. I thought it might be
simpler than the "ideas" application (for example).
I suppose it is difficult to migrate xwiki from sql server to postgres?
Probably easier to reinstall from scratch (I don't have a lot of content
that needs to be preserved).
Thanks for your input.
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Install-Task-Manager-Application-2-4-1-ve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
8:51 a.m.
Hi,
On 17 Jan 2017, at 04:55, novnovice
<novnovice(a)gmail.com> wrote:
I had no idea that sql server is not officially supported, bummer. I worked
from http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWAR
which lists sql server in the rdbms section and has a link to the sql server
page. The sql server page does list older versions, but I sure didn't expect
it to be unsupported.
You’re right, the info was missing. I’ve now added it to
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWAR#HInstal…
Thanks for reporting this, you’ll help future users I’m sure :)
This is frustrating because I could have just as
easily used postgresql
instead, or oracle, if I'd realized sql server was second tier to them as
far as xwiki goes.
What does "Some pull requests for this would be nice..." mean?
It means that the DB that are not supported by the xwiki devs are supported by the
community and the XWiki devs just apply patches and pull requests.
I might post
to taskman jira as you suggest.
I was only installing task manager to have a look at the inner workings of
an application. So I don't need it to work per se. I thought it might be
simpler than the "ideas" application (for example).
I suppose it is difficult to migrate xwiki from sql server to postgres?
I don’t know but maybe it’s not that hard. You’d need to do a SQL92 export from sqlserver
and try to import it in Postgres for ex.
Probably easier to reinstall from scratch (I don't
have a lot of content
that needs to be preserved).
In that case you can do a XAR export of your pages and reimport them in a clean instance
indeed.
Thanks
-Vincent
Thanks for your input.
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Install-Task-Manager-Application-2-4-1-ve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
5:42 p.m.
New subject: [xwiki-users] Install Task Manager Application 2.4.1, velocity error
Well, thank you Vincent. You've been instrumental in my very positive xwiki
experience. xwiki is amazing and the support from you folks has been very
good. I'll try another application and see if it has issues like task
manager.
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Install-Task-Manager-Application-2-4-1-ve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
2896
days inactive
2897
days old
4 comments
2 participants
participants (2)
-
novnovice -
Vincent Massol