Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-20294

The REST API Explorer in SQL API section points to the wrong Endpoint

    Details

    • 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:
      Category 3
    • ACT Numbers:

      00983848

      Description

      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

       

        Attachments

          Structure

            Activity

              People

              • Assignee:
                closedissues Closed Issues
                Reporter:
                twilliams Terry Williams [X] (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Structure Helper Panel