Uploaded image for project: 'Elements Connect'
  1. Elements Connect
  2. CO-3615

Field broken after upgrade V5 to V6 if cache is active + empty query

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: 6.0.1, 6.0.5, 6.0.6, 6.0.7
    • Fix Version/s: 6.0.9
    • Labels:
      None
    • Functional components:
      Cache
      Runtime - Field Edition

      Description

      How to reproduce:

      • Install Connect 5.13.x, 
      • configure a connect field
        • query empty (important)
        • with root element and json columns
        • activate cache
      • Upgrade to V6.
      • Edit the field value.

      Current:
      The field doesn't work, an error in the logs occurs:

      2019-08-14 00:17:03,778 http-nio-8080-exec-25 ERROR basile.g 17x200x1 k6crve 45.15.78.66 /rest/nfeed/3.0/nFeed/field/input/options [c.v.j.p.s.f.rest.v3.RuntimeFieldService] Error while building input options
      java.lang.NullPointerException
              at com.valiantys.jira.plugins.sql.service.request.execution.datasource.cache.DatasourceWithCacheDecorator.appendCacheKeyPropertyValue(DatasourceWithCacheDecorator.java:141)
              at com.valiantys.jira.plugins.sql.service.request.execution.datasource.cache.DatasourceWithCacheDecorator.getCacheKey(DatasourceWithCacheDecorator.java:131)
              at com.valiantys.jira.plugins.sql.service.request.execution.datasource.cache.DatasourceWithCacheDecorator.getRawDatasourceResult(DatasourceWithCacheDecorator.java:68)
              at com.valiantys.jira.plugins.sql.service.request.execution.datasource.DatasourceRequestExecutor.executeDatasourceRequest(DatasourceRequestExecutor.java:45)
              at com.valiantys.jira.plugins.sql.service.request.execution.resultset.DatasourceResultSetFactory.create(DatasourceResultSetFactory.java:32)
              at com.valiantys.jira.plugins.sql.service.request.execution.RequestExecutionService.getInputResultSet(RequestExecutionService.java:45)
              at com.valiantys.jira.plugins.sql.service.request.execution.RequestExecutionService.getResultSet(RequestExecutionService.java:33)
              at com.valiantys.jira.plugins.sql.service.rendering.ResultSetRenderingService.consumeResultSet(ResultSetRenderingService.java:38)
              at com.valiantys.jira.plugins.sql.fieldruntime.rest.v3.RuntimeFieldService.getInputOptions(RuntimeFieldService.java:259)
              ... 3 filtered
      

      Expected:
      The field is updated

      Workaround:
      Edit your configuration and add a comment in the query of your field like:

      ##empty query - this line is only a comment
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              basile.grandperret@valiantys.com Basile Grandperret
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: