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
۶Ƶ 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