500 error when viewing status list

Sara Shoemaker

I get the following Exception when I attempt to view the status list

 

com.google.template.soy.tofu.SoyTofuException: In template JIRA.Templates.Statuses.success: In 'foreach' command {foreach $status in $statuses}{call .statusRow}{param status: $status /}{/call}{/foreach}, the data reference does not resolve to a SoyListData.

 

I already followed the steps to check for orphaned Workflows and Schemes and the queries didn't find anything.

I would appreciate any help

-Sara

somethingblue

Hi Sara,

In order to diagnose this further can I have the output of the commands from:

<span>select</span> <span>*</span> <span>from</span> nodeassociation <span>where</span> SOURCE_NODE_ENTITY<span>=</span><span>'Project'</span> <span>AND</span> SOURCE_NODE_ID <span>not</span> <span>in</span> <span>(</span><span>select</span> ID <span>from</span> project<span>)</span><span>;</span>

<span>select</span> <span>*</span> <span>from</span> nodeassociation <span>where</span> SOURCE_NODE_ENTITY<span>=</span><span>'Project'</span> <span>AND</span> SOURCE_NODE_ID <span>not</span> <span>in</span> <span>(</span><span>select</span> ID <span>from</span> project<span>)</span><span>;</span>

SELECT count(*), parentname FROM jiradraftworkflows group by parentname having count(*) > 1;

SELECT count(*), workflowname FROM jiraworkflows group by workflowname having count(*) > 1;

In addition, do you see anything in your logs near these lines similar to the following:

Caused by: com.atlassian.cache.CacheException: java.lang.IllegalStateException: There are more than one draft workflows associated with the workflow named '<workflow name>'

Let me know.

Cheers,

Branden