AEM ACS common Bundle issue
Hi Team,
I am facing one related to AEM 6.5 with acs common bundles like while running this below query the lastloggedin Author reports I am getting this below Error
SELECT * FROM [rep:AccessControllable] as nodes WHERE ISDESCENDANTNODE("/home/users")
AND nodes.[profile/lastLoggedIn] IS NOT NULL
AND NOT ISDESCENDANTNODE([/home/users/community])
AND NOT ISDESCENDANTNODE([/home/users/mac])
AND NOT ISDESCENDANTNODE([/home/users/rep:policy])
AND NOT ISDESCENDANTNODE([/home/users/screens])
AND NOT ISDESCENDANTNODE([/home/users/system])
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) [org.apache.felix.http.jetty:4.1.4]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) [org.apache.felix.http.jetty:4.1.4]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773) [org.apache.felix.http.jetty:4.1.4]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905) [org.apache.felix.http.jetty:4.1.4]
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: com.adobe.acs.commons.reports.api.ReportException: Exception executing search results
at com.adobe.acs.commons.reports.models.QueryReportExecutor.fetchResults(QueryReportExecutor.java:110) [com.adobe.acs.acs-aem-commons-bundle:4.12.0]
at com.adobe.acs.commons.reports.models.QueryReportExecutor.getResults(QueryReportExecutor.java:185) [com.adobe.acs.acs-aem-commons-bundle:4.12.0]
at jdk.internal.reflect.GeneratedMethodAccessor820.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at javax.el.BeanELResolver.getValue(BeanELResolver.java:83) [org.apache.sling.scripting.el-api:1.0.4]
... 156 common frames omitted
Caused by: javax.jcr.query.InvalidQueryException: The specified language is not supported: sas_84362
at org.apache.jackrabbit.oak.jcr.query.QueryManagerImpl.createQuery(QueryManagerImpl.java:82) [org.apache.jackrabbit.oak-jcr:1.22.6]
at org.apache.jackrabbit.oak.jcr.query.QueryManagerImpl.createQuery(QueryManagerImpl.java:59) [org.apache.jackrabbit.oak-jcr:1.22.6]
at com.adobe.acs.commons.reports.models.QueryReportExecutor.fetchResults(QueryReportExecutor.java:90) [com.adobe.acs.acs-aem-commons-bundle:4.12.0]
... 161 common frames omitted
Could you please help on this
