Workflow Scheme NULL ptr exception

[arikevin]

When I try to access the workflow scheme for a project I get:

The log has:

2019-11-22 10:07:46,292 https-jsse-nio-2603:3026:100:13e1:0:0:100:1-443-exec-25 ERROR kevin 607x254x1 zninvo 2603:3026:100:13e0:104e:56e5:3ccb:23ae /plugins/servlet/project-config/ASWCLIENTS/workflows [c.s.p.w.domain.scope.StructureScopeElementConnectors] Token: c9fe3e98973a16dc9ffe6ba52166d5ee.e320691b83ccf10467d906e4a13719be.Fri Nov 22 10:07:46 MST 2019, [TC:9d8be662] Could not find ExtTaskQueryElementTypeConnector by key: JIRA_AGILE_BOARD

2019-11-22 10:07:46,293 https-jsse-nio-2603:3026:100:13e1:0:0:100:1-443-exec-25 ERROR kevin 607x254x1 zninvo 2603:3026:100:13e0:104e:56e5:3ccb:23ae /plugins/servlet/project-config/ASWCLIENTS/workflows [c.s.p.w.domain.scope.StructureScopeElementConnectors] Token: c9fe3e98973a16dc9ffe6ba52166d5ee.e320691b83ccf10467d906e4a13719be.Fri Nov 22 10:07:46 MST 2019, [TC:9d8be662] Could not find ExtTaskQueryElementTypeConnector by key: JIRA_AGILE_BOARD

2019-11-22 10:07:46,295 https-jsse-nio-2603:3026:100:13e1:0:0:100:1-443-exec-25 ERROR kevin 607x254x1 zninvo 2603:3026:100:13e0:104e:56e5:3ccb:23ae /plugins/servlet/project-config/ASWCLIENTS/workflows [c.s.p.w.domain.scope.StructureScopeElementConnectors] Token: c9fe3e98973a16dc9ffe6ba52166d5ee.e320691b83ccf10467d906e4a13719be.Fri Nov 22 10:07:46 MST 2019, [TC:0045c6aa] Could not find ExtTaskQueryElementTypeConnector by key: JIRA_AGILE_BOARD

2019-11-22 10:07:46,296 https-jsse-nio-2603:3026:100:13e1:0:0:100:1-443-exec-25 ERROR kevin 607x254x1 zninvo 2603:3026:100:13e0:104e:56e5:3ccb:23ae /plugins/servlet/project-config/ASWCLIENTS/workflows [c.s.p.w.domain.scope.StructureScopeElementConnectors] Token: c9fe3e98973a16dc9ffe6ba52166d5ee.e320691b83ccf10467d906e4a13719be.Fri Nov 22 10:07:46 MST 2019, [TC:0045c6aa] Could not find ExtTaskQueryElementTypeConnector by key: JIRA_AGILE_BOARD

2019-11-22 10:07:47,502 https-jsse-nio-2603:3026:100:13e1:0:0:100:1-443-exec-9 ERROR kevin 607x260x1 zninvo 2603:3026:100:13e0:104e:56e5:3ccb:23ae /rest/projectconfig/latest/workflowscheme/ASWCLIENTS [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: null

java.lang.NullPointerException

at java.util.ComparableTimSort.binarySort(ComparableTimSort.java:262)

at java.util.ComparableTimSort.sort(ComparableTimSort.java:207)

at java.util.Arrays.sort(Arrays.java:1312)

at java.util.Arrays.sort(Arrays.java:1506)

at java.util.ArrayList.sort(ArrayList.java:1462)

at java.util.Collections.sort(Collections.java:141)

at com.atlassian.jira.workflow.OSWorkflowManager.getWorkflows(OSWorkflowManager.java:127)

... 3 filtered

at java.lang.reflect.Method.invoke(Method.java:498)

at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)

at com.sun.proxy.$Proxy97.getWorkflows(Unknown Source)

... 3 filtered

at java.lang.reflect.Method.invoke(Method.java:498)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)

at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)

at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)

at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)

at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)

at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)

at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)

at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)

at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)

at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)

at com.sun.proxy.$Proxy2273.getWorkflows(Unknown Source)

at com.atlassian.jira.projectconfig.rest.WorkflowSchemeRestHelper$ResponseDataBuilder.build(WorkflowSchemeRestHelper.java:171)

at com.atlassian.jira.projectconfig.rest.project.WorkflowSchemeResource.generateSchemeData(WorkflowSchemeResource.java:153)

at com.atlassian.jira.projectconfig.rest.project.WorkflowSchemeResource.getWorkflowSchemeInfo(WorkflowSchemeResource.java:78)

... 3 filtered

at java.lang.reflect.Method.invoke(Method.java:498)

... 19 filtered

at com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter(RestDelegatingServletFilter.java:159)

... 1 filtered

at com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter(RestDelegatingServletFilter.java:69)

... 36 filtered

at com.atlassian.jira.plugin.mobile.web.filter.MobileAppRequestFilter.doFilter(MobileAppRequestFilter.java:37)

... 4 filtered

at com.atlassian.jira.plugin.mobile.login.MobileLoginSuccessFilter.doFilter(MobileLoginSuccessFilter.java:54)

... 3 filtered

at com.atlassian.diagnostics.internal.platform.monitor.http.HttpRequestMonitoringFilter.doFilter(HttpRequestMonitoringFilter.java:55)

... 8 filtered

at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)

... 57 filtered

at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)

... 1 filtered

at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)

... 16 filtered

at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter(RestSeraphFilter.java:37)

... 19 filtered

at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)

... 5 filtered

at com.idalko.jira.plugins.igrid.servicedesk.ServletRequestContextFilter.doFilter(ServletRequestContextFilter.java:23)

... 8 filtered

at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)

... 4 filtered

at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)

... 26 filtered

at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)

... 24 filtered

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:748)

2019-11-22 10:08:29

[Petter Gonçalves]

Hello @arikevin

Sorry to hear you are facing this problem.

Checking the logs you provided and the error message that appears to you when you try to access the workflow scheme page, I believe the error is being caused by an existing workflow draft with a null name in your Jira instance just like mentioned in the documentation below:

- NullPointerException while viewing workflow scheme with draft 

Please, try the following steps to confirm if this is the problem and fix it:

Diagnostic Steps

In the database, you'll see a draft Workflow Scheme, with no name or description:

jira=# select * from draftworkflowscheme;
  id   | name | description | workflow_scheme_id |     last_modified_date     | last_modified_user
-------+------+-------------+--------------------+----------------------------+--------------------
 10700 |      |             |              12201 | 2015-09-14 13:06:28.772+02 | admin
(1 row)

And in the entity table:

jira=# select * from draftworkflowschemeentity;
  id   | scheme |                   workflow                   | issuetype
-------+--------+----------------------------------------------+-----------
 10700 |  10700 | Agile Simplified Workflow for Project PROJ | 0
 10701 |  10700 | Agile Simplified Workflow for Project PROJ | 1
 10702 |  10700 | Agile Simplified Workflow for Project PROJ | 2
 10703 |  10700 | Agile Simplified Workflow for Project PROJ | 3
(5 rows)

Resolution

P.S: Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

1. Delete any drafts with a NULL value in the name column by running the following SQL commands against JIRA's database:
   

   delete from draftworkflowschemeentity where scheme IN (select id from draftworkflowscheme where name is NULL);
   delete from draftworkflowscheme where name is NULL;

2. Restart JIRA.

Let me know if the steps above worked for you.