Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Experience Manager Champion Program are open!

Indexing issue - AEM 6.1

Avatar

Level 3

Hi,

I am using AEM 6.1 vanilla without any HFs. We are getting below exception in Author, not sure what is causing this issue.

We have below index definition which is being used in query builder API.

<?xml version="1.0" encoding="UTF-8"?>

<jcr:root xmlns:oak="http://jackrabbit.apache.org/oak/ns/1.0" xmlns:jcr="http://www.jcp.org/jcr/1.0" xmlns:nt="http://www.jcp.org/jcr/nt/1.0" xmlns:rep="internal"

    jcr:mixinTypes="[rep:AccessControllable]"

    jcr:primaryType="nt:unstructured">

    <ProductIndex

        jcr:primaryType="oak:QueryIndexDefinition"

        propertyNames="{Name}[identifier,cq:tags,subGroupId,sku,packName,packGroup,groupId,brand,model,deviceId,SalesEndDate,launchDate,ranking,SalesEffectiveDate]"

        includedPaths="/etc/commerce/products"

reindex="{Boolean}true"

        reindexCount="{Long}1"

        type="property"/>

</jcr:root>

This oak index definition is part of our deployment package and gets deployed during each deployment.

Please help/share to overcome this issue.

Index.png

3 Replies

Avatar

Employee Advisor

Can you share the full stack trace?

Also set up a DEBUG logger on the following classes to check if its an indexing issue:-

  • org.apache.jackrabbit.oak.plugins.index
  • org.apache.jackrabbit.oak.query
  • com.day.cq.search

Avatar

Level 10

Did you watch the GEMS session on Indexing?

Best Practices for Indexing and Queries in AEM

Make sure that you follow all of the best practice techniques discussed in that session.

Avatar

Level 3

Thanks jaideep, as per your guideline

I have enabled this, but could not get much in index log.  Below is the index report. Highlighted one below is my index.

Need help to understand few things :-

1- Why its showing * in below report

2- Though i have mentioned includedPaths but still index on all other nodes on top of includedPaths ? do i need to define the excluded paths as well for Var, tmp, system etc ?

21.08.2018 14:50:47.752 *INFO* [qtp388571778-193] org.apache.jackrabbit.oak.plugins.index.IndexUpdate Reindexing Traversed #800000 /apps/acs-commons/components/utilities/jcr-compare/clientlibs/js

21.08.2018 14:50:47.756 *INFO* [qtp388571778-193] org.apache.jackrabbit.oak.plugins.index.IndexUpdate Indexing report

    - /oak:index/cqOwnerCanvasPage(0)

    - /oak:index/uuid(0)

    - /oak:index/damStatus(0)

    - /oak:index/campaignpath(0)

    - /oak:index/type(0)

    - /oak:index/cqPayloadPath(0)

    - /oak:index/contentPath(0)

    - /oak:index/refExpired(0)

    - /oak:index/containeeInstanceId(0)

    - /oak:index/cqCloudServiceConfigs(0)

    - /oak:index/cqCugEnabled(0)

    - /oak:index/cqAcUUID(0)

    - /oak:index/status(0)

    - /oak:index/reference(0)

    - /oak:index/principalName(0)

    - /oak:index/extensionType(0)

    - /oak:index/cqMaster(0)

    - /oak:index/jcrLanguage(0)

    - /oak:index/ProductIndex*(78754)

    - /oak:index/lockCreated(0)

    - /oak:index/sdProductIdentifier(0)

    - /oak:index/processingProfile(0)

    - /oak:index/cqLastRolledoutBy(0)

    - /oak:index/slingResources(0)

    - /oak:index/damScene7ID(0)

    - /oak:index/damResolvedPath(0)

    - /oak:index/subType(0)

    - /oak:index/slingResource(0)

    - /oak:index/damS7watch(0)

    - /oak:index/jcrLockOwner(0)

    - /oak:index/cqTemplate(0)

    - /oak:index/sdCqProductMaster(0)

    - /oak:index/cqDefaultFormFor(0)

    - /oak:index/fpContentType(0)

    - /oak:index/cqParentPath(0)

    - /oak:index/cqVariantFamily(0)

    - /oak:index/slingVanityPath(0)

    - /oak:index/jcrFrozenMixinTypes(0)

    - /oak:index/deviceId(0)

    - /oak:index/slingAlias(0)

    - /oak:index/active(0)

    - /oak:index/sdCqCommerceType(0)

    - /oak:index/acPrincipalName(0)

    - /oak:index/devicePriceDeviceId(0)

    - /oak:index/cqKeywords(0)

    - /oak:index/cqCloudServiceConfig(0)

    - /oak:index/cqLastReplicationAction(0)

    - /oak:index/sdContentReviewDate(0)

    - /oak:index/verb(0)

    - /oak:index/guideComponentType(0)

    - /oak:index/authorizableId(0)

    - /oak:index/planId(0)

    - /oak:index/deviceIdentificationMode(0)

    - /oak:index/sdCqArticleDate(0)

    - /oak:index/event.job.topic(0)

    - /oak:index/slingResourceType(0)

    - /oak:index/slingResourceSuperType(0)

    - /oak:index/nodetype(0)

    - /oak:index/slingeventEventId(0)