AnsweredAssumed Answered

Issue while querying with search SQL REST API in REST API explorer in ACS 6.1 with Insight Engine

Question asked by rohit9637 on Jan 3, 2019

I have installed the latest ACS 6.1.0 and upgraded the search service to Alfresco Search & Insight Engine.

I can find the search SQL API section in rest-api explorer. But while Querying simple SQL query mentioned in the description it returns 404 error

                        

 

 

I have verified the solr is running and Alfresco Search & Insight Engine is installed.

 

 

Following is the error log I get on hitting the API from rest-api explorer

2019-01-03 13:43:19,334 ERROR [extensions.webscripts.AbstractRuntime] [http-nio-8080-exec-7] Exception from executeScript: 00030000 {0} was not found
alfresco_1 | org.alfresco.rest.framework.core.exceptions.NotFoundException: 00030000 {0} was not found
alfresco_1 | at org.alfresco.rest.framework.core.ResourceLookupDictionary.locateRelationResource(ResourceLookupDictionary.java:95)
alfresco_1 | at org.alfresco.rest.framework.core.ResourceLookupDictionary.locateEntityResource(ResourceLookupDictionary.java:57)
alfresco_1 | at org.alfresco.rest.framework.core.ResourceLookupDictionary.locateResource(ResourceLookupDictionary.java:148)
alfresco_1 | at org.alfresco.rest.api.PublicApiDeclarativeRegistry.getResourceWithMetadataOrNull(PublicApiDeclarativeRegistry.java:263)
alfresco_1 | at org.alfresco.rest.api.PublicApiDeclarativeRegistry.findWebScript(PublicApiDeclarativeRegistry.java:197)
alfresco_1 | at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:165)
alfresco_1 | at org.alfresco.repo.web.scripts.TenantWebScriptServlet.service(TenantWebScriptServlet.java:82)
alfresco_1 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
alfresco_1 | at jdk.internal.reflect.GeneratedMethodAccessor650.invoke(Unknown Source)
alfresco_1 | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
alfresco_1 | at java.base/java.lang.reflect.Method.invoke(Method.java:566)
alfresco_1 | at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)
alfresco_1 | at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)
alfresco_1 | at java.base/java.security.AccessController.doPrivileged(Native Method)
alfresco_1 | at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)
alfresco_1 | at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)
alfresco_1 | at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:170)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:225)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:47)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:149)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)
alfresco_1 | at java.base/java.security.AccessController.doPrivileged(Native Method)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
alfresco_1 | at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
alfresco_1 | at jdk.internal.reflect.GeneratedMethodAccessor647.invoke(Unknown Source)
alfresco_1 | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
alfresco_1 | at java.base/java.lang.reflect.Method.invoke(Method.java:566)
alfresco_1 | at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)
alfresco_1 | at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)
alfresco_1 | at java.base/java.security.AccessController.doPrivileged(Native Method)
alfresco_1 | at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)
alfresco_1 | at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)
alfresco_1 | at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:47)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:149)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)
alfresco_1 | at java.base/java.security.AccessController.doPrivileged(Native Method)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
alfresco_1 | at org.alfresco.module.aosmodule.service.ContextRootFilter.doFilter(ContextRootFilter.java:93)
alfresco_1 | at jdk.internal.reflect.GeneratedMethodAccessor647.invoke(Unknown Source)
alfresco_1 | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
alfresco_1 | at java.base/java.lang.reflect.Method.invoke(Method.java:566)
alfresco_1 | at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)
alfresco_1 | at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)
alfresco_1 | at java.base/java.security.AccessController.doPrivileged(Native Method)
alfresco_1 | at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)
alfresco_1 | at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)
alfresco_1 | at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:47)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:149)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)
alfresco_1 | at java.base/java.security.AccessController.doPrivileged(Native Method)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
alfresco_1 | at org.alfresco.web.app.servlet.ServletMetricsFilter.doFilter(ServletMetricsFilter.java:178)
alfresco_1 | at org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:89)
alfresco_1 | at jdk.internal.reflect.GeneratedMethodAccessor647.invoke(Unknown Source)
alfresco_1 | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
alfresco_1 | at java.base/java.lang.reflect.Method.invoke(Method.java:566)
alfresco_1 | at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)
alfresco_1 | at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)
alfresco_1 | at java.base/java.security.AccessController.doPrivileged(Native Method)
alfresco_1 | at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)
alfresco_1 | at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)
alfresco_1 | at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:47)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:149)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)
alfresco_1 | at java.base/java.security.AccessController.doPrivileged(Native Method)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
alfresco_1 | at org.alfresco.repo.web.filter.beans.NullFilter.doFilter(NullFilter.java:75)
alfresco_1 | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
alfresco_1 | at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
alfresco_1 | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
alfresco_1 | at java.base/java.lang.reflect.Method.invoke(Method.java:566)
alfresco_1 | at org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(ChainingSubsystemProxyFactory.java:132)
alfresco_1 | at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
alfresco_1 | at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
alfresco_1 | at com.sun.proxy.$Proxy190.doFilter(Unknown Source)
alfresco_1 | at org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:89)
alfresco_1 | at jdk.internal.reflect.GeneratedMethodAccessor647.invoke(Unknown Source)
alfresco_1 | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
alfresco_1 | at java.base/java.lang.reflect.Method.invoke(Method.java:566)
alfresco_1 | at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)
alfresco_1 | at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)
alfresco_1 | at java.base/java.security.AccessController.doPrivileged(Native Method)
alfresco_1 | at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)
alfresco_1 | at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)
alfresco_1 | at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:47)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:149)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)
alfresco_1 | at java.base/java.security.AccessController.doPrivileged(Native Method)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
alfresco_1 | at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:53)
alfresco_1 | at jdk.internal.reflect.GeneratedMethodAccessor647.invoke(Unknown Source)
alfresco_1 | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
alfresco_1 | at java.base/java.lang.reflect.Method.invoke(Method.java:566)
alfresco_1 | at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)
alfresco_1 | at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)
alfresco_1 | at java.base/java.security.AccessController.doPrivileged(Native Method)
alfresco_1 | at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)
alfresco_1 | at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)
alfresco_1 | at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:47)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:149)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)
alfresco_1 | at java.base/java.security.AccessController.doPrivileged(Native Method)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
alfresco_1 | at org.alfresco.web.app.servlet.ClearSecurityContextFilter.doFilter(ClearSecurityContextFilter.java:53)
alfresco_1 | at jdk.internal.reflect.GeneratedMethodAccessor647.invoke(Unknown Source)
alfresco_1 | at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
alfresco_1 | at java.base/java.lang.reflect.Method.invoke(Method.java:566)
alfresco_1 | at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:282)
alfresco_1 | at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:279)
alfresco_1 | at java.base/java.security.AccessController.doPrivileged(Native Method)
alfresco_1 | at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)
alfresco_1 | at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:314)
alfresco_1 | at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:47)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:149)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:145)
alfresco_1 | at java.base/java.security.AccessController.doPrivileged(Native Method)
alfresco_1 | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
alfresco_1 | at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
alfresco_1 | at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
alfresco_1 | at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
alfresco_1 | at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
alfresco_1 | at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
alfresco_1 | at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
alfresco_1 | at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
alfresco_1 | at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
alfresco_1 | at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
alfresco_1 | at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
alfresco_1 | at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
alfresco_1 | at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
alfresco_1 | at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
alfresco_1 | at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
alfresco_1 | at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
alfresco_1 | at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
alfresco_1 | at java.base/java.lang.Thread.run(Thread.java:834)

Outcomes