Absolute Path expected exception when runs the query in SQL2 in AEM cloud | Community
Skip to main content
KNan
New Participant
May 12, 2023 5:55 PM UTC
Solved

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

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
Jagadeesh_PrakashAccepted solution
New Participant
May 15, 2023 9:31 AM UTC

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

View reply

1 reply

Jagadeesh_Prakash
Jagadeesh_PrakashAccepted solution
New Participant
May 15, 2023 9:31 AM UTC

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

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...