Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Editable Templates not displayed

Avatar

Avatar
Validate 1
Level 2
kartheekd203042
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Ignite 1
Give Back 3
Give Back
Boost 3
View profile

Avatar
Validate 1
Level 2
kartheekd203042
Level 2

Likes

3 likes

Total Posts

19 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Ignite 1
Give Back 3
Give Back
Boost 3
View profile
kartheekd203042
Level 2

01-07-2020

We are not able to navigate via Templates tab under Tools-->General-->Templates (nothing is displayed)
AEM version: AEM 6.4.6.0
This blocks us the ability to create editable templates under the /conf folder

Please note we can see the folders created under /conf folder

View Entire Topic

Avatar

Avatar
Give Back 5
Employee
sunjot16
Employee

Likes

103 likes

Total Posts

164 posts

Correct Reply

50 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile

Avatar
Give Back 5
Employee
sunjot16
Employee

Likes

103 likes

Total Posts

164 posts

Correct Reply

50 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile
sunjot16
Employee

03-07-2020

This issue isn't reproducible OOTB.

 

* Do you see any Console errors in Developer Tools of your browser?

* Do you see the same issue using OOTB admin user?

 

If it's not related to permissions, try the following steps as well:

* Enable DEBUG log level on query class below in /system/console/slinglog

org.apache.jackrabbit.oak.query

 

* Reload the http://<host>/<port>/libs/wcm/core/content/sites/templates.html/conf on your AEM environment.

* You will see the logs showing some query. It would be something like: 

SELECT * FROM [cq:Page] AS p WHERE ISDESCENDANTNODE([/conf]) AND p.[jcr:path] LIKE '/conf/%/settings/wcm/templates' ORDER BY [jcr:path]

 

* Run that query in Explain Query tool (/libs/granite/operations/content/diagnosistools/queryPerformance.html) with Include Execution Time and Include Node Count checkboxes checked.

 

Does it show any results?

* If it does, then the query is showing the correct results. Something on the UI side could be causing the issue.

Recompile JSPs & rebuild clientlibs, and then verify whether you see the templates appearing. 

https://helpx.adobe.com/experience-manager/kb/How-to-force-a-recompilation-of-all-Sling-scripts-jsps...

* If it doesn't, it could be something to do with cqPageLucene(/oak:index/cqPageLucene). Try re-indexing it and verify whether the issue still exists. Try using OOTB cqPageLucene index and then verify whether the issue still exists.

 

 

Hope it helps !!

kartheekd203042

Thanks sunjot.Rebuilding the clientlibs did not help and no errors in the console. Adding the log here for the explain query:

 

{
    "statement": "SELECT * FROM [cq:Page] AS p WHERE ISDESCENDANTNODE([/conf]) AND p.[jcr:path] LIKE '/conf/%/settings/wcm/templates' ORDER BY [jcr:path]",
    "language": "JCR-SQL2",
    "explain": {
        "logs": [
            "Parsing JCR-SQL2 statement: explain SELECT * FROM [cq:Page] AS p WHERE ISDESCENDANTNODE([/conf]) AND p.[jcr:path] LIKE '/conf/%/settings/wcm/templates' ORDER BY [jcr:path]\n",
            "Execute JCR-SQL2 / explain SELECT * FROM [cq:Page] AS p WHERE ISDESCENDANTNODE([/conf]) AND p.[jcr:path] LIKE '/conf/%/settings/wcm/templates' ORDER BY [jcr:path]\n",
            "Literal used\n",
            "Attempting optimisation\n",
            "cost using filter Filter(query=explain SELECT * FROM [cq:Page] AS p WHERE ISDESCENDANTNODE([/conf]) AND p.[jcr:path] LIKE '/conf/%/settings/wcm/templates' ORDER BY [jcr:path], path=/conf//*)\n",
            "cost for reference is Infinity\n",
            "cost for property is Infinity\n",
            "cost for nodeType is Infinity\n",
            "Ignoring index [/oak:index/slingeventJob] which is not working correctly since 16.66 d ,0 indexing cycles, accessed 32900 times\n",
            "Evaluating plan with index definition Lucene Index : /oak:index/versionStoreIndex\n",
            "Applicable IndexingRule found IndexRule: nt:base\n",
            "Evaluating plan with index definition Lucene Index : /oak:index/cqTagLucene\n",
            "No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
            "Evaluating plan with index definition Lucene Index : /oak:index/workflowDataLucene\n",
            "No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
            "Evaluating plan with index definition Lucene Index : /oak:index/socialLucene\n",
            "No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
            "Evaluating plan with index definition Lucene Index : /oak:index/authorizables\n",
            "No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
            "Evaluating plan with index definition Lucene Index : /oak:index/ntBaseLucene\n",
            "Applicable IndexingRule found IndexRule: nt:base\n",
            "Evaluating plan with index definition Lucene Index : /oak:index/nodetypeLucene\n",
            "No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
            "Evaluating plan with index definition Lucene Index : /oak:index/lucene\n",
            "Applicable IndexingRule found IndexRule: nt:base\n",
            "Evaluating plan with index definition Lucene Index : /oak:index/commerceLucene\n",
            "Applicable IndexingRule found IndexRule: nt:base\n",
            "Opting out due mismatch between path restriction /conf and query paths [/var/commerce]\n",
            "Evaluating plan with index definition Lucene Index : /oak:index/enablementResourceName\n",
            "Applicable IndexingRule found IndexRule: nt:base\n",
            "Opting out due mismatch between path restriction /conf and query paths [/content]\n",
            "Evaluating plan with index definition Lucene Index : /oak:index/cqReportsLucene\n",
            "No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
            "Evaluating plan with index definition Lucene Index : /oak:index/repTokenIndex\n",
            "No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
            "Evaluating plan with index definition Lucene Index : /oak:index/cqProjectLucene\n",
            "No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
            "Evaluating plan with index definition Lucene Index : /oak:index/cmLucene\n",
            "No applicable IndexingRule found for any of the superTypes [nt:hierarchyNode, cq:Page, nt:base, mix:created]\n",
            "Ignoring index [/oak:index/damAssetLucene] which is not working correctly since 16.66 d ,0 indexing cycles, accessed 27445 times\n",
            "Evaluating plan with index definition Lucene Index : /oak:index/cqPageLucene\n",
            "Applicable IndexingRule found IndexRule: cq:Page\n",
            "cost for [/oak:index/cqPageLucene] of type (lucene-property) with plan [lucene:cqPageLucene(/oak:index/cqPageLucene) :ancestors:/conf] is 1601.00\n",
            "cost for lucene-property[/oak:index/cqPageLucene] is 1601.0\n",
            "cost for aggregate lucene is Infinity\n",
            "looking for plans for paths : []\n",
            "cost for aggregate solr is Infinity\n",
            "cost for traverse is 2000.0\n",
            "No alternatives found. Query: select [p].[jcr:primaryType] as [p.jcr:primaryType], [p].[jcr:createdBy] as [p.jcr:createdBy], [p].[jcr:created] as [p.jcr:created] from [cq:Page] as [p] where (isdescendantnode([p], [/conf])) and ([p].[jcr:path] like '/conf/%/settings/wcm/templates') order by [p].[jcr:path] ASCENDING\n",
            "query:\texplain SELECT * FROM [cq:Page] AS p WHERE ISDESCENDANTNODE([/conf]) AND p.[jcr:path] LIKE '/conf/%/settings/wcm/templates' ORDER BY [jcr:path]\n",
            "count:\t1\tquery:\texplain SELECT * FROM [cq:Page] AS p WHERE ISDESCENDANTNODE('x') AND p.[jcr:path] LIKE 'x' ORDER BY [jcr:path]\n"
        ],
        "plan": "[cq:Page] as [p] /* lucene:cqPageLucene(/oak:index/cqPageLucene) :ancestors:/conf where (isdescendantnode([p], [/conf])) and ([p].[jcr:path] like '/conf/%/settings/wcm/templates') */",
        "propertyIndexes": [
            "cqPageLucene(/oak:index/cqPageLucene)"
        ]
    },
    "heuristics": {
        "count": 0,
        "countTime": 2,
        "executionTime": 4,
        "getNodesTime": 1,
        "totalTime": 7
    }
}
sunjot16
@kartheekd203042 The count seems to be 0. It could be something to do with cqPageLucene(/oak:index/cqPageLucene). Try re-indexing it and verify whether the issue still exists. Try using OOTB cqPageLucene index and then verify whether the issue still exists.
kartheekd203042
The issue is resolved by recreating the instance as it seems to be caused due to a corrupted repository.Thanks all for your help on this.