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

Cannot generate standard analytic/report when configured to use ES REST

    Details

    • Bug Priority:
      Category 2
    • ACT Numbers:

      00983503

      Description

      Issues

      There seems to be no way to generate standard Alfresco Report via Alfresco Analytic app from within /activiti-app UI if one configure APS 1.9.0.3 to use ElasticSearch server type : rest 

      Steps to reproduce

      1. Install ES 5.5.3, have it run locally. Double check http://localhost:9200 that the ES is running now: 

      "name" : "XwcH4Fs""cluster_name" : "elasticsearch""cluster_uuid" : "6HXdY1zfSAqgyWJksRxtfQ""version" : { 
      "number" : "5.5.3""build_hash" : "9305a5e""build_date" : "2017-09-07T15:56:59.599Z""build_snapshot" : false"lucene_version" : "6.6.0" 
      }, 
      "tagline" : "You Know, for Search" 
      } 
      
      

      2. Install APS 1.9.0.3 locally using mac installer. Modify /tomcat/lib/activiti-app.properties to configure with ES rest , as below: 

      elastic-search.enable.http=true 
      
      elastic-search.server.type=rest 
      elastic-search.rest-client.port=9200 
      elastic-search.rest-client.connect-timeout=10000000 
      elastic-search.rest-client.socket-timeout=10000000 
      elastic-search.rest-client.address=127.0.0.1 
      elastic-search.cluster.name=elasticsearch 
      elastic-search.node.name=XwcH4Fs 
      elastic-search.default.index.name=activiti 
      elastic-search.tenant.index.prefix=activiti_tenant 
      
      #Alfresco Report (defaults)
      event.generation.enabled=true 
      event.processing.enabled=true 
      event.processing.blocksize=100 
      event.processing.cronExpression=0/5 * * * * ? 
      event.processing.expired.cronExpression=0 0/30 * * * ? 
      event.processing.max.locktime=600000 
      event.processing.processed.events.action=move 
      event.processing.processed.action.cronExpression=0 25/45 * * * ? 

      3. Start APS 1.9.0.3, login to /activiti-app as default admin@app.activiti.com user (with analytic users capability), create new process/app and published app in /activiti-app, and start couple test app process instances/tasks (active, completed). 

      4. Run REST API call and confirmed ES indexes are created properly in ES 5.5.3. 

      GET http://localhost:9200/activiti_tenant1/process-instances/_search 
      
      Response: 
      { 
      "took": 4, 
      "timed_out": false"_shards": { 
      "total": 5, 
      "successful": 5, 
      "failed": 0 
      }, 
      "hits": { 
      "total": 5, 
      "max_score": 1, 
      "hits": [ 
      { 
      "_index": "activiti_tenant1""_type": "process-instances""_id": "2501""_score": 1, 
      "_source": { 
      "duration": 5907, 
      "timeStamp": 1547657451050, 
      "processDefinitionId": "testapp:1:4""createTime": 1547657445143, 
      "name": "testapp - January 16th 2019""tenantId": "tenant_1""id": "2501""endTime": 1547657451050, 
      "userId": "1""processDefinitionKey": "testapp" 
      } 
      }, 
      { 
      "_index": "activiti_tenant1""_type": "process-instances""_id": "2511""_score": 1, 
      "_source": { 
      "duration": 6536, 
      "timeStamp": 1547657557541, 
      "processDefinitionId": "testapp:1:4""createTime": 1547657551005, 
      "name": "testapp - January 16th 2019""tenantId": "tenant_1""id": "2511""endTime": 1547657557541, 
      "userId": "1""processDefinitionKey": "testapp" 
      } 
      }, 
      ...

       

      5. Now, try to generate standard report 'Process Instance' from app/report.

      Actual: While I can select and filled in all form fields value, no report is generated and it displayed> "No report data found. Fill in the parameters to generate your report" 

      Expected: Report is generate properly without issue. 

      6. Next, try to generate same standard report from analytic/report UI,

      Actual: From this UI, I have no way to select any value from 'Process Definition' drop down because no value is listed. Again same message displayed > "No report data found. Fill in the parameters to generate your report" 

      Expected: 'Process Definition' drop down has value, and report is generate properly without issue. 

      See attached screenshots zip from my APS 1.9.0.3+locally run ES 5.5.3 testing + elastic-search.server.type=rest testing. 

        Attachments

          Structure

            Activity

              People

              • Assignee:
                cdenton Claire Denton
                Reporter:
                sliaw Seng Liaw
              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Structure Helper Panel