-
Type:
Service Pack Request
-
Status: Closed
-
Resolution: Cannot Reproduce
-
Affects Version/s: 6.1
-
Fix Version/s: None
-
Component/s: ACS REST API
-
Labels:None
-
Environment:PostgreSQL 10.1, Alfresco version: 6.1.0 (RC3 rd2dc2f75-b18)
-
Bug Priority:
-
ACT Numbers:
00983848
Using ACS 6.1 with Alfresco Search & Insight Engine
Issue while querying with search SQL REST API in REST API explorer in ACS 6.1 with Insight Engine results in a error 404 framework.exception.notfound
In the Alfresco.log we see
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
The problem is the REST API Explorer in SQL API section points to the wrong Endpoint.
Endpoint directed on REST API Explorer in SQL API section is: http://localhost:8080/alfresco/api/-default-/public/search/versions/1/sql/sql
The correct Endpoint should be http://localhost:8080/alfresco/api/-default-/public/search/versions/1/sql
Steps to reproduce
Setup:
ACS using Docker
Steps:
1. Navigate to: http://localhost:8080/api-explorer/#!/sql
2. Specify the query body:
{ "stmt": "select * from alfresco" }
3.
Error:
404 response is returned as the request url is incorrect.
Request url appears to be:
http://localhost:8080/alfresco/api/-default-/public/search/versions/1/sql/sql it should be:
http://localhost:8080/alfresco/api/-default-/public/search/versions/1/sql
Expected behaviour
Search results should be displayed
Actual behaviour
Results in an error 404 framework.exception.notfound