Error creating new Service Desk issue

Paul Stephens July 28, 2017

We get the following SQL message back when trying to create an issue.

The issue still appears to save correctly. 

Exception occurred: com.atlassian.plugins.rest.common.json.JsonMarshallingException: org.codehaus.jackson.map.JsonMappingException: Caught SQLException 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"])

2 answers

1 accepted

0 votes
Answer accepted
Paul Stephens July 29, 2017

Jira 7.4 is only supported on MS SQL 2012 & 2014. We need to migrate the data

0 votes
somethingblue
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 28, 2017

Hi Paul,

I see you put in a ticket with Support for this issue.  Once they wrap things up on that end please update this ticket with the resolution so the whole community can benefit from the answer!

Cheers,

Branden

Suggest an answer

Log in or Sign up to answer