Skip to main content
Level 4
Jul 22, 2018 4:32 AM UTC
Solved

Dialog taking long time to open

Hello All,

             We are migrating from  AEM 6.0 to AEM 6.3.2.2(SP2 + CFPS 1 and 2).  All our application related tags are  present under /etc/tags/xyzApp

After migration, when we open any of our components dialog, they are taking long time (around 10~15 seconds) to open.

When we tail error.log, while opening dialog,  we are seeing below warnings in error.log

07.2018 06:28:25.803 *WARN* [10.246.75.239 [1532082503111] GET /mnt/override/apps/xyzApp/components/content/site/abc-pqr/_cq_dialog.html/content/xyz/dfh/jcr:content/rhs/abc-pqr HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 14000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [cq:Tag] as a where isdescendantnode(a, '/etc/tags/xyzApp') /* xpath: /jcr:root/etc/tags/xyzApp//element(*, cq:Tag) */, path=/etc/tags/xyzApp//*); consider creating an index or changing the query

20.07.2018 06:28:25.962 *WARN* [10.246.75.239 [1532082503111] GET /mnt/override/apps/xyzApp/components/content/site/abc-pqr/_cq_dialog.html/content/xyz/dfh/jcr:content/rhs/abc-pqr HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 15000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [cq:Tag] as a where isdescendantnode(a, '/etc/tags/xyzApp') /* xpath: /jcr:root/etc/tags/xyzApp//element(*, cq:Tag) */, path=/etc/tags/xyzApp//*); consider creating an index or changing the query

Please let us know how to solve this problem. We have not seen this issue in AEM 6.0

Regards

Sreeni

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
vish.dhaliwalAccepted solution
Adobe Employee
Jul 24, 2018 3:55 AM UTC

These warnings may be stemming from bad index definition, where the "propertyNames" property has type String but the expected type is Name[] and that index is used to index "lastUnpacked" property.

13 replies

smacdonald2008
Level 10
Jul 22, 2018 3:21 PM UTC

This seems to be an upgrade issue. You may require a hotfix. I recommend opening a support ticket.

Translate
user00725Author
Level 4
Jul 23, 2018 2:40 AM UTC

Thanks Scott for your quick reply!

We also tried creating an index on query shown in above WARNING message as follows.

Query:-

select [jcr:path], [jcr:score], * from [cq:Tag] as a where isdescendantnode(a, '/etc/tags/xyzApp')

Index:-

{

"compatVersion": 2,

"async": "async",

"jcr:primaryType": "oak:QueryIndexDefinition",

"evaluatePathRestrictions": true,

"type": "lucene",

"indexRules": {

"jcr:primaryType": "nt:unstructured",

"cq:Tag": {

"jcr:primaryType": "nt:unstructured",

"properties": {

"jcr:primaryType": "nt:unstructured",

"primaryType": {

"name": "jcr:primaryType",

"propertyIndex": true,

"jcr:primaryType": "nt:unstructured"

}

}

}

}

}

After creating the above index, we are not seeing the WARNING message in error log, but no performance improvement.

But we are seeing below new WARNING messages while opening the dialog of the component. Please suggest  how to resolve this issue

22.07.2018 08:56:34.667 *WARN* [10.246.75.239 [1532264175651] GET /mnt/override/apps/xyzApp/components/content/site/abc-pqr/_cq_dialog.html/content/xyz/dfh /jcr:content/rhs/abc-pqr HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.property.PropertyIndexLookup Expected 'NAMES' as type of property 'propertyNames' but found 'STRING'. Node - '{ jcr:primaryType = oak:QueryIndexDefinition, propertyNames = lastUnpacked, type = property, reindex = false, reindexCount = 1, :index = { ... } }'

22.07.2018 08:56:34.668 *WARN* [10.246.75.239 [1532264175651] GET /mnt/override/apps/xyzApp/components/content/site/abc-pqr/_cq_dialog.html/content/xyz/dfh /jcr:content/rhs/abc-pqr HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.property.PropertyIndexLookup Expected 'NAMES' as type of property 'propertyNames' but found 'STRING'. Node - '{ jcr:primaryType = oak:QueryIndexDefinition, propertyNames = lastUnpacked, type = property, reindex = false, reindexCount = 1, :index = { ... } }'

Thanks in advance!

Translate
vish.dhaliwalAdobe EmployeeAccepted solution
Adobe Employee
Jul 24, 2018 3:55 AM UTC

These warnings may be stemming from bad index definition, where the "propertyNames" property has type String but the expected type is Name[] and that index is used to index "lastUnpacked" property.

Translate
user00725Author
Level 4
Jul 26, 2018 4:59 PM UTC

Any help here please, i am still blocked on this issue!

Translate
smacdonald2008
Level 10
Jul 26, 2018 5:02 PM UTC

I have asked our cust care team to look here. This may be a known issue when upgrading.

Translate
Adobe Employee
Jul 26, 2018 5:17 PM UTC

It looks like the custom index was not created properly.

Based on a traverse query WARN message you have to have something similar to:

Keep in mind that in AEM 6.3 and 6.4 "jcr:primaryType" property is indexed by default. If you are using one of those versions you can try to reindex /oak:index/cqTagLucene

Translate
smacdonald2008
Level 10
Jul 27, 2018 3:03 PM UTC

Thanks Leo for responding!

Translate
user00725Author
Level 4
Jul 30, 2018 3:37 PM UTC

Thanks Scott and Leo for responding to it.

As suggested, primaryType is created under /oak:index/cqTagLucene/indexRules/cq:Tag/properties and reindexed /oak:index/cqTagLucene.

After re indexing successful, when i try to open any dialog, now i am not seeing any WARN messages in log, but still it is taking time to load.

Below are 2 observations, which may help to give more insights to problem

1. The OOB foundation component(like text, image etc) dialogs are opening quite fast, only my custom components are taking time.

2. We have enabled SAML integration in our environment, if i login with a user(not admin/admin) and try opening a dialog, they open quite fast, but if i login with admin/admin it takes time to load. We disabled SAML and tried with admin/admin user, but still takes long time.

Please suggest.

Translate
user00725Author
Level 4
Aug 3, 2018 5:24 PM UTC

Any help here please, I am still blocked

Translate
smacdonald2008
Level 10
Aug 3, 2018 5:30 PM UTC

Did you follow Leo,s advice exactly as is. I have never seen a situation where dialogs open in the manner you are descring, Is this AEM instance a fresh instance or upgraded one?

Translate