Re: [xwiki-users] Install Task Manager Application 2.4.1, velocity error

[novnovice]

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-velocity-error-tp7602410p7602441.html
Sent from the XWiki- Users mailing list archive at Nabble.com.

Re: [xwiki-users] Install Task Manager Application 2.4.1, velocity error

[Vincent Massol]

Hi,

> On 17 Jan 2017, at 04:55, novnovice  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#HInstallandconfigureaRelationalDatabase

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-velocity-error-tp7602410p7602424.html
> Sent from the XWiki- Users mailing list archive at Nabble.com.

Re: [xwiki-users] Install Task Manager Application 2.4.1, velocity error

[novnovice]

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-velocity-error-tp7602410p7602424.html
Sent from the XWiki- Users mailing list archive at Nabble.com.

Re: [xwiki-users] Install Task Manager Application 2.4.1, velocity error

[Vincent Massol]

Hi,

> On 16 Jan 2017, at 03:01, novnovice  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-velocity-error-tp7602410.html
> Sent from the XWiki- Users mailing list archive at Nabble.com.