Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-15076

In a Clustered Environment, A Null Progress ID in the AO_8542F1_IFJ_PRG_IN_PRG table will Prevent Assets from Loading

      Issue Summary

      For unknown reasons, if a clustered environment has a null progress id on the AO_8542F1_IFJ_PRG_IN_PRG table, then users will not be able to use Assets Management on one of the nodes.

      This seems to impact multi-node, or clustered, environments only.

      Steps to Reproduce

      unknown at this time

      Expected Results

      The null record should not prevent the Assets Management feature from being inaccessible to Users

      Actual Results

      When this record is in place, then one of the nodes in the cluster cannot access the Assets Index and therefore users are not able to access Assets Management from that node.

      The below exception is thrown in the atlassian-jira.log file:

      Caesium-1-1 ERROR     [i.r.a.s.service.freetext.FreeTextIndexingServiceJiraImpl] Fail re-indexing - ProgressId: resourceId: freetext, category: freetext-reindex!
      java.lang.NullPointerException
              at com.riadalabs.jira.plugins.insight.services.core.dal.impl.ProgressDalImpl.persistProgressInProgress(ProgressDalImpl.java:159)
              at io.riada.insight.index.model.ProgressIndexImpl.persistProgress(ProgressIndexImpl.java:429) 

      and we also see a NullPointerException like this:

      /rest/insight/1.0/global/config/object; /rest/insight/1.0/global/config/object [c.r.j.p.i.c.w.a.r.exception.mapper.DefaultMapper] Unexpected exception was thrown while processing the request
      java.lang.NullPointerException
              at com.riadalabs.jira.plugins.insight.services.progress.model.ProgressId.newInstanceFromCacheKey(ProgressId.java:74)
              at com.riadalabs.jira.plugins.insight.services.core.dal.impl.ProgressDalImpl.assembleProgressInProgress(ProgressDalImpl.java:366)
              at com.riadalabs.jira.plugins.insight.services.core.dal.impl.ProgressDalImpl.findAllProgressInProgress(ProgressDalImpl.java:146)
              at io.riada.insight.index.model.ProgressIndexImpl.getKeys(ProgressIndexImpl.java:363)
              at io.riada.insight.index.model.ProgressIndexImpl.getProgressIdsInProgressByCategoryAndStatus(ProgressIndexImpl.java:326)
              at io.riada.insight.index.model.ProgressIndexImpl.getAllInProgressByCategory(ProgressIndexImpl.java:114)
              at com.riadalabs.jira.plugins.insight.services.progress.ProgressServiceBase.findAllInProgressProgressCategories(ProgressServiceBase.java:446)
              at com.riadalabs.jira.plugins.insight.channel.web.api.configuration.GlobalConfigurationServiceInJira.appendSpecificConfig(GlobalConfigurationServiceInJira.java:54)
              at io.riada.insight.services.GlobalConfigurationServiceImpl.getInsightGlobalConfigModel(GlobalConfigurationServiceImpl.java:123)
              at com.riadalabs.jira.plugins.insight.channel.web.api.rest.services.globalconfiguration.GlobalConfigurationResource.getConfigForObjectSchema(GlobalConfigurationResource.java:101) 

      Workaround

      Delete the null entry from the AO_8542F1_IFJ_PRG_IN_PRG table

      DELETE  from "AO_8542F1_IFJ_PRG_IN_PRG" where "PROGRESS_ID" is null; 

            [JSDSERVER-15076] In a Clustered Environment, A Null Progress ID in the AO_8542F1_IFJ_PRG_IN_PRG table will Prevent Assets from Loading

              c8bcca445054 Benjamin Suess
              6a1ad6d343e3 Patrick Turbett
              Affected customers:
              0 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: