Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.
SOLVED

Wrong Query happened for particular asset 11 times

Avatar

Level 1

Wrong Query happened for particular asset 11 times
(1st occurence 12:39:45 & Last occurence 12:39:45)
24.02.2021 12:39:45.693 *WARN* [10.43.32.87 [1614170383638] GET /libs/wcm/core/content/reference.json HTTP/1.1]
org.apache.sling.event.impl.jobs.JobManagerImpl
Query syntax wrong /jcr:root/var/eventing/jobs//element(*,slingevent:Job)
[@event.job.topic = 'com/day/cq/replication/job/offloading_outbox' and not(@slingevent:finishedState)
and ((@cq:path = '/content/dam/diagnostics/Blueprint/en/videos/rmd/Fighting-To-Beat-Lung-Cancer-Bobbi's-Story-of-Hope.mp4'))]
order by @slingevent:created ascending
org.apache.sling.api.resource.QuerySyntaxException: java.text.ParseException: Query:
/jcr:root/var/eventing/jobs//element(*,slingevent:Job)[@event.job.topic =
'com/day/cq/replication/job/offloading_outbox' and not(@slingevent:finishedState)
and ((@cq:path = '/content/dam/diagnostics/Blueprint/en/videos/rmd/Fighting-To-Beat-Lung-Cancer-Bobbi's-Story-of-Hope.mp4(*)'))]
order by @slingevent:created ascending

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@SreeDurga 
It looks like the error/warning is associated to a particular asset only. It will help to see the query that was used. However can you try to see

1. if there is a scope to do escaping in query or

2. try to make same query using AEM query builder (assuming current query is happening via code)

View solution in original post

2 Replies

Avatar

Community Advisor

Hi @SreeDurga,

 

Can you please elaborate on your query?

 

Thanks,

Kiran Vedantam.

Avatar

Correct answer by
Community Advisor

@SreeDurga 
It looks like the error/warning is associated to a particular asset only. It will help to see the query that was used. However can you try to see

1. if there is a scope to do escaping in query or

2. try to make same query using AEM query builder (assuming current query is happening via code)