Report Generation gives error

[skumari1]

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. 

[ksh_ingole7]

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

[skumari1]

Hi @ksh_ingole7 
The result after running it from crxde

[ksh_ingole7]

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? 

[skumari1]

Hi @ksh_ingole7 

Are you asking about the below window whether dateProp present here as a property or not?

Also i am still not able to fetch the report as its giving me 500 error. while trying to download the report its giving me empty report.

The error which i am getting in the error.log console its only saying about  date format. So i have tried to modify the date format, currently using "yyyy-MM-dd'T'HH:mm:ssZ". You can also see in the image.

javax.jcr.query.InvalidQueryException: java.lang.IllegalArgumentException: Not a date string: {{dateFrom}}    

[Aditya_Chabuku]

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

[skumari1]

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

[skumari1]

Hi @Aditya_Chabuku 

Added one zero in the "In memory limit" but it didn't worked. still got the same error.