Issue Service outage looks like we are having some issues with our service we are working hard to bring it online again AEM | Adobe Higher Education
Skip to main content
N
NathanVieira
Level 3
September 25, 2023
Répondu

Issue Service outage looks like we are having some issues with our service we are working hard to bring it online again AEM

I have a contentfragment list type component that returns content fragments according to the logic of my queryBuilder. However, in the cloud environment, there are many content fragments, and when I try to render the search results, it displays this error:

"Service outage looks like we are having some issues with our service we are working hard to bring it online again AEM."

The page is black with no content in the editing panel and also in the "view as published" mode. In the editing panel, I can't even select the component to delete it from the left sidebar.

Below is the code for my query:

Map<String, String> queryParameterMap = new HashMap<>();
queryParameterMap.put("type", NT_DAM_ASSET);
queryParameterMap.put("p.limit", Integer.toString(maxItems));

queryParameterMap.put("group.p.or", "true");
queryParameterMap.put("group.1_group.path", "/content/dam/conteudo-multicanal/rodovias/conteudo/" + languagePageValue + folderNameTaxasDePedagio + concessionaryNameValue);
queryParameterMap.put("group.2_group.path", "/content/dam/conteudo-multicanal/rodovias/conteudo/" + languagePageValue + folderNamePontoDeParada + concessionaryNameValue); //tollPath + concessionaryNameValue //REMOVE CONCESSIONARY NAME VALUE IN CLOUD SERVER, LET ONLY tollPath

queryParameterMap.put("group.1_group.property", JcrConstants.JCR_CONTENT + "/data/cq:model");
queryParameterMap.put("group.1_group.property.value", "/conf/App-Rodovias/settings/dam/cfm/models/veiculos-com-multiplicadores");

queryParameterMap.put("group.2_group.property", JcrConstants.JCR_CONTENT + "/data/cq:model");
queryParameterMap.put("group.2_group.property.value", "/conf/App-Rodovias/settings/dam/cfm/models/ponto-de-parada");
queryParameterMap.put("group.2_group.2_property", JcrConstants.JCR_CONTENT + "/data/master/type");
queryParameterMap.put("group.2_group.2_property.value", "Toll");

//All the variables are correct because I can retrieve them correctly in the local environment.

 

Ce sujet a été fermé aux réponses.
Meilleure réponse par aanchal-sikka

Hello @nathanvieira 

 

Query optimization:

I had shared optimized query for you in previous post Solved: How to resolve and return correctly content fragme... - Adobe Experience League Community - 619204. 

I guess you had to keep code changes to minimum, so it was not taken into account 🙂

 

Please check, if its performing better than existing query. Even if it does not, please do share the feedback still. 

 

Index optimization:

- Assure that all fields used in the query are indexed. 

- Also sharing the best practices around indexing and query https://experienceleague.adobe.com/docs/experience-manager-65/deploying/practices/best-practices-for-queries-and-indexing.html?lang=en . Please check what is applicable for you

 

 

 

 

3 commentaires

EstebanBustamante
Community Advisor and Adobe Champion
EstebanBustamanteCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
September 25, 2023

Most likely your query is not performant causing a timeout and thus the issue you are seeing.

Please check your query using the Diagnosis Tool. You could use the following articles which explain how to check if your query is performant:

 

https://wttech.blog/blog/2020/jcr-query-performance/

https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/operations/query-and-indexing-best-practices.html?lang=en#use-an-index 

Esteban Bustamante
    N
    NathanVieiraAuteur
    Level 3
    September 25, 2023

    In my case, in the search I perform with the QueryBuilder, it retrieves content fragments from 2 different data models, "veiculos-com-multiplicadores" and "ponto-de-parada," and in the "ponto-de-parada" model, it retrieves all fragments of the "Toll" type.

    How can I adjust this code to be more performant?

      EstebanBustamante
      Community Advisor and Adobe Champion
      EstebanBustamanteCommunity Advisor and Adobe Champion
      Community Advisor and Adobe Champion
      September 26, 2023

      Some quick ideas:

      - Check if your query needs a custom index, 

      - Check if you can change the type of the node you are trying to traverse

       

      It is not that you necessarily need to change the query but make sure it runs in the optimal conditions as well, please check the articles i posted which contains more ideas. 

       

      Esteban Bustamante
        aanchal-sikka
        Community Advisor
        aanchal-sikkaCommunity AdvisorRéponse
        Community Advisor
        September 26, 2023

        Hello @nathanvieira 

         

        Query optimization:

        I had shared optimized query for you in previous post Solved: How to resolve and return correctly content fragme... - Adobe Experience League Community - 619204. 

        I guess you had to keep code changes to minimum, so it was not taken into account 🙂

         

        Please check, if its performing better than existing query. Even if it does not, please do share the feedback still. 

         

        Index optimization:

        - Assure that all fields used in the query are indexed. 

        - Also sharing the best practices around indexing and query https://experienceleague.adobe.com/docs/experience-manager-65/deploying/practices/best-practices-for-queries-and-indexing.html?lang=en . Please check what is applicable for you

         

         

         

         

        Aanchal Sikka
          N
          NathanVieiraAuteur
          Level 3
          September 26, 2023

          The solution didn't work; it's returning only fragments from the "ponto-de-parada" model of type "Toll" because the second property invalidates the first one.

            aanchal-sikka
            Community Advisor
            aanchal-sikkaCommunity Advisor
            Community Advisor
            September 26, 2023

            @nathanvieira 

             

            May be I am not reading your requirement correctly. Apologies for that

             

            Following is working fine for me:

            - Both CF are in different paths

            - They have different models

            - They have value type=Toll

             

             

             

             

            Aanchal Sikka
              kautuk_sahni
              Community Manager
              kautuk_sahniCommunity Manager
              Community Manager
              September 28, 2023

              @nathanvieira Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.

              Kautuk Sahni
              Conditions d'utilisationAccessibility statement

              Loading footer...