[xwiki-users] Install Task Manager Application 2.4.1, velocity error
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-vel... Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi,
On 16 Jan 2017, at 03:01, novnovice <[email protected]> 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-vel... Sent from the XWiki- Users mailing list archive at Nabble.com.
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-vel... Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi,
On 17 Jan 2017, at 04:55, novnovice <[email protected]> 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#HInstall... 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-vel... Sent from the XWiki- Users mailing list archive at Nabble.com.
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-vel... Sent from the XWiki- Users mailing list archive at Nabble.com.
participants (2)
-
novnovice -
Vincent Massol