Expand my Community achievements bar.

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)