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

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

  • May 12, 2023
  • 1 reply
  • 1312 views

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

Best answer by Jagadeesh_Prakash

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

1 reply

Jagadeesh_Prakash
Jagadeesh_PrakashAccepted solution
New Participant
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. 

    Terms & ConditionsAccessibility statement

    Loading footer...