Dialog taking long time to open | Community
Skip to main content
user00725
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
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.

View reply

13 replies

Show previous replies
vish.dhaliwalAccepted solution
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 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
    smacdonald2008
    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
    Terms & ConditionsAccessibility statement

    Loading footer...