Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Wrong Query happened for particular asset 11 times

SreeDurga
Level 1
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
snbaem
Correct answer by
Community Advisor
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
KiranVedantam1992
Community Advisor
Community Advisor

Hi @SreeDurga,

 

Can you please elaborate on your query?

 

Thanks,

Kiran Vedantam.

snbaem
Correct answer by
Community Advisor
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