Indexing issue - AEM 6.1

Avatar

Avatar
Validate 1
Level 2
sukumard5750513
Level 2

Likes

6 likes

Total Posts

26 posts

Correct reply

3 solutions
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Validate 1
Level 2
sukumard5750513
Level 2

Likes

6 likes

Total Posts

26 posts

Correct reply

3 solutions
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile
sukumard5750513
Level 2

20-08-2018

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

Replies

Avatar

Avatar
Coach
Employee
jbrar
Employee

Likes

389 likes

Total Posts

869 posts

Correct reply

283 solutions
Top badges earned
Coach
Establish
Give Back 50
Give Back 5
Give Back 3
View profile

Avatar
Coach
Employee
jbrar
Employee

Likes

389 likes

Total Posts

869 posts

Correct reply

283 solutions
Top badges earned
Coach
Establish
Give Back 50
Give Back 5
Give Back 3
View profile
jbrar
Employee

20-08-2018

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

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,409 likes

Total Posts

12,671 posts

Correct reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,409 likes

Total Posts

12,671 posts

Correct reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile
smacdonald2008
Level 10

20-08-2018

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

Avatar
Validate 1
Level 2
sukumard5750513
Level 2

Likes

6 likes

Total Posts

26 posts

Correct reply

3 solutions
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Validate 1
Level 2
sukumard5750513
Level 2

Likes

6 likes

Total Posts

26 posts

Correct reply

3 solutions
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile
sukumard5750513
Level 2

21-08-2018

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)