Report Generation gives error | Community
Skip to main content
S
skumari1
Level 3
August 29, 2022

Report Generation gives error

  • August 29, 2022
  • 2 replies
  • 2055 views

Hi Team,

 we are trying to generate Dam report through Localhost:4502/var/acs-commons/reports/workflow-audit-report.html?wcmmode=disabled.

But we are getting the below error

29.08.2022 08:17:23.286 *ERROR* [10.182.60.81 [1661775443262] GET /var/acs-commons/reports/workflow-audit-report/_jcr_content.results.html HTTP/1.1] org.apache.sling.engine.impl.SlingRequestProcessorImpl service: Uncaught SlingException
javax.el.ELException: Error reading 'results' on type com.adobe.acs.commons.reports.models.QueryReportExecutor
	at javax.el.BeanELResolver.getValue(BeanELResolver.java:87)

Can anyone help here to troubleshoot the issue. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

ksh_ingole7
Community Advisor
ksh_ingole7Community Advisor
Community Advisor
August 29, 2022

Hi @skumari1 

 

Can you try running the Report Query in CRX and see if the results are coming fine?

 

Also check configuration of Query Language value that is configured as part of JCR Query Report Configuration component. Check if it same as the intended value. Refer below document to check the same

 

https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/configuring.html

 

Thanks

    S
    skumari1Author
    Level 3
    August 30, 2022

    Hi @ksh_ingole7 
    The result after running it from crxde

     

      ksh_ingole7
      Community Advisor
      ksh_ingole7Community Advisor
      Community Advisor
      August 30, 2022

      There seems to be an issue with the Query. The query is not able to generate results hence not able to return it to the Report. If we fix the query the report should ideally work. 

       

      I believe you are trying to fetch pages between 2 dates based on 'DateProp'. 'dateFrom' and 'dateTo' are provided in the report. 

       

      I ran the below query and it fetched the results between specified dates.

       

      SELECT p.* FROM [nt:base] AS p WHERE ISDESCENDANTNODE(p,'/content') AND (p.[cq:lastModified] >= CAST('2022-01-01T00:00:00.000Z' AS DATE) AND p.[cq:lastModified] <= CAST('2022-12-31T23:59:59.999Z' AS DATE))

       

      Things to check that are on top of my head ->

      1. Check if the dateProp, dateFrom, dateTo properties are getting fetched into the Report.

      2. Is the 'dateProp' present on cq:Page node or nt:base node? 

       

        Aditya_Chabuku
        Community Advisor
        Aditya_ChabukuCommunity Advisor
        Community Advisor
        August 29, 2022

        Hi @skumari1, I know this Exception. It's because your Report is calling too many queries. Just increase your in-memory limit at 

         

        Query Engine 

        Apache Jackrabbit Query Engine Settings Service

         

         

        Thanks,Aditya Chabuku
          S
          skumari1Author
          Level 3
          August 30, 2022

          Hi @aditya_chabuku 

          Its already 500000, shall i increase this if yes then how much?

          Also the error log having these details:-

          Caused by: javax.jcr.query.InvalidQueryException: java.lang.IllegalArgumentException: Not a date string: 2022-08-16T00:00:00.000 05:30 Caused by: com.adobe.acs.commons.reports.api.ReportException: Exception executing search results Caused by: java.lang.IllegalArgumentException: Not a date string: 2022-08-16T00:00:00.000 05:30

           

            Terms & ConditionsAccessibility statement

            Loading footer...