Open TNagarjuna opened 2 years ago
@TNagarjuna do you have an error log for this? Can you reproduce locally?
@TNagarjuna Are the properties indexed? If not quite likely Oak is performing a traversal to execute your query (thus leading to the described performance issues).
This tool can help you create an index for your query: https://oakutils.appspot.com/generate/index
Required Information
Expected Behavior
Report has to generate even if there are more nodes under the path(Ex:/content/mysite/Test1
Actual Behavior
Using ACS AEM commons, we have created report for our custom properties ,, but its working where the data is less and its failing where data is heavy and its redirecting to adobe cloud outtage error page.
Ex: Path: /content/dam/Abc: Assume there are 50 nodes under this and when we are tryiing to report then its working.
Ex:/content/dam/xyz: Assume there are more than 100 + nodes and where we try to generate the report using this path then its failing and not able to excute/generate the reprot.
Steps to Reproduce
Go to General-->ACS AEM Commons Click reports Create new Created the custom report with custom properties using ACS AEM Commons SELECT * FROM [nt:unstructured] AS s WHERE ISDESCENDANTNODE(s,'/content/dam/bdb/products/global/reagents/flow-cytometry-reagents/research-reagents')
Links
Links to related assets, e.g. content packages containing test components