{ "exception":{ "exception_class":"javax.jcr.query.InvalidQueryException", "exception_message":"java.text.ParseException: Query: SELECT * FROM [mix:referenceable] AS ref INNER JOIN [nt:base] AS b ON ISCHILDNODE(b, ref) WHERE b.[jcr:primaryType] IS NOT NULL AND ISDESCENDANTNODE(ref, '')(*)AND (LOWER(ref.[docName]) LIKE '%%') ORDER BY ref.[jcr:created] DESC; expected: absolute path", "stacktrace":"javax.jcr.query.InvalidQueryException: java.text.ParseException: Query: SELECT * FROM [mix:referenceable] AS ref INNER JOIN [nt:base] AS b ON ISCHILDNODE(b, ref) WHERE b.[jcr:primaryType] IS NOT NULL AND ISDESCENDANTNODE(ref, '')(*)AND (LOWER(ref.[docName]) LIKE '%%') ORDER BY ref.[jcr:created] DESC; expected: absolute path\n\tat org.apache.jackrabbit.oak.jcr.query.QueryManagerImpl.executeQuery(QueryManagerImpl.java:148)\n\tSuppressed: reactor.core.publisher.FluxOnAssembly$OnAssemblyException: \nError has been observed at the following site(s):\n\t|_ checkpoint ⇢ it.aruba.arubacc.jackrabbitoak.config.logger.MDCFilter [DefaultWebFilterChain]\n\t|_ checkpoint ⇢ org.springframework.security.web.server.authorization.AuthorizationWebFilter [DefaultWebFilterChain]\n\t|_ checkpoint ⇢ org.springframework.security.web.server.authorization.ExceptionTranslationWebFilter [DefaultWebFilterChain]\n\t|_ checkpoint ⇢ org.springframework.security.web.server.authentication.logout.LogoutWebFilter [DefaultWebFilterChain]\n\t|_ checkpoint ⇢ org.springframework.security.web.server.savedrequest.ServerRequestCacheWebFilter [DefaultWebFilterChain]\n\t|_ checkpoint ⇢ org.springframework.security.web.server.context.SecurityContextServerWebExchangeWebFilter [DefaultWebFilterChain]\n\t|_ checkpoint ⇢ org.springframework.security.config.web.server.ServerHttpSecurity$OAuth2ResourceServerSpec$BearerTokenAuthenticationWebFilter [DefaultWebFilterChain]\n\t|_ checkpoint ⇢ org.springframework.security.web.server.context.ReactorContextWebFilter [DefaultWebFilterChain]\n\t|_ checkpoint ⇢ org.springframework.security.web.server.header.HttpHeaderWriterWebFilter [DefaultWebFilterChain]\n\t|_ checkpoint ⇢ org.springframework.security.config.web.server.ServerHttpSecurity$ServerWebExchangeReactorContextWebFilter [DefaultWebFilterChain]\n\t|_ checkpoint ⇢ org.springframework.security.web.server.WebFilterChainProxy [DefaultWebFilterChain]\n\t|_ checkpoint ⇢ org.springframework.boot.actuate.metrics.web.reactive.server.MetricsWebFilter [DefaultWebFilterChain]\n\t|_ checkpoint ⇢ HTTP POST \"/dms/v1/documents/find\" [ExceptionHandlingWebHandler]\nStack trace:\n\t\tat org.apache.jackrabbit.oak.jcr.query.QueryManagerImpl.executeQuery(QueryManagerImpl.java:148)\n\t\tat org.apache.jackrabbit.oak.jcr.query.QueryImpl$2.perform(QueryImpl.java:104)\n\t\tat org.apache.jackrabbit.oak.jcr.query.QueryImpl$2.perform(QueryImpl.java:100)\n\t\tat org.apache.jackrabbit.oak.jcr.delegate.SessionDelegate.perform(SessionDelegate.java:209)\n\t\tat org.apache.jackrabbit.oak.jcr.query.QueryImpl.execute(QueryImpl.java:99)\n\t\tat it.aruba.arubacc.jackrabbitoak.repository.DocumentRepository.findDocuments(DocumentRepository.java:458)\n\t\tat it.aruba.arubacc.jackrabbitoak.repository.DocumentRepository$$FastClassBySpringCGLIB$$447bd822.invoke()\n\t\tat org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\n\t\tat org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)\n\t\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\n\t\tat org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)\n\t\tat org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)\n\t\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n\t\tat org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)\n\t\tat org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)\n\t\tat it.aruba.arubacc.jackrabbitoak.repository.DocumentRepository$$EnhancerBySpringCGLIB$$f790e9ff.findDocuments()\n\t\tat it.aruba.arubacc.jackrabbitoak.service.impl.DocumentServiceImpl.findDocuments(DocumentServiceImpl.java:155)\n\t\tat it.aruba.arubacc.jackrabbitoak.web.rest.DocumentController.find(DocumentController.java:331)\n\t\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\t\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\t\tat java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\t\tat java.base/java.lang.reflect.Method.invoke(Method.java:566)\n\t\tat org.springframework.web.reactive.result.method.InvocableHandlerMethod.lambda$invoke$0(InvocableHandlerMethod.java:146)\n\t\tat reactor.core.publisher.MonoFlatMap$FlatMapMain.onNext(MonoFlatMap.java:125)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\t\tat reactor.core.publisher.Operators$MonoSubscriber.complete(Operators.java:1784)\n\t\tat reactor.core.publisher.MonoZip$ZipCoordinator.signal(MonoZip.java:251)\n\t\tat reactor.core.publisher.MonoZip$ZipInner.onNext(MonoZip.java:336)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\t\tat reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.onNext(MonoPeekTerminal.java:180)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\t\tat reactor.core.publisher.FluxDefaultIfEmpty$DefaultIfEmptySubscriber.onNext(FluxDefaultIfEmpty.java:99)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\t\tat reactor.core.publisher.FluxSwitchIfEmpty$SwitchIfEmptySubscriber.onNext(FluxSwitchIfEmpty.java:73)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\t\tat reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onNext(FluxOnErrorResume.java:79)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\t\tat reactor.core.publisher.Operators$MonoSubscriber.complete(Operators.java:1784)\n\t\tat reactor.core.publisher.MonoFlatMap$FlatMapInner.onNext(MonoFlatMap.java:249)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\t\tat reactor.core.publisher.Operators$ScalarSubscription.request(Operators.java:2346)\n\t\tat reactor.core.publisher.MonoFlatMap$FlatMapInner.onSubscribe(MonoFlatMap.java:238)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onSubscribe(MdcContextLifter.java:27)\n\t\tat reactor.core.publisher.MonoJust.subscribe(MonoJust.java:54)\n\t\tat reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64)\n\t\tat reactor.core.publisher.MonoFlatMap$FlatMapMain.onNext(MonoFlatMap.java:157)\n\t\tat reactor.core.publisher.FluxContextWrite$ContextWriteSubscriber.onNext(FluxContextWrite.java:107)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\t\tat reactor.core.publisher.FluxHide$SuppressFuseableSubscriber.onNext(FluxHide.java:136)\n\t\tat reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.onNext(FluxMapFuseable.java:127)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\t\tat reactor.core.publisher.FluxHide$SuppressFuseableSubscriber.onNext(FluxHide.java:136)\n\t\tat reactor.core.publisher.FluxFilterFuseable$FilterFuseableSubscriber.onNext(FluxFilterFuseable.java:118)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\t\tat reactor.core.publisher.FluxHide$SuppressFuseableSubscriber.onNext(FluxHide.java:136)\n\t\tat reactor.core.publisher.Operators$MonoSubscriber.complete(Operators.java:1784)\n\t\tat reactor.core.publisher.MonoCollect$CollectSubscriber.onComplete(MonoCollect.java:159)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onComplete(MdcContextLifter.java:43)\n\t\tat reactor.core.publisher.FluxPeek$PeekSubscriber.onComplete(FluxPeek.java:259)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onComplete(MdcContextLifter.java:43)\n\t\tat reactor.core.publisher.FluxMap$MapSubscriber.onComplete(FluxMap.java:142)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onComplete(MdcContextLifter.java:43)\n\t\tat reactor.core.publisher.FluxPeek$PeekSubscriber.onComplete(FluxPeek.java:259)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onComplete(MdcContextLifter.java:43)\n\t\tat reactor.core.publisher.FluxMap$MapSubscriber.onComplete(FluxMap.java:142)\n\t\tat reactor.netty.channel.FluxReceive.terminateReceiver(FluxReceive.java:450)\n\t\tat reactor.netty.channel.FluxReceive.drainReceiver(FluxReceive.java:256)\n\t\tat reactor.netty.channel.FluxReceive.request(FluxReceive.java:130)\n\t\tat reactor.core.publisher.FluxMap$MapSubscriber.request(FluxMap.java:162)\n\t\tat reactor.core.publisher.FluxPeek$PeekSubscriber.request(FluxPeek.java:137)\n\t\tat reactor.core.publisher.FluxMap$MapSubscriber.request(FluxMap.java:162)\n\t\tat reactor.core.publisher.FluxPeek$PeekSubscriber.request(FluxPeek.java:137)\n\t\tat reactor.core.publisher.MonoCollect$CollectSubscriber.onSubscribe(MonoCollect.java:103)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onSubscribe(MdcContextLifter.java:27)\n\t\tat reactor.core.publisher.FluxPeek$PeekSubscriber.onSubscribe(FluxPeek.java:170)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onSubscribe(MdcContextLifter.java:27)\n\t\tat reactor.core.publisher.FluxMap$MapSubscriber.onSubscribe(FluxMap.java:92)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onSubscribe(MdcContextLifter.java:27)\n\t\tat reactor.core.publisher.FluxPeek$PeekSubscriber.onSubscribe(FluxPeek.java:170)\n\t\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onSubscribe(MdcContextLifter.java:27)\n\t\tat reactor.core.publisher.FluxMap$MapSubscriber.onSubscribe(FluxMap.java:92)\n\t\tat reactor.netty.channel.FluxReceive.startReceiver(FluxReceive.java:168)\n\t\tat reactor.netty.channel.FluxReceive.lambda$subscribe$2(FluxReceive.java:147)\n\t\tat io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:164)\n\t\tat io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:472)\n\t\tat io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:384)\n\t\tat io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989)\n\t\tat io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)\n\t\tat io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)\n\t\tat java.base/java.lang.Thread.run(Thread.java:829)\nCaused by: java.text.ParseException: Query: SELECT * FROM [mix:referenceable] AS ref INNER JOIN [nt:base] AS b ON ISCHILDNODE(b, ref) WHERE b.[jcr:primaryType] IS NOT NULL AND ISDESCENDANTNODE(ref, '')(*)AND (LOWER(ref.[docName]) LIKE '%%') ORDER BY ref.[jcr:created] DESC; expected: absolute path\n\tat org.apache.jackrabbit.oak.query.SQL2Parser.getSyntaxError(SQL2Parser.java:1404)\n\tat org.apache.jackrabbit.oak.query.SQL2Parser.readAbsolutePath(SQL2Parser.java:644)\n\tat org.apache.jackrabbit.oak.query.SQL2Parser.parseConditionFunctionIf(SQL2Parser.java:575)\n\tat org.apache.jackrabbit.oak.query.SQL2Parser.parseCondition(SQL2Parser.java:407)\n\tat org.apache.jackrabbit.oak.query.SQL2Parser.parseAnd(SQL2Parser.java:392)\n\tat org.apache.jackrabbit.oak.query.SQL2Parser.parseConstraint(SQL2Parser.java:382)\n\tat org.apache.jackrabbit.oak.query.SQL2Parser.parseSelect(SQL2Parser.java:238)\n\tat org.apache.jackrabbit.oak.query.SQL2Parser.parse(SQL2Parser.java:158)\n\tat org.apache.jackrabbit.oak.query.QueryEngineImpl.parseQuery(QueryEngineImpl.java:176)\n\tat org.apache.jackrabbit.oak.query.QueryEngineImpl.executeQuery(QueryEngineImpl.java:261)\n\tat org.apache.jackrabbit.oak.jcr.query.QueryManagerImpl.executeQuery(QueryManagerImpl.java:136)\n\tat org.apache.jackrabbit.oak.jcr.query.QueryImpl$2.perform(QueryImpl.java:104)\n\tat org.apache.jackrabbit.oak.jcr.query.QueryImpl$2.perform(QueryImpl.java:100)\n\tat org.apache.jackrabbit.oak.jcr.delegate.SessionDelegate.perform(SessionDelegate.java:209)\n\tat org.apache.jackrabbit.oak.jcr.query.QueryImpl.execute(QueryImpl.java:99)\n\tat it.aruba.arubacc.jackrabbitoak.repository.DocumentRepository.findDocuments(DocumentRepository.java:458)\n\tat it.aruba.arubacc.jackrabbitoak.repository.DocumentRepository$$FastClassBySpringCGLIB$$447bd822.invoke()\n\tat org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\n\tat org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\n\tat org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)\n\tat org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n\tat org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)\n\tat org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)\n\tat it.aruba.arubacc.jackrabbitoak.repository.DocumentRepository$$EnhancerBySpringCGLIB$$f790e9ff.findDocuments()\n\tat it.aruba.arubacc.jackrabbitoak.service.impl.DocumentServiceImpl.findDocuments(DocumentServiceImpl.java:155)\n\tat it.aruba.arubacc.jackrabbitoak.web.rest.DocumentController.find(DocumentController.java:331)\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.base/java.lang.reflect.Method.invoke(Method.java:566)\n\tat org.springframework.web.reactive.result.method.InvocableHandlerMethod.lambda$invoke$0(InvocableHandlerMethod.java:146)\n\tat reactor.core.publisher.MonoFlatMap$FlatMapMain.onNext(MonoFlatMap.java:125)\n\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\tat reactor.core.publisher.Operators$MonoSubscriber.complete(Operators.java:1784)\n\tat reactor.core.publisher.MonoZip$ZipCoordinator.signal(MonoZip.java:251)\n\tat reactor.core.publisher.MonoZip$ZipInner.onNext(MonoZip.java:336)\n\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\tat reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.onNext(MonoPeekTerminal.java:180)\n\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\tat reactor.core.publisher.FluxDefaultIfEmpty$DefaultIfEmptySubscriber.onNext(FluxDefaultIfEmpty.java:99)\n\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\tat reactor.core.publisher.FluxSwitchIfEmpty$SwitchIfEmptySubscriber.onNext(FluxSwitchIfEmpty.java:73)\n\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\tat reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onNext(FluxOnErrorResume.java:79)\n\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\tat reactor.core.publisher.Operators$MonoSubscriber.complete(Operators.java:1784)\n\tat reactor.core.publisher.MonoFlatMap$FlatMapInner2021-05-26T07:54:30.286360604Z .onNext(MonoFlatMap.java:249)\n\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onNext(MdcContextLifter.java:33)\n\tat reactor.core.publisher.Operators$ScalarSubscription.request(Operators.java:2346)\n\tat reactor.core.publisher.MonoFlatMap$FlatMapInner.onSubscribe(MonoFlatMap.java:238)\n\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onSubscribe(MdcContextLifter.java:27)\n\tat reactor.core.publisher.MonoJust.subscribe(MonoJust.java:54)\n\tat reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64)\n\tat reactor.core.publisher.MonoFlatMap$FlatMapMain.onNext(MonoFlatMap.java:157)\n\tat reactor.core.publisher.FluxContextWrite$ContextWriteSubscriber.onNext(FluxContextWrite.java:107)\n\tat it.aruba.arubacc.jackrabbitoak.config.logger.hooks.MdcContextLifter.onN…" }, "@timestamp":"2021-05-26T07:54:30.276Z", "lineNumber":122, "class":"org.springframework.core.log.CompositeLog", "@version":1, "@application":"arubacc-jackrabbitoak", "sourceHost":"cc-jackrabbit-oak-deployment-7b75567c9f-4gbbt", "message":"[67d4475f-54] 500 Server Error for HTTP POST \"/v1/documents/find\"", "threadName":"reactor-http-epoll-2", "level":"ERROR", "file":"CompositeLog.java", "method":"error", "loggerName":"org.springframework.boot.autoconfigure.web.reactive.error.AbstractErrorWebExceptionHandler" }