CMIS Query returns different results

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

darminm

Hello,

We have a repository with about 2M documents.

We are trying to get list of documents that have a certain category (attribute) assigned.

I am using CMIS Workbench to connect to Alfresco 5.0.3.1

Each time I ran the simple select query I get different result set.

Attempt 1: 3185 results, 107 seconds

Attempt 2: 3065 results, 93 seconds

Attempt 3: 4197 results, 112 seconds

Attempt 4: 3003 results, 76 seconds

We should have close to 100K documents that fall within the category we are searching for.

Thank you

jego

Hi,

please Post your query here... and check if the query will run via Solr or database...

maybe there is a timeout / limit in Alfresco which prevents returning all results.

do you find anything in the repository log?

thanks

jens