Indexing issue - AEM 6.1

[#1]

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.

[#2]

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

[#3]

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.

[#4]

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)