Re: [xwiki-users] Task Manager Application - CLOB problem on Oracle

[vinc...@massol.net]

Hi,

On 7 Dec 2015 at 13:56:20, Miroslav Galajda 
(miroslav.gala...@gmail.com(mailto:miroslav.gala...@gmail.com)) wrote:

> Hi,
>  
> in the roadmap for 7.4 release I can see, there is Task Manager included.
>  
> Will you consider this issue to be a part of the release? Should I create
> an issue for it?
>  
> Generally, I am repeatedly encountering problems with Oracle compatibility.
> You should improve the quality of DB tests against Oracle databases.

Indeed, we’re lacking automated testing against Oracle (although there are 
members of this community doing manual tests on Oracle at each final release 
AFAIK).

Would you be willing to help out by:
* Performing manual tests on Oracle when we release milestones so that we can 
be sure to have a final version working on Oracle
* Write and work on our automated tests/builds to ensure that all existing 
XWiki tests are executed on Oracle?

Thanks
-Vincent


> Thank you
>  
> Mirec
>  
> On 6 November 2015 at 16:28, Miroslav Galajda  
> wrote:
>  
> > Hi,
> >
> > I'm running xwiki 7.3 Milestion 2 on Oracle.
> > Task Manager Application have problems with it at least with part of it.
> >
> > In TaskManagerPanel there I get "ORA-00932: inconsistent datatypes:
> > expected - got CLOB". See the attached exception report.
> >
> > Also I noticed some warning logs:
> >
> > http://wiki/test-xwiki/get/TaskManager/TaskManagerLiveTableResults?outputSyntax=plain=taskmanager.livetable.=TaskManager.TaskManagerClass=number%2Cname%2Cproject%2Cstatus%2Cseverity%2Creporter%2Cassignee%2Cduedate=currentlanguage%2Chidden=1=15=1=number=asc]
> > WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of getter
> > [com.xpn.xwiki.api.DeprecatedContext.getAction] in
> > 79:xwiki:TaskManager.MyTestTask@2,14
> >
> >
> > Thank you
> >
> > Best regards
> > Miroslav Galajda
> >
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Task Manager Application - CLOB problem on Oracle

[Miroslav Galajda]

Hi,

in the roadmap for 7.4 release I can see, there is Task Manager included.

Will you consider this issue to be a part of the release? Should I create
an issue for it?

Generally, I am repeatedly encountering problems with Oracle compatibility.
You should improve the quality of DB tests against Oracle databases.

Thank you

Mirec

On 6 November 2015 at 16:28, Miroslav Galajda 
wrote:

> Hi,
>
> I'm running xwiki 7.3 Milestion 2 on Oracle.
> Task Manager Application have problems with it at least with part of it.
>
> In TaskManagerPanel there I get "ORA-00932: inconsistent datatypes:
> expected - got CLOB". See the attached exception report.
>
> Also I noticed some warning logs:
>
> http://wiki/test-xwiki/get/TaskManager/TaskManagerLiveTableResults?outputSyntax=plain=taskmanager.livetable.=TaskManager.TaskManagerClass=number%2Cname%2Cproject%2Cstatus%2Cseverity%2Creporter%2Cassignee%2Cduedate=currentlanguage%2Chidden=1=15=1=number=asc]
> WARN  o.x.v.i.DefaultVelocityEngine  - Deprecated usage of getter
> [com.xpn.xwiki.api.DeprecatedContext.getAction] in
> 79:xwiki:TaskManager.MyTestTask@2,14
>
>
> Thank you
>
> Best regards
> Miroslav Galajda
>
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

[xwiki-users] Task Manager Application - CLOB problem on Oracle

[Miroslav Galajda]

Hi,

I'm running xwiki 7.3 Milestion 2 on Oracle.
Task Manager Application have problems with it at least with part of it.

In TaskManagerPanel there I get "ORA-00932: inconsistent datatypes:
expected - got CLOB". See the attached exception report.

Also I noticed some warning logs:
http://wiki/test-xwiki/get/TaskManager/TaskManagerLiveTableResults?outputSyntax=plain=taskmanager.livetable.=TaskManager.TaskManagerClass=number%2Cname%2Cproject%2Cstatus%2Cseverity%2Creporter%2Cassignee%2Cduedate=currentlanguage%2Chidden=1=15=1=number=asc]
WARN  o.x.v.i.DefaultVelocityEngine  - Deprecated usage of getter
[com.xpn.xwiki.api.DeprecatedContext.getAction] in
79:xwiki:TaskManager.MyTestTask@2,14


Thank you

Best regards
Miroslav Galajda
org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate Velocity 
Macro for content [  
#panelheader($services.localization.render('taskmanager.panel.paneltitle'))
  #set($query = "from doc.object(TaskManager.TaskManagerClass) as document 
where doc.fullName <> 'TaskManager.TaskManagerTemplate' and 
document.assignee=:currentUser order by document.duedate asc")
  #set($results = $services.query.xwql("$query").bindValue("currentUser", 
$services.model.serialize($xcontext.userReference,'compactwiki')).setLimit(5).execute())
  #foreach($result in $results)
#set($object = 
$xwiki.getDocument($result).getObject('TaskManager.TaskManagerClass'))
* $services.icon.render('accept') 
**[[$object.getProperty('name').value>>$result]]**
(% class="text-muted small" 
%)$services.localization.render('taskmanager.panel.untildate') 
$datetool.format('HH:mm dd/MMM/',$object.getProperty('duedate').value)
  #end
  #if($results.size() == 0)
(% 
class="pull-left"%)$services.localization.render('taskmanager.panel.noactivetasks')
  #else
(% 
class="pull-right"%)[[$services.localization.render('taskmanager.panel.fulltasklist')>>TaskManager.WebHome]]
  #end
  #panelfooter()]
at 
org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:131)
at 
org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:50)
at 
org.xwiki.rendering.macro.script.AbstractScriptMacro.evaluateBlock(AbstractScriptMacro.java:286)
at 
org.xwiki.rendering.macro.script.AbstractScriptMacro.execute(AbstractScriptMacro.java:182)
at 
org.xwiki.rendering.macro.script.AbstractScriptMacro.execute(AbstractScriptMacro.java:58)
at 
org.xwiki.rendering.internal.transformation.macro.MacroTransformation.transform(MacroTransformation.java:269)
at 
org.xwiki.rendering.internal.transformation.DefaultRenderingContext.transformInContext(DefaultRenderingContext.java:183)
at 
org.xwiki.panels.internal.PanelWikiUIExtension$1.call(PanelWikiUIExtension.java:175)
at 
org.xwiki.panels.internal.PanelWikiUIExtension$1.call(PanelWikiUIExtension.java:169)
at com.xpn.xwiki.internal.template.SUExecutor.call(SUExecutor.java:91)
at 
org.xwiki.panels.internal.PanelWikiUIExtension.execute(PanelWikiUIExtension.java:168)
at sun.reflect.GeneratedMethodAccessor451.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at 
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395)
at 
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384)
at 
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173)
at 
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280)
at 
org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:567)
at 
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:151)
at 
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:280)
at 
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:369)
at 
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at 
org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87)
at 
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at 
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:420)
at 
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:207)
at 
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
at 
org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87)
at 
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:342)
at 
org.xwiki.velocity.internal.DefaultVelocityEngine.evaluateInternal(DefaultVelocityEngine.java:256)
at