Wrong Query happened for particular asset 11 times

Avatar

Avatar

SreeDurga

Avatar

SreeDurga

SreeDurga

02-04-2021

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

snbaem

Avatar

snbaem

snbaem

05-04-2021

@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)

Answers (1)

Answers (1)

Avatar

Avatar

KiranVedantam1992

Avatar

KiranVedantam1992

KiranVedantam1992

02-04-2021

Hi @SreeDurga,

 

Can you please elaborate on your query?

 

Thanks,

Kiran Vedantam.