Add tag of document in mongodb not working

Hi,

I am using nuxeo-9.1 with postgress and mongodb. While adding tag to document I am getting following error:

org.nuxeo.ecm.core.query.QueryParseException: Failed to execute query: NXQL: SELECT DISTINCT tag:label FROM Tag WHERE tag:label LIKE 't%' AND ecm:isProxy = 0, SELECT DISTINCT not supported on DBS
at org.nuxeo.ecm.core.storage.dbs.DBSSession.doQueryAndFetch(DBSSession.java:1473)
at org.nuxeo.ecm.core.storage.dbs.DBSSession.queryAndFetch(DBSSession.java:1668)
at sun.reflect.GeneratedMethodAccessor127.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.nuxeo.ecm.core.storage.dbs.DBSRepositoryBase$DBSSessionInvoker.invoke(DBSRepositoryBase.java:487)
at com.sun.proxy.$Proxy64.queryAndFetch(Unknown Source)
at org.nuxeo.ecm.core.api.AbstractSession.queryAndFetch(AbstractSession.java:1248)
at org.nuxeo.ecm.core.api.AbstractSession.queryAndFetch(AbstractSession.java:1223)
at org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchUnrestrictedSessionRunner.run(CoreQueryAndFetchUnrestrictedSessionRunner.java:46)
at org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestricted(UnrestrictedSessionRunner.java:117)
at org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider.getCurrentPage(CoreQueryAndFetchPageProvider.java:134)
at org.nuxeo.ecm.platform.tag.TagServiceImpl.getItems(TagServiceImpl.java:684)
at org.nuxeo.ecm.platform.tag.TagServiceImpl$UnrestrictedGetTagSuggestions.run(TagServiceImpl.java:641)
at org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestricted(UnrestrictedSessionRunner.java:117)
at org.nuxeo.ecm.platform.tag.TagServiceImpl.getSuggestions(TagServiceImpl.java:614)
at org.nuxeo.ecm.platform.tag.automation.SuggestTagEntry.run(SuggestTagEntry.java:91)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.nuxeo.ecm.automation.core.impl.InvokableMethod.doInvoke(InvokableMethod.java:164)
at org.nuxeo.ecm.automation.core.impl.InvokableMethod.invoke(InvokableMethod.java:176)
at org.nuxeo.ecm.automation.core.impl.OperationChainCompiler$OperationMethod.invoke(OperationChainCompiler.java:128)
at org.nuxeo.ecm.automation.core.impl.OperationChainCompiler$CompiledChainImpl.invoke(OperationChainCompiler.java:196)
at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:119)
at org.nuxeo.ecm.automation.core.impl.OperationServiceImpl.run(OperationServiceImpl.java:107)
at org.nuxeo.ecm.automation.server.jaxrs.OperationResource.execute(OperationResource.java:58)
at org.nuxeo.ecm.automation.server.jaxrs.ExecutableResource.doPost(ExecutableResource.java:71)
0 votes

1 answers

667 views

ANSWER



Tags rely on JOIN capabilities in the database and are therefore currently not implemented on MongoDB (NXP-17670).

We have a task to implement this in the near future for Nuxeo 9.10 using a different mechanism (NXP-21649).

1 votes