Absolute Path expected exception when runs the query in SQL2 in AEM cloud

[KannanC]

Hello Team,

My local is in AEM 6.5 .My query runs properly and getting result as expected . But I'm executing the same query in the Cloud ENV. But I got exception like.

Caused by: java.text.ParseException: Query: {....my query contains content path....} expected: absolute path
    at org.apache.jackrabbit.oak.query.SQL2Parser.getSyntaxError(SQL2Parser.java:1446) [org.apache.jackrabbit.oak-core:1.44.0.T20221206170501-6d59064]
    at org.apache.jackrabbit.oak.query.SQL2Parser.readAbsolutePath(SQL2Parser.java:678) [org.apache.jackrabbit.oak-core:1.44.0.T20221206170501-6d59064]
    at org.apache.jackrabbit.oak.query.SQL2Parser.parseConditionFunctionIf(SQL2Parser.java:608) [org.apache.jackrabbit.oak-core:1.44.0.T20221206170501-6d59064]
    at org.apache.jackrabbit.oak.query.SQL2Parser.parseCondition(SQL2Parser.java:440) [org.apache.jackrabbit.oak-core:1.44.0.T20221206170501-6d59064]
[org.apache.jackrabbit.oak-core:1.44.0.T20221206170501-6d59064]

What will be the root cause for this exception .? any suggestions ?

Please let me know if any other details needed..

Thanks in advance 

KNaN

[Jagadeesh_Prakash · Accepted solution]

@KannanC  It looks like pageUrl is empty and searching the entire repository. Can you ping me the query which you are executing.