Error Message when Creating Case

[Ng Wee Jin]

there is an error message that is shown when creating cases

Exception occurred: 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"])

Please assist to check and let us know what went wrong in our setup

[Danyal Iqbal]

Which Database && Jira (version) are you using? It seems that your database version is not supported. Upgrade the database.

Execute the SQL statement directly against the database and analyse what it returns.

You need to see the log for a more details.

[Ng Wee Jin]

we are using SQL Server 2008 R2, with JIRA Service Desk 3.12.1 
together with Jira Core 7.9.1 

what is the SQL query that should be run? im not sure as it is the creation of a new case

[Danyal Iqbal]

you need to migrate to a newer DB version. Check the supported platform page for your version. I belive SQLS 2008 is not supported anymore.

[Nic Brough -Adaptavist-]

Support for MS-SQL 2008 was dropped around Jira 7.3. 

You need to move to a supported version immediately.