Skip to main content
Community Advisor
KNanCommunity Advisor
Community Advisor
May 12, 2023
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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jagadeesh_Prakash
Jagadeesh_PrakashAccepted solution
Community Advisor
May 15, 2023

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

View in thread

1 reply

Jagadeesh_Prakash
Community Advisor
Jagadeesh_PrakashCommunity AdvisorAccepted solution
Community Advisor
May 15, 2023

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