Unable to load DAM assets console in Author

If you see a blank screen while accessing the assets AEM console in Author, it could be because of too many workflow instances leading to error [ 1] . You can resolve it by cleaning these instances.

Description description

Environment

Adobe Experience Manager (AEM) on premise 6.5.15

Description

While trying to access the assets AEM console using “/assets.html/content/dam” the screen is blank.

Resolution resolution

The issue was fixed after cleaning the workflow instances.

Cause

While checking the error log, error [ 1] was found.

Assets and Sites UIs have to lookup the workflow status of the items they are listing. Therefore, if there are too many workflow instances, the page will fail to load and error [ 1] will be present in the logs.

[ 1]

*ERROR* [ 20.207.205.247 [ 1693905760728]  GET /assets.html/content/dam HTTP/1.1]  org.apache.sling.engine.impl.SlingRequestProcessorImpl service: Uncaught SlingException
org.apache.jackrabbit.oak.query.RuntimeNodeTraversalException: The query read or traversed more than 100000 nodes. To avoid affecting other tasks, processing was stopped.
    at org.apache.jackrabbit.oak.query.FilterIterators.checkReadLimit(FilterIterators.java:70) [ org.apache.jackrabbit.oak-core:1.22.13]
    at org.apache.jackrabbit.oak.plugins.index.Cursors.checkReadLimit(Cursors.java:67) [ org.apache.jackrabbit.oak-core:1.22.13]
    at org.apache.jackrabbit.oak.plugins.index.search.spi.query.FulltextIndex$FulltextPathCursor$1.next(FulltextIndex.java:411) [ org.apache.jackrabbit.oak-lucene:1.22.13]
    at org.apache.jackrabbit.oak.plugins.index.search.spi.query.FulltextIndex$FulltextPathCursor$1.next(FulltextIndex.java:392) [ org.apache.jackrabbit.oak-lucene:1.22.13]
    at com.google.common.collect.Iterators$7.computeNext(Iterators.java:646)
    at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:143)
    at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:138)
    at org.apache.jackrabbit.oak.plugins.index.Cursors$PathCursor.hasNext(Cursors.java:216) [ org.apache.jackrabbit.oak-core:1.22.13]
    at org.apache.jackrabbit.oak.plugins.index.search.spi.query.FulltextIndex$FulltextPathCursor.hasNext(FulltextIndex.java:432) [ org.apache.jackrabbit.oak-lucene:1.22.13]
    at org.apache.jackrabbit.oak.query.ast.SelectorImpl.nextInternal(SelectorImpl.java:515) [ org.apache.jackrabbit.oak-core:1.22.13]
    at org.apache.jackrabbit.oak.query.ast.SelectorImpl.next(SelectorImpl.java:508) [ org.apache.jackrabbit.oak-core:1.22.13]
    at org.apache.jackrabbit.oak.query.QueryImpl$RowIterator.fetchNext(QueryImpl.java:876) [ org.apache.jackrabbit.oak-core:1.22.13]
    at org.apache.jackrabbit.oak.query.QueryImpl$RowIterator.hasNext(QueryImpl.java:903) [ org.apache.jackrabbit.oak-core:1.22.13]
    at org.apache.jackrabbit.oak.jcr.query.QueryResultImpl$4.fetch(QueryResultImpl.java:186) [ org.apache.jackrabbit.oak-jcr:1.22.13]
    at org.apache.jackrabbit.oak.jcr.query.QueryResultImpl$4.next(QueryResultImpl.java:212) [ org.apache.jackrabbit.oak-jcr:1.22.13]
    at org.apache.jackrabbit.oak.jcr.query.QueryResultImpl$4.next(QueryResultImpl.java:175) [ org.apache.jackrabbit.oak-jcr:1.22.13]
    at org.apache.jackrabbit.oak.jcr.delegate.SessionDelegate$SynchronizedIterator.next(SessionDelegate.java:702) [ org.apache.jackrabbit.oak-jcr:1.22.13]
    at org.apache.jackrabbit.oak.jcr.query.PrefetchIterator.next(PrefetchIterator.java:88) [ org.apache.jackrabbit.oak-jcr:1.22.13]
    at org.apache.jackrabbit.commons.iterator.RangeIteratorAdapter.next(RangeIteratorAdapter.java:152) [ org.apache.jackrabbit.jackrabbit-jcr-commons:2.20.4]
    at org.apache.jackrabbit.commons.iterator.RangeIteratorDecorator.next(RangeIteratorDecorator.java:92) [ org.apache.jackrabbit.jackrabbit-jcr-commons:2.20.4]
    at org.apache.jackrabbit.commons.iterator.NodeIteratorAdapter.nextNode(NodeIteratorAdapter.java:80) [ org.apache.jackrabbit.jackrabbit-jcr-commons:2.20.4]
    at com.adobe.granite.workflow.core.jcr.WorkflowManager.getWorkflowInstances(WorkflowManager.java:1062) [ com.adobe.granite.workflow.core:2.0.240.CQ660-B0017]
    at com.adobe.granite.workflow.core.jcr.WorkflowManager.getAllWorkflowInstances(WorkflowManager.java:237) [ com.adobe.granite.workflow.core:2.0.240.CQ660-B0017]
    at com.adobe.granite.workflow.core.WorkflowSessionImpl.getWorkflows(WorkflowSessionImpl.java:636) [ com.adobe.granite.workflow.core:2.0.240.CQ660-B0017]
    at com.adobe.granite.workflow.core.WorkflowSessionImpl.getWorkflows(WorkflowSessionImpl.java:627) [ com.adobe.granite.workflow.core:2.0.240.CQ660-B0017]
    at com.adobe.granite.workflow.core.PayloadMapCache.init(PayloadMapCache.java:657) [ com.adobe.granite.workflow.core:2.0.240.CQ660-B0017]
    at com.adobe.granite.workflow.core.PayloadMapCache.exists(PayloadMapCache.java:560) [ com.adobe.granite.workflow.core:2.0.240.CQ660-B0017]
    at com.adobe.granite.workflow.core.PayloadMapCache.getWorkflowInstances(PayloadMapCache.java:199) [ com.adobe.granite.workflow.core:2.0.240.CQ660-B0017]
    at com.adobe.granite.workflow.core.PayloadMapImpl.getWorkflowInstances(PayloadMapImpl.java:64) [ com.adobe.granite.workflow.core:2.0.240.CQ660-B0017]
recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f