Nuxeo Retention Management addon - error

[Lukasz_Zalewski]

Hi All,
/> I try to use addon Nuxeo Retention Management addon version 2021.0.0 https://doc.nuxeo.com/nxdoc/nuxeo-retention-management/

in my nuxeo 2021 and when I try to put documents under retention from a result list (https://doc.nuxeo.com/nxdoc/nuxeo-retention-functional-overview/#from-a-result-list/)

I get this error:

ERROR [bulk/scrollerPool-00]
[org.nuxeo.ecm.core.bulk.computation.BulkScrollerComputation]
  
Invalid query results in an empty document set:
org.nuxeo.ecm.core.bulk.message.BulkCommand@574b8fea
[action=attachRetentionRule,batchSize=20,bucketSize=100,externalScroller=false,genericScroller=false,id=b62218e5-810a-444e-9d01-110265ad44b0,params={ruleId=4343eed7-d7d6-4a86-a32d-6ceb72698354},
  
query=SELECT * FROM Document WHERE file:content/name IS NOT NULL AND ecm:mixinType != 'HiddenInNavigation' AND record:ruleIds IS NULL,queryLimit=<null>,repository=default,scroller=<null>,username=Administrator]
  
Can only use collection record:ruleIds with =, <>, IN or NOT IN clause?  

 at org.nuxeo.ecm.core.storage.sql.jdbc.NXQLQueryMaker$WhereBuilder.visitReference(NXQLQueryMaker.java:2441) ~[nuxeo-core-storage-sql-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.query.sql.model.Reference.accept(Reference.java:80) ~[nuxeo-core-query-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.query.sql.model.DefaultQueryVisitor.visitExpression(DefaultQueryVisitor.java:93) ~[nuxeo-core-query-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.storage.sql.jdbc.NXQLQueryMaker$WhereBuilder.visitExpression(NXQLQueryMaker.java:1960) ~[nuxeo-core-storage-sql-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.query.sql.model.Expression.accept(Expression.java:52) ~[nuxeo-core-query-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.storage.sql.jdbc.NXQLQueryMaker$WhereBuilder.visitMultiExpression(NXQLQueryMaker.java:1876) ~[nuxeo-core-storage-sql-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.query.sql.model.MultiExpression.accept(MultiExpression.java:56) ~[nuxeo-core-query-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.storage.sql.jdbc.NXQLQueryMaker.buildQuery(NXQLQueryMaker.java:493) ~[nuxeo-core-storage-sql-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.scrollSearch(JDBCMapper.java:635) ~[nuxeo-core-storage-sql-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.scroll(JDBCMapper.java:612) ~[nuxeo-core-storage-sql-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.storage.sql.SoftRefCachingMapper.scroll(SoftRefCachingMapper.java:52) ~[nuxeo-core-storage-sql-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.storage.sql.SessionImpl.scroll(SessionImpl.java:652) ~[nuxeo-core-storage-sql-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.scroll(SQLSession.java:145) ~[nuxeo-core-storage-sql-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.api.AbstractSession.scroll(AbstractSession.java:1389) ~[nuxeo-core-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.scroll.RepositoryScroll.fetch(RepositoryScroll.java:88) ~[nuxeo-core-bulk-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.scroll.RepositoryScroll.hasNext(RepositoryScroll.java:81) ~[nuxeo-core-bulk-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.bulk.computation.BulkScrollerComputation.processRecord(BulkScrollerComputation.java:172) ~[nuxeo-core-bulk-2021.6.4.jar:?]
        at org.nuxeo.ecm.core.bulk.computation.BulkScrollerComputation.processRecord(BulkScrollerComputation.java:148) ~[nuxeo-core-bulk-2021.6.4.jar:?]
        at org.nuxeo.lib.stream.computation.log.ComputationRunner.lambda$processRecordWithRetry$10(ComputationRunner.java:466) ~[nuxeo-stream-2021.6.4.jar:?]
        at net.jodah.failsafe.Functions$10.call(Functions.java:252) [failsafe-1.1.0.jar:1.1.0]
        at net.jodah.failsafe.SyncFailsafe.call(SyncFailsafe.java:145) [failsafe-1.1.0.jar:1.1.0]
        at net.jodah.failsafe.SyncFailsafe.run(SyncFailsafe.java:81) [failsafe-1.1.0.jar:1.1.0]
        at org.nuxeo.lib.stream.computation.log.ComputationRunner.processRecordWithRetry(ComputationRunner.java:466) [nuxeo-stream-2021.6.4.jar:?]
        at org.nuxeo.lib.stream.computation.log.ComputationRunner.processRecordWithTracing(ComputationRunner.java:418) [nuxeo-stream-2021.6.4.jar:?]
        at org.nuxeo.lib.stream.computation.log.ComputationRunner.processRecord(ComputationRunner.java:409) [nuxeo-stream-2021.6.4.jar:?]
        at org.nuxeo.lib.stream.computation.log.ComputationRunner.processLoop(ComputationRunner.java:272) [nuxeo-stream-2021.6.4.jar:?]
        at org.nuxeo.lib.stream.computation.log.ComputationRunner.run(ComputationRunner.java:206) [nuxeo-stream-2021.6.4.jar:?]
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
        at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
        at java.lang.Thread.run(Thread.java:829) [?:?]

Any ideas??

[Gregory_Carlin]

Can you reproduce the bug with the LTS2019 version? There's no reason this behaviour would happen IMO. It seems a bug and should be reported to the product team.

[Lukasz_Zalewski]

Thank you for your answer. I did not try to reproduce the bug with the LTS2019 version. How can I reported a bug to the product team?