Error to create subtask

José Antonio Carrasco November 8, 2017

SEN-10634762

 

Saltó una excepción: com.atlassian.plugins.rest.common.json.JsonMarshallingException: org.codehaus.jackson.map.JsonMappingException: Caught SQLServerException for select ACTION.id, ACTION.issueid, ACTION.author, ACTION.actiontype, ACTION.actionlevel, ACTION.rolelevel, ACTION.actionbody, ACTION.created, ACTION.updateauthor, ACTION.updated, ACTION.actionnum from dbo.jiraaction ACTION where ACTION.issueid = ? and ACTION.actiontype = ? order by ACTION.created asc, ACTION.id asc offset ? rows fetch next ? rows only (through reference chain: com.atlassian.jira.quickedit.rest.api.field.QuickEditFields["createdIssueDetails"]->com.atlassian.jira.rest.v2.issue.IssueBean["fields"]->java.util.HashMap["comment"])

1 answer

1 accepted

1 vote
Answer accepted
Benito Picarelli
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 8, 2017

Might be a bit of guessing but similar issues were noticed when customers use versions 7.5 of JIRA with SQL Server 2008. Can you confirm if this is the case on your environment configuration?

José Antonio Carrasco November 8, 2017

Yes. I use SqlServer 2008R2

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 8, 2017

Ouch.  You need to move to MS SQL Server 2012 at least.  2008 simply doesn't work with Jira 7.2 upwards.

José Antonio Carrasco November 8, 2017

Ok. Thanks.

José Antonio Carrasco November 8, 2017

Jira 7.5 work with SqlServer 2012 Express Edition?

Ash
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 8, 2017
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 8, 2017

I can confirm that they're not only unsupported, they also fail.

Suggest an answer

Log in or Sign up to answer