Not getting response from Querybuilder api | Community
Skip to main content
M
mayee_abhishek
March 1, 2023
Solved

Not getting response from Querybuilder api

  • March 1, 2023
  • 4 replies
  • 1022 views

Hi 

For the above query I am not getting response from querybuilder. 

I am getting below error 

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">


    <link rel="stylesheet" href="https://errors.adobeaemcloud.com/src.status.css">
</head>

<body>
    <noscript>AEM Cloud Service.</noscript>
    <div id="root" status="503" backend="91530c0b88d94723658fbdea70611f93--F_Skyline_Origin_Ingress_Author" healthy="1"
        gen="0" rid="c353be71-c5cf-45a9-9840-6819d71ee958" xid="1768318060" age="0.000" ttl="0.000" restarts="0"
        nobranding="true"
    </div>
    <script src="https://errors.adobeaemcloud.com/src.status.js"> </script>
</body>

</html>
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Shiv_Prakash_Patel

Hi @mayee_abhishek ,

Run the query with the query builder servlet. It will work in AEM as a cloud service as well. i.e. http://localhost:4502/bin/querybuilder.json?type=cq:Page&path=/content&limits=-1 

For original query :

type=cq:Page
path=/content
limits=-1

Please check out the query builder API in AEM as a cloud service -  https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/implementing/developing/full-stack/search/query-builder-api.html?lang=en 

You can also check the query builder search limit from the configuration Apache Jackrabbit Query Engine Settings Service and increase the limit or optimize your query.

Please checkout this reference - https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-maximum-limit-of-hits-of-querybuilder/m-p/460150 

Regards,

Shiv

 

 

4 replies

cwalter-1
cwalter-1
Level 2
March 1, 2023

Try to test this on your local sdk. I'm not sure if the old querybuilderdebugger ist still be supported at the cloud tbh.

    Shiv_Prakash_Patel
    Community Advisor
    Shiv_Prakash_PatelCommunity AdvisorAccepted solution
    Community Advisor
    March 1, 2023

    Hi @mayee_abhishek ,

    Run the query with the query builder servlet. It will work in AEM as a cloud service as well. i.e. http://localhost:4502/bin/querybuilder.json?type=cq:Page&path=/content&limits=-1 

    For original query :

    type=cq:Page
    path=/content
    limits=-1

    Please check out the query builder API in AEM as a cloud service -  https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/implementing/developing/full-stack/search/query-builder-api.html?lang=en 

    You can also check the query builder search limit from the configuration Apache Jackrabbit Query Engine Settings Service and increase the limit or optimize your query.

    Please checkout this reference - https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/what-is-maximum-limit-of-hits-of-querybuilder/m-p/460150 

    Regards,

    Shiv

     

     

    Shiv Prakash
      aanchal-sikka
      Community Advisor
      aanchal-sikkaCommunity Advisor
      Community Advisor
      March 1, 2023

      @mayee_abhishek 

      The query that you have shared in screenshot would traverse a lot of pages. It might be failing at backend after reaching Max traversal limit.

       

      When in doubt about queries, always check logs for Traversal errors.

      https://wttech.blog/blog/2020/jcr-query-performance/ explains about Explain Query tool, which helps you identify if an Index is picked for a query or not.

       

      Please find-tune your query to be more exact. Like a smaller sub-tree. 

      Aanchal Sikka
        TarunKumar
        Community Advisor
        TarunKumarCommunity Advisor
        Community Advisor
        March 1, 2023

        Hi @mayee_abhishek ,

        Try to debug and check if you are getting indexing for your query in the query performance tool:-
        http://localhost:4502/libs/granite/operations/content/diagnosistools/queryPerformance.html
        In this select the tab explain query and paste your query there.
        If there is any indexing issue that is prohibiting your query to execute, you should be able to identify that.

          Terms & ConditionsAccessibility statement

          Loading footer...