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

topic Issue while querying with search SQL REST API in REST API explorer in ACS 6.1 with Insight Engine in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/issue-while-querying-with-search-sql-rest-api-in-rest-api/m-p/67993#M22630 <HTML><HEAD></HEAD><BODY>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                        <IMG class="image-3 jive-image" src="https://connect.hyland.com/legacyfs/online/alfresco/24741_pastedImage_5.png" /><IMG class="jive-image image-4" src="https://connect.hyland.com/legacyfs/online/alfresco/24743_pastedImage_6.png" />I have verified the solr is running and Alfresco Search & Insight Engine is installed.<IMG class="image-2 jive-image" src="https://connect.hyland.com/legacyfs/online/alfresco/24739_pastedImage_2.png" />Following is the error log I get on hitting the API from rest-api explorer<BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro">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)</BLOCKQUOTE></BODY></HTML> Thu, 03 Jan 2019 13:56:45 GMT rohit9637 2019-01-03T13:56:45Z Issue while querying with search SQL REST API in REST API explorer in ACS 6.1 with Insight Engine https://connect.hyland.com/t5/alfresco-forum/issue-while-querying-with-search-sql-rest-api-in-rest-api/m-p/67993#M22630 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 s Thu, 03 Jan 2019 13:56:45 GMT https://connect.hyland.com/t5/alfresco-forum/issue-while-querying-with-search-sql-rest-api-in-rest-api/m-p/67993#M22630 rohit9637 2019-01-03T13:56:45Z