Exception occurred when create an issue

[Zhanjie He]

when I click 'create', Exception occurred: ------------------error message------------------ 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"])

------------------error message------------------ detail information: 1) jira core verson: 7.13.1 2) db,ms sql server 2008 sp2 - server collation: SQL_Latin1_General_CP1_CI_AS - db collation: Latin1_General_CI_AI

[Petter Gonçalves]

Hello Zhanjie,

Welcome to Atlassian Community!

Analyzing the error returned and other users facing the same problem, it seems that your SQL Server is not supported in your JIRA version.

Could you please provide us the version of your SQL Server?

For any JIRA versions after 7.2, SQL Server 2008 or 2008R2 are not supported anymore as you can see in the following announcement:

- End of support announcements

If this is the scenario you are facing, please upgrade your SQL Server to a supported version (preferably, SQL Server 2016).

Let us know if this information helps. Have a nice Tuesday!