Expand my Community achievements bar.

SOLVED

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

Avatar

Level 4

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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